From the Newsgroups: Configuring Business Alerts to report posting errors

Welcome to another edition of From the Newsgroups. In this installment we will look at a question posted in the Partner Online Technical Community newsgroup. The partner needed to know if it was possible to configure Microsoft Dynamics GP Business Alerts to submit posting errors to application adminstrators when using an auto-posting tool.

Q: Is it possible to setup a GP Business Alert to notify someone when a scheduled SOP batch (or any other GP batch) fails to post? The background to this is we are using MC2 GP Agent module to autopost the imported SOP invoice batches. This will happen many times a day. To avoid the need for a person monitoring the automated posting process, we want an alert to be generated when the posting process fails.
The response comes courtesy of Dave Bader, Moderator of the Partner Online Technical Community, enhanced by me with pictures to facilitate the explanation.

I have been looking at the SY00500 which is the Posting Definitions Master and I have an option that may work for you on the Business Alert.

1. Create a new Business Alert.




2. Select the Series as Company.
3. Select the Posting Definitions Master as the Table.



4. In the Define Alert Formula window select the table and use the column name Batch Error Messages 1 and add that to the formula.
5. Select the <> symbol.
6. In the Constants field enter in 2 single quotes ''.
7. Select the OR symbol.
8. Select Batch Error Messages 2 and add that field.
7. Select the <> symbol.
8. In the Constants field enter in 2 single quotes ''.

The formula should look like the following.

SY00500_T1.BCHEMSG1 <> '' OR SY00500_T1.BCHEMSG2 <> ''



9. Click next and select the notification information and the message text.



10. Click next and enter the schedule information.



11. Click Finish.

Below are the values that can be held in the error message fields.

Batch Error
Messages 1: Indicates a general batch error causing the batch to not post.
1 - Recurring batch posted too many times
2 - Series is missing or invalid
3 - Missing or invalid system-posting settings
4 - Batch currently being posted
5 - Batch currently being edited
6 - User posting access denied
7 - Next Audit Trail Code invalid
8 - No transactions found to post
9 - Batch Source is missing or invalid
10 - Batch Number is missing or invalid
11 - GL posting date is invalid
12 - Batch has not been approved for posting
13 - Actual batch total does not equal the control batch total
14 - Actual transaction number does not equal the control transaction number
15 - Fiscal period for the posting date does not exist
16 - Fiscal period for the posting date is closed
17 - The General Ledger module is not registered
18 - The Receivables Management module is not registered
19 - The Payables Management module is not registered
20 - The Inventory Control module is not registered
21 - The Invoicing module is not registered
22 - The United States Payroll module is not registered
23 - Fatal posting error occurred. Please revert to backup.
24 - Fatal posting error occurred. Please revert to backup.
25 - Actual number of journal entries does not equal the control number.
26 - Another user is editing this batch. Some information may not be updated.
27 - The Sales Order Processing module is not registered.
28 - The Bill of Materials module is not registered.


Batch Error Messages 2:
1 - The Receivables Management module setup information is missing or damaged.
2 - The Payables Management module setup information is missing or damaged.
3 - The General Ledger module setup information is missing or damaged.
4 - The Inventory Control module setup information is missing or damaged.
5 - The Invoicing module setup information is missing or damaged.
6 - The United States Payroll module setup information is missing or damaged.
7 - The Inventory Control module is being reconciled.
8 - The Inventory Control module is changing valuation methods.
9 - The Inventory Control module is changing decimal places.
10 - The Inventory Control module is performing a year end close.
11 - Not enough system resources. Please close some windows.
12 - The Multicurrency setup information is missing or damaged.
13 - The functional currency is missing.
14 - This company does not have access to the selected functional currency.
15 - The functional currency for this company is inactive.
16 - The Purchase Order Processing module setup information is missing or damaged.
17 - The General Ledger posting date is missing or invalid.
18 - The Bill Of Materials module setup information is missing or damaged.
19 - There is no Released transaction.
20 - The Euro Currency ID is inactive.

I hope this information is helpful to you. Please post back if we can be of any further assistance.


Business Alerts can be a powerful tool to assist Microsoft Dynamics GP administrators in their daily tasks by keeping an eye on a number of activities ocurring throughout the system. Definitely, this is one to keep in the arsenal of tips and tricks and one that I expect to see in a future edition of 50 MORE Tips in 50 Minutes session presented by my friend MVP Mark Polino.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

Comments

Unknown said…
This is very good.. I have created this and come accross when batch had an issue.

Is there any way that we can generate alert to know if any unposted bacth or transaction lying in GL. Basically I need to trace any system generated batch should be notice.

Regards,
Santosh
June 3, 2010 at 8:44 AM
adventurer212 said…
hi Mariano,

we have GP Agent for our customer and is setup to automatically schedule posting certain times of the day, but we did not set it to have a posting journal to be created. I tried to make use of the email notification in GP agent but that does not seem to work or even send out an email notification. Is this post more or less like the workaround to that instead... alert if there is a posting prob? as the email notification of GP Agent for posting without reports do not work at all yet? Appreciate any feedback you may have. cheers!
January 24, 2011 at 3:26 PM
Mariano Gomez said…
Adventurer,

In the context that you described, it would seem that the approach described in this post could help with your situation, but I am not at all familiar with your environment, hence I strongly recommend you test it out first.

MG.-
January 26, 2011 at 9:45 PM
bill@mc2software said…
In order to send out email notifications, you must have Outlook installed on the DPS. If you want the resulting report sent as an attachment, you need to assign a file name to the report destination for the task.
July 12, 2011 at 5:13 PM
Post a Comment

Popular posts from this blog

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

Image
Hello all! It's been quite a while since I've actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I've been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10's of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on. This time around I want to bring to the forefront, an issue I encountered updating  from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack. Background My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I'm absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics
Read more

Cannot insert the value NULL into column 'CONTACT' error when clicking on Items List in Navigation Pane

Image
Moving on from my previous article on a similar subject - see Cannot insert the value NULL into column 'BASEUOFM' error when clicking on Items List in Navigation Pane , I recently came across this error,  Cannot insert the value NULL into column 'CONTACT' when clicking on the All Purchasing Transactions list under the Purchasing Navigation Pane option, after performing an upgrade from Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010 R2. All Purchasing Transactions list error - Purchasing Navigation List The name of the global temp table - in this case, tempdb.dbo.##2093338- varies in almost all cases, but the end result of the error is the same. The issue has been identified running Microsoft Dynamics GP 2010 RTM, SP1 or SP2. Upon further review, the issue is due to bad data in the Vendor ID (VENDORID) column in the Purchasing Receipt History table (POP30300). In summary, if you have a purchasing receipt with a blank vendor ID or a vendor ID that doe
Read more

How to uninstall Microsoft Dynamics GP 10.0 if you cannot uninstall it by using the "Add or Remove Programs" feature

INTRODUCTION This article describes how to uninstall an existing Microsoft Dynamics GP v10 system if you cannot uninstall it by using the Add or Remove Programs feature (or Programs and Features in Windows Vista) in Control Panel. It is recommended that you verify that you cannot uninstall by using Add or Remove Programs first. MORE INFORMATION First, verify that you cannot uninstall Microsoft Dynamics GP by using Add or Remove Programs (or Programs and Features) To verify that you cannot uninstall Microsoft Dynamics GP by using Add or Remove Programs (or Programs and Features in Windows Vista), follow these steps. For Windows XP or Windows Server 2003: 1. Click Start, click Run, type control appwiz.cpl in the Open box, and then press ENTER. 2. Click to select Microsoft Dynamics GP 10.0 product from the application list, and then click Remove. For Windows Vista: 1. Click Start, type Programs and Features in the Search box, and then press ENTER. 2. Click to select the product to be un
Read more