Tax Invoice Template Au

1. Australian GST Invoice Template (2)

"Australian GST Invoice Template (2)" was found to be relative to Tax Invoice Template Au with the score grade of 96.

(From Detail Page - about 18 words) - As detailed on the Australian Taxation Office web site, the invoice layout should include sufficient information to ascertain:

• The identity of the supplier, such as the business name at the top
• The ABN of the supplier at the top, near the supplier's identity
• The date of issue of the tax invoice at the top, on the right hand side
• That the document is intended as a tax invoice, such as including the words 'tax invoice' at the top
• An invoice number shown prominently alongside the words 'tax invoice'
• The purchaser's identity such as a name or ABN, for goods or services costing $1,000 or more
• A unit description of each good or service supplied, including quantities - it is optional to include item numbers
• An indication of which goods or services don't include GST by showing a 'zero' in the GST amount column
• An indication of which goods or services include GST by showing the GST amount in the GST payable column, and
• The GST exclusive price, the GST amount and the GST inclusive price for each item, together with the totals for these, vertically in the bottom right hand corner.

(From Detail Page - about 74 words) - Australian GST Invoice Template (2) generally has the same layout as Australian GST Invoice Template (2). The most important difference is that it shows a 0 (zero) if the item is not taxable. This requirements sounds not special, but in fact conflicts with one global options we set for almost all invoice templates available on InvoicingTemplate.com - to simply the output invoices, we choose not to shown zero values on the entire invoice form.

(From Detail Page - about 37 words) - To resolve this problem Australian GST Invoice Template (2) a nice feature offered by Excel, conditional formatting. As always, Excel's powerful features on formatting data making it possible to draft invoices in the way your business likes.

(From Detail Page - about 19 words) - To create the conditional formatting for the GST Amount cells in Excel 2013, here are the steps to follow.

(From Detail Page - about 13 words) - First, you have to unprotect the Invoice worksheet and display gridlines row/column headers.

LEARN MORE PDF

2. Australian GST Invoice Template

"Australian GST Billing Form" was found to be relative to Tax Invoice Template Au with the score grade of 84.

• the identity of the supplier, such as the business name at the top
• the Australian business number (ABN) of the supplier at the top, near the supplier's identity
• the date of issue of the tax invoice at the top, on the right hand side
• that the document is intended as a tax invoice, such as including the words 'tax invoice' at the top
• an invoice number shown prominently alongside the words 'tax invoice'
• the purchaser's identity such as a name or ABN, for goods or services costing $1,000 or more
• a unit description of each good or service supplied, including quantities - it is optional to include item numbers, and
• the GST exclusive price, the GST amount and the GST inclusive price for each item, together with the totals for these, vertically in the bottom right hand corner.

(From Detail Page - about 29 words) - Australian GST Invoice Template includes seven columns on the invoice body - DESCRIPTION, ITEM No., PRICE (excl. GST), QTY, SUB TOTAL (excl. GST), GST AMOUNT, AMOUNT PAYABLE (incl. GST).

(From Format Page - about 57 words) - On Saturday, March 1, 2014 InvoicingTemplate.com released Australian GST Invoice Template for the first time, and assigned "c7018" as its template#. Like all the other invoice templates here on InvoicingTemplate.com, Australian GST Invoice Template has two editions, one free Australian GST Invoice Template that is named "australiangst.xls", and another Uniform Invoice Software version that is named "australiangst-software.xls".

LEARN MORE PDF

3. Parts and Labor Invoice Template

"Parts and Labor Billing Format for Excel" was found to be relative to Tax Invoice Template Au with the score grade of 82.

(From Detail Page - about 50 words) - This parts & labor invoice template in Excel spreadsheet format divides the invoice detail section into two parts, one for labor where the calculation of line totals is based on hours and rate; the another section for parts and materials, where line total calculation are based on price and quantity.

(From Detail Page - about 96 words) - Note that on the invoicing templates we're publishing here on InvoicingTemplate.com, the term "price" is the money the client / customer pay you for each unit of product / service they purchase; on the other hand, we use the term "cost" for the money you pay to your vendor. In case of selling of goods / materials, "price - cost" results in the gross profit of each unit you sell out. On most of our invoicing formats, you see only the "Price" or "Unit Price" column, because the "Cost" fields are put into a hidden column.

(From Detail Page - about 76 words) - This free printable parts and labor billing format for Microsoft Excel shipping and delivery information, unit prices, rate, and more, as well as a box in which to note the date and invoice number. You can also download a PDF version of this template here on InvoicingTemplate.com. Unlike the our Excel labor invoice template, the detail section on this invoicing form is divided into two section, each section has its own tax rate and calculation formula.

(From Detail Page - about 55 words) - For example, in the first section for labor / service, where you itemize the work or job that you have done. The default tax name is "tax 1" in this part, with the calculation formula assigned as "=ROUND(oknTax1Rate*SUM(oknLinetotal_1:oknLinetotal_6),2)"; and the formula of the total charges for labor / service is calculated with the formula "=ROUND(oknTax1+SUM(oknLinetotal_1:oknLinetotal_6),2)".

...(96)...

(From Detail Page - about 130 words) - Here on InvoicingTemplate.com there is at least one another invoice template that has the similar layout, which is Contractor Billing Format. In fact, this parts and labor invoice template is created based on "contractor billing format", by removing the "Date" (oknItemDate_?) column, and by adding back the "Unit Price" ("oknPrice_?") and the "Quantity" ("oknQuantity_?") column. As you can see, although we've made significant customizations to the template, Uniform Invoice Software works well with the new template. If you are looking for a billing and invoicing software for your business, make sure it is flexible enough so that it meets your special business requirements. Visit Excel Job Invoice Template, Contractor Invoice Template Free, Auto Repair Invoice Template, Plumbing Contractor Invoice Template and Contract Labor Invoice Template for more invoice template samples.

(From Detail Page - about 100 words) - While the free version of Parts and Labor Invoice Template is simple, the result invoice created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service invoice creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Parts and Labor Invoice Template work for you.

LEARN MORE PDF

4. Simple Tax Invoice Sample with Tax Rate List

"Simple Tax Invoice Sample with Tax Rate List" was found to be relative to Tax Invoice Template Au with the score grade of 78.

(From Detail Page - about 43 words) - If your business is selling to several states or countries, you may need to change the tax rates from invoice to invoice depending on shipping destination. This sample shows you how to implement a drop list to simplify the selection of tax rate.

(From Detail Page - about 55 words) - With a drop down list, you select values from a list, instead of typing in manually. This is a great way to prevent typo errors. With the default sales invoice template shipping with Uniform Invoice Software, the tax rate is fillable when you create an invoice; but it is not implemented as a dropdown list.

(From Detail Page - about 81 words) - With this Simple Tax Invoice Sample with Tax Rate List, we'll create the drop down list of tax rates by using Excel's data validation features. There are already samples of using drop down list here on InvoicingTemplates.com, such as Auto Repair Invoice Template (2), which adds a "Model" drop down list to the basic template Auto Repair Invoice Template, allowing to select car or vehicle model. Note that the drop down list will not be implemented in the PDF invoice template.

(From Detail Page - about 56 words) - With this sample, we'll focused on the steps of creating the tax rate drop down list. The basic template of this demonstration is c4051 Simple Invoice Template - Discount Amount Field - i.e. we'll use the result of c4051 as the starting point of this customization. The billing form created here can be downloaded for free.

(From Detail Page - about 85 words) - For a template support mixed tax rates on one same billing form / receipt format (for example, beverage tax must be at 3.0% and non-beverage tax rate must be at 5.0%; or if you are selling both general products (goods) and labor (service) to customers, which are two types of taxable items and should be charged with different tax rate), visit Mixed Tax Rates in an Invoice If you need to detail the tax amount for each invoicing item, try Invoice Template with Tax Column.

(From Detail Page - about 61 words) - The base template supports two taxes on the bottom of the form (The default tax names are set to PST - Provincial sales tax, and GST - stands for Goods and Services Tax. It is a federal sales tax, although you can easily change this via the Settings dialog box). For the purpose of this demonstration, we'll use only one tax.

...(11)...

...(127)...

(From Detail Page - about 126 words) - A sales tax is a tax paid to a governing body for the sales of certain goods and services. Usually laws allow (or require) the seller to collect funds for the tax from the consumer at the point of purchase. Besides state tax, you may also need to consider local sales tax. For example, Texas imposes a state sales tax on all retail sales, leases and rentals of most goods, as well as taxable services. Texas cities, counties, transit authorities and special purpose districts have the option of imposing an additional local sales tax for a combined state and local tax rate of up to 8 1/4% (.0825). Taxation itself is a complex topic. If your business is located in Australia, try Australian GST Invoice Template.

LEARN MORE PDF

5. Hourly Service Invoice Template

"Hourly Service Invoice Template" was found to be relative to Tax Invoice Template Au with the score grade of 73.

(From Detail Page - about 35 words) - The default invoice template calculates line totals from Quantity and Unit Price. This simple sample service invoice template simply change the headings to Hours and Rate so that it becomes an hourly service invoice template.

...(176)...

(From Detail Page - about 69 words) - While all the invoicing templates online here on InvoicingTemplate.com is has the final common source - the default invoice template shipped with Uniform Invoice Software, our invoicing software that is able to turns a pure Excel-formatted invoice template into a complete invoicing program, the direct source of this invoice template, Hourly Service Invoice Template (or Hourly Service Billing Statement) is actually based on c4001 Invoice Template with 4 Columns.

(From Detail Page - about 122 words) - c4001 Invoice Template with 4 Columns was created from the default invoice template shipped with Uniform Invoice Software, by moving the Product# column out of the printable invoicing form and placing it before the taxable column. We don't remove the product# mainly for two reasons. First, with Uniform Invoice Software the Product# is a standard field that is required. Second, with Uniform Invoice Software installed, you can retrieved item descriptions, prices and other related information from the backend database by simply entering the item# into the Product# field. This feature is called in-cell lookup, and it is useful even you are running a service business, because it helps you avoid typing same content again and again once it is save to database.

(From Detail Page - about 112 words) - To create Hourly Service Invoice Template from c4001 Invoice Template with 4 Columns, we moved out the Shipping Address section because this is a service invoice template, and then change the column headings from Quantity and Unit Price to Hours and Rate. It is a basic sample on how we customize the invoicing templates here on InvoicingTemplate.com. As long as you follow the guidelines detailed in the Uniform Invoice Software documents, all templates customized in this way will work with Uniform Invoice Software without problem. One last word, however, always protect the Invoice worksheet once you have done your customization. This prevents unexpected modifications to the format and layout of the template.

(From Detail Page - about 61 words) - The protection of the Invoice worksheet in Hourly Service Invoice Template prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Hourly Service Invoice Template.

(From Detail Page - about 98 words) - While the free version of Hourly Service Invoice Template is simple, the result invoice created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service invoice creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Hourly Service Invoice Template work for you.

LEARN MORE PDF

6. Music Store Invoice Template (Wholesale)

"Music Store Invoice Template (Wholesale)" was found to be relative to Tax Invoice Template Au with the score grade of 65.

...(45)...

(From Detail Page - about 53 words) - 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 "Invoice Header" database table.

(From Detail Page - about 104 words) - Adding a custom field to the Invoice Header table in the database makes it possible to save the field value to database along with the other data of an invoice. For example, adding the custom field Company Name to the Invoice Header database table allows you to save the company name of a customer to the database when you save an invoice. If you use Uniform Invoice Software version template Music Store Invoice Template (Wholesale) and add the custom field to the invoice form, the value is saved from or retrieved to Music Store Invoice Template (Wholesale) whenever you save or reload an invoice.

(From Detail Page - about 76 words) - 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 Invoice Header 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.

(From Detail Page - about 63 words) - It's natural that different businesses need to detail their customer / client information on the different levels. For example, a retail shop may have to hide their customer information at all, including customer# and customer name etc.; on the other hand, a wholesale limited company or firm may need to add more details than what the default fields defined by Uniform Invoice Software.

...(22)...

(From Detail Page - about 59 words) - 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 Uniform Invoice Software can write to cell even if the Invoice worksheet is protected.

...(11)...

1. Click and activate the worksheet you want to display gridlines and row/column headers for.
2. On the Tools menu, click Options, and then click the View tab.
3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

...(14)...

(From Detail Page - about 17 words) - The gridlines and row/column headings could help a lot when design the layout of the invoice form.

...(37)...

...(11)...

=ROUND(oknSubTotal*oknDiscountRate,2)

...(21)...

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

(From Detail Page - about 35 words) - The discount rate cell should be unlocked so that even when the Invoice worksheet is protected, Uniform Invoice Software is able to write to cell, and you are able to edit the cell value manually.

(From Detail Page - about 127 words) - The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Music Store Invoice Template (Wholesale), all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the Invoice worksheet of Music Store Invoice Template (Wholesale). To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

...(61)...

(From Detail Page - about 56 words) - Music Store Invoice Template (Wholesale) is provided in two editions - a freeware editions of Music Store Invoice Template (Wholesale), and a Uniform Invoice Software edition of Music Store Invoice Template (Wholesale). Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

(From Detail Page - about 118 words) - The freeware edition of Music Store Invoice Template (Wholesale) provides exactly the same form layout and design in Microsoft Excel format as the Uniform Invoice Software edition of Music Store Invoice Template (Wholesale). The most noticeable difference, at the first glance, is that the Uniform Invoice Software edition of Music Store Invoice Template (Wholesale) contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by Uniform Invoice Software. For example, if you click "Save To DB", the Uniform Invoice Software validates and checks the current document on Music Store Invoice Template (Wholesale), generate a unique invoice number automatically (if necessary), and then save it to the backend database.

LEARN MORE PDF

7. Blank Sales Invoicing Sample (One-tax, Long Description)

"Blank Sales Billing Sample (One-tax, Long Description)" was found to be relative to Tax Invoice Template Au with the score grade of 58.

(From Detail Page - about 30 words) - With this sample template, the base template is customized to show one tax (sales tax) on the bottom of the printable form. The tax amount is calculated using Excel formulas.

...(26)...

(From Detail Page - about 146 words) - c2022 - Blank Sales Invoicing Sample (One-tax, Long Description) (Blank Sales Billing Sample (One-tax, Long Description)) is one of the templates in the serial Blank Sales Invoicing Templates. As of Dec/07/2015, there are 6 template(s) in this serial. For a version that has no tax and shows all lines on the invoice body, see Blank Sales Sample (No-tax). For a version that has one tax and shows all lines on the invoice body, see Blank Sales Invoice Sample (One-tax). For a version that has two taxes and shows all lines on the invoice body, see Blank Sales Invoice Layout (Two-tax). For a version that has no taxes and shows 6 lines on the invoice body, see Blank Sales Billing Format (No-tax, Long Description). For a version that has two taxes and shows 6 lines on the invoice body, see Blank Sales Invoicing Sample (Two-tax, Long Description).

(From Detail Page - about 117 words) - Uniform Invoice Software, our proud billing and invoicing software based on Excel spreadsheet and database technology, helps you manipulate your invoice processing in many ways. Firstly, it helps you create invoices. For example, you don't have to type in customer / client information and product information again and again, just pick up from existing records using the in-cell picker. Once all the required information is filled in, click the Save Invoice command to save it to the back end database - an invoice# is generated for you if you don't filled it in based on the serial stored in the database. There are also a number of reports that helps you track account receivable, sales, taxes etc.

(From Detail Page - about 110 words) - If you find a template here on InvoicingTemplate.com meets your business requirements closely but not exactly, you can download and use our sample template free of charge, and use our templates as a starting point of creating your own template. Our templates are pure Excel spreadsheet documents that contains no macro code, and are not protected with password. You can simply unprotect the sheet to start your customization by clicking the "Unprotect Sheet" command on Excel's "Review" ribbon tab. In our templates, the protection set on the sheet is to prevent modifications to the layout of the invoicing form accidently, but not to prevent end-users from customizing the template layout.

LEARN MORE PDF

8. Medical Invoice Template (2)

"Medical Invoice Template (2)" was found to be relative to Tax Invoice Template Au with the score grade of 54.

...(86)...

(From Detail Page - about 46 words) - Like the original medical invoice template, the name in the "Bill To" section is not necessary same as the name in the "Patient" section. The patient name, the person whose specimen was processed or actually treated at the hospital, should be put in the "Patient" section.

(From Detail Page - about 98 words) - If you use the Uniform Invoice Software version of this medical invoice template, the billing software program helps you create unique customer account number with its powerful customer management features. The customer account number is the account number with the health care provider. Every new encounter should create a unique account number. The "Date of Service" fields detail the dates the patient was treated. In some cases, such as laboratory draws, a range of dates are provided in case multiple tests were performed across several days. A charge itemization can be sent to you detailing all hospital services.

...(89)...

...(71)...

(From Detail Page - about 134 words) - In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Medical Invoice Template (2). Note that if you have our invoicing program (Uniform Invoice Software) installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products invoices and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

• In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
• In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

  (From Detail Page - about 53 words) - TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

  (From Detail Page - about 49 words) - Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

(From Detail Page - about 22 words) - Once you have finished your design work for Medical Invoice Template (2), click the Design Mode button again to exit design mode.

(From Detail Page - about 11 words) - To show gridlines and row/column headers in Excel 2000 - 2003:

1. Click and activate the worksheet you want to display gridlines and row/column headers for.
2. On the Tools menu, click Options, and then click the View tab.
3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

...(40)...

(From Detail Page - about 14 words) - To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

...(34)...

(From Detail Page - about 17 words) - The gridlines and row/column headings could help a lot when design the layout of the invoice form.

...(94)...

(From Detail Page - about 217 words) - Before you can hide a row, make sure the Invoice worksheet of Medical Invoice Template (2) is unprotected and row / column headings are shown. To hide a single row in Medical Invoice Template (2), first right click on the row header of the row to be hidden; Choose Hide from the menu; The selected row and the row number will be hidden from view. To hide adjacent rows in the worksheet, for example, you want to hide rows 14, 15, and 16 in the Medical Invoice Template (2): In the row header drag select to highlight all of the rows you want to hide; Right click on the selected rows; Choose Hide from the menu; The selected rows and row numbers will be hidden from view. To hide separated rows in Medical Invoice Template (2), for example, you want to hide rows 3, 5, and 7: In the row header left click on the first row to be hidden; Press and hold down the CTRL key on the keyboard; Continue to hold down the CTRL key and left click on the rest of rows to be hidden; Right click on one of the selected rows; Choose Hide from the menu; The selected rows and row numbers will be hidden from view of Medical Invoice Template (2).

(From Detail Page - about 18 words) - This customized sample medial invoice form has a PDF version too, which you can view by clicking here.

LEARN MORE PDF

9. Five Price Percentage Levels (Sales, Custom Column)

"Form with 5 Price Levels" was found to be relative to Tax Invoice Template Au with the score grade of 52.

(From Detail Page - about 34 words) - As the name of this invoice template implies, it is a sales invoice template that has shipping information inside the printable range on the invoice form, and the prices or discounts are in percentage.

(From Detail Page - about 64 words) - The meaning and usage of percentage values are detailed in Form with 5 Price Percentage Levels (Sales), where you can also find samples on how to use the percentage discount fields. The keyword "Color" in the template name means there is an additional column "Color" on the invoice body, which is a custom field defined in both the Product and Invoice Body database table.

(From Detail Page - about 123 words) - Custom Field is a concept introduced by Uniform Invoice Software, which refers to the fields that are not defined in the default database structure of Uniform Invoice Software. For example, for an invoice selling clothes you may like a "Size" column on the invoice body to indicate the size of the invoicing item, but the "Size" field does not exist in the default database definition. In this case, you can add it as a custom field in both the Product and Invoice Body database table, so that when you pick up a product on creating an invoice, the size field filled in automatically along with the description, price and product #, and when you save an invoice, the size field is saved too.

(From Detail Page - about 12 words) - If you prefer a service version of this invoice template, click here.

LEARN MORE PDF

10. Music Store Invoice Template (Retail)

"Music Store Invoice Template (Retail)" was found to be relative to Tax Invoice Template Au with the score grade of 18.

...(53)...

The addtional fields are implemented as custom fields.

(From Detail Page - about 135 words) - Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the invoice form. Music Store Invoice Template (Retail) uses custom fields to implement the features that are not available in the default sales invoice template. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, Uniform Invoice Software has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

...(111)...

(From Detail Page - about 88 words) - Adding a custom field to the Invoice Body database table makes it possible to save the data on the invoice form to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the Invoice Body database table allows save the type value on the invoice form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Music Store Invoice Template (Retail).

(From Detail Page - about 99 words) - Adding a custom field to the Product table in the database makes it possible to save the field value to database along with the other data of a product. For example, adding the custom field "Product Type" to the Product database table allows you to save the type, such as "General" or "Labor", to the database when you save a product or item. If you use Uniform Invoice Software version template Music Store Invoice Template (Retail) and add the custom field to the invoice form, the value is retrieved whenever you pick up a product on creating an invoice.

...(64)...

(From Detail Page - about 232 words) - When working with Uniform Invoice Software version of Music Store Invoice Template (Retail), how does Uniform Invoice Software know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice, a customer or a product item? That is, how does Uniform Invoice Software create the map or relationship between Excel cells on the template Music Store Invoice Template (Retail) and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the Invoice Body database table. By using cell names, Uniform Invoice Software allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the Invoice form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice.

(From Detail Page - about 56 words) - Music Store Invoice Template (Retail) is desinged mainly for the retail business. If you are doing wholesale you may need a Discount field to appear on the invoice that you issue. See Music Store Invoice Template (Wholesale) for a free template that you can use. A PDF version of this template is also included for free.

LEARN MORE PDF