I would like to build a GridView report from inventory that will tell me quantities on hand. I thought I was on the right track, but my report was only telling me quantities based on "Quantity on Hand 1". I used GridView Adagio Inventory 8.0A/B, and then "Items (1/3)Master. Although it lists all five of the "on hand" possibilities, it also lists one selection only listed as "Qty on Hand", which I had thought would total all quantities on hand, for a specific item. No so, it is only giving me the "Quantity on Hand 1". Is there a way, short of building a report with all five quantities, and then adding them up, to show me simply the total of quantities on hand.

Thank you.

Hi Barb,

This is really a technical support question, I'll move your post to that forum.

Hello Barb,

The field name in the list is a bit misleading, as it is actually calculated when it is displayed in an Adagio grid. You can create a calculated field with the following formula that will show the correct number:

Code:

---

({Qty on Hand 1} +
{Qty on Hand 2} +
{Qty on Hand 3} + 
{Qty on Hand 4} +
{Qty on Hand 5}) -
{Qty Shipped not Cost} 

---

You can copy and paste the formula from this post. Hope that helps.

Could someone give us the syntax to eliminate the decimal point and zeros for quantities on hand on sales order (so) and on purchase order (po)?

Round the column using the format toolbar.

That seems to do it. Under format/cells we were looking for a "number" selection and a place to put the number of decimal points like in that other spreadsheet.
Instead, select "fixed" and "precision" and we get desired results. Thanks

And then there is the Round function:

ROUND(X, N)
Description
Returns X rounded to the number of decimal places specified by N (when N is positive); it returns X rounded to a whole number when N is negative.

Parameters
X A numeric value
N the number of decimal places or whole numbers, between -15 and 15

Example
ROUND(PI, 2) = 3.14
ROUND(COS(60), 2) = -0.95
ROUND(1234.5678, -2) = 1200