Want to import data into EFT Bank Maintenance Screen (Table SY06000)
Brandon asked 7 years ago
Hello,
To start, I am extremely new to smartconnect, still learning it in fact.
We are using Microsoft GP 2015.
I have a sql table that contains customer information that I am importing from into the receivables group and customers node type.
What I would like to do is also import the customers bank information, which I believe would go into the EFT maintenance table.
I am not seeing a group for that in smartconnect. Could I be missing it?
If anyone has any advice, I would be very appreciative.
Thank you!
To start, I am extremely new to smartconnect, still learning it in fact.
We are using Microsoft GP 2015.
I have a sql table that contains customer information that I am importing from into the receivables group and customers node type.
What I would like to do is also import the customers bank information, which I believe would go into the EFT maintenance table.
I am not seeing a group for that in smartconnect. Could I be missing it?
If anyone has any advice, I would be very appreciative.
Thank you!
Answers
Mark Anderson Staff answered 7 years ago
At this time eConnect from Dynamics GP does not have a node to update this table, and this is why you are not seeing this within SmartConnect. Until Dynamics GP adds this node, you have 2 options. The first option is to use Node Builder from eOne to build a node to update this table. Node builder allows you to build the business logic needed to validate the data. The other option, which is not recommended, you can import directly into the SQL table.