Hello, I’m looking for some insights from other u...
# general
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!
a
I think the supply planning module has support for change orders (I know this isn't what you asked but wanted to mention in case it's useful at all: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_159190685327.html) As far as PO bills, I think they're generated from POs based on transaction lines, not transaction totals. When you're working with inventory items (as you probably know) quantities have to be positive - I assume they just haven't built them to handle negatives properly. What would be ideal is if you could bill both lines, including the negative quantity, such that the PO shows as billed once the bill is created, but from what I can tell, that doesn't work and it still shows "Pending Bill" forever. It might honestly be worth opening a support ticket for this (although I haven't done my diligence and checked for one, maybe someone has already raised the alarm), as I would argue this is a bug. Otherwise, probably your best option is to make a copy of the transaction then change the quantities and close the original, instead of using negative quantities. If you wanted the two to be linked, you could get fancy and create a "Changed From" field on POs as a PO list/record field, so you can record the original closed PO on the new one. Extra fancy would be to then automate this, but that's probably overkill, depending how often this happens.