SKU Unit cost problem

vikram7_dabas

Dear concern
By mistake Unit cost of all SKU's has become zero, Now please tell from where we can update the unitcost of all SKU's.

DaveT

vikram7_dabas wrote:

Dear concern
By mistake Unit cost of all SKU's has become zero

How?
If we know how then we can suggest a fix.

vikram7_dabas

Dear concern
Sorry I dont know can we update cost of SKU?

chengalasettyvsrao

1. How did u update the stock is it trhough Purchase order or Item Journal.

2. If it is Purchase order then did u create the Purchase invoice ?

3. if u update the stock through Item Journal then did u enter the Unit amount in item Journal ?

4. . First check the Field Cost amount (Actual) in Item Ledger entry for that entry what u posted.

2. If you have ZERO , then Use Revaluation Journal to change the unit cost .

5. Run the AICE batch Job.

6. Check the field Unit cost in Item card.

vikram7_dabas

Dear concern
We have lot of SKU's (approx. 1 Lakh) its not possible to change the cost in every Item Journal line through Revaluation.

DaveT

Hi Vikram,

Has there been any movement on the items or is this an initial load of the data?

If initial load then you can import via dataport/xmlport/RIM...

If not :shock:

chengalasettyvsrao

what about the answers to my questions ?

if you share that information , then any expert try to throw some help.

vikram7_dabas

Dear concern
No its not an initial data many transaction has been done.

ara3n

vikram7_dabas wrote:

Dear concern
We have lot of SKU's (approx. 1 Lakh) its not possible to change the cost in every Item Journal line through Revaluation.

write a processing report to do it for you.

vikram7_dabas

Dear concern
Sorry I didnt understand what r u saying?

ara3n

Well you mentioned it takes a long time to do it manually.
I suggested to write a program to automate it for you.