Skip to Content
0
Jan 05, 2023 at 12:26 PM

Landed Costs Query links

119 Views

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]

lcqest.jpg

Attachments

lcqest.jpg (56.3 kB)