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 ID
Description 2
Quantity
C.23-000019_10000
additional description
1
The Contract ID consists of Contract number_line number
additional import-specific description
quantity 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.
