Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / New twist on an old topic
Finance | Project Operations, Human Resources, ...
Suggested answer

New twist on an old topic

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730

User is getting the usual 'Your previous transaction level posting has not finished..." message. In this case she does get the message to run batch recovery but there is nothing to recover as the transaction made it down to the ledger.. In the SY00500 I see the batch with her name in it and the solution is to delete that record. The problem is when she does some more receivables transactions this record will return and the error repeats. I tried running GRANT.SQL and the next thing I will try is dropping her GP user and recreating unless someone has a better idea.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: New twist on an old topic

    maybe this blog post from Steve Endow might give a hint:
    dynamicsgpland.blogspot.com/.../importing-sop-orders-with-sales-taxes.html

    eOne has a good article about the SOP transaction import with Smartconnect by using eConnect
    www.eonesolutions.com/.../

    And this is the official Docs link for the econnect nodes:
    https://docs.microsoft.com/en-us/previous-versions/dynamicsgp/developer/ff623968(v=msdn.10)

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New twist on an old topic

    This is where I am confused. I do not see the method </taSopLineIvcInsert_Items> listed in the list of XML Node reference.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: New twist on an old topic

    Thanks Richard,

    You may want to be careful and redact (or replace by X's ) the personal data (like e-mail) from the code..

    The sopHeader insert is a separate step, usually comes after the sopDetails insert..

    the relevant data is here:

        <taSopLineIvcTaxInsert>
          <SOPTYPE>2</SOPTYPE>
          <TAXTYPE>1</TAXTYPE>
          <SOPNUMBE>PWEB0004696318</SOPNUMBE>
          <CUSTNMBR>CWEB00003701699</CUSTNMBR>
          <SALESAMT>25.98</SALESAMT>
          <TAXDTLID>MN</TAXDTLID>
          <STAXAMNT>0.53</STAXAMNT>

    this indicates that the Sales Taxes are provided by the source data in fact.. and this KB article details the process :

    support.microsoft.com/.../sample-xml-document-that-you-can-use-to-import-tax-information-for-a-sales-order-processing-transaction-in-econnect-for-microsoft-dynamics-gp-619111e2-77d7-f362-06ad-1953124b50aa

    in the above KB link, the SopHeader part that is missing is showing the trigger for the CreateTaxes, which is at 0 and the DefaultTaxSchds flag which is at 0 too.

    This link provides the values description behind the codes:

    dynamicbusinesssolutions.ru/.../ecpg_ch26_xmlnodereference1535921.htm

    In your case, the TaxType = 1 means "Freight"...

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New twist on an old topic

    I was able to get part of an xml file. There must be more because I do not see the sophdrinsert in this.

    <?xml version="1.0" encoding="utf-16"?>

    <eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">

     <SOPTransactionType>

       <eConnectProcessInfo xsi:nil="true" />

       <taRequesterTrxDisabler_Items xsi:nil="true" />

       <taUpdateCreateItemRcd xsi:nil="true" />

       <taUpdateCreateCustomerRcd>

         <CUSTNMBR>CWEB00003701699</CUSTNMBR>

         <CUSTNAME>Cole Carlson</CUSTNAME>

         <PRSTADCD>SHIPTO</PRSTADCD>

         <PRBTADCD>BILLTO</PRBTADCD>

         <USERDEF1>colecarlson829@gmail.com</USERDEF1>

         <PRCLEVEL>RETAIL</PRCLEVEL>

         <CRLMTTYP>2</CRLMTTYP>

         <CRLMTAMT>250</CRLMTAMT>

         <MXWOFTYP>2</MXWOFTYP>

         <MXWROFAM>5.00</MXWROFAM>

         <ToEmail_Recipient>colecarlson829@gmail.com</ToEmail_Recipient>

         <USRDEFND1>colecarlson829@gmail.com</USRDEFND1>

       </taUpdateCreateCustomerRcd>

       <taCreateCustomerAddress_Items>

         <taCreateCustomerAddress>

           <CUSTNMBR>CWEB00003701699</CUSTNMBR>

           <ADRSCODE>SHIPTO</ADRSCODE>

           <ADDRESS1>15779 AVOCET ST NW</ADDRESS1>

           <COUNTRY>US</COUNTRY>

           <CITY>ANDOVER</CITY>

           <STATE>MN</STATE>

           <ZIPCODE>55304</ZIPCODE>

           <PHNUMBR1>7633134390</PHNUMBR1>

           <CCode>US</CCode>

           <USERDEF1>colecarlson829@gmail.com</USERDEF1>

         </taCreateCustomerAddress>

         <taCreateCustomerAddress>

           <CUSTNMBR>CWEB00003701699</CUSTNMBR>

           <ADRSCODE>BILLTO</ADRSCODE>

           <ADDRESS1>15779 AVOCET ST NW</ADDRESS1>

           <COUNTRY>US</COUNTRY>

           <CITY>ANDOVER</CITY>

           <STATE>MN</STATE>

           <ZIPCODE>55304</ZIPCODE>

           <PHNUMBR1>7633134390</PHNUMBR1>

           <CCode>US</CCode>

           <USERDEF1>colecarlson829@gmail.com</USERDEF1>

         </taCreateCustomerAddress>

       </taCreateCustomerAddress_Items>

       <taSopSerial_Items xsi:nil="true" />

       <taSopLotAuto_Items xsi:nil="true" />

       <taSopLineIvcInsert_Items>

         <taSopLineIvcInsert>

           <SOPTYPE>2</SOPTYPE>

           <SOPNUMBE>PWEB0004696318</SOPNUMBE>

           <CUSTNMBR>CWEB00003701699</CUSTNMBR>

           <DOCDATE>03/07/2022</DOCDATE>

           <LOCNCODE>MAIN</LOCNCODE>

           <ITEMNMBR>ICP0HPSPBL-TSLG</ITEMNMBR>

           <UNITPRCE>25.00</UNITPRCE>

           <XTNDPRCE>25.00</XTNDPRCE>

           <QUANTITY>1</QUANTITY>

           <ITEMDESC>Insane Clown Posse - Hells Pit Splatter Black - T-Shirt Large</ITEMDESC>

           <DOCID>MORD</DOCID>

           <PRSTADCD>SHIPTO</PRSTADCD>

           <ADDRESS1>15779 AVOCET ST NW</ADDRESS1>

           <CITY>ANDOVER</CITY>

           <STATE>MN</STATE>

           <ZIPCODE>55304</ZIPCODE>

           <COUNTRY>US</COUNTRY>

           <SHIPMTHD>FIRSTCLASS</SHIPMTHD>

         </taSopLineIvcInsert>

         <taSopLineIvcInsert>

           <SOPTYPE>2</SOPTYPE>

           <SOPNUMBE>PWEB0004696318</SOPNUMBE>

           <CUSTNMBR>CWEB00003701699</CUSTNMBR>

           <DOCDATE>03/07/2022</DOCDATE>

           <LOCNCODE>MAIN</LOCNCODE>

           <ITEMNMBR>ROUTEINS10</ITEMNMBR>

           <UNITPRCE>0.98</UNITPRCE>

           <XTNDPRCE>0.98</XTNDPRCE>

           <QUANTITY>1</QUANTITY>

           <ITEMDESC>Order insurance - visit Route.com for claims</ITEMDESC>

           <DOCID>MORD</DOCID>

           <PRSTADCD>SHIPTO</PRSTADCD>

           <ADDRESS1>15779 AVOCET ST NW</ADDRESS1>

           <CITY>ANDOVER</CITY>

           <STATE>MN</STATE>

           <ZIPCODE>55304</ZIPCODE>

           <COUNTRY>US</COUNTRY>

           <SHIPMTHD>FIRSTCLASS</SHIPMTHD>

         </taSopLineIvcInsert>

       </taSopLineIvcInsert_Items>

       <taSopLineIvcInsertComponent_Items xsi:nil="true" />

       <taSopTrackingNum_Items xsi:nil="true" />

       <taSopCommissions_Items xsi:nil="true" />

       <taSopLineIvcTaxInsert_Items>

         <taSopLineIvcTaxInsert>

           <SOPTYPE>2</SOPTYPE>

           <TAXTYPE>1</TAXTYPE>

           <SOPNUMBE>PWEB0004696318</SOPNUMBE>

           <CUSTNMBR>CWEB00003701699</CUSTNMBR>

           <SALESAMT>25.98</SALESAMT>

           <TAXDTLID>MN</TAXDTLID>

           <STAXAMNT>0.53</STAXAMNT>

         </taSopL

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: New twist on an old topic

    somebody could have been in the settings recently and just decided to change the default behavior for posting Sales Transactions..

    That's why User Activity tracking for master settings should be enabled in GP.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New twist on an old topic

    She has been doing transactional posting for decades. It is only in the past couple of weeks this has popped. I will check that just to be sure.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: New twist on an old topic

    Yes,

    this is likely because the settings in GP are requiring the transactions to be posted by using batches..

    Check it out under the posting settings.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New twist on an old topic

    The problem is every time she enter transactions a batch with her name appears in the SY00500 table. I can't say I have ever seen this be reproducable before.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: New twist on an old topic

    Richard,

    Most of the time when this type of message comes up, it's because there is a locked record which will be displayed in the SY00800 table in DYNAMICS.

    I've had customers running into this multiple times, and I'd bet that the problem was an incomplete transaction, but the tough part is to find out why.. Sometimes it's because the users don't have enough permissions, sometimes it's because there distribution problems, or GP simply freezes to the user and they kill their GP session.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: New twist on an old topic

    The RM10201 is empty and the SY00500 table is clear.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans