GP is converting the amount field to 0 for all transactions marked as Distribution Type Cash in an Accounts Payable Transaction export. Hence when you open the transaction distribution in GP, it gives a error messages as below
-
The cash distribution(s) does not equal the actual amount
-
The Debit distributions do not equal the credit distributions.
For your reference,attaching the XML file sent to GP.
<econnect>
<PMTransactionType>
<taPMDistribution_Items>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>128</VCHRNMBR>
<VENDORID>VND-VC-001</VENDORID>
<DISTTYPE>6</DISTTYPE>
<DistRef>2T1LR32E64C829308-Excise Tax-21</DistRef>
<DEBITAMT>10</DEBITAMT>
<CRDTAMT>0</CRDTAMT>
<ACTNUMST>100-1230-1230</ACTNUMST>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>128</VCHRNMBR>
<VENDORID>VND-VC-001</VENDORID>
<DISTTYPE>6</DISTTYPE>
<DistRef>2T1LR32E64C829308-Excise Tax-21</DistRef>
<DEBITAMT>10</DEBITAMT>
<CRDTAMT>0</CRDTAMT>
<ACTNUMST>100-1230-1230</ACTNUMST>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>128</VCHRNMBR>
<VENDORID>VND-VC-001</VENDORID>
<DISTTYPE>1</DISTTYPE>
<DistRef>2T1LR32E64C829308-Excise Tax-21</DistRef>
<DEBITAMT>0</DEBITAMT>
<CRDTAMT>20</CRDTAMT>
<ACTNUMST>100-1230-1230</ACTNUMST>
</taPMDistribution>
</taPMDistribution_Items>
<taPMTransactionInsert>
<BACHNUMB>LWFAP10123013</BACHNUMB>
<VCHNUMWK>128</VCHNUMWK>
<VENDORID>VND-VC-001</VENDORID>
<DOCNUMBR>12112121212</DOCNUMBR>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>20.00</DOCAMNT>
<DOCDATE>12/1/2010</DOCDATE>
<PSTGDATE>12/30/2010</PSTGDATE>
<VADDCDPR>PRIMARY</VADDCDPR>
<PRCHAMNT>20.00</PRCHAMNT>
<CHEKBKID>FLEETMANUAL</CHEKBKID>
<TRXDSCRN>Excise Tax</TRXDSCRN>
<TEN99AMNT>0</TEN99AMNT>
<CHRGAMNT>0</CHRGAMNT>
<CHEKAMNT>20.00</CHEKAMNT>
<CHAMCBID>FLEETMANUAL</CHAMCBID>
<CHEKNMBR>2323232323</CHEKNMBR>
<CAMPYNBR>2323232323</CAMPYNBR>
<CHEKDATE>12/30/2010</CHEKDATE>
<PTDURID>Kinshuk B</PTDURID>
<CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>
</PMTransactionType>
</econnect>