Would having an Assignment Rule set up on the Product-Site impact this?

Hi Lee Sommerfeldt

The status to allocated is driven by the product category site (of any) or by the product category.
So, I suggestion you to follow this process:

1. Identify a product allocated in Q
2. Check if the related category
3. Check if a product category site exists
4. Control the allocation setup

In addition, any user with the parameter value STOADMIN = Yes can manually by pass the allocation rules. Are you use this is the result of an automatic allocation and not a manual one?

Last idea, would you happen to modify the stock status AFTER the automatic allocation is done on a A stock?

Hi Julien,

Thank you for always responding to my posts.

1. I did this.

2. Check if the related category what? The related category is the one pictured above with our FEFO allocation/issue rules.

3. I'm not sure this exists in our version of Sage (v7)

4. I'm going to need more details. If our allocation setup was working, I would not be having this problem or posting on this forum. 

Yes, I can confirm that STOADMIN is turned off and this is not the result of a manual allocation. 

I have also confirmed on the STOJOU table that this item was never modified from status Q. 

I'm not sure if you saw my own reply, but could this be related to the Assignment Rule for a product-site?

Lee Sommerfeldt said:

but could this be related to the Assignment Rule for a product-site?

I don't think so but using an old version there might be a bug that by pass the rules set on the category.
You can try to replicate it by:

1. Create a SO with no stock allocated
2. Create related PO (same product and date)
3. Assign the PO with the SO (manually or automatically)
4. Then receive the PO in Q* status.
5. Check if the stock in Q is allocated to the SO

I have just replicated the same behavior in V12 : indeed the assignment allows to bypass the status set on the allocation rule !!

Detailed of the test done in V12 (2022R2):

1. Creation of a new product-site: NA011 - BMS002 
2. Creation of a SO with no stock allocated: NA011 - BMS002 - 12 units
3. Creation of a new PO: NA011 - BMS002 - 100 units
4. Assigning manually the PO with the SO using the Assignment workbench
5. Receipt of the in Q* status.

As a result the SO is allocated on the Q stock newly created.

I have just learned something new. This is why I enjoy this forum ;).

Thank you so much! I didn't get notified of your subsequent response. I went ahead and changed this value on our product-sites. For some reason, our Finished Goods were defaulting with this Assignment Rule.