On cash payment journal we have custom report users print for approval before posting the journal and on that report there is cost center code displayed and the approving party needed to see the cost center name instead of the cost center code and the journal line only contained the cost center code.And thought of getting this solved with my limited CAL skill i need help.
Thanks in advace
The dimension value table contains all the codes and names for all dimensions. So you need to lookup the name in this table with something like DimensionValue.GET(CostCenterDimCode,CostCenterDimValue);
Erik's suggestion is the correct way to do this, ... but.If youa re not confident writing C/AL code then a simpler option is to just add a flow field to the source table where the dimension code is currently. The flow filed would be type LOOKUP pointing tot he dimension table description. This way you don't need to write any code.