Setup a Subscription

Learn how to setup Subscriptions, used for receiving data from other Business Central companies.

9 minute read

After setting up the Topic, create a Subscription for each Party that should pull data from the Topic.

Watch our video how to setup a Subscription.

Masterdata

The subscriptions are setup a bit different depending on if the companies are in the same environment or not.

Same environment

Select the 🔎 icon, enter Subscriptions (IDM), and select the related link.
Select New to create a new Subscription.
General fast tab:
Party code – Select the code for the sending company.
Topic – Select the Topic.
Subscription Tables
The tables that are included in the Topic message.
Use Subscription Fields to modify field-level data processing, mapping, and rules.

Multiple environments using Azure Service Bus

Run the Topic in the sending company.
Go to the receiving company.
Select the 🔎 icon, enter Subscriptions (IDM), and select the related link.
Enter the Party code for the sending company and select the related Topic.
Run the Subscription.
Add the tables under Subscription Tables.
Use Subscription Fields to modify field-level data processing, mapping, and rules.

Subscription tables

When the Subscription header is filled in, the tables from the Topic are automatically populated in the Subscription tables. It’s possible to delete a table you don’t want to import.

Subscription Fields

Subscription fields is the definition of which fields are imported, and it controls how the data is processed. Note that you can’t add a filed in the Subscription that doesn’t exist in the Topic. Some of the most important fields are as follows:

Field	Comment
Target field No./Name	The number and name of the field that should be updated in your company. It’s not always one-to-one with the Source No/Name in the Topic. The fields are colour coded: Green – The field is imported, no action needed. Red – The field is imported, an action is needed (check the comment field). Black – The field is not imported.
Source field No./Name	The number and name of the table in the sending company.
Include field	This field is selected if the field is included when running the subscription. This value can be changed.
Skip validation	If this field is selected, the data will not be validated. This means that any data can be imported, even if the field has a related table.
Mapping type	When importing a table, it’s possible to change a value in a field on an entry using the Mapping functionality. Mapping must be done if the values in the sending and receiving company are not the same. You can map a field four different ways: Value – One-to-one mapping. Filter – Conditional updates based on filters. Fixed – Assigns a fixed value to all imported transactions. Currency – Manages local currency conversions. Read more about currencies.
Has mapping	If you have selected a Mapping type, you must add the Mapping parameters. Click on Yes/No to update the parameters.
Value	From value -> To value Add one or several one-to-one mappings. This is useful if you want to update the project managers to different values.
Filter	Conditional updates based on filters.
Fixed	Assigns a fixed value on all imported entries. Useful when you map the Bill-to customer to the sending company’s customer number in your company.
Currency	No mapping needs to be done.
Comment	When changing or mapping a field, add a comment to document the changes.

Templates

Only available in Pryme Intercompany for Projects

The subscriptions are setup a bit different depending on if the companies are in the same environment or not. The Subscription looks the same and the example below shows the Project template.

Same environment

Select the 🔎 icon, enter Subscriptions (IDM), and select the related link.
Select New to create a new Subscription.
General fast tab
Party code – Select the code for the sending company.
Topic – Select the Topic.
Options fast tab (only visible for the Project template):
Inv. Setup Template – Select if you want to add an invoice template when creating the project.
Res. price Template – Select if you want to add a pricing list when creating the project.
Subscription Tables.
The tables that are included in the Topic message.
Use Subscription Fields to modify field-level data processing, mapping, and rules.

Multiple environment using Azure Service Bus

Run the Topic in the sending company.
Go to the receiving company.
Select the 🔎 icon, enter Subscriptions (IDM), and select the related link.
Enter the Party code for the sending company and select the related Topic.
Run the Subscription.
Options fast tab (only visible for the Project template):
Inv. Setup template – Defines if you want to add an invoice template on intercompany projects.
Res. price template - Defines if you want to add a pricing list on intercompany projects
Add the tables under Subscription Tables.
Use Subscription Fields to modify field-level data processing, mapping, and rules.

Subscription tables

When the Subscription header is filled in, the tables from the Topic are automatically populated in the Subscription tables. It’s possible to delete a table you don’t want to import.

Subscription Fields

Subscription fields is the definition of which fields are imported, and it controls how the data is processed. Note that you can’t add a filed in the Subscription that doesn’t exist in the Topic.

Some of the most important fields are as follows:

Field	Comment
Target field No./Name	The number and name of the field that should be updated in your company. It’s not always one-to-one with the Source No/Name in the Topic. The fields are colour coded: Green – The field is imported, no action needed. Red – The field is imported, an action is needed (check the comment field). Black – The field is not imported.
Source field No./Name	The number and name of the table in the sending company.
Include field	This field is selected if the field is included when running the subscription. This value can be changed.
Skip validation	If this field is selected, the data will not be validated. This means that any data can be imported, even if the field has a related table.
Mapping type	When importing a table, it’s possible to change a value in a field on an entry using the Mapping functionality. Mapping must be done if the values in the sending and receiving company are not the same. You can map a field four different ways: Value – One-to-one mapping. Filter – Conditional updates based on filters. Fixed – Assigns a fixed value to all imported transactions. Currency – Manages local currency conversions. Read more about currencies.
Has mapping	If you have selected a Mapping type, you must add the Mapping parameters. Click on Yes/No to update the parameters.
Value	From value -> To value Add one or several one-to-one mappings. This is useful if you want to update the project managers to different values.
Filter	Conditional updates based on filters.
Fixed	Assigns a fixed value on all imported entries. Useful when you map the Bill-to customer to the sending company’s customer number in your company.
Currency	No mapping needs to be done.
Comment	When changing or mapping a field, add a comment to document the changes.

Note!

If the companies have different LCY, open the Subscription table and add the fields Invoice currency code and Time sheet currency code. Note that the fields must be added in the Topic first.

Review and update table definitions

In Pryme Intercompany Project templates there are fields that needs to be mapped project to ensure correct values in the receiving company’s projects.

Project (Table 167 – Job)

Target Field No	Target Field Name	Mapping Value	Comment
5	Bill-to Customer No.	Fixed	Always map to the sending company’s customer number in the receiving company.
20	Person Responsible		Verify if it matches the sending company.
23	Job Posting Group		Verify if it matches the sending company.
1011	Invoice Currency Code	Currency	Use Currency if the companies have different local currencies. Read more about currencies.
2000	Sell-to Customer No.	Fixed	If the customer table is not part of master data, map to the sending company’s customer number.
14045651	Resource Invoice Type	Value	If there is a fixed price agreement with the end-customer, but the intercompany agreement is not fixed price you should map to T&M.
14045655	Item Invoice Type	Value	If there is a fixed price agreement with the end-customer, but the intercompany agreement is not fixed price you should map to T&M.
14045656	Expense Invoice Type	Value	If there is a fixed price agreement with the end-customer, but the intercompany agreement is not fixed price you should map to T&M.
14045674	Project Manager PGS		Verify if the resource matches the sending company.
14045753	Timesheet Currency Code	Currency	Use Currency if the companies have different local currencies. Read more about currencies.

Job Task (Table 1001 – Job Task)

Target Field No	Target Field Name	Mapping Value	Comment
14045764	Contract Type PGS	Value	If there is a fixed price agreement with the end-customer, but the intercompany agreement is not fixed price you should map to T&M.
14045709	Project Manager PGS		Verify if the resource matches the sending company.

Permissions (Table 14045676 - Permissions PM)

This table is not mandatory. If permission from the sending company is unnecessary, delete the table.

Target Field No	Target Field Name	Mapping Value	Comment
1	No		Verify if the resource matches the sending company.

Time (Table 156 – Resource)

Target Field No	Target Field Name	Mapping Value	Comment
51	Gen Prod Posting Grp		Verify if it matches the sending company.
58	VAT Prod Posting Grp		Verify if it matches the sending company.

Note!

Pryme intercompany project does not include cost price as part of its default setup. Handle cost prices using one of the following approaches:

Manually input the cost price for external resources in the receiving company.
Automate using resource group / resource subgroup. Create a dedicated group/subgroup for IC resources and add transfer pricing rates. Map IC resources to the designated group/subgroup.

Job Journal Line (Table 210)

Target Field No	Target Field Name	Mapping Value	Comment
1008	Currency Code	Currency	See Currency Mapping.
14045810	Expense Payment Type	Value	Map expense payment types for intercompany transactions.

Test the Setup

After creating the topic and corresponding subscription, test the setup:

Send one entry from the sending company.
Run the subscription manually in the receiving company using Run Subscription.
When successful, configure a Job Queue for automated subscription processing.

For details on job queue setup, see Set Up Job Queues.

Update a Subscription After Changing the Topic

If changes are made to the Topic field definitions, update the subscription manually:

Select the 🔎 icon, enter Subscriptions (IDM), and select the related link.
Choose the Update Source Fields action under the Actions action group.
Open the Subscription Card.
Select Subscription Fields under Subscription Tables tab.
Locate the field to add.
In Source Field No, add the Table No (same as Target Field No).

Update Subscription Fields after changing the target table

If field is added to or removed from target table listed under Subscription Tables, you can update the Subscription Fields manually.

Select the 🔎 icon, enter Subscriptions (IDM), and select the related link.
Select the subscription which subscription fields you want to update.
Choose the Update Subscription Fields action.
Open the Subscription Card.
Select Subscription Fields under Subscription Tables tab.
Field is added to or removed from Subscription Fields based on whether it was added to or removed from related target table.