AR/AP transactions are listed in the Debt Tracking window with the following columns:
- Transaction Date
- Date
- Number
- Transaction
- Debit
- Credit
- Balance
- Remaining
- Document No.
- Trading Group
- Reminder Level
All invoice types are processed on the debt-tracking window except for Sales Proforma Invoices. If a payment plan is linked to the invoice bottom or the transaction in the line, the invoice is displayed in the debt-tracking window in as many pieces as the number of payments. The Date column displays the payment date calculated for each payment. Invoices which are not linked to the payment plan are listed as outstanding transactions, on a single line on the Debt Tracking window.
Transaction lines totally or partially closed with a payment are listed as connected to each other with a link. In this way, it can be understood which transaction is closed by which payment or collection, and Closed and Remaining Amount information can be tracked.
The Filter button is used to search for and display requested records in the debt-tracking window. The filtering transaction is performed on the filter debt-tracking window to access record(s) matching the required characteristics. The filter options are:
Filter | Value |
|---|---|
Date of Transaction | Start / End |
Due Date | Start / End |
Division | Defined divisions |
Department | Defined departments |
Transaction Currency Type | Currency options |
Closed Transactions | List / Do Not List |
Trading Group | Group / Range |
Invoice Types | Invoices |
AR/AP Transaction Types | AR/AP Transactions |
Check/P. Note Transaction Types | Check/P. Note Transactions |
Bank Transaction Types | Bank Transactions |
Safe Deposit Transaction Types | Safe Deposit Transactions |
Order Types | Sales Orders / Purchase Orders |
Transaction Total | Total range |
Posting Status | Posted to G/L / Not Posted to G/L |
Salesperson Code | Group / Range |
Cancelled Ones | List / Do Not List |
Aux. Code | Group / Range |
Closing operations on the debt-tracking window can be performed by inter-connecting Debit and Credit transactions and using one of the following options:
- Close
- Multiple Close
- FIFO Close
- Automatic Close
When FIFO Close is selected, the transaction with the closest due date among transactions with reverse balance that have not been used in other closing operations is used for the closing operation.
When Close is selected, transactions are linked and closed by the user.
When Automatic Close is selected, all transactions displayed in the window are closed according to the FIFO method. In other words, debit and credit transactions sorted by due date close each other according to this order.
If transactions are not wholly closed after the closing operation, closed and outstanding parts are separated. Each part of the transaction separated after the closing operation is displayed as linked to the other parts. When the cursor is on transactions of which Closed (Remaining) fields are empty, the Counter Transaction field lists the following fields of the slip that closed the transaction.
- Slip Number
- Date
- Slip Type
- Doc. Tracking Number
- Amount
Payment details are listed under Debt Tracking window, and these fields are not editable. Document tracking number of the relevant invoice is transferred to "Document Tracking Number" field located in this section for the payment transactions of purchase or sales invoices, and this value can not be changed. Debit - Average Due Date, Debit - Average Day, Credit - Average Due Date, Credit - Average Day fields are used to display average due dates of unclosed transactions. Average due date is calculated for debt/credit amounts and days separately. If there are more than one line checked in Debit Tracking window, average due date of only the selected lines are calculated.
Average Due Date Calculation:
Transaction Date + ((Transaction Date – Due Date) * Amount 1) + ((Transaction Date – Due Date) * Amount 2) + ..... n / Amount1 + Amount2 + ... AmountN