Available stock showing as Unavailable in B2B
We have a significant problem that our Available stock is showing as Unavailable due to future demand. B2B does not seem to understand that future demand (SO) is covered by future incoming (PO). This is critical as we are losing sales! Our customers think we are out of stock when we are not.
Changing the parameters to “include All PO” is not an acceptable option as we will then be showing that we have stock we do not. This will be equally problematic.
Comments
6 comments
Hi Tracey, we include a setting in the B2B to allow purchase orders to be displayed within 7, 30 days or all from ETD. This should allow your customers to see the available stock. The production job is not included on the calculations.
As mentioned earlier, this does not work. Consider the following scenarios:
SCENARIO A: I have 100 parts in stock, I have a purchase order for 200 parts in September and a customer order for 150 parts in October,
SCENARIO B: I have 0 parts in stock, no future demand and a purchase order for 100 parts due in October
Let's say we have setting turned on to include PO within 7 days. SCENARIO A stock will incorrectly show as unavailable, even though it is actually available. (The future demand is covered by the future PO.) SCENARIO B will correctly show stock as unavailable.
So let's say we change the setting to include all PO. Now both scenarios will show as available. SCENARIO A correctly, SCENARIO B incorrectly.
These are real life situations which are confounding our customers every single day. There is currently no setting which can make both of these scenarios correct.
On the second matter, of course the shop needs to include Production Jobs. Why wouldn't it? Regardless of whether the product is made in-house or purchased is of zero consequence to anyone. I would love to know what logic was applied to decide not to include PJs.
In your scenario A will show 100 units for 7/30 days and 300 units available to purchase for your customers.
The made-in-house using production job have not been included in the future availability in B2B. I'll introduce to our feature request backlog for evaluation. Thanks!
No it wont. 7/30 will include the October demand, but not the Sep PO and say there is no stock available. Please check.
Tracey, I too am having troubles with this in B2B. Was there any update from cin7? I too make in-house and buy in stock, so having issues with it reading purchase orders and production orders are different. When I raise a Prod Order, even if there is still low stock, b2b reverts to my oversell text box, which is recently changed to now read “low stock - more coming” but for the b2b customer that wants something now it looks like low stock, but its only cos I raised an order to replenish.
If you have any more feedback on your situation, I would be interested to hear it.
Hi Andrew
Unfortunately I have no helpful feedback. Cin7 basically confirmed that production orders are not considered when calculating available stock, so that's that. Bizarre, really, given that both are legitimate means of procuring stock. I have lengthy experience with MRP systems going back to the 1990s, and have never come across a system that fails to recognise this
Please sign in to leave a comment.