Announcements
We are using Postmaster but I would like to know if anybody knows where Postmaster keeps its information (e.g. to store History of posted batches and such). I am looking to baseline some basic metrics and it would be awesome if I could grab the info from a table, as apposed to manually entering it. Thanks.
*This post is locked for comments
Old post but useful. Is there an updated list of Status Field values for DYNAMICS..ESS80300?
I see a ESS80300.STATUS = 40
What does that indicate?
*********************************************
CASE ESS80300.STATUS
WHEN 2 THEN 'Posted Successfully'
WHEN 3 THEN 'Missing Batch'
WHEN 4 THEN 'Reporting Failed'
WHEN 5 THEN 'Unhandled Batch Type'
WHEN 6 THEN 'Unknown Company'
WHEN 7 THEN 'Open Batch Transaction'
WHEN 8 THEN 'Gerneral Ledger Period Not Open'
WHEN 9 THEN 'Batch Posting Failure'
WHEN 10 THEN 'Partial Batch Posting Failure'
WHEN 11 THEN 'Process Timeout'
WHEN 12 THEN 'Resubmitted'
WHEN 13 THEN 'Empty Batch'
WHEN 14 THEN 'Posting Date Not Set'
WHEN 15 THEN 'Batch Not Approved'
WHEN 16 THEN 'Marked To Post'
WHEN 17 THEN 'Pre Process Validation Failure'
WHEN 18 THEN 'Post Process Validation Failure'
WHEN 19 THEN 'Transaction added to batch while posting'
WHEN 20 THEN 'Batch Status Locked'
WHEN 21 THEN 'Ignored Batch Post Request'
WHEN 22 THEN 'Post Through GL Batch Locked in SY00800'
WHEN 23 THEN 'Post Through GL Not Present in SY00801'
WHEN 24 THEN 'Batch AA Report Not Switched Off'
WHEN 25 THEN 'ESS800000 INTERID Value does not Exist'
WHEN 26 THEN 'Receipt has associated PO Locked in SY00800'
WHEN 27 THEN 'Dynamics GP System Error'
WHEN 28 THEN 'Batch Type requires PMEXTNS.Dic to be installed'
WHEN 29 THEN '(not used)'
WHEN 30 THEN 'Batch Locked in SY00801'
WHEN 31 THEN 'glpBatchCleanup System Error'
WHEN 32 THEN 'SY00500.BCHSTTUS<>0 (Batch is not available)'
WHEN 33 THEN 'Receipt PO Locked SQL Timeout'
WHEN 34 THEN 'Payroll Manual Check Gross Amount=0'
WHEN 35 THEN 'Payroll Manual Check Locked'
WHEN 35 THEN 'Payroll Manual Check Batch missing'
END AS BatchStatus
Thank you very much, how can we mark these transaction again considering for posting? we have got one month old many transaction which was failed due to fiscal period not open, but we opened those 20-25 days later, these are not considering for posting again in postmaster. in setup only have 168 hour maximum.
if we can change a status marking on any table field to re-consider for posting , please let me know.
Here's a breakdown of the values in ESS80300.STATUS
If ESS80300.STATUS = 2, then that batch posted successfully
Thanks for the feedback. We are using Postmaster Enterprise so it is the ESS80300 table I'm interested in.
For Post Master Standard, the history is kept in DYNAMICS..ESS30001. For Post Master Enterprise, the history is kept in DYNAMICS..ESS80300
Regards
Andrew Dean
Envisage Software Solutions
They are in the DYNAMICS database and the tables start with ESS. The ESS30001 looks to be a historical table of everything that's been posted.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
