Sample BAI file for Microsoft Dynamics GP

Symptoms
Sample BAI file for Microsoft Dynamics GP
Cause
.
Resolution
1.  FILE SETUP:  Copy the below date in-between the lines below into Notepad, and save the file as a .csv file to your desktop or another location where you can find it.   FYI --The same data in the file is:

date = May 30, 2016 (notice needs to be 160530. the format is YYMMDD, so don't drop leading zeroes on the month or day, which is why you should work in Notepad and not Excel, as the auto-formatting in Excel drops leading zeroes.)
Bank account = 80808080
Two checks #456 and #789 for $100.00 each
The first two digits of each line is the standard code for each line type to tell the system what type of line it is.
------------------------------------------------
01,,,,,,,,
02,,,,160530,,,
03,80808080,,,,,,
16,475,10000,,160530,,,456,
16,475,10000,,160530,,,789,
9,,
98,,,
99,20000,,2
------------------------------------------------

2.  CHECKBOOK SETUP:  Then in GP, go to Cards | Financial | Checkbook, and select the checkbook you want to use.

     a. Put the Bank Account number'80808080' in the BANK ACCOUNT field, or else put your actual bank account number in and then update it in the third line of the sample file above, so it matches.  This is how it finds the checkbook to use.   (This bank account can only be on ONE checkbook.)

     b. In the BANK ID field, enter a Bank ID of your choice, such as 'BAI'.  (Click to ADD it when prompted.)  

     c. Save and close the checkbook.


3. CONFIGURATOR SETUP.  Go to Tools | Routines | Financial | Electronic Reconcile | Configurator.

    a.  Enter a Bank format name and description of your choice, such as 'BAI'.

    b.  For FILE FORMAT, select 'BAI' and the fields will default.

    c.  Unmark the 'RECORD DELIMITER' checkbox.

    d.  Click on the CODES ENTRY button in the button right.

         I.  Select CHECK PAID and click Save to cache the default codes under this category.

         II.  Also select DEPOSITS REC'D and click Save to cache it.   Close the window.

    e.  Click SAVE.



4.  DOWNLOAD SETUP:  Go to Tools | Routines | Financial | Electronic Reconcile | Download Maintenance.

     a. Enter a BANK DOWNLOAD IS  of whatever you want, such as 'BAI'.

     b. Select the 'BAI' bank format that you created.

     c. Select the 'BAI' bank ID that you saved on the checkbook.

         I. Click ADD CHECKBOOK and select the checkbook ID you worked with in #2 above.

     d.  In the Download Filename and path, browse out to the bai.scv file you saved on your desktop in #1. 

     e.  Save.



5.  DOWNLOAD TRX:  To download the file, go to Tools | Routines | Financial | Electronic Reconcile | Transactions Download.

     a.  Select the 'BAI' download ID.

     b.  Click DOWNLOAD button at the top.

     c.  For a confirmation number, enter '123' and click SUCCESSFUL.  Hopefully both checks rom the file populate in.

     d.  Click OK at the top to close the window.


6.  CLEAR.  To do this again, go to Tools | Routines | Financial | Electronic Reconcile | Summary History, and select your download ID, and click DELETE ALL at the top, and click DELETE when prompted.  Now you can bring in the file again.


More information
For more troubleshooting tips for Electronic Reconcile, bringing in bai files, and the matching process refer to the following: 

2872105 Steps to modify the BAI file format in Electronic Reconcile in Microsoft Dynamics GP
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2872105

850751 Setup information for Electronic Reconcile Format Configurator
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;850751

851279 How Transactions are Matched in Electronic Reconcile for Microsoft Dynamics GP
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;851279



Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 3168165 - Last Review: 06/02/2016 23:12:00 - Revision: 4.0

Microsoft Dynamics GP 2016, Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2013

  • kbmbsmigrate kbsurveynew KB3168165
Feedback