Hi Community,
Is there any native NetSuite way to calculate Available to Sell (ATS)?
Currently, we are using the following formula:
ATS = On Hand - (Open SO + Open PO)
For example:
On Hand Qty = 4
Open SO Qty = 5
Open PO Qty = 234
This results in ATS = -235.
The reason we are questioning this approach is that open Purchase Orders represent incoming inventory, so including them as a deduction seems to make the ATS more negative rather than reflecting future availability.
We also have future-dated Purchase Orders and Sales Orders in the system.
Is there a native NetSuite field, report, or recommended calculation for ATS that considers future-dated supply and demand transactions?
Any insights would be appreciated.