Error: When attempting to import a test order into Counterpoint I receive the following error: Cannot insert the value NULL into column ’AMT’, table
Article Number: 296 | Rating: Unrated | Last Updated: Sat, Sep 29, 2012 at 6:14 AM
Purpose:
To explain how to resolve the Counterpoint import error, "When attempting to import a test order into Counterpoint I receive the following error: Cannot insert the value NULL into column 'AMT', table."
Solution:
In Setup/Point of Sale/Stores, open the store being used for ecommerce.
Next to the description field for the store, is a Pay Codes button.
Open the Store Pay Codes window and add the CASH paycode.