Hi,
We have BC configured to require reservations, but reservations to be done via worksheet rather than automatically (using filters when getting requirements to prioritise).
Consider this scenario:
zero physical inventory, zero on purchase order.
Sales order 1 - quantity 2
Sales order 2 - quantity 2
Both customers have same priority.
We then later raise a PO manually and receive 2 physical into stock and go to the reservations worksheet to reserve to the sales orders.
- If we set reservation policy to /basic/, neither is suggested as an reservation because there is insufficient quantity to fulfill both.
- If we set reservation policy to /equally/, it appeares to suggest reserving 1 to each order. This means neither order is shipped, but one of them obviously could be as we have sufficient stock to fulfill one or the other (but not both).
- By customer priority - because both are at same priority, this seems to act the same as 'basic' and not suggest reservation to either order.
Ideally, our reservation should be based on order sequence - e.g. in above scenario it would reserve both inventory units to the first order, so that could be shipped today. Manually reviewing is not practical given we could have 2000 orders per day at busy times.
a) is there any way to achieve this out of the box?
b) if not and we need to look at implenting our own allocation policy - has anyone done anything similar / any pointers? Or equally any negative experiences/ is it likely to be more problem than benefit?
Thanks
Andrew