Download
Description | Size | Download |
---|---|---|
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:
| 428 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Detail
This template is designed for law firms and small law offices. It has exactly the same layout as c5104, but with the currency set to INR (Indian Rupee). It also demonstrates how to use the custom field "Bank Charge".
It differs from the Attorney Invoice Template (c5067), where the line totals are calculated from "Quantity" and "Unit Price". This form has five columns too, but the line totals are the sum of "Official" and "Professional", which are all manually editable.
The "Exec.ID" column uses the "Prouct ID" field defined as a standard field in the default template shipped with our app, which could be the short codes for the services provided.
With c5104, we use the "oknShippingCost" field for storing bank charges.
This template replaces the "ShippingCost" standard field with a custom field named "BankCharge".
To do this, the first step is to delete the "ShippingCost" name.
- First, make a backup of your template.
- Open the template.
- Click the "Design Mode" button on the ribbon.
- Go to the "Formulas" ribbon tab, and then click the "Name Manager" button.
- On the name manager dialog box, browse to and select the "oknShippingCost" name, then click "Edit".
- Enter the new name "oknBankCharge".
- To make the bank charge column populated on reports, we also need to rename "oknRsShippingCost" to "oknRsBankCharge", "oknRcShippingCost" to "oknRcBankCharge", and "oknRrShippingCost" to "oknRrBankCharge".
- Click "Close" to close the name manager dialog box and return to the Excel worksheet.
- Exit design mode.
Now we need to create the custom field "BankCharge" at the database level. Here are the steps to follow:
- Click the "Invoices" button on the ribbon tab.
- Click "Custom Fields" on the toolbar.
- Click "Add Field".
- Enter the following: Field name: BankCharge; Type: decimal; Precision: 10; Scale: 2.
- Click "OK" to create the new custom field.
- Click "Close" to close the custom field manager.
Format and Specification
Template# | c5105 |
Belongs to | |
Format (XLS or XLSX) | .xlsx |
Columns | 5 |
Lines | 12 |
Line Height (Points) | 21.75 |
Print Area | $E$3:$L$45 |
Papaer Orientation | Portrait |
Default Margins (Points) | |
Left | 18.00 |
Right | 18.00 |
Top | 75.60 |
Bottom | 75.60 |
Price | Free |