A typical set of invoice lines looks like this.
Article No Product Code Style Size Qty Price Tot Price
DM13031 DM13031-XS Hoodie XS 0 15 0
DM13031 DM13031-S Hoodie S 2 15 30
DM13031 DM13031-M Hoodie M 1 15 15
DM13031 DM13031-L Hoodie L 2 15 30
DM13031 DM13031-XL Hoodie XL 3 15 45
I would like to enter the ordering information in this format, there of course could be a second line in the same format with a different Article No, DM13172 etc. Pricing would be always be the same for all Product Codes for a given Article No.
Article No Style XS S M L XL Qty Price Tot Price
DM13031 Hoodie 0 2 1 2 3 8 15 120
I would still need to be able to break out the individual Product Codes later in Table view for analysis. I will post another question in a second thread, but I need to summarize the data in a similar format, but by Product Code for all invoices.