Importing Bank Transactions via Integration Manager with Fees on the Debit Side

(0) Share

Report

Posted on by Community Member

Hello all,

I'm new to GP, I was able to get the bank transactions to load using integration manager by removing the cash distribution line in my upload file and that worked well.

Now I have bank fees that I need to enter in on the debit side of the transaction going into different accounts. When I do that the error I get is "the transaction amount is not fully distributed".

So for amount I have 11680

my first line is a credit for 12000

then my other 2 lines are for debits in the amount of 270 and 50 respectively.

2275.Capture.JPG

*This post is locked for comments

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

RE: Importing Bank Transactions via Integration Manager with Fees on the Debit Side

Yes Heather, that's the problem.

I tried adding back the Debit line, no success, same error message.

Any help would be appreciated.

Thank you,
Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Importing Bank Transactions via Integration Manager with Fees on the Debit Side

Hi Benny

I understand the problem - I haven't tried it myself.

Because you have the bank fees in there, have you tried adding the bank account line back in with that scenario?

I will give this a go later on if you don't find a solution and see if I can make it work.

Cheers

Heather
sandipdjadhav 18,297 on at

Like (0)

Report

RE: Importing Bank Transactions via Integration Manager with Fees on the Debit Side

Your Credit =12,000 and Debit only (270+5) ?

Thats problem. Your Debit Amt should be Match with Credit.
Suggested answer

Praveen Kumar RR 1,552 on at

Like (0)

Report

RE: Importing Bank Transactions via Integration Manager with Fees on the Debit Side

Hi,

This is issue with Excel Sheet selected for Field Mapping.

I suggest you to check the default Template for this Integration to know the format that is columns and how values were distributed.

You can find under Installation Folder of Integration Manager >> IMSamples >>

Before you work on Data Preparation, make sure that you are able to enter the same transaction manually.

Thanks,

Praveen