on 02-01-2023 8:32 AM
Dear Experts.
Please assist with a mapping issue.If a purchase order has a single account assignment the values are shown in source node account->segment-1 to 7 highlighted in green .(1 per purchase order line item) If a purchase order has multiple account assignments the values are shown in source account-allocations-account->segment-1 to 7. (2 or more per purchase order line item)
For the multiple account assignment test the 2nd value in account-allocation-account-segment-5 does not show in target field account.
Thank you
Hello,
create a simple solution for account & account_allocations.
Step-1 --> just create one duplicate subtree at your receiver side for "Accounts". (right click on Accounts and click duplicate subtree)
first, map with your "account" single account assignment and map your subtree with "account_allocations".
For the first account mapping do as below:
account --> exists --> create if --> Accounts
segment-5 --> mapWithDefault --> CostCentre
For the first account_allocations mapping do as below:
account_allocations --> exists --> create If --> Accounts
segment-5 --> mapWithDefault --> CostCentre
Do not use any split by value remove context here.
It will resolve your issue.
but you need to do the mapping for Accounts remaining fiedlagain for subtree.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Harish.
I had tried that but it didnt work.The display queue for the IF statement only returned 1 value.I changed the context and moved the segment 5 around and that worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vanessa,
Please add split by value before cost centre (after if else).
regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.