Browse to the folder where the database file is located and select the database file.Click the Settings button on the worksheet.

To connect a template to a specified database file: To share data between the two templates, all you need to do is connect the two templates to the same database file. Share data between the invoice template and processing sheet template To meet this requirement, the two templates must connect to the same database file so that when a document is loaded by the spreadsheet, it appears as an invoice, and when it is loaded by the processing sheet template, it appears as a processing sheet. Then, it wants to print the same order as an invoice to send to the customer with the billing information on it. I.e., the manufacturer wants to use the processing sheet to provide information to make the shade for the order. (but doesn't need to know which parts were used). When the invoice is created for the customer, the customer will need to know the price, line total, etc. The processing sheet is a working sheet that will be given to the person assembling the shade i.e., they don't need to know price, etc., but they do need to know what parts to use. However, the idea of creating a work order or processing sheet from an invoice template is still useful.įor a generic work order template, visit Work Order Template (c5015) or for pest-control jobs, visit Pest Control (c4042).Ī processing sheet that shares the database with the invoice template is also included. If you are in a different industry, for example, providing maintenance services or construction, you may not be able to use this template directly. This work order (job order) template is designed for a fabric shade manufacturer.

Automatic invoice generator excel