AR Setup

Table of Contents

Overview

Detail

 

General Tab

The A/R Setup screen is divided into 3 tabs.  The first defines the General Ledger accounts used by the A/R module, the 2nd allows you to define groupings for the aging reports and the 3rd tab is used to set beginning document numbers.

AR > AR Special Functions > AR Setup

Default setups

  • Default A/R Account - Default A/R account to use when setting up customer types and new customers.  The A/R account can be changed for each customer.

  • General Ledger Cash Account - This is the General Ledger account to use for cash in this account.

  • Sales Discount Account - General Ledger account to debit for discounts taken during cash receipts.  A discount is given when a customer pays an invoice early such as in 2%, 10 days, net 30.

  • Cash Receipt Allowance Account - General Ledger account to debit for allowances taken during cash receipts.  An allowance is given when the customer short pays an invoice by a small amount not worth trying to recover and marking the invoice paid in full is desired.  In many cases, the Sales Discount and Allowance account are the same General Ledger account.

  • Customer Deposits Account - General Ledger account to credit when taking a deposit on a sales order.  Cash is debited.  When the invoice for the order is created, this account is debited and the A/R account is credited.

  • Default Payoff document Sales Account - Payoff documents are credits and debits created on the fly during cash receipts to close out an invoice.  These are used instead of sales discounts or allowances.  This is the account to post the amounts to.

  • NSF Service Charge Account – the default account that gets used when NSF charges are applied at the reverse cash receipts screen.

  • Default Bank for Cash Receipts - This is the default bank account to use when making a cash receipt.  You can change the bank account when making cash receipts

  • Default Finance Charge – the default monthly finance charge that gets applied to customer aging when the customer statement is printed.

  • Finance Customer Type – This customer type will interact with the finance tab in customer setup when creating finance company invoice copies

  • Default Terms - These are the default terms that will be used for new customers.  

  • Invoice Copies - The number of copies to print when printing invoices, users can change it when they use the Print Invoices menu option.  If you use a custom invoice that prints multiple copies, this should be left at 1.

  • Preview - Check this box to preview invoices on the screen when printing them.  Un-checking this box sends the invoices directly to the printer.

  • Printer - This is the printer on which to print the invoices.  Leave it blank to use the default printer of the PC from which documents are printing.  Users can change printers when they use the Print Invoices menu option.

  • Salesperson for cash receipts payoff doc – You can declare a salesperson that will get the credit for cash receipts payoffs.  Ideally this will be one that is not on any commission so that the extra charges will have no effect.

Check Boxes

  • Group Customer Statements by Billing Contact – When this box is checked customer

  • Group Customer statements will be sorted and printed by the billing contact that was on the order.

  • Roll up finance charges of Statements to a single line – If this box is checked all finance charges from past months will roll up into a single charge amount

  • Create price rule for last price paid – Creates a price rule automatically each time an invoice is processed.  The price rule is a customer/item type and specifies actual price.  The price being that of the last invoice for the customer/item.  The process is date sensitive and looks at the invoice date to determine if an invoice is actually that latest invoice.  Credit & Debit memos have no effect.  By creating a price rule of customer/item, quotes, orders, POS Sales, and A/R invoices will always use the last price paid for a customer.  No price rule is created for the POS cash customer.

  • Pay commissions on Debit and Credit Memos – If this box is checked sales people will get commissions on all debit and credit memos (with the exception of those created in cash receipts)

  • Pay commissions on Debit and Credit Memos in Cash Receipts - If checked salespeople will get commissions on credit and debit memes that are created in cash receipts

Aging Tab

The Aging tab of the A/R setup screen allows you to define the number of days overdue for each column of the aging reports.  There are five columns and you must cover all possible days.  An example is shown on the next page.  You may also provide a title for each of your groupings.

 

There is an option to use either the invoice or due date of documents when calculating the number of days overdue for a document.  This is used as a default on the reports and users can choose either option when selecting an aging report.  The aging summary that is displayed as part of the Customer Inquiry screen uses this option to calculate days overdue.

Numbering Tab

On the Numbering tab, you specify the next numbers to use for each of the different types of documents in the A/R module, invoices, credit and debit memos, new customers and refunds.  There is an option to automatically number each type of document and it is highly recommended to automatically number documents.  If the user chooses not to automatically number documents, the user needs to make sure there are no duplicates when manually entering documents.  TRX Enterprise will not process documents with duplicate numbers.

  • The choice of automatic or manual numbering for customers and the next customer is handled on this tab.

  • The batch number is used to number General Ledger posting batches. These will always be automatically numbered.

 

It is not advisable to start numbering all five reports at one.  We recommend:

Refunds -1    -     Customers – 1000   -   Credit memos – 10000   -     Debit memos – 50000

Invoices 100000

By spreading the numbers out you will help avoid the confusion that will occur at times when all form numbers run together.

Customer Layering

Here, you can setup your Customer layers. These will become fields on your Customer records. Examples are Chain, Franchise, Legacy Location, etc. For complete Customer Layering setup, see Customer Layering under AR Concepts.

  • Layer 1-7 Title - This will be the name of the field on your Customer record

  • Required Checkbox - This will require that the field is entered on every Customer record