It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Items and Inventory → Calculate average cost by Inventory Location
Hello,
Does FA handle costing of the same item in multiple locations differently? I have been looking into the issue in 2.4.8 and it seems the system either uses the last/latest standard cost in stock_moves or the standard_cost in stock_master. while this is okay for 1 location, its a problem in cases where items are stored in several locations.
Please guide further on this.
Regards,
Mugao.
Treat an item in another location as a different item for now as FA currently just has one cost at a time for each item.
Dear apmuthu,
This is noted. what are the plans to include this feature?
Mugao.
FA is using perpetual weighted average cost inventory system,
perhaps you may share what is the reason of same item different cost in different location,
maybe there is alternative solution.
Take this scenario.
A Spare is purchased into Store A at 100 and into Store B at 105.
This results in a different average cost of the same spare in two stores.
Amputhu's work around of having two different IDs can work, but there will be a challenge when the item is transfered from Store A to B.
Mugao.
I think it's ok to has one average cost for spare from 2 stores within a company.
The other way is 2 stores(branches) have their individual accounting (treat it as 2 companies).
and on fiscal year end you just need to consolidated 2 stores financial statements.
that's just my opinion 
FrontAccounting forum → Items and Inventory → Calculate average cost by Inventory Location
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.