where to look for relationship between posted invoices and payments. “Cust. Ledger Entry” has “Applies-to Doc. No.” but one invoice can be paid with different payments and one payment can affect several invoices. Therefore it’s many-to-many relationship. I can not find what table holds the information about those relations. Is there any way to order some MS SQL-tool to tell me the relations between the tables?
Annar, Why don’t you use Navision Toolkit?
where to get one?
Well, If you are not from a solution center, ask your solution center. If you work with SQL you can use SQL itself to look at relations or an external tool, there are many possibilities. John
Annar, the application issue is a difficult topic and depends a lot on the Navision version you are working with. In fact, it is a 1 to n relationship, because either one of the applied entries must finally have a remaining amount of 0. This information is saved in the same Cust. Ledg. Entry table…look through the field “Closed by…” in T21 and have a look at the code in Form 61, OnOpenForm on how to obtain all “applied” entries for a particular entry. Saludos Nils