Show Record in ONE line joining THREE tables

Business Central/NAV Technical Forum
1

Dear Sir / Madam,

I am the fresh person to do the Microsoft NAV reporting. Please help me this question.

I am doing the AR report using the cust. ledger entry table, customer table and the salesperson purchaser table. I want to get the data from cust. ledger entry table and tyhe name in customer table and the salesperson purchaser table. The result of the report is such DUPLICATE record but the customer name in first line and the salesperson purchaser name in the second line. so what can i do.

2

Hi ,

Can you be more specific here , with an example what you want to see ?

(I couldnt open your pdf …)

g.