Page History

15-Document Report -Customer Statement R116 - New layout and add print option

...

•     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

1. Option for Print Date - default today, user can change if needs. 
   1. The print date is use for exclude the settled invoice during the period from End Date to Print Date. 
   2. Print Date to be show on the Billing Statement 

2. Option "Exclude Settled Invoice" added, default checked.

Image RemovedImage Added

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

Image Removed

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. 

Image Added

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 Image Added	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 Image Added

Before Change

After Change

The Opening Balance (i.e. 3,675.50) is included the balance it settled during the

selected period 

Image Removed

if the option is checked, the "opening balance" will not included the balance it

have been settled within the selected period.   

Image Removed

if the option is un-checked, the opening balance will included the settled balance

(same as the logic before)

Image Removed