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!

sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Accounts Receivable Changes

Every few months, Sage releases an update for their Sage 100 software which includes many useful changes and bug fixes to help your Sage 100 product run more efficiently. The most recent version, Sage 100 2018.3, includes many helpful changes to Accounts Receivable, including but not limited to:

 

  • Error “The Cash Receipts entry files are empty” no longer occurs when updating an A/R Cash Receipts batch where one deposit within the batch was transferred to a new batch.
  • Running the Credit Card Settlement Report no longer returns a communication error.
  • Printing the Credit Card Settlement report no longer returns a communication error (support for Error 20 AR_AgedInvoiceReport_rpt.pvc 386 is no longer occurred when previewing/printing the Accounts Receivable Aged Invoice Report.
  • Correct amount for discounts allowed and A/R GL accounts posted to GL shown on Sales Journal Recap by Division when printing/updating.
  • “Customer On Credit Hold” text font color is now red in Customer Maintenance version 2018.
  • Fix Error: “<Customer Number> is in use by another user and can only be viewed” in Price Level by Customer Maintenance
  • Error 47 CI_CustomerFormatter.pvc 100 is no longer occurred when entering cash receipts for Cash customer
  • Schedule text is not displayed over Exemption No text on Sales Order Invoice Data Entry Header panel when Sales Tax Reporting is disabled.
  • Fixed Error: “Payroll is not installed on this system” in AR Salesperson Maintenance when clicking Link button if Payroll is not installed.
  • Schedule text is no longer displayed over Exemption No text on Sales Order Invoice Data Entry Header panel when Sales Tax Reporting is disabled
  • The Error: “65 CI_AuditTracking.pvc 355” is not occurred when saving new credit card in customer maintenance with AR Audit tracking enabled.
  • The Cash Receipts records are updating to AR or Job Cost correctly.
  • Wrong amount for discounts are not allowed and AR GL accounts posted to GL shown on Sales Journal Recap by Division when printing/updating.

Sage 100, Sage 100 2018, Sage 100 2018.3, Sage 100 Accounts Receivable

Accounting Business Solutions by JCS offers a variety of Sage 100 support, training, and data repair services to assist you with any problems you may be having with Accounts Receivable in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 software. To learn more about Sage 100 software, call us at 800-475-1047 or email us at solutions@jcscomputer.com. Your success is our goal!

To download the Sage 100 2018.3 update, visit the Sage 100 2018 download portal here.

Sage 100 Accounts Receivable – 800.475.1047 – Training – Support – Consultant – Reseller

Sage 100 Accounts Receivable – 800.475.1047 – Training – Support – Consultant – Reseller

Sage 100 Accounts Receivable

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Sage 100 Accounting Training Class Outline – 800.475.107 – Training – Support – Consultant – Reseller

Sage 100 Accounting Training Class Outline – 800.475.107 – Training – Support – Consultant – Reseller

Are you a new user to Sage 100?  Are you a user who would like to learn more or add modules to your existing Sage 100 software system?  These classes are designed to introduce setup, integration, daily work and period-end processing aspects of each Sage 100 Module.

– Designed as an introduction to Sage 100 these core comprehensive classes cover Library Master, General Ledger, Accounts Payable, Accounts Receivable, and Bank Reconciliation.  We can help you understand the Sage 100 Software launcher and how to use it.  You will learn all menu options and how to properly close the periods for Sage 100 modules.

– The Sage 100 distribution classes include Inventory, Purchase Order and Sales Orders.

– If you are looking for more advanced Sage 100 training we offer Payroll, Bill of Material, Material Requirement Planning, Return Material Authorization, Work Order, Job Costs, Alerts, Workflow and Bar Coding.

– Sage 100 Reporting Classes include Sage Intelligence, Crystal reports and Business Insights.

Sage 100 Core Training Classes Include:
Sage 100 Library Master Training Class:

For Sage 100 System Administrators who want to learn tips and tricks to managing your Sage 100 Software.  Setup security and utilize Library Master Features and utilities

Sage 100 General Ledger Training Class:

This course teaches the fundamentals of setting up and operating the Sage 100 General Ledger.  In this class, you will review General Ledger setup options, learn the effects of those options on your Sage Software system and learn how to setup, modify and manager your company Chart of Accounts.  You will also learn the daily processing functions like entering journal entries.

Sage 100 Accounts Payable Training Class:

This course offers the Sage 100 user the knowledge and power of the Accounts Payable module.  Learn how to setup the software to meet your company’s requirements and gain the processing skills to improve accuracy and save valuable time throughout your daily Accounts Payable routine.

Sage 100 Accounts Receivable Training Class:

This course is designed to help you understand how to streamline receivables processing and generate quicker invoice payments.  You will gain the power to setup the module based on your company’s requirements and learn the basics of creating invoices, cash receipts and recurring invoices.

Sage 100 Bank Reconciliation Training Class:

This course is a complete review of Sage 100 bank reconciliation and how Journal Entries in the General Ledger, checks from Accounts Payable and Payroll and Cash Receipts from Accounts Receivable effect your Bank Reconciliation module.

Sage 100 Training classes

100% Satisfaction Guaranteed or return to Sage 100 Training Class for free within 60 days!

Classes held from 9:00 am – 4:00 pm    Sign Up Here

Call Now 800.475.1047 to speak with a Certified Consultant for Sage 100 to discuss how learning this business tool can help rev up your business.

User Guide, Lunch and Certificate of Attendance are included.  Classes are small and hands on, 1 person per PC. All classes are CPE accredited.

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

X