(Optimum) Customer Knockoff still showing transaction without outstanding

Created by Lucas Leong Yee Hong, Modified on Mon, 21 Dec, 2020 at 5:13 PM by Lucas Leong Yee Hong

To clear AR zero matching amount

  1. The script to filter out all the ARMatching is zero amount. This is one of the reasons that showing the error message “Sequence is contain More than 1 element”.  

 

        2. Other than this, If you happen to find that for those transactions with no outstanding but still showing in Customer Knock Off              after tick Show Outstanding Only, it is having the same issue.

 

3. Using Below script to filter out all the transactions that having matching with zero amount.

 

/*filter all AR zero matching amount */

select*from armatched where amount = '0' and ARAmountLocal='0' and PayForAmountLocal='0'

select artype,ARTranId,arcode,payfortype,payforid,payforcode, glaccountid, amount, ARAmountLocal, PayForAmountLocal

from armatched where amount = '0' and ARAmountLocal='0' and PayForAmountLocal='0'

 

/*filter all AP zero matching amount */

select* from apmatched where amount = '0' and ApAmountLocal='0' and PayForAmountLocal='0'

select aptype,ApTranId,apcode,payfortype,payforid,payforcode, glaccountid, amount, ApAmountLocal, PayForAmountLocal

from apmatched where amount = '0' and ApAmountLocal='0' and PayForAmountLocal='0'

 

 

 

 

 

 

 

 

Here is the example, you will find out all the transcations that are with zero amount in matching.

 

 

 

4. After filtered out all the transactions that is zero matching amount, delete by running below script.

 

/*filter all AR zero matching amount */

delete from armatched where amount = '0' and ARAmountLocal='0' and PayForAmountLocal='0'

select artype,ARTranId,arcode,payfortype,payforid,payforcode, glaccountid, amount, ARAmountLocal, PayForAmountLocal

from armatched where amount = '0' and ARAmountLocal='0' and PayForAmountLocal='0'

 

/*filter all AP zero matching amount */

delete from apmatched where amount = '0' and ApAmountLocal='0' and PayForAmountLocal='0'

select aptype,ApTranId,apcode,payfortype,payforid,payforcode, glaccountid, amount, ApAmountLocal, PayForAmountLocal

from apmatched where amount = '0' and ApAmountLocal='0' and PayForAmountLocal='0'


5. Then the problem will be gone, you may check again by using the script in step 3.

Now you are able to open the OR or CN already.

Thank you.

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