Multiple Invoices for One Vendor Do Not Combine on One Check

Issue

Although there are multiple invoices approved for payment for a vendor, each invoice is printing out on a separate check.  In this case, this is not due to alternate remit to addresses.

Solution or Workaround

Note: The following should only be done by a Sage Certified Consultant or Business Partner. Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

This will happen if the address fields have been widened in the APVEND, APADDR, APRODT, APROHD, and APVADR tables to over 35 characters in length. It is suspected that this is due to hard coding in APPCHCK.PRG and .FXP where the size of the field is defined as 35 characters when creating the temporary file.

To go beyond the the current 35 character size limitation for these fields when printing checks, the code for APPCHCK.prg needs to be modified to increase the size limitation.  This modification has not been tested or supported by Sage Customer Support. To resolve the issue the address fields need to be restored back to 35 characters or less using the modify structure command on the database files using either Visual FoxPro or Visual FoxPro Access using the files exclusively.

© Copyright Sage Software

Leave A Comment?