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?
Answer:
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.
