get Vendor or Customer Location Name based on LogisticsLocationRoleType

tmpSnapShot

info(strFmt("%1",DirPartyPostalAddressView::find(CustTable::find('C00003').Party,
DirParty::findPostalAddressByRole(CustTable::find('C00003').Party,LogisticsLocationRoleType::FakturPajak).Location).LocationName));
Advertisements

Default Dimension

select c.NAME,a.DISPLAYVALUE from DIMENSIONATTRIBUTEVALUESETITEM a
INNER JOIN DIMENSIONATTRIBUTEVALUE b on a.DIMENSIONATTRIBUTEVALUE = b.RECID
INNER JOIN DIMENSIONATTRIBUTE c on b.DIMENSIONATTRIBUTE = c.RECID
where a.DIMENSIONATTRIBUTEVALUESET= <DEFAULT DIMENSION RECID>