Subscriptions
7 minute read
When you have created a Topic you proceed and create a Subscription in the company/companies receiving data from the Topic. You have to set up one Subscription for each Party you are receiving data from.
Subscription card
- Choose the 🔎 icon, enter Subscriptions (IDM), and choose the related link.
- Fill in the Party code for the sending company and choose the related Topic.
- pryme Intercompany Project only.
- Inv. Setup template the selected invoice template will be applied on all projects. If this field is empty, you must manually add the invoice template on all intercompany projects.
- Res. price template the transfer pricing list that you want to use for all projects.
- The related tables from the Topic are opened under Subscription tables. You can delete a table you don’t want to import. You can add it again, but you can never add a table that is not in the Topic.
- If you want to change the field definitions, click on Subscription fields.
Subscription Fields
Subscription fields are used for defining which fields should be imported, how the data should be processed on a field level and if there are any rules importing the field. When you import a table, you can mapp a field to change the value in it. This is only possible if the field is included in the Topic message.
If you change or mapp a field, we recommend you use the Comment field to document your changes. The field Relation Table Caption specifies the table that is related to the field. If you have values in these fields, the value you import must exist in the related table in the receiving company.
You can map a field four ways, by Value, Filter, Fixed or Currency.
| Type | Description |
|---|---|
| Value | Map a value one to one to convert from one value to another. |
| Filter | Map and update a field based on a filter setting. |
| Fixed | Map to a fixed value that will be valid for all imported transactions. |
| Currency | Local currency will be mapped to/from blank. |
Currency mapping
This mapping is used when you have different LCY in your parties. This mapping requires that the field “Currency Code” on each party is defined as well as the “LCY Code” in the General ledger setup.
- If the currency code is blank in the subscription message the Currency code on the Party code will be picked and mapped into the field.
- If the currency code in the subscription message is matching the Currency code on the Party code the currency will be mapped to blank.
Note!
When a record is received from another company from a Topic, a Subscription record is created. This record keeps track of where it came from and if it was created from another company or only updated. If the record was created in another company, local changes will not be sent to other companies. This means that if a record, e.g. a payment term, has been created outside of the IC process in several companies, the parties will not agree on who owns the record, and all changes in all companies will be transferred. In these cases, you must update the Subscription record on these records (under Related), by manually set the Data owned by party.Subscription fields in pryme Intercompany Project
In the pryme Intercompany Project app there are fields you must map to get the correct values on the projects in the receiving company.
Project
Table 167 – Job
| Target Field No | Target Field Name | Mapping value | Comment |
|---|---|---|---|
| 5 | Bill-to Customer No. | Fixed | You must always map to the sending company’s customer number in the receiving company. |
| 20 | Person Responsible | Is it the same as in the sending company? | |
| 23 | Job posting group | Is it the same as in the sending company? | |
| 1011 | Invoice currency code | Currency | If you have an intercompany transfer pricing list in another currency than your LCY, always change the Mapping value to Currency. Read more about Currency mapping here. |
| 2000 | Sell-to Customer No. | Fixed | If you don’t have the customer table as Master data, you must map to the sending company’s customer number in the receiving company. |
| 14045651 | Resource Invoice type | Value | If the selling company have fixed price agreement with the customer, and the performing company need to maintain regular intercompany billings, you must mapp this field to T&M |
| 14045655 | Item Invoice type | Value | If the selling company have fixed price agreement with the customer, and the performing company need to maintain regular intercompany billings, you must mapp this field to T&M |
| 14045656 | Expense Invoice type | Value | If the selling company have fixed price agreement with the customer, and the performing company need to maintain regular intercompany billings, you must mapp this field to T&M |
| 14045674 | Project Managerx PGS | Is it the same resource as in the sending company? | |
| 14045753 | Time sheet currency code | Currency | If you have an intercompany transfer pricing list in another currency than your LCY, always change the Mapping value to Currency. Read more about Currency mapping here. |
Table 1001 – Job task
| Target Field No | Target Field Name | Mapping value | Comment |
|---|---|---|---|
| 14045764 | Contract Type PGS | Value | If the selling company have fixed price agreement with the customer, and the performing company need to maintain regular intercompany billings, you must map this field to T&M |
| 14045709 | Project Manager PGS | Is it the same resource as in the sending company? |
Table 14045676 - Permissions PM
This table is not mandatory to transfer. If you don’t need the permissions from the sending company, you can delete the table.
| Target Field No | Target Field Name | Mapping value | Comment |
|---|---|---|---|
| 1 | No | Is it the same resources as in the sending company? |
Time
Table 156 – Resource
| Target Field No | Target Field Name | Mapping value | Comment |
|---|---|---|---|
| 51 | Gen Prod Posting Grp | Is it the same as in the sending company? | |
| 58 | VAT Prod Posting Grp | Is it the same as in the sending company? |
Note!
Cost price is not a part of the Intercompany Project app. You have two options:
- Enter the cost price manually on the external resources in the receiving company.
- Find a way to automate this, e.g. by using the Resource Group / Resource Subgroup. Create a specific Resource Group / Resource Subgroup for IC resources and add your transfer pricing rates for resource costs. Don’t forget to map the IC resources to the group/subgroup.
Project ledger entries
This is a preview feature that transfer resource, expenses and item ledgers between companies. It is to be tested in a Sandbox environment. Please contact support if you want to use it in a production environment.
Table 210 – Job jounal line
| Target Field No | Target Field Name | Mapping value | Comment |
|---|---|---|---|
| 1008 | Currency code | Currency | Read more about Currency mapping here. |
| 14045810 | Expense Payment Type | Value | Mapp the expense payment types you have in the sending company to the one you created for Intercompay purpose. |
Test the setup
When you have created a topic and the corresponding subscription, try to send one entry in the sending company. In the receiving company you can run the subscription manually from the action Run subscription. When everything is working, you can set up a job queue that runs the subscription automatically.
Read more about setting up job queues here.
Update a Subscription after changing the Topic
If you have changed the field definitions on the Topic you must manually update the Subscription.
- Choose the 🔎 icon, enter Subscriptions (IDM), and choose the related link.
- Go to Update Source fields on the Action tab.
- Open the Subscription card.
- Click on Subscription fields on the table you want to update.
- Go to the field you want to add.
- In Source field No you add the Table No (same number as in Target field No).