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 SL (Archived) / Any way to "kill...
Microsoft Dynamics SL (Archived)

Any way to "kill" a batch

(0) ShareShare
ReportReport
Posted on by lynntr 45

 

Hi,

I work in the IT Department and HR has a problem with solomon and they know how to fix it by voiding all the checks and printing them to paper, but they want to know if it could be done an easier way by IT. Is there a way to"Kill" the batch because they want to be able to select an invoice and they can't. I noticed in the Batch table the batch number has a status of "r". Can I change the status to something else using Query Analyzer? If I can, what status do I change it to? Also, HR said if I can make a change in IT, they want to make sure the invoices will be available at a later date for payment.

Thanks in Advance,

Lynn 

 

*This post is locked for comments

  • lynntr Profile Picture
    lynntr 45 on at
    Re: Re: Any way to "kill" a batch

    Yes, exactly my thoughts. This is why I posted the question before I did anything. ( I wasn't going to touch it ). Now I can print out an expert's answer and show it HR. I had already told her that changing the status could cause greater problems because I did not know the database schema.

    Thank you for your answer

    Lynn 

     

  • Dwellingbrook Profile Picture
    Dwellingbrook 45 on at
    Re: Any way to "kill" a batch

    The short answer is "Yes, but..."

    The batch state can be changed by updating the Rlsed and Status columns in the Batch table.

    But: Changing only the Batch table can make a real mess of things, depending on exactly what needs to be accomplished.  Changes to the Batch table must be coordinated with changes in all of the related tables (for example GLTran, POTran, etc.) and which tables are related depends on the module and journal entry type. Failing to keep the table states in synch can wreak havoc on the database integrity and cause Integrity Checks to fail.

    The fact that you don't know accounting and haven't looked up the meaning of the Batch table status codes in the Help indicates to me that you don't yet have sufficient skills and information to be attempting this.  Making this kind of change in Dynamics SL requires detailed knowledge of the table schema and how each table state relates to the accounting system. 

    I recommend that you ask your VAR for help with this. Your VAR can help evaluate exactly what the HR department trying to accomplish and design a solution that fits.  Don't forget to bring in the accounting people early in this process since it impacts on the the bookkeeping.

    NOTE WELL:  As an IT person your should always get your Comptroller to sign off on it before you 'kill' a batch.  Messing up the books can have serious legal implications.

  • lynntr Profile Picture
    lynntr 45 on at
    Re: Re: Any way to "kill" a batch

    Hi Gail,

    I am sorry it is confusing. It's because I don't  know accounting. The HR person said the best way to descibe it is:

    They have some checks that they do not to run(It's AP, not payroll). Is there a way I can do it through SQL's enterprise manager(Query) so they don't have to do it one by one.

     

    Thanks,

    Lynn 

     

  • Gail J-N Profile Picture
    Gail J-N 1,000 on at
    Re: Any way to "kill" a batch

    Your question is a little confusing.    What kind of batch are you trying to kill?    An A/P check batch (e.g. for expense reports?) or a P/R check?   I'm confused because you refer to an "invoice number" which I wouldn't expect for a P/R check.    Could you give me the screen number for the batch?   (batch.editscrrnnbr)

    Thanks!

     Best regards,

    Gail J-N

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,997 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,831 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans