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.
