Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Accounts Distributions issue for Flat fee item through Econnect

Posted on by 180

Hi All,

I'm creating the order in GP through eConnnect then i'm transferring to Invoice.But those DISTRIBUTION Accounts are mismatch for ITEM2 item.

Posting accounts from ITEM ( SET UP LEVEL -- Client have configured in GP).

For ex: (From my scenario)

ITEM1 ( FLAT FEE item Type ),ITEM2 ( SIMPLE Item ) and ITEM3 (FLAT FEE item Type) has items . if simple item is not exists in GP then we will the create the Item.then generate the Order in GP. But when i'm transferring from order to Invoice in GP. Those distribution accounts are showing Wrong .

please suggest me ,if is there any wrong from my end ?.

My XML is like below.

-<taSopLineIvcInsert_Items>


-<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<CUSTNMBR>474947</CUSTNMBR>

<DOCDATE>02/26/2019</DOCDATE>

<ITEMNMBR>ITEM1</ITEMNMBR>

<UNITPRCE>59</UNITPRCE>

<XTNDPRCE>59</XTNDPRCE>

<QUANTITY>1</QUANTITY>

<DOCID>CHD</DOCID>

<ITMTSHID>PA</ITMTSHID>

<TAXSCHID>PA</TAXSCHID>

<SHIPMTHD>UPS GROUND</SHIPMTHD>

<DEFEXTPRICE>1</DEFEXTPRICE>

<UOFM>EACH</UOFM>

</taSopLineIvcInsert>


-<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<CUSTNMBR>474947</CUSTNMBR>

<DOCDATE>02/26/2019</DOCDATE>

<ITEMNMBR>ITEM2</ITEMNMBR>

<UNITPRCE>499</UNITPRCE>

<XTNDPRCE>499</XTNDPRCE>

<QUANTITY>1</QUANTITY>

<DOCID>CHD</DOCID>

<ITMTSHID>PA</ITMTSHID>

<TAXSCHID>PA</TAXSCHID>

<SHIPMTHD>UPS GROUND</SHIPMTHD>

<DEFEXTPRICE>1</DEFEXTPRICE>

<UOFM>EACH</UOFM>

</taSopLineIvcInsert>


-<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<CUSTNMBR>474947</CUSTNMBR>

<DOCDATE>02/26/2019</DOCDATE>

<ITEMNMBR>ITEM3</ITEMNMBR>

<UNITPRCE>-59</UNITPRCE>

<XTNDPRCE>-59</XTNDPRCE>

<QUANTITY>1</QUANTITY>

<DOCID>CHD</DOCID>

<ITMTSHID>PA</ITMTSHID>

<TAXSCHID>PA</TAXSCHID>

<SHIPMTHD>UPS GROUND</SHIPMTHD>

<DEFEXTPRICE>1</DEFEXTPRICE>

<UOFM>EACH</UOFM>

</taSopLineIvcInsert>

</taSopLineIvcInsert_Items>

<taSopLineIvcInsertComponent_Items xsi:nil="true"/>

<taSopTrackingNum_Items xsi:nil="true"/>

<taSopCommissions_Items xsi:nil="true"/>

<taSopLineIvcTaxInsert_Items xsi:nil="true"/>


-<taCreateSopPaymentInsertRecord_Items>


-<taCreateSopPaymentInsertRecord>

<SOPTYPE>2</SOPTYPE>

<CUSTNMBR>474947</CUSTNMBR>

<DOCAMNT>271.34</DOCAMNT>

<CHEKBKID>PETTY CASH</CHEKBKID>

</taCreateSopPaymentInsertRecord>

</taCreateSopPaymentInsertRecord_Items>


-<taSopUserDefined>

<SOPTYPE>2</SOPTYPE>

<USRTAB03>a0X3D000003wRruUAE</USRTAB03>

<USERDEF1>Salesforce</USERDEF1>

</taSopUserDefined>


-<taSopDistribution_Items>


-<taSopDistribution>

<SOPTYPE>2</SOPTYPE>

<DISTTYPE>21</DISTTYPE>

<ACTINDX>26</ACTINDX>

<CUSTNMBR>474947</CUSTNMBR>

</taSopDistribution>

</taSopDistribution_Items>

<taAnalyticsDistribution_Items xsi:nil="true"/>

<taSopMultiBin_Items xsi:nil="true"/>


-<taSopHdrIvcInsert>

<SOPTYPE>2</SOPTYPE>

<DOCID>CHD</DOCID>

<TAXSCHID>PA</TAXSCHID>

<FRTSCHID>PA</FRTSCHID>

<SHIPMTHD>UPS GROUND</SHIPMTHD>

<LOCNCODE>MAIN</LOCNCODE>

<DOCDATE>02/26/2019</DOCDATE>

<FREIGHT>12.95</FREIGHT>

<TRDISAMT>0</TRDISAMT>

<CUSTNMBR>474947</CUSTNMBR>

<CUSTNAME>laxman sankar2</CUSTNAME>

<CSTPONBR>28-4875</CSTPONBR>

<SUBTOTAL>499</SUBTOTAL>

<PYMTRCVD>271.34</PYMTRCVD>

<BACHNUMB>SFDCORDER</BACHNUMB>

<PRBTADCD>PRIMARY</PRBTADCD>

<CREATETAXES>1</CREATETAXES>

<DEFTAXSCHDS>1</DEFTAXSCHDS>

<FREIGTBLE>3</FREIGTBLE>

<PRCLEVEL>RETAIL</PRCLEVEL>

<DEFPRICING>1</DEFPRICING>

<NOTETEXT>a0X3D000003wRruUAE</NOTETEXT>

</taSopHdrIvcInsert>

Distribution Account is 100-9999-999-4932 as shown in below pic.

image_5F00_G1.png

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans