A salesorder integration between a webshop with different storeviews and a accounting system.
The accounting software expects a offset account for the revenue on the customer account. The enduser wants to differentiate on the 3 variables.
- What storeview is the order coming from?
- What is the delivery country?
- Is there a VAT Number?
For this we want to know the storeview, so if the data is not empty, we want to use the field value. For example the value 1 is coming from the source
We want to know the delivery country as we have a revenue account per country for OSS purposes and we put the action on field value. Expected values are for example NL for the Netherlands or BE for Belgium.
The third value is to check if there is VATnumber in the date. If there is no value in the field we expect TRUE if there is a value we expect FALSE.
These rows create a output that looks technically like this
{value}|{value}|TRUE/FALSE
As you can see the results in the picture we want to map are for a Dutch customer from storeview 1 without a vatnumber, we want to use the revenue account 8000. 1|NL|TRUE à 8000
For a Dutch customer from storeview 1 with a vatnumber 1|NL|FALSE à 8001
As you can see the results in the picture we want to map are for a Belgian customer from storeview 1 without a vatnumber 1|BE|TRUE à 8002
For a Belgian customer from storeview 1 with a vatnumber 1|BE|FALSE à 8003