Hi There

Try the below , may assist you somehow

Query - Customer Invoice Details

Explanation

The Query - Customer Invoice Details activity states detailed information about the customer, invoice details, the payment plan and discounts, the voucher, etc. The window is divided into six different tabs. You can also view the proposed installment plan for the invoice.

Prerequisites

This activity requires that customer and invoices have been entered.

System Effects

There are no system effects as a result of this activity.

Window

Customer Invoice Analysis

Related Window Descriptions

Query - Customer Invoice Details

Procedure

To query for customer invoice details:

1. Open Customer Invoice Analysis window. 
2. Use the query or populate function to find the relevant customer invoices.

Thanks

Hi Khaled,

The first Excel file I understand as it show two transactions.

1. 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)
2. 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.