BoostExcel main content

Simple Sample: Total Quantity on Sales Report

Template#: c4103

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
339 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Simple Sample: Total Quantity on Sales Report

Detail

This form adds a custom field to calculate and store the total quantity on an invoice, and then add this information to the sales report.

  1. First, make sure you have created a backup copy of the template.
  2. Open the template.
  3. Click "Invoices" on the ribbon tab.
  4. Click "Custom Fields" on the toolbar to open the "Custom Field Manager" dialog box.
  5. Make sure "Database Table" is showing "Invoice Header".
  6. Click "Add Field" to open the "Add New Custom Field" dialog box.
  7. Define a new field as the following:
    • Field Name: TotalQuantity
    • Type: Decimal
    • Precision: 10
    • Scale: 2
  8. Click "OK" to create the new field.
  9. Close all dialog boxes and return to the Excel sheet.
  10. Switch to design mode by clicking the "Design Mode" button on the ribbon.
  11. Click the cell where you want to place the total quantity. In this example, we choose $I$34, i.e., the cell below the "Quantity" column.
  12. Enter the formula to calculate the sum of the quantities:

    =sum(oknQuantity_1:oknQuantity_12)

  13. On the formula bar, click to activate the name box located at the left end and enter the cell name "oknTotalQuantity".

Next, we add this field to the sales report.

  1. First, click and activate the "Sales Report" worksheet.
  2. Click the cell with the text "Balance Due".
  3. Click "Format Painter" in Excel's "Home" ribbon tab.
  4. Click the cell next to "Balance Due", i.e., $R$11. This copies the format of the "Balance Due" cell to $R$11 to make it look like a report heading.
  5. In the name box of the formula bar, enter the cell name "oknRsTotalQuantity".
  6. Enter the label of this column, "Total Quantity".
  7. Click and activate the "Invoice" worksheet.
  8. Click "Design Mode" on the ribbon to exit design mode.
  9. Save the template.

Now the form calculates the total quantity for each invoice, and when you create a new sales report, the total quantity of each invoice is retrieved and shown.

Format and Specification

Template#c4103
Belongs to
Format (XLS or XLSX).xlsx
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$46
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree

Related

Simple Service Invoice Template Thumbnail
Simple 2-Column Sales Invoice Sample Thumbnail
Simple Sales Invoice Template without Item Description Thumbnail
Simple 2-Column Service Bill Sample Thumbnail
Simple Sample: Manually Fillable Line-Totals Thumbnail
Simple Service Bill with Pleased Customer Image Thumbnail