Hi.
I'm trying to get IM to work for this destination. It's an econnect integration and seems to be requiring things that regular data entry to the screen does not. I'm trying to make an integration to receivables transactions for non-inventory items.
Using the GP screen we enter the header and then the detail goes like this: skip PO#, enter project, enter cost cat, enter description as item (non-inventory) then qty and unit price then next line. Regular data entry works just fine. But IM doesn't work. Setting those destination mappings and running the process generates errors.
From the errors it appears that this was written to only work with previously entered POs and stock items.
Any ideas how to make this work?
Here's the text of the IM error
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Sql procedure error codes returned:
Error Number = 2051 Stored Procedure= taPopRcptLineInsert Error Description = Input variable contains an empty value
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 3
POPRCTNM = RCT40762
PONUMBER =
ITEMNMBR =
Related Error Code Parameters for Node : taPopRcptLineInsert
POPRCTNM = RCT40762
ITEMNMBR =
VNDITNUM =
<taPopRcptLineInsert>
<POPRCTNM>RCT40762</POPRCTNM>
<POPTYPE>3</POPTYPE>
<VENDORID>MASTERCARD</VENDORID>
<PONUMBER></PONUMBER>
<ITEMNMBR></ITEMNMBR>
<ITEMDESC></ITEMDESC>
<VNDITNUM></VNDITNUM>
<VNDITDSC></VNDITDSC>
<ACTLSHIP></ACTLSHIP>
<InventoryAccount></InventoryAccount>
<UOFM></UOFM>
<UNITCOST>12.42000</UNITCOST>
<EXTDCOST></EXTDCOST>
<QTYSHPPD>1.000000000000000</QTYSHPPD>
<QTYINVCD>1.000000000000000</QTYINVCD>
<LOCNCODE></LOCNCODE>
<POLNENUM></POLNENUM>
<ProjNum>BRA001-OPEX</ProjNum>
<CostCatID>ENT</CostCatID>
<AUTOCOST>0</AUTOCOST>
<NONINVEN>1</NONINVEN>
<Landed_Cost_Group_ID></Landed_Cost_Group_ID>
<receiptdate></receiptdate>
<Purchase_IV_Item_Taxable>2</Purchase_IV_Item_Taxable>
<Purchase_Item_Tax_Schedu />
<AutoAssignBin>1</AutoAssignBin>
<RequesterTrx>0</RequesterTrx>
</taPopRcptLineInsert>
Integration Failed
Integration Results
1 documents were read from the source query.
1 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
1 failed to integrate.