When I perform joins between the ORCT (Incoming Payments) and RCT1 (Checks) tables, which of the following conditions should I use:
ORCT.DocEntry = RCT1.DocNum
ORCT.DocNum = RCT1.DocNum
If you add the tables ORCT and RCT1 in the Query Generator it automatically adds the second one, DocNum = DocNum.
However, ORCT.DocEntry is the primary key of ORCT and it is the same as ORCT.DocNum in the cases I've tested.
The reason I ask is that in the marketing documents, you always use OQUT.DocEntry = QUT1.DocEntry which both happen to be the primary keys of their respective tables.