web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Gail J-N Profile Picture
    Gail J-N 1,000 on at

    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

  • lynntr Profile Picture
    lynntr 45 on at

    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 

     

  • Dwellingbrook Profile Picture
    Dwellingbrook 45 on at

    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

    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 

     

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans