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 Details

  To View the Sales Details Report: 

  1. Go to the Reports Menu and click on the Sales Details Sub-Menu
  
  
  
  2. You are now viewing all of the sales details (one record per order detail line) across all customers.  
  
  
  

  
  
  To Limit by Cycle:

  1. Enter a cycle in YYMM format and click the Search Button 
  
  Example: Cycle 4 of 2021 -> YYMM = 2104 
  
  
  
  

  
  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 Generate Subtotals:

  
  Example 1: Subtotal by Service
  
  1. Select the appropriate option from the Subtotal By Drop Down 
  
  
  
  2. Enter either a 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 service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's transactions
  
  
  
  4. Click on Download Table to download an Excel Spreadsheet of the current table 
  
  
  
  
  Example 2: Subtotal by Address ID
  
  1. Enter a Customer name (Required) 
  
  
  
  2. Select the appropriate option from the Subtotal By Drop Down 
  
  
  
  3. Enter either a Cycle or a From/To Date (Required)
  
  
  
  4. 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 address id subtotal selection, entries will be shown by address id in descending date order with a subtotal at the end of each address id's transactions
  
  
  
  5. Click on Download Table to download an Excel Spreadsheet of the current table 
  
  

• 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 service) across all customers. 

  
  

  
  
  
  To Limit by Cycle:

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

   

  Example: Cycle 1 of 2021 -> YYMM = 2101 

   

  

  
  
  
  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 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

   

  

• Sales Weekly

  To View the Sales Weekly Report: 

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

   

  
  
  

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

  
  

  
  
  To Limit by Date: 

  1. Enter either a From Date, To Date or both a From and To Date and click the Search Button 
  
  Note: From Date must be a Saturday

  To Date must be a Friday
   

  

  
  
  To Subtotal by Item: 

  1. Select the appropriate option from the Subtotal By Drop Down

  
  
  
  

  2. Enter 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 item subtotal selection, entries will be shown by item number in descending date order with a subtotal at the end of each item's transactions

  
  
  
  

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

  
  

  
  
  To Subtotal by Item Class: 

  1. Select the appropriate option from the Subtotal By Drop Down

  
  
  
  

  2. Enter 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 item class subtotal selection, entries will be shown by item class in descending date order with a subtotal at the end of each item class' transactions 

  
  
  
  

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

   

  

• Sales Monthly

  To View the Sales Monthly Report: 

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

   

  
  
  

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

  
  

  
  
  To Limit By Cycle: 

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

   

  Note: Cycle 1 of 2021 -> YYMM = 2101

   

   

  

  
  
  To Subotal by Salesman: 

  1. Select the appropriate option from the Subtotal By Drop Down

  
  
  
  

  2. Enter a From/To Cycle (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 salesman subtotal selection, entries will be shown by salesman in descending date order with a subtotal at the end of each salesman's transactions 

  
  
  
  
  

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

  
  

  
  
  To Subtotal by Service:

  1. Select the appropriate option from the Subtotal By Drop Down

  
  
  
  

  2. Enter a From/To Cycle (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 service subtotal selection, entries will be shown by service in descending date order with a subtotal at the end of each service's 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 those top sale customers
  
  
  
  
  
  
  Limit By Cycle 
  
  
  
  Limit By Customer, Item and/or Service
  
  
  
  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