Product quantity in Report / calculation in formula

[Laimonas]

Hi everyone,

I'm having trouble with the "quantity" field in the Product Entity.

For example, if I want to know the total number of items in the warehouse, I can't seem to find a "quantity" (label "Available") or "quantityOnHand" (label "On hand") field in the Report of Product Entity.

Another case is when I try to calculate the total value of a product in the warehouse (e.g., Available Quantity x Cost Price), the formula "cTotalValue = quantity * costPrice;" doesn't calculate anything, the result is "0".

How would you go about solving this issue?

Thanks in advance!

[yuri]

Hi,

This is a special field. It's currently not supported in reports. There're some difficulties to implement it.