Sales invoice, balance due and receipting

1

i have been having issue with my customer reconciliation, of which i normally do without any hassle initially. An illustration is this customer statement:

image
image942Ă—372 8.03 KB

i have no issue with the customer balance (which is correct) but if i go to sales invoice, all my invoices from inception is showing paid in full
image
image1495Ă—860 70.8 KB

i Decided to view balance due on todays invoice for the same customer, i found out that it was showing a receipt that i didnt record today (today is 23/01/2025)

image
image1463Ă—250 15.3 KB

the edit screen of the receipt showed that it was recorded on 17/01/2025 but its bringing 23/01/2025 on scenerio3

image
image1488Ă—543 19.1 KB

i was expecting the last 2 sales invoices to show “unpaid” because the receipts were not yet generated and the invoices were not mapped to any receipt.

Please help me understand this issue.

Thanks

2

Can you post screenshot of customer statement that includes all the transactions?

3

Dear @shahabb
find as requested. The customer statement transaction from inception

image
image863Ă—852 17.9 KB

Thanks

4

Can you show how you created the first transaction? Customer opening balance? If it’s through Journal Entry then thats the issue.
Create a Sale Invoice for Opening Balance too.
You dont create Debit balance for customer through Jounal entrym thats not how it works.

2 Likes
5

@shahabb Thank you for shedding more light.
I have raised sales invoices in place of journal entries to brin in the opening balance

I appreciate alot