Stocked Flag is Greyed out in Macola

[Candice71]

I have some part numbers that have the stocked flag greyed out in Macola. It will not let me make inventory adjustments with it being non stocked. It also will not show up on count sheets for inventory. How can I change this flag? We do not use any outside sources to access Macola.

 

[dgillz]

Is the controlled flag set? If not, this could be a phantom item, which has its own BOM and by design is never stocked nor controlled, and the components are consumed when the phantom item is called for.

The other thing that will not allow a change to this field is if there is an open customer order for the item. If you are interested in tracking qty on hand, I suspect it is the latter. Go to multi-level item view and click on Open Cust Orders. Then post back here if you found any.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Candice71]

@dgillz
The Controlled item is checked. I have tried to uncheck it and it does not make a difference. I did the multi level check for customer orders and the open Cust Orders is greyed out. There is not any open orders or open PO's. It does not have a BOM either. This one is stumping me.

 

[dgillz]

That is stumping me too but here is a quick fix using SQL:

Update imitmidx_sql
set stocked_fg='Y'
where item_no='<insert item here>'

Honestly to keep it safe you should update the OEORDLIN_SQL table as well, even though in this instance there are no customer orders. The SQL is almost identical:

Update oeordlin_sql
set stocked_fg='Y'
where item_no='<insert item here>'

Macola Software Veteran

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html