Import Bank Statements in AX2012 R2 which have multiple accounts details

This question is not answered

Hi,

   I'm uploading a Bank statement of format BAI2 which contains information for several accounts for the same bank.

The file has trans for 2 accounts. I can load up the files successfully from the both accounts but it what does is that in the 2 accounts it creates 2 'statement'. So in the end I have 4 statements instead of 2.

I would expect that if I imported the file from Account 'A' it would only import the transactions in under the 03 section of the file for account 'A' and ignore the transitions in the other 03 section for Account 'B' and creates one bank statement.

I would expect that if I imported the file from Account 'B' it would only import the transactions in under the 03 section of the file for account 'B' and ignore the transitions in the other 03 section for Account 'A' and creates one bank statement.

if any one has an ideal how this can be done or if even AX supports it (BAI2 does) that would be great.

Below are is a sample of the file that I'm uploading

01,WELLS Fargo,Companyname,130902,1116,1,,,2/

02,Companyname,WELLS Fargo,1,130829,,,2/

03,Account_A,USD,010,+692434,,,015,+684434,,/

16,475,8000,,Check Paid 621 ,,/

49,8000,3/

03,Account_B,USD,010,+104196478,,,015,+24305777,,/

16,175,8000,,Deposit  ,,/

16,495,79898701,,some sample transaction text,,/

49,79906701,4/

98,79914701,2,9/

99,79914701,1,11/

Thanks,

Seamus

All Replies
  • AX does not do that. There is no validation built in the system to look up. Although 1 thing which you could do is modify the logic to reject any bank statement that is not having the same account number as per the setup in AX. Or, you need to divide the bank statements for each bank, that is you need to have 2 separate files.

  • Hi Seamus,

    AX doesn't support this functionality. If your BAI2 file has multiple bank accounts then AX will import them all for the company/bank account you are currently logged in. You will need to generate one BAI2 file per legal entity/bank account.

  • Can you please tell me the exact settings you have top to bottom to get this to work? We can't get it to work on AX 2012 R2.  Please tell me what you have in the Inbound Port Service Operations, Inbound Transforms, Manage Transformations (did you edit any of the formats that you 'loaded'?), Cash > Setup > Bank Rec > Bank Statement Format Screen, GL setup screen for imports.  Thanks.

    Rachel Carney

    Tekhausen

    550 North Reo Street, Ste 300

    Tampa, FL 33609

     

    (Office) 866-898-8811

    Skype: Rachel.Carney

    rcarney@tekhausen.com