Today’s #TipTuesday post is yet another integration-related post. In my case, it’s about Payables Transaction Entry and distributions doubling up. This tip will (or should) also hold true for other eConnect nodes that have optional GL distributions as most behave in the same default manner I describe below.
I was building a Payables Transaction integration for the first time in a long time. In my case, I am passing in GL distributions so I was mapping both the “PM Transaction Insert” node as well as the “PM Distributions” node. All was going super smoothly and the integration was a success, until I looked at the resulting transaction!
Double distribution amounts
My GL distributions were duplicated and yet there was no error message in eConnect (SmartConnect in my case). Hmm. I double checked my source data, and there was no summing of my fields on grouping so it took me a second to realize what the issue was.
Here’s my payables entry (one example): a $250 document.
Here is the distribution for this entry: $500 debits and credits.
What the heck did I do?
The default mapping on the eConnect node in PM Transaction Insert is to default in the GL distributions. This is on the line “Create Distributions” and the value that is defaulting, if you do not explicitly map otherwise, is a 1 (which means “auto-create GL distributions” using the default posting accounts). However, my SmartConnect mapping looked like this: it wasn’t mapped.
By leaving it unmapped, my integration passed through my PM Distributions AND auto-created the distributions resulting in double the amounts. Here is what I should have done on the PM Transaction Insert node: map it with a 0, indicating “do not create distributions”.
Once I did that, the GL distributions matched perfectly what I was passing in and all was good!