x

Running a report based on inventory?set up “options”

I own a bra boutique and we are very inventory heavy.  We also buy bras from different places such as USA, UK, Canada and EU.  The cup sizing for each county is different.  For instance, a DDD in the USA is an E or F in EU or Canada.  

I currently have options for band size and cup size based on manufacturer location.  I need to run a report that will tell me how many of one thing I have in stock.  Basically I need a full inventory and accounting of every band and cup size separately so that I know where we are running low.  I also need to inventory each size on occasion so I can update sizes that were input as a custom sale.  

Our options are set up like this:

Band size

30, 32, 34, 36, 38, 40, etc

Cup Sized (USA)

A, B, C. D,  DD, DDD, G

Cup Size (Canada)

A,B,C,D,DD. E,F, FF, G etc

 

i need to run reports to identify each size combination of sizes  separately. 

210 Views
Message 1 of 1
Report
0 REPLIES 0