Bitta Sheets · Part 16 · 2:47 · YouTube
Business Central Report Templates You Reuse
What this video covers
Start Business Central workbooks from templates. A sheet template asks for a few values, like a customer or a period, and builds the workbook for you.
Use the six standard templates, open Customer 360 straight from a customer card, save any workbook of your own as a template, and start new workbooks from it with New from Template.
Transcript
Marcus needs the same customer review every month. A template builds it for him. Here's how to start workbooks from templates. 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. Sheet Templates lists the six standard templates, each with a category and its number of parameters.
Receivables by salesperson, a balance sheet comparison, customer 360, department budgets, profit and loss against budget, and vendor spend by quarter. Some open from a record.
Customer 360 opens from a customer. Open one 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.
Customer 360 opens right from the customer card. In the Actions menu, choose Open in Sheet Template. The customer number and name are already filled in. Type the period, here 2025, and choose OK.
Business Central builds a new workbook: Customer 360 for customer 30000. The filters hold the customer and the period. Below them, the balance, and the ledger by month, with payments and invoices.
Any workbook can become a template. Here, Sales Dashboard. In the 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 it to a kind of record, like customers, so it opens from those records. Here it stays at none.
The gallery shows this preview. Choose Save, and the template joins the standard ones. To use it, choose New from Template on the Workbooks page. The gallery lists your template with the standard ones:
Monthly sales review, in Sales. Pick it, and choose Use Template. The new workbook takes its name from the template's description, and opens with the same pivots and KPI card,
on live data. To copy a workbook exactly as it is, mark it as a template on the Workbooks page instead. The guide shows how.
Use a template for any workbook you build again and again: for each customer, each period, or each new team. Next, share a workbook, present it, and move it.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping