Table of Contents |
---|
15-Document Report -Customer Statement R116 - New layout and add print option
1) Customer Statement (Report 116)
- New layout for customer statement developed according to the sample provided by UICL at 2021/06/17.
- New overdue reminder according to document provided by UICL at 2022/02/15
2) Print option for Exclude settled invoice and Print Date
- Option for Print Date - default today, user can change if needs.
- The print date is use for exclude the settled invoice during the period from End Date to Print Date.
- Print Date to be show on the Billing Statement
Option "Exclude Settled Invoice" added, default checked.
2.1) Case Example for Exclude Settled Invoice
Case Scenario: Print the statement for the customer with Start Date 1/1/2001, End Date 7/31/2022 and Print at 8/6/2022
Refer to the customer ledger entries, there are 5 outstanding invoice with total amount 3,433.00. One of invoice No. 201210133 with amount 813.00 is settled at 08/02/2022
The outstanding balance as of print date Aug 6, 22 is 2,620.00 for 4 invoice.
If Exclude Settled Invoice is selected | If Excluded Selected Invoice is not selected |
---|---|
1) Statement Date = End Date in print option 2) Balance Due = Balance as of End Date 3) Print Date = Print Date in print option 4) Total as of Print Date = caption to be shows if Exclude Settled Invoice is selected the account activity and total show the outstanding as of Print Date Only | 1) Statement Date = End Date in print option 2) Balance Due = Balance as of End Date 3) Print Date = Print Date in print option 4) Total = caption to be shows if Exclude Settled Invoice is not selected the account activity and total show the outstanding as of end date in option page |