AR

• AR
  1. Go to the Reports Menu and click on the AR Sub-Menu
  
  
  
  2. You are now viewing the Accounts Receivables for all customers
  
  

• AR Aging
  1. Go to the Reports Menu and click on the AR Aging Sub-Menu 
  
  
  
  2. You are now viewing the open accounts receivables for all customers
  
  
  
  Note: Only customers with an open AR Balance will appear on this report

Sales

• Sales Daily

  To View the Sales Daily Report:

  1. Go to the Reports Menu and click on the Sales Daily Sub-Menu.
  
  
  
  
  

  2. You are now viewing all of the sales daily details (one record per date, per item or service) across all customers.
  
  

  
  
  
  

  To Limit by Period:

  1. Enter both a From and To Period in YYMM format and click the Search Button.

   

  Example:Periods 10 through 11 of 2024 -> YYMM = From Period: 2410, To Period: 2411 
  
  
  
  
  

  To Limit by Date:

  1. Enter either a From Date, To Date or both a From and To Date and click the Search Button.
  
  
  
  
  

  To Limit by Item:

  1. Enter the Item Number and click on the Search Button.
  
  
  
  
  

  To Limit by Service:

  1. Enter the Service and click on the Search Button.
  
  
  
  
  

  To Limit by Description:

  1. Enter a description and click the Search Button.
  
  
  
  
  

  To Generate Subtotals:

  Example 1: Subtotal by Customer
  
  1. Select the appropriate option from the Subtotal By Drop Down.
  
  
  
  
  2. Enter either a From/To Cycle or a From/To Date (Required).
  
  
  
  
  3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
  
  Note:For the customer subtotal selection, entries will be shown by customer # (not name), in descending date order with a subtotal at the end of each customer's transactions.
  
  
  
  
  4. Click on Download Table to download an Excel Spreadsheet of the current table.
  
  
  
  
  
  Example 2: Subtotal by Customer Class
  
  1. Select the appropriate option from the Subtotal By Drop Down.
  
  
  
  
  2. Enter either a From/To Cycle or a From/To Date (Required).
  
  
  
  
  3. Click on the Show All Button to view each subtotal (the subtotal will depend on the Subtotal By selection) and the grand total at the bottom.
  
  Note:For the customer class subtotal selection, entries will be shown by customer class name in descending date order with a subtotal at the end of each customer class' transactions.
  
  
  

  
  
  

  4. Click on Download Table to download an Excel Spreadsheet of the current table.
  
  

• Top Sales

  Use our Cloud ERP WMS software's Top Sales Report to easily view the customers bringing in the most sales.  
  
  
  1. Go to the Reports Menu and click on the Top Sales Sub-Menu
  
  
  
  2. You are now viewing the sales made for the current month, ordered by customer, starting with the top sale customers
  
  
  
  
  
  
  Limit By Cycle 
  
  
  
  Limit By Customer, Item and/or Service
  
  
  
  Sort By Total Average Cost or Total Cost
  
  
  
  Sort By Total Average Profit or Total Profit 
  
  
  
  Sort By Total Price, Total Quantity or Total Weight 
  
  
  
  Download Excel Sheets 
  
  
  
  Compare Sales With The Previous Year
  
  
  
  Subtotal By Customer, Customer Class, Item Class, Item, Salesman and Service  
  
  
  
  
  

Registers

• AR Invoice Register

  To View the Invoice Register:

  
  1. Go to the Reports Menu and click on the AR Invoice Register Sub-Menu 
  
  
  
  2. You are now viewing all invoices across all customers
  
  
  

  
  To View Just Open or Closed/Paid Invoices:

  
  1. Select the Open or Closed/Paid Option from the Show Dropdown 
  
  
  

  
  To View Totals: 

  
  1. Select either a Customer, or enter a Date or Cycle (Required) 
  
  
  
  2. Click on the Show All Button 
  
  
  
  3. Click on Download Table to download an excel file
  
  

• AR Credit Register

  To View the Credit Register:

   

  1. Go to the Reports Menu and click on the AR Credit Register Sub-Menu 

  
  
  
  

  2. You are now viewing all posted credit invoices (both on account and against invoice credits) across all customers

  
  

  
  To View Just Open or Closed/Paid Credits:

   

  1. Select the Open or Closed/Paid Option from the Show Dropdown 
  
  
  

  
  To View Only On Account or Against Invoice Credits: 

  
  1. Select either Against Invoice or On Account from the Credit Type Dropdown 
  
  

  
  To View Totals: 

   

  1. Select either a Customer, and/or enter a Date or Cycle (Required) 

  
  
  
  

  2. Click on the Show All Button 

  
  
  
  

  3. Click on Download Table to download an excel file
  
  

• AR Overpayment Register

  To View the Overpayment Register:

  1. Go to the Reports Menu and click on the AR Overpayment Register Sub-Menu 

   

  

   

  2. You are now viewing all posted overpayment invoices across all customers

   

  

   

  To View Just Open or Closed/Paid Overpayments:

  1. Select the Open or Closed/Paid Option from the Show Dropdown 

   

  
  

  
  To View Totals:

  1. Select either a Customer, and/or enter a Date or Cycle (Required) 

   

  

   

  2. Click on the Show All Button  
  
  

  

   

  3. Click on Download Table to download an excel file
  
  

• AR Invoices/Credits/Over-payments Register

  To View the AR Invoices/Credits/Over-payments Register:

   

  1. Go to the Reports Menu and click on the AR Invoices/Credits/Overpayments Register Sub-Menu 

  
  
  
  

  2. You are now viewing all invoices for all invoice types across all customers

  
  
  
  

  To View just Open or Closed/Paid Invoices/Credits/Over-payments:

   

  1. Select the Open or Closed/Paid Option from the Show Dropdown 

  
  

  
  To View Totals: 

   

  1. Select either a Customer, or enter a Date or Cycle (Required) 

  
  
  
  

  2. Click on the Show All Button 

  
  
  
  

  3. Click on Download Table to download an excel file
  
  

• Tax Register
  The Tax Register showcases one row per order line, along with its tax rate and tax total.
  
  Note: Only credits made directly against invoices will be showcased on the Tax Register.  On Account Credits do not apply to the Tax Register. 
  
  
  1. Go to the Reports Menu and click on the Accounts Receivable Sub-Menu, then click on the Tax Register 
  
  
  
  
  
  
  

  Search by Customer

  
  
  

  Search by Period or Date

  
  
  

  View Invoices and/or Credits

   
  
  

  View Totals

  
  
  

Transactions

• AR Invoice Adjustments

  To View AR Invoice Adjustments:

  1. Go to the Reports Menu and click on the AR Invoice Adjustments Sub-Menu
  
  
  
  2. You are now viewing all Posted AR Invoice Adjustments 
  
  
  
  

  To Search by Date: 

  1. Enter either a From, To or both a From and To Date and click on the Search Button 
  
  Accepted Formats: MM/DD/YY or MMDDYY
  
  Examples: 12/07/20
  120720
  
  
  
  

  To Search by Cycle:

  1. Enter the Cycle Date and Cycle Year and click on the Search Button 
  
  Accepted Format: YYMM
  
  Example: 2101
  
  
  
  

  To Search by Notes:

  1. Enter the Note and any other relevant inputs 
  Note: Only either  note1, note2 or amount can be searched over at once   
  
  
  
  

  To Search by Amount: 

  1. Enter the amount of the AR Invoice Adjustment(s) and any other relevant inputs 
  Note: Only either  note1, note2 or amount can be searched over at once 
  
  

• AR Miscellaneous Cash

  To View AR Miscellaneous Cash Entries:

  1. Go to the Reports Menu and click on the AR Miscellaneous Cash Sub-Menu

  
  
  
  

  2. You are now viewing all Posted AR Miscellaneous Cash Entries  
  
  

  
  To Search by Date: 

  1. Enter either a From, To or both a From and To Date and click on the Search Button 

   

  Accepted Formats: MM/DD/YY or MMDDYY

   

  Examples: 12/07/20

  120720
  
  

   

  To Search by Cycle: 

  1. Enter the Cycle Date and Cycle Year and click on the Search Button 

   

  Accepted Format: YYMM

   

  Example:

  2101

  
  

  
  To Search by Notes:

  1. Enter the note in either the Notes 1 or Notes 2 input field 

   

  Note:Only either  note 1, note 2 or amount can be searched over at once
  Notes entered into the Notes 1 field can only be searched within the Notes 1 field, not Notes 2, and vice versa  

  
  

  
  To Search by Amount: 

  1. Enter the amount of the AR Misc. Cash entry and any other relevant inputs 
  
  

  Note: 

   Only either  note 1, note 2 or amount can be searched over at once    
  
  
  
  

   

• AR Cash Receipts

  To View AR Cash Receipts:

  1. Go to the Reports Menu and click on the AR Cash Receipts Sub-Menu

  
  
  
  

  2. You are now viewing all Posted AR Cash Receipts 

  
  

  
  To Search by Date: 

  1. Enter either a From, To or both a From and To Date and click on the Search Button 

   

  Accepted Formats: MM/DD/YY or MMDDYY

   

  Examples: 12/07/20

  120720

  
  

  
  To Search by Cycle:

  1. Enter the Cycle Date and Cycle Year and click on the Search Button 

   

  Accepted Format: YYMM

   

  Example: 

  2101

  
  

  
  To Search by Check #:

  1. Enter the check # and any other relevant inputs 

   

  Note:

  Only either check #, amount or reference # can be searched over at once 
  
  

  
  To Search by Amount: 

  1. Enter the amount of the AR Cash Receipt(s) and any other relevant inputs 

   

  Note: 

   Only either check #, amount or reference # can be searched over at once 
  
  

  
  To Search by Reference Number: 
  

  Reference #: Reference numbers are required for Credit Card and ACH/Transfer/Wire Payments.  Once a Credit Card or ACH/Transfer/Wire Payment has been completed from an outside source, the reference number generated from that transaction must be included as part of the corresponding AR Cash Receipt. 
   
  1. Enter the reference # and any other relevant inputs 

   

  Note: 

   Only either check #, amount or reference # can be searched over at once
  
  

• AR Credits

  To View AR Credits: 

  1. Go to the Reports Menu and click on the AR Credits Sub-Menu

  
  
  
  

  2. You are now viewing all Posted AR Credits (Against Invoice Credits and On Account Credits)

  
  

  
  To Search by Date: 

  1. Enter either a From, To or both a From and To Date and click on the Search Button 

   

  Accepted Formats: MM/DD/YY or MMDDYY

   

  Examples: 12/07/20

  120720

  
  

  
  To Search by Cycle: 

  1. Enter the Cycle Date and Cycle Year and click on the Search Button 

   

  Accepted Format: YYMM

   

  Example: 

  2101

  
  

  
  To Search for Credits Applied Against an Invoice: 

  1. Enter the invoice number the credit has been applied to and click on the Search Button