Sage 100 Accounts Receivable Options

Learn how to use Sage 100 Accounts Receivable Options with Sage 100 training classes from Accounting Business Solutions by JCS!

One of the most attractive features of Sage 100 is its flexibility, and the Sage 100 Accounts Receivable module is no exception. AR in Sage 100 has a variety of customizable options which range from sales tax reporting and aging options to printing and batch processing options. Continue reading to see the various customizable screens in Sage 100 Accounts Receivable.

 

Accounts Receivable Options – Main

 

  • Divisions – used for reporting purposes and default posting accounts.
  • Expanding the customer number cannot be undone. Non-graphical forms (legacy modules) do not support expended customer numbers.
  • Posting
  • Segment Substitution by sub-account segment is divionalized.
  • Sales Tax Reporting – determines if sales tax is calculated and tracked.
  • Job Cost retention
  • Integration

 

Accounts Receivable Options – Additional

 

 

  • Open Item vs Balance Forward.

Open Item: When entering cash receipts, you can apply the payment to a specific invoice and the invoice detail remains in the system.

Balance Forward: During period-end processing, open invoice balances are converted to one balance. When entering cash receipts, the payment is applied to the total amount due for the customer, not to individual invoices. Invoice detail is not retained in the system.

Mixed: Allows you to determine on a customer-by-customer basis in Customer Maintenance if they are Balance Forward or Open Item.

  • Aging – How calculated and catagories.
  • Commissions
  • Finance Charges

 

Accounts Receivable Options – Credit

 

  • Credit limit checking

Select None if you do not want to check the customer’s credit limit when entering transactions.

Select Customer’s Credit Limit Only to have the system compare the customer’s current open invoice balance to the customer’s credit limit or a specified amount. If the open invoice balance exceeds the credit limit or amount defined, a warning displays.

  • At the Margin for Customer’s Credit Limit Exceeded Warning field, you can enter a credit limit margin.
  • If a margin is entered, the customer’s current open invoice balance is compared to their credit limit, if the difference falls within the margin entered, the credit limit warning displays.

Select Aging Category Onlyto have the system compare the customer’s aged invoice balance to the customer’s credit limit or a specific amount you specify. If the aged invoice balance exceeds the credit limit or amount defined, the credit limit warning displays.

  • At the Aging Category for Credit Limit Exceeded Warning field, you determine which aging categories are used when comparing to the customer’s credit limit or specified amount. For example, if you select 90+ Days, the system calculates the total aging balance for all aging categories up to and including the 90+ days aging category.
  • The options available are based on the aging categories defined on the Additional tab.
  • At the Aging Category Balance Exceeds Amount field, you can enter an amount to compare to the aged invoice balance calculated for the customer. If the amount exceeds the amount entered, the credit limit warning displays.

Select Bothto have the system compare both the current open invoice balance and aged invoice balance to the customer’s credit limit.

  • You can define both a margin and determine the aging category to use if Both is selected at Credit Limit Checking field.
  • he system displays a warning if any of the conditions discussed for the Aging Category Only and Customer’s Credit Limit Only options are met.
  • Automatic Recalculate Aging (Never, Always, By Number of Days)

Note: The date the aging information was last recalculated for a customer is maintained in the AR_Customer file.

 

Accounts Receivable Options – Entry

  • Batch Processing
  • Defaults

– If the Require Deposit Amount check box is selected, you are required to enter a total cash and credit card deposit amount in Cash Receipts Entry to be compared against the actual transactions entered.

  • Resets

 

Accounts Receivable Options – Printing

 

 

 

 

 

 

 

Accounts Receivable Options – History

  • Customer Audit
  • Cash Receipts
  • Invoice History

The Retain In Detail field determines if invoice history is retained in detail or summary.

Yes: Select Yes to have the ability to drill down to view invoice information, reprint invoices, and print detailed invoice reports.

Summary: Select Summary to retain information regarding the original invoice amount and payment terms. Detailed information such as the items or services purchased are not retained.

No: Select  No if you do not want to retain detailed or summary invoice history.

  • Sales History

 

 

Are you interested in learning how to customize Sage 100 Accounts Receivable? Accounting Business Solutions by JCS offers Sage 100 training classes, including how to customize options in Accounts Receivable in Sage 100.  Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started.

Setting up Sage 100 Accounts Receivable

Correctly setting up Sage 100 Accounts Receivable is crucial to your Sage 100 success. Learn how to set up Sage 100 Accounts Receivable with the certified Sage 100 consultants at Accounting Business Solutions by JCS.

 

What’s needed to set up Sage 100 Accounts Receivable

Before using Accounts Receivable for a new company, you must complete the Accounts Receivable system startup process. Before beginning the system startup process, gather the following information:

  • Your general ledger chart of accounts
  • A list of states, counties, and local areas to which you report sales tax and their tax rates
  • Your bank account number(s) for the checking account(s) used by Accounts Payable
  • A list of standard payment terms offered to your customers
  • A list of customers, including addresses and phone numbers
  • A list of payments and payment types
  • A list of sales people
  • All open invoices at the time of installation

 

How to set up Sage 100 Accounts Receivable

 

  1. Enter the Company Code
  2. Enter Accounting Date
  3. Complete the Accounts Receivable Setup Wizard
  4. Define Accounts Receivable Options
  5. Division Maintenance
  6. (Bank Code Maintenance)
  7. Terms Code Maintenance
  8. Sales Tax Class Maintenance
  9. Sales Tax Code Maintenance
  10. Sales Tax Schedule Maintenance
  11. Sales Tax Account Maintenance
  12. Salesperson Maintenance
  13. Payment Type Maintenance
  14. (Miscellaneous Item Maintenance)
  15. (Memo Manager Maintenance)
  16. Customer Maintenance
  17. Beginning Balance Entry
  18. Open Invoice Entry
  19. Print Invoice Register and Update
  20. (Set-up Repetitive Invoice Templates)
  21. Daily Processing

 

Are you interested in learning how to set up Sage 100 Accounts Receivable? Accounting Business Solutions by JCS offers Sage 100 training classes, including how to set up Accounts Receivable in Sage 100.  Our experienced, certified professionals offer a full line of Sage 100 support, training, and data repair. Call us today at 800-475-1047 or email us at solutions@jcscomputer.com today to get started with Sage 100 software today!

X