I am creating an IM and have only added 1 source. When I right-click on the source name to preview it, I get the error message "ADO field is nothing." Would love some advice...
When you look at your integration, are any fields defined? Look at the query and see if any columns were detected from your data source.
Richard E. Wheeler 2013 MVP
MS Dynamics GP Support
www.rbsolutions.com Revered Business Solutions Ballston Lake, NY 518-877-0763 x10
No, no columns were detected although there are columns in the file
Then there is your problem. What is the data source? Text File, csv, excel or SQL? You need to get the data source in a formnat that IM can read. If can attach a sample file I would be glad to take a look at it.
It is a text file (.txt). How do I attach the file. It only has 4 lines in it because I wanted to test it first..
Click on Use Rich Formatting and there is an Attach Image Link. I believe that will allow you to attach it. Is this file tab or comma delimited or is it fixed width length?
tab delimited..8132.leasepymt.txt
I corrected two issues with this file.
1) The first two lines were blank they were removed
2) The file name was 8132.leasepym.txt I changed it to 8132leasepym.txt by removing the first period(.). I think this confused IM as to what the file type was. Once I did this the field names appeared.