User Tools

Site Tools


training:10_paymenttransactionsdneinvoicepaid_relatedtodepositonworkorderissues0908181615

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.

Note: this article is also publicly available at http://wiki.wws5.com/share/10_Payment Transactions d n e Invoice Paid_ related to deposit on work order issues0908181615.html

10_paymenttransactionsdneinvoicepaid_relatedtodepositonworkorderissues0908181615.flv

Created by Clifford MacKay at 8/18/2009 4:15:27 PM

training/10_paymenttransactionsdneinvoicepaid_relatedtodepositonworkorderissues0908181615.txt · Last modified: 2009/08/18 16:35 (15 years ago) by 127.0.0.1