Accounts Debt Management Trade Experience Tab
For the Other Action Menu options (press F9 or ) see Accounts Other Actions Menu.
The Trade Experience screen displays a weekly snapshot of a customer's statement going back in time for X number of weeks. Using the result it's possible to see how long the customer took to pay invoices issued to them, displaying their "payment history trends". The results also show the customer's turnover. The report can also be printed using the printer icon on the button bar. This information can be used to help determine customer credit terms.
Note: This report can also be run for a creditor or supplier and it will display your trade experience with them.
The screen consists of the top filters and the grid.
Trade Experience Filters
- Go button: after making changes to the filters press the Go button to populate the grid.
- Number of Weeks: the number of weeks that the system should analyse the customer's statement over.
- URN : use the green folder to select the company.
- Company : the name of the selected company.
- Terms: the terms as listed on the
[ Customer | Detail | Financial ]
screen. - Turnover checkbox: the system will calculate the turnover and display it in the Turnover column.
- Display Area:
- Maximum days taken to pay an invoice: # (# weeks): the maximum number of days it takes the company to pay an invoice based on the number of weeks entered in the filter field. i.e. The longest time it took them to pay.
- Minimum days taken to pay an invoice: # (# weeks): the minimum number of days it takes the company to pay an invoice based on the number of weeks entered in the filter field. i.e. The quickest time it took them to pay.
- Average days taken to pay an invoice: # (# weeks): the average number of days it takes the company to pay an invoice based on the number of weeks entered in the filter field. If this is equal to or greater than their terms then they are becoming or have become a bad debt customer.
Trade Experience Grid
- Date: week ending.
- Current: the current week.
- Week 1-12+: weeks 1 to 11 and 12 onward. This will display the relative age of the debt based on the Date.
- Total: the total amount owed at that point in time.
- Turnover: calculated from the sum of the item total plus the delivery total (including tax) from invoices for the particular company from the start of the year.
Trade Experience Context Menu
- Goto Customer: opens the
[ Customer | Detail | General ]
tab for the customer. - Clear Selection: deselects the currently selected line(s).