- Document for Excel Invoice Manager
This version of the document, "Invoice Template for Holland Clothing (Wear) Company or Shop", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.
The sample invoice template implemented here is based on C6-001 for clothing / wear company, who needs the "Size" column. Most text labels in this invoice template are translated into Dutch.
In Holland zip code contains a space, like "1234 AA" and it is normal to put the ZIP first and then the name of the city. It is always written as: ZIP CODE space CITY, like: "". For example, the "City State ZIP" cell/field in the "Bill To" section looks like " . It is same in the "Ship To" section.
To display this type of "City, State ZIP", we can use Excel formulas. There are two steps involved to implement this feature based on the invoice format provided by C6-001.
Tip: Download the customized invoice template for holland clothing (wear) company or shop from the bottom of this page.
Note: Invoice Template for Holland Clothing (Wear) Company or Shop was revised and published on our new web site, Invoice Templates, at Netherland Sales Invoice Template and Netherland Service Invoice Template. Excel Invoice Software has published the custom build for these templates too, where the customized sample Netherland invoice templates become the default invoice template of the Uniform Invoice Software installation. Refer to Netherland Service Invoice Template for Excel Invoice Software and Netherland Sales Invoice Template for Excel Invoice Software for more information.
Note: Invoice Templates has also created two variants and customization samples for Invoice Template for Holland Clothing (Wear) Company or Shop. These new samples moved the "Size"("Maat" in Dutch) column out of the printable invoice form and added VAT# cell to both the Customer and Invoice Header database tables, making the new invoicing templates more general and suitable for more business types. Please refer to Netherland Sales Invoice Template 2 and Netherland Service Invoice Template 2 for more information and download links of the sample Netherland invoice templates. For custom builds that integrate the new sample Netherland invoice templates as the default invoice template of Uniform Invoice Software, visit Excel Invoice Software, at Netherland Sales Invoice Template 2 for Excel Invoice Software and Netherland Service Invoice Template 2 for Excel Invoice Software.
First, we should move out the default "City, State ZIP" cells - the cells names areand . The steps to move cells are as follows.
To move a control:
The formula to analyze the original "City, State and ZIP" format and return it in the Holland format is:
The most important Excel worksheet functions used here are as follows, as detailed in Microsoft Excel documents.
The worksheet function substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string.
In this case, the firstformula searches for spaces, and replace them with a symbol "^", and the number of occurrence is the count of all spaces in minus 1. As a result, this formula replaces all spaces in , except the last space, with the symbol "^".
locates one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
returns the number of characters in a text string.
returns the last character or characters in a text string, based on the number of characters you specify.
It joins several text strings into one text string. Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Sometimes, understanding how a nested formula, such as the one provided here, calculates the final result is difficult because there are several intermediate calculations and logical tests. However, by using thedialog box, you can see the different parts of a nested formula evaluated in the order the formula is calculated.
If the underlined part of the formula is a reference to another formula, clickto display the other formula in the box. Click to go back to the previous cell and formula.
Note - Thebutton is not available for a reference the second time the reference appears in the formula, or if the formula refers to a cell in a separate workbook.
To end the evaluation, click.
When you enter "City, State and ZIP", enter it as normal into thecell ($S$10) and ($S$11), it will then shown in Holland format in the "Bill To" and "Ship To" section.
The template adds a custom field "Size" to both the Product and Invoice Body (InvBdy) database tables. For example, if you have a clothing retail shop, it is necessary to stock sizes like 2xl 3xl 4xl 5xl 6xl - each product will have these sizes and the size information should be added to invoices too.