Re: Bank Transaction Integration Error
Hi Francisco
I do have 2 source file (header & detail) and I am using column INDEX, JR# and Date to define a link b/w the two files and the relationship is also based on these 3 keys. As I mentioned before my upload only fails when I try to add the Dr side of transaction into the file as you know that the system always picks the DR side of the entry from the account that is linked to the Checkbook. My transaction is a little bit different than usual as the amount to be distributed to the Checkbook is let say 5000 AED then when distributing the amount I am distributing more than the checkbook amount as you can in the example below where I have 5000 AED as checkbook amount but I am distributing 6000 AED, the 2 other debit entries are for some charges so I need to account them but not to the checkbook account.
I have tested this entry and it works fine if I enter it through the Bank Transactions Screen but it fails to upload when I try to upload it through Integration and gives the error.
INDEX Journal Option Type Date ACC Debit Credit Dist Ref CHECKBOOK Amount
1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-02-05240 5000.00 0.00 Test HSBC-001 5000.00
1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-14-62980 500.00 0.00 Test HSBC-001 5000.00
1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-28-88060 500.00 0.00 Test HSBC-001 5000.00
1 RCP0051 Enter Receipt Cash 07/06/2011 151-19-00-28-88020 0.00 2500.00 Test HSBC-001 5000.00
1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-02-05245 0.00 1000.00 Test HSBC-001 5000.00
1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-14-62615 0.00 1500.00 Test HSBC-001 5000.00
1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-14-62100 0.00 1000.00 Test HSBC-001 5000.00
Share
Report
All responses (
Answers (
291,269
