Finance | Project Operations, Human Resources, ...

Sales Batch corrupted almost every time for one user only

(0) Share

Report

Posted on by Bill Campbell

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?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Sales Batch corrupted almost every time for one user only

Bill,

This sounds very strange and unusual..

Have you checked if the user runs into the same issues when being a "POWERUSER" in the system ? that would be a sign of insufficient permissions..

if not, I'd bet on a some corrupt user profile or some technical network issues with the user's GP client..

This could be a case for GPPT and DEXSQL tracing...

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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’

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,069 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

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.

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: Sales Batch corrupted almost every time for one user only

Update on the case notes

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No