Defining Query or Ledger Criteria



  1. Begin by choosing a cell in an existing matrix layout.


    Click the B3 cell.

    Step 1
  2. Click the nVision menu.

    Step 2
  3. Click the Layout Definition... list item.

    Step 3
  4. Click the Source tab.

    Step 4
  5. Click the Type list.

    Step 5
  6. Click the Query list item.

    Step 6
  7. Click the Query Name list.

    Step 7
  8. Click the DBAG_ORD_LINE list item.

    Step 8
  9. Click the Apply button.

    Step 9
  10. You have successfully applied query criteria to a cell of the layout. You now need define criteria for another cell of the layout.


    Click the Down Arrow button.

    Step 10
  11. Click the Type list.

    Step 11
  12. Click the Ledger list item.

    Step 12
  13. Click the Ledger Name list.

    Step 13
  14. Click the Down scrollbar.

    Step 14
  15. Click the Budgets [BUDGETS] list item.

    Step 15
  16. Click the Get List button.

    Step 16
  17. Click the Posted Total Amount list item.

    Step 17
  18. Click the Lookup [?] button.

    Step 18
  19. Click the SHARE ADJALLYR-1 list item.

    Step 19
  20. Click the OK button.

    Step 20
  21. Click the Apply button.

    Step 21
  22. Click the OK button.

    Step 22

You have successfully defined query and ledger criteria for an existing matrix layout.

Table of Contents  Start Topic