AnsweredAssumed Answered

Inventory Tracking report

Question asked by Karnel on Nov 11, 2009
Latest reply on Nov 11, 2009 by Karnel

Title

Inventory Tracking report

Post

I'm using FM Pro 10 Advanced on Win XP.  I have an inventory tracking table that tracks the distribution of several clothing items that come in various sizes. I need to show at any given time the total count of each item broken down with subtotals of each size. Here are the fields in my table:


PersonID
ItemID
Item Description
Size
Date
Amount Checked Out
Amount Checked In
Balance Item – Calculation = Amount Checked In – Amount Checked Out
Running Balance – Summary =Total of Balance Item(running with restart), when sorted by Item Description

I have created a sub-summary report sorted by Item Description and it gives me the total for each item just fine, but I’m having trouble figuring out how to get it to break down each item by size and give me a subtotal of that.  I was thinking I need another summary field for the size and I’ve tried several different things, but can’t get it to work right. 





Outcomes