One function that we need in order to provide good service to our customers is the ability to allocate sales orders based on order type. In our business we take preseason orders, which are orders taken 6-8 months prior to the scheduled delivery date, and allow the factory time to produce the product and ensure that customers who placed these orders are allocated the stock. These orders take first priority when allocating stock. We also have reorders, which are orders placed by existing customers who placed preseason orders for these same items. Reorders take second priority to preseason orders. Then we have ASAP orders, which are orders for items not ordered in the preseason for delivery as soon as possible. Allocation of these orders take third priority in the overall scheme of things. Finally, we have promotional orders, which have the lowest priority in terms of allocating stock.
In addition to allocating stock based on order type, we need to be able to allocate stock or soon to be received stock based on anticipated receipt of that stock. We need a multidimensional report that allows us to plan our allocations to individual orders based on the date the order was received, the type of order, the requested ship date, and the receiving status of the items in question. Pre Netsuite, we used an Excel spreadsheet to track this info (see attached). It worked, but would be unwieldy, now that our business has grown.
Can anyone help with suggestions on tracking a heirachical fulfillment of orders?