Relation between tfacp200 & tdpur046
This is related to Baan IV.
we have a report requirement with following details:
Supplier Tran.type Doc.No Invoice amt Order Order amt
abc FIP 20090001 1000 100001 500
abc FIP 20090001 1000 100002 500
here, invoice FIP 2009000 is paid against two purchase orders (records from tdpur046). Is there any way to join these two tables (obviously based on ttyp and ninv) in such a way that if a matching record is not found in tdpur046, the fields from tdpur046 will be blank but the values from tfacp200 will be printed. I could not find any way to use "refers to" as there is no native relationship between these two tables. One way is I can use is as below:
tfacp200.ttyp = tdpur046.ttyp and tfacp200.ninv = tdpur046.invn
ON THE FORM FOLLOWING FIELDS WILL BE USED AS SELECTION CRITERIA:
SUPPLIER FROM - TO
PURCHASE ORDER FROM - TO
TFACP200.TTYP FROM - TO
TFACP200.NINV FROM- TO
Is there any way out to overcome this problem ?