Sage 100 ERP Demo of the Accounts Receivable Tasks – View AR Reports, Module Options and Sage 100 Support Overview Information

Bisness Information Systems is a Sage Authorized Partner, Sage Reseller, Sage Certified Consultant, support and solution provider for the sage 100 erp accounts receivable module

Sage 100 ERP AR – Accounts Receivable Demo & Overview

Introduction to Sage 100 ERP Accounts Receivable Module

Sage 100 ERP Demo of the Accounts Receivable Module Web Browser Edition – BIS Virtual Tour Navigator

This page includes overview information about each menu task in the Accounts Receivable module that is accessible from the Sage 100 ERP main explorer menu and aided by an interactive virtual demo; Business Information Systems’ Virtual Tour Navigator. Clicking the thumbnails in each section opens the Sage 100 ERP virtual tour navigator. The clickable blue highlighted rectangles allows you to navigate to related screen panes in each Accounts Receivable task in which you can experience what the Sage ERP accounting software suite is all about.

About Sage 100 ERP Accounts Receivable Accounting Tasks

The Sage 100 ERP Accounts Receivable Tasks contained in this module is a set of intuitively designed tasks organized in an straightforward approach to quickly accumulate and present information needed for effective management of customers and cash. Streamline the management of customers who have corporate and branch accounts utilizing powerful National Accounts features. Efficiently track and bill the parent company for goods and services sold to the branch—while still keeping a unique customer account for each branch entity. The accounts receivable module contains key reports and includes powerful tools that efficiently mine data when needed, by utilizing the report writing capabilities using Crystal Reports, and data queries using Business Insights Explore. As with all the modules in the Sage 100 ERP Suite, eCommerce and Paperless is the standard.

sage 100 erp accounts receivable module features and benefits Accounts Receivable Features & Benefits

  1. Divisional Accounting Divisional accounting allows you to assign a separate accounts receivable general ledger account to the receivables for each division. All reports can provide divisional subtotals.
  2. Cash Expectations Reporting Forecast future cash receipts using three user-defined aging categories and forecast requirements based upon the average-days-to-pay information for individual customers.
  3. Advance Sales Tax Canadian GST/PST, tax schedules for multiple jurisdictions, and tax-on-tax calculations are all part of this feature.
  4. Balance Forward or Open item Customers Process all accounts receivable on a balance-forward or open-item basis and assign the open-item or balance-forward method to individual customers.
  5. International Address Capability Customer masterfiles include three address lines to handle international numbers: country code, international postal codes, and an expanded telephone number field.
  6. Credit Card Processing for Cash Receipts Posting of credit card payments can be done with or without the Credit Card Processing module. When the module is used, functionality is further enhanced through automated authorizations and integration with credit card settlement reports.
  7. Customer Delete Renumber and/or Merge Automatically delete, renumber, or merge customer numbers without having to renumber or merge customer information manually.
  8. Invoice Entry Automatically calculates due dates, discount due dates, discount amounts, and commission amounts for invoice entries. Use sales codes to obtain price and cost-of-goods-sold information. Enter unlimited sales codes, miscellaneous charges, and comment lines for each invoice in an easy-to-use grid-based entry window.
  9. Repetitive Invoie Processing Automatically process repetitive billing, such as membership fees, maintenance contracts, and rent.
  10. Invoice History Printing Prints history invoices for customer numbers, invoice numbers, and invoice dates. Reprint Accounts Receivable, Job Cost, and Sales Order invoices separately or all at once using the same form code or print only unpaid invoices for open-item customers. Reprint individual invoices from the drill-down screen in invoice history.
  11. Cash Receipts Processing Automatically applies cash receipts against the oldest invoices or against specific invoices. It allows you to post miscellaneous cash receipts directly against General Ledger accounts and process any prepayments against invoices not yet recorded.
  12. Statement Printing Print statements for a billing cycle, for example monthly or quarterly, on standard or custom forms for all customers or for a specific group of customers. You can also print statements based upon a minimum balance. Statements can be faxed directly from within Sage 100 ERP either individually or in batches.
  13. Customer Masterfile Audit This feature provides an audit trail of changes made to the Accounts Receivable customer masterfile. Use the Customer Masterfile Audit Report to review any changes, deletions, or additions to the customer masterfile.
  14. Memo Management Accurately and simply apply checks, cash, or credit card payments. Assign memos to specific customers and have them automatically display from related data entry points throughout the system including sales order entry and cash receipts. View attachments associated with the memo in addition to establishing expiration dates.

The multiple features of the Accounts Receivable module allow divisional accounting, use of multiple bank accounts, audit trails, the ability to add new customers and codes “on the fly,” automatic processing of repetitive billing, statement printing on standard or custom forms, advanced sales tax support, extensive reporting, and so much more.

A comprehensive module, Accounts Receivable also integrates with General Ledger, Sales Order, Inventory Management, Job Cost, Bank Reconciliation, e-Business Manager, and Custom Office. The Sage 100 ERP Accounts Receivable module is second to none in the industry and of cource Business Information Systems backs you 100 percent.

for questions and more information on the sage 100 erp accounts receivable module's features and benefits contact business information system a sage authorized partner reseller and software support providerQuestions? Contact BIS

For question and more information on the Sage 100 ERP Accounts Receivable module’s features and benefits, contact Business Information System – a Sage Authorized Partner, Reseller, Software Support, and Solution Provider.


Sage 100 ERP Accounts Receivable Overview Support Information for the Main Menu Tasks

Details of Sage 100 Accounts Receivable Main Menu

…about this…

sage 100 erp accounts receivable A/R module main menu customer maintenance taskAccounts Receivable Customer Maintenance

Use Customer Maintenance to create and maintain detailed records for each of your customers. This task provides several major functions that allow you to set up, maintain, and inquire about customers, including:

sage 100 erp accounts recceivable customer maintenance task user support options User & Support Options

  1. Viewing sales history for the selected customer by period by year.
  2. Creating and maintaining multiple contacts for customers and ship-to addresses.
  3. Defining electronic delivery options for invoices, statements, sales orders, and RMAs.
  4. Assigning a new customer number to any current customer.
  5. Displaying additional customer information, such as sales tax and credit card information.
  6. Assigning tax schedules and exemptions for each ship-to address.
  7. Selecting a primary credit card for the customer.
  8. Viewing customer sales and payment history information.
  9. Viewing open invoices by customer, along with a breakdown by aging category of total invoiced amounts due.
  10. Defining customers as bill-to and/or sold-to customers.
  11. Viewing open orders for a specific customer.

sage 100 erp accounts receivable customer maintenance task setup integration optionsSetup & Integration Options

  1. Deleting a relationship between a customer and Sage CRM company automatically deletes the customer contact and ship-to address relationships for that customer and company.
  2. Customer records can be deleted only if there is no outstanding activity for that customer.
  3. If there is activity, such as pending orders or e-mails for the customer, you must wait until all open invoices for the customer are paid and purged before you proceed with the record deletion, or use the Delete and Change Customers utility.
  4. If a customer with a Sage CRM relationship is deleted, the relationship with the Sage CRM company is deleted, but the Sage CRM company record itself is not deleted from the Sage CRM system.
  5. The Sage CRM Prospects customer in Sage 100 ERP cannot be deleted, copied, or renumbered in Customer Maintenance.
  6. When this task is accessed from Sage CRM, the system date is automatically used as the accounting date.

sage 100 erp crm integration options for accounts receivable customer maintenaceIf the Customer Relationship Management module is set up:

  1. You can create and maintain relationships between customers and Sage CRM companies.
  2. You can also maintain the Sage CRM Prospects customer, which is a single shared customer record in Accounts Receivable that allows you to define default information for all Sage CRM prospect companies that are not related to Accounts Receivable customers. The Sage CRM Prospects information is then defaulted into all prospect quotes.
  3. The Sage CRM Prospects customer record in Sage 100 ERP represents multiple prospect companies in the Sage CRM system; therefore, do not enter specific information for this customer record unless it can be used for all prospect quotes.
  4. If a relationship is created between a customer and Sage CRM company, relationships for customer contacts and ship-to addresses can be created separately in Customer Contact Maintenance and Customer Ship-To Address Maintenance.

view the sage 100 erp demo of the accounts receivable customer maintenace taskView the Sage 100 ERP Demo of the Accounts Receivable Customer Maintenance Task

Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Maitenance Task.

sage 100 erp accounts receivable module main menu customer inquiry taskAccounts Receivable Customer Inquiry

Customer Inquiry is used to view customer maintenance.

sage 100 erp interactive screenshot of accounts receivable customer inquiry taskClick to View the Sage 100 ERP Demo of the Accounts Receivable Customer Inquiry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Inquiry Task.

sage 100 erp accounts receivable module main menu inquiry inquiry taskAccounts Receivable Invoice History Inquiry

Invoice History Inquiry Task is used to view detailed or summary invoice information. Use this task for access to invoice history information when handling a customer phone inquiry.

sage 100 erp invoice history inquiry task setup and integration otpionsSetup & Integration Options

  1. This task is available only if Yes or Summary is selected in the Retain in Detail field in Accounts Receivable Options.
  2. If the Sales Order module is installed and set up, you can access sales order invoice information for invoices entered in both modules.
  3. If the Accounts Receivable module is integrated with Job Cost, you can access Job Cost retention information.

sage 100 erp demo of the accounts receivable invoice history inquiry taskView the Sage 100 ERP Demo of the Accounts Receivable Invoice History Inquiry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Invoice History Inquiry Task.

sage 100 erp accounts receivable module main menu repetitive invoice entry taskAccounts Receivable Repetitive Invoice Entry

Accounts Receivable Repetitive Invoice Entry is used to create and maintain repetitive invoices for receivable items such as rent or service contracts. After the items are set up, they can be selected as necessary and transferred to Invoice Data Entry automatically for processing. Each time a repetitive invoice is processed, the last billed date on file for the invoice is updated.

sage 100 erp repetitive invoice entry task user support options User & Support Options

  1. When entering a new repetitive invoice, you can copy information from an existing customer’s repetitive invoice to the new one.

sage 100 erp accounts receivable repetitive invoice entry task setup and integration optionsSetup & Integration Options

  1. If the Allow Credit Cards check box is selected in Accounts Receivable Options, the Credit Card tab appears allowing you to enter information pertaining to the credit card record, including billing information, corporate card information, and transaction information.
  2. You can also clear credit card information that defaults from the customer for the current transaction.
  3. You can access Sage Exchange to enter and store sensitive credit card information.
  4. If the Job Cost module is integrated with Accounts Receivable, use Repetitive Invoice Entry to create and maintain a file of recurring invoices for job-related receivable items such as rent or service contracts. Also, do monthly and quarterly service-type billing, which must be done to track profit for service-type jobs. Repetitive invoicing for jobs does not allow for retention entries. Customer numbers are assigned to a job in Job Masterfile Maintenance.

sage 100 erp accounts receivable Repetitive Invoice Entry Setup & Integration OptionsView the Sage 100 ERP Demo of the Accounts Receivable Repetitive Invoice Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click View the Sage 100 ERP Demo of the Accounts Receivable Repetitive Invoice Entry Task.

sage 100 erp accounts receivable module main menu repetitive invoice selection taskAccounts Receivable Repetitive Invoice Selection

Repetitive Invoice Selection is used to select recurring invoices when you are ready to invoice customers. You can select a customer number range, reference code range, and/or select cycles. You can also enter a starting invoice number which is used by the system to automatically assign invoice numbers to the selected repetitive invoices.

sage 100 erp repetitive invoice selection task user support options User & Support Options

  1. The invoices selected are transferred automatically from Repetitive Invoice Entry to Invoice Data Entry. If you have no changes to make to any of the repetitive invoices selected, print the invoices after the selection process is completed, print the Sales Journal, and update the permanent files.
  2. Repetitive invoices can be selected and processed along with a batch of regular invoices, or they can be processed separately.
  3. You must print the Sales Journal and perform the subsequent update in order to transfer the repetitive invoice data to the permanent files.
  4. To modify repetitive invoice information before printing invoices (for example, to add a last-minute freight charge, make a change in the salesperson commission rate, or enter the CVV number for credit card transactions), use Invoice Data Entry. Taxes will be recalculated for selected invoices.

sage 100 erp repetitive invoice selection task setup and integration optionsSetup & Integration Options

  1. If the CVV number for credit card transactions is not submitted to Sage Exchange in Invoice Data Entry, the credit card company may charge a higher transaction fee.
  2. Only invoices for which the Print Invoice check box is selected in Repetitive Invoice Entry can be printed.
  3. If the Job Cost module is integrated with Accounts Receivable, Repetitive Invoice Selection can be used to select recurring invoices for job-related receivable items. When allowed job statuses are defined in Job Status Maintenance, the system checks for allowed job statuses only when a job number is first entered in a data entry window. Changing a job status from allowed to not allowed does not affect existing records. The system will not check for allowed job statuses when selecting transactions for Repetitive Invoice Selection.

view the sage 100 erp demo of the accounts receivable repetitive invoice data selection taskView the Sage 100 ERP Demo of the Accounts Receivable Repetitive Invoice Data Selection Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Repetitive Invoice Data Selection Task

sage 100 erp accounts receivable module main menu invoice data entry taskAccounts Receivable Invoice Data Entry

Accounts Receivable Invoice Data Entry is used to enter information necessary for preparing customer invoices and provide a first step toward evaluating and processing your receivables. All invoices, debit memos, credit memos, and adjustments to previously recorded invoices must first be entered here.

sage 100 erp invoice data entry task user support options User & Support Options

  1. If your business handles over-the-counter sales, use Invoice Data Entry to record the sale and produce an invoice.
  2. Invoices that are entered but not yet updated can be maintained when necessary.
  3. Check your invoice entries for accuracy by reviewing the Sales Journal prior to completing the update.
  4. If you are currently using a manual Accounts Receivable system or a different computerized system, you must perform certain preliminary data entry procedures to ensure that your accounting records are in balance.
  5. Adjustments print on a customer’s invoice and/or statement. Internally, the adjustments print on the Sales Journal and the Daily Transaction Register. If a debit memo or credit memo is applied to a specific invoice, the appropriate invoice number is also shown on these reports. You can also use the Match Credits to Open Invoices task.
  6. Debit memos are generally issued to an account for billing errors, freight not billed, or other miscellaneous, charges; credit memos are typically used to credit an account for returned goods. Enter the debit or credit memo as a positive amount. The system recognizes the -DM or -CM invoice type and automatically reverses the amount signs, when necessary, before applying the amount to the proper account.

sage 100 erp invoice data entry task set and integration optionsSetup & Integration Options

  1. If the Job Cost module is integrated with Accounts Receivable, you can enter the job number and retention that will print on the invoice and sales journal. For normal job-related billing, Job Billing Data Entry should be used. You can use Invoice Data Entry to enter invoices that are not related, that are not work-in-process billings, or to make adjustments to job-related invoices. This task does not relieve work-in-process accounts for job-related invoices.
  2. If the Allow Credit Cards check box is selected in Accounts Receivable Options, the Credit Card tab appears allowing you to enter information pertaining to the credit card record, including billing information, corporate card information, and transaction information. You can also clear credit card information that defaults from the customer for the current transaction.
  3. You can access Sage Exchange to enter and store sensitive credit card information.

view the sage 100 erp demo of the accounts receivable invoice data entry taskView the Sage 100 ERP Demo of the Accounts Receivable Invoice Data Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Invoice Data Entry Task.

sage 100 erp accounts receivable module main menu invoice printing taskAccounts Receivable Invoice Printing

Accounts Receivable Invoice Printing is used to print invoices entered in A/R Invoice Data Entry for your customers. Recurring invoices selected in Repetitive Invoice Selection can also be printed from this window.

sage 100 erp accounts receivable invoice printing task user support options User & Support Options

  1. After you have printed invoices, you can print the Sales Journal and the Gross Profit Journal (optional), which contain cost of goods sold, commission, and tax information.
  2. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the invoices to the general ledger and post the receivable amounts to customers’ account.
  3. IMPORTANT: The Invoice and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

sage 100 erp accounts receivable invoice printing task setup and integration optionsSetup & Integration Options

  1. In the Print Invoices window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  2. Invoice forms, as with any Sage 100 ERP form, it can be modified as necessary using Crystal Reports Designer.
  3. If the Allow Batch Entry for Invoicing check box is selected in Accounts Receivable Options, invoices entered by batch can also be printed.
  4. If the Job Cost module is integrated with Accounts Receivable, invoices relating to a job can print job number and retention amount information.
  5. If the Allow Credit Cards check box is selected in Accounts Receivable Options and you have invoices with credit card transactions, the credit card payment amount appears on the invoice and is reflected in the invoice balance.

sage 100 erp interactive screenshots demo of the accounts receivable invoice printing taskView the Sage 100 ERP Demo of the Accounts Receivable Invoice Printing Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Invoice Printing Task.

sage 100 erp accounts receivable module main menu sales journal taskAccounts Receivable Sales Journal

The Accounts Receivable Sales Journal is an accounting report register that is used to print the information entered in the corresponding invoice and/or repetitive invoice data entry window and is used to review transactions prior to posting and updating the General Ledger.

sage 100 erp accounts receivable sales journal update report user support options User & Support Options

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the invoices to the general ledger and post the receivable amounts to customers’ account.
  2. Note: The Invoice and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

sage 100 interactive screenshots demo of the accounts receivable sales journal update reportView the Sage 100 ERP Demo of the Accounts Receivable Sales Journal Update Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Sales Journal Update Report.

sage 100 erp accounts receivable module main menu cash receipts entry taskAccounts Receivable Cash Receipts Entry

Accounts Receivable Cash Receipts Entry is used to enter cash receipts header information. Cash and credit card transactions can be included in one deposit.

sage 100 erp accounts receivable cash receipts entry task user support options User & Support Options

  1. You can process any number of cash or credit card deposits for a single day.
  2. For each deposit, you must enter the corresponding deposit amount that represents the total of all checks and/or credit card payments deposited.
  3. Before completing the entry, the system automatically compares the deposit amount against the total of all checks and/or credit card payments entered to ensure accurate entry of data.

sage 100 erp accounts receivable cash receipts entry task setup and integration optionsSetup & Integration Options

  1. Only use the Delete button to cancel the entire deposit. When attempting to delete credit deposits that include authorized credit card receipts, the Delete button is available only with the appropriate security setup.

sage 100 erp interactive screenshots of the accounts receivable cash receipts entry taskView the Sage 100 ERP Demo of the Accounts Receivable Cash Receipts Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Cash Receipts Entry Task.

sage 100 erp accounts receivable module main menu cash receipts journal taskAccounts Receivable Cash Receipts Journal Update Report

Accounts Receivable Cash Receipts Journal is an accounting report register that is used to print the information entered in the corresponding cash receipts deposit data entry window and is used to review transactions prior to posting and updating the General Ledger.

sage 100 ero accounts receivable cash receipts jpurnal update report user support options User & Support Options

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the deposits to the general ledger.
  2. IMPORTANT: The Deposit and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

view the sage 100 erp interactive screenshots demo of the accounts receivable cash receipts journal update reportView the Sage 100 ERP Demo of the Cash Receipts Journal Update Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Cash Receipts Journal Update Report.

sage 100 erp accounts receivable module main menu daily transaction register taskAccounts Receivable Daily Transaction Register

The Daily Transaction Register is an accounting report register that is used to print the information entered in the corresponding data entry windows for the Accounts Receivable Main Task Folder and is used to review transactions prior to posting and updating the General Ledger.

sage 100 erp accounts receivable daily transaction register task user support options User & Support Options

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the transactions to the general ledger.
  2. IMPORTANT: The Invoice, Deposit, and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

view the dsage 100 erp interactive screenshots demo of the accounts receivable daily transaction register reportView the Sage 100 ERP Demo of the Accounts Receivable Daily Transaction Register Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Daily Transaction Register Report.

Sage 100 ERP Accounts Receivable Overview Support Information for the Reports Menu Tasks

Details of Sage 100 Accounts Receivable Reports Menu

…about this…

sage 100 erp accounts receivable module reports menu customer listingAccounts Receivable Customer Listing Report

The Accounts Receivable Customer Listing is an accounting report that is used to print a list of customer-related information.

sage 100 erp customer listing report user support options User & Support Options

  1. You can select to print only active, only temporary, only on credit hold, only inactive, or all customers in the customer number range selected.
  2. If the eBusiness Manager module is installed, you can also select to print Internet customers only.
  3. You can print tax exemption numbers, ship-to address information, credit card information, price level information, bill-to and sold-to information, split commission information, customer memos, and customer contacts for the selected range of customers.
  4. You can enter a selection of customer numbers and names, salespersons, customer types, sort fields, states, ZIP Codes, tax schedules, and user-defined fields (UDFs) to print.

sage 100 erp customer listing report setup and integration optionsSetup & Integration Options

  1. In the Print Listing window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  2. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp interactive screenshots of the accounts receivable customer listing reportView the Sage 100 ERP Demo of the Accounts Receivable Customer Listing Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Listing Report.

sage 100 erp accounts receivable module reports menu accounts receivable customer listing with balances reportAccounts Receivable Customer Listing with Balances Report

Customer Listing with Balances is an accounting report that is used to print a list of customer-related information, similar to the Customer Listing, as well as customer sales history data such as period-to-date, year-to-date, and prior-year sales.

sage 100 epr customer listing with balances user support options User & Support Options

  1. This report also allows you to print the customer data by any defined fiscal year or period.
  2. You can enter a selection of customer numbers and names, salespersons, customer types, sort fields, states, ZIP Codes, tax schedules, and user-defined fields (UDFs) to print.

sage 100 erp customer listing with balances report setup and integration optionsSetup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected and Bill To and Sold To Customers is selected in the Track Customer Sales History in Accounts Receivable By field in Accounts Receivable Options, a message appears stating that the sales information will be overstated when printing the report for both the bill-to and sold-to customers.
  2. In the Print Listing window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  3. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp interactive screenshots of the accounts receivable customer listing with balances reportView the Sage 100 ERP Demo of the Accounts Receivable Customer Listing with Balances Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Listing with Balances Report.

sage 100 erp accounts receivable module reports menu accounts receivable customer mailing labelsAccounts Receivable Print Customer Mailing Labels Task

Customer Mailing Labels is an operational form that is used to print customer names and addresses, as well as tax schedule and exemption numbers from the Exemption file onto labels. Options are available for aligning the data to fit the size of your labels and the format of your label sheets.

sage 100 erp print customer mailing labels task user support options User & Support Options

  1. You can select to print active only, inactive only, temporary only, or all customers in the selected range. You can also print multiple labels for each customer. Ship-to-address information can be printed instead of the customers’ regular address.
  2. You can print one type of label for correspondence and a different type of label to use on file folders or other internal records.
  3. You can also create formats to accommodate Rolo-Dex® cards, continuous form envelopes, or even personalized business letterhead.
  4. In addition to names and addresses, you can print any information contained in the Customer file, including phone numbers, contacts, reference numbers, and receivable balances

sage 100 erp print customer mailing labels task setup and integration optionSetup & Integration Options

  1. The standard, default format for customer mailing labels is contained in the Forms file. This format can be modified, or you can customize new formats to print customer information on a variety of forms.
  2. Customer Mailing Labels supports the use of Avery Labels.
  3. In the Print Form window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  4. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp interactive screenshots of the accounts receivable customer mailing labels taskView the Sage 100 ERP Demo of the Accounts Receivable Print Customer Mailing Labels Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Print Customer Mailing Labels Task.

sage 100 erp accounts receivable module reports menu customer memo printingAccounts Receivable Customer Memo Printing

Customer Memo Printing is operational form that is used to print a listing of memos containing information pertinent to specific customers. This report can contain recaps of customer correspondence, specific instructions regarding the maintenance of individual accounts, and overridden auto-display settings.

sage 100 erp customer memo printing task user support options User & Support Options

  1. You can enter a selection of customer numbers, memo codes, memo descriptions, memo dates, expiration dates, and starting and ending reminder dates to print.

view the sage 100 erp demo of the accounts receivable customer memo printing taskView the Sage 100 ERP Demo of the Accounts Receivable Customer Memo Printing Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Memo Printing Task.

sage 100 erp accounts receivable module reports menu accounts receivable aged invoice reportAccounts Receivable Aged Invoice Report

Accounts Receivable Aged Invoice is an accounting report that is used to provide a detailed list of invoices by customer number and by aging categories for all or for a selected range of customers. This report provides a concise overview of outstanding receivables balances and is useful for managing collections and achieving an efficient receivables turnaround.

sage 100 erp accounts receivable aged invoice report user support options User & Support Options

  1. You can include open invoices only, paid invoices only, or all invoices.
  2. You can specify complete invoice item detail, invoice information without item detail, or summary total information by customer. You can also include, and age, any credit memos issued during the selected period.
  3. You can enter a selection of customer numbers and names, salespersons, customer types, states, ZIP Codes, phone numbers, sort fields, customer purchase orders, and user-defined fields (UDFs) to print.
  4. Information is provided for any specific date as long as the date does not represent a period that is already closed, or the invoice date and the accounting date are not in the same accounting period.
  5. The report can include any one or all of the four aging categories specified in Accounts Receivable Options. For each invoice, the report shows the invoice number, invoice date, amount, due date, and discount due date (if applicable).
  6. Totals are printed by customer number and by division, with a grand total of all invoices shown as the report total.
  7. Invoices purged from the Accounts Receivable Open Invoices files do not display on the Accounts Receivable Aged Invoice Report, even when it is printed as of the last date.
  8. Records for paid invoices are purged by using the Remove Zero Balance Invoices utility.
  9. Paid invoice records are also removed during period-end and year-end processing based on the setting in the Days to Retain Paid Invoices field in Accounts Receivable Options.

sage 100 erp accounts receivable age invoice report setup and integration optionsSetup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options, the sold-to customer information can be included for the bill-to customer.
  2. If the Job Cost module is integrated with Accounts Receivable, the job number and retention balance are also printed for job-related invoices.
  3. If the Track Job Cost Retention Receivables check box is selected in Accounts Receivable Options, the Aged Invoice Report prints only three aging categories, instead of the standard four. The last column is used to print the retention balance. The aged invoice balance does not include the retention balance.
  4. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  5. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo of the accounts receivable aged invoice reportView the Sage 100 ERP Demo of the Accounts Receivable Aged Invoice Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
View the Sage 100 ERP Demo of the Accounts Receivable Aged Invoice Report.

sage 100 erp accounts receivable module reports menu accounts receivable trial balance reportAccounts Receivable Trial Balance Report

Accounts Receivable Trial Balance is an accounting report that is used to provide a complete recap of the Accounts Receivable invoices, detailing all receipts, adjustments, or other activities that affect the Accounts Receivable balances during a specified period.

sage 100 erp accounts receivable trial balance report user support options User & Support Options

  1. You can also use the Trial Balance report to reconcile the general ledger accounts receivable accounts. Information is organized by general ledger posting date (or transaction date).
  2. You can use this report to reconcile your general ledger to the balance of the Accounts Receivable account.
  3. You can select a range of customer numbers to include in the report. In addition, you can include all invoices on file, or select either open or paid invoices.
  4. You can print the transaction information in detail form, or summarized it by invoice.
  5. Print this report before performing period-end processing.

sage 100 erp accounts receivable trial balance report setup and integration optionsSetup & Integration Option

  1. The Aged Invoice Report uses the Invoice Date or Due Date (document date) specified in Accounts Receivable Options. The Trial Balance Report uses the transaction date (accounting date or posting date).
  2. If the Aged Invoice Report and the Trial Balance Report do not balance to each other, one or more invoices may have an invoice date and a transaction date that are not in the same period.
  3. When transaction detail prints, the payment type for credit card and other payment type transactions generated through the Sales Order module are added to the report.
  4. Information is provided for any specific date as long as the date does not represent a period that is already closed, or the invoice date and the accounting date are not in the same period.
  5. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  6. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo of the accounts receivable trial balance reportView the Sage 100 ERP Demo of the Accounts Receivable Trial Balance Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Trial Balance Report.

sage 100 erp accounts receivable module reports menu cash expectations reportAccounts Receivable Cash Expectations Report

The Cash Expectations Report is a financial report that is used to provide a summary of outstanding customer invoices due for up to four consecutive periods and one “future” period. This report provides a comprehensive picture of the cash you expect to receive within a given time frame. The “future” period will contain all cash expectations beyond the four periods.

sage 100 erp cash expectations report user support options User & Support Options

  1. Information on the report includes the customer number and name, invoice number and due date, available discount and due date, invoice balance, and aged payments due.
  2. Due dates can also be calculated using the average days to pay information for each customer.
  3. Totals are provided by customer and division, with a total of all payments due within the period-ending dates specified.

sage 100 erp cash expectations report setup and integration optionsSetup & Integration Options

  1. If the Job Cost module is integrated with Accounts Receivable, the job number and retention balance are printed for job-related invoices.
  2. If the Track Job Cost Retention Receivables check box is selected in the Accounts Receivable Options window, only three accounting periods can be printed. To replace the fourth accounting period, the retention balances for job invoices are printed on this report in a separate column. The retention amounts are not included in the cash expectation balances.
  3. Information is provided for any specific date as long as the date does not represent a period that is already closed, or the invoice date and the accounting date are not in the same accounting period. Entries made in the Ending Date fields must be prior to Ending Date 4.
  4. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  5. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view sage 100 erp demo of the accounts receivable cash expectations reportView the Sage 100 ERP Demo of the Accounts Receivable Cash Expectations Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Cash Expectations Report.

sage 100 erp accounts receivable module reports menu customer sales analysis reportAccounts Receivable Customer Sales Analysis

The Accounts Receivable Customer Sales Analysis financial report that is used to obtain a comprehensive recap of total sales, cost of goods sold, profit percentages, cash received, and finance charges. The total number of invoices and finance charges issued to each customer is also itemized.

sage 100 erp customer sales analysis report user support options Customer Sales Analysis Report User & Support Options

  1. Use information detailed in this report to compare sales activity by customer for any fiscal year and period defined, as well as by period-to-date, year-to-date, and prior-year data.
  2. Sales amount percent-of-total figures are printed only if the report is being ranked by period-to-date, year-to-date, or prior-year sales. The percentage shown represents the percentage of the total receivables each customer’s sales represents. If you have created divisions, divisional totals are also provided.
  3. Printing the Customer Sales Analysis report by salesperson reflects the customer sales, sorted by the default salesperson for each customer.
  4. The Sales Analysis by Salesperson report provides accurate information by the actual salesperson assigned to each invoice.
  5. Printing the Customer Sales Analysis report by salesperson reflects the customer sales, sorted by the default salesperson for each customer. The Sales Analysis by Salesperson report provides accurate information by the actual salesperson assigned to each invoice.

sage 100 erp customer sales analysis report setup and integration optionsSetup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected and Bill To and Sold To Customers is selected in the Track Customer Sales History in Accounts Receivable By field in Accounts Receivable Options, a message appears stating that the sales information will be overstated when printing the report for both the bill-to and sold-to customers.
  2. In the Print Invoices window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  3. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo interactive screenshots of the accounts receivable customer sales analysis reportView the Sage 100 ERP Demo of the Accounts Receivable Customer Sales Analysis Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Sales Analysis Report.

sage 100 erp accounts receivable module reports menu customer sales history by period reportAccounts Receivable Customer Sales History by Period Report

The Customer Sales History by Period is an accounting report that is used to print customer sales history information by period for a specified fiscal year.

sage 100 erp customer sales history by period report user support options Customer Sales History by Period Report User & Support Options

  1. You can sort the report by customer number, total dollars sold, total gross profit amount, and total gross profit percent. A total column, which reflects the total of all periods, prints after the last period for each item selected to print.
  2. A total for each division along with a report total prints except when sorting by total dollars sold, total gross profit amount, and total gross profit percent.
  3. You can enter a selection of customer numbers, total dollars sold, total gross profit amounts, and total gross profit percentages to print.

sage 100 erp customer sales history by period report setup and integration optionsSetup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected and Bill To and Sold To Customers is selected in the Track Customer Sales History in Accounts Receivable By field in Accounts Receivable Options, a message appears stating that the sales information will be overstated when printing the report for both the bill-to and sold-to customers.
  2. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  3. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo interactive screenshots of the accounts receivable customer sales history by perio reportView the Sage 100 ERP Demo of the Accounts Receivable Customer Sales History by Period Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Sales History by Period Report.

sage 100 erp accounts receivable module reports menu sales anlaysis by salesperson reportAccount Receivable Salesperson Sales History by Period Report

Salesperson Sales History by Period is an accounting report that is used to print salesperson sales history by period for a specified fiscal year.

sage 100 erp salesperson sales history by period report user support options User & Support Options

  1. You can sort the report by salesperson, total dollars sold, total gross profit amount, and total gross profit percent. A total column, which is the total of all periods, prints after the last period for each item selected to print.
  2. You can enter a selection of salespersons, total dollars sold, total gross profit amounts, total gross profit percentages, and customer numbers to print.
  3. A total for each division along with a report total prints except when sorting by total dollars sold, total gross profit amount, and total gross profit percent
  4. When printing the customer information, a subtotal is printed for each salesperson. The sales on the Salesperson Sales History by Period report reflect what was sold to the customer by the primary salesperson.

sage 100 erp salesperson sales history by period report setup and integration optionsSetup & Integration Options

  1. If the Include Sales Tax and Freight in Sales History check box is selected in the Accounts Receivable Options window, the report prints the sales tax and freight.
  2. In the Print Invoices window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  3. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo interactive screenshots of the accounts receivable salesperson sales history report by period reportView the Sage 100 ERP Demo of the Accounts Receivable Salesperson Sales History by Period Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Salesperson Sales History by Period Report.

sage 100 erp accounts receivable module reports menu sales anlaysis by salesperson reportAccounts Receivable Sales Analysis by Salesperson Report

The Sales Analysis by Salesperson is an accounting report that is used to obtain a recap of sales analysis information that can be sorted by salesperson, customer number, period-to-date sales, year-to-date sales, and prior-year sales for any fiscal year and period defined. Use this report to accurately reflect salesperson sales based on the salesperson assigned to each invoice.

sage 100 erp sales analysis by salesperson report user support options User & Support Options

  1. You can include period-to-date, year-to-date, or prior-year information, or you can incorporate all three periods.
  2. You can enter a selection of salespersons, customer numbers, period-to-date sales, year-to-date sales, prior-year sales, and user-defined fields (UDFs) to print.
  3. The information detailed in this report allows you to compare receivables activity by salesperson and customer for any of the three periods selected. If you have created divisions, divisional totals are also provided.

sage 100 erp sales analysis by salesperson report setup and integration optionsSetup & Integration Options

  1. The information detailed in this report allows you to compare receivables activity by salesperson and customer for any of the three periods selected. If you have created divisions, divisional totals are also provided.
  2. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  3. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp demo interactive screenshots of the accounts receivable sales analysis by salesperson reportView the Sage 100 ERP Demo of the Accounts Receivable Sales Analysis by Salesperson Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Sales Analysis by Salesperson Report.

sage 100 erp accounts receivable module reports menu salesperson commission reportAccounts Receivable Salesperson Commission Report

Salesperson Commission is an accounting report that list the details of commissions updated in the current period. Commission information for each salesperson includes the invoice number, the invoice date, and the total, as well as the cost, gross profit, and percent-of-profit earned. Totals are provided by customer and salesperson, followed by a total of all commissions reported.

sage 100 erp salesperson commission report user support options Salesperson Commission Report User & Support Options

  1. If you have divisionalized your Accounts Receivable, divisional totals are also provided.
  2. The report shows the invoice amount paid and the commission payable amount for invoices fully paid if the Commissions Paid on Paid Invoices Only check box is selected in the Accounts Receivable Options window.

sage 100 erp salesperson commission report setup and integration optionsSetup & Integration Options

  1. This report is available only if the Salesperson Commission Reporting check box is selected in the Accounts Receivable Options window.
  2. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  3. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo interactive screenshots of the accounts receivable salesperson commission reportView the Sage 100 ERP Demo of the Accounts Receivable Salesperson Commission Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
View the Sage 100 ERP Demo of the Accounts Receivable Salesperson Commission Report.

sage 100 erp accounts receivable module reports menu accounts receivable sales tax reportAccounts Receivable Sales Tax Report

The Accounts Receivable Sales Tax Report is an accounting report that provide a recap of all sales tax information by tax code.

sage 100 erp accounts receivable sales tax report user support options Report User & Support Options

  1. This report can be printed in summary or detail format and includes taxable sales, nontaxable sales, taxable freight, nontaxable freight, taxable tax, exempt amount, and sales tax amount for each tax code.
  2. The accumulated sales tax collected is printed for each tax code and primary tax code.
    1. Cleared information appears on the report with zero amounts for the taxable and nontaxable columns. Clear records are the result of using the AP from AR Clearing utility to pay off Accounts Receivable invoices that contain sales tax.
    2. Recap information appears on the report with the sales tax collected amount for the day. Recap records are the result of using the Cash Receipts Journal, Accounts Receivable Sales Journal, and Sales Order Sales Journal, these transaction register include invoices paid in full that contain sales tax.
  3. The Sales Tax Report reflects all sales tax from all invoices recorded since the last time the report was printed and the file was cleared.
  4. This report should be printed and the file be cleared before processing any invoices for the next tax reporting period.
  5. To purge sales tax detail, use the Purge Sales Tax History option in Period End Processing.

sage 100 erp accounts receivable sales tax report setup and integration optionsSetup & Integration Options

  1. This task is available only if the Sales Tax Reporting check box is selected in the Accounts Receivable Options window.
  2. The Accounts Receivable Sales Tax Report offers multiple print options.
  3. When the Print by Primary Tax Code check box is selected and your state is defined as the first tax code within the tax schedules, the report provides subtotals by all primary tax codes, as defined in Library Master Sales Tax Schedule Maintenance.
  4. If your state is defined as the first tax code within the tax schedules, the report also prints by state.
  5. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  6. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo interactive screenshots of the accounts receivable sales tax reportView the Sage 100 ERP Demo of the Accounts Receivable Sales Tax Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Sales Tax Report.

sage 100 erp accounts receivable module reports menu monthly sales reportAccounts Receivable Monthly Sales Report

The Accounts Receivable Monthly Sales Report is an accounting report that provides a recap of all sales activities for the period recorded in the Accounts Receivable module. All invoices recorded using Invoice Data Entry, Cash Receipts Entry, and the Sales Order module are included on this report.

sage 100 erp monthly sale report user support options User & Support Options

  1. If you have created divisions, this report is sorted by division. Invoices within each division are sorted by customer number and sorted further by invoice number.
  2. The invoice information detailed by this report includes the invoice date, due date, and discount date. The transaction information included specifies the transaction type, date, and amount.
  3. Any prepayments applied to each invoice are also specified. Invoices are subtotaled by customer number and totaled by division. Report totals are also provided.
  4. You can enter a selection of customer numbers, invoice numbers, and user-defined fields (UDFs) to print.

sage 100 erp monthly sales report setup and integration optionsSetup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options, the sold-to customer information can be included on the report.
  2. This report is cleared during period-end processing.
  3. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  4. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp demo interactive screenshots of the accounts receivable monthly sale reportView the Sage 100 ERP Demo of the Accounts Receivable Monthly Sales Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Monthly Sales Report.

sage 100 erp accounts receivable module reports menu cash receipts reportAccounts Receivable Cash Receipts Report

Accounts Receivable Cash Receipts is an accounting report that provides a recap of all cash receipts processed for a specified date using Cash Receipts Entry. The information for each deposit includes the deposit date and number, as well as the customer name and number.

sage 100 erp cash receipts report user support options User & Support Options

  1. All checks deposited and all invoices (or miscellaneous general ledger distribution) to which they are applied are detailed along with the cash amounts applied, discounts applied, and invoice balance information. Totals are provided by deposit number, deposit date, and bank code.
  2. You can enter a selection of customer numbers, bank codes, deposit dates, check numbers, and user-defined fields (UDFs) to print.

sage 100 erp cash receipts report setup and integration optionsSetup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options, the sold-to customer information can be included on the report.
  2. The Monthly Cash Receipts Report does not reflect credit card transactions. The Deposit Transaction Report includes sales order deposits (paid by cash or credit card) entered and updated in the Sales Order module, as well as credit card receipts entered in Cash Receipts Entry.
  3. In the Print Invoices window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  4. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

view the sage 100 erp interative screenshot demo of the accounts receivable cash receipt reportView the Sage 100 ERP Demo of the Accounts Receivable Cash Receipts Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Cash Receipts Report.

sage 100 erp accounts receivable module reports menu accounts receivable invoice history reportInvoice History Report

The Accounts Receivable Invoice History Report is an accounting report that is used to to obtain a detailed listing of invoice information recorded using Invoice Data Entry.

invoice history report user support options Invoice History Report Options

  1. If the Sales Order or Job Cost module is integrated with Accounts Receivable, you can also access invoice history information for invoices entered through those modules.
  2. You can enter a selection of invoice numbers, customer numbers and names, salespersons, ship-to states, bill-to states, customer purchase orders, sales order numbers, invoice dates to print, and user-defined fields (UDFs) to print. The customer number and name, billing address, ship-to address, and invoice total appear for each invoice.
  3. Line item detail information can also be provided for each invoice.

invoice history report setup and integration optionsInvoice History Report Setup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options, the bill-to customer information can be included on the report.
  2. If the Purchase Order module is set up, the purchase order number and purchase order required date can be included on the report.
  3. If the Job Cost module is integrated with Accounts Receivable, you can print job number and retention balance information for job-related invoices. If the Job Cost module is integrated with Sales Order, you can print the job number, retention amount, cost code, and cost type for invoices updated from the Sales Order module.
  4. Line item detail information for time and material invoices processed through the Job Cost module is summarized as a single line on this report.
  5. If the Customer Relationship Management module is set up, the Sage CRM user, company, opportunity, and person information prints for invoices created from Sage CRM orders if the fields are added to the form using the SAP Crystal Reports software.
  6. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.
  7. In the Print Report window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.

sage 100 erp interactive screenshots of the accounts receivable invoice history reportSage 100 ERP Interactive Screenshots of the Accounts Receivable Invoice History Report:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable Invoice History Report – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu accounts receveible analysisAccounts Receivable Analysis

The Accounts Receivable Analysis is a management report consisting of a statistical summary of receivables activity and an aging recap for up to six consecutive closed periods within the current year.

accounts receivable analysis user support options Accounts Receivable Analysis User & Support Options

  1. Reporting is based on the current module date and includes previously closed periods (processed through period-end processing.
  2. Information reported includes total Accounts Receivable dollars, the percentage of change over the prior period(s), the total number of invoices, and a breakdown by period of invoices overdue.
  3. The aging recap portion of the report includes data for up to six previously closed periods. For example, if you set up your system in January, and run this report in March, periods 1 and 2 (January and February) are the only previous closed periods reflected.

sage 100 erp interactive screenshots of the accounts receivable analysisSage 100 ERP Interactive Screenshots of the Accounts Receivable Analysis:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable Analysis – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu accounts receveible analysis reportAccounts Receivable Analysis Report

Accounts Receivable Analysis Report is an in-depth management report consisting of an aging recap and statistical summary of receivables activity for up to six consecutive closed periods within the current year. The statistical summary indicates whether Accounts Receivable activity is increasing or decreasing in comparison to prior periods and what proportion of the receivables is not current.

accounts receivable analysis user support options Accounts Receivable Analysis Report User & Support Options

  1. Reporting is based on the current module date and includes previously closed periods (processed through period-end processing.
  2. Information is accumulated from the Open Invoices file and includes, total Accounts Receivable dollars, the percentage of change over the prior periods, the total number of invoices, and a breakdown by period of overdue invoices. The aging of invoices is based on the Aging Categories field in the Accounts Receivable Options window.
  3. Statistical data includes percentage comparisons of Accounts Receivable dollars as of the current module date and aged over the previous period and the remaining period average.
  4. The aging recap portion of the report includes data for up to six previously closed periods. For example, if you set up your system in January, and run this report in March, periods 1 and 2 (January and February) are the only previous periods reflected.

analysis report setup and integration optionsAccounts Receivable Analysis Report Setup & Integration Options

  1. In the Print Reports window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  2. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp interactive screenshots of the accounts receivable analysis report:Sage 100 ERP Interactive Screenshots of the Accounts Receivable Analysis Report:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable Analysis Report – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu general ledger posting recap reportAccounts Receivable General Ledger Posting Recap

The General Ledger Posting Recap is an accounting register report that provides a detailed recap, by general ledger account number, of all transactions posted from the the General Ledger module.

general ledger posting recap report user support options General Ledger Posting Recap Rerport User & Support Options

  1. This report only includes transactions printed on the Daily Transaction Register and updated to the general ledger. Like the Daily Transaction Register, the General Ledger Posting Recap itemizes each transaction and lists the corresponding debit and credit amounts.
  2. You can also print a summarized version of the report.
  3. The General Ledger Posting Recap displays totals for all transactions posted to each account.
  4. You can enter a selection of posting dates to print. The report total shows the grand total of all posting activity through the specified ending date.

general ledger posting recap task setup and integration OptionsGeneral Ledger Posting Recap Report Setup & Integration Options

  1. In the Print Reports window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  2. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

Sage 100 ERP Interactice Screenshots of the Accounts Receivable General Ledger Posting Recap Report:Sage 100 ERP Interactive Screenshots of the Accounts Receivable General Ledger Posting Recap Report:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts General Ledger Posting Recap Report – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu invoice history printingAccounts Receivable Invoice History Printing

Accounts Receivable Invoice History Printing Task is use to print history invoices for a range of customer numbers, invoice numbers, and invoice dates.

sage 100 erp Invoice History printing task user support options Invoice History Printing Task User & Support Options

  1. You must print the different types of invoices separately. You can print only unpaid invoices for open item customers, which shows past due invoices for collection purposes.

sage 100 erp invoice history printing task setup & integration optionsInvoice History Printing Task Setup & Integration Options

  1. If the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options, the bill-to customer number and name can be included.
  2. If the Allow Credit Cards check box is selected in Accounts Receivable Options and you have invoices with credit card transactions, the credit card payment amount appears on the invoice and is reflected in the invoice balance.
  3. If the Customer Relationship Management module is set up, the Sage CRM user, company, opportunity, and person information prints for invoices created from Sage CRM orders if the fields are added to the form in the Crystal Reports software.
  4. If the Job Cost module is integrated with Accounts Receivable, you can print job number and retention balance information for job-related invoices. If the Job Cost module is integrated with Sales Order, you can print the job number, retention amount, cost code, and cost type for invoices updated from the Sales Order module.
  5. The retention amount appears only if the Track Job Cost Retention Receivables check box is selected in Accounts Receivable Options.

sage 100 erp interactive screenshots of the accounts receivable invoice history printing taskSage 100 ERP Interactive Screenshots of the Accounts Receivable Invoice History Printing Task:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable History Invoice Printing Task – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu customer audit reportAccounts Receviable Customer Audit Report

The Accounts Receivable Customer Audit Report is used to track changes, deletions, and additions to customer information. This report prints changes made to data fields, including changes created “on the fly,” and notes the date and user code or workstation ID.

sage 100 erp user support options Customer Audit Report User & Support Options

  1. You can enter a selection of user logons or workstation names, and transaction dates. By entering these selections, you can obtain a report that allows you to identify pertinent information.
  2. If you do not purge the Customer Audit file after printing the Customer Audit Report, the transaction information remains in the file and is available for future reporting needs.

Customer Audit Report Setup & Integration Options

sage 100 erp user support options Customer Audit Report Setup & Integration Options

  1. This report is not available if No is selected in the Track Customer Changes field in the Accounts Receivable Options window.

sage 100 erp interactive screenshpts of the accounts receivable customer audit reportSage 100 ERP Interaction Screenshots of the Accounts Receivable Customer Audit Report:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable Customer Audit Report – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu deposit transaction reportAccounts Receivable Deposit Transaction Report

The Accounts Receivable Deposit Transaction Report is used to provide a history of deposit payment transactions processed by the system. The report prints in payment type/invoice number order.

sage 100 erp deposit transaction report user support options Deposit Transaction Report User & Support Options

  1. When the report prints, you can then purge the printed transactions. All transactions within the printed range are deleted.
  2. The Deposit Transaction Report includes sales order deposits (paid by cash or credit card) entered and updated in the Sales Order module, and credit card deposits recorded in Cash Receipts Entry.

sage 100 erp deposit transaction report setup & integration optionsDeposit Transaction Report Setup & Integration Options

  1. This task is available only if an option other than None is selected in the Retain Deposit Transaction History field in Accounts Receivable Options.

sage 100 erp interactive screenshots of the accounts receivable deposit transaction reportSage 100 ERP Interactive Screenshot Demo of the Accounts Receivable Deposit Transaction Report:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable Deposit Transaction Report – Sage 100 ERP Interactive Demo.

sage 100 erp accounts receivable module reports menu credit card settlement reportAccounts Receivable Credit Card Settlement Report

Credit Card Settlement Report

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.

sage 100 erp accounts receivable module reports menu customer pricing reportAccounts Receivable Customer Pricing Report

The Accounts Receivable Customer Pricing Report is used to produce a list of customer’s special pricing and discounts, including customers that have been set up with product line/price level records.

sage 100 erp customer pricing report user support options User & Support Options

  1. You can enter a selection of customers, item codes, product lines, price codes, price levels, and item categories (if descriptions have been entered in Inventory Management Options).
  2. You can also print or suppress product line information, weight, item categories, bill-to customer numbers (if the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options), and/or customer pricing information such as the price code, price level, and price source.

sage 100 erp custome pricing report setup & integration optionsCustomer Pricing Report Setup & Integration Options

  1. In the Print Reports window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  2. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp inteeactive screenshots of the accounts receivable customer pricing reportSage 100 ERP Interactive Screenshots of the Accounts Receivable Customer Pricing Report:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Accounts Receivable Customer Pricing Report – Sage 100 ERP Interactive Demo.

Sage 100 ERP Accounts Receivable Overview Support Information for the Period End Menu Tasks

Details of Sage 100 Accounts Receivable Period End Menu

…about this…

sage 100 erp accounts receivable module period end menu finance charge calculationAccounts Receivable Finance Charge Calculation

The Accounts Receivable Finance Charge Calculation task is used to calculate finance charges on overdue amounts before printing customer statements.

sage 100 erp accounts receivable finance charge calculation task user support options User & Support Options

  1. You can specify a customer number range, aging date, statement cycle (monthly, bimonthly, etc.), and minimum balance to use in the calculation.
  2. Finance charges are calculated for all customers and all statement cycles, as of the current date, and are based on the minimum overdue balance for applying a finance charge established in Accounts Receivable Options.
  3. When the calculations are completed, you can calculate the finance charge for another range of customers, or print the Finance Charge Journal.
  4. If you click Clear after a calculation is performed, but before the Finance Charge Journal is updated, the calculated finance charges are deleted and are not applied against the customer’s unpaid balance.
  5. If invoices must be printed for finance charges, you can create finance charge invoices from the Invoice Data Entry window by typing an –FC in the Invoice No. field.
  6. If applying finance charges is an exception rather than a common practice in your business, you may want to skip the Finance Charge Calculation task and enter the finance charges individually in Finance Charge Entry.

sage 100 erp accounts receivable finance charge calculation setup & integration optionsSetup & Integration Options

  1. If None is selected in the Computation Method field in the Accounts Receivable Options window, Finance Charge Calculation is not available.

sage 100 erp interactive screenshots demo of the accounts receivable finance charge calculation taskView the Sage 100 ERP Demo of the Accounts Receivable Finance Charge Calculation Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Finance Charge Calculation Setup Task.

sage 100 erp accounts receivable module period end menu finance charge entryAccounts Receivable Finance Charge Entry

Finance Charge Entry is used to manually apply finance charges to individual customers or to adjust calculated finance charges automatically.

sage 100 erp finance charge entry task user support options User & Support Options

  1. If applying finance charges is an exception rather than a rule, you may want to skip Finance Charge Calculation and enter the charges using this task.
  2. At the completion of Finance Charge Entry, you can print the Finance Charge Journal to review your entries for accuracy.
  3. The information can then be updated, and the finance charges are reflected on the customers’ next statements.
  4. The aging categories displayed are Days or Months, depending on whether Days or Months is selected in the Aging Categories to Be Used field in the Accounts Receivable Options window.
  5. If you use the Fixed method for calculating finance charges, the fixed amount entered in Accounts Receivable Options is added to the customer balance automatically unless a different amount was entered for specific customers in the Customer file.
  6. If you use the Percentage method for calculating finance charges, the percentage entered in Accounts Receivable Options is used to perform the calculation.
  7. If a different percentage is on file for individual customers in the Customer file, that percentage is used instead. If the calculated finance charge is not greater than the minimum finance charge amount entered in Accounts Receivable Options, the minimum finance charge amount is used instead.
  8. If a Blank percentage or Blank amount is on file for any customers in the range selected, no finance charge is calculated.
  9. Cash customers cannot be entered in Finance Charge Entry.

sage 100 erp accounts receivable finance charge entry task setup and integration optionsSetup & Integration Options

  1. This task is available only if Fixed or Percent is selected in the Computation Method field in the Accounts Receivable Options window.
  2. If invoices must be printed for finance charges, you can create finance charge invoices from the Invoice Data Entry window by typing an –FC in the Invoice No. field. For more information, see Invoice Data Entry.

view the sage 100 erp interactive srceenshots demo of the accounts receivable finance charge entry taskView the Sage 100 ERP Demo the Accounts Receivable Finance Charge Journal Entry Period End Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo the Accounts Receivable Finance Charge Journal Entry Period End Task.

sage 100 erp accounts receivable module period end menu finance charge journalAccounts Receivable Finance Charge Journal Update Report

The Finance Charge Journal is an accounting register update report that is used to print the information entered in the corresponding data entry windows, finance charge entry, and is used to review transactions prior to posting and updating the General Ledger.

sage 100 erp finance charge journal update report user support options User & Support Options

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the transactions to the general ledger.
  2. IMPORTANT: The Invoice, Deposit, Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

sage 100 erp interactive screenshots demo for the accounts receivable finance charge journal update reportView the Sage 100 ERP Demo of the Accounts Receivable Finance Charge Journal Update Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Finance Charge Journal Update Report.

sage 100 erp accounts receivable module period end menu statement printingAccounts Receivable Customer Statement Printing

The Accounts Receivable Customer Statement Printing to print statements for selected customers on preprinted statement forms or plain paper or email pdf.

sage 100 erp customer statement printing user support options User & Support Options

  1. Statements are printed using the information entered in Invoice Data Entry, Repetitive Invoice Entry, Cash Receipts Entry, Finance Charge Calculation, or Finance Charge Entry.
  2. Name and address information, and invoice and payment detail information can be printed. You can print statements for a range of customer numbers, a group of statement cycles and/or customers with a certain minimum balance, or by the aging category of the customer’s oldest balance.
  3. You can also print a separate bill-to statement for each sold-to customer, and you can include bill-to invoices on a sold-to customer statement.

sage 100 erp customer statement printing setup and integration optionsSetup & Integration Options

  1. If the Print Sold To Customer Number on Bill To Statements check box is selected in Accounts Receivable Options, the sold-to customer number is printed under the invoice number for those invoices that have a sold-to customer number.
  2. You can print customer statements only if the Print Customer Statements check box is selected in Accounts Receivable Options.
  3. Statements can also be e-mailed in PDF format to selected customers, if the E-mail Statements check box is selected in Accounts Receivable Options.
  4. Statements that have been set up as fax enabled can be batch faxed.
  5. If the Job Cost module is integrated with Accounts Receivable, the invoice retention can be printed for job-related invoices.
  6. In the Print Listing window you can save settings in this window by creating a new form code. Changes to settings for the STANDARD form code are not saved when you close the window.
  7. Reports, as with any Sage 100 ERP form or report, can be modified as necessary using Crystal Reports Designer.

sage 100 erp interactive screenshots demo of the accounts receivable csutomer statement printing taskView the Sage 100 ERP Demo of the Accounts Receivable Customer Statement Printing Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Customer Statement Printing Task.

sage 100 erp accounts receivable module period end menu commission edit maintenanceAccounts Receivable Commission Edit Maintenance

The Commission Edit Maintenance is used to edit any individual record in the Salesperson Commission file. Edited records are marked on the window display and the Commission Edit Register.

sage 100 erp commission edit maintenance task user support options User & Support Options

  1. Print the Salesperson Commission Report before making entries in Commission Edit Maintenance to review the commissions currently earned or due for payment.
  2. You can also use Commission Edit Maintenance with the Commission Edit Register to update the invoices for a specific salesperson to other modules.
  3. When adding commissions using Commission Edit Maintenance, amounts are written to the Salesperson Commission file, but not to the Salesperson file.
  4. The period-to-date and year-to-date values are not updated in the Salesperson file when commissions are manually entered or corrected using Commission Edit Maintenance. Totals need to be entered manually in Salesperson Maintenance.
  5. The Salesperson Commission Report should be printed after using Commission Edit Maintenance to verify changes.
  6. If you are not using Linkages, use Commission Edit Maintenance to change, add, or delete a record in the Salesperson Commission file, and then print the Salesperson Commission Report to verify changes.
  7. If you are using Linkages, use Commission Edit Maintenance to change, add, or delete a record in the Salesperson Commission file, and then print the Salesperson Commission Report and Commission Edit Register.
  8. Review the report and register for accuracy before updating the the Salesperson Commission file.
  9. Update to the respective modules and clear the Commission Edit Register.
  10. When the Commission Edit Register prints, the system validates that all salespersons with established links actually connect to a valid vendor, employee, or general ledger account.
  11. You are prompted to update to each module.

sage 100 erp commission edit maintenance task setup and integrtion optionsSetup & Integration Options

  1. This task is available only if the Salesperson Commission Reporting check box is selected in the Accounts Receivable Options window.

view the sage 100 erp interactive screenshots demo for the accounts receivable commission edit maintenance taskView the Sage 100 ERP Demo for the Accounts Receivable Commission Edit Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo for the Accounts Receivable Commission Edit Maintenance Task.

sage 100 erp accounts receivable module period end menu commsission edit registerAccounts Receivable Commission Edit Register Update Report

The Commission Edit Register is an accounting register update report that is used to print the information entered in the corresponding data entry windows, Commission Edit Mintenance, and is used to review transactions prior to posting and updating the General Ledger.

sage 100 erp commission edit maintenance task user support options User & Support Options

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the transactions to the general ledger.
  2. IMPORTANT: The Invoice, Deposit, Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

sage 100 erp interactive screenshots demo of the accounts receivable commission edit register update reportView the Sage 100 ERP Demo of the Accounts Receivable Commission Edit Register Update Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Commission Edit Register Update Report.

sage 100 erp accounts receivable module period end menu match credits to open invoicesAccounts Receivable Match Credits to Open Invoices

The Accounts Receivable Match Credits to Open Invoices is used to match credits automatically, such as prepayments, credit memos, and negative invoices, against open invoices in the Open Invoice file.

sage 100 erp match credit to open invoices task user support options User & Support Options

  1. You can perform global or selective matching of credits to outstanding invoices by invoice date or invoice number.
  2. There is no requirement that the invoice numbers and credit numbers must match.
  3. The Match Credits to Open Invoices Report shows all invoices for which the task automatically applies the credits.
  4. After printing and reviewing the report, you can update credit matches to the Accounts Receivable Open Invoice file and the Transaction and Payment History files.
  5. Review the Match Credits to Open Invoices report for accuracy before updating the Accounts Receivable files.
  6. Printing the journals or registers does not automatically update to the general ledger. After you print the journals or registers, you are prompted to update which clears the file and updates the transactions to the general ledger.
  7. IMPORTANT: The Invoice, Deposit, Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger or other module.
  8. WARNING: Do NOT, under any circumstances, interrupt the update process.
  9. Credit memos are created with a transaction type payment of CREDIT-X, with the transaction date and an offset amount to the open invoices selected for matching.

view the sage 100 erp interactive screeenshots demo of the accounts receivable match credits to open invoices taskView the Sage 100 ERP Demo of the Accounts Receivable Match Credits to Open Invoices Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Match Credits to Open Invoices Task.

sage 100 erp accounts receivable module period end menu period end report selectionAccounts Receivable Period End Report Selection

Period End Report Selection is used to select reports and financial report groups to print during period-end or year-end processing.

sage 100 erp accounts receivable period end report selection taskUser & Support Options

  1. You can print the default reports selected in the list, and select additional reports for printing. You can modify the number of copies to print and the printer to use on a report-by-report basis.
  2. The reports can be printed and/or exported to Paperless Office, to Data Only, or to paper.
  3. The selected reports can be printed in the Period End Report Selection window or in the Period End Reports window during period-end processing.

the sage 100 erp accounts receivable period end report selection group inludesThe Accounts Receivable Period End Report Selection Group Include:

  1. Accounts Receivable Aged Invoice Report.
  2. Accounts Receivable Trial Balance Report.
  3. Customer Sales Analysis.
  4. Sales Analysis by Salesperson Report.
  5. Salesperson Commission Report.
  6. Accounts Receivable Sales Tax Report.
  7. Monthly Sales Report.
  8. Cash Receipts Report.
  9. Accounts Receivable Analysis Report.
  10. Customer Sales History by Period.
  11. Salesperson Sales History by Period.

sage 100 erp accounts receivablee period end report selection task setup and integration optionsSetup & Integration Options

  1. If the Enable Electronic Delivery and PDF Storage check box is marked in Paperless Office Options you can save a couple trees :D.
  2. The reports and financial report groups displayed in the Period End Report Selection window must have already been defined.
  3. You can set up a predefined report setting for each report with options and selection criteria that are specifically used for period-end and year-end reporting purposes. For more information, see Create a Report Setting.
  4. This task is available only in some modules.

view the sage 100 erp interactive screenshots demo of the accounts receivable period end report selection taskView the Sage 100 ERP Demo of the Accounts Receivable Period Report Selection Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Period Report Selection Task.

sage 100 erp accounts receivable module period end menu period end processingAccounts Receivable Period End Processing

Period End Processing is use to automatically perform either period-end or year-end processing based on the period entered at the Current Period field in Accounts Receivable Options.

sage 100 erp accounts receivable period end processing task user support options User & Support Options

  1. Period End Processing allows you to close the current period and increment the accounting period forward to the next period. Period-end processing is usually performed at the end of each accounting period. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.
The following occurs during accounts receivable period-end or year-end:
  1. Temporary customers with zero balances are automatically purged during period-end and year-end processing unless you selected the Retain Temporary Customers Paid Invoices check box in Accounts Receivable Options.
  2. Monthly cash receipts history, customer sales history, and salesperson sales history is purged only during period year-end processing based on the selections made in the Years to Retain Cash Receipts History, Years to Retain Customer History, and Years to Retain Salesperson History fields in Accounts Receivable Options. For example, if the number of years to retain cash receipts history, customer sales history, and salesperson history is set to three years, sales and cash receipts history for the year 2014 will be purged when year-end processing is performed for the year 2016.
  3. Open invoices with zero balances are removed during period-end and year-end processing based on the number of days entered in the Days to Retain Paid Invoices field in Accounts Receivable Options.

If you have not already printed period-end reports, you can do so during period-end processing. Alternately, you can select and print period-end reports without accessing Period End Processing by using Period End Report Selection.

period end processing task setup and integration importnat information and optionsImportant Information

Backing up your data is an important part of your daily and monthly procedures. Back up all Accounts Receivable data before proceeding.

view the sage 100 erp interactive screenshots demo of the accounts receivable period end processing taskView the Sage 100 ERP Demo of the Accounts Receivable Period End Processing Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Period End Processing Task.

Sage 100 ERP Accounts Receivable Overview Support Information for the Setup Menu Tasks

Details of Sage 100 Accounts Receivable Setup Menu

…about this…

sage 100 erp accounts receivable module setup menu accounts receivable optionsAccounts Receivable Module Options

The AR Module Options Task are module setup options allowing you to maintain features most appropriate for your business. Some of these options are defined during new company setup using the Accounts Receivable Setup Wizard, but they can be further maintained in this window.

sage 100 erp accounts receivable module options task setup and integrationSetup & Integration

  1. The options defined in the Accounts Receivable module have a significant and material effect on the integration of information processed from other modules.
  2. The General Ledger and Common Information modules must be set up before the Accounts Receivable module can be set up.
  3. For new companies, you can only access Accpounts Receivable Options after completing the Accounts Receivable Setup Wizard.
  4. Only one user at a time can access Accounts Receivable Options. The second user accessing Accounts Receivable Options will open an inquiry window where fields can only be viewed.

view the sage 100 erp interactive screenshots demo of the accounts receivable module options taskView the Sage 100 ERP Demo of the Accounts Receivable Module Options Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Module Options Setup Task.

sage 100 erp accounts receivable module setup menu division maintenanceAccounts Receivable Division Maintenance

The Accounts Rceivable Division Maintenance Task is used to organize your customer and invoice information by divisions.

sage 100 erp accounts receivable division maintenance setup task user support options User & Support Options

  1. You can define up to 100 divisions by department, branch, or profit center.
  2. Each division can maintain its own Accounts Receivable and Discounts Allowed account numbers for posting to the general ledger.
  3. Amounts posted to each account reflect the activities for only that division.
  4. If you integrate the General Ledger module with Accounts Receivable, you can print the accounts receivable ending balance amounts for each profit center on your financial statements and other General Ledger reports.
  5. Divisions affect the numbering of your customers. The division number precedes the customer number entered in Customer Maintenance and determines which general ledger accounts are posted to when an invoice or cash receipt is processed.
  6. Reports containing customer invoice and payment information provide subtotals by division.
  7. The accounts posted to are based on the accounts specified in Division Maintenance.

sage 100 erp accounts receivable division maintenance setup task setup and integration optionsSetup & Integration Options

  1. If the Accounts Receivable Divisions check box is selected in the Accounts Receivable Options window, use Division Maintenance to assign a two-digit number and description to each division of your company.
  2. You also assign the general ledger account numbers associated with transactions to post when invoices or cash receipts are processed for a customer within a specific division.
  3. If the Accounts Receivable Divisions check box is cleared in the Accounts Receivable Options window, then you can only enter information for division 00 (default).
  4. Division 00 cannot be deleted and you cannot post invoices, cash receipts, or finance charges if any general ledger account numbers in Division Maintenane are blank.
Retention Invoices and Payments:
  1. When an invoice with retention is first entered, the net invoice amount (invoice balance minus retention) is debited to the Accounts Receivable account, and the retention amount is debited to the Retention Receivable account. You must specify the Retention Receivable account to use in Division Maintenance. If you do not want to post retention separately, use the same general ledger account for both the Accounts Receivable and Retention Receivable accounts in the Division Maintenance window.
  2. When a payment for an invoice is received, it is assumed that the Accounts Receivable balance is applied before any payment is applied to the retention balance. This means that any partial payment that does not fully pay the invoice is first applied against the Accounts Receivable account until the invoice balance is equal to the retention amount. Any additional payment is applied to the Retention Receivable account.

view the sage 100 erp interracctive screenshot demo of the accounts receivable division maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Division Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Division Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu bank code maintenanceAccounts Receivable Bank Code Maintenance

The Bank Code Maintenance Task is used to establish multiple cash accounts to which receipts can be deposited.

sage 100 erp accounts receivable bank code maintenance task user support options User & Support Options

  1. For each company, you can set up multiple bank codes, each representing a separate bank account.
  2. The bank code is identified by a letter (A through Z) or a number (0 through 9), allowing up to 36 bank codes for each company.
  3. Information maintained for each bank account also includes a description, bank identification number, and the general ledger cash account to debit when receipts are deposited.
  4. You can also select default forms to use for printing Accounts Payable checks for each bank code.
  5. You can also maintain separate accounts and specify which account will be used when performing Payroll Data Entry and Check Printing.
  6. You can select a specific account by selecting the appropriate bank code.

sage 100 erp accounts receivable bank code maintenance task setup and integration optionsSetup & Integration Options

  1. If the Integrate with Bank Reconciliation check box is marked in Accounts Receivable Options all transaction posted from the Accounts Receivable Module also posts to the Bank Reconciliation Module for reconciliation later.

view teh dsage 100 erp interactive screenshots demo of the accounts receivable bank code maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Bank Code Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Bank Code Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu terms code maintenanceAccounts Receivable Terms Code Maintenance

The Accounts Receivable Terms Code Maintenance is used to establish common payment terms offered to your customers.

sage 100 erp accounts receivable terms code maintenance task user support options User & Support Options

  1. After terms codes are established, you can assign these standard terms to customers.
  2. During invoice processing, discount amounts are calculated automatically, and invoice and discount due dates are displayed based on the terms code assigned to each customer in which display automatically.
  3. You only need to enter each term once. You can recall the appropriate terms information (for example, 2% 10 Days, Net 30 Days) for any customer by selecting the correct code.

sage 100 erp accounts receivable terms code maintenance task setup and integration optionsSetup & Integration Options

  1. A default “no terms” code of 00 has been established for use with customers not entitled to discount terms.
  2. When establishing customer information and during Invoice Data Entry, terms code 00 must be used for these customers.
  3. Terms code 00 cannot be deleted from the file, but you can enter 00 to access this record and change the description if necessary.

view the sage 100 erp interactive screenshots demo of the accounts receivabe terms code maintenance taskView the Sage 100 ERP Demo of the Accounts Receivable Terms Code Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Terms Code Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu sales tax account maintenanceAccounts Receivable Sales Tax Account Maintenance

The Accounts Receivable Sales Tax Account Maintenance Task is used to set up registration numbers, exemption numbers, and general ledger account numbers for your business. The sales tax and nontaxable sales amounts are reflected on the Sales Tax Report or can be viewed by clicking Sales or Purchases, as applicable.

sage 100 erp accounts receivable sales tax code maintenance task user support options User & Support Options

  1. Enter your company-specific registration numbers and exemption numbers for each tax code, if required.

sage 100 erp accounts receivable sales tax code maintenance task setup and integration optionsSetup & Integration Options

  1. This task is available only if the Sales Tax Reporting check box is selected in the Accounts Payable Options or Accounts Receivable Options window.
  2. Entering a general ledger account for the tax code overrides the sales tax code in Division Maintenance.

view the sage 100 erp interactive screenshots demo of the accounts receivable sales tax code maintenance taskView the Sage 100 ERP Demo of the Accounts Receivable Sales Tax Code Maintenance Setup Task:

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Sales Tax Code Maintenance Setup Task:

sage 100 erp accounts receivable module setup menu salesperson maintenanceAccounts Receivable Salesperson Maintenance

The Salesperson Maintenance Task is used to enter salesperson information and commission rates. A salesperson number and commission rate are assigned to each salesperson that is paid a commission.

sage 100 erp accounts receivable salesperson maintenance task user support options User & Support Options

  1. When you enter this salesperson number in Invoice Data Entry, the system automatically calculates the sales commission for the items sold.
  2. Sales, gross profit, and commissions for each salesperson are tracked by year by period.
  3. Salespeople can be Linked to accounts payable vendors, payroll employees, or general ledger account numbers for added commission tracking and payment capabilities. Also, period-to-date, year-to-date, and previous year totals are provided on the Salesperson Commission Report.

sage 100 erp accounts receivable salesperson maintenance task set and integration optionsSetup & Integration Options

  1. If the Customer Relationship Management module is set up, you can view the relationship between the salesperson and their Sage CRM user logon and Sage 100 ERP user logon.
  2. This relationship allows salespeople to enter sales orders from Sage CRM.
  3. Historical information can be viewed based on the fiscal year selected on the History tab. The sales, gross profit, and commission can be modified with the appropriate Security Setup.
  4. A salesperson cannot be deleted in Salesperson Maintenance if there is historical data saved for the salesperson.

view the sage 100 erp interactive screenshots demo of the accounts receivable salesperson maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Salesperson Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
View the Sage 100 ERP Demo of the Accounts Receivable Salesperson Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu payment type maintenanceAccounts Receivable Payment Type Maintenance

The Payment Type Maintenance Task is used to create and maintain payment types (such as credit cards) and to process sales order deposits and payments.

payment type maintenance task user support options Payment Type Maintenance Task User & Support Options

  1. You can also specify which payment types allow the use of corporate credit cards.

sage 100 erp accounts receivable payment type maintenance task setup and integration optionsSetup & Integration Options

  1. A default payment type of CHECK is created automatically and cannot be deleted. The CHECK payment type is assigned to new customers as a default.
  2. If the Credit Card Processing module is installed and configured, you can automatically process credit card transactions.
  3. When sales journals are posted, credit card payments on sales order invoices are debited to the asset account and the accrued credit card expense account.

view the sage 100 erp inteactive screenshots demo of the accounts reveivable payment type maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Payment Type Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Payment Type Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu miscellaneous item maintenanceAccounts Receivable Miscellanous Item Maintenance

Miscellanouse Item Maintenance Task is use to add, view, or maintain miscellaneous items, charges, and comment items.

sage 100 erp accounts receivable miscellaneous item maintenance task user support options User & Support Options

  1. An item code can be a product part number, an abbreviation, or any other code identifying your products or services.
  2. The general ledger account number for sales, cost of goods sold, purchases, inventory, and manufacturing cost postings can be defined for item codes in the Miscellaneouse Item Maintenance window.
  3. You can determine whether items are posted to a particular account number, or to a substituted account number where a subaccount serves as a segment substitution.
  4. You can also use Miscellaneous Item Maintenance to establish charge and miscellaneous items if you routinely bill customers for services that are not inventory items.
  5. You can type standardized comment lines. Comment item codes allow you to print comments on sales orders, invoices, purchase orders, receipts, returns, material requisition issues, and bill of materials component lists.

sage 100 erp accounts receivable miscellaneous item maintenance task setup and integration optionsSetup & Integration Options

  1. If the eBusiness Manager module is installed and set up for the current company, you can set up and enable access to your eBusiness Manager Web pages for miscellaneous items and charge codes.
  2. Inventory item types can be maintained in Item Maintenance.

view the sage 100 erp interactive screenshots demo of the accounts receivable miscellaneouse item maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Miscellaneous Item Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Miscellaneous Item Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu bill to customer maintenanceAccounts Receivable Bill To Customer Maintenance

The Bill To Customer Maintenance Task is used to set up relationships between a bill-to customer and its sold-to customers.

sage 100 erp accounts receivable bill to customer maintenance task user support options User & Support Options

  1. An unlimited number of sold-to customers can be linked to a single bill-to customer.
  2. Only one sold-to customer can be linked to one bill-to customer.
  3. Any customer that has been created and saved in the company can be set up as a bill-to customer or sold-to customer.
Credit Limit Checking on Sold To and/or Bill To Customer

This task can also be used to determine whether credit limit checking should be based on the bill-to customer or the sold-to customer. This can be done on a sold-to customer line basis. You can view the bill-to customer’s credit limit. To use the credit limit checking features, select Customer’s Credit Limit Only or Both in the Credit Limit Checking field in Accounts Receivable Options. Additionally, the credit hold, terms code, default address for billing, and customer pricing can be set to default to the bill-to or sold-to customer.

If one or more credit limit options have been changed for the sold-to customer, a message will appear warning you to use the Recalculate Open Order Amounts utility to recalculate the customer’s open order amounts that are used for credit limit checking.

bill to customer maintenance task setup and integration optionsBill To Customer Maintenance Task Setup & Integration Options

  1. Click Defaults to select default values for this task.
  2. IMPORTANT: If you are using salesperson commission reporting and the bill-to customer is set up in a different division than the sold-to customer, you should set up your salesperson in both divisions. The salesperson can then be used when adjusting an invoice for the bill-to customer for the bill-to customer.

sage 100 erp interactive screeenshots demo for the accounts receivable bill to customer maintenance taskView the Sage 100 ERP Demo of the Accounts Receivable Bill To Customer Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Bill To Customer Maintenance Task.

sage 100 erp accounts receivable module setup menu price leel by customer maintenanceAccounts Receivable Price Level by Customer Maintenance

The Accounts Receivable Price Level by Customer Maintenance Task is used to establish default price levels that can be used when entering sales orders and 1-step sales order invoices.

sage 100 erp accounts receivable price level by customer maintenance task user support options User & Support Options

  1. Use this task to set up default price levels for the customer by product line only, a combination of product line and price code, or product line and ship-to code depending on the selection made in the Base New Price Level Records On field in Sales Order Options.
  2. Effective and end dates can be defined for each product line and/or price level record to determine when the customer price level is in effect.
  3. If this task is accessed from Customer Maintenance, you can set up default price levels for the selected customer.

sage 100 erp accounts receivable price level by customer maintenance task setup and integration optionsSetup & Integration Options

  1. This task is available only if the Enable Default Price Level by Customer check box is selected in Sales Order Options.
  2. You can also establish a customer price level for one or more product lines.
  3. If this task is accessed from the Setup menu or the Price Level button in Product Line Maintenance, you can set up price levels for multiple customers
  4. You can copy product line and/or price level records that have been previously created for one customer to one or to multiple customers.

view the sage 100 erp interactive screenshots demo of the accounts receivable price level by customer maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Price Level by Customer Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Price Level by Customer Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu price level by customer copyAccounts Receivable Price Level by Customer Copy

The Accounts Receivable Price Level by Customer Copy Task is used to copy all or specific product line and/or price level records from a customer with existing product line and/or price level records to one or multiple customers.

sage 100 erp accounts receivable price level by customer copy task user support options User & Support Options

  1. After the information is copied, you can modify only the Price Lvl field in Price Level by Customer Maintenance for the copied records.

sage 100 erp accounts receivable price level by customer copy task set and integration optionsSetup & Integration Options

  1. Clicking Proceed will display a message with the number of new records to be created and the number of existing records that will be overwritten, if the Overwrite Existing Product Line/Price Level Records check box is selected.
  2. This task is available only with the appropriate Security Setup.

view the sage 100 erp inteactive screenshots demo of the accounts receivable price level by customer copy setup taskView the Sage 100 ERP Demo of the Accounts Receivable Price Level by Customer Copy Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Price Level by Customer Copy Setup Task

sage 100 erp accounts receivable module setup menu inactive reason code maintenanceAccounts Receivable Inactive Reason Code Maintenance

The Accounts Receivable Inactive Reason Code Maintenance is use to set up the reasons customers or vendors are inactive. The inactive reason codes can be used in Customer Maintenance and Vendor Maintenance.

sage 100 ero accounts receivable inactive reason code maintenance task user support options User & Support Options

  1. Inactive reason codes are printed on the Customer Audit Report and Vendor Audit Report, and they can be viewed in Customer Inquiry and Vendor Inquiry.

view the sage 100 erp interactive screenshots demo of the accounts receivable inactive reason code maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Inactive Reason Code Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Inactive Reason Code Maintenance Setup Task.

sage 100 erp accounts receivable module setup menu memo manager maintenanceAccounts Receivable Memo Manager Maintenance

The Memo Manager Maintenance Task is used to view, maintain, and manage memos system-wide.

sage 100 erp accounts receivable memo code manager maintenance setup task user support options Task User & Support Options

  1. In Memo Manager Maintenance, you can define where memos can be displayed or maintained within the software.
  2. You can also specify a default setting for the automatic display of memos when accessing certain tasks.
  3. Multiple types of memos can be defined per module.

sage 100 erp accounts receivable memo code manager setup task setup and integration optionsSetup & Integration Options

  1. The auto-display settings defined in Memo Manager Maintenance for the Default role can be overridden for individual memos in Override Auto Display Settings.
  2. After a memo is created, any changes made to the auto-display settings for a memo type do not affect the existing memo.

view the sage 100 erp inactive screenshots demo of the accounts receivable memo manger maintenance setup taskView the Sage 100 ERP Demo of the Accounts Receivable Memo Manager Maintenance Setup Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Memo Manager Maintenance Setup Task.

Sage 100 ERP Accounts Receivable Overview Support Information for the Utilities Menu Tasks

Details of Sage 100 Accounts Receivable Utilities Menu

…about this…

sage 100 erp accounts receivable module utilities menu delete and change customersAccounts Receivable Delete and Change Customers

The AR Delete and Change Customers Utility Task is used to delete or change existing customer numbers.

sage 100 erp accounts receivable delete and change customers task user support options User & Support Options

  1. An active customer cannot be merged into an inactive customer.
  2. A customer number can be selected to undergo only one function at a time. For example, you cannot delete a customer number and renumber the same customer number. The most recent function assigned to that customer number is placed on the delete and/or change list to execute.
  3. To perform a series of procedures using a single customer number, you must execute each function separately, updating the Delete and Change Customer Log file each time.
  4. You can enter individual or ranges of customer numbers, using wildcard characters to mask selected groups of customer numbers. Changes are made to the files in which the selected customer number is referenced.
  5. If two repetitive invoices with the same reference designator exist for both customers, the repetitive invoice of the original customer is deleted.
  6. Clicking Proceed executes the delete and change customer process and allows you to print the Delete and Change Customer Log.
  7. You must print and clear the Delete and Change Customer Log before you can update another delete and change customers process.
  8. Clicking the Print button allows you to print the Delete and Change Customer Listing.

sage 100 erp accounts receivable delete and change customers setup and integration optionsSetup & Integration Options

  1. Before using this task, any invoice entry and cash receipt entry in progress must be completed.
  2. WARNING: Before using this utility, back up all data files.
  3. If the Customer Relationship Management module is set up, you can delete and renumber customers that are related to Sage CRM companies. When a customer is renumbered, the relationship between the customer and the Sage CRM company is maintained. When a customer is deleted, the relationship with the Sage CRM company is deleted, but the Sage CRM company is not deleted. When customers are merged, the destination customer determines which Sage CRM relationship is maintained; all Sage CRM relationships for the source customers are deleted.

Important Information to Consider First

Changing the division number of a customer may affect the primary salesperson in open data entry files (for example, the salesperson may become invalid).

When deleting temporary customers, the customer will be deleted if the balance in the Customer file is zero. Records in the Open Invoice and Transaction Payment History files that exist for the customer will be removed; therefore, when printing aging or trial balance information for a period that applies to these records, the total will not tie to the general ledger balance.

The Sage CRM Prospects customer in Sage 100 ERP cannot be merged or renumbered with this task. You can change the Sage CRM Prospects customer number in CRM Options if there are no existing prospect quotes.

During the change process, for security and encryption reasons, the source customer’s credit card records and credit card Internet records (if applicable) are not copied to the destination customer and are deleted. Credit card information for source customers should be printed before merging customers. After the merge process is complete, you can manually reenter the credit card information, if necessary.

view the sage 100 erp inteactive screenshots demo for the accounts receivable delete and change customer task View the Sage 100 ERP Demo of the Accounts Receivable Change and Delete Customers Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Change and Delete Customers Utility.

sage 100 erp accounts receivable module utilities menu global customer field changeAccounts Receivable Global Customer Field Change

The AR Global Customer Field Change is used to to modify specified customer fields for a large number of customers.

sage 100 erp accounts receivable global customer field change task user support options User & Support Options

  1. The Activity Log is updated with the date, time, company code, user logon, and a message that the Global Customer Field Change utility was run.

view the sage 100 erp interactive screenshots Demo of the accounts receivable global customer field change utilityView the Sage 100 ERP Demo of the Accounts Receivable Global Customer Field Change Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Global Customer Field Change Utility.

sage 100 erp accounts receivable module utilities menu remove temporary customersAccounts Receivable Remove Temporary Customers

The AR Remove Temporary Customers Task is used to remove zero-balance temporary customers from the Customer file.

sage 100 erp accounts receivable remove temporary customers task setup and integration optionsSetup & Integration Options

  1. If the Retain Temporary Customers with Paid Invoices check box is cleared in the Accounts Receivable Options window, zero balance invoices for temporary customers will be purged and the temporary customer will be removed from the Customer file.
  2. To retain temporary customers based on the value entered in the Days to Retain Paid Invoices field in the Accounts Receivable Options window, select the Retain Temporary Customers with Paid Invoices check box in the Accounts Receivable Options window.

view the sage 100 erp interactive screenshots demo of the accounts receivable remove temporary customers utilityView the Sage 100 ERP Demo of the Accounts Receivable Remove Temporary Customers Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Remove Temporary Customers Utility.

sage 100 erp accounts receivable module utilities menu remove zero balance invoicesAccounts Receivable Remove Zero Balance Invoices

The AR Remove Zero Balance Invoices Task is used to only remove zero balance invoices and to clear any zero-balance invoices from the Open Invoice file, based on the information entered in the Days to Retain Paid Invoices field in the Accounts Receivable Options window.

view the sage 100 erp interactive screenshots demo of the accounts recievable remove zero balance invoices utilityView the Sage 100 ERP Demo of the Accounts Receivable Remove Zero Balance Invoices Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Remove Zero Balance Invoices Utility.

sage 100 erp accounts receivable module utilities menu recalculate customer high balancesAccounts Receivable Recalculate Customer High Balances

The AR Recalculate Customer High Balances Utility Task is used to update high balances for all customers during period-end processing. An updated balance is reflected in the Highest Balance field in the Customer Maintenance and Customer Inquiry windows.

sage 100 erp accounts receivable recalculate cusomter high balances user support options User & Support Options

  1. You can specify a date earlier than the current period; however, the high balance reflects the most current period for which Period End Processing has been run.
  2. If you do not enter a date, the Accounts Receivable module date is used.

sage 100 erp accounts receivable recalculate cusomter high balances utility setup and integration optionsSetup & Integration Options

  1. The updated balance is an assessment of all open invoices, future transactions, and payments prior to the date entered in the date field that appears after selecting the Only Recalculate Customer High Balances option.

view the sage 100 erp interactive screenshots demo of the accounts receivable recalculate customer high balances utilityView the Sage 100 ERP Demo of the Accounts Receivable Recalculate Customer High Balances Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Recalculate Customer High Balances Utility.

sage 100 erp accounts receivable module utilities menu salesperson commission purgeAccounts Receivable Salesperson Commission Purge

The AR Salesperson Commission Purge Utility is used to remove commission detail that is not cleared from the Salesperson Commission file.

sage 100 erp accounts receivable salesperson commission purge utility task user support options sUser & Support Options

  1. You can specify a range of salespersons, customers, invoices, and/or dates for which to purge the commission detail.
  2. You can also determine whether to treat negative balance invoices as paid invoices, allowing negative balance invoices to be purged.
  3. This task deletes commission detail for the selected salespersons, customers, and invoices, whether or not the commissions are printed or updated to the Accounts Payable, Payroll, or General Ledger module.
  4. The Activity Log is updated with the purge activity information and a message that the Salesperson Commission Purge was run.

sage 100 erp accounts receivablee salesperson commission purge utility task setup and integration optionsSetup & Integration Options

  1. This task is available only if the Salesperson Commission Reporting check box is selected in Accounts Receivable Options.
  2. If the Commissions Paid on Paid Invoices Only check box is selected in Accounts Receivable Options, commission details for only paid invoices are deleted.
  3. If the Commissions Paid on Paid Invoices Only check box is cleared, all commission details are deleted.

view the sage 100 erp interactive screenshots demo of the accounts receivable salesperson commission purge utility taskView the Sage 100 ERP Demo of the Accounts Receivable Salesperson Commission Purge Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Salesperson Commission Purge Utility.

sage 100 erp accounts receivable module utilities menu purge accounts receivable historyAccounts Receivable Purge AR History

The Purge Accounts Receivable History Utility Task is use to purge Accounts Receivable historical data, including invoice and the associated credit card information, cash receipts, customer sales, deposit, and salesperson history.

sage 100 erp accounts receivable purge accounts receivable history utility task user support options User & Support Options

  1. You can purge multiple history files, a combination of history files, or one history file at a time.
  2. You can specify a date when purging data from invoice history and deposit history or to only purge deleted invoices from invoice history.
  3. Customer sales history, salesperson history, and cash receipts history can be purged based on a specific fiscal year.

sage 100 erp accounts receivable purge accounts receivable history utility task setup and integration optionsSetup & Integration Options

  1. The Activity Log is updated with the date, time, company code, user logon and a message that the Purge Accounts Receivable History utility was run.

view the sage 100 erp interactive screenshots demo of the accounts recievable purge accounts receivable history utilityView the Sage 100 ERP Demo of the Accounts Receivable Purge Accounts Receivable History Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Purge Accounts Receivable History Utility.

sage 100 erp accounts receivable module utilities menu purge sales tax historyAccounts Receivable Purge Sales Tax History

The AR Purge Sales Tax History is used to purge all sales tax history by tax code on or before the date entered.

sage 100 erp accounts receivable purge sales tax history utility task user support options User & Support Options

  1. You can select which tax codes to remove sales tax history.
  2. Historical sales tax data dated on or before the date entered in Purge Sales Tax History is purged.
  3. Purging the Sales Tax History file clears the Sales Tax Report. Prior to purging, you should run the Accounts Receivable Sales Tax Report.

sagem100 erp accounts receivabel purge sales tax history utility task setup and integration optionsSetup & Integration Options

  1. This task is available only if the Sales Tax Reporting check box is selected in the Accounts Receivable Options window.
  2. The Activity Log is updated with the date, time, company code, user logon, and a message that the Purge Sales Tax History utility was run.

view the sage 100 erp interactive screenshots demo of the accounts receivable purge sales tax history utility taskView the Sage 100 ERP Demo of the Accounts Receivable Purge Sales Tax History Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Purge Sales Tax History Utility.

sage 100 erp accounts receivable module utilities menu sales tax calculationAccounts Receivable Sales Tax Calculation

The AR Sales Tax Calculation Task is used to recalculate sales tax for repetitive invoices, Accounts Receivable invoices, sales orders, and/or Sales Order invoices, based on the current tax information in the Common Tax files.

sage 100 erp accounts receivable sales tax calculation utility task user support options User & Support Options

  1. When the Sales Tax Calculation Utility is run, any invoices or sales orders that use the default tax schedule on file for the customer but have changed or cleared exemptions will return to the default exemptions for the customer. Also, when the Sales Tax Calculation Utility is run, any invoices or sales orders that use a different tax schedule than the default tax schedule on file for the customer will have any exemptions cleared.

sage 100 erp accounts receivable sales tax calculation utility task set and integration optionsSetup & Integration Options

  1. This task is available only if the Sales Tax Reporting check box is selected in the Accounts Receivable Options window.
  2. The System Activity Log is updated with the date, time, company code, user logon, and a message that the Sales Tax Calculation utility was run.

view the dsage 100 erp interactive screenshots demo of the accounts receivable sales tax calculation utilityView the Sage 100 ERP Demo of the Accounts Receivable Sales Tax Calculation Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Sales Tax Calculation Utility.

sage 100 erp accounts receivable module utilities menu internet customers enable purgeAccounts Receivable Internet Customers Enable Purge

The AR Internet Customers Enable Purge Utility is used to purge .store customer records by a date of last activity by customer type.

sage 100 erp accounts receivable internet customer enable purge utility task user support options User & Support Options

  1. You can also use this utility to enable access to your eBusiness Manager Web pages for all or a specified range of customer numbers and types. When you enable Internet customers, the system recognizes them as .order customers.

sage 100 erp accounts receivable internet customer enable purge utility task setup and integration optionsUser & Support Options

  1. The Activity Log is updated with the date, time, company code, user logon, and a message that the Internet Customers Enable/Purge utility was run.

AR Internet .store and .order Customers

If you have set up different Accounts Receivable divisions for .store and .order customers, and you are running the Delete and Change Customers utility, to save the customer records for .store customers who access your Web site frequently but have yet to make a purchase, exclude the Accounts Receivable division used for .store customers, and use the Internet Customers Enable/Purge utility instead. The Customers Enable/Purge utility allows you to delete records for .store customers who have not accessed your Web site since a specified date.

view the sage 100 erp interactive screenshots demo for the accounts receivable internet customer enable purge utiliityView the Sage 100 ERP Demo of the Accounts Receivabe Internet Customers Enable Purge Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivabe Internet Customers Enable Purge Utility.

sage 100 erp accounts receivable module utilities menu clear credit card informationAccounts Receivable Clear Credit Card Information

The AR Clear Credit Card Information Utility is used to purge credit card information.

sage 100 erp accounts receivable clear credit card information utility task user support options User & Support Options

  1. You can purge expired credit card information, purge credit card history, and purge credit card settlement report records.
  2. You can also specify a date when purging expired credit card information, history, and settlement report records posted to General Ledger.

sage 100 erp accounts receivable clear credit card information utility task setup and integration optionsSetup & Integration Options

  1. After the Clear Credit Card Information utility is run, the Activity Log is updated with the date, time, company code, user logon, program, table, action, and result.

view the sage 100 erp interactive screenshots demo for the accounts receivable clear credit information utilityView the Sage 100 ERP Demo of the Account Receivable Clear Credit Card Information Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Account Receivable Clear Credit Card Information Utility.

sage 100 erp accounts receivable module utilities menu recalculate open order amountsAccounts Receivable Recalculate Open Order Amounts

The AR Recalculate Open Order Amounts Utility is used to recalculate the open order amount for all customers in Customer Maintenance based on the open orders in Sales Order Entry.

sage 100 erp recalculate open order amount utility task setup and integration optionsSetup & Integration Options

  1. When the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options and the sold-to customer is set up to use the bill-to customer’s credit limit, the bill-to customer’s open order amount will include the sold-to customer’s open orders.

view the sage 100 erp interactive screenshots demo of the accounts receivable recalculate open order amount utilityView the Sage 100 ERP Demo of the Accounts Receivable Recalculate Open Order Amount Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Recalculate Open Order Amount Utility.

sage 100 erp accounts receivable module utilities menu remove inactive customersAccounts Receivable Remove Inactive Customers

The AR Remove Inactive Customers Utility is uesed to remove inactive customers from the Customer file.

sage 100 erp accounts receivable remove inactive customers utility task user support options User & Support Options

  1. Inactive customer records can be deleted only if there is no outstanding activity for that customer.
  2. If there is activity, such as pending orders, you must wait until all open invoices for the customer are paid and purged before you proceed with the record deletion, or use the Delete and Change Customers utility.

sage 100 erp accounts receivable remove inactive customers utility task setup and integration optionsSetup & Integration Options

  1. The Activity Log is updated with the date, time, company code, user logon, and the utility description.

view the sage 100 erp inteactive screenshots demo for the accounts receivabe remove inactive customers utilityView the Sage 100 ERP Demo of the Accounts Receivable Remove Inactive Customers Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Remove Inactive Customers Utility.

Sage 100 ERP Accounts Receivable Module Overview Support Information for Crystal Reports Custom Reports

Details of Sage 100 Accounts Receivable Custom Reports Menu

…about this…how to…

sage 100 erp accounts receivable module custom reports menu createCrystal Reports for A/R Custom Reports

Use Custom Reports to build custom Crystal Reports for Sage 100 ERP Accounts Receivable.

click to view the sage 100 erp demo of the accounts receivable crystal reports custom reports task View the Sage 100 ERP Demo of the Accounts Receivable Crystal Reports Custom Reports Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Crystal Reports Custom Reports.

Sage 100 ERP Accounts Receivable Module Overview Support Information for the Business Insights Explore Task

Details of Sage 100 Accounts Receivable Business Insights Explore Menu

The Sage 100 ERP Business Insights Explorer Views are predifined data table relationships provide for you to navigate through a module’s data, and preview and drill into related information for a selected row to follow the transactions from beginning to end. Business Insights Explorer provides predefined views of Accounts Receivable commonly used sets of data, such as Customer View, Salesperson View, Customer Invoices History View, Customer Open Invoices View, Customer Repetitive Invoices View, and Customer Payments View. Explorer Views can be exported to a variety of output types, including Microsoft Excel, Microsoft Access, Microsoft Word, XML, and Web pages.

sage 100 erp accounts receivable module explore menu customer veiwBusiness Insights Explore Customer View

The Customer View.

click to view the sage 100 erp demo of the accounts receivable business insights explore customer view View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer View.

sage 100 erp accounts receivable module explore menu salesperson veiwBusiness Insights Explore Salesperson View

The Salesperson View to

click to view the sage 100 erp demo of the accounts receivable business insights explore salesperson view View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Salesperson View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Salesperson View.

sage 100 erp accounts receivable module explore menu customer history invoices veiwBusiness Insights Explore Customer History Invoices View

The Customer History Invoices View.

click to view the sage 100 erp demo of the accounts receivable business insights explore customer history invoices view View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer History Invoices View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer History Invoices View.

sage 100 erp accounts receivable module explore menu customer open invoices veiwBusiness Insights Explore Customer Open Invoices View

The Customer Open Invoices View.

click to view the sage 100 erp demo of the accounts receivable business insights explore customer open invoices view View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer Open Invoices View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer Open Invoices View.

sage 100 erp accounts receivable module explore menu customer repetitive invoices veiwBusiness Insights Explore Customer Repetitive Invoices View

The Customer History Repetitive View.

click to view the sage 100 erp demo of the accounts receivable business insights explore customer repetitive invoices view View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer Repetitive Invoices View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer Repetitive Invoices View.

sage 100 erp accounts receivable module explore menu customer payments viewBusiness Insights Explore Customer Payments View

The Customer Payments View.

click to view the sage 100 erp demo of the accounts receivable business insights explore customer payments view View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer Payments View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Business Insights Explore Customer Payments View.

Sage 100 ERP Accounts Receivable Module Overview Support Information for the Visual Process Flows Task

Details of Sage 100 Accounts Receivable Visual Process Flows Menu

…about this…how to…

sage 100 erp accounts receivable module custom process flows menu createCustom Process Flows

Custom Process Flows.

click to view the sage 100 erp demo of the accounts receivable visual process flows View the Sage 100 ERP Demo of the Accounts Receivable Visual Process Flows.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Accounts Receivable Visual Process Flows.

Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are property of their respective owners.