We are having issues with the stock valuation report for a client on V12.

The client uses version management.

Everything else works and respect the versions but it looks like the standard stock valuation report does not respect the actual version of the quantity on hand and uses the current version cost to cost all products.

Example below to explain the issue

Standard costs

Product A version 1      $10

Product A version 2      $12

Now we have stock on hand as follows

Product A version 1 Qty 20

Product A version 2 Qty 10

We were expecting stock valuation report to show as follows

Product A version 1 Qty 20 cost $10 Total value $200

Product A version 2 Qty 10 cost $12 Total value $120

Total value for Product A           $320

The standard report is showing as follows

Product A version 1 Qty 20 cost $12 Total Value $240

Product A version 2 Qty 10 cost $12 Total Value $120

Total Value for Product A            $360

So the report is always using the current version's cost

When we do stock transactions they respect the version's cost and now the GL and Inventory wont balance because of the report issue.

Has anyone faced this one before and how did you resolve it?

Is there are a new report that works with version managed products