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
Leslie,
Did you get a chance to try the invoice without using the Temp table?
Hi Leslie,
My above attached transaction screen remains OPEN(But fully applied), either we need to change the state to History by using Paid Transaction Removal?
please advise my case.
Hi Keith,
I would try using the regular sop header instead of the temp table. I will give this a whirl tomorrow when I get into the office. Seems like there should be an easy answer to this one, I have had similar issues with the temp tables.
Kind regards,
Leslie
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
Hi Leslie,
I forget to add the main snap, please have a look on it.
Hi Leslie,
No, This is the fresh company & the above snap are the 1st transaction in the fresh company.
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?
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?
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
