(Optimum) Outstanding Invoice still show in knock off screen after matched

Created by Cheng Kah Poh, Modified on Wed, 11 Nov, 2020 at 9:20 AM by Cheng Kah Poh

SCENARIO:

Example: OR1603/080 matched with INV1603/011

1.       Go to Debtor > Receive Payment > search out OR1603/080 and verify that full matched with INV1603/011.

2.       Click New Receive Payment

3.       Select Debtor 3000/D26

4.       INV1603/011 still showing outstanding amount


ROOT CAUSE:

ARMatched table column GLAccountId is null, to fix: 


Please execute below Script:


UPDATE M SET M.GLAccountId = JD.GLAccountId FROM dbo.ARMatched M JOIN dbo.JournalDetails JD ON JD.Id = M.PayForId WHERE M.GLAccountId Is Null
UPDATE M SET M.GLAccountId = D.GLAccountId FROM dbo.ARMatched M JOIN dbo.Invoices INV ON INV.Id = M.PayForId JOIN dbo.Debtors D ON D.Id = INV.DebtorId WHERE M.GLAccountId Is Null
UPDATE M SET M.GLAccountId = D.GLAccountId FROM dbo.ARMatched M JOIN dbo.ARDN DN ON DN.Id = M.PayForId JOIN dbo.Debtors D ON D.Id = DN.DebtorId WHERE M.GLAccountId Is Null



Please refer How to Connect to Database use Microsoft SQL Server Management Studio

AND
Please refer How to install Microsoft SQL Management Studio


Above scenario is specific cases, Kindly Backup before execute.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article