Posted Invoice

(6) Share

Report

Posted on by CU24021115-0

I have a customer posted invoice showing both debit and credit in the customer statement, so ZERO balance and when the payment is received the customer account became in credit:

Posting Date	Document No.	Description	Due Date		Original Amount	Remaining Amount	Running Total
Entries USD				0.00
10/08/24	PS-INV103135	Order S-ORD101174	10/08/24		20,034.00	0.00	20,034.00
10/08/24	PS-INV103135	Order S-ORD101174	10/08/24		-20,034.00	0.00	0.00
11/01/24	G00183	RBC USD Account	11/01/24		-19,999.00	-19,999.00	-19,999.00
12/26/24	PS-CR104021	Credit Memo S-CR1024	12/26/24		-225.60	-225.60	-20,224.60
					Total USD		-20,224.60

Posting Date	Document No.	Description	Due Date	Original Amount	Remaining Amount
Overdue Entries USD
11/01/24	G00183	RBC USD Account	11/01/24	-19,999.00	-19,999.00
12/26/24	PS-CR104021	Credit Memo S-CR1024	12/26/24	-225.60	-225.60
		Total USD				-20,224.60

Appreciate assistance.

Categories:

Dynamics 365 general

*This post is locked for comments

All responses (5)

Answers (0)

CU24021115-0 46 on at

Like (0)

Report

Posted Invoice

Hello Abhilash Warrier,

Thank you for your reply. Strangely when I clicked the Customer Balance which is -$20,224.60 I noticed the payment received being applied $19,999.00 along with a credit note we applied for this client for items not shipped (Screenshot attached). However, when I go to the Posted Invoice and click on the Remaining Balance which is 0.00 I see the amount of the invoice in subject $20,034 is there both credit and debit, see the screenshot attached.

Appreciate your help, thank you.

Posted Invoice PP...

Posted Invoice PP...
Martin Dráb 232,532 Most Valuable Professional on at

Like (0)

Report

Posted Invoice

This question is a duplicate and in a wrong thread. Please continue the discussion in the thread in the Business Central forum.
Abhilash Warrier 135 on at

Like (0)

Report

Posted Invoice

Hi,

Could you please extract the data from Customer Balance to review all the transactions (Open & Closed). All Customers >> Customer Tab >> Balance >> Balance.

Please share the report name you are trying to review. Whether the report is standard, or any development/customizations are made?

Appreciate, if you could provide the details specifying in the Header (Invoice or Payments).
CU24021115-0 46 on at

Like (0)

Report

Posted Invoice

I am talking about a customer invoice that is posted both debit and credit, create a ZERO balance for the customer and when payment is applied it create a credit balance for the customer.

PS-xxx135 - C0029...

PS-xxx135 - Poste...

PS-xxx135 - C0029...
CU24021115-0 46 on at

Like (0)

Report

Posted Invoice

Can someone help, thank you