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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
mark4yesu 10/5/2016 9:38:24 PM

GP PO Receiving Entry "Purchase Order Line Item does not exist"

Hi,

I'm writing an econnect import for POP Receiving Transaction Entry in Gp10.

I had it working for a while (purely doing it via SQL) - no XML.

I have recently come accross a situation where the Receipts don't match to the PO line items, but the should!   I'm at my wits end.  I setup a PO and Receipt like i usually do in test and make sure that the PO is in the system (only one line on the PO).  My values are as follows.

POPRCTNM =RCT100451

PONUMBER = MF10001 (this exists in GP with the one item "2016 BPO")

POLNENUM = 16348 (and it matches the ORD number on the PO for the same line item.

ITEMNMBR = "2016 BPO"

VNDITNUM = "2016 BPO" (noninventory number) - used to work with this value blank also.

UOFM = "Each" like on PO

*** Unit Cost DOES NOT Equal Unit Cost on the PO.  there is a difference.  Is this the culprit?

I get the error message taError code 2053:  Purchase Order Line Item does not exist."   but it does!

If anyone can assist... I am using the [taPopRcptLineInsert] proc. and I looked at the other posts here that show how to use the POLNENUM as a multiple of 16348.  

Any ideas on how to troubleshoot are welcome.

Thanks,
Mark

Version: GP 10
Section: Dynamics GP, eConnect, SQL Scripts








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