How to configure Business Alert for Dynamics GP (GL Module)

Hi Zeeshan,

Please follow these steps to create the business alert

1- Create New Business Alert

2- Use these tables in "select tables" window

GL00100

GL10001

3- Provide this relationship in "Joining Table" window

GL00100.ACTINDEX= GL10001.ACTINDEX

4- Define this alert formula in "Business Alert Formula" window

GL00100 ( GL00100_T2.ACTNUMBR_1 = 100 OR GL00100_T2.ACTNUMBR_1 =

200 ) AND ( GL00100_T2.ACTNUMBR_3 = 01 OR GL00100_T2.ACTNUMBR_3 =

02 ) AND

(GL10001_T1.DEBITAMT >= 50000 OR GL10001_T1.CRDTAMNT >= 50000)

5- You have done. Next you can setup the alert notification.

Best Regards,

Waqas Butt

Microsoft Business Solutions Consultant

Mbl: +97150 1606879

-----Original Message-----

From: Zeeshan_butt via ms-greatplains-l

[mailto:ms-greatplains-l@groups.ittoolbox.com]

Sent: Tuesday, September 25, 2007 4:36 PM

To: Waqas_Butt

Subject: [ms-greatplains-l] Business Alert

Hi All:

I am trying to create a Business alert in GP. Give me an alert If GL Open

Transaction amount posted >50000 for an account which have got segment 1 =

100 or 200 and segment 3 = 01 or 02 and segment 2 = any

I will be thankful for your help in this.

Zeeshan