web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Receivings: Tax Amount...
Finance | Project Operations, Human Resources, ...
Unanswered

Receivings: Tax Amount removed from Credit distribution

(0) ShareShare
ReportReport
Posted on by chadbruels 1,588

I am importing Shipment/Invoice transactions via eConnect and everything is correct until I view the transaction in GP. Immediately upon selecting the transaction in the Receivings Transaction Entry window the distributions are recalculated and the Credited PAY distribution is reduced by the amount of the TAX distributions. In the POP10390 table I confirmed it is good before viewing the transaction and refresh the table after bring it up.

Items are non-inventoried. No tax is provided on the line, just at the header level as this is how my client does this currently. And actually, I can replicate the behavior by entering a transaction manually and then clicking the Default button in the Distributions window. That is a button the client never uses as they don't experience this today with their manually processed transactions. 

Here is XML from an import. You can see I am sending 1 for USINGHEADERLEVELTAXES

<eConnect xmlns:xsi="">www.w3.org/.../XMLSchema-instance" xmlns:xsd="">www.w3.org/.../XMLSchema">
<POPReceivingsType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateVendorRcd xsi:nil="true" />
<taCreateVendorAddress_Items xsi:nil="true" />
<taPopRcptLotInsert_Items xsi:nil="true" />
<taPopRcptSerialInsert_Items xsi:nil="true" />
<taPopRcptLineInsert_Items>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT00033513</POPRCTNM>
<PONUMBER>PO16134</PONUMBER>
<ITEMNMBR>2KYAD</ITEMNMBR>
<ITEMDESC>OIL FILTER</ITEMDESC>
<VENDORID>GRAINGER01</VENDORID>
<InventoryAccount>9002-6300</InventoryAccount>
<UNITCOST>8.74</UNITCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>2.000</QTYSHPPD>
<QTYINVCD>2.000</QTYINVCD>
<Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
<Purchase_Item_Tax_Schedu>CALIFORNIA</Purchase_Item_Tax_Schedu>
</taPopRcptLineInsert>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT00033513</POPRCTNM>
<PONUMBER>PO16134</PONUMBER>
<ITEMNMBR>2KYA8</ITEMNMBR>
<ITEMDESC>FUEL FILTER</ITEMDESC>
<VENDORID>GRAINGER01</VENDORID>
<InventoryAccount>9002-6300</InventoryAccount>
<UNITCOST>8.32</UNITCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>2.000</QTYSHPPD>
<QTYINVCD>2.000</QTYINVCD>
<Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
<Purchase_Item_Tax_Schedu>CALIFORNIA</Purchase_Item_Tax_Schedu>
</taPopRcptLineInsert>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT00033513</POPRCTNM>
<PONUMBER>PO16134</PONUMBER>
<ITEMNMBR>19YP70</ITEMNMBR>
<ITEMDESC>SOLDER WIRE</ITEMDESC>
<VENDORID>GRAINGER01</VENDORID>
<InventoryAccount>9002-6300</InventoryAccount>
<UNITCOST>34.37</UNITCOST>
<NONINVEN>1</NONINVEN>
<QTYSHPPD>1.000</QTYSHPPD>
<QTYINVCD>1.000</QTYINVCD>
<Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
<Purchase_Item_Tax_Schedu>CALIFORNIA</Purchase_Item_Tax_Schedu>
</taPopRcptLineInsert>
</taPopRcptLineInsert_Items>
<taPopRcptMultiBin_Items xsi:nil="true" />
<taPopRcptLineTaxInsert_Items>
<taPopRcptLineTaxInsert>
<VENDORID>GRAINGER01</VENDORID>
<POPRCTNM>RCT00033513</POPRCTNM>
<TAXDTLID>CALIFORNIA</TAXDTLID>
<TAXTYPE>0</TAXTYPE>
<ACTNUMST>9002-7020</ACTNUMST>
<TAXAMNT>5.65</TAXAMNT>
<TAXPURCH>68.49000</TAXPURCH>
</taPopRcptLineTaxInsert>
</taPopRcptLineTaxInsert_Items>
<taPopRctUserDefined xsi:nil="true" />
<taPopDistribution_Items>
<taPopDistribution>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT00033513</POPRCTNM>
<ACTNUMST>9002-6300</ACTNUMST>
<DEBITAMT>68.49000</DEBITAMT>
<DISTTYPE>1</DISTTYPE>
<VENDORID>GRAINGER01</VENDORID>
</taPopDistribution>
<taPopDistribution>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT00033513</POPRCTNM>
<ACTNUMST>9002-7020</ACTNUMST>
<DEBITAMT>5.65</DEBITAMT>
<DISTTYPE>5</DISTTYPE>
<VENDORID>GRAINGER01</VENDORID>
</taPopDistribution>
<taPopDistribution>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT00033513</POPRCTNM>
<ACTNUMST>0000-2000 </ACTNUMST>
<CRDTAMNT>74.14000</CRDTAMNT>
<DISTTYPE>7</DISTTYPE>
<VENDORID>GRAINGER01</VENDORID>
</taPopDistribution>
</taPopDistribution_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taPopRcptHdrInsert>
<POPRCTNM>RCT00033513</POPRCTNM>
<POPTYPE>3</POPTYPE>
<VNDDOCNM>9825280218</VNDDOCNM>
<receiptdate>03/04/2021</receiptdate>
<BACHNUMB>20210401181537</BACHNUMB>
<VENDORID>GRAINGER01</VENDORID>
<TAXAMNT>5.65</TAXAMNT>
<TAXSCHID>CALIFORNIA</TAXSCHID>
<USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
<CREATEDIST>0</CREATEDIST>
</taPopRcptHdrInsert>
<taMdaUpdate_Items xsi:nil="true" />
</POPReceivingsType>
</eConnect>

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Isaac Olson Profile Picture
    Isaac Olson on at

    Hi Chad,

    My Distributions calculated properly through eConnect with your XML.  They also did not automatically recalculate when I pulled the transaction up, they stayed correct.  That part seems odd, like maybe they have a customization or something that is calling it to recalculate when they select the transaction as our windows do not currently do this by default. 

    The only way that they would recalculate was if I clicked the default button.  If I clicked the Default button, then I could reproduce what you are seeing where the PAY account does not recalculate to include the header level tax amount in it.  This second issue with the default button is one that we had documented as a quality issue, that is still outstanding as of now as it is a rare like you mentioned that users would click the default distribution button. 

    My recommendation would be to look into why in this environment, the distributions are being automatically recalculated without clicking the default button as that is not natural functionality that I have seen in our supported versions, and like you said, the distributions do come in properly as long as they do not get recalculated, and it should not be automatically recalculating just by pulling up the transaction.

    I will leave this open the to community in case anyone else has ran into what you are seeing specifically and we can update the thread if a different resolution is found.

    Thanks,

    Isaac Olson

    Microsoft Support  

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    By searching through the source code of both Dynamics GP and eConnect, I have found the reason distributions are recalculated when viewing the transaction in Receivings Transaction Entry.

    The eConnect script taPOPRcptHdrInsert does not set the value of Currency ID or Currency Index in the table POP10300. In my scenario I have non-inventoried items and there is a check on this table that will always return 0 records and that has the effect of this script never setting these currency fields. When pulling up the transaction in Receivings Transaction Entry there is code that checks whether the transaction is multicurrency, this check returns a false condition and the result is to call a script to set the Currency ID. That series of calls eventually runs RecalcDistributions of form POP_Receipt.

    To resolve the issue I have modified taPopRcptHdrInsertPost with code to set the Currency ID and Currency Index field to the Functional Currency. Here is that code.

    declare @FUNLCURR char(15), @FCURRNIDX int

    select @FUNLCURR = FUNLCURR,

    @FCURRNIDX = IsNull(FUNCRIDX, 0)

    from MC40000

    update POP10300

    set CURNCYID = @FUNLCURR,

    CURRNIDX = @FCURRNIDX

    from POP10310

    where POP10300.POPRCTNM = @I_vPOPRCTNM

    and POP10300.CURNCYID = ''

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans