Print manual  

 NCRC Recurring Contracts


Contracts for automated invoice creation and billing.
Current Version: 21.1.1.1 as of Business Central 21.

Manual


Creation date: 2024/05/17
The current version of this manual can be found at:

https://www.navax.app/help.php?AppID=NCRC&L=en


☰ Contents



General

  • NCRC Recurring Contracts
    NCRC Recurring Contracts adds contracts to Microsoft Dynamics 365 Business Central for automated invoice creation and billing...

Working With The App

  • Contract Creation

    • Customer Contract
    • Vendor Contract
  • Billing

    • Customer Contract
      Click the Create Sales Invoice button at the Contract header or in the Contract overview...
    • Vendor Contract
      Unlike sales invoices from Contracts, purchase invoices are not collected from the Contract...
  • Dimensions

    • Dimension Setup
      By default, both shortcut dimensions are displayed in the Contract line. Additionally, all other dimensions can be activated in the NCRC Recurring Contracts setup...
    • Dimensions in Contract
      For line-level actions that cause the Payment Plan to be regenerated, dimension value changes can be entered directly in the associated input mask...
  • Payment Plan

    • Working With Payment Plan
      The Payment Plan defines when and how much will be invoiced...
    • Payment Plan and Start of Period
      The default Day of Period Start is defined in the NCRC Recurring Contracts setup and is transferred from there to the Contract header and thus also to the Contract lines...
  • Indexing

    • Indexing Setup
      In the Contract setup in the Indexing tab, an index status must be entered, as well as the rounding precision...
    • Working With Indexing
    • Working With Retrospective Indexing
  • Cancellation

    • Working With Cancellation
      Cancellation of a Contract or a Contract line takes place at the customer's request and must happen within deadlines defined at the Contract header...
  • Extension

    • Working With Manual Extension
      Contracts can be extended by a defined interval...
    • Working With Auto. Extension
      Contracts or Contract lines that are not cancelled before the deadline may also be automatically extended...
  • End Contract

    • Working With Auto. Ending
      Once a Contract line has been fully invoiced and is no longer to be extended, the status can be set to Ended via a Job queue entry, thus marking the Contract line as closed...
  • Job Integration

    • Job Setup
      Activate Job integration to create Jobs for Contracts...
    • Working With Job
      Use the Create Project action to create a project for a Contract. The project number is then entered in the corresponding field at the Contract header as well as the Contract lines...
    • Working With Job And Contract
      You can connect a Customer Contract and a Vendor Contract using a Job, thereby comparing the actual values from the purchase invoices and sales invoices. To do this, first create the Customer Contract and create a Job...
  • Prepayment

    • Prepayment Setup
      To manage Prepayment, you must enable Job Integration in the NCRC Recurring Contracts Setup...
    • Working With Prepayment
  • Consumption Based

    • Consumption Based Setup
      To be able to invoice at cost, you must activate Job Integration in the NCRC Recurring Contracts Setup...
    • Working With Consumption Based
  • Scheduled Change

    • Scheduled Change Setup
      To use Scheduled Changes, you must enable them in the NCRC Recurring Contracts Setup...
    • Working With Qty. Increase
      An increase in quantity, for a period already invoiced, results in a sales invoice for one or more periods...
    • Working With Price Increase
      An increase in the price, for a period already invoiced, results in a sales invoice for one or more periods...
    • Working With Qty. Decrease
      A decrease in quantity, for a period already invoiced, results in a sales credit to one or more periods...
    • Working With Price Decrease
      A decrease in the price, for a period already invoiced, results in a sales credit memo to one or more periods...
    • Working With Qty. Change in Future Periods
      A change does not result in the creation of documents it only adjusts the payment schedule...
    • Working With Price Change in Future Periods
      A change does not result in the creation of documents it only adjusts the payment schedule...
    • Working With Date Change
      There is the possibility to change the start and end date of a Contract line afterwards. To do this, open Functions > Scheduled Date Changes on the Contract line. You can then enter a new start or end date...
  • Bundles

    • Working With Bundles

Setup

  • NCRC Recurring Contracts Setup
    Here you can specify the general settings and defaults for the NCRC Recurring Contracts...

Appendix

  • NAVAX License Management
    The NAVAX License Management page (in older versions NAVAX License Overview or NCEX License Overview) displays the current license status of the NAVAX extensions...
  • Installation Notes
  • Release Notes

Docs  /  NCRC Recurring Contracts  /  General
NCRC Recurring Contracts

NCRC Recurring Contracts adds contracts to Microsoft Dynamics 365 Business Central for automated invoice creation and billing.

Navigation

The NCRC Recurring Contracts is integrated into its own Contract Processor roles. Fields, actions, pages and reports originating from the NCRC Recurring Contractsg extension are identified by the abbreviation NCRC. This additional labeling makes them clearly distinguishable from other extensions (which may use similar names and designations). The search terms "nvxrc", "ncrc" and "navax" are also recognized by "Tell me what you want to do". This allows very fast access to the individual areas of NCRC Recurring Contracts. NCRC stands for NAVAX Consulting Recurring Contracts.

Permission Sets

The following permission sets are available for NCRC Recurring Contracts:
NameDescription
NVXRCNCRC Recurring Contracts You need these permissions to use NCRC Recurring Contracts.
NVXRC SetupNCRC Setup Recurring Contracts You need these permissions to set up NCRC Recurring Contracts. For more information, see Setup, NCRC Recurring Contracts Setup.

Installation Notes

For more information, see Appendix, Installation Notes.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Contract Creation
Customer Contract

Creating A New Contract

Open the page Contract List and click on New. The following values should be entered at the Contract header:
FieldDescription
Starting DateDefines the start date of the entire Contract
The value entered here is transferred to the Contract lines, but can be changed per Contract line.
Ending DateDefines the end date of the entire Contract
The value entered here is transferred to the Contract lines, but can be changed per Contract line.
Billing TypeDefines how often to invoice (monthly, quarterly, annually, etc.)
Source TypeCustomer
No.Customer No.
For more information, see Contract Card. In addition, define default values for the Contract lines for the Cancellation and Indexing sections. As soon as the Contract number, the origin number and the Customer number have been entered in the Contract header, you can enter the Contract line. The status in the Contract line cannot be edited. When a new Contract is created, the default status from the NCRC Recurring Contracts Setup is automatically applied. Status changes can only be made using the associated feature. Select the type and No. of the object (Item, G/L Account, Resource) you want to invoice your Customer and enter the quantity as well as the price per invoicing period. All other values are taken from the Contract header and can be adjusted per Contract line.

Create new Contract from Sales Quote/Sales Order

In the sales quote/sales order, under Actions > Function > NCRC Recurring Contracts > Create New Contract, select to create a new Contract. A new page then opens where you can enter Contract-specific information. The values are then transferred to the Contract header and automatically applied to the Contract lines. The sales offer or sales order can then be deleted (or archived). In the newly created Contract, the values from the offer or order lines are automatically transferred to the Contract lines, whereby the quantity in the offer/order then corresponds to the quantity to be invoiced per period. Change the status, to the Active status defined in the NCRC Recurring Contracts Setup, to generate invoices from your Contract.

Adding Sales Offer/Sales Order Lines to existing Contract

If a Contract already exists for a customer, you can also add offer or order lines to it. To do this, use Actions > Function > NCRC Recurring Contracts > Add lines to existing Contract. A selection list of all Contracts will then open for the Customer and the desired Contract can be selected. The sales line is then created as a new line in the Contract. Further Stepts see Billing

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Contract Creation
Vendor Contract

Create new Contract

Vendor Contracts must be compulsorily created from purchase requests or purchase orders. For the creation as well as the correct posting of purchase invoices to Vendor Contracts from purchase inquiries or purchase orders, it is mandatory to activate the archiving of inquiries/purchase orders.

Important

Activate archiving under Purchases & Payables Setup > Archive Quotes > Always & Archive Orders.
Enter a purchase request or purchase order. To convert it into a Contract, choose Actions > Function > NCRC Recurring Contracts > Create New Contract. A new page then opens where you can enter Contract-specific information. The values are then transferred to the Contract header and automatically applied to the Contract lines. The purchase request or purchase order can then be deleted (or archived). In the newly created Contract, the values from the inquiry or order line are automatically transferred to the Contract line, whereby the quantity in the offer/order then corresponds to the quantity to be invoiced per period. Change the status to the Active status defined in the NCRC Recurring Contracts Setup to assign purchase invoices to the Contract.

Adding Request/Order Lines To Existing Contract

If a Contract already exists for a Vendor, you can also add request or order lines to it. To do this, use Actions > Function > NCRC Recurring Contracts > Add lines to existing Contract. A selection list of all Contracts will then open for the Vendor and the desired Contract can be selected. The purchase line is then created as a new line in the Contract. Further Stepts see Billing

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Billing
Customer Contract

Click the Create Sales Invoice button at the Contract header or in the Contract overview.

Options

Bill Until DateSpecify the date up to which the invoices should be created
Document DateSpecify the document date of the sales invoice to be created
Posting DateSpecify the posting date of the sales invoice to be created. By specifically setting the posting date, you can control an allocation in advance or in retrospect.
Do Not Create Invoice for PeriodIf enabled, all periods up to the Settlement to date will be marked as Invoiced in the payment schedule without creating an actual document.
Combine PeriodsDefines whether you want to create one invoice per period to be charged, or one invoice for all periods.
Create Invoices perDefines at which level the invoice will be created:
  • Contract Line
  • Contract

Customer (Requires the "Combine invoices" indicator to be set in the required contracts).
The created, unposted sales invoice is visible in the Payment Plan and can be accessed from here. If you want to delete the unposted invoice, you can either run the Correct Billing feature in the Payment Plan or open the invoice and delete it there. The period is then marked again in the Payment Plan as not invoiced and can be offset. To post the invoice, open the document and click Post. In the Payment Plan the posted invoice No. will be entered. If you need to cancel the posted invoice, use either the associated function in the Payment Plan or the standard functions (Cancel Sales Invoice, Correct Sales Invoice) in the sales invoice. This will then post a sales credit memo and allow you to recreate the sales invoice. The original sales invoice as well as the created sales credit memo are attached in the payment schedule as Assigned documents of the period. For each sales invoice line, which is created from a Contract, a remark line is created which gives conclusions about the Contract number and Contract line number, as well as the period. In the NCRC Recurring Contracts Setup you can define if only the period, excl. the Contract number/Contract line number should be printed.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Billing
Vendor Contract

Unlike sales invoices from Contracts, purchase invoices are not collected from the Contract.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Dimensions
Dimension Setup

By default, both shortcut dimensions are displayed in the Contract line. Additionally, all other dimensions can be activated in the NCRC Recurring Contracts setup. Upon activation, the fields are automatically displayed in the line and can be filled.

Important

The dimensions will ONLY be included in the Payment Plan and not any receipts that may be created in conjunction with the Contract.
For more information, see Working With The App, Dimensions, Dimensions in Contract.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Dimensions
Dimensions in Contract

For line-level actions that cause the Payment Plan to be regenerated, dimension value changes can be entered directly in the associated input mask. To do this, Change Dimensions must be activated. The dimension fields defined in the NCRC Recurring Contracts Setup will then be displayed and can be filled. Dimension values are only visible in the Contract Payment Plan card via Related > Contract > Active Payment Plan.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Payment Plan
Working With Payment Plan

The Payment Plan defines when and how much will be invoiced. It is clearly assigned to a Contract line. The active Payment Plan for the respective Contract line is displayed directly below the Contract line or can be reached via Related > Payment Plan. The Payment Plan is built for the entire Contract line period (start date - end date) based on the Contract line details (Quantity, Unit Price, Billing Period). The first Payment Plan is created at initial activation (Active status per NCRC Recurring Contracts Setup). In case the values of the Contract line change or another action is executed which influences the Payment Plan, a new Payment Plan version will be created and activated. Example 1: monthly billing Example 2: half-yearly billing Example 3: yearly billing For more information, see Working With The App, Payment Plan, Payment Plan and Start of Period.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Payment Plan
Payment Plan and Start of Period

The default Day of Period Start is defined in the NCRC Recurring Contracts setup and is transferred from there to the Contract header and thus also to the Contract lines. Day of Period Start = 1 means that, regardless of the start date of the Contract line, invoicing is always from 01 to the following 01. Started periods will be partially invoiced. Set Day of Period Start to Starting Date defines whether the start date of the period should be automatically adjusted to the start date for Contract lines with a different start date.

Example Day of Period Start: 01

Billing interval: 1M (no different start of period set in billing interval) Price per period: 100 € Start date in the Contract line: 05.01.2023 End date in the Contract line: 04.01.2024

Important

Only complete periods can be charged in a Contract period, i.e. the first partial period and the last partial period must result in a complete period.

Result:

In the Payment Plan, 13 periods are created, with the first period having a term from 05.01.2023 to 31.01.2023 (period start 01). Subsequently, all complete periods are invoiced, whereby these always start on day 1. The last period is again not a complete period. The price is calculated as follows. price per period – value of the first partial period = value of the last partial period 100 – 90 = 10

Example Day of Period Start: 15, deviating Contract period

Billing interval: 1M (Different start of period set in billing interval) Price per period: 100 € Start date in the Contract line: 01.01.2023 End date in the Contract line: 31.12.2023

Important

Only complete periods can be charged in a Contract period, i.e. the first partial period and the last partial period must result in a complete period.

Result

In the Payment Plan, 13 periods are created, with the first period having a term from 01.01.2023 to 14.01.2023 (period start 15). Subsequently, all complete periods are invoiced, whereby these always start on day 15. The last period is again not a complete period. The price is calculated as follows. price per period – value of the first partial period = value of the last partial period 100 – 46,67 = 53,33

Example Day of Period Start: 05, identical Contract period

Billing interval: 1M (Different start of period set in billing interval) Price per period: 100 € Start date in the Contract line: 05.01.2023 End date in the Contract line: 04.01.2024

Important

Only complete periods can be charged in a Contract period, i.e. the first partial period and the last partial period must result in a complete period.

Result

In the Payment Plan 12 periods are created and all periods are identical.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Indexing
Indexing Setup

In the Contract setup in the Indexing tab, an index status must be entered, as well as the rounding precision. It is recommended to enter 0.01 for the rounding precision to avoid error messages. In the index list, index codes are entered, which are then also assigned to a Contract, or a Contract line. Index values can be entered for each index code. For more information, see Working With The App, Indexing, Working With Indexing.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Indexing
Working With Indexing

The index fields must be maintained in the Contract header or Contract line, and the index values must be maintained in the corresponding index code in the starting month and year and in the comparison month and year: Indexing can be performed for one Contract line, one Contract or several or all Contracts. To do this, click Actions > Indexing. After the indexing has been performed, the new prices are transferred directly to the Contract line. Via the indexing log, which can be found under Related > History > Indexing Log, the calculated values can be printed. There is an additional option to inform Customers about the index adjustment via an additional text in the sales invoice. Set Printed is then set in the indexing log. After the indexing has been performed successfully, the new index values (month/year) are adjusted in the Contract line. At the Contract header the original values remain. For more information, see Working With The App, Indexing, Working With Retrospective Indexing.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Indexing
Working With Retrospective Indexing

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Cancellation
Working With Cancellation

Cancellation of a Contract or a Contract line takes place at the customer's request and must happen within deadlines defined at the Contract header. The period is defined by the values from the Cancellation Type & Cancellation Allowed fields.

Example 1:

Cancellation Period: 1M Allowed Cancellation: Till end of contract Thus, the termination must be submitted no later than 1 month before the end date of the Contract or Contract line to be valid.

Example 2:

Cancellation Period: 1M Allowed Cancellation: Till end of a year The cancellation must be submitted at least 1 month before the end of the year, i.e. 30.11.XX, in order to be valid.

Example 3:

Cancellation Period: - Allowed Cancellation: Till end of the month The notice of cancellation can thus be submitted monthly. In case of the cancellation periods, which have a reference to the current date (Till end of a year, Till end year quarter, Till end of the month), there is an additional task queue item, which updates the date. For day-accurate calculation of the allowed cancellation date, the Job queue entry should be run daily. If a cancellation is not submitted in time, the Contract may be automatically extended. For more information, see Working With The App, Extension, Working With Auto. Extension. When a cancellation is entered into the system, the cancellation status defined in the NCRC Recurring Contracts Setup is set. The status must have the "Billable" boolean enabled, as invoices can still be created from a terminated Contract. A cancellation can be executed either for a Contract line only or for an entire Contract.

Cancelling a Contract line

If only one line is cancelled, but the Contract remains valid, the line action can be executed under Functions > Cancel Contract Line. Only Contract lines that are marked as Billable can be cancelled. For more information, see NCRC Contract Status. An input mask then opens, which is preset with values from the associated Contract line

Options

Cancellation Reasonselection of a predefined cancellation reason in the NCRC Cancellation Reason table.
Cancellation DateThe calculated date based on the entry of the "Allowed Cancellation" field (Contract end date, year-end date, quarter end date, month end date).
Latest Allowed Cancellation DateThe calculated date based on the entry of the "Allowed Cancellation" field (Contract end date, year-end date, quarter end date, month end date) minus the cancellation period.
Cancellation Received AtThe Business Central work date
Upon successful execution of the cancellation, the following will be executed:
  • The status changes to the defined cancellation status
  • The Contract line is no longer marked as to be extended
  • The recorded cancellation values are recorded in the Contract line

Important

The cancellation has NO effect on the end date of the Contract line. If the end date is to be brought forward by the cancellation, this must happen manually.
Once the Contract line is ended (no more non-invoiced Payment Plan lines), the Contract line is automatically cancelled. For more information, see Working With The App, End Contract, Working With Auto. Ending.

Cancel entire Contract

In case an entire Contract is cancelled, the action can be executed at the Contract header under Actions > Cancel Contract. Only Contract lines that are marked as billable can be cancelled. For more information, see NCRC Contract Status. The same input mask opens as for the cancellation on line level. This will be filled with values from the Contract lines, if they are identical. If the cancellation date and consequently also the latest permissible cancellation date in the affected Contract lines are different, no default values are displayed. The entry of the cancellation data is identical to the cancellation at line level. Only those Contract lines are then marked as cancelled for which the cancellation was received before the deadline.

Revoke Cancellation

To reverse a cancellation, only the status must be changed. The recorded cancellation values are then automatically deleted.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Extension
Working With Manual Extension

Contracts can be extended by a defined interval. To do this, check the Extension box in the Contract line and define the extension type. Extension Types/Periods are maintained in the Contract Periods table. For more information, see NCRC Contract Periods. It is also possible to enter the extension type at the Contract type. The defined extension type is then automatically set in all Contract lines. This interval is then used to calculate the new end date of the Contract line. Contracts can be extended under Actions > Extend Contract. Then - independent of the time of the execution of this function - the end date of all Contract lines will be set back by the respective defined interval and a new Payment Plan will be created. The status of the Contract line briefly changes to the Extension status defined in the NCRC Recurring Contracts Setup. The status change can then be tracked at header and line level under History > Status Change Log. The Payment Plan will then use the price and quantity of the original last Payment Plan line for all newly created Payment Plan lines.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Extension
Working With Auto. Extension

Contracts or Contract lines that are not cancelled before the deadline may also be automatically extended. For this, the associated Job queue entry must be created: A Contract line is automatically extended when:
  • Status = Active
  • End Date > Work Date
  • Extension = enabled

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  End Contract
Working With Auto. Ending

Once a Contract line has been fully invoiced and is no longer to be extended, the status can be set to Ended via a Job queue entry, thus marking the Contract line as closed. A Contract line is set to the Ended status defined in the NCRC Recurring Contracts Setup when:
  • Status = Active/Cancelled
  • End Date > Work Date
  • Extension = Disabled
  • Payment Plan = Completly Billed

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Job Integration
Job Setup

Activate Job integration to create Jobs for Contracts. Jobs for Contracts offer versatile advantages; for example, Customer and Vendor Contracts can be linked to calculate the actual profit of a Contract line.

Important

Jobs are also required to use Prepayments or to invoice at cost.
Open the NCRC Recurring Contracts Setup and enable Project Integration. In the Job No. for Contracts field, select the number series to be used when creating Jobs from Contracts & define a Default Job. Only after activating the Job Integration, the corresponding fields & actions will be displayed in the Contract. For more information, see Working With The App, Job Integration, Working With Job.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Job Integration
Working With Job

Use the Create Project action to create a project for a Contract. The project number is then entered in the corresponding field at the Contract header as well as the Contract lines.

Important

The lines must not be Active or Ended, otherwise the Job No. cannot be entered in the line.
Provided you have enabled Create Job Task and Planning Lines in the NCRC Recurring Contracts Setup, when enabled, a Job task and planning line will be created and assigned to the Contract line. The assignment of Job, Job Task & Job Planning Line can also be done manually. A Job is created for each Contract line. The Job Task No. is assigned based on the Start No. in the NCRC Recurring Contracts Setup. The description corresponds to the description of the Contract line. In addition, a Job Planning Line is created for each Contract line.
FieldValue
Planning DateStart date of the Contract line
Line TypeBudget
Document No.Contract No.
TypeContract line type
No.Contract line No.
DescriptionContract line description
QuantityTotal quantity for the complete duration of the Contract line
Unit CostCost price of the Contract line - if filled
Unit PriceSales price of the Contract line - if filled
Job Planning Lines that are linked to a Contract cannot be changed or posted or invoiced from within the Job. Please use the corresponding functions in the Contract. As soon as a Contract linked to a Job creates a sales invoice, a billable Job Planning Line is created, and it is invoiced. This creates a Job item of type sales on the Job, and the actual values end up on the Job. For more information, see Working With The App, Job Integration, Working With Job And Contract.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Job Integration
Working With Job And Contract

You can connect a Customer Contract and a Vendor Contract using a Job, thereby comparing the actual values from the purchase invoices and sales invoices. To do this, first create the Customer Contract and create a Job. Then create a Vendor Contract and select the Job number of the previously created Customer Contract. If there is a 1:1 mapping between Customer Contract line and Vendor Contract line; select the Job Task No. of the Customer Contract line. The Job is then populated with the budget cost amount and the actual costs from the Vendor Contract and the budget sales amount and the invoiced value from the Customer Contract.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Prepayment
Prepayment Setup

To manage Prepayment, you must enable Job Integration in the NCRC Recurring Contracts Setup. Also define the Prepayment Job Journal Name, the Prepayment Job Journal Batch Name and the Prepayment Journal Document No. to be used for posting Prepayments. For more information, see Working With The App, Prepayment, Working With Prepayment.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Prepayment
Working With Prepayment

Enter Prepayment line

Prepayments are fixed defined amounts/quantities which you charge your Customer in full and from which they can then call. To enter a new Prepayment, create a new Contract line and enter the No. as well as the quantity and price. Since a Prepayment is invoiced once and not continuously, the billing type must be removed in Prepayment lines. A Contract line of the Prepayment type therefore also has no Payment Plan. Check the Prepayment box and define the Prepayment type.
Prepayment TypeDescription
QuantityIt is called from a defined quantity, regardless of the amount that is consumed
AmountIt is called off from a defined amount, regardless of the actual amount called off
You can also define whether Business Central allows overbooking of the defined quantity or amount by enabling or disabling Overbooking Not Allowed. Before you can activate a Contract with a contingency line, you must link the Contract or Contract line to a Job.

Invoicing Prepayments

Prepayment invoices are usually issued at the beginning of the Contract. To create a Prepayment invoice, select the desired Contract line. Click on Line > Prepayment > Invoice Prepayment. An unposted invoice will be created which you can access and post via Line > Prepayment > Sales Invoice/Credit Memos.... In the Prepayment area in the info box, you can see if and what has been invoiced from your Prepayment.

Retrieve Prepayment in Contract

The actual consumed values can be entered either manually, or via Excel import. To enter the consumptions manually, select the desired Contract line and click Line > Prepayments > Use Prepayment. Then enter the consumption date and the quantity or value consumed. In the Prepayment area in the info box, you can see the retrieved values. If you have activated Overbooking not Allowed, the system checks that the quantity to be called off does not exceed the remaining quantity and issues an error message if necessary.

Retrieve Prepayment via Excel import

To be able to enter consumptions via Excel, you must create the associated data exchange definition. To do this, run the associated Create Default Data Exchange Definition action for Prepayments in the NCRC Recurring Contracts setup. A data exchange definition is then created in which it is defined how the Excel file must be structured for the import. Based on the default setup, the import file must be structured as follows:
Contract IDDescription 2Quantity
C.23-000019_10000additional description1
The Contract ID consists of Contract number_line numberadditional import-specific descriptionquantity retrieved
Seperator: Semicolon Headline: Yes Invoke the Import Contract lines from Data Exchange Definition function. Select the data exchange definition CONTRACT COST (= default data exchange definition) Select the posting type Consumption Based. Select the posting date for the line items. Activate reverse signs to create negative items. This can be used to reverse items that have already been imported and posted. Click OK and import the .csv file.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Consumption Based
Consumption Based Setup

To be able to invoice at cost, you must activate Job Integration in the NCRC Recurring Contracts Setup. Also, define the Default Job Journal and the Job Journal Name to be used for posting the expenses. Activate Automatically Get Consumptions if you want recorded expenses to be transferred directly to the Payment Plan. For more information, see Working With The App, Consumption Based, Working With Consumption Based.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Consumption Based
Working With Consumption Based

Activate Contract line for Consumption Based

Create a new Contract line, leaving the quantity blank, and enable Consumption Based. Before you can activate a Contract with a Contract line that is billed at cost, you must link the Contract or Contract line to a Job. In the created Payment Plan, the quantity and the line amount are then initially 0.00 in all periods.

Get Costs in the Contract

The actual consumed values can be entered either manually, or via Excel import. To enter the consumptions manually, select the desired Contract line and click Line > Consumption > Add Consumptions. Then enter the Posting Date and the Quantity To Transfer To Journal.

Get Costs via Excel import

To be able to enter consumptions via Excel, you must create the associated data exchange definition. To do this, run the associated Create Default Data Exchange Definition for Consumption Based action in the NCRC Recurring Contracts Setup. A data exchange definition is then created in which it is defined how the Excel file must be structured for the import. Based on the default setup, the import file must be structured as follows:
Contract IDDescription 2Quantity
C.23-000019_10000additional description1
The Contract ID consists of Contract number_line numberadditional import-specific descriptionquantity retrieved
Seperator: Semicolon Headline: Yes Invoke the Import Contract lines from Data Exchange Definition function. Select the data exchange definition CONTRACT COST (= default data exchange definition) Select the posting type Consumption Based. Select the posting date for the line items. Activate reverse signs to create negative items. This can be used to reverse items that have already been imported and posted. Click OK and import the .csv file.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Scheduled Change Setup

To use Scheduled Changes, you must enable them in the NCRC Recurring Contracts Setup. By activating it, two new Contract line actions will be displayed. This allows Scheduled Changes to be created for past and future periods. Scheduled Changes can only be made at the Contract line level, not at the Contract header level, and may result in sales invoices or sales credit memos, if applicable. If you activate Scheduled Changes, you can only make changes using the associated functions. If you try to change the quantity, the price or the start and end date of the line, an error message will be displayed.

Caution

Scheduled changes cannot be executed for Contract lines of type Prepayment or Consumption Based.
When a scheduled change is executed, the status is briefly set to the defined change status and the change entered via the input mask is executed. This means that changes that have been made can also be tracked retrospectively via the Status Change Log.

Important

Documents which are created by scheduled changes must be posted and cannot be cancelled. If you want to cancel a document created from a scheduled change or undo the change, you must make an additional scheduled change.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Qty. Increase

An increase in quantity, for a period already invoiced, results in a sales invoice for one or more periods.

Example:

Initial situation: Quantity in the Contract line: 2 Price in the Contract line: 100,00 Start date: 01.01.23 End date: 31.12.23 Billed Until: 31.03.23 Input: New Quantity: 3 – the quantity is increased from 2 to 3 New Unit Price: 0,00 – the Unit Cost in the Contract line doesn’t change Date for Change: 01.02.23 – the period from which the change comes into force Posting Date: 01.02.23 – the posting date of the sales invoice Status for Change: the status that is set briefly to execute the change Combine Periods: If activated, sales invoices which concern several periods are summarized on one invoice. Change Dimensions: see Working With The App, Dimensions, Dimensions in Contract Result: However, the quantity was increased from 2 to 3 in period 2, which leads to an increase in the line amount and thus triggers a sales invoice. The sales invoice is created but not posted and can be seen in the relevant Payment Plan lines in the additional table No. of Related Documents. Click on the number to open all the documents that are assigned to the Payment Plan line. You can also see by which function the document was created. Click Source Document to open and post the sales invoice. The quantity in the Contract line has also been increased as the new quantity affects the next billing interval.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Price Increase

An increase in the price, for a period already invoiced, results in a sales invoice for one or more periods.

Example:

Initial situation: Quantity in the Contract line: 3 Price in the Contract line: 100,00 Start date: 01.01.23 End date: 31.12.23 Billed Until: 31.03.23 Input: New Quantity: 0 – the quantity remains the same New Unit Price: 200,00 – the Unit Cost in the Contract line increases from 100,00€ to 200,00€ Date for Change: 01.02.23 – the period from which the change comes into force Posting Date: 01.02.23 – the posting date of the sales invoice Status for Change: the status that is set briefly to execute the change Combine Periods: If activated, sales invoices which concern several periods are summarized on one invoice. Change Dimensions: see Working With The App, Dimensions, Dimensions in Contract Result: The unit price has been increased from 100 to 200 in period 2, which results in an increase in the line amount and thus triggers a sales invoice. The sales invoice is created but not posted and is visible in the relevant Payment Plan lines in the additional table No. of Related Documents and can be posted. The Unit Price in the Contract line has also been increased as the new price affects the next billing interval.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Qty. Decrease

A decrease in quantity, for a period already invoiced, results in a sales credit to one or more periods.

Example:

Initial situation: Quantity in the Contract line: 3 Price in the Contract line: 200,00 Start date: 01.01.23 End date: 31.12.23 Billed Until: 31.03.23 Input: New Quantity: 2 – the quantity is reduced from 3 to 2 New Unit Price: 0,00 – the Unit Cost remains the same Date for Change: 01.02.23 – the period from which the change comes into force Posting Date: 01.02.23 – the posting date of the sales invoice Status for Change: the status that is set briefly to execute the change Combine Periods: If activated, sales invoices which concern several periods are summarized on one invoice. Change Dimensions: see Working With The App, Dimensions, Dimensions in Contract Result: However, the quantity has been reduced from 2 to 1 in period 2, which results in a reduction of the line amount and thus triggers a sales credit memo. The sales credit memo is created but not posted and is visible in the relevant Payment Plan lines in the additional table No. of Related Documents and can be posted there. The quantity in the Contract line has also been increased as the new quantity affects the next billing interval.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Price Decrease

A decrease in the price, for a period already invoiced, results in a sales credit memo to one or more periods.

Example:

Initial situation: Quantity in the Contract line: 2 Price in the Contract line: 200,00 Start date: 01.01.23 End date: 31.12.23 Billed Until: 31.03.23 Input: New Quantity: 0 – the quantity remains the same New Unit Price: 100,00 – the unit cost decreases from 200 to 100 Date for Change: 01.02.23 – the period from which the change comes into force Posting Date: 01.02.23 – the posting date of the sales invoice Status for Change: the status that is set briefly to execute the change Combine Periods: If activated, sales invoices which concern several periods are summarized on one invoice. Change Dimensions: see Working With The App, Dimensions, Dimensions in Contract Result: However, the unit price has been reduced from 200 to 100 in period 2, which results in a reduction of the line amount and thus triggers a sales credit memo. The sales credit memo is created but not posted and can be seen in the relevant Payment Plan lines in the additional table Number of Assigned Documents and can be posted there. The unit price in the Contract line has also been increased as the new price affects the next billing interval.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Qty. Change in Future Periods

A change does not result in the creation of documents it only adjusts the payment schedule.

Example:

Initial situation: Quantity in the Contract line: 2 Price in the Contract line: 100,00 Start date: 01.01.23 End date: 31.12.23 Billed Until: 31.03.23 Input: New Quantity: 3 – the Quantity increases from 2 to 3 New Unit Price: 0,00 – the Unit Price remains the same Date for Change: 01.05.23 – the period from which the change comes into force Posting Date: can be left blank as this entry does not trigger a sales document Status for Change: the status that is set briefly to execute the change Combine Periods: If activated, sales invoices which concern several periods are summarized on one invoice. Change Dimensions: see Working With The App, Dimensions, Dimensions in Contract Result: The quantity has been increased from 1 to 2 starting from period 5, which results in an increase of the line amount but no additional document. The quantity in the Contract line has not been increased because the new quantity does not yet affect the next billing interval. Only when the new quantity affects the next billing interval, the new quantity is automatically transferred to the Contract line.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Price Change in Future Periods

A change does not result in the creation of documents it only adjusts the payment schedule.

Example:

Initial situation: Quantity in the Contract line: 1 Price in the Contract line: 100,00 Start date: 01.01.23 End date: 31.12.23 Billed Until: 31.03.23 Input: New Quantity: 0 – the Quantity remains the same New Unit Price: 50,00 – the Unit Price is decreased to 50,00 Date for Change: 01.05.23 – the period from which the change comes into force Posting Date: can be left blank as this entry does not trigger a sales document Status for Change: the status that is set briefly to execute the change Combine Periods: If activated, sales invoices which concern several periods are summarized on one invoice. Change Dimensions: see Working With The App, Dimensions, Dimensions in Contract Result: The unit price has been reduced from 100 to 50 starting from period 5, resulting in a reduction of the line amount but no additional document. The unit price in the Contract line has not been changed, because the new price does not affect the next billing interval yet. Only when the price affects the next billing interval, it will be automatically transferred to the Contract line.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Scheduled Change
Working With Date Change

There is the possibility to change the start and end date of a Contract line afterwards. To do this, open Functions > Scheduled Date Changes on the Contract line. You can then enter a new start or end date. If you set the start date later and the first period has already been invoiced, a sales credit note will be created for it. However, the original first period is no longer included in the new Payment Plan, and can therefore only be accessed and posted via the previous version of the Payment Plan.

Docs  /  NCRC Recurring Contracts  /  Working With The App  /  Bundles
Working With Bundles

To use Bundles, you must enable them in the NCRC Recurring Contracts Setup. This will cause two new fields to appear in the Contract lines as well as sales invoice lines:
  • Bundle
  • Belongs To Bundle
  • Print Line
  • Print Quantity
  • Print Price
In the Bundle field, select the Bundle value to enter the Bundle creation screen and create your Bundle there. Bundles consist of a text line as a header and one or more item lines and are created for each Contract. You can create the Bundle description as a default text and select it in the No. field, the components will be added individually. Certain values, such as the term and extension and termination type, are maintained at the Bundle header level and automatically copied to all component lines. By clicking OK, the Bundle will be added to the Contract. The Bundle line (=Bundle header) is a remark line and is displayed in bold, the component lines are assigned to the Bundle header line via the respective line ID in the Belongs to Bundle field. By default, the text, the quantity and the price are printed for the Bundle line. Printing is disabled for the component lines, but can be enabled for each individual component.

Important

The print logic can only be used in conjunction with RDLC documents that have implemented this logic.
The quantities and prices of the component lines are taken from the Bundle entry. The Bundle line receives the value 1 by default, the line amount corresponds to the sum of the line amounts of the associated components. If the quantity in the Bundle is changed, the Bundle's unit price is automatically adjusted so that the line amount per billing interval continues to equal the sum of the components. Values which must remain the same for the entire Bundle (e.g. Billing Type, Cancellation Type, etc.) cannot be changed in the Contract line. If these values must be edited afterwards, the Bundle entry mask can be called via Functions > Open Bundle. All components of a Bundle must always have the same status. If you change the Contract line status of a component line, the status of all component line is automatically changed. Payment Plans are created for the respective component lines, just as for normal Contract lines, and can then also be transferred to a sales invoice. The print options from the Contract line are transferred to the invoice.

Docs  /  NCRC Recurring Contracts  /  Setup
NCRC Recurring Contracts Setup

Here you can specify the general settings and defaults for the NCRC Recurring Contracts.

General, Fields

Default StatusSpecifies the default status used when creating the contract.
Active StatusSpecifies the active status used to set a contract to a billable status.
Cancellation StatusSpecifies the Cancellation status used for the Cancellation.
Extension StatusSpecifies the Extension status used for the Cancellation.
Ending StatusSpecifies the Ending status used for the Ending of a contract.
Set Day of Period Start to Starting DateSpecifies by default whether the day of the period start should be automatically adjusted to the start date for Contract lines with different start date.
Default Day of Period StartSpecifies the default value of the Day of Period Start.
Default Reason CodeSpecifies the default value of the Reason Code.
Contract Dimension CodeSpecifies the contract dimension code. When a new Contract is created, a new dimension value consisting of Contract No. and Contract Description is automatically created.
TODO_"Autom. Approval Request at Invoicecreation"Specifies that the approval request is created automatically if sales invoice approval is enabled.
TODO_"Limit Amount for Contract Invoice"Specifies the minimum value that a sales invoice created from a Contract must show. Invoices below this amount are not generated and the period is marked as invoiced.
Default Source TypeSpecifies the default value of the Source Type.
Print Only Period On InvoiceSpecifies whether the remark line in the sales invoice contains only information about the period (excl. Contract data).
Enable BundlesSpecifies whether the bundle functionality has been enabled.
Line Text For BundlesSpecifies whether only one remark line should be printed for a Bundle or one remark line per component.

Numbering, Fields

TODO_"Contract Nos"Specifies the code of the number series used to assign numbers to Contracts.
Contract Invoice Nos.Specifies the code of the number series used to assign numbers to Contract Invoices.
TODO_"Contract Cr.Memo Nos."Specifies the code of the number series used to assign numbers to Contract Cr. Memos.
Posted Contract Invoice NosSpecifies the code of the number series used to assign numbers to Posted Contract Invoices.
Posted Contract Cr. Memo Nos.Specifies the code of the number series used to assign numbers to Posted Contract Cr. Memos.

Dimensions, Fields

Enable Shorcut Dimension 3Specifies whether the shortcut dimension code 3 should be displayed.
Enable Shorcut Dimension 4Specifies whether the shortcut dimension code 4 should be displayed.
Enable Shorcut Dimension 5Specifies whether the shortcut dimension code 5 should be displayed.
Enable Shorcut Dimension 6Specifies whether the shortcut dimension code 6 should be displayed.
Enable Shorcut Dimension 7Specifies whether the shortcut dimension code 7 should be displayed.
Enable Shorcut Dimension 8Specifies whether the shortcut dimension code 8 should be displayed.

Role Center, Fields

Date Fromula for expiring ContractsSpecifies the Date Formula for the Cue No. of expiring Contract Lines.

Scheduled Changes, Fields

Disable Manual Changes on Contract LineSpecifies whether manual changes to the contract line have been deactivated. Changes can then only be made via the scheduled change functionality.
Retrospective IndexingSpecifies whether past periods are also taken into account during indexing. A difference invoice/cr. memo is then created for periods that have already been invoiced.
Change StatusSpecifies the change status that will be set for the scheduled changes.

Indexing, Fields

Indexing StatusSpecifies the Indexing status used for the Indexing.
Indexing Unit Cost RoundingSpecifies the rounding of the unit code field after an indexing
Indexing Unit Price RoundingSpecifies the rounding of the unit price field after an indexing

Job (Prepayment/Consupmtion), Fields

Enable Job IntegrationSpecifies whether job integration has been activated. Integration must be activated to record Prepayments/consumption.
Default JobSpecifies the Job number that will be used as a template from the Contract, when Create Job is executed.
Job Nos. for ContractsSpecifies the code of the number series used to assign numbers to Jobs from Contracts.
Create Job Task and Planning LinesSpecifies whether to automatically create the job tasks and planning lines for the contract lines.
Job Task No. Start No.Specifies the start number of the Job tasks and is always incremented by 1.

Prepayment, Fields

Prepayment Job Jnl. Document Nos.Specifies the Job journal document number used to post when getting Prepayment.
Prepayment Job Jnl. NameSpecifies the Job journal template used to post when getting Prepayment.
Prepayment Job Jnl. Batch NameSpecifies the Job journal batch name used to post when getting Prepayment.

Consumption, Fields

Consumption Job Jnl. NameSpecifies the Job journal template used to post consumption.
TODO_"Consumption Job Jnl. Batch Name"Specifies the Job journal batch name used to post consumption.
Automatically Get ConsumptionsSpecifies whether entered or imported consumptions are automatically transferred to the Payment Plan.

Sales, Fields

Sales Release Needed at Contract CreationSpecifies whether a sales quote or sales order must be in Released status for a contract to be created.

Purchase, Fields

TODO_"Gen. Journal Document Nos. Purchase Invoice"Specifies the Gen. Journal Document Nos. Purchase Invoice used to post an purchase invoice.
TODO_"Gen. Journal Template Purchase Invoice"Specifies the value of the Gen. Journal Template Purchase Invoice field.
TODO_"Gen. Journal Name Purchase Invoice"Specifies the value of the Gen. Journal Name Purchase Invoice field.
Purchase Release Needed at Contract CreationSpecifies whether a purchase quote or purchase order must be in Released status for a contract to be created.

Import, Fields

Contract Import Attribute IDSpecifies the Contract Import Attribute ID for the import.
Contract Import AttributeSpecifies the Contract Import Attribute for the import.

Reminder, Fields

ActiveSpecifies whether the reminder is active for contracts that are about to expire.
PeriodSpecifies the period from which a reminder should be sent out for a Contract. 1M = A reminder will be sent starting 1 month before the end date
RecipientSpecifies the recipient of the reminder.
E-MailSpecifies wheter the reminder will be send via E-Mail.
TeamsSpecifies wheter the reminder will be send via Teams.
E-Mail SubjectSpecifies the subject of the reminder E-Mail.
E-Mail-Notification TextSpecifies the content of the E-Mail
Flow URLSpecifies the request URL of the Power Automate Flows.

Actions

  • Create Default Data Exchange Definition for Consumption Based

    Executes the Create Default Data Exchange Definition for Consumption Based action.
  • Create Default Data Exchange Definition for Prepayment

    Executes the Create Default Data Exchange Definition for Prepayment action.
  • NAVAX License Management

    Opens the NAVAX License Management which displays the current license status of the NAVAX extensions.

Docs  /  NCRC Recurring Contracts  /  Appendix
NAVAX License Management

The NAVAX License Management page (in older versions "NAVAX License Overview" or "NCEX License Overview") displays the current license status of the NAVAX extensions. In order for a NAVAX extension to be displayed in this page, the corresponding setup of the extension must first be opened.

Note

Changes as of Version xx.1.16.0 The NAVAX License Management page now supports automatic adding of NAVAX extensions. NAVAX extensions that use this system no longer need to have the corresponding extension setup opened first to be displayed in this page.

Fields

NameSpecifies the name of the Extension.
License StatusSpecifies the current license status of the Extension.
Serial No.Specifies the serial number of the Extension.
VersionSpecifies the currently installed version of the Extension.

Trial Version

A NAVAX extension can be tested or used free of charge for 30 days after installation. After that, the extension can only be used with a valid license.

Note

Changes as of Version xx.1.4.0 The licensing of a NAVAX extension is only necessary in the production environment. In the sandbox environment, NAVAX extensions can be tested unlimited.

Request License

The license can be requested or checked via the Current Status action (in older versions What's New?). This opens a window. The following example shows the NAVAX extension Excel Report Builder. Fill in the fields in the window and then click Send License Request. Please note that the licensing process may take some time. In the next few days you will receive an email with further information.

Note

For licensing, calling the online help and performing some actions, access to https://www.navax.app must be allowed.

Public IP from www.navax.app for setting firewall access:
94.136.22.236, Port: TCP/443

Checking the connection to https://www.navax.app using PS:
Test-NetConnection navax.app -port 443
(PS must be performed with the M-Tier service user)

Activate/Update License

As soon as the licensing has been completed, you will receive an email and the license can be activated via the Update License action. The license is company independent. So it does not matter in which company the action is called.

Note

  • The licence must be updated once a year via the Update License action.
  • The update is only possible or necessary within the last 30 days before the license expires, or afterwards. Within the last 30 days before the license expires, notes are displayed.
  • If the Automatic License Renewal is enabled, the Update License action is called automatically before the license expires. Note that the setting is only active after the license has been activated via the action.

Terms & Conditions

For more information, see https://www.navax.app/EULA.php?L=en

Data Security

For more information, see https://www.navax.app/privacyStatement.php?L=en

Submit Rating

This action can be used to open the Microsoft AppSource ratings page for the extension. We would be very happy if you submit your rating and let us know about your experience with the Extension.

Docs  /  NCRC Recurring Contracts  /  Appendix
Installation Notes

Publish and Install the Extension


All necessary steps are described here:
[Microsoft Learn] Business Central - Publishing and Installing an Extension

Dependencies

  • NAVAX Extension Base

    ID: 2f4cb42d-6e2a-4708-a5e2-3ec5f32f20e9 For more information, see [Docs] NAVAX Extension Base - General
  • NCDT Document Text Base

    ID: 2f97a39f-60f1-45d1-8bb2-7497bee60684

On-Premises

The following Granules are required for an On-Premises installation:
  • 70714830 NCRC Recurring Contracts by NAVAX
  • 1010860 Extension Base by NAVAX
  • 70714775 NCDT Document Text by NAVAX

External Addresses

  • https://www.navax.app

    For licensing, calling the online help and performing some actions, access to https://www.navax.app must be allowed.

    Public IP from www.navax.app for setting firewall access:
    94.136.22.236, Port: TCP/443

    Checking the connection to https://www.navax.app using PS:
    Test-NetConnection navax.app -port 443
    (PS must be performed with the M-Tier service user)

Docs  /  NCRC Recurring Contracts  /  Appendix
Release Notes

Would you like to know what has changed in the extension?
Below you'll find an overview of the new features and changes made in the updates.

Version 21.1.1.1

as of Business Central 21
2024/04/10
  • Modifications

    • Power BI Factboxes that are no longer supported have been replaced.

Version 21.1.1.0

as of Business Central 21
2023/10/27
  • Modifications

    • Changed the caption of Quota and Bill At Cost for language code EN to Prepayment and Consumption Based.
  • Corrections

    • When extending a contract line then payment plan was created incorretly.

Version 21.1.0.0

as of Business Central 21
2023/10/16
  • Initial Version

  Print manual  
DE|EN Imprint