Inventory Valuation goes wrong

lally

HI Folks,



I am working On nav 4.0 sp3.

I am facing some problems regarding Inventory Valuation.

When I run the inventory valuation report for the month 01/01/2009 ..01/31/2009.
It shows all negative values for that FG.
Like this for every month I am getting the wrong values that means negative values.

Key users posted the transactions with wrong postingdate.(by mistake I had give the allow posting 01/01/2009 …. 31/12/2009.

I found that mistake is Out put happened one date , but they transferred that material before that out put date.
Example is : 02/11/2009 Out put journal posted for FG. Lot number is ABC 001
But they transferd that lot to another location on 01/05/2009.

So like this they posted wrong posted date .

So how to correct this one .



Throw some light on me.

Regards

David_Singleton

The first thing I recommend is to change the costing method. It looks like they are using GIGO and this is the wrong method for any company to use. 8)

Basically run the adjustment routines and costing should come out correct next month. The current mess needs to be accounted for by the accountants for the current month.

lally

Thanks,

i am working Nav 4.0 sp3.



It des not have the costing method GIGO.


Please help me.

ara3n

David Singleton wrote:

The first thing I recommend is to change the costing method. It looks like they are using GIGO and this is the wrong method for any company to use. 8)

Basically run the adjustment routines and costing should come out correct next month. The current mess needs to be accounted for by the accountants for the current month.

GIGO
I guess I'm learning something everyday.

David_Singleton

lally wrote:

Thanks,

i am working Nav 4.0 sp3.



It des not have the costing method GIGO.


Please help me.

Actually GIGO is the costing methoind that your client is using try clicking on the link. :whistle:

David_Singleton

ara3n wrote:

GIGO
I guess I'm learning something everyday.

I also learn't of a costing method FINO (First In Never Out) today that I never knew about before even though I have at least one current client that uses it.

lally

thanks,


My client is using FIFO costing method.

please help me............ ](*,)

SD-JR

Hi,

Unapply the incorrect transactions (application worksheet)

post a positive adjustment for incorrect transactions as start of period they were incorrectly posted and then apply these..

post a negative adjustment for above transactions at correct date and then apply these.

No magic bullet solution.

Else stock take everything to zero, and take back on correct stock.

It's a big mistake and will take effort to correct

ssingla

With 4.0 SP3 the functionality of apply-unapply inventory transactions will not be available. You can suggest to do accounting adjustment and correct inventory as on date as suggested by David.