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

Do I have to use those "Z-" currency IDs in GP?

Image
I know this seems like a trivia question, but recently I have come across a number of clients who have been using Microsoft Dynamics GP for a number of years and have been told by their former partners that they *must* use the predefined currency IDs created after adding the sample company, with no real explanation to support these claims. Case in point, my new client in Saudi Arabia, has been struggling for years to understand why they were told to prefix all currency IDs with the "Z-". So they went ahead and setup "Z-SR" for the Saudi Real. If you are familiar with Microsoft Dynamics GP and the sample company, Fabrikam, you may have noticed by now that after adding the sample company (which is not a requirement by any means), you will get a number of predefined currencies such as Z-US$ (US Dollars), Z-UK (British Pounds), Z-C$ (Canadian Dollars), Z-AUD (Australian Dollars), and so forth, accompanied by a number of exchange rate tables. If you are not familiar wi...
Read more

Microsoft Dynamics GP Scrolling Windows and Line Sequence Numbers

Image
I thought I would write about something meaningless that no one really thinks about. However, I realized that this is a compelling topic since it makes for some interesting discussion around the ability to insert line items withinin most transaction scrolling windows. Let’s take some time to understand where Line Sequence Numbers come from. A Line Sequence Number is auto generated by Dynamics GP and uses a seed value of 16,384 as a basis for the first line. Each subsequent line in the scrolling window is incremented by this number, so line number 2 would have a Line Sequence Number value of 32,768, line number 3 would have Line Sequence Number Value of 49,152, and so on. Since most GP transaction entry scrolling windows allow inserting rows in between line items, the newly inserted Line Sequence Number value is calculated as an average between the previous and the next line item sequences, i.e., if you were to insert an item in between row 1 and row 2 in the scrolling window -- keep in...
Read more