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 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.
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
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
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.
Thank you - that was it! Despite having mapped it to the correct source, I didn't click on the Options to confirm. THANKS@!!!
Have you set your source of data to RecordSource for the distributions?
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.
Share
Report
All responses (
Answers (
12,931
