Friday, January 8, 2010

IS Error When Printing Purchase Order

Version: Interprise Suite 2007 5.3 ebiz

Problem:

The following error is generated when trying to print a purchase order:

The value for column ‘Contact’ in table ‘SupplierPurchaseOrder’ is DBNull

Solution:

IS: Open the supplier, click the setup tab and update the following columns:

Default Contact Name
Accounts Contact Name
Sales Contact

or

Database: Update the following columns in table Supplier:

SupplierContactCode
DefaultAPContact
DefaultContact

No comments:

Post a Comment