Invoice Posting Audit Report

Menu Path: Accounts Receivable Images\bluerarw.gif Reports Images\bluerarw.gif Invoices Images\bluerarw.gif Invoice Posting Audit Report

Purpose

Output audit reports for invoice postings.

Overview

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.

Generating the Invoice Posting Audit Report

To generate the report:

  1. Click the ribbon button for the report you want to output (reconciling with the general ledger, product sales, or customer sales).

  2. Select filter options for the report.

  3. Click the Print Options tab.

  4. Select a process option.

  5. Click the Print button in the ribbon to output the report.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Invoice Posting Audit Report window.

Print

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.

Main Tab Fields and Buttons

Field or Button

Description

All Post Sort (YYYYMM)

Select this check box to include data for all posting periods/years on the report. This check box is cleared by default.

From (Post Sort)

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.

To (Post Sort)

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.

All Reference Dates

Select this check box to include data for all reference dates on the report. This check box is selected by default.

From (Reference Date)

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.

To (Reference Date)

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.

All Reference Types

Select this check box to include data on the report for all reference types. This check box is selected by default.

Type

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.

List (Reference Types)

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.

All Order Classes

Select this check box to include data on the report for all order class. This check box is selected by default.

From (Order Class)

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.

To (Order Class)

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.

List (Order Class)

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.

Show (Posted)

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.

Show (Sales History)

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.

All G/L Accounts

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.

From (General Ledger Account)

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.

To (General Ledger Account)

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.

Show Product Lines

Select this check box to include data on the report for product invoice line items. This check box is selected by default.

Show Tax Lines

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.

Show Charge Lines

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.

Print Options Tab Fields and Buttons

Field or Button

Description

Output Option

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

Enter the time to output or process, and select AM or PM.

These fields are only enabled if the Schedule radio button is selected, and only available if the Once or Every radio button is selected.

Date

Enter the date (or first date) to output or process. This field is only enabled if the Schedule radio button is selected, and only available if the Once or Every radio button is selected.

Task Occurs

Select one of the following options:

  • Once - Output or process at a specified date and time.

  • Every - Output or process on a recurring basis. You can select to output/process at a specific time:

    • every week on specified days

    • after a specified number of days

    • on the first or last day of each month

    • after a specified number of minutes

  • After - Output/process after a specified task is completed.

These radio buttons are only enabled if you select the Schedule radio button.

Frequency

Select one of the following:

  • Day of Week - Output or process every week on the selected days.

  • Days - Output or process after a specified number of days, starting on a specified date.

  • Month - Output or process on the first or last day of each month, starting on a specified date.

  • Time - Output or process after a specified number of minutes, starting on a specified date.

These radio buttons are only available if you select the Every radio button.

Day of Week

Select the day(s) of the week to output or process.

These check boxes are only enabled if you select the Schedule radio button, and select the Every and Day of Week radio buttons.

Repeat Every X Days

Enter a number of days after which to output or process. This field is only available if you select the Days radio button.

Repeat On

Click the Lookup button and select whether to output or process on the first or last day of the month. This field is only available if you select the Month radio button.

Repeat Every X Minutes

Enter a number of minutes after which to output or process. This field is only available if you select the Time radio button.

Triggering Task Id

Click the Lookup button to select a task ID that will trigger the task. This field is only available if the After radio button is selected.

Triggering Task Name

This field displays the name of the triggering task. This field is only available if the After radio button is selected.

Triggering Task Description

This field displays the description of the triggering task. This field is only available if the After radio button is selected.

Task Description

Enter a description of the task. This can help users understand the purpose of a recurring task.

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

Select this check box to send an email (outside of Apprise, using SMTP) when the task is completed.

Screen Alert

Select this check box to display an alert when the task is completed.

Internal Email

Select this check box to send an internal Apprise email when the task is completed.

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:

  • Print - Select the check box in this column to output the report file.

  • Number of Copies - Enter the number of copies of the report file to print. This column is only available if you select the Printer radio button.

  • Report Description - This column displays the description of each report file.

  • Report Filename - This column displays the .rpt file name for each report file.

  • Report Name - This column displays the name of each report file.