Menu Path: Accounts Receivable Reports Invoices Invoice Posting Audit Report
Output audit reports for invoice postings.
Use Invoice Posting Audit Report to create an Excel spreadsheet of invoice postings. Use this report to reconcile sales history with the general ledger for monthly reconciliation and auditing.
To generate the report:
Click the ribbon button for the report you want to output (reconciling with the general ledger, product sales, or customer sales).
Select filter options for the report.
Click the Print Options tab.
Select a process option.
Click the Print button in the ribbon to output the report.
Button |
Description |
Exit |
Click this button to close the Invoice Posting Audit Report window. |
|
Click this button to output the report. |
Reconcile to G/L |
Click this button to select options for generating a report of general ledger postings when reconciling with the general ledger. |
Reconcile to Product Sales |
Click this button to select options for generating a report of product sales for reconciling with the Product Sales Report. For information on the Product Sales Report, see Product Sales Report. |
Reconcile to Customer Sales |
Click this button to select options for generating a report of customer sales for reconciling with the Customer Sales Report. For information on the Customer Sales Report, see Customer Sales Report. |
Field or Button |
Description |
Select this check box to include data for all posting periods/years on the report. This check box is cleared by default. |
|
Enter a posting year/period (in YYYYMM format) for which to include data on the report. If you want to include data for a range of posting years/periods, enter the first year/period in the range. This field is only enabled if the All Post Sort (YYYYMM) check box is cleared. |
|
Enter the last posting year/period (in YYYYMM format) in a range of posting years/periods for which to include data on the report. If you only want to include data for a single year/period, you can leave this field blank. This field is only enabled if the All Post Sort (YYYYMM) check box is cleared. |
|
Select this check box to include data for all reference dates on the report. This check box is selected by default. |
|
Enter a reference date for which to include data on the report, or click the drop-down arrow to select a reference date. If you want to include data for a range of reference dates on the report, you can leave this field blank. This field is only enabled if you clear the All Reference Dates check box. |
|
Enter the last reference date in a range of reference dates for which to include data on the report, or click the drop-down arrow to select a reference date. If you only want to include data on the report for a single reference date, you can leave this field blank. This field is only enabled if you clear the All Reference Dates check box. |
|
Select this check box to include data on the report for all reference types. This check box is selected by default. |
|
Enter a reference type for which to include data on the report, or click the Lookup button to select a reference type. This field is only enabled if you clear the All Reference Types check box. |
|
Click this button to display Record List, which allows you to select specific reference types for which to include data on the report. This button is only enabled if you clear the All Reference Types check box. If you click this button, and select reference types, the check box to the right of the button is selected. |
|
Select this check box to include data on the report for all order class. This check box is selected by default. |
|
Enter an order class for which to include data on the report, or click the Lookup button to select an order class. If you want to include data on the report for a range of order classes, enter the first order class in the range. This field is only enabled if you clear the All Order Classes check box. |
|
Enter the last order class in a range of order classes for which to include data on the report, or click the Lookup button to select an order class. If you only want to include data on the report for a single order class, you can leave this field blank. This field is only enabled if you clear the All Order Classes check box. |
|
Click this button to display Order Class List, which allows you to select specific order classes for which to include data on the report. This button is only enabled if you clear the All Order Classes check box. If you click this button, and select order classes, the check box to the right of the button is selected. |
|
Select whether to include data on the report only for posted invoices, only for unposted invoices, or for all invoices. The Posted Only radio button is selected by default if you click the Reconcile to G/L button in the ribbon. The All radio button is selected by default if you click the Reconcile to Product Sales button in the ribbon or the Reconcile to Customer Sales button in the ribbon. |
|
Select whether to include data on the report only for invoices that update sales history, only for invoices that bypass sales history, or for all invoices. The All radio button is selected by default if you click the Reconcile to G/L button in the ribbon. The Updates Sales History radio button is selected by default if you click the Reconcile to Product Sales button in the ribbon or the Reconcile to Customer Sales button in the ribbon. |
|
Select this check box to include data on the report for all general ledger accounts. This check box is selected by default if you click the Reconcile to Product Sales button in the ribbon or the Reconcile to Customer Sales button in the ribbon. This check box is cleared by default if you click the Reconcile to G/L button in the ribbon. |
|
Enter a general ledger account for which to include data on the report, or click the Lookup button to select a general ledger account. If you want to include data on the report for a range of general ledger accounts, enter the first general ledger account in the range. This field is only enabled if the All G/L Accounts check box is cleared. |
|
Enter the last general ledger account in a range of general ledger accounts for which to include data on the report, or click the Lookup button to select a general ledger account. If you only want to include data on the report for a single general ledger account, you can leave this field blank. This field is only enabled if the All G/L Accounts check box is cleared. |
|
Select this check box to include data on the report for product invoice line items. This check box is selected by default. |
|
Select this check box to include data on the report for tax invoice line items. This check box is selected by default if you click the Reconcile to G/L button in the ribbon. This check box is cleared by default if you click the Reconcile to Product Sales button in the ribbon or the Reconcile to Customer Sales button in the ribbon. |
|
Select whether to include all additional charge invoice line items on the report. The All radio button is selected by default if you click the Reconcile to G/L button in the ribbon or the Reconcile to Customer Sales button in the ribbon. The Exclude Charge Only radio button is selected if you click the Reconcile to Product Sales button in the ribbon. |
Field or Button |
Description |
The Excel radio button is selected to indicate the report is output directly to Excel. You can specify the location of the Excel application in the Spreadsheet File field in User Profile Maintenance. If you select to output to Scheduling Assistant, you are prompted to select recipients for an email, and Scheduling Assistant sends an email with the report attached as an Excel file. |
|
Process |
Select whether the task is run now or run by Scheduling Assistant. If you select the Schedule radio button, you can specify when the task occurs, and optionally set up an alert to be created when the task completes. These radio buttons are only enabled if the Disable Scheduling Assistant check box is cleared for your user ID in User Profile Maintenance. Note If you select the Schedule radio button, you cannot output to the screen. |
Time |
|
Date |
|
Task Occurs |
Select one of the following options:
These radio buttons are only enabled if you select the Schedule radio button. |
Frequency |
These radio buttons are only available if you select the Every radio button. |
Day of Week |
|
Repeat Every X Days |
|
Repeat On |
|
Repeat Every X Minutes |
|
Triggering Task Id |
|
Triggering Task Name |
|
Triggering Task Description |
|
Task Description |
|
Scheduling Assistant Queue |
Enter an active Scheduling Assistant queue for the task, or click the Lookup button to select a Scheduling Assistant queue. This defaults to the default queue for your user ID. This field is only enabled if you select the Schedule radio button, and you are assigned to a queue other than the Default queue. |
External Email |
|
Screen Alert |
|
Internal Email |
|
Report Files |
This grid displays report files set up for the report, and is only available if report files are set up for the program in Report File Maintenance. This grid includes the following columns:
|