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 RMS (Archived) / how do I close batches...
Microsoft Dynamics RMS (Archived)

how do I close batches for a non-existant register?

(0) ShareShare
ReportReport
Posted on by scottfatcat 122

I have been using RMS for many years now.  When I was first setting it up, I apparently created 2 batches that were not assigned to a register.  There were no transactions associated with the batches, I was just trying to figure out the software.  These batches still show up as open.  They aren't causing any problems, but I am sick of looking at them every time I go to update batch info.  If I try to select them to close, RMS tells me I need to Z out the batch (of course).  the problem is there is no register assigned, so I can't access anything to do a z-report.  I only use one register, which shows up as "1" on my register list.  The register # assigned to these 2 unclosed batches is empty.

does anybody have any ideas how to close or get rid of these batches?  Thanks

*This post is locked for comments

I have the same question (0)
  • scottfatcat Profile Picture
    scottfatcat 122 on at

    Edit- I can select "Generate Z report" but it tells me I need to blind close the batch from the register... but there is no register to use to close the batch.

  • Verified answer
    Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on at

    You need to run a sql command in Store Operations Administration by connecting to the database to change the batch status to each batch you are having problems with. The batch status should be set to 23 (see support.microsoft.com/.../891318).

    Run this command:

    UPDATE batch SET status = 23 WHERE batchnumber = xxxx  (replace xxxx with appropriate batch number)

  • scottfatcat Profile Picture
    scottfatcat 122 on at

    Like a charm.  That's not something I would have ever figured out on my own. Thanks you!

  • Suggested answer
    IT Licensing Profile Picture
    IT Licensing 65 on at

    Very nice, worked perfectly for me as well. Thank you!

  • Suggested answer
    HolliV Profile Picture
    HolliV 235 on at

    I slightly disagree with the solution.  I ran the below statement and then could generate the z report.  After doing this the tender types appeared.

    UPDATE batch SET status = 8 WHERE batchnumber = xxx

  • Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on at

    Of course there are always more ways to skin a cat. Below is a table describing the Batch Status Codes. Use the above sql statements to change the batch status' to a desired state that will help solve our issue. Somewhere there is a Microsoft KB article with all of this information.

    Code
    Description
    1
    Closed
    2
    Opening Amounts Entered
    3
    Closed, Opening Amounts Entered
    4
    Closing Amounts Entered
    5
    Closed, Closing Amounts Entered
    6
    Opening Amounts Entered, Closing Amounts Entered
    7
    Closed, Opening Amounts Entered, Closing Amounts Entered
    8
    Blind Closed
    9
    Closed, Blind Closed
    10
    Opening Amounts Entered, Blind Closed
    11
    Closed, Opening Amounts Entered, Blind Closed
    12
    Closing Amounts Entered, Blind Closed
    13
    Closed, Closing Amounts Entered, Blind Closed
    14
    Opening Amounts Entered, Closing Amounts Entered, Blind Closed
    15
    Closed, Opening Amounts Entered, Closing Amounts Entered, Blind Closed
    17
    Closed, Exported
    19
    Closed, Opening Amounts Entered, Exported
    21
    Closed, Closing Amounts Entered, Exported
    23
    Closed, Opening Amounts Entered, Closing Amounts Entered, Exported
    25
    Closed, Blind Closed, Exported
    27
    Closed, Opening Amounts Entered, Blind Closed, Exported
    29
    Closed, Closing Amounts Entered, Blind Closed, Exported
    31
    Closed, Opening Amounts Entered, Closing Amounts Entered, Blind Closed, Exported

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 RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans