carls
4Penny.net
Points: 3300

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.”
 
4Penny.net
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
3