PM Transactions w/ Large Number of Distributions
Phil asked 5 years ago
I’m going to lead with an apology here for botching lots of accounting terminology on this thread — it’s not my space.
I’m working on a SmartConnect integration to import employee expense reports and have been struggling to understand how to handle a variable number of distributions per document. When I choose the “PM Transactions with Distributions” node type for my destination, I’m given up to 4 distributions to map, but what if the expense report needs 5 or 6 or any number of distributions? I know I can add more manually, but is there some sort of looping mechanism that I could take advantage of or am I misunderstanding something more fundamental than that?
Thanks.
Phil
I’m working on a SmartConnect integration to import employee expense reports and have been struggling to understand how to handle a variable number of distributions per document. When I choose the “PM Transactions with Distributions” node type for my destination, I’m given up to 4 distributions to map, but what if the expense report needs 5 or 6 or any number of distributions? I know I can add more manually, but is there some sort of looping mechanism that I could take advantage of or am I misunderstanding something more fundamental than that?
Thanks.
Phil
Answers
Best Answer
Ethan Sorenson Staff answered 5 years ago
Phil replied 5 years ago
Ethan Sorenson Staff answered 5 years ago
Phil,
SmartConnect uses the grouping to determine which header the distributions are assigned to. What you will want to do is set your key field to VendorID and group your header by VendorID. You do NOT want to group on the distribution mapping.
Here is a link to some sample maps so you can see what a working map would look like.
Sample Maps
SmartConnect uses the grouping to determine which header the distributions are assigned to. What you will want to do is set your key field to VendorID and group your header by VendorID. You do NOT want to group on the distribution mapping.
Here is a link to some sample maps so you can see what a working map would look like.
Sample Maps
Phil replied 5 years ago Perfect, very helpful. I was thinking about this all wrong.
Phil answered 5 years ago
I suppose it would be helpful to provide a sample source document of what I’m trying to import so that someone can tell me if I’m headed in the complete wrong direction.
Batch ID
VendorID
DocumentDate
ExpenseDate
ExpenseAmount
DistributionAccount
Description
Reimbursable
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/27/2018
10
100-6230-000
Isobel’s iPhones
yes
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/27/2018
2.45
100-6350-000
Snuffleupagus’ Staplers
yes
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/19/2018
13.46
100-6350-000
Perry’s Pens & Pencils
yes
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/11/2018
8.12
100-6330-000
Ivy’s Ice Creams
no
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/8/2018
8.88
100-6220-000
Tyrone’s Tire Repair
yes
Upon integration, I’m hoping to create one invoice for PHILI001 which a distribution for each row listed as a separate distribution.
Batch ID
VendorID
DocumentDate
ExpenseDate
ExpenseAmount
DistributionAccount
Description
Reimbursable
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/27/2018
10
100-6230-000
Isobel’s iPhones
yes
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/27/2018
2.45
100-6350-000
Snuffleupagus’ Staplers
yes
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/19/2018
13.46
100-6350-000
Perry’s Pens & Pencils
yes
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/11/2018
8.12
100-6330-000
Ivy’s Ice Creams
no
ExpenseReport-PHILI001-06272018
PHILI001
6/27/2018
6/8/2018
8.88
100-6220-000
Tyrone’s Tire Repair
yes
Upon integration, I’m hoping to create one invoice for PHILI001 which a distribution for each row listed as a separate distribution.