I am trying to generate an alert for stores department when there is a new production order document is generated either planned or released status.
I am using the following query but it is not displaying any results even after generating a new production order document.
SELECT T0.[DocNum], T0.[ItemCode], T0.[PlannedQty], T0.[PostDate], T0.[OriginNum], T0.[CardCode] FROM OWOR T0 WHERE T0.[PostDate]=getdate()
Is there any wrong with the query?