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.
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.
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!
Mariano Gomez, MVP
Maximum Global Business, LLC