how to get store name with store number from DirPartyTable

(0) Share

Report

Posted on by Community Member

Hi All,

i want to get store number and store name together in one field,

i used concatenation and find method for store name . code is below

salesRemittanceTemp. Store = paymentTransTable.store+'-'+ DirPartyTable::find(paymentTransTable.store, boolean::true, DirPartyType::LegalEntity).Name;

but it's not get the name from DirPartyTable... any one can suggest me ?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Fredrik Sætre 12,644 on at

Like (1)

Report

Are there any relations from paymentTransTable and DirPartyTable?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

then which partynumber i shuld pass in find method

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (1)

Report

Hi Safdar,

Please try salesRemittanceTemp. Store = strFmt("%1-%2", retailStoreTable.StoreNumber, retailStoreTable.name());

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Hi Safdar Ali,

Find the DirpartyTable relation to PaymentTransTable, try doing with the relations.

Suresh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen,

thank you , i resolve it by using this code:

salesRemittanceTemp. Store = paymentTransTable.store +'-'+ DirPartyTable::findRec(retailChannelTable.OMOperatingUnitID).Name;

Was this reply helpful? Yes No