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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / bchsourc has an asteri...
Microsoft Dynamics GP (Archived)

bchsourc has an asterisk - delete from the database?

(0) ShareShare
ReportReport
Posted on by martink 890

Can transactions/ batches where bchsourc has an "*" asterisk be deleted from the database? I'm asking about open or work tables, SOP and POP mostly.  I know we delete these from the SY tables to clear locked users or transactions.  Can we also delete these from the POP and SOP tables like 10100, 10300 ?

*This post is locked for comments

I have the same question (0)
  • Ajit K Profile Picture
    Ajit K 957 on at
    Re: bchsourc has an asterisk - delete from the database?

    Hi,

    Bchsource gets this '**' asterisk when posting gets interupted and when interupted batch has been restored through batch recovery. You will have to make sure the transaction is getting posted properly before deleting it from tables. Deletion from tables is possible.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: bchsourc has an asterisk - delete from the database?

    I would add that if you find documents in the SOP10100 table with BACHNUMB='*batchname' check the SOP30300 table to see if it made it to History.  Just compare SOP1000.SOPNUMBE=SOP30200 and SOP10100.SOPTYPE=SOP30200.SOPTYPE. If there is a match you should be able to delete it as most likely all the adjustments to inventoiry did occur.

  • martink Profile Picture
    martink 890 on at
    Re: bchsourc has an asterisk - delete from the database?

    These were in the POP tables. And yes posting was interrupted.  We have a PO that had items received against it. And everything but the PO shows the correct received amount.  The PO shows in Open and History.  I was thinking I could rename the bach (it's the userid) and try it??

    Interistingly i found literaly hundreds of asterisk batched in the POP30300 tables

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: bchsourc has an asterisk - delete from the database?

    As a general rule, I would not recommend deleting anything from tables unless you are 100% sure of the implications.  

    An asterisk in the beginning of a batch source and a batch ID that is a user ID simply means that the user did not save their transaction into a batch before posting.  There is nothing wrong with these transactions and this is allowed behavior in GP.  

    If posting was interrupted, and the posting was not able to recover on its own, first steps are typically  to run check links and/or reconcile.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans