How is inventory getting allocated in Q status?

SOLVED

Our business utilizes a basic A,Q,R quality status logic. We have set our "Allocation and Issue Rules" to specify that only products in status A can be allocated. 

We continue to encounter products getting automatically allocated to sales orders in Q status. I am at a complete loss. If there's some back end parameter called "Ignore Allocation Rules" turned on, I wouldn't be surprised. 

Here is a screenshot of the offending Product Category with the relevant FEFO allocations rules applied. 

Parents
  • 0

    Hi

    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?

  • 0 in reply to Julien Patureau

    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?

Reply
  • 0 in reply to Julien Patureau

    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?

Children
No Data