Hello, I’m looking for some insights from other u...
# inventory
a
Hello, I’m looking for some insights from other users on an issue we’re encountering. Use Case: We use Non-Inventory Items for Purchase on our Purchase Orders (POs), which are not available for fulfillment or receiving (
Can be Fulfilled/Received = F
). Here’s the scenario: 1. We create a PO for a quantity of 100,000. 2. We bill 10,000, leaving 90,000 remaining. 3. A change order reduces the PO by 10,000, so we add a negative line on the PO (to preserve the original details). 4. This should bring the new billable quantity to 80,000. 5. However, NetSuite still allows us to bill up to the original 90,000, ignoring the negative line. Question: Is there a setting or preference in NetSuite that limits billing strictly to the adjusted PO quantity (especially when using negative lines)? We bill at $1 per unit, so it's the quantity we're tracking—not the amount. Thanks in advance for any guidance!
r
You should not use negative quantities on transactions. The line quantity should be adjusted down to the new quantity. I'd suggest a custom field on the PO line that is copied to when a new line is added to the PO either on create or edit. This will provide the info you're looking for and meet best practices for the transactions. This will require a small script or being manually entered on PO create or edit
m
Also the line history will show you system notes type changes for line level data