A/P Receipt Accrual Print (AP35)

Additional Information
Balance Unmatched Receipts to GL

The Receipt Accruals Report (AP35) is used to print the Unmatched Receipt Accruals Report or the Receipt Accrual Variance Report, depending on the format selected.

  1. The Printer Selection screen automatically opens. Select the device destination and click OK.

  2. The Report Parameters screen for AP35 opens.

    • Select a Format from the drop down list. Valid options include:

      • Unmatched Receipt Accruals - prints from the Receipt Accrual Detail file and reports all Receipts that have not yet been matched up to an AP Invoice. When a Receipt is matched up to an AP Invoice in AP30, the AP Invoice number is updated in the Receipt Accrual Detail record, deeming it 'matched' and therefore skipped on this report format. This report should reconcile to the Receipts Accrual control account in the General Ledger (GL). For more information on balancing the unmatched receipts to the GL, click here.

      • Receipt Accrual Variance - prints from the Receipt Accrual Detail file and reports variances between the Receipt amount and the Invoiced amount (which are both stored in each detail record) that were captured as a byproduct of the detailed matching process in Enter Invoices (AP30/Receipt Accruals). This report is useful when analyzing the balance in the Receipts Variance GL account.

        Note: When Purge AP Invoice History (AP88) runs to purge paid AP Invoices, the associated matched Receipt Accrual Detail records are also purged. By default, the Variance history also purges.

    • Select a Sequence from the drop down list. Valid options include:

      • Supplier - prints in Supplier/Receipt number sequence.

      • Supplier & Invoice - prints in Supplier/Invoice number sequence. Note: This sequence only applies to format 2 (Receipt Accrual Variance).

    • If a New Page for each Break is required, select the check box.

    • The Levels list box displays the various Levels of detail available for the report. All Levels are automatically selected in AP35; the '>' before each Level option indicates the Level is selected. Double click on the line to remove the selector. AP35 includes the following Levels:
      • Detail Line
      • Receipt Number
      • Supplier
      • Report Total

    • Select the Restrictions that apply to the Receipt Accrual Report by double clicking on the line in the list box. Restrictions allow you to tailor AP35 to your specific needs. The '>' before a Restriction indicates the Restriction is selected. Once a Restriction is selected, it can be de-selected but the '>' remains. An '*' before a Restriction means the Restriction is mandatory. AP35 includes the following Restrictions:

      • Show Zero Variance - applicable with Format 2-Receipt Accrual Variance only. By default this restriction is selected so all detail lines are reported, even if there is no variance between the Receipt and the Invoiced amounts. If you want to reduce the report to only print those details that have a variance between the Receipt and the Invoice amount, ensure that this restriction is de-selected.

      • Ending Date - applicable to both report formats. Receipts still unmatched or Variances for Receipts up to and including the date entered are reported.

        Note: Do not back date the Unmatched Receipt Accruals report if you are trying to reconcile it to the Receipt Accrual control account in the General Ledger. For more information on balancing the unmatched receipts to the GL, click here.

      Note: To modify a Restriction once it is set up, reselect the Restriction and make the necessary changes.

    • Select the Range From and To for the report. The Range must match the Sequence selected. Multiple Ranges may be entered.

      • In the From field, enter the starting 'code' for the report, e.g. Supplier code.

      • In the To field, enter the ending 'code' for the report.

      • The information displays in the list box below.

      • To add additional Ranges, repeat these steps.

        Note: To print the entire file (all Supplier codes), simply tab through the From and To fields. The list box displays *Start and *End in the From and To fields.

      • To delete a Range from the list box, double click on the line. The following message displays, "Do you wish to delete this range? Yes/No". Click Yes to delete the range.

    • When all of the information on the Report Parameters screen is complete, click OK to run the report.

  3. The Report Complete screen opens when the report is generated. Enter OK to accept the report, click Restart to restart the printing of the report, or click Abort to cancel the report.

AP35
Receipt Accruals Report (AP35)