COMMUNITY FORUM

Hi,

I am trying to import payables transaction into GP. Below is an example of  my source Excel file. 

BatchNumber DocumentType DocumentNumber VendorID DocumentDate DistributionReference AccountNumber DistributionType DistributionAmount TaxScheduleID TEST20230918 Invoice EXP1230918 BRADKOWA01 2023-07-12   1-1119-5302 6 500.00 BCPUR-PSTEXEMPT TEST20230918 Invoice EXP1230918 BRADKOWA01 2023-07-12   1-1119-5308 6 200.00 BCPUR-PSTEXEMPT TEST20230918 Invoice EXP1230918 BRADKOWA01 2023-07-12   1-1119-5309 6 300.00 BCPUR-PSTEXEMPT TEST20230918 Invoice EXP1230918 BRADKOWA01 2023-07-12 BCPUR-7%GST 1-0000-2102 10 50.00 BCPUR-PSTEXEMPT

In Destination – create payables transaction, I group by document number to create AP transaction. But I also need to get the tax amount and purchase amount separately to map to TAXAMNT and PRCHAMNT. I tried to create two calculated fields as below:

TAXAMOUNT:

if _DISTRIBUTIONTYPE = “10” then
return _DISTRIBUTIONAMOUNT
else
return 0.0
end if

PURCHASEAMOUNT:

if _DISTRIBUTIONTYPE = “6” then
return _DISTRIBUTIONAMOUNT
else
return 0.0
end if

Run the map and the transaction has been sent to GP successfully but the TAXAMOUNT is 0 and PURCHASEAMOUNT is full amount ($1050). 

Here is the logged XML so you can see the TAXAMNT = 0 and PRCHAMNT = 1050 and no tax distribution included:

<?xml version=”1.0″?>

-<eConnect>

-<PMTransactionType>

-<eConnectProcessInfo>

<ConnectionString>data source=xxxx;initial catalog=xxxx;integrated security=SSPI;persist security info=False;packet size=4096;Connect Timeout=10</ConnectionString>

</eConnectProcessInfo>

-<taPMDistribution_Items>

-<taPMDistribution>

<DISTTYPE>6</DISTTYPE>

<VENDORID>BRADKOWA01</VENDORID>

<CRDTAMNT>0</CRDTAMNT>

<DistRef></DistRef>

<ACTNUMST>1-1119-5302</ACTNUMST>

<DEBITAMT>500</DEBITAMT>

<DOCTYPE>1</DOCTYPE>

<VCHRNMBR>00000000000487051</VCHRNMBR>

<DSTSQNUM>16384</DSTSQNUM>

</taPMDistribution>

-<taPMDistribution>

<DISTTYPE>6</DISTTYPE>

<VENDORID>BRADKOWA01</VENDORID>

<CRDTAMNT>0</CRDTAMNT>

<DistRef></DistRef>

<ACTNUMST>1-1119-5308</ACTNUMST>

<DEBITAMT>200</DEBITAMT>

<DOCTYPE>1</DOCTYPE>

<VCHRNMBR>00000000000487051</VCHRNMBR>

<DSTSQNUM>32768</DSTSQNUM>

</taPMDistribution>

-<taPMDistribution>

<DISTTYPE>6</DISTTYPE>

<VENDORID>BRADKOWA01</VENDORID>

<CRDTAMNT>0</CRDTAMNT>

<DistRef></DistRef>

<ACTNUMST>1-1119-5309</ACTNUMST>

<DEBITAMT>300</DEBITAMT>

<DOCTYPE>1</DOCTYPE>

<VCHRNMBR>00000000000487051</VCHRNMBR>

<DSTSQNUM>49152</DSTSQNUM>

</taPMDistribution>

-<taPMDistribution>

<DISTTYPE>10</DISTTYPE>

<VENDORID>BRADKOWA01</VENDORID>

<CRDTAMNT>0</CRDTAMNT>

<DistRef>BCPUR-7%GST</DistRef>

<ACTNUMST>1-0000-2102</ACTNUMST>

<DEBITAMT>50</DEBITAMT>

<DOCTYPE>1</DOCTYPE>

<VCHRNMBR>00000000000487051</VCHRNMBR>

<DSTSQNUM>65536</DSTSQNUM>

</taPMDistribution>

</taPMDistribution_Items>

-<taPMTransactionInsert>

<UpdateIfExists>1</UpdateIfExists>

<DOCNUMBR>EXP1230918</DOCNUMBR>

<VENDORID>BRADKOWA01</VENDORID>

<DOCDATE>2023-7-12</DOCDATE>

<BACHNUMB>TEST20230918</BACHNUMB>

<DOCAMNT>1050</DOCAMNT>

<CREATEDIST>1</CREATEDIST>

<CHRGAMNT>1050</CHRGAMNT>

<TAXSCHID>BCPUR-PSTEXEMPT</TAXSCHID>

<DOCTYPE>1</DOCTYPE>

<VCHNUMWK>00000000000487051</VCHNUMWK>

<TAXAMNT>0</TAXAMNT>

<PRCHAMNT>1050</PRCHAMNT>

</taPMTransactionInsert>

</PMTransactionType>

</eConnect>

Can you please let me know what is the issue here?

Thanks in advance,