Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
How does the logic of how the total sales amount (including tax), i.e. work in a Sales Order?
Could you please explain to me the logic of how the total sales amount (including tax), i.e. the foreigntotal value of SalesOrder is calculated?
My understanding is as follows
(Item A unit price excluding tax * quantity purchased) * (1 + consumption tax rate)
(Item B unit price excluding tax * quantity purchased) * (1 + consumption tax rate)
(Product C unit price excluding tax * quantity purchased) * (1 + consumption tax rate)
Coupon discount amount (excluding tax) * (1 + consumption tax rate) * value is -.
Point discount amount (excluding tax) * (1 + consumption tax rate) * value will be -.
Shipping cost (excl. tax) * (1 + consumption tax rate)
============================================
= total amount (foreintotal)
I am thinking that the system is to calculate the amount including tax for each item line and add them together to use as the total accounting amount, is this correct?