0

Error: aaTrxDimCode is the same on all the taPopRcptLineInsert.

Cause: It would appear that the details of all the taAnalyticsDistribution are given to each of the articles, instead of one for each. This happens at the end of the xml, on taAnalyticsDistribution.

Objective: Each taPopRcptLineInsert gets an individual taAnalyticsDistribution. I want this specifically for the aaTrxDimCode. Each taPopRcptLineInsert has a different (not unique) aaTrxDimCode.

Example:

<taPopRcptLineInsert_Items>
            <taPopRcptLineInsert>
                <POPTYPE>3</POPTYPE>
                <POPRCTNM>1234</POPRCTNM>
                <ITEMNMBR>CONCEPT 1</ITEMNMBR>
                <ITEMDESC>CONCEPT 1</ITEMDESC>
                <TAXDTLID>TAX PLAN 1</TAXDTLID>
                <VENDORID>ABCD</VENDORID>
                <RCPTLNNM>16384</RCPTLNNM>
                <VNDITNUM>CONCEPT 1</VNDITNUM>
                <VNDITDSC>CONCEPT 1</VNDITDSC>
                <LOCNCODE>73993</LOCNCODE>
                <INVINDX>0</INVINDX>
                <UOFM>PZ</UOFM>
                <UNITCOST>52</UNITCOST>
                <EXTDCOST>156</EXTDCOST>
                <NONINVEN>0</NONINVEN>
                <QTYSHPPD>3</QTYSHPPD>
                <QTYINVCD>3</QTYINVCD>
                <TAXAMNT>24.96</TAXAMNT>
                <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
                <Purchase_Site_Tax_Schedu>TAX PLAN 1</Purchase_Site_Tax_Schedu>
                <AUTOCOST>0</AUTOCOST>
            </taPopRcptLineInsert>
        </taPopRcptLineInsert_Items>
        <taPopRcptLineTaxInsert_Items>
            <taPopRcptLineTaxInsert>
                <VENDORID>ABCD</VENDORID>
                <POPRCTNM>1234</POPRCTNM>
                <TAXDTLID>TAX PLAN 1</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <TAXAMNT>24.96</TAXAMNT>
                <TAXPURCH>156</TAXPURCH>
                <TOTPURCH>156</TOTPURCH>
                <RCPTLNNM>16384</RCPTLNNM>
            </taPopRcptLineTaxInsert>
        </taPopRcptLineTaxInsert_Items>
        <taAnalyticsDistribution_Items>
            <taAnalyticsDistribution>
                <DOCNMBR>1234</DOCNMBR>
                <DOCTYPE>3</DOCTYPE>
                <ACTINDX>2065</ACTINDX>
                <ACTNUMST>5-50-004-00001</ACTNUMST>
                <aaTrxDim>SUCURSAL</aaTrxDim>
                **<aaTrxDimCode>73993</aaTrxDimCode>**
                **<aaSubLedgerAssignID>1</aaSubLedgerAssignID>**
            </taAnalyticsDistribution>
        </taAnalyticsDistribution_Items>

        <taPopRcptLineInsert_Items>
            <taPopRcptLineInsert>
                <POPTYPE>3</POPTYPE>
                <POPRCTNM>1234</POPRCTNM>
                <ITEMNMBR>CONCEPT 1</ITEMNMBR>
                <ITEMDESC>CONCEPT 1</ITEMDESC>
                <TAXDTLID>TAX PLAN 1</TAXDTLID>
                <VENDORID>ABCD</VENDORID>
                <RCPTLNNM>32768</RCPTLNNM>
                <VNDITNUM>CONCEPT 1</VNDITNUM>
                <VNDITDSC>CONCEPT 1</VNDITDSC>
                <LOCNCODE>70267</LOCNCODE>
                <INVINDX>0</INVINDX>
                <UOFM>PZ</UOFM>
                <UNITCOST>52</UNITCOST>
                <EXTDCOST>156</EXTDCOST>
                <NONINVEN>0</NONINVEN>
                <QTYSHPPD>3</QTYSHPPD>
                <QTYINVCD>3</QTYINVCD>
                <TAXAMNT>24.96</TAXAMNT>
                <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
                <Purchase_Item_Tax_Schedu>TAX PLAN 1</Purchase_Item_Tax_Schedu>
                <Purchase_Site_Tax_Schedu>TAX PLAN 1</Purchase_Site_Tax_Schedu>
                <AUTOCOST>0</AUTOCOST>
            </taPopRcptLineInsert>
        </taPopRcptLineInsert_Items>
        <taPopRcptLineTaxInsert_Items>
            <taPopRcptLineTaxInsert>
                <VENDORID>ABCD</VENDORID>
                <POPRCTNM>1234</POPRCTNM>
                <TAXDTLID>TAX PLAN 1</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <TAXAMNT>24.96</TAXAMNT>
                <TAXPURCH>156</TAXPURCH>
                <TOTPURCH>156</TOTPURCH>
                <RCPTLNNM>32768</RCPTLNNM>
            </taPopRcptLineTaxInsert>
        </taPopRcptLineTaxInsert_Items>
        <taAnalyticsDistribution_Items>
            <taAnalyticsDistribution>
                <DOCNMBR>1234</DOCNMBR>
                <DOCTYPE>3</DOCTYPE>
                <ACTINDX>2065</ACTINDX>
                <ACTNUMST>5-50-004-00001</ACTNUMST>
                <aaTrxDim>SUCURSAL</aaTrxDim>
                **<aaTrxDimCode>70267</aaTrxDimCode>**
                **<aaSubLedgerAssignID>2</aaSubLedgerAssignID>**
            </taAnalyticsDistribution>
        </taAnalyticsDistribution_Items>


        <taPopRcptHdrInsert>
            <POPRCTNM>1234</POPRCTNM>
            <POPTYPE>3</POPTYPE>
            <VNDDOCNM>1234</VNDDOCNM>
            <receiptdate>05/01/2023</receiptdate>
            <BACHNUMB>PRUEBA 1N-1</BACHNUMB>
            <VENDORID>ABCD</VENDORID>
            <SUBTOTAL>312</SUBTOTAL>
            <TAXAMNT>49.92</TAXAMNT>
            <TAXSCHID>TAX PLAN 2</TAXSCHID>
            <USER2ENT>sa</USER2ENT>
            <WITHHAMT>0</WITHHAMT>
            <AUTOCOST>0</AUTOCOST>
            <CREATEDIST>1</CREATEDIST>
            <REFRENCE>1234</REFRENCE>
        </taPopRcptHdrInsert>

I know this is kind-of ancient tech, but it's what I have to deal with. I've been trying to come up with a solution but I could really use some help.

Best regards.

Nothing that tackled the problem itself. Just misinterpretations on my end.

Tobubas
  • 1
  • 2

0 Answers0