Stock Selection Object - How to display "Q" stock

SUGGESTED

Hi,

I want to add "Q" status stock to the STOCK SELECTION object (STO), so that customer service can view all lots (A and Q) WITHOUT being able to pick the "Q" status lot numbers. Is there a way to do this? I know under Setup - Stock - Allocation and Issue rules you can set A and Q as pick-able lots, but we want to only be able to view the Q lots and not be able to pick them. And if you select Q as pick-able, will the system let you ship the stock if it's still in Q.

Is there a way to do this or a work around?

Regards,

Mike

  • 0
    SUGGESTED
    Hi Mike,

    I'm on V6.5, so I'm not completely sure whether your default STO object is the same as mine, but mine doesn't restrict viewing stock at status 'Q'. Where this may be restricted is in the code for the window that includes the STO browser object. For instance, in my system, the window for stock changes includes the STO object, and the code for the stock changes object (SUBSCS & SUBSCSP) contains a FILGAUCHE label that decides on the filters to apply to the STO object. You may be able to include some custom processing in SPESCS that changes the filters on the STO object.

    Cheers,
    Ben.
  • 0 in reply to bbarnes
    On further thought, does the window that uses the STO object have a 'Selection criteria' button available? You may be able to enter status Q in the authorised statuses in this window.
  • 0
    Hi,
    assuming I understood your requirements correctly.

    Yes, you can configure the system to allow the allocation (Picking) of items to sales orders with Q status but prevent the shipping or issuing of items with Q status. you can control this by setting up the allocation rules to allow 'A' and 'Q' status and then setting the issue rule as 'A' status only.

    regarding being able to view Q stock (By a sales user on the sales order screen for example?) the sales user can view detailed stock by launching the inquiry screen directly from the sales order line. you can also set the allocation method to 'Detailed allocation' which will allow the sales user to select the individual stock to allocate to each SO manually.

    hope this helps.
  • 0 in reply to bbarnes

    I am also on V6.5.This is what my window and screen look like. I do have a "SELECTION CRITERIA" button on the bottom right, which does allow the option to display all lots (A & Q). I just wanted to be able to view only stock coming off QC release and not allocate or be able to issue(ship) with "Q" allocated lots, but I know this would require custom processing, which I do not know how to do.

  • 0 in reply to Mirabelli7
    I was going to say then that you can prevent issue of Q stock by ensuring that Q is not included in the authorised status field in the 'Issue flow' tab for the relevant product category, but all I can manage to get it to do is display a warning. I thought the parameter SDACLOK (in chapter VEN, group AUZ) set to 'No' would prevent picking slips and deliveries being created with unauthorised statuses, but still - all it does is display a warning. I must be missing something - another parameter maybe?

    Anyway - you can at least get a warning displayed for picking slips and deliveries created for Q stock. I think that you will always be able to manually allocate any status stock - there doesn't seem to be any controls around statuses for manual allocations. Only global and automatic allocations.

    So you could display all A and Q stock by using the 'Selection criteria' button and then rely on the warnings for picking and deliveries of Q stock. As I said above, I'm sure there is a way to actually disallow picking and delivery of Q stock. Once the Q stock is displayed though, it doesn't look like there is any way to prevent manual allocation.

    I could be wrong though.

    Cheers,
    Ben.