Inventory Value by Location - Custom Report

Can anyone help me in producing the inventories’ values at a certain date grouped by location?

Location A

  • inventory item A 100.000
  • inventory item B 50.000
    TOTAL LOCATION A 150.000

Location B

  • inventory item A 70.000
  • inventory item B 50.000
    TOTAL LOCATION B 120.000

Total inventory 270.000

This is not yet possible. However I think custom reports should be able to produce such a report easily.

Thanks for the reply. One question, are you planning somehow to enable also some sort of pivot table reporting (ie multiple dates as columns)?