Hi Experts,
I want a query to use it for FMS to change the posting date of a "Delivery" (ODLN) based on the posting date of an "AR Reserve Invoice" (OINV) linked by a field in DLN1 called "Base Ref." $[$38.44.0] = OINV."DocNum".
However, if the u...
Hey Lothar,This is the query I wrote:Select Distinct(OINV."DocDate") from ODLNInner Join DLN1 On ODLN."DocEntry" = DLN1."DocEntry"Inner Join OINV on OINV."DocNum" = $[$38.44.0]but it doesn't take into consideration if $[$38.44.0] is the same for all ...
