Inventory Balance to Z_Inventory Balance - Early Warning error status but seems successful

Dear CSO,

18/11/2021

Summary of issue/request/query

We checked that early warning for capturing inventory balance to z_inventorybalance Last Run status is Error, but data was inserted. Could you advise what is the error?

As per checking with our consultant, we understand that the logic for INV_ALERT is slightly different from others.

Alert will only show status “Success” when warning email is sent, indicates that insertion into Z_InventoryBalance failed.

On the other hand, if it shows status “Error”, it simply means that no warning email is sent, because insertion into Z_InventoryBalance is successful.

Take this case as example, since Z_InventoryBalance is updated successfully, there is no email triggered. In result, INV_ALERT showing status error because no alert email sent out.

To conclude, it is normal to see status “Error” for this particular alert. It means that action was completed correctly.