Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Music Store Invoicing Sample (Wholesale)

Music Store Invoicing Sample (Wholesale) (c5059)

c5059 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open musicstorewholesaleinvoicetemplate.xlsx.

Music Store Invoicing Sample (Wholesale) (IMFE Edition)

Music Store Invoicing Sample (Wholesale) - IMFE edition

Download

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

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you want this design to be set as the default template by the installer program.

3.38 MBDownload

Without database file. How to download and use

105 KBDownload

Download this if you have already installed IMFE, but are looking for additional customized templates.

368 KBDownload

Detail

Music Store Invoicing Form (Wholesale) is a variant of Music Store Invoicing Form (Retail). It differs from the original version in that this wholesale version includes a new custom field, Discount, on the bottom of the form, allowing you to apply discount to wholesale clients.

Just like the other new fields COMPOSER, INSTRUMENTATION, PUBLISHER and COMMENT, this new fields "Discount Rate" and "Discount Amount" are also added as custom fields. However, unlike those custom fields that are detailed in the Music Store Invoicing Form (Retail) document, these discount custom fields are added to the "InvHdr" database table.

The steps of adding the discount rante and discount amount fields to database tables are similar to what we've done in Music Store Invoicing Form (Retail). Note that this time, you have to choose "InvHdr" database table. If you want to set default Discount Rate for each computer, so that the rate value is populated automatically each time a customer is picked up, simply add the Discount Rate custom field to the Customer database table.

To add the custom fields, Discount Rate and Discount Amount, to the Invoice worksheet, the steps to follow are: unprotect the Invoice worksheet, insert a new row underneath the "Subtotal" row and then name the discount cells, unlock the named discount rate cell so that UIS (Invoice Manager for Excel (namely Uniform Invoice Software)) can write to cell even if the Invoice worksheet is protected.

To insert a new row underneath the "Subtotal" row: Right-click the row header of the first tax row, and choose "Insert" from the shortcut menu. A new row is inserted, now you have to name the cells.

The Excel formula of the discount amount cell is followed below:

=ROUND(oknSubTotal*oknDiscountRate,2)

You should also modify the formula of the "Total" cell to use the discounted amount instead of the original subtotal amount:

=ROUND(oknSubTotal -oknDiscountAmount + oknShippingCost + 
IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)

The discount rate cell should be unlocked so that even when the Invoice worksheet is protected, UIS is able to write to cell, and you are able to edit the cell value manually.

Like other form designs here on InvoicingTemplate.com, Music Store Invoicing Form (Wholesale) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5059
NameMusic Store Invoicing Sample (Wholesale)
CategorySales Invoice Template
Release DateSaturday, September 20, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines12
Line Height (Points)24.75
Print Area$F$3:$N$42
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Update History

August 27, 2018

  • This template was updated to be compatible with UIS 6.