Revaluation Journal Difference

mohana_cse06

Hi ALL,

I have purchased 50 PCS of Item X for amount 100.(Received & Invoiced)

I have sold 10 Pcs for 150 (Shipped & Invoiced)

I have a SO of 20 in which 20 are shipped and only 5 are invoiced for 150.

NOw am calculating Revaluation Journal.

am getting 20 Pcs only for revaluation.

I think we should get 35 PCs for revaluation ?? ](*,)

AdamRoue

When you use the calculation function it looks at inventory you have, although you have invoiced 5 you have invoiced 20, so they are not in inventory and you cannot revalue them through the on hand calcualtion.

Add the line manually to the revaluation and use the applies field.

mohana_cse06

AdamRoue wrote:

although you have invoiced 5 you have invoiced 20,

is it ...5 you have shipped 20?

AdamRoue wrote:

Add the line manually to the revaluation and use the applies field.

but i think we will get 35 in 4.0 SP2, is it any functionality change?

AdamRoue

Yes sorry shipped 20

No I do not believe there is a funcitonality change. You had 50, you have shipped 20, you have 20 left on a shelf, the routine looks at your on hand inventory to do a calculation, you have 20 so 20 is all it can return.

mohana_cse06

but am getting 35 in 4.0sp2..am sure abiut it. :?:

AdamRoue

It is not how I remember it working but if you are getting 35 you are getting 35, but in your original post you said you were getting 20, which I feel is right.

mohana_cse06

ok ..thanks

mohana_cse06

HI all,

after calculating Revaluation Journal,I have changed Unit Cost (Revalued) to 200
and posted

i have sold remaining 20 PCS for 150

and also 15 PCS which are in Prev. Sales Order

now inventory is ZERO.

but SUm of cost amount(actual) in Value entries is not ZERO. [-X

which shd be ZERO.

can anyone help..

thanks in Advance

AdamRoue

The cost amount actual is the cost of the transaction, it is not the value of your inventory. This cost only changes through the invoicing and item charge process, just because you sell it does not mean the cost of the original inbound transaction is now zero.

mohana_cse06

thanks

so you mean there is no need of sum shd be ZERO.

i am getting -1500 is it right?

AdamRoue

That is correct, the cost actual must NOT be zero unless you paid nothing for it.

If you run the valuation report it will tell you the inventory value is 0x1500=0

mohana_cse06

Thank you AdamRoue

Thank you very much
\:D/