Child pages
  • Customer invoices and ageing in RetailManager


 

 

RetailManager

ANSWER ID:13702

In RetailManager, custom ageing terms can be set up on a per-customer basis on the customer's card.

 

To set up custom ageing
  1. Go to the Information menu and choose Customers.
  2. Press F5 on the keyboard to create a new customer, or select an existing customer.
  3. On the General tab, click Show Account Details or press F3 on the keyboard.
    Select the Account Customer option as shown in the example below.
    Image

    The ageing options are as follows:

    OptionDescription
    No of Days

    You can select the number of days from the invoice date that you want this customer to pay in, before the invoice becomes overdue.

    For example

    If a customer has No of Days = 30 , an invoice with a date of the 1st of July would be due in 30 days. That invoice would become overdue on the 31st of July.

    In your customer statement , the invoice amount would appear as part of the current amount. On the 31st of July it would move into 30 Days , since the invoice is now between 1 and 30 days overdue.

    From EOM

    If you have selected the From EOM (End of Month) option, the number of days is from the end of the invoice month. This option is regardless of which date of the month, so an invoice entered on the 5th of July would be due at the same time as an invoice entered on the 30th of July.

    For example

    A customer has been setup with No of Days = 30 and From EOM has been selected.

    The customer has an invoice created on the 1st of July, then the due date will be the 30th of August. This is 30 days after the end of the invoice month.

    If the same customer has another invoice created on the 30th of July, it will be due on the same date, 30th August, because it is 30 days after the end of the invoice month.

The terms that you have created in your customer card are used in the Customer Statements to age the invoices. The As at date uses the terms created in the customer card to age the invoices as of the entered date. The as at date can be changed, but this will affect the ageing within the customer statement.

Image

If the As at date is on or before the due date of an invoice, that invoice balance will appear in the Current aged balance field. The outstanding invoice amount will only move to the 30 days field, once the invoice has become overdue by 1 to 30 days. When the invoice has become more than 31 days overdue, the balance will be moved across to 60 Days and then 90 Days.

Image

 

 
Related topics