Problem Description
Messages on integrity report:
- Payment transactions do not equal invoice paid
Additional Description:
- Related to deposit on work order problems
Additional messages on integrity report touched on
- Credits do not equal debits
- Total payments do not equal the ROA total
Solution
This error ends up being longer, more advanced, and more technical. Please review the brief explenation of the error and the text below but refer to the video for details.
Error explained: The payment transactions are calculated by looking at the AR and Deposit on work order lines and comparing them against what the invoice sais that it has paid. If there are deposit on work order issues these lines don't add up properly for this check. So even though the invoice has no posting errors, it will report the error because of the problems with the payment(s) applied to it.Additional description: - The issue is related to deposit on work order issues- The invoice was completed and switched back to a work order causing all of the issues.
The video describes a complex process of determining the problem. Part way through the scenario we run into another integrity scenario who's fix is already recorded. This is the Credits do not Equal Debits issue with the additional behavior of Total Payments do not equal the ROA Total.WARNING: Any time you change from an A type invoice with payments to a W type invoice you will break the integrity of your system. This is the lesson to be learned.End result: The fix is described for this, and steps have been taken to record the exact scenario that causes these types of problems. I am going to submit a request to the programmers to help prevent this situation.
Video source: training:10_paymenttransactionsdneinvoicepaid_relatedtodepositonworkorderissues0908181615.flv
Created by Clifford MacKay at 8/18/2009 4:15:27 PM
