Hi Guys,
I have encountered a problem with Alert Management in SBO and would like to check if any of you is having the same problem.
Objective: Receive stock arrival notification alert with items details for items that are currently out of stock. We use the PO delivery date to check if the items on the PO is due to be delivered within 7 days
Tables: POR1, OPOR and OITM
Query:
SELECT T0.[ItemCode], T0.[Dscription], T0.[Quantity], T1.[NumAtCard] FROM POR1 T0 INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode WHERE (DATEDIFF(DAY, T0.[ShipDate], GETDATE()) <= 7) AND T1.[DocStatus] = 'O' AND T2.[OnHand] =0 ORDER BY T0.[ItemCode]
I have written the above query to give a list of items that is currently out of stock but new stock is arriving within the next 7 Days. When I test the query in query generator it gives the correct set of the result. For example 204 records are returned.
I then set up user defined alert to be based on the above query which runs every Monday at 10:00 AM.
The alert works as I receive the internal alert message via the Inbox in SBO but I noticed only 83 records are displayed in the alert message but in fact there should be 204 records.
Does anyone know if there is a limitation on the number of records that an internal alert message can hold? Or why the complete 204 records are not displayed in the message.
Thanks very much.
Jimmy Lee