First of all make sure no one posted anything into this account without your knowledge. People do stuff in the system. Next check to ensure the external transaction code 040 (opening balance) is configured properly with correct sign. Also, the file below looks like a prior day file but may I ask which bank is sending this BAI file? Dammah
| | | ---------------Original Message--------------- From: USER_2312264 Sent: Monday, January 24, 2011 4:52 PM Subject: Electronic Bank Statement - Incorrect Opening Balance We are loading a BAI2 file with the following: 01,XXXX,YYYY,110120,0516,001,80,1,2/ 02,YYYY,XXXX,1,110119,,CAD,/ 03,06900365934,CAD,040,+0000022379229,,,045,+0000055479754,,/ 88,100,000000053629590,00552,V,110119,,400,0000000 00372199,00003,V,110119,/ This is the first time we are loading a bank statement for this House Bank. It is set to NOT post in FF.5. I am expecting the opening balance to reflect the $223,792.29 that's in the file itself. Again, this is the FIRST bank statement ever uploaded for this bank. When displaying the loaded bank statement however, we are getting an opening balance of $-532,573.91. I cannot figure out why it's calculating this value instead of using what's in the file directly. Any ideas? Thanks in advance! | |