To show Caption "Shortcut Dimension 1 Code" Filter in Report

manikandan
manikandan Member Posts: 160
edited 2011-05-27 in NAV Three Tier
Hi Everybody,

Is it possible to show the caption class of "Shortcut Dimension 1 Code" Field when applying filter in reports Instead of Printing "Shortcut Dimension 1 Code" Field Name :?:

Comments

  • ufuk
    ufuk Member Posts: 514
    I think you're getting filters by GETFILTERS and I don't think you can easily do this with an out-of-box solution. If it worths maybe you can loop through fields and get filter and caption of field for each filtered field.
    Ufuk Asci
    Pargesoft
  • manikandan
    manikandan Member Posts: 160
    Hi ufuk,
    Thanks for your replay.
    But not getting result when using GETFILTER and FIELDCAPTION.
    ie,In General Ledger Setup "Shortcut Dimension 1 Code" is BRANCH
    but in "Purch. Inv. Header" table Field Name is "Shortcut Dimension 1 Code".
    Is it Possible to show Caption of "Shortcut Dimension 1 Code" when Filtering in the Reports using "Purch. Inv. Header" Table Using GETFILTERS Function . ](*,)
  • ufuk
    ufuk Member Posts: 514
    For normal fields you can use captions but for dims you can go to G/L Setup and get dim names. But as I said before you can't do this with GETFILTERS. You have to code.
    Ufuk Asci
    Pargesoft
  • manikandan
    manikandan Member Posts: 160
    Hi ufuk,
    Thanks for your reply. :D

Categories