Hi ,
Good day.
I have created a two custom fields in the sales order form and in that two custom fieldsi want to populate the value of line amount from sales line table and the total tax amount from the sales tax amount line table.
Can anybody suggest some method to achieve this.
PLease advice.
Bharath
*This post is locked for comments
I have the same question (0)Do you mean sto um of the all the sales line amount and tax amount ? If so, create two flowfields on the sales header to get sum of Amount from sales Line and Amount Including Tax from sales Line. You can use those two fields to calculate the tax amount or you can check the logic in order acknowledgement report to calculate values.
If you have a newer version of NAV, you can check the logic over there which by standard has those fields.