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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Batch has been marked ...
Microsoft Dynamics GP (Archived)

Batch has been marked for posting by another user

(0) ShareShare
ReportReport
Posted on by Jason Liang 225

 Hi..guys there.

I met one issue when u use GP:

'This batch has been marketed for posting by another user'  when i try to post invoice.

The reason occurs this i think is because server suddenly shut down when i did post transaction.

The version for GP is GP 8.

So how can i settle this?

*This post is locked for comments

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,335 on at

    Jason,

    Please follow below steps to resolve issue.

    ****1) Let all users logout from Dynamics GP. and keep good backup of your Dynamics and Production company DB

     

    2) Run checklink on sales table

    3) Run Following Delete statement agains Dynamics DB

       delete ACTIVITY
       delete SY00800
       delete SY00801
     
    4) Delete statement against Temp DB
       
       delete DEX_LOCK
       delete DEX_SESSION
     
    5) very that MKDTPOST field and Bchsttus field are set to 0 for all batches in Sy00500 table
     
    Let us know how your problem solved or not.
    Thanks
    Sandip
     
     
     
  • Jason Liang Profile Picture
    Jason Liang 225 on at

     Thanks so much. dude.I will try.

    Love u.haha.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,335 on at

    No problem buddy !!!

     

    Thanks

    Sandip

  • Gina Raynard Profile Picture
    Gina Raynard 45 on at

    Sandip,

    There seems to be a batch marked for posting.  This batch has zero transactions.  I have taken the steps you outlined above along, with the addition to step 5) I added where BACHNUMB='batch_id' when resetting the two fields to 0.  The batch is still marked for posting and therefore cannot remove it.  Using Query Analzer, I did find that UPR10301 contains the Batch ID I am trying to delete.  Is is advisable to delete UPR10301?

    I appreciate any input,

    G Raynard

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,335 on at

    Gina,

    Are you facing error in Payroll Batch ? follow the below steps. Most Improtant Please please take backup of your production and dynamics DB datbase before running any below script.

     Delete DYNAMICS..UPR10300
    Delete DYNAMICS..UPR10304
    Delete UPR10200
    Delete UPR10201
    Delete UPR10202
    Delete UPR10203
    Delete UPR10204
    Delete UPR10205
    Delete UPR10206
    Delete UPR10207
    Delete UPR10208
    Delete UPR10209
    Delete UPR10213
    Delete UPR10301
    Delete UPR19900
    Delete UPR19901

     Open Windows Explorer, and then click the Temporary directory. The Temporary directory has the following path:

    C:\Windows\Temporary
    If you have Direct Deposit, run the following scripts.
    Delete DD10100 --(Direct Deposit Employee Deposit Work) 
Delete DD10200 --(Direct Deposit ACH Copy) 
Delete DD10300 --(Direct Deposit ACH Cross Reference) 
Delete DD10400 --(Direct Deposit ACH Header) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.) 
Delete DD10500 --(Direct Deposit ACH Items) - If this file is renamed or deleted, you will lose any builds in the generate ACH file window (Transactions | Payroll | Generate ACH file.) 
Delete DD10600 --(Direct Deposit Prenotes Completed) 
Delete DD10700 --(Direct Deposit Exceptions)

    Run Checklink on Payroll Transactions.

    Note If you have recurring batches, and you delete the UPR10301 file in step 1, the frequency defaults back to single use when you run the Check Links process. Before you post the batch, click Transactions, click Payroll, and then click Batches. Select the recurring batch, and then change the frequency to a frequency other than Single.

     

    For more information follow KB851664

    Again do not forgot to take backup of your Databases

    Let me know how it goes.

    Thanks

    Sandip

  • Gina Raynard Profile Picture
    Gina Raynard 45 on at

    I have asked users to log out of GP again.  Will let you know the outcome.  Thanks!

    Gina

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,335 on at

    Gina,

    I think you should have told user log out before running this script.. anyhow let see how it goes.

     

    Thanksa

    Sandip

  • Gina Raynard Profile Picture
    Gina Raynard 45 on at

    My mistake, yes I had users log out before running any scripts and updates.  I ran the script you provided and also ran the automated solution (to clear batch activity).  I'm not sure which one worked but it is now fixed.  Thanks for all your help!  I will definitely be back on this site for future issues!  Great resource!

    Gina

  • Suggested answer
    Mohamed El-Tohamy Profile Picture
    Mohamed El-Tohamy 305 on at

    1. Have all users exit Microsoft Dynamics GP and execute the following query in the SQL Query Tool against the DYNAMICS database:

    delete SY00800

    2. Execute the following queries against the Tempdb database:

    delete DEX_LOCK

    delete DEX_SESSION

    3. Run this script

    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans