When submitting a Receiving transaction from PanatrackerGP, the transaction is rejected by eConnect with SQL procedure error 4612 from taPopRcptLineInsert. This article explains why it happens and how to fix it.
The Receiving transaction submits from the handheld or portal, then fails. The failed-transaction details (or the error email sent from the portal) show eConnect rejecting the transaction with an error like this:
An error occurred performing the Receiving transaction. eConnect rejected this transaction. Sql procedure error codes returned: Error Number = 4612 Stored Procedure = taPopRcptLineInsert Error Description = Invalid Account Index Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = RCV0000XX PONUMBER = PO0000XX ITEMNMBR = ITEM-0001 Related Error Code Parameters for Node : taPopRcptLineInsert INVINDX = Note: This parameter was not passed in, no value for the parameter will be returned.
The key line is INVINDX not being passed in — eConnect needs an inventory/purchases account index for the line and doesn't have one.
The Purchase Order line for the item being received doesn't have a Purchase (inventory) Account assigned, and Dynamics GP has no default posting account to fall back on. Without one or the other, eConnect has no account index to send with the receipt and the transaction is rejected.
This most often shows up on newly set-up items: if an item was created without a Class ID, GP never populated its default GL accounts, so any PO line for that item has nothing to fall back to. It can also happen if the account assigned to the item is simply incorrect.
PONUMBER) and find the line for the item named in the error (ITEMNMBR).Questions? Contact Panatrack Support.
Related articles