Skip to Content
0
Jan 06, 2023 at 10:26 AM

Landed Cost AP service invoice

40 Views

Hi experts

When open on landed cost relationship map you can see (attachment):

Invoice (Goods), Landed cost and Invoice (Transport).

Can anyone help me to build simple query please:

T0.[DocNum] (Invoice transport), T1.[DocNum] (landed cost)

Query below returns only Invoice (Goods) but not Invoice (Transport)

SELECT T0.[DocNum], T1.[DocNum] FROM OPCH T0 INNER JOIN OIPF T1 ON T0.[LndCstNum] = T1.[DocEntry]

On relationship map link exist but I cannot find way to link it in query

lcqest.jpg

lcqest.jpg

Attachments

lcqest.jpg (56.3 kB)
lcqest.jpg (56.3 kB)