Sage 300 ERP A/R Statement Printing – Troubleshooting 101

Posted by EQ Tech on Tue, May 12, 2015

At Equation, there are certain tech support issues that come up time and time again. A/R Statement Printing is one such stumbling block. Read on to find several quick troubleshooting tips…

Error:  There are no records in the specified range.

Sage 300 ERP clients will have a customer with an open balance but when they try to print a statement through A/R Statements/Letters/Labels, they receive the below error message:

AR_Statement_Printing_error_1of4

The usual culprit can be found on the Processing tab of the main Customer record.  Make sure that the checkbox next to Print Statements is marked.

AR_Statement_Printing_error_2of4

Clients running the most recent version of Sage 300 ERP (2014 aka 6.2) will also need to be on the lookout for customers setup as Sage Billing and Payment Customers (also designated on the Processing tab of the main Customer record).

If a customer is designated as a Sage Billing and Payment Customer then in order for statements to print, the check box on the A/R Statements/Letters/Labels screen must also be selected prior to printing. The same principle applies for Customers using the National Accounts designation.

AR_Statement_Printing_error_3of4

Finally, check the Criteria tab for other options that may be restricting your statement from printing. For example, if you have a client with open invoices that are offset by account credits creating a zero balance, their statement would not print unless you were to mark the checkbox below to include Zero balance customers.

AR_Statement_Printing_error_4of4

If you would like more information about how to troubleshoot your Sage 300 ERP software, please contact Equation Technologies today.

Topics: Sage 300 (ACCPAC)

Submit a Comment

Need Help Now?

Request a Call