Setting up virtual field translation for flexible service codes and related table connection

For the retrieval of values in the required format, you must define translations for flexible service codes in M3 Business Engine. You must install and enable this feature in ‘Feature List. Open’ (CMS975). See NCR 11746 – Ad hoc reporting - Virtual field for data translation.
  1. Open ‘Ad Hoc Report Group. Open’ (AHS100).
  2. Specify AR_SIRE in the Ad hoc rept grp field and click Enter.
  3. Highlight AR_SIRE and select Related > Virtual Fields (CTRL+21).
    ‘Virtual Fields. Connect’ (CMS012/B) opens.
  4. Specify &RESE in the V fld field and click Create.
    Panel E opens.
  5. From the Message ID field, select the SRRESE field and click Next.
    The description and the name are automatically populated.
  6. From the Type field, select 11-Translate Business Message Data and click Next.
    ‘Business Message Data. Translate’ (CRS882/B1) opens.
  7. Click Close.
    'Virtual Fields. Connect' (CMS012/B) reopens.
  8. Verify that &RESE is displayed. Click Close.
    ‘Ad Hoc Report Group. Open’ (AHS100/B) reopens.
  9. Highlight AR_SIRE and select Related > Related Tables (CTRL+20).
    ‘Related Tables. Connect’ (CMS011/B1) opens.
  10. Specify MBMTRN in the Table field and TR in the Pfx field.
  11. Click Create.
    Panel E opens.
  12. Click Next.
  13. Specify this information and verify that the sorting option is 00:
    Key field Read option Value
    TRTRQF 1-Equal to 0
    TRMSTD 1-Equal to ADHOC
    TRMVRS 1-Equal to 1
    TRBMSG 1-Equal to AR_SIRE
    TRIBOB 1-Equal to O
    TRELMP 1-Equal to &RESE
    TRELMD 2-Blank value
    TRELMC 2-Blank value
    TRMBMC 2-Blank value
  14. Click Next.
    ‘Related Tables. Connect’ (CMS011/B1) reopens.
  15. Clear the Table and Pfx fields.
  16. Specify MBMTRD in the Table field and TD in the Pfx field.
  17. Click Create.
    Panel E opens.
  18. Specify 1 in the Sequence no field.
  19. Click Next.
  20. Specify this information and verify that the sorting option is 00:
    Key field Read option Value
    TDCONO 1-Equal to SRCONO
    TDDIVI 1-Equal to SRDIVI
    TDIDTR 1-Equal to TRIDTR
    TDMVXP 2-Blank value
    TDEXTP 2-Blank value
    TDMVXD 1-Equal to SRRESE
    TDMBMD 3-First record
  21. Click Next.
    ‘Related Tables. Connect’ (CMS011/B1) reopens.
  22. Click Close.
    ‘Ad Hoc Report Group. Open’ (AHS100/B) reopens.