Forgive me if this has been answered. I've searched and found nothing.
My company has historically operated with zero inventory. We simply place POs with vendors when we receive a PO from a customer and either drop ship or bill stored so it never hits inventory. We're working to change that model and use inventory to balance and make our order patterns more regular with vendors. As we work to implement this change, we're finding that our business model doesn't appear to fit with Netsuite's approach to inventory and backorders so I'm trying to figure out if I'm simply missing something or if there are changes we can make to how these features function.
Mainly, we receive orders from our customers that may not need to be delivered for 2 years and they won't accept them before that. This means we enter sales orders as much as 2 or 3 years before we actually have to deliver product. Keeping those items in inventory for that time would be a terrible use of money so we're trying to use Supply Allocation which allows us to add a "Supply Required By Date" to each line on our sales order. (Note: some lines may be needed immediately while others could not be needed for several months or years - we are in construction)
My hope was that items with a "Supply Required By Date" that was far out into the future would not be indicated as backordered until such a time that the we didn't have the product in the building by that date as that is when it would actually be considered backordered by us. However, through my testing, these items show up as backordered immediately regardless of the supply required by date (assuming we don't have enough in inventory already). The downside of this is that when they are indicated as backordered, they show up on the Order Items report which is precisely what I don't want them to do.
Here is what I was hoping the functionality would be:
Date items hit Order Items Report = Supply Required By Date + Lead Time
To accomplish this since the formula above doesn't appear to be an option, my hope was that backorders could be tied to item commitments in the following way:
Set supply allocation rule to set item commitment to XX days before Supply Required By Date
When commitment is attempted by the above rule, it would be unable to commit items that we didn't have on hand or on order and would THEN backorder them and THEN they would show up on an Order Items report. It felt like this would work but the items are backordering regardless of any dates or commitments as soon as we enter the Sales Order.
Are either of my desired approaches/formulas possible or does anyone know of a good solution so that items that aren't needed for years into the future don't show up on a report for a buyer to purchase until much closer to when they are actually needed?