How to change Item Model Group from standard cost to weighted avg? (or moving avg)

Dear,

I need your help or advice.

We are tring to change item model group from standard cost to weighted average. But, as expected, system does not allow if those items have transactions even though there is no on-hand inventory.

Is there any way to change item model group from standard cost to weighted average(or moving agerage)?

You need to fix a date of close of inventory then :

Invoice all :

  1. Open puchase orders till date of close.

2.Open sales orders till date of close.

  1. Post all inventory journals no open lines.

  2. Close the inventory on specific date

Then try to change item model group.

Dear Sumit,

Thank you for your reply. But, I tested only 1 item as following;

  1. Registered new item and setup item model group as standard.

  2. Activated standard price.

  3. Stocked in by movement journal. (of course posted)

  4. Stocked out by movement journal. (of course posted)

  5. Tried to change item model group as weighted avg. → occured the error

Error : “The item is set to be evaluated by inventory model ‘Standard cost’. The system cannot convert the item to be evaluated by an inventory model of type ‘Transactions settled’ only inventory models of type ‘Transactions not settled’ can be selected.”

You need to close the inventory for that new item on a particular date and then change the item model group .Please try again

Dear Sumit,

Thank you for your reply again.

I tried closing all inventory as today and tried to change again, but not worked…

Anything I missed?

I am assuming on hand inventory is zero .

You need to zero it first .

Then do all as described above.

Change Item model group and then bring back the inventory .

Dear Sumit, As I mentioned, of course, on-hand inventory is 0.