how do I print qty by location side by side in IC6.5A. I have selected the qty by location field but it prints one location after the other and I can't fiqure how to move them to side by side.

Dear tmiller

Hope you didn't read my earlier response. In any case, if you are using the fields from the IC table Quantity by Location in your report, then you must create formulas for the "Qty in location" field columns:

If {Location code} = "xxx" then {Qty on hand} else 0

(Where, "xxx" represents the 3-character location code)

Once you have done this for each location, you will still have the extra details printing on separate lines, which you do not want. To remedy this, you must subtotal each formula field (by item number), then hide the details, thus having only the total quantities for each location for each item print the way you want.

You will also have to insert the Item No and/or Item description field into your subtotal section so you can see this information as well.

Sorry if my earlier post was confusing.

Regards,