Alert when a new document or journal entry is posted

[Former Member]

Does anyone developed a query that starts an alert when a new document or journal entry is posted?

By example: The accountant needs to know when a new journal entry is posted (made by a marketing document).

Thanks in advance,

[Gianluigi]

If you want to know when a new object (like a document or a journal entry) is

added in the B1 DB you must use the SBO_SP_TransactionNotification.

There is a document here on SDN that describes this SP and how to use it.

You may also want to use the B1 DI Event Service that provides you a listener-

based C# interface to these databases events. You can download it from SDN.

[Former Member]

Hi Joao,

the user alerts didn´t work like that. The user alerts are executed every X minutes(the user defines the minutes), and if the query does return any record, the alert is created.

You could create a query that gets the journal entries that where created in the last X minutes (same as the period) so you will get the ones created in that period.

Just an idea.

Ibai Peñ

[Former Member]

hi ibai,

my requirement is also same . my actual requirement is i will be posting the journal entry to multiple company.i.e i have parent comp. and child companies. all the transactions are posted in patent comp. as soon as the transaction is posted i want get the details and store in temperory table and at the end of the day i will be posting that to the appropriate child company that will be identified by the ware house . this is my requirement . pls help me. if any sample code i can get for tracking the journal entries.

Regards

Om Prakash.