National Accounts Cash Receipts

(0) Share

Report

Posted on by Community Member

When a cash receipt is received from a parent and is applied to an invoice from one of the children, the invoice still shows as being open when viewed from the child's document in transaction inquiry. Is there a way to see that the invoice was paid by paid by the parent?

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

That should not be the case. is this for all customers that are part of a national account or just certain customers? I would try running Reconcile on your Receivables transactions to see if that resolves the issue.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

Keith,

When you say "the invoice still shows as being open" do you mean it has an Origin of OPEN? If so, this is standard Dynamics GP behavior and perhaps a poor choice of terminology. All this means is that this transaction is in the OPEN tables, as opposed to WORK or HISTORY tables. What you really need to do to see if the transaction is "open" (in accounting terms) is to check the Amount Remaining on the invoice - if that is 0, then it is fully paid/applied and "closed".

GP keeps receivables transactions in the OPEN tables because transactions in HISTORY cannot be unapplied or voided. There is a manual process to periodically move receivables transactions that have been fully applied to HISTORY. (Paid Transaction Removal)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your response Victoria. My issue is not that the invoice is in the OPEN table, but that when the invoice is reprinted, it does not show that it was paid as the payment was done via National Accounts. I would like to edit the Invoice in report writer but I do not see a table that contains the 'Amount Remaining' field. There is a Sales Payment Work and History table but this only shows work and history.

How can I add this 'Amount Remaining' to the invoice so that I can use it in a formula.

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

Like (0)

Report

Hi Keith,

When you reprint an historical invoice that has been paid by the direct customer, how does it show that it was paid? Whenever I print a posted/paid SOP invoice, it shows the invoice as it originally printed. It is not updated with any payment information.

The payment information is in the RM tables. When a SOP invoice is posted, it moves into the SOP history file, RM takes over from there. If you look at the invoice record in the RM tables, there is a field for the Current Transaction Amount. That is the field that will show the remaining balance. Are the invoices in question only partially paid?

Which specific report are you printing that you are wanting to modify. Which specific report are you printing that shows a non-national account invoice as paid off?

Kind regards,

Leslie

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (0)

Report

Leslie brings up a good point - what is the invoice report you're printing? And are you using SOP or Invoicing or Receivables Management to enter your invoices?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Leslie & Victoria,

I guess the Keith has face the issue as below

I have configured National Accounts setup as shown below.

Now i apply fully applied payment from Parent for child with state as OPEN as shown below

In this case Reconcile on your Receivables transactions? Or Any settings missed?

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

Like (0)

Report

Hi Nataraj,

The screenshots you provided is what I would expect it to look like. Do you have transactions where it looks different?

Kind regards,

leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Leslie,

No, This is the fresh company & the above snap are the 1st transaction in the fresh company.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Leslie,

I forget to add the main snap, please have a look on it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Leslie,

I am using the Blank Historical Invoice form. It is modified to show Amount Paid (Payment Received) and Amount Due (Document Amount - Payment Received). This works great when the cash was received from the child customer to whom the original invoice was posted.

I am trying to update this to show the payment when the parent makes the payment. My intention is to create another calculated field and use the Current Transaction Amount from the RM Open File to show the Amount Remaining. When I try this however, I consistently get 0.00 as the Current Transaction Amount even when there is an amount in the table. My strategy was to add the RM Open table to the SOP_Document_HDR_Temp using relationship in the report writer.

Any idea why I am not seeing the current transaction amount?

Thanks for your suggestions.

Keith

Was this reply helpful? Yes No