Cannot insert null in DISAVMT when you use eConnect to integrate Payables Transactions into Microsoft Dynamics GP


RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

 

SYMPTOMS

When you use eConnect to integrate Payables Management Transactions, you may receive the error:

Cannot insert the value NULL into column 'DISAVAMT', table 'TWO.dbo.POP10300'; column does not allow nulls. INSERT fails. The statement has been terminated.

 

CAUSE

The message that you receive is because the drop-down list for Discount Type field is blank which will cause the null error to be returned.

RESOLUTION

To resolve the issue, you have to open the Payment Terms Setup window through the following method.
1. Select the Vendor ID that you use on the payables transaction in the Vendor Maintenance window.
2. Click the Options button.
3. Click the Payment Terms hyperlink.
Note The Payment Terms Setup window will open.
4. Check the Discount Type field to see whether the drop-down list is blank.
5. If the drop-down list is blank select either the Percent or Amount value and then press the Save .

This process will set the drop-down list to the specific value that you have specified instead of blank. This allows for the payables transaction to be integrated.

 

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.