You’re offline. This is a read only version of the page.
60
Invoice was paid. payment included 3 other invoices. On payment the three show up but not the one that is still showing open. Tried to void open transaction, says it was used as partial payment or on hold. It is not on hold. It still shows up on Historical Aged Trial Balance as being due. How can I correct?
*This post is locked for comments
Paula,
When the corresponding payment application record is missing in table PM30300, invoices with a zero balance show up in the HATB report.
Run this query in SQL Management Studio to confirm that the record is missing:
SELECT *
FROM PM30300
WHERE (APTODCNM = 'invoice number')
substitute invoice number for the invoice number showing up in the HATB report.
If this query returns zero results, you need to add the missing record to table PM30300. Open table PM30300 in SQL Management Studio and insert the missing record. Then, run the HATB report to confirm that the invoice no longer shows up.
Leslie- i think this question is related to PM, not RM.
if so, i have a very similar issue.
GP shows the following:
PM invoice for $1381.33
PM payment for $1176.13
difference $205.20
the invoice shows has HIST in vendor inquiry. upon further review, there is a discount terms available of $205.20, but discount terms taken shows $0. it's pretty clear that the discount was taken but doesn't show up under discount taken. if you look at the vendor inquiry, it appears that the document balance is 0. the document shows up on the HATB with the original document amount and the payment amount and shows a balance. there were a number of transactions like this for this particular vendor -- to the tune of an $18,000 balance over the years. the customer created a credit memo to apply to the open balance, but is unable to apply it because the individual documents show $0 balance.
how do we show them fully applied and remove them from the HATB? my initial thought is to edit the PM30000 table to update the discount taken field.
Hi Paula,
The first line of defense is always Check Links and Reconcile Sales Documents. Then do a Reconcile Sales Documents and Remove Completed documents.
When you inquire on this sales document and zoom back on the amount remaining, what comes up in the window? Does it show as fully applied?
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (