Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Sales Batch corrupted almost every time for one user only

Posted on by 22,647

When one user out of seven users prepares a sales batch it is being corrupted some how and after creating the batch, doing the data entry, the user can not post the batch.  The user, then has to move the transactions into another batch and then posts from that batch.

The other batch then shows in the application as having NEGATIVE transactions -> -10 transactions and the other batch that is created only to post will show 10 transactions (no negative)

This is not happening every time, as the user is able to create a batch, and move the other transactions over to the other batch.

Any suggestions?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Sales Batch corrupted almost every time for one user only

    Beat, thanks for the extra steps and suggestion on this matter.  I will working on this after hours tonight and will post an update when complete.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Sales Batch corrupted almost every time for one user only

    Bill,

    I'd suggest to download and install GPPT (if the customer isn't already a client of it) and use the "Enable Dex Trace" function right before they try to add some transactions to the batch or create a new batch.

    The captured DEXSQL.Log would then help to identify what's happening behind the scene...I'm fearing that there is some 3rd-party app in the game here... or some rogue script/trigger in SQL.

    Beat

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Sales Batch corrupted almost every time for one user only

    If you run check links on the sales transaction open table does it correct the batch totals?

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Sales Batch corrupted almost every time for one user only

    Update on the case notes

    pastedimage1665503016205v1.png

    Asked the user who is encountering the issue to create a new batch - ORDERS22

    She then moved 48 orders from the ORDERS batch - note in the post above - that the NUMOFTRX in ORDERS was -4 (the challenge) and then when user moved them to a new batch - the NUMOFTRX is now showing as -58 and the NUMOFTRX in the new ORDERS22 batch is not showing at 48 - the number of good transactions client actual created.

    Note that the 48 orders in the new batch, was the same number that ORDERS showed before the 'event' that reset the count to -4

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Sales Batch corrupted almost every time for one user only

    Here is how to create a DEXSQL.LOG.

    https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/create-a-dexsql-dot-log-file-troubleshoot

    If this user logs into a different computer does the problem follow him/her?

    Have you tried copying the complete GP program folder from another workstation?

    Any third-party products or something in the GP Addins folder? Check what is in your DYNAMICS.SET file.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Sales Batch corrupted almost every time for one user only

    Moring All,

    So based on the notes above, I have

    1) made user power user
    2) create a new suer profile
    3) cleaned out the %TEMP% folder
    4) applied the security scripts.

    Here is a screen shot - after the updates, but before the user has tried anything since the overall reset of the batch.  pastedimage1665457595791v1.png

    I will be proceeding to GP Power Tools after discussion with client.  Richard / David either of you have any suggestion on what to run next?

    Thanks.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,831 Moderator on at
    RE: Sales Batch corrupted almost every time for one user only

    Hi Bill 

    We could use GP Power to identify the cause of the data being corrupted in the tables.  This is exactly what the Support Debugging Tool was created for.

    It solved a case that had been running for 12 months without progress. Identifed the cause within 4 days of being implemented.

    Regards

    David 

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Sales Batch corrupted almost every time for one user only

    Bill,

    it could be anything... did you made sure the latest security script for the GP 18.4 code were added to the security tables ? Microsoft has published with every major year update new security scripts to run to add to the GP security.

    Now, if that user is a "Poweruser" that wouldn't matter...

    I'm wondering from your initial post if there isn't any 3rd-party code or custom code that comes into the play.. the thing with negative values in the transactions bugs me quite a bit... why would GP randomly reverse some of the SOP transactions values to a negative sign ???

    Is this user using DrophShipping ? could it be that the user accidentally hits the checkbox in the line item for a DropShip ?

    Just throwing out ideas to follow... what about creating another user account in GP for this user and copy the security over from the old account..

    And, last but not least, make sure the %TEMP% folder is clean.. i've recently ran into some troubleshooting with customers where the %TEMP% folder location was not cleared out by GP and full of junk.. happens more likely on local computers than on Terminal Server, but not exclusively.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Sales Batch corrupted almost every time for one user only

    Forgot to mention that this user profile has not been changed in a long time - the user has full access to everything - and has since the installation of GP - seems that this issue started with the recent update to 18.4

    Interesting that it is not effecting other Sales Order users at this office.  I have checked with 3 or 4 other clients and none of them are reporting issues with Sales Order batch processing.

    Is there any possibility that this is local user code?  I would believe that the code to create a batch is from the SQL scripts and triggers and that the local code (machine installed) would / should not effect those processes.  If this is correct, then all users in the client install should be experiencing the same problem.

    If user profile based, then would moving the user to a different machine make a difference?  

    Anyway, just thinking out loud, hoping someone will read and provide some direction and lead me to a solution.  Senior management at the client site is not pleased with continued errors

    Thanks all,

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Sales Batch corrupted almost every time for one user only

    Beat wondering if you could PM me with some idea on how to do DEXSQL trace - I just don’t want to waste a bunch of time on something someone might already know how to resolve.

    ‘If you are on What’s App - that is a great way to connect’

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans