News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Has anyone been succes...

Microsoft Dynamics GP (Archived)

Has anyone been successful with configurator

(0) Share

Report

Report

Posted on by george.harmon

520

I am trying to setup electronic reconcile and I am using a csv file

The file has the following column headers date, check number, description, debit, credit

The description contains various descriptions

I have several questions:

Do I need a header and detail data record type?

Do I need the account number in the file?

How are the records in the spreadsheet mapped to the configurater in GP?

the configurator tells me that account number and transaction amount are required when I try to save it.

What are the transaction codes used for?

How does the configurater know what a debit and credit us?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: Has anyone been successful with configurator

Hi George,

Seriously, you need to talk to your bank so that you understand what their codes mean. Typically a .csv or fixed length file is downloaded from the bank. It normally contains at least 1 header record per account. Following the header are detail records. These detail records are the transaction records that will be used by Bank Rec.

You need to read the section of the Electronic Banking user manual that covers Electronic Reconcile -it is only seven pages. After reading that information you will be ready to ask questions that we can best help you with.

Kind regards

Leslie

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans