Nav Business Logic from SQL Server Stored Procedure

Hariharanssudan

Hi there,

Can anyone of you having idea about calling Nav Business Logic from SQL SPs?

For example, We are having Purchase Order Posting routine. We will have to call this codeunit for an Given Purchase Order Number from SQL SP. Is that possible and how?

Thanks in Advance,
Hari

garak

The C/AL code is only running, when a NAV client or a NAS runs.

So, if you need a batch to post some Orders from a SQL SP, run a NAS.
The NAS can wait on a port or on the MSMQ.
Your SQL SP send an Event to the Port where the NAS wait or send a Message to the Queue of the NAS.

One NAS is free and is in your NAV lincense.

Regards