Hi Khaled,
The first Excel file I understand as it show two transactions.
- An Instant Invoice has been entered with the AR amount -27635571,95, I do not quite understand the postings, but the amount 25232478,74 is posted to the account 11201002, Trade Receivable - Progress Billing (Local)
- there seems to have been a payment in advance including VAT totalling 8650188,67 and that was offset against the invoice II202400227 and the account 11201002, Trade Receivable - Progress Billing (Local).
After these two transactions there should be a residual of 25232478,74 - 8650188,67 = 16 582 290,07 to handle, which is exactly the amount on your report dated March 4th at the time 10:06.
Has any transaction on the invoice happened after that? In the window Customer Invoice Analysis, the tab Payment Status, you should be able to identify additional payment transactions against the invoice.