Share
Report
3,657Hi Everyone
I am looking at a situation that I haven't come across before. We have several vendors which have their invoices fully paid but yet remain on the Payables HATB. This problem occurs on vendors with foreign currency.
For example: Vendor 1 invoice entered on July 31 and posted. At month end a revaluation was run and an unrealized gain/loss was recorded.
August 15th a cheque was issued to pay the vendor and applied against the invoice. The cheque exchange rate was the same as the revaluation rate used and a realized gain/loss was recorded.
When running the HATB in functional or with multicurrency, the invoice and cheque amount appears on the report when using a print/age of date of today. These records should not appear on the report as they are fully paid.
I have checked the PM30200, PM30300, MC020103 and MC020105 tables to see if there are residual values and there are no incorrect values. I have verified the document date, apply dates, posting date fields and they all match.
Any suggestions?
thanks
*This post is locked for comments
All responses (
Answers (
