Skip to content
Bitta Apps

Chapter 4 of 4Page 1 of 4

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.

Sheet Templates list with the six standard templates, their categories and parameters, and the Load Standard Templates action

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.

Sheet Template card for CUSTOMER-360 with its parameters: customer number, customer name and a period date range

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.

Customer 360 workbook for customer 30000 with the customer and period filters, the balance and the ledger by month

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.

  1. In the workbook's File menu, choose Save as template.
  2. The code comes from the workbook's name. Add a description and a category.
  3. 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.
  4. The gallery shows the preview picture. Choose Save.
Save as template dialog with the code, description Monthly sales review, category Sales, use as a template for none, and the preview picture

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.

Sheet Template Gallery with the standard templates and Monthly sales review in the Sales category, ready for Use Template

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.

Next step

Ready to try Bitta Sheets?