Spreadsheet: 840926d1693190012-how-to-get-data-from-sheet-without-transforming-to-table-getdata
Sheet: Test

2023-08-25 10:54:11 |  |  |  |  |  |  | 2. XXX PTE LTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 1
A/R Aged Trial Balance by Document Date (ARTBAL01)
From Customer Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [UCW]  To  [UCW]
From Customer Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [ ]  To  [zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz]
Sort Customers By |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [Customer Name]
Account Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [All Customers]
Age Transactions As Of |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [25/08/2023]
[NAME] by Document Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [25/08/2023]
Print Transactions In |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [[NAME] by Document Date]
Transaction Types |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [Invoice, Debit Note, Credit Note, Interest, Unapplied Cash, Prepayment, Receipt, Refund, Adjustment]
Include Contact/Phone/Credit Limit |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [Yes]
Include Space For Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [No]
Include Only Customers Over Their Credit Limits |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [No]
Include Zero-Balance Customers |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [No]
Show Applied Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [No]
Show Fully Paid Transactions |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [No]
From Document Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  | []
[NAME] by Transaction Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [No]
Print Amounts In |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [Customer Currency]
Customer Number/Name/ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1    to    30 |  |  | 31    to    60 |  |  | 61    to    90 |  | Over    90
Document Type/Number |  |  |  |  |  |  |  |  |  |  |  |  |  | Doc. Date | Due Date or Check/Recpt. No. |  |  |  |  |  |  |  |  |  | Current | Days |  |  | Days |  |  | Days |  | Days |  |  | Total
UCW3831 |  |  |  |  |  | 4 ABC Pte Ltd |  |  |  |  |  |  |  |  |  |  | Contact: |  |  |  |  |  |  |  |  |  | Phone:
 |  | DB |  | INV17171717 |  |  |  |  |  |  |  |  |  | 2023-06-12 00:00:00 | 12/06/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 626.4 |  |  |  |  | 626.4
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 0 |  |  | 626.4 |  | 0 |  |  | 626.4
UCW3817 |  |  |  |  |  | LYKSDJ |  |  |  |  |  |  |  |  |  |  | Contact: |  |  |  |  |  |  |  |  |  | Phone:
 |  | DB |  | INV2818271 |  |  |  |  |  |  |  |  |  | 2023-04-19 00:00:00 | 19/04/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 648 |  |  | 648
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 0 |  |  | 0 |  | 648 |  |  | 648
UCW1308 |  |  |  |  |  | TESTING |  |  |  |  |  |  |  |  |  |  | Contact: |  |  |  |  |  |  |  |  |  | Phone:
 |  | DB |  | DN717162 |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00 | 08/05/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 540 |  |  | 540
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 0 |  |  | 0 |  | 540 |  |  | 540
UCW3125 |  |  |  |  |  | UUUU |  |  |  |  |  |  |  |  |  |  | Contact: |  |  |  |  |  |  |  |  |  | Phone:
 |  | DB |  | INV6172818 |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00 | 08/05/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108 |  |  | 108
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 0 |  |  | 0 |  | 108 |  |  | 108
UCW4448 |  |  |  |  |  | Yoyosysy |  |  |  |  |  |  |  |  |  |  | Contact: |  |  |  |  |  |  |  |  |  | Phone:
 |  | DB |  | INV821 |  |  |  |  |  |  |  |  |  | 2023-06-12 00:00:00 | 12/06/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 756 |  |  |  |  | 756
 |  | IN |  | INV91727171 |  |  |  |  |  |  |  |  |  | 2023-06-12 00:00:00 | 12/07/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108 |  |  |  |  | 108
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 0 |  |  | 864 |  | 0 |  |  | 864
[NAME] |  |  |  |  |  | Hello |  |  |  |  |  |  |  |  |  |  | Contact: |  |  |  |  |  |  |  |  |  | Phone:
 |  | DB |  | INV717171 |  |  |  |  |  |  |  |  |  | 2023-05-08 00:00:00 | 08/05/2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108 |  |  | 108
 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 0 |  |  | 0 |  | 108 |  |  | 108
 |  |  |  |  |  |  |  |  |  |  |  |  | Report Total: |  |  |  |  |  |  |  |  |  | SGD |  | 0 | 0 |  |  | 3661.2 |  |  | 9590.4 |  | 22401.82 |  |  | 35653.42
CR: Credit Note         DB: Debit Note                         IN: Invoice                            IT: Interest Charge                 PI: Prepayment                   UC: Unapplied Cash                       MC: [NAME]
AD: Adjustment         CF: Applied Credit (from)         CT: Applied Credit (to)         DF: Applied Debit (from)         DT: Applied Debit (to)         ED: Earned Discount Taken
GL: Gain or [NAME] (multicurrency ledgers)                   PY: Receipt                          WO: Write-Off                      RD: [NAME] Refund
58 customers printed
57 customer name records printed