paid invoice, invoice still showing open with zero balance remaining to be paid, shows in Historical Aged Trial balance as open. Cannot close open transaction - says used as partial payment or on hold. It isn't on hold. How can I correct

(0) Share

Report

Posted on by Paula Strange

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

I have the same question (0)

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

Re: paid invoice, invoice still showing open with zero balance remaining to be paid, shows in Historical Aged Trial balance as open. Cannot close open transaction - says used as partial payment or on hold. It isn't on hold. How can I correct

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.

Was this reply helpful? Yes No
kwj3 11 on at

Like (0)

Report

Re: paid invoice, invoice still showing open with zero balance remaining to be paid, shows in Historical Aged Trial balance as open. Cannot close open transaction - says used as partial payment or on hold. It isn't on hold. How can I correct

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: paid invoice, invoice still showing open with zero balance remaining to be paid, shows in Historical Aged Trial balance as open. Cannot close open transaction - says used as partial payment or on hold. It isn't on hold. How can I correct

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

Was this reply helpful? Yes No

Community site session details

paid invoice, invoice still showing open with zero balance remaining to be paid, shows in Historical Aged Trial balance as open. Cannot close open transaction - says used as partial payment or on hold. It isn't on hold. How can I correct

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

paid invoice, invoice still showing open with zero balance remaining to be paid, shows in Historical Aged Trial balance as open. Cannot close open transaction - says used as partial payment or on hold. It isn't on hold. How can I correct

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates