mibuso.com

Microsoft Business Solutions online community
It is currently Wed Sep 24, 2014 4:25 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: valuate the inventory from Average to FIFO
PostPosted: Fri Jun 22, 2012 10:22 am 
Offline

Joined: Sun Oct 17, 2004 9:40 am
Posts: 29
Location: hydearbad
Country: India (in)
HEllo,

one of my client having Average costing method for some items since long time.
now they want to convert to FIFO.
My Query is how to valuate the inventory available on FIFO?

we are planinng to take a new Item instead of old and valuate the old item's inventory as per FIFO, so that i can do the Positive adjustment with the new Item code.

please suggest me the best way to valuate the old inventory as per FIFO.

regards,
Ramesh


Top
 Profile  
 
 Post subject: Re: valuate the inventory from Average to FIFO
PostPosted: Fri Jun 22, 2012 10:27 am 
Offline

Joined: Fri May 18, 2012 3:04 pm
Posts: 148
Location: Armenia, Quindio
Country: Colombia (co)
First make sure you do not have any open negative entries by checking in the Item Application Worksheet. Then do a report of the open positive entries for the item. The costs on these entries weighted on the remaining quantity will give you your opening FIFO layers.

_________________
Gerry Kistler
KCP Consultores


Top
 Profile E-mail  
 
 Post subject: Re: valuate the inventory from Average to FIFO
PostPosted: Fri Jun 22, 2012 10:41 am 
Offline

Joined: Sun Oct 17, 2004 9:40 am
Posts: 29
Location: hydearbad
Country: India (in)
gerrykistler,

Thanks for your prompt reply

we are having more Open entries of Transfer entries than purchases.
these transfers are built with Average cost. so how can i concder this cost as FIFO cost?


Top
 Profile  
 
 Post subject: Re: valuate the inventory from Average to FIFO
PostPosted: Fri Jun 22, 2012 10:47 am 
Offline

Joined: Fri May 18, 2012 3:04 pm
Posts: 148
Location: Armenia, Quindio
Country: Colombia (co)
You would have to use the Item Application entries to got through the transfers back to the original positive entry and get the cost form there.

_________________
Gerry Kistler
KCP Consultores


Top
 Profile E-mail  
 
 Post subject: Re: valuate the inventory from Average to FIFO
PostPosted: Fri Jun 22, 2012 11:07 am 
Offline

Joined: Sun Oct 17, 2004 9:40 am
Posts: 29
Location: hydearbad
Country: India (in)
Thanks for the suggession , i am working on the same idea.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: