Skip to Content
0
Former Member
Apr 19, 2010 at 11:37 AM

Database Alert Macros issue while executing the macros in Background

39 Views

Hi All,

I am facing some problems while executing the Database alert macros in Background/Process Chain.

There are two macros for which the problem exists.

1.Excess Projected Inventory above Max

The logic here is, the alert should work for Only Fixed Lot size Procedure.

If the Stock on hand (projected EA) > (Safety Stock (EA) + Full SOQ (EA)) then alert = "Projected inventory is XX% above MAX".

XX is the Percent above Max.

Note: SOQ => fixed lot size.

2.Excess Actual Days of Supply

The Logic here is, the alert should work for all Lot size Procedures except for "Fixed lot size".

Actual Days Supply >=180 days. (current -> future buckets)

- For every receipt cell check the Actual Days Supply - if >= 180 days.

The macros are working perfectly as expected.