...
- 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/20212001, End Date 17/31/2021 2022 and Print at 8/6/2022
Refer to the customer ledger entries, the there are 5 outstanding invoice with total amount 3,675 have been settled at 1/18/21
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 |
Before Change | After Change |
The Opening Balance (i.e. 3,675.50) is included the balance it settled during the selected period if the option is checked, the "opening balance" will not included the balance it have been settled within the selected period. if the option is un-checked, the opening balance will included the settled balance (same as the logic before) |