Get Vendor account for a LedgerJournalTrans record

(0) Share

Report

Posted on by DAX09

2,470

I am looking to get the vendor for the line items of an NPO - I don't see any reference in the LedgerJournalTrans table - and in the Invoice Journal screen - using the "Personalize" option I see that vendor is "LedgerJournalTrans(LedgerJournalTrans).LedgerDimension" - but I don't understand that - I think that might be related to the dropdown?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi

The Vendor is store on LedgerDimension field as Recid.

On LedgerJournalTrans Table, you can use the "accountDisplay" method or "accountNameFind" for the description.

Was this reply helpful? Yes No
Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report
Copy link

Link copied!

VendTable::find(DimensionStorage::ledgerDimension2AccountNum(_dimensionDynamicAccount))
_dimensionDynamicAccount is the ledgerdimension recid

Was this reply helpful? Yes No
Suggested answer

Christiaan 380 on at

Like (0)

Report
Copy link

Link copied!

Journal lines use dimension values.

To convert dimension records use the DimensionStorage Class methods. for example:

find the Vendor AccountNum corresponding to ledgerdimension (recid) = DimensionStorage::ledgerDimension2AccountNum(LedgerDimension)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

to get account number for vendor or customer or etc use LedgerJournalTrans.accountDisply().

1 people found this reply helpful.

Was this reply helpful? Yes No