BeyondERP.Newsletter
Menu

Setup step on the Free text invoice templates page · Accounts receivable

Set up Free text invoice templates

Stores reusable free text invoice definitions, including lines, charges and accounting distributions, that are assigned to customers to generate recurring invoices.

Used by
Accounts receivable clerk, Accounts receivable manager, Collections agent and 8 more roles
Business process
Generate recurring free text invoices in Dynamics 365 Finance
Menu item
CustInvoiceTemplate
Main table
CustInvoiceTemplate
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isThe page where reusable free text invoice templates are maintained.
What you do hereUse this page to create free text invoice templates with invoice lines, charges, an accounting distribution template and ledger account information.
ExampleAn existing free text invoice can be saved as a template with Save to template on the Invoice tab, entering a name and description.
Free text invoice templates page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Free text invoice templates5 screens

Stores reusable free text invoice definitions, including lines, charges and accounting distributions, that are assigned to customers to generate recurring invoices.

  1. Screen 1

    Create the free text invoice template

    Go to Accounts receivable > Invoices > Recurring invoices > Free text invoice templates

    1. Select New and enter BEAT-SERVI as the template, with a description
    2. On the General FastTab, set the posting profile
    3. On the Payment FastTab, set the currency and terms of payment
    4. On the Invoice lines FastTab, select Add and enter the main account, quantity and unit price
    1Posting profileBEAT
    2Terms of paymentNET30
    DescriptionService 300 USD NET30
    CurrencyUSD
    Main account410100
    Quantity1.00
    Unit price300.00
    Create the free text invoice template (zoomed on the outlined fields)
    Show the full screenCreate the free text invoice template
    page title tab to open what to set or check
  2. Screen 2

    Check the posted invoice

    Go to Free text invoice BEAT-000004, Lines tab

    1. Open free text invoice BEAT-000004
    2. Review the header and the Invoice lines FastTab

    Check Invoice BEAT-000004 for customer BEAT-000001 shows currency USD, accounting status Completed, terms NET30, date 10/7/2026, and one line of 1 x 300.00 = 300.00 USD to main account 410100.

    Check the posted invoice
    page title tab to open what to set or check
  3. Screen 3

    Check the invoice settlement

    Go to Customer transactions > View settlements

    1. Open the customer's transactions
    2. Select the credit voucher BEAT-40000004 and open View settlements

    Check Credit voucher BEAT-40000004 (-300.00) and invoice voucher BEAT-30000003 (300.00 USD) are each settled 300.00, with settlement and closed dates of 10/7/2026 and a balance of 0.00.

    Check the invoice settlement (zoomed on the outlined fields)
    Show the full screenCheck the invoice settlement
    page title tab to open what to set or check
  4. Screen 4

    Check the ledger vouchers

    Go to General ledger > Inquiries and reports > Voucher transactions

    1. In the Inquiry dialog, set Voucher to BEAT-30000003,BEAT-40000004 and select OK
    2. Review the four lines on the Overview tab

    Check Invoice voucher BEAT-30000003 (document BEAT-000004) posts 120100 +300.00 and 410100 -300.00 USD; credit note voucher BEAT-40000004 (document BEAT-000005) posts the exact opposite: 120100 -300.00 and 410100 +300.00 USD.

    Check the ledger vouchers (zoomed on the outlined fields)
    Show the full screenCheck the ledger vouchers
    page title tab to open what to set or check
  5. Screen 5

    Check the second posted invoice

    Go to Free text invoice BEAT-000006, Lines tab

    1. Open free text invoice BEAT-000006
    2. Review the header and the Invoice lines FastTab

    Check Invoice BEAT-000006 for customer BEAT-000001 is dated 10/7/2026, due 11/6/2026, with accounting status Completed, terms NET30, and one line of 1 x 100.00 = 100.00 USD to main account 410100.

    Check the second posted invoice (zoomed on the outlined fields)
    Show the full screenCheck the second posted invoice
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Accounts receivable > Invoices > Recurring invoices > Free text invoice templates.
  2. Select New.
  3. In the Template name field, enter a unique name, and enter a Description.
  4. Expand the Invoice lines tab and enter a Description for the line.
  5. In the Main account field, select a revenue account.
  6. Select the Sales tax group and Item sales tax group for the line.
  7. Enter the Quantity and Unit price.
  8. Add more lines as needed and review the accounting distributions for each line.
  9. Select Close.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Template nameA unique name that identifies the template.Microsoft Learn TemplateName
Main accountThe revenue account for the template line.Microsoft Learn 410100LedgerDimension
Sales tax groupThe sales tax group for the line; it defaults from the customer account.Microsoft Learn
Unit pricePrice per unit, multiplied by the quantity to give the line amount.Microsoft Learn 300.00
DescriptionA short text that describes the template.Microsoft Learn Service 300 USD NET30
Posting profileGENPostingProfile
CurrencyUSDCurrencyCode
Terms of paymentNET30Payment
Quantity1.00Quantity

Test checklist

  1. Create a template with two lines, each with a revenue Main account, Sales tax group, Quantity and Unit price.
  2. Assign it to a customer under Invoice > Recurring invoices with a Billing start date, a monthly Recurrence pattern and default values from the template.
  3. Generate recurring invoices and check that one free text invoice is created under a recurrence ID with the template lines and amounts.
  4. Delete the generated invoice, generate again and check that it's recreated.
  5. Post the invoice from Post recurring invoices and check the voucher uses the template's revenue accounts.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Free text invoice templatesOne template per recurring service, complete with lines, revenue main accounts, sales tax groups, charges and accounting distributions. On each customer's recurring invoice setup, decide whether defaults come from the template or from the customer account.A recurring template is effectively a whole invoice saved for reuse. When it's assigned to a customer, the setting Generate recurring invoices by using the default values from decides whether payment terms, sales tax groups, posting profile, currency and financial dimensions come from the template or the customer.Using Save to template with a name that already exists. The system warns you, but selecting OK replaces the existing template, and every customer using that template then gets the new lines.Test: Recurring invoice uses the chosen default source
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Template changes apply to invoices generated afterwards. Generated recurring invoices can be reviewed and deleted before posting; deleting one resets the customer's recurrence for that template so you can generate it again.
If you change it laterWhen generating recurring invoices, defaults such as payment terms and tax groups come from either the template or the customer account, as chosen on the customer's recurring invoice setup. Microsoft Learn
Technical architect

6Technical

Menu itemCustInvoiceTemplate Checked in Dynamics 365
FormCustInvoiceTemplate Checked in Dynamics 365
TableCustInvoiceTemplateShown as “Free text invoice template” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain customer invoice template CustInvoiceTemplateMaintainView a list of invoices that were generated for this customer and the template that was used CustInvoiceTemplateViewDutiesInquire into customer invoice status CustInvoiceCustomerInvoiceStatusInquireMaintain customer invoice transactions CustInvoiceCustomerInvoiceTransMaintain
11 security rolesCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerk
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts receivable clerk CustInvoiceAccountsReceivableClerkTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerCollections manager CollectionLetterCollectionsManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkGive people one of these roles. On this system, 11 roles can open this page.Checked in Dynamics 365
Actions on the pageButtons: Copy, Charges, Assigned customersChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustInvoiceTemplate
Table definitionCustInvoiceTemplate columns and relations Microsoft data model
Everyone

8Sources