Accounts Debt Management Trade Experience Tab

For the Other Action Menu options (press F9 or the Other Actions Menu on the Button Bar) 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 the green opening folder icon is normally linked to the opening of a dialog box that allows the user to browse and select a value or range of values : 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


See Also


Did you find this article helpful?