BoostExcel main content

Simple Sample: Discount Percentage Field

Template#: c4054

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.
373 KBDownload

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

Screenshot

The screen shot for Simple Sample: Discount Percentage Field

Detail

This template is based on the Simple Invoice Template: Discount Amount Field (c4051). It demonstrates how to add a discount percentage field.

  1. First, backup the template and database files.
  2. Open the template.
  3. Click the "Design Mode" button on the ribbon tab.
  4. Click cell G35 and enter the text "DISCOUNT PERCENTAGE".
  5. Click to select cell H35. Enter the cell name "oknDiscountPercentage" into the name box on the left side of the Excel formula bar.
  6. Right-click the same cell and choose "Format Cells" from the shortcut menu.
  7. On the "Format Cells" dialog box, go to the "Number" tab.
  8. From the "Category" list, choose "Percentage". Adjust the "Decimal Place" if you like. In this sample, we just keep the default value of "2".

    Click OK to close the "Format Cells" dialog box.

  9. Click the "oknDiscountAmount" cell at K35 and modify its formula as follows:

    =ROUND( SUM ( oknLineTotal_1:oknLineTotal_12 ) * oknDiscountPercentage,2)
    

  10. Exit design mode by clicking the "Design Mode" button again.
  11. Click the "Invoices" button on the ribbon tab.
  12. Click "Custom Fields".
  13. On the "Custom Field Manager" dialog box, make sure "Invoice Header" is selected in the "Database Table" list.
  14. Click "Add Field" to open the "Add New Custom Field" dialog box.
  15. Define the new field like this:
    • Field Name: DiscountPercentage
    • Type: Decimal
    • Precision: 6
    • Scale: 4
  16. Click OK to close the "Add New Custom Field" dialog box.
  17. Click "Close" to close the "Custom Field Manager" dialog box.
  18. Save the template.

Format and Specification

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

Related

Sales Invoice Template with Discount Amount Column Thumbnail
Sales Invoice Template with Discount Percentage Column Thumbnail
Simple Sample: Discount Amount Field Thumbnail
Business Invoice with Customer-Specific Discounting Thumbnail
Service Bill with Discount Percentage Thumbnail
Service Invoice with Discount Amount Thumbnail
Simple Sample: Discount Amount on Sales Report Thumbnail