The CPRS Preparation Report in Accounts Payable is returning incorrect information
Description
Cause
  • The conditional print area formula in the design that determines whether to print the vendor or not was not applying the date range.
  • If the spelling of "check" on the CM Check description in Custom Descriptions, was something other than "check", such as "cheque", those payments were not being included in the total.

These issues have been fixed in the attached report design.

Resolution

The corrected report design will be included in a future release. As a workaround, you have the following options:

Option I: Use Accounts Payable, Tasks, Government eFile and Reporting, Form T5018 (CAN) to create the T5018 forms or to perform a test run to use as a preparation report.

Option II: Download the attached report AP CPRS Preparation Report_KB114368_rev1.rpt.

  • The conditional print area formula has the date range applied.
  • The check payment types are now included regardless of the spelling for the CM Check description in Custom Descriptions.
  • Refer to article ID 18607 DocLink: How do I save, add, and print a report design? for instructions on how to download the attached report and add it to your report menu.

Warning: The attached report is provided as a possible solution to your issue. It was not reviewed by Quality Assurance. You may need to modify it to meet your reporting needs or adapt it for use with future releases of the software. Contact your Sage 300 Construction and Real Estate certified consultant for assistance with modifying this report.

Option III: Use AP, Reports, Cash Management, Paid Invoice Register or Paid Invoices by Property. You will need to deduct the Discount Taken amount from the Amount Paid.

Note: The Paid Invoices by Property report is by GL prefix. You may need to add this report to your menu. The report file name is and can be found the default Report directory. See article 17087 DocLink: How do I add a report to a Reports menu?

Attachment: 196_20230425112047_AP CPRS Preparation Report_KB114368_v1.rpt

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
542578
Steps to duplicate
Related Articles