• From: Pakistan, Karachi
  • Registered: 10/13/2018
  • Posts: 1

Topic: Volumetric Unit Information for Products

We have a business of selling Doors and Windows. All products are quoted according to Widths x Heights and in some rare cases Widths x Heights x Lengths. I need to show these dimensions against line items in quotes, orders, invoices and reports.

So my line items should look like:
Item code, Description, Height, Width, Qty, Area, Price, Discount, Total

Where Total = Area x Price (less discount)
and Area = Qty x Height x Width.

Please advise the way foward.

thanks.

Moosa

  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: Volumetric Unit Information for Products

Can you create standard items where the description is "Description, Height, Width, Area"?  Then then item units would be area, the price is price/area, so invoice line price is qty x area.

If you are unable to make standard line items because every order is custom sized, then you would create a single item with an editable description and units of area.  During order entry, you would have to enter the height/width/area in the description and do the math yourself when you create the invoices, calculate the area, and update the associated price/area if it varies based on area.  You could keep a spreadsheet handy to do this during order entry.

If that is unacceptable, you could make some relatively simple modifications to the order entry to have Height, Width columns and do the calculations for you and update the description to "Description, Height, Width, Area" after the line is entered.  This would not require any database modifications.