Trying to setup a Project Accounting Employee Expense import using Integration Manager.
This is regarding Dynamics GP 2013 (SP1) and Integration Manager 12.00.1488
Been having an unexpected problem with that however, so I’m testing using the sample integration with the sample company.
For some reason, the sample integration didn’t have its fields mapped, so I did that. Pretty straight forward more or less, but if you need more detail on the mappings I'll happily provide that.
Getting an error that the employees are not setup as vendors. Checked that, and things look OK. I was even able to enter an employee expense by hand, and it worked OK.
The Integration Manager error report:
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Sql procedure error codes returned:
Error Number = 1914 Stored Procedure= taPAEmpExpenseLineInsert Error Description = Employee is not setup as a Vendor
Node Identifier Parameters: taPAEmpExpenseLineInsert
PAerdocnumber = EE000000000000001
LNITMSEQ = 49152
Related Error Code Parameters for Node : taPAEmpExpenseLineInsert
EMPLOYID = BARB0001
<taPAEmpExpenseLineInsert>
<PAertrxtype>1</PAertrxtype>
<PAerdocnumber>EE000000000000001</PAerdocnumber>
<EMPLOYID>BARB0001</EMPLOYID>
<PADT>4/12/2017</PADT>
<PAPROJNUMBER>HOTELEDGER</PAPROJNUMBER>
<PACOSTCATID>ALLOWANCE</PACOSTCATID>
<CURNCYID>Z-US$</CURNCYID>
<LNITMSEQ>49152</LNITMSEQ>
<PAitemnumber>Meal Expenses</PAitemnumber>
<PAREFNO></PAREFNO>
<PAQtyQ>3.00000</PAQtyQ>
<PAUnit_of_Measure>EACH</PAUnit_of_Measure>
<UOMSCHDL></UOMSCHDL>
<PAUNITCOST>25.00000</PAUNITCOST>
<PAPurchase_Tax_Options>3</PAPurchase_Tax_Options>
<ITMTSHID></ITMTSHID>
<TAXAMNT></TAXAMNT>
<BCKTXAMT></BCKTXAMT>
<PAPaymentMethod></PAPaymentMethod>
<PAExpenseType></PAExpenseType>
<PAReference_Line_Seq_N></PAReference_Line_Seq_N>
<PAbllngtype>1</PAbllngtype>
<RequesterTrx>0</RequesterTrx>
</taPAEmpExpenseLineInsert>
DOC 2 ERROR: Sql procedure error codes returned:
Error Number = 1914 Stored Procedure= taPAEmpExpenseLineInsert Error Description = Employee is not setup as a Vendor
Node Identifier Parameters: taPAEmpExpenseLineInsert
PAerdocnumber = EE000000000000002
LNITMSEQ = 49152
Related Error Code Parameters for Node : taPAEmpExpenseLineInsert
EMPLOYID = BARR0001
<taPAEmpExpenseLineInsert>
<PAertrxtype>1</PAertrxtype>
<PAerdocnumber>EE000000000000002</PAerdocnumber>
<EMPLOYID>BARR0001</EMPLOYID>
<PADT>4/12/2017</PADT>
<PAPROJNUMBER>HOTELEDGER</PAPROJNUMBER>
<PACOSTCATID>ALLOWANCE</PACOSTCATID>
<CURNCYID>Z-US$</CURNCYID>
<LNITMSEQ>49152</LNITMSEQ>
<PAitemnumber>Meal Expenses</PAitemnumber>
<PAREFNO></PAREFNO>
<PAQtyQ>3.00000</PAQtyQ>
<PAUnit_of_Measure>EACH</PAUnit_of_Measure>
<UOMSCHDL></UOMSCHDL>
<PAUNITCOST>30.00000</PAUNITCOST>
<PAPurchase_Tax_Options>3</PAPurchase_Tax_Options>
<ITMTSHID></ITMTSHID>
<TAXAMNT></TAXAMNT>
<BCKTXAMT></BCKTXAMT>
<PAPaymentMethod></PAPaymentMethod>
<PAExpenseType></PAExpenseType>
<PAReference_Line_Seq_N></PAReference_Line_Seq_N>
<PAbllngtype>1</PAbllngtype>
<RequesterTrx>0</RequesterTrx>
</taPAEmpExpenseLineInsert>
DOC 3 ERROR: Sql procedure error codes returned:
Error Number = 1914 Stored Procedure= taPAEmpExpenseLineInsert Error Description = Employee is not setup as a Vendor
Node Identifier Parameters: taPAEmpExpenseLineInsert
PAerdocnumber = EE000000000000003
LNITMSEQ = 49152
Related Error Code Parameters for Node : taPAEmpExpenseLineInsert
EMPLOYID = BONI0001
<taPAEmpExpenseLineInsert>
<PAertrxtype>1</PAertrxtype>
<PAerdocnumber>EE000000000000003</PAerdocnumber>
<EMPLOYID>BONI0001</EMPLOYID>
<PADT>4/12/2017</PADT>
<PAPROJNUMBER>HOTELEDGER</PAPROJNUMBER>
<PACOSTCATID>ALLOWANCE</PACOSTCATID>
<CURNCYID>Z-US$</CURNCYID>
<LNITMSEQ>49152</LNITMSEQ>
<PAitemnumber>Meal Expenses</PAitemnumber>
<PAREFNO></PAREFNO>
<PAQtyQ>2.00000</PAQtyQ>
<PAUnit_of_Measure>EACH</PAUnit_of_Measure>
<UOMSCHDL></UOMSCHDL>
<PAUNITCOST>25.00000</PAUNITCOST>
<PAPurchase_Tax_Options>3</PAPurchase_Tax_Options>
<ITMTSHID></ITMTSHID>
<TAXAMNT></TAXAMNT>
<BCKTXAMT></BCKTXAMT>
<PAPaymentMethod></PAPaymentMethod>
<PAExpenseType></PAExpenseType>
<PAReference_Line_Seq_N></PAReference_Line_Seq_N>
<PAbllngtype>1</PAbllngtype>
<RequesterTrx>0</RequesterTrx>
</taPAEmpExpenseLineInsert>
Integration Failed
Integration Results
3 documents were read from the source query.
3 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
3 failed to integrate.
A Successful expense entry using one of the employees.
Any idea on why integration manager is rejecting these employee id's?
p.s. The real reason behind this is that I'm running into a problem with a "real" integration and want to troubleshoot by testing the most basic things first. And first I need a properly working integration into the sample company.
