The CPRS Preparation Report in Accounts Payable is returning incorrect information
Description

Version 24.3 includes the corrected report design.

If you are on an earlier version, you can use one of the workarounds below.

Cause

The conditional print area formula in the design doesn't apply the date range. This print area determines whether to print the vendor or not.

In Custom Descriptions, the CM Check description isn't spelled "check", the report doesn't include the payments in the total. Example: The description is "cheque" instead of "check".

We fixed these issues in the attached report design.

Resolution

Use Aatrix

  1. Go to Accounts Payable, Tasks, Government eFile and Reporting, Form T5018 (CAN).
  2. Create the T5018 forms or perform a test run to use as a preparation report.

Download a modified report

Download the APCPRSPreparationReportV1 report. 

Attachment: APCPRSPreparationReportV1.rpt

Warning: We offer this report as a possible solution to your issue. Quality Assurance didn't review the report. If you need to modify the report further to meet your reporting needs, contact your Sage Consultant for assistance.

  • The conditional print area formula has the date range applied
  • It includes the check payment types regardless of the spelling for the CM Check description in Custom Descriptions
  • See steps to save and print the report

Use the Paid Invoice Register

Use the Paid Invoice Register or the Paid Invoices by Property reports.

  1. Go to AP, Reports, Cash Management.
  2. Select the Paid Invoice Register or Paid Invoices by Property.
    Note: The Paid Invoices by Property report is by GL prefix. You may need to add the report to your menu. You can find the report in the default Report directory. 
  3. Deduct the Discount Taken amount from the Amount Paid.



[BCB:156:Chat 300 CRE US:ECB]
Steps to duplicate
Related Solutions