Learn how

Sage 100 Accounts Receivable Maintenance 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. Sage 100 Accounts Receivable Maintenance contains a variety of options which can be customize to fit your particular needs.

Division Maintenance

• GL Accounts are assigned by division
• All customers must be assigned to a division
• If divisions are created, they can be set to post to specified GL account segments
• Use 00 (default) if no divisions are to be tracked

Bank Code Maintenance

• A is default bank code
• Bank Code Beginning Balances are entered through Bank Reconciliation

Terms Code Maintenance

• 00 is default terms code and cannot be deleted
• During invoice entry, discount amounts are calculated automatically and invoice and discount due dates display based on the assigned terms code.
• Although terms codes are assigned to customers in Customer Maintenance, you can change them in Invoice Data Entry.
• You can add new codes automatically using such tasks as Invoice Data Entry and Customer Maintenance.
• The Minimum Days Allowed field enables the proper calculation of the due date and discount date when the Day of the Month check box is selected.

Sales Tax

• For calculation of sales tax in AR or SO

• Sales Tax Class Maintenance

• Sales Tax Code Maintenance

• Sales Tax Schedule Maintenance

Sales Tax Account Maintenance

Sales Person Maintenance – Main

• Options for calculating and tracking commissions are entered in Accounts Receivable Options.
• A salesperson number and commission rate are assigned to each salesperson. The first two characters of the salesperson number indicate the division the salesperson is assigned.
• You can assign a default salesperson to each customer in Customer Maintenance; however, you can change the default salesperson when entering transactions in Invoice Data Entry.
• You can link salespersons to vendors, employees, or account numbers for commission tracking and payment if the Update Commissions to Other Modules check box is selected in Accounts Receivable Options.

– Click Link to establish these links.

Sales Person Maintenance – History

• Switch View
• Fix

Payment Type Maintenance

• A default payment type of CHECK is created automatically and you cannot delete this payment type. CHECK is also assigned to new customers by default.
• The asset account number defined is debited when the payment posts in Sales Order.
• For Credit cards, the default transaction method selected determines how to handle the transfer of funds when recording credit card deposits and payments in Sales Order.
• The accrual account is used to post the estimated accrued expense associated with accepting a credit card for payment. This expense is accrued during the sales journal update process and posts to the account entered at the Accrual Account field.
• The merchant ID is your ID with the credit card company. This information does not display when receiving credit card deposits.
• The discount percentage rate, transaction fee, and authorization term are assigned by the merchant bank.
• Credit card expenses equal the discount percentage plus the per transaction fee.
• At the Validation Code Length field, enter the length of the validation code sent to the credit card server.
• Select the Allow Corporate Cards check box to accept corporate credit cards for the selected payment type.

Miscellaneous Item Maintenance

Use Miscellaneous Item Maintenance on the Setup menu in Accounts Receivable or on the Common Information Main menu to identify and track miscellaneous products or services sold and purchased. This task is used primarily if Sales Order or Purchase Order and Inventory Management are not activated for the selected company.

Note: Items created through this task in Accounts Receivable are also available in Common Information and any other module containing the same task.

Miscellaneous Item Maintenance – Main

• During Invoice Data Entry, item codes are used to automatically display such information as the description, price, and cost for each item sold.
• The item code determines the posting to General Ledger for the sale of this item code when invoices are updated.
• The sales tax class selected determines if sales tax is calculated when the item is sold.
• For items or services sold in quantities, you can display a unit of measure on the customer’s invoice. The user is also prompted for a quantity in Invoice Data Entry.
• Select the Calculate Commission on Sales check box to calculate commission on this item code when entering transactions in Accounts Receivable.
• For both Miscellaneous and Charge Item Types, you can define a unit price and unit cost.
• You can define a sales, cost of goods sold, inventory, and purchases account on the Accounts tab for items assigned to the Miscellaneous item type.
• For the Charge item type, you cannot enter a unit of measure for item codes assigned to this type and you can only define a sales account and purchases account on the Accounts tab.
• Select Comment as the item type to enter a comment that you can add to an invoice. For example, you can enter a comment for warranty information or care instructions.
• Standard Codes M & C are available for one-time entries

Miscellaneous Item Maintenance – Accounts

• The Cost of Goods Account and Inventory Account fields are only available if the Cost of Goods check box is selected in Accounts Receivable Options.
• If you selected to post sales by division, the appropriate subaccount segment value is replaced with the value defined for the division assigned to the customer in Division Maintenance.

Miscellaneous Item Maintenance – History

Memo Manager Maintenance

• Assign security roles to where memo’s can be created / viewed

Are you interested in learning how to maintain 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.

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.

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!