SP transaction notification after Receipt from production

[former_member208987]

Hi,

I want following.

When I create an receipt from production , items are entered in stock and should be put in picklist for the pickproces by sales department.

The object of receipt from production is 59, but how can I get an automatic notification to the sales department that the receipt is entered??

Or how should you handle this.

Kind Regards,

Mark

[pedro_magueija · Accepted solution]

Hi Hageman,

Are you using an addon? If yes, why not use the message service after you created the receipt?

You can find a sample in C:\Program Files\SAP\SAP Business One SDK\Samples\COM DI\CSharp\10.Message.

If not you can still use the message service, but you will need to create a user query that checks for new receipts and then set up a schedule in the Alerts Management window in Administration -> Alerts Management.

Good luck.

Best regards,

Pedro Magueija

[former_member208987 · Accepted solution]

Hi Pedro,

I think your last solution is fine.

But can you please help me to compare my current date in my query below: I tried Getdate()

SELECT T1.ItemCode , T1.Quantity   FROM OIGN T0

INNER JOIN IGN1 T1 on T0.DocEntry = T1.DocEntry

Where T0.DocDate = CURRENTDATE

[former_member208987 · Accepted solution]

I think this will work. Thanks

SELECT T1.ItemCode , T1.Quantity   FROM OIGN T0

INNER JOIN IGN1 T1 on T0.DocEntry = T1.DocEntry

WHERE DateDiff(dd,T0.DocDate,GetDate()) = 0