Relation between VendInvoiceInfoTable and VendInvoiceJour

(0) Share

Report

Posted on by Community Member

Hi All,

May I know how to link between VendInvoiceInfoTable and VendInvoiceJour? If I have VendInvoiceInfoTable record, how can I get the VendInvoiceJour record?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

UmesH@ 810 on at

Like (0)

Report
Copy link

Link copied!

May be you can Check by PostingProfile

VENDINVOICEJOUR.POSTINGPROFILE = VENDINVOICEINFOTABLE.POSTINGPROFILE

Thanks,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Jignesh,

I unable to link to VendInvoiceJour using PostingProfile. It is quite general, I need unique link. Anyway, thank you.

Anyone can help?

Thank you.

Was this reply helpful? Yes No
Suggested answer

UmesH@ 810 on at

Like (1)

Report
Copy link

Link copied!

Hi sanme,

if you want Create unique link between those two table then you can create your Own Column and linked it.

you want to add Field in That 2 tables.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

What about this relation ?

SELECT *

FROM VENDINVOICEJOUR AS vij

JOIN PURCHTABLE AS pt

ON vij.PURCHID = pt.PURCHID

JOIN VENDINVOICEINFOSUBTABLE AS viist

ON viist.ORIGPURCHID = pt.PURCHID

JOIN VENDINVOICEINFOTABLE AS viit

ON viit.PARMID = viist.PARMID and viit.TABLEREFID = viist.TABLEREFID

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Check these two methods:

\Data Dictionary\Tables\VendInvoiceInfoTable\Methods\ledgerVoucher (via source document header)

\Data Dictionary\Tables\VendInvoiceInfoTable\Methods\findFromVendInvoiceJour (via num, purchid and parmid if it came from a posting)

Was this reply helpful? Yes No