Receivings Transaction > Shipment/Invoice with Project
Shelly asked 9 years ago
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?
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?
Answers
Best Answer
Lorren answered 9 years ago
Shelly replied 9 years ago
Shelly replied 9 years ago
Lorren answered 9 years ago
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
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
Shelly replied 9 years ago I still receive the error "Cannot insert the value NULL into column 'ORD; table 'TEST.dbo.PA10702'; column does not allow nulls. INSERT fails.
Shelly replied 9 years ago I still receive the error "Cannot insert the value NULL into column 'ORD; table 'TEST.dbo.PA10702'; column does not allow nulls. INSERT fails.