ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Reports for the AR Aging Module

To obtain the AR Aging reports, depress the Reports button.  The following screen will appear:

Select one of the radio buttons for the output you desire. Select from Screen, Printer, XL File, TXT File, or PDF.

Highlight the report.

Depress the option tab.

 

AR Aging Summary With Prepays

Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button.  Select the appropriate Radio button for report aged on;    

Depress the Ok button

 

The following is printed:

AR Aging Detail with Prepays & AR Aging Detail with Prepays as of

Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button.  Select the appropriate Radio buttons for Report Aged on and Report Sorted on; 

Depress the Ok button

NOTE:  
You want to be sure that all invoices have been released and posted to the GL.  The "AR Aging Detail with Prepays As Of" report does NOT list invoices that have NOT been released/posted to the GL yet.  This report is intended to match the GL account information not the AR Aging screen.   Note:  If this report is still not matching the GL account information after all transactions have been released and posted to the GL then it may be due to Posted Journal Entries against the AR GL account.  These JE's will not be accounted for on the AS OF report yet will affect the GL Account balance and could explain why you are seeing a difference between the two.  
 

The following report will appear:

Customer Statements

Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button.  Select the appropriate Radio button for Report Sorted on;

Depress the Ok button  

 

The following report will appear:

 

AR Collection Status

Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button. 

Depress the Ok button  

 

The following report will appear:

Tax Distribution Summary

Select desired From and To dates.  Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button. 

Depress the Ok button  

 

The following report will appear:

Tax Distribution Detail

Select desired From and To dates.  Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button. 

Depress the Ok button  

 

The following report will appear:

 

Projected Cash Collections

Select desired From and To dates.  Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button. 

Depress the Ok button  

 

The following report will appear:

AR Sales Order/Invoice Report

Select one of the radio buttons for the desired Report - "By Sales Order", "By Invoice Number" or by Customer Check Number" .  Enter the exact Sales Order number, Invoice number or Customer Check number you are interested in. 

Depress the Ok button  

 

The following report will appear:

  

AR Transactions

Select desired From and To dates.  Highlight the Customer(s) of interest and depress the > button.  If you want all of the Customers, depress the >> button.  

Depress the Ok button  

 

The following report will appear:

 

 

Article ID: 555