cancel
Showing results for 
Search instead for 
Did you mean: 

Why did the Item Cost becomes zero when Item is transfered to another whse.

Former Member
0 Kudos

Dear all,

I made two inventory transfers, one from the MAIN Warehouse to warehouse 1 and the other one from the MAIN Warehouse to warehouse 2. The item in the MAIN has a cost of 10 USD.

When transferred to warehouse 1, the Item Cost in the Inventory Transfer is 10 USD.

When transferred to warehouse 2, the Item Cost in the Inventory Transfer is zero. The problem now is that when I make an A/R Invoice from warehouse 2, it says that Item cost is not found, and so I needed to do inventory revaluation.

Why did the item cost become zero in the inventory transfer to warehouse 2?

Thanks in advance.

Regards,

Derrick

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Derrick.......

I guess your Valuation method is FIFO.......

First in of qty was in 10USD which is out in 10USD and I guess second In was on Zero Price so thts why it did not calculate Unit Price........

If it is like tht then you must revaluate the second GRPO for desired price.......

Please check.......

Regards,

Rahul.....

Former Member
0 Kudos

Hi,

It's FIFO. I checked the costs, there was no document where the item got into the inventory at zero cost. It's just that when we make an inventory transfer to the said two warehouses simultaneously, the cost will be zero on the other warehouse while the cost is correct in the other one.

Does this have something to do with the warehouse setup? But I guess this is less likely the reason. Thanks for the reply.

Regards,

Derrick

Former Member
0 Kudos

Hi Eric,

Are you sure that all the item you had received have come in with a price ?

Check the inventory audit report for the item and warehouse.

Regards,

Rakesh N

kvbalakumar
Active Contributor
0 Kudos

Hi Derrick,

Can you post here the prices of your incoming inventory for that item? As Rahul said, it may come with no price also.

Regards,

Bala

Former Member
0 Kudos

Hi Bala,

Okay I will post the prices, I will just get it from the client then will post it here. I will also take a look to see if there really was an instance where the item came in with no price.

Thanks and regards,

Derrick

Former Member
0 Kudos

Hi Eric,

The Inventory Audit repot will help you identify the document that had receipted the item into inventory at Zero price.

Regards,

Rakesh N

Former Member
0 Kudos

Hi Eric,

In Inventory transation --> Inventory Revaluation enter the Item No. and the WH 02 and see the layers if there is a current cost available as you have moved the item there to WH 02 enter in a new cost to the item.

Regards,

Rakesh N

Former Member
0 Kudos

Hi Rakesh,

Yes the current cost of the Item is zero in warehouse 2 and so we had to do revaluation. Why is it working this way for warehouse 2? In warehouse 1, the current cost will be the same as the cost from the MAIN warehouse.

note: I created new warehouses and did inventory transfer to those warehouses with the MAIN warehouse as the origin. All the costs were zero. Could it be the warehouse set up? I duplicated the warehouse 1 and did inventory transfer, still the cost is zero on that warehouse. I hope this is not a bug.

Thank you so much,

Derrick

Former Member
0 Kudos

Dear Derrick,

What is your valuation method?

Thanks,

Gordon