Hi, does anyone knows where to find the table under Dynamics or Company database that would contain all the error message that can appear when posting a batch AP or AR? I'm looking for the message like: "Batch has not been posted" for example.
I verified in the table MESSAGES under Dynamics but it's not there...
Thanks in advance!
Jason
*This post is locked for comments
This may be related but I'm not sure. Take for example the column called SOPHDRE1 in the SOP10100 table. If there is an error for the document, it will contain a binary value other than 0x00000000. How do I figure out what error message the binary value is related to? I think this has something to do with the listbox because there are 32 values such as:
1 **ERROR: No customer record exists for this customer ID.
...
32 **ERROR: The freight tax distribution(s) does not equal the actual amount
For example, a row of data in my SOP10100 table contains the following:
0x00000A00 0x00004000 for SOPHDRE1 & SOPHDRE2
Can I convert this binary value to one of the 32 errors directly in a SQL script?
Thanks,
Wes
Hi Jason
The message resources in the core Dynamics.dic dictionary are copied to the MESSAGES table from the dictionary when you first install. The other location could be the SY_Error_Messages_MSTR (SY01700) table.
However, there are situations where a Multi-Select Listbox has been used to store the text for the various error messages and this allows up to 32 errors to be turned on and off (1 for each of the 32 bits in a Dexterity long integer). If this is the case, the data will not be available in any table. The Multi-Select Listbox fields are called Batch Error Messages 1 and Batch Error Messages 2.
David
You can find the batch status in table SY00500. The column BCHSTTUS contains the information you need.
See this link:
support.microsoft.com/.../batch-status-codes-bchsttus-in-the-sy00500-posting-definitions-master
If it's in SQL Tables I should be able to find in which table but if it's in dic then I can't find it. I wanted to created a query to look for batch that have only errors and display the error. I want to avoid the accountant to look on each paper batch one by one just to find one error...
No all messages are stored in SQL tables, they can also be embedded in the dictionaries files.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
