You’re offline. This is a read only version of the page.
30
Hello to all.
I am having three issues with the Customer Statement by Customer Report.
A) On this report there are invoices that are listed more than once. There is only one invoice # 14772 and yet it is listed five times on the customer statement.
B) Also, there are customer payments which are credits (negative) and yet the amount in the balance column is positive!
C) Due to the balance column being wrong, the Total Balance Due at the bottom of the statement must also be fixed.
Please help me to correct these two issues since as of now, I have to export the data into Excel and fix the information there. This is time consuming and ridiculous since this software is state of the art and was on the expensive side. Thank you so much.
*This post is locked for comments
I have the same question (0)
This is odd I have not seen this happen in GP. How are you populating the data? Are you allowing duplicate transaction numbers in the module? None of these duplicates are voids?
2 things I would try to correct the problem (in a test database first preferably)
1. Run check links on the RM Transaction Open and History tables?
2. Run AR reconcile on the customer,
Don't forget to back up in case you need to restore your data.
Share
Report
All responses (
Answers (
