web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Electronic Reconcile D...
Microsoft Dynamics GP (Archived)

Electronic Reconcile Download error: There are 68 unprocessed records on one ore more unrecognized fields from the text file read.

(0) ShareShare
ReportReport
Posted on by Napolo 766

I have setup the electronic reconcile format configurator with "Comma Delimited" file type. The file when opened in notepad looks good.  The actual file is saved as CSV.

I have tried various settings. I checked the record delimiter and entered "," in the box, I removed the check box.  I have tried using the Tab Delimited file type.

Column A = D for detail

I have mapped each field and made sure that the transaction code and record type are both added to field type.

cs-error.png

Without giving too much detail, here is a sample of the row errors.

detail-error.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Nicole,

    I've never used the Electronic Bank Reconcile module in GP, but I'm wondering about the format.. doesn't the bank send a file with some header information ? you seem to only have a detail section defined..

    Would you mind to post the format of your definition here ? (you can use the export option to save the format as a TXT file).. or send it to me by e-mail .

    Thanks,

  • Suggested answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at

    Hi Nicole

    A number of things.  Your detail record only shows 1 field. It should match the number of fields that you have data in.

    Second, the Record type Identifier field position should have the field number where you have the record type identifier record in.

    It looks to me like you have 11 detail fields with the Record type identifier in field position 1.

  • Napolo Profile Picture
    Napolo 766 on at

    Thank for the reply Jeffrey,

    # of fields looks like one in the image, but it is 13. That field appears cut off until it is clicked.

    Yes, I have 13 detail records and my record type code = "D", is in field 1.

  • Napolo Profile Picture
    Napolo 766 on at

    Thank for the reply Beat BUCHER,

    Yes, I only have detail. It is an export from the online bank portal.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Nicole,

    Could you post another screen capture of the upper portion of your record defintion ? we can't see the type of field right now from the "configurator" tool..

    My suspicion is that the Type error comes from the value 'D' that GP might eventually look for a numeric value.. not an alpha char..

  • Napolo Profile Picture
    Napolo 766 on at

    Is this what your needing?

    7823.file.png

    Here is a better snapshot of the export from the bank. It is in csv (comma delimited) file type.

    7823.file.png

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Thank you.

    When looking at the user guide / help file for the Electronic Banking  reconcile, what strikes me is the codes.. :

    The following is an example list showing a file containing two groups and multiple accounts within a group:

    Record Code

    Record Name

    Purpose

    01

    File Header

    Begins file

    02

    Group Header

    Begins group 1

    03

    Account Identifier

    Begins first account

    16

    Transaction Detail

    First account detail

    49

    Account Footer

    End of first account

    03

    Account Identifier

    Begins second account

    49

    Account Footer

    End of second account

    98

    Group Footer

    End of group 1

    02

    Group Header

    Begins group 2

    03

    Account Identifier

    Begins third account

    88

    Continuation

    Continues previous 03 record

    49

    Account Footer

    End of third account

    98

    Group Footer

    End of group 2

    99

    File Footer

    End of file

    For each record type, you will define the number of fields in the record type, the field type, and field format according to your bank specifications.


    The samples from the guide are all numeric values, which might not mean anything, but I'm still inclined to say that a numeric value in your first column may resolve the problem.. (unless confirmed by Microsoft that this doesn't need to be the case).. 

    I'd give it a try and replace the 'D' by 16..

     

  • Napolo Profile Picture
    Napolo 766 on at

    Replaced D with 16 and the error is the same. It just picks up the 16 in place of the D.

  • Napolo Profile Picture
    Napolo 766 on at

    I tried this too:

    Some bank formats don’t explicitly require a record type code; however, Electronic Reconcile does. If your bank doesn’t define a record type code, select a field in the file format that has a fixed value (account number, for example) and enter that value as a text string in the Record Type Code field.

    I replaced column 1 with the account number. Received same error.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    OK..

    At this point, can you send me the format as a TXT file ? I would like to test this out in my GP 2018 setup (I don't have the Electronic Bank Management in a 2013 TEST node setup)..

    and also the sample CSV file to run the import process..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans