Issue

While entering transactions in Accounts Payable (AP) or Accounts Receivable (AR), the Terms ID field defaults to blank. Selecting a term during transactions or in the vendor or customer maintenance screens results in the following message:

Payment Terms [term description] not found.

Important
During AR transactions, selecting a term appears to work and proceeds to the next screen. However upon further review, the Header screen shows that the Terms ID field is blank. This does not occur in AP.

Solution or Workaround

These issues have been caused by modified field lengths for the Pterms field in the APVEND, APMAST, ARCUST, ARMAST, and other tables.

In most cases this situation can be identified by using the Verify File Structures and Indexes utility in System Manager. This utility will not identify the cause if the Sage Pro Data Dictionary was updated to include these modifications.

Important
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 issue can be resolved by manually editing the affected tables and shortening the Pterms field to 20 characters as originally designed. Reindexing application files in System Manager has been found to resolve this issue if no modifications are involved.

© Copyright Sage Software