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?
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.
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.
987
Share
Report
All responses (
Answers (
