Table Trigger to use after OnModify?

dottocka

Hi,

I'm pretty new to the NAV Development so excuse me if I'm asking too obvious questions

I need to call .NET methods that are directly querying the NAV Data Base and doing external tax calculation for the Sales Order. The call need to be done on every modification to the Order or modification to the Order Sales Lines details.
At first I called the method from the OnModify trigger of the Sales Header and Sales Line Tables but unfortunately I have found out that the changes are still not stored in the Data Base so I can't do the calculations on the changed data.
So my question is: Is there any trigger of event that is triggered after OnModify when the data is already stored in the Data Base?

Thanks

Marije_Brummel

The way that NAV calculates Sales Tax is not in the OnModify trigger. If you don't know NAV I would never touch Sales Tax.

Have you looked at Avalara? Their product does what it should do but the code is horrible.

Be careful with Sales Tax...

dottocka

Thanks Mark.

I have already put my code in designated place for external tax calculation implementation which is in the Code Unit 398 Sales Tax Calculate, which is executed when the Order is posted. But my client insist the calculation to be done also on any change of the details of order which is not the case by default in NAV. That's why I'm trying to init the process during the OnModify table trigger.

Yes the Avalara is doing the same thing, I'll try to dig the solution from there.

Marije_Brummel

Clients can insist, but do they understand the product well enough to know what they ask?

joshuasung

Clients can insist to pay to break and pay to fix it again, I guess.
They will have wonderful performance in system

If you have to, you probably want to touch area where amount is getting updated.
You probably don't want to update sales tax when customer just change the description of line.

I would probably enforce them to default to calculate sales tax, so you can keep sales tax calculation code stay in CU398

chavansachin20

Hi all,

with latest releases from Avalara, code is moving toward good shape. we are incline towards Code refactor which we are considering with releases on continuous pattern. Let us know your exact need here : sachin.chavan@avalara.com.

Thanks Mark, and nice video https://www.youtube.com/watch?time_continue=4&v=uDFvG64TkEI


Regards
Sachin Chavan