You’re offline. This is a read only version of the page.
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
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
Hi John,
Thanks for this. This is a huge help.
Matt
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
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.
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
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.
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.
Thank you Barry... I will keep researching the rest and post back a complete list, so that everyone knows what these mean.
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
#1
Community Member
136
#2
Mohamed Amine Mahmoudi
102
Super User 2025 Season 1
#3
REUser
8
Share
Report
All responses (
Answers (
