Item Master Data Problem

[former_member541807]

hello all,

i have an item master data record. it was created as an Purchase item checked. other tick box are unchecked during the creation of the item. now a transaction on this item has been made. PO -->> GRPO, now the time we want to withdraw the item from the Warehouse as an Inventory Item, we found out that this item master data is not an Inventory Item. its inventory count is zero. GRPO does not affect the stock in WH.

Please tell me how will i solve this one.

Thanks & best Regards.

Fidel

[Former Member · Accepted solution]

Hello Fidel,

Since the item got transaction, it means you could not change this item type anymore. The workaround is to create a new item with same name (Different Item Code). Create a goods receipt for the new item to get the right quantity on hand. Then lock the wrong item.

Thanks,

Gordon

[former_member541807 · Accepted solution]

hello Gordon and Laurence,

Thanks a lot for the quick response.

im a quiet confuse why should i need to lock the item, what i did, i just check the inventory item check box and the system allow it. im thinking if ill just make an goods receipt to put the count in the inventory since the transaction of this item is just yet once. is this just ok? also i want to ask, since the item now is updated and inventory item already if a new transaction will occur, will this item master data behave as a normal Inventory Item like others?

please advice.

many thanks

Fidel

[Former Member · Accepted solution]

Hi,

What in meant in Lock is to On Hold the Itemso that it will never be used again, just tick the On Hold check box in the Item master Module. The Item can be shown but never be added in the transaction,

Regards,

Clint

[Former Member · Accepted solution]

Hi,

If problem solve kindly close the thread.

Thank you very much,

Clint

[Former Member]

If you can change this item type to including Inventory, you don't need to lock it. All above suggestion is based on new item creation. That means you have to lock the old item so that no duplication item in use at same time.

Thanks,

Gordon

[former_member541807]

hello all,

Thanks a lot on your suggestions, my problem is now solved.

Fidel

[Former Member]

Hi Fidel,

The only way to correct your item is to Duplicate the Item Master Data and make sure Inventory Checkbox is checked.

Then if there are previous inventory transactions/activities that need to be recorded in the Financials and address its valuation (Moving Avg, FIFO or Std Cost) create a monthly summary of the quantity that came in and perform a Good Receipts for each month.

There will be no duplication here as the previous GRPOs are just a documents (like the sales quotation) and did not affect the quantities and the financials.

Laurence Resubal