Invoice lines aggregation

[laguna92651]

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.

[laguna92651]

Does anyone have any ideas how I might go about this task. In essence I want to create 5 Invoice lineitems from a single line on the invoice. The user would not see the 5 new lineItems. But I would need those lineItems for inventory and post sales analysis. Basically the system structure is done but the end user now wants a different interface on the invoice. Without a one to five approach they could have 100 invoice lines or more.

[laguna92651]

Still looking for some ideas on how to implement this.

[LaRetta]

" In essence I want to create 5 Invoice lineitems from a single line on the invoice. "

I will guess that you haven't received answer for same reason I haven't responded ... If you already know what makes up those 5 items which (combined) create the Product then you can display those items as a multi-line list or aggregate their values in many ways. If the user won't see them then why do they need to be on the invoice or the LineItems? If it is for sales analysis then might it best come from the production side?

Can you explain exactly what you cannot get and maybe provide a file? We all want to help but we need a bit more of your vision. :^]