Change item from User Specified costing to Lot Costing

Hi,

I would like to change some items from User Specified costing to Lot Costing.  The option to use a Lot Costed account set is not available until I uncheck "Allow lot quantities to be different from the quantity in the entries."   But, that box is greyed out and won't allow me to uncheck it.  

What is the right way to change User Costed items to Lot Costed?

Thanks

  • 0

    1. Do a physical inventory and set all user-costed items to zero quantity and zero cost

    2. Change the account sets

    3. Do an IC adjustment batch to return them to inventory, the adjustment batch will force you to add lot numbers.

  • 0 in reply to Jay Converse Acumen

    I tried this for just one item.  The "Allow lot quantities to be different from the quantity in the entries." box remains greyed out, and prevents me from seeing the Lot Costed account set in the list of available account sets. 

    Tried running Day-End processing to see if there is any difference, but still unable to uncheck that box

  • 0 in reply to Jay Converse Acumen

    Found that for step 2 I can simply delete and recreate the item with the correct account set after the quantities and cost are zero'd in the way you said.

    I also found that I can uncheck the "Allow lot quantities to be different.." box, by setting ICITEM.LDIFQTYOK to 0. When I do it this way I am able to change from the user-specified account set to the lot costed one without deleting the item. 

    (UPDATE ICITEM SET LDIFQTYOK=0 WHERE ITEMNO='XXX')

    Is unchecking that box in this way and then changing account set going to cause problems later?   

    Also, the items I am working with are already lotted. I'm just changing from an account set that uses User Specified Costing to  an account set that uses Lot Costing. I found that by setting LDIFQTYOK=0, it allows me to change the account set of items that have a non zero quantity/cost to the lot costed account set.  Will this cause errors later?

  • 0 in reply to Dave MacKay

    I don't know, I've never touched that field before.