G
Guest
I have created a report that shows a product we sell and under the product,
what we purchase to build the product. The report calculates how much of
each item we need to build the desired part. Several of the products we sell
contain the same item. I want to generate a separate report that gives me
total number of items needed. I can't seem to get the new report to
calculate. Here is an expample:
Report 1
Product Name 1059
Qty on order 10
-----------------------------
Qty/Item On order In Stock
Qty to order
Inventory Item 0045 .75 .875 .3
500
Inventory Item 113-2 1 0 2
8
Report 2
Inventory Item Qty to Order
0045
Inventory Item Qty to Order
113-2
The inventory item will be used more than once, so I need a total from the
whole report.
what we purchase to build the product. The report calculates how much of
each item we need to build the desired part. Several of the products we sell
contain the same item. I want to generate a separate report that gives me
total number of items needed. I can't seem to get the new report to
calculate. Here is an expample:
Report 1
Product Name 1059
Qty on order 10
-----------------------------
Qty/Item On order In Stock
Qty to order
Inventory Item 0045 .75 .875 .3
500
Inventory Item 113-2 1 0 2
8
Report 2
Inventory Item Qty to Order
0045
Inventory Item Qty to Order
113-2
The inventory item will be used more than once, so I need a total from the
whole report.