Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / REQUEST FOR RESOLUTION...
Microsoft Dynamics GP (Archived)

REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All

 

Firstly, I hearltly thank you for uour guidance for resolving Rexiept QTYs do not match IV QTYs in Inventory Validation report.

My second problem- this transaction has been marked for posting is still unresolved. However i have followed the following guidance as provided by your goodself . When i enter affected assembly batch number which are in transaction entry window in the BACHNUMB=XXX palce in the follwing script  and execute querry then sql give me result that now rows affected.

Therefore i request you to kindly provide me solution to second problem.

I will be grateful for your prompt response.

 

Regards

 

MIK

As for the second issue, check MKDTOPST and BCHSTTUS fields on SY00500, in case they were not equal to (zero), you need to correct them by running the following script.

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

Before running the script, please check the following tables;

-  DYNAMICS..SY00800

-  DYNAMICS..SY00801

-  DYNAMICS..ACTIVITY  

-  TEMPDB..DEX_LOCK

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    Restore this compnay back to the point prior to doing the deletion. Then go into GP Inventory Transaction Batches and create a new assembly batch with the same batch name as this transaction. This should then allow you to print out the edit list. Hopefully the edit list will give you a clue as to what GP thinks is wrong.

  • Community Member Profile Picture
    Community Member on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    Thank you for your valueable solution.

    When we have applied the above steps in our GP test enviroment the error this transaction is assigned to a batch that has been marked for postin g is removed and GP shows this transaction as posted. However when we check the inventory item inquiry which is affected by the batch the enquiry shows it as allocated quantity. when we drill allocated quantity then we have  identified that it is due to stucked assembly transaction when we open that assembly transaction document number then GP shows that you cannot zoom to this document because it is no longer exist in bill of material.

    Can you plese guide to resolve why GP shows that you cannot zoom to this documentrs becaiuse it is no longer exist in bill of material.

    Regards

    MIK

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    BM10200 is the transaction header and BM10300 is the transaction detail. They are tied together by a field called TRX_ID.

    Step 1) SELECT * from BM10200 and take note of the value of DEX_ROW_ID

    Step 2) SELECT * from BM10300 where TRX_ID equals that of BM10200 for the transaction in question and take note of the DEX_ROW_ID value

    Step 3) DELETE BM10200 WHERE DEX_ROW_ID = as found in Step 1

    Step 4) DELETE BM10300 WHERE DEX_ROW_ID = as found in step 2

    Now if you can see this record in GP I would jsut pull it up and hit the DELETE button.

    Make sure you have a backup before doing any of this.

    If you see inventory adjusted and the ledger adjusted, it is alright to just delete this record as it just got left behind.

  • Community Member Profile Picture
    Community Member on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    Dear Rishard

    Can you please guide on the followings

    which should we select from bm10200  and bm 10300.is it batch number or assembly trasnsaction number.

    Yea this transaction get posted and now it is just left behind.

    yea inventory was adjusted.

    Thanks and Regards

    mik

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    If you run these, do you see your transaction?

    select * from bm10200

    select * from bm10300

    Did this transaction actually get posted and now it is just left behind? Do you see inventory adjusted and do you see the resulting transaction in the ledger?

  • Community Member Profile Picture
    Community Member on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    It is an inventory ssembly record.

    Yes i see it.

    Regards

    MIK

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    For my clarification, is this a purchase order receipt record that is lost or an inventory assembly record that is lost? If you try to pull up the record in GP, do you see it?

  • Community Member Profile Picture
    Community Member on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    I have also run checklink on POP , SOP and inventory series but the problem is still unresolved,

    Regards,

    MIK

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    Try running check lnks on the purchasing series. It sounds like you have orphaned record that was in a batch but has now been left behind. Make sure you perform a backup first.

  • Community Member Profile Picture
    Community Member on at
    RE: REQUEST FOR RESOLUTION OF GP-2010 ERROR : THIS Transaction HAS BEEN MARKED FOR POSTING

    Dear Richard,

    I heartly thank you for your precious advice.

    unfortunately our problem is not resolved.

    Firstly, I  checked the stuched batch in batch recovery window . the stucked batch was not shown inbatch recovery window.

    As a result i checked the batch in SyS 00500 i have not found the question batch in this table . however the stucked batch exist in transactin entry inquiry window.

    Can you  please guide us do you have any other resolution for this issue.

    Thanks and Kind regards

    MIK

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans