Finance | Project Operations, Human Resources, ...

Is there a direct relation between PurchLine to VendInvoiceTrans?

(0) Share

Report

Posted on by xppdev

122

Hello everyone,

Is there a way to connect each PurchLine to VendInvoiceTrans individually? Checking it in the backend relation shows that it does not have any relation. The only available field in VendInvoiceTrans is the Purchase ID which you can use to refer to the Purchase Order Header itself. VendInvoiceJour is also another table that could be a possible relation between each line but that table only has a connection on PurchTable.

Please suggest if there are workaround for this table relation.

Thank you

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi,

There is no direct relation defined. But you can try using InventTransId to link both the tables. InventTransId is a unique key in PurchLine and it gets set in VendInvoiceTrans table in initFromPurchLine method.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi xppdev,

What is your business case?

Like it is mentioned you can use InventTransId and OrigPurchId from VendInvoiceTrans as relation to PurchLine table.

Was this reply helpful? Yes No