Skip to content
+1-888-319-3663

COMMUNITY FORUM

POP Receipt > Shipment/Invoice against a Project failing due to missing ORD in node

Shelly asked 6 years ago
Not sure why my questions was marked resolved when it still hasn’t been resolved??
 
Shelly asked September 5, 2014 at 1:13pm
 
I'm trying to import AP invoices into the Receivings Transaction Entry with a Project.  I receive the the following error:

Cannot insert the value NULL into the column 'ORD', table 'TEST.dboPA10702'; column does not allow nulls.  INSERT fails.  The stattement has been terminated.
 
I tried adding the ORD field to the taPopRcptLineInsert Node but this still doesn't work.

Has any one been able to import Project AP transactions into Receiving Transaction Entry?







Lorren October 3, 2014 at 4:46pm    







Shelly,

The Project Account business logic uses the Purchase Order Line number (Line Number) in the Receivings Node.  If you pass that value it should not give you that error.

Lorren
                   



  1. Shelly October 13, 2014 at 1:34pm


    I still receive the error "Cannot insert the value NULL into column 'ORD; table 'TEST.dbo.PA10702'; column does not allow nulls. INSERT fails.







If you would like to submit an answer or comment, please sign in to the eOne portal.