Hi Im trying to create a report in Axapta 3 that joins the InventTrans table with the CustPickingListTrans table. The only way I can see to identify unique records is to join on the InventTransId fields and InventTrans.InventDate == CustPickingListTrans.PickingListDate
The only problem is it doesnt appear to work! Is Axapta unable to join on fields that have a data datatype?? I have checked which datatype the fields are extending and they both extend TransDate.