ColinR
Jun 29th 2004, 7:28 am
We have "Scotiabank" for our Bank Debits and while doing a batch run where 90% of our PAP customer base is being debited, the file that it exports out too the total $ amounts it includes a decimal in it, when it shouldn't. As an example it shows 000001234.56 when it should be 00000123456
For the "Z Record" in export it is position 39 - 46 if that helps.
It only appears to happen when a huge batch is being exported. Previously I imported into MSAccess to get the amount and edit the txt file then send to bank but as our business is growing, its becoming more of a pain in the a$$.
Thanks for your help in this matter.
PS - Attaching a thread to jog your memory
http://www.digitalpoint.com/lists/73472.html (http://)
For the "Z Record" in export it is position 39 - 46 if that helps.
It only appears to happen when a huge batch is being exported. Previously I imported into MSAccess to get the amount and edit the txt file then send to bank but as our business is growing, its becoming more of a pain in the a$$.
Thanks for your help in this matter.
PS - Attaching a thread to jog your memory
http://www.digitalpoint.com/lists/73472.html (http://)