Relation between VendInvoiceInfoTable and VendInvoiceJour

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (5)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Relation between VendInvoiceInfoTable and VendInvoiceJour

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)
Community Member Microsoft Employee on at

Like (0)

Report

RE: Relation between VendInvoiceInfoTable and VendInvoiceJour

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
Suggested answer

UmesH@ 810 on at

Like (1)

Report

RE: Relation between VendInvoiceInfoTable and VendInvoiceJour

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Relation between VendInvoiceInfoTable and VendInvoiceJour

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.
UmesH@ 810 on at

Like (0)

Report

RE: Relation between VendInvoiceInfoTable and VendInvoiceJour

May be you can Check by PostingProfile

VENDINVOICEJOUR.POSTINGPROFILE = VENDINVOICEINFOTABLE.POSTINGPROFILE

Thanks,