Who's On?

Smart Notification For Procurement

5 Replies

0 Subscribed to this topic

14 Subscribed to this forum

Sort:

Author

Messages

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/16/2009 7:31 PM

I am trying to create a smart notification to notify users when a buyers message clears up in lawson.

Has anybody created this already? Can you tell me which tables and field is updated when procurement clears up a buyer's message.

Thanks in advance,

Ruma.

Matthew Nye

Veteran Member Send Private Message

Posts: 514

1/20/2009 4:58 PM

what type of Buyer Message? Most likely youll want to start at the POMESSAGE table.

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/21/2009 5:44 PM

Which field is updated?

Matthew Nye

Veteran Member Send Private Message

Posts: 514

1/21/2009 5:57 PM

depends i think POM-STATUS. Unreleased or Released is what youre looking for.

Ruma Malhotra

Veteran Member Send Private Message

Posts: 412

1/21/2009 6:32 PM

Thanks for your help on this. I will try this out.

Mike Lamb

Basic Member Send Private Message

Posts: 7

1/22/2009 1:57 PM

Ruma, I can help you with this if still need it. I have written a few reports and am familiar with the tables. You know how to find me... -Mike