Share and distribute
Templates
Start Business Central workbooks from templates that ask for a customer or a period, use the six standard templates, and save any workbook as your own template.
updated: applies-to: 1.0.0.0
A sheet template is a saved workbook that asks for a few values when you use it, like a customer or a period. Business Central fills them in and builds a new workbook, so the same review takes a minute every month.
The standard templates
Sheet Templates lists the templates, each with a category and its number of parameters. Six come with Bitta Sheets:
- Aged Receivables by Salesperson (Receivables): receivables by salesperson, grouped by due-date quarter.
- Balance Sheet Comparative (Finance).
- Customer 360 (Customers): one customer's balance and ledger.
- Department Budget Entry (Budgets): see department budgets.
- Profit and Loss vs Budget (Finance).
- Vendor Spend by Quarter (Purchasing).
Load Standard Templates adds the standard templates. They are loaded automatically when the list is empty. Gallery shows every template by category, and Use Template starts a workbook from the selected one.
Open a template to see its parameters. Customer 360 asks for a customer number, the customer's name and a period, and writes each one into its own cell. A parameter can be text, a code, a number, a date, a date range, yes or no, an option list or a record, and a default can be TODAY, WORKDATE, USERID or COMPANY.
From a customer card
Some templates open from a record. On a customer card, open the Actions menu and choose Open in Sheet Template. The customer number and name are already filled in: type the period and choose OK.
Business Central builds a new workbook, Customer 360 for that customer. The filters hold the customer and the period, and below them are the balance and the ledger by month, with payments and invoices.
Vendor, item, G/L account and project cards have the same action for templates of your own. Customer 360 is the standard template that opens from a card.
Save your own
Any workbook can become a template.
- In the workbook's File menu, choose Save as template.
- The code comes from the workbook's name. Add a description and a category.
- Use as a template for links the template to a kind of record, such as customers, so it opens from those records. Leave it at none for a general template.
- The gallery shows the preview picture. Choose Save.
Parameters are added afterwards, on the template's card.
New from Template
On the Workbooks page, choose New from Template. The gallery lists your templates with the standard ones. Pick one and choose Use Template: the new workbook takes its name from the template's description and opens with the same layout, on live data.
Workbooks marked as templates
To copy a workbook exactly as it is, without parameters, mark it as a template instead: on the Workbooks page, choose Use as Template. Workbooks Marked as Templates lists those workbooks, and New from Template copies them as they are. Sheet templates are stored copies with parameters and a preview; workbooks marked as templates are live workbooks copied as they are.
Move workbooks between environments
Export Package and Import Package move workbooks between environments.
To print a workbook or save it as PDF, see Print and PDF. To email it on a schedule, see Send workbooks on a schedule.