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
Copy link

Link copied!

Are there any relations from paymentTransTable and DirPartyTable?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

then which partynumber i shuld pass in find method

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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