after that's done, then naturally setting cron job of this script is already 2nd in nature

Going to upgrade to 2.4.4 soon and see wether it resolves

IVR and CIMR are both very important, because at the moment that's how you get inventory valuation and they way it's setup not correct / accurate

Expected Results
-------------------
                  Qty         Unit Cost              Total Cost
Opening       37               193                  7141
Adjustment  37                0.01                 0.37
Closing        74               96.505            7141.37

Thank you in advance,
Mugao

For illustration, let's imagine a company such as Walmart. Store A (New-York) purchase T-shirt ABC from china at price 10$. A month later, store B (Los Angeles) purchase the same T-Shirt at 6$ (discount).  A month later, T-shirt is back at 10$ from supplier. Since Los Angeles store still has a lot of these T-Shirt in stock and New-York is out of stock, New-York purchase from LA at 8$. So LA makes profit and reduces its stock and New-York make also more profit (as compared to purchasing from chinese supplier). These stores must really share the same stock_id. From a fiscal point of view as well as management and insurance point of view, you really need to know the exact acquisition cost for a specific location.

I have tested your bug fix with latest rep301 (Inventory Valuation Report) with $use_costed_values=1. It seems to work at least partially.

Item Cost in Inventory Valuation Report should also be calculated according to "received into" location unless you don't specify a location in the report.

To be able to reproduce the problem, just create two locations: A and B

Create one PO for 10x item P (cost 10$) received at location A and another one for same 10x item P (cost 90$) at location B.

Average item cost is 50$ for both locations A and B according to current algorithm. Inventory Valuation Report should show 100$ at location A and 900$ at B. Right now both have stock 500$.

I guess also that if all items P at location A are transferred to location B, average item cost at location B should then drop from 90$ to 50$. However Stock Valuation for both A and B location should stay the same at 1000$ with or without a transfer (considering a 0$ shipping cost between A and B).

I will then push it to the HG repository to go to next minor release.

/Joe

It works.

The results were as expected for the same test data as before.
The Inventory Valuation Report reported correct average costs when run for past dates and the Costed Inventory Movement Report reflected correct average unit costs for opening stock, purchases and closing stock.
Thank you very much!

Mark

We are now using the price on the stock_moves where appropriate. This price has been converted to domestic values where needed.

I have tested this in your scenarios and it works.

Please give me a feed back. Maybe we after all can use the costed values.

/Joe