FrontAccounting forum — Calculate average cost by Inventory Location

Re: Calculate average cost by Inventory Location

null@example.com (flpages) — Mon, 07 Sep 2020 06:33:09 +0000

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

Re: Calculate average cost by Inventory Location

null@example.com (mugao-em) — Mon, 07 Sep 2020 05:37:03 +0000

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.

Re: Calculate average cost by Inventory Location

null@example.com (flpages) — Mon, 07 Sep 2020 02:44:29 +0000

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.

Re: Calculate average cost by Inventory Location

null@example.com (mugao-em) — Sat, 05 Sep 2020 12:38:00 +0000

Dear apmuthu,

This is noted. what are the plans to include this feature?

Mugao.

Re: Calculate average cost by Inventory Location

null@example.com (apmuthu) — Fri, 04 Sep 2020 18:33:55 +0000

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.

Calculate average cost by Inventory Location

null@example.com (mugao-em) — Fri, 04 Sep 2020 18:00:43 +0000

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.