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 SL (Archived) / Batch table Status fie...
Microsoft Dynamics SL (Archived)

Batch table Status field value meanings?

(0) ShareShare
ReportReport
Posted on by Community Member

I am working on a reporting that I need to take into consideration the Batch Status to remove records that are not valid:

So far the batch status that are possible in the Batch table for the Status field are as follows, please validate and correct if I am incorrect. There are also a few that I don't know what they represent. Does anyone know?

H = Hold (Not Released and Not Posted to G/L)

B = Balanced (Not Released and Not Posted to G/L)

S = Suspended (Partially Released and may not be posted to G/L)

V = Voided Batch (Not Released and Not Posted to G/L)

U = Unposted (Released but Not Posted to G/L)

P = Posted (Released and Posted to G/L)

C = Closed (Released but Non-Posting G/L)

Z = Suspended (Partially Released and may not be posted to G/L)

R = ?

D = ?

I = ?

T = ?

K = ?

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Batch table Status field value meanings?

    Thanks Juan Carlos,

    This is a huge help knowing where this schema Help file is. We have a "VDI" environment, so the path is a little different for me. But I found it by searching in File Explorer for "Full_schema".

    Muchas Gracias desde tu vecino en norte California!

    Matt

  • Community Member Profile Picture
    Community Member on at
    RE: Batch table Status field value meanings?

    Hi John,

    Thanks for this. This is a huge help.

    Matt

  • Suggested answer
    Apps Mexico Profile Picture
    Apps Mexico 1,090 on at
    RE: Batch table Status field value meanings?

    Hi Sandra,

    You can find the status definition on this file. On SL 2011 have this status.

    "C:\Program Files\Microsoft Dynamics\SL\Applications\Help\Full_schema.chm"

    P = Posted - has been released and posted to the general ledger.

    C - Completed - for batches that never post to GL (typcially recurring batches of some type or zero balance documents), so they won't be posted.

    U -Unposted - has been released but not yet posted to the general ledger

    D - Deleted - indicated the batch was deleted in GL in init mode. It is usually used to update a new database.

    Unreleased Statuses:

    B = Balanced - available for release process

    H - On Hold

    V - Voided - deleted by user

    S - Partially Release (Suspended Release) indicates that the batch did not make it all the way through the release process. When using Release Now handling, the batch is automatically set to this value prior to beginning the release process.

    M - Multiple Installment

    AP Check batch statuses

    K - Keep

    R - Ready to be printed

  • JohnTwohig Profile Picture
    JohnTwohig 152 on at
    RE: Batch table Status field value meanings?

    From the main Dynamics screen click the question mark for help at the top right. Click Help Topics. On the left scroll down almost to the bottom and click the + next to 2015 Schema. Click the + by Financial Management Schema and you will see a list of all of the financial tables. Click on a table and you will see a list of all of the fields and (usually) a description of what it means.

    I find it nearly indispensable for understanding what is happening or for doing any customizations in SL.

  • Community Member Profile Picture
    Community Member on at
    RE: Batch table Status field value meanings?

    Hi RD, Thanks for this. This is a big help. And, first time I've seen it. Above, when you say "check the Schema", I'm not following. Are you saying you went to a SQL prompt and directly queried the table in the data base? Or you are saying you clicked on the "?", pulled up the online Help wizard, and drilled down from there into the above data?  Thanks, Matt

  • Community Member Profile Picture
    Community Member on at
    RE: Batch table Status field value meanings?

    This is far too late for Sandra, but if you made it here, you've probably tried searching for the same reference I did.

    When in doubt, check the Schema under using the built-in help documentation! I checked the documentation for the Batch table under the Financial Management Schema and found the following:

    Status

    CHARACTER (1)

    Indicates the status of the batch in the posting process. Released Statuses:

    C - Completed - for batches that never post to GL (typcially recurring batches of some type or zero balance documents), so they won't be posted.

    D - Deleted - indicated the batch was deleted in GL in init mode. It is usually used to update a new database.

    P - Posted - has been released and posted to the general ledger.

    U -Unposted - has been released but not yet posted to the general ledger

    Unreleased Statuses:

    B- Balanced - available for release process

    H - On Hold

    M - Multiple Installment

    S - Partially Release (Suspended Release) indicates that the batch did not make it all the way through the release process. When using Release Now handling, the batch is automatically set to this value prior to beginning the release process.

    V - Voided - deleted by user

    AP and PR Check batch statuses

    K - Keep – The check batch has been printed and kept in the Check Update process (Keep All); but the release process has not been run for PR or AP

    R - Ready to be printed. The check batch has been through View Selections. A batch number has been assigned and the checks are ready to be printed.  

  • Community Member Profile Picture
    Community Member on at
    Re: Batch table Status field value meanings?

    I always check the input screens for each module and use customize mode to get the full list, or atleast the one I am looking for.

  • Community Member Profile Picture
    Community Member on at
    Re: Batch table Status field value meanings?

    Thank you Barry... I will keep researching the rest and post back a complete list, so that everyone knows what these mean.

  • Barry Flynn Profile Picture
    Barry Flynn 3,090 on at
    Re: Batch table Status field value meanings?

    R & K are used in AP (and payroll??) processing

    R = the vouchers have been selected for payment, but the cheques have not been printyed.

    K = they have been printed, and the next phase is the "keep/delete/void" screen.

    D & V are "deleted" / "voided".

    One (not sure which) means the batch was deleted in the originating module.

    The other means that it was processed in the module, but deleted in GL

    I - I think this is "partially deleted" - the batch is in the course of being deleted, but the deletion is not yet completed.

    Dunno about T.

    That's according to my memory.

    Barry

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August 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