Message Table Name in GP

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

coquisalsa 2,725 on at

Like (1)

Report

RE: Message Table Name in GP

No all messages are stored in SQL tables, they can also be embedded in the dictionaries files.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Message Table Name in GP

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...

Was this reply helpful? Yes No
Suggested answer

coquisalsa 2,725 on at

Like (1)

Report

RE: Message Table Name in GP

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

Was this reply helpful? Yes No
Verified answer

David Musgrave MVP ... 14,069 Most Valuable Professional on at

Like (3)

Report

RE: Message Table Name in GP

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

Was this reply helpful? Yes No
Wesley VanAlstyne 182 on at

Like (0)

Report

RE: Message Table Name in GP

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

Was this reply helpful? Yes No