Dynamics Community Forum Thread Details

Table Import for EFT

Has anyone successfully done a table import for Vendor EFT data. I see the primary table for this information is SY06000 are there any supporting tables that also need populated?

Please advise. Look forward to a reply.

Categories:

Microsoft Dynamics GP

Hey JGarcia,

Did you have a moment to review the response on the previous forum for this same question?

Import Vendor EFT information (dynamics.com)

The table import process built into GP will do this without the need for a customization. I assume you already have your Excel file ready to go and the only part left would be to link the fields in Excel to the fields in SQL.

This is a very easy process.

Sample file. Random values to demonstrate.

The Table Import in GP. (Tools | Integrate | Table Import)

Enter a Definition Name. It is just a name to hold what you select when you save.
Choose a description.
Choose your source file Format.
Choose your Source File.
Destination – Choose the Address Electronic Funds Transfer Master under the Company Series.

Next, you map each source to your column in Excel to the column in SQL.

Click Save once everything is defined so it is saved
Click Import to import the data.
You will get a popup saying if anything failed or was successful.

Looking at the tables to verify it imported.

This is likely your best approach without the need to purchase customizations or additional products to import this info.

I hope this helps!

Brandon
Microsoft Dynamics 365 Implementation & Support | Cloud ERP Consultant (enavate.com)

Quick Links