This report shows payment details by customer with invoiced, Paid and still Due amount.



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 



Customer

 Customer name.

Invoice #

 Invoice Number identifying sale invoice.

Invoice Date

 Invoice issue date.

Due Date

 Date when invoice is due for payment.

Sales Representative

 Name of sales representative associated with the sale.

Invoice Total

 Total of invoice - Total of credit note including tax.

Paid

 Total Paid - Total Refunded.

Due

 Due amount = Invoice - Paid - FX Gain/Loss.

FX Gain/Loss

 Foreign Exchange gains and losses.

Year

 Year of invoice date.

Quarter

 Quarter of invoice date.

Month

 Month of invoice date.

Customer Tags

 Comma-separated customer tags.

Customer Reference

 Additional reference provided to customer to identify the sale.

Country

 Shipment address country.

State

 Shipment address state.

City

 Shipment address city.

Postcode

 Shipment address postcode.

Shipping Address 1

 Shipment address line 1.