Hi,
How can I link in sql query landed cost with AP Invoice (Service) – see attachment.
AP Invoice (Items) I can do this way but it doesn’t work with service invoice
SELECT T0.[DocNum], T0.[CardName], T0.[DocDate], T1.[DocNum] FROM OPCH T0 INNER JOIN OIPF T1 ON T0.[LndCstNum] = T1.[DocEntry]
