writing to $Sales Header and $Sales Line directly from 3rd

vasilis6669

Hi,

Are there any reasons not to write to $Sales Header and $Sales Line directly from 3rd party application?

Has anyone had any problems with these 2 tables Nav 5.0 SP1

Regerds,
Vasilis

Albertvh

Hi,

NEVER do this as any logic will not be triggered in NAV.


Albert

vasilis6669

ok

I also read that it is recommended to

"1) Insert your data into a "temp" table
2) start a NAS process that interpretes this data and insert it into the right standard tables into navision

Why? NAS executes NAV's business logic, SQL Query does not."

Do i have to write a code unit to enter $Sales Header and $Sales Line records from the MytempSales Header and MytempSalesLine tables?

Regards Vasilis

garak

vasilis6669 wrote:

Hi,

Are there any reasons not to write to $Sales Header and $Sales Line directly from 3rd party application?

Has anyone had any problems with these 2 tables Nav 5.0 SP1

Regerds,
Vasilis

[-X [-X [-X [-X =; =; =; =;

Yes, the NAV internal code and the buissnes logic.
If you need to create Sales Orders, store this infos in a "Batch Tabel".
These Batchtable can be processed by a NAS (this runs a report or a codeunit and this codeunit reads the batch table and create sales orders) or a userinteraction (for example with Job queue).
So you are saved that the NAV code and the buisiness logic works.

vasilis6669

Hi,

I did write to the sql tables and until now the order from sales header and sales line works fine.

Thanks,
Vasilis