Finance | Project Operations, Human Resources, ...

Bad fields displayed in Relationships window of GJ Adapter

(0) Share

Report

Posted on by mikepeck

356

I created a General Journal Integration with two source files; the Header and the line details

When I review the Query Relationships, there are several fields showing as 'NOT FOUND'

All of the fields in the Source File are listed, these are in addition.

Where do these fields come from, and how can I remove them from my Integration Query?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Bad fields displayed in Relationships window of GJ Adapter

Hi Michael,

Not sure how you linked the sources in IM, but I'd simply check the properties of each source and make sure the columns are the ones that are really in the file. In doubt, click on the "Refresh Columns" and make sure you checked only the ones that matter to each source (header or detail).

Then go into the Query RelationShips and delete the 2 sources, re-add them and link by the proper field(s).

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Bad fields displayed in Relationships window of GJ Adapter

Hi Michael,

Not sure how you linked the sources in IM, but I'd simply check the properties of each source and make sure the columns are the ones that are really in the file. In doubt, click on the "Refresh Columns" and make sure you checked only the ones that matter to each source (header or detail).

Then go into the Query RelationShips and delete the 2 sources, re-add them and link by the proper field(s).

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Bad fields displayed in Relationships window of GJ Adapter

Hi Michael,

Not sure how you linked the sources in IM, but I'd simply check the properties of each source and make sure the columns are the ones that are really in the file. In doubt, click on the "Refresh Columns" and make sure you checked only the ones that matter to each source (header or detail).

Then go into the Query RelationShips and delete the 2 sources, re-add them and link by the proper field(s).

Was this reply helpful? Yes No
mikepeck 356 on at

Like (0)

Report

RE: Bad fields displayed in Relationships window of GJ Adapter

I am using Integration Manager. The NOT FOUND fields shown in the Query Relationship window shown above, do not appear in my source file. I have no idea where they are coming from. I don't see any way to remove them so i can complete the integration.

If you have any ideas concerning what I may have done to introduce these fields, and how to remove them, I would appreciate the help.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Bad fields displayed in Relationships window of GJ Adapter

Hi Michael,

Are you doing this in Intergration Manager ? the fields are linked in the Relationship part in IM... that's the only place I'd see to make corrections.

Was this reply helpful? Yes No