Importing bank transactions with Integration manager - multiple distributions

(0) Share

Report

Posted on by Community Member

I am importing a bank file with Increase and Decrease adjustments into Bank Transaction. Everything works fine as long as there is a single offset. If I try to do an IAJ that has more than one account to credit I get the "not fully distributed message" Any ideas?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

DinB 3,951 on at

Like (0)

Report

In the Integration Manager, right click each file under "Sources" and Preview the data for Header and Line. See if the amounts are balanced.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you - they are. Everything is fine with the integration if running with a single offset, but when trying to do a multiple it doesn't do it. There is a "number" field which is a sequential number and that is what is linking my two files. The one with the multiple transactions has the same number multiple times so as to link it to the header.

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Have you set your source of data to RecordSource for the distributions?

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you - that was it! Despite having mapped it to the correct source, I didn't click on the Options to confirm. THANKS@!!!

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

It is important, when you have multiple distributions, per adjustment, that you create your Integration Manager sources correctly. You need to create a file/query, which shows an instance for each of the multiple distributions, which apply to any adjustment/document. Then you must link the distributions query using query relationships feature so you can see the multiple distributions when you right click on the source and select Preview. Here is a screen shot of what you should see.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Would you please explain how did you upload banking to Integration Manager?

What I usually do, enter each transaction separately to GP until, I came up with idea that I can upload all banking transactions using Integration Manager as if I'm processing transaction in GP by going to Financial- General in one batch. But I have no clue how to process it using the increase or decrease as a single batch.

Thank you

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

The banking module does not have batch functionality, so you could do as described above. If you have multiple distributions for a single transaction, you could do a GL batch and instead of using the Cash Account use a clearing account. Then you could do a Bank Transaction to offset the clearing account vs cash

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I appreciate your response.

I do have banking transactions involving multiple distributions, so first of all I have to come with an account to be a clearing account to offset the cash account?

I know if I entered the transaction in cash account, it wont show up when I do the bank reconciliation.

The Integration manager part I fully understand it, but the banking if you explain it more , it would be helpful.

Was this reply helpful? Yes No