Link Relationships

[NKOS13]

Using a one is to many relationship.One Receipt number is to many invoice numbers.It is failing to give me the correct results when it gets to that .

The report is supposed to pull all GRN vs GRV so that l can see what was receipted and not invoiced.
My data is coming from Accpac tables.l'm using SQL & running.These are Accpac related reports.
Please help me .

 

[rose4567]

Please copy/paste your SQL query.

I understand the results you are expecting, but what results are you actually getting?

 

[jmd0252]

Do you have any tables, that should have everything? Such as it there always a P/O entered for the activity you are trying to look at. If so,, use the p/o file as your major file, and link everything back to it. But show us the sql statement, it helps a lot.