Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Sign Up Now!Log In
carls 6/26/2019 10:19:12 AM

Cannot Receive and Invoice the PO Items in GP

I am trying to Receive and Invoice PO Items in GP (Purchase Order Entry form -> Actions -> Receive and Invoice the PO Items).  I get an error saying “[Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert a NULL into column ‘UseQtyOverageTolerance’ in table tempdb.dbo.#PODetailed.”

When I click OK, I get another error stating that “The stored procedure popSelectPOItemsLoadDexTables returned the following resulds:  DBMS: 515, Microsoft Dynamcis GP: 0.”
Version: All
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables