ERP005-Exploring Visual total vital forms-Research Base course

Part 1- User System / User Parameters / Menus / Reports – 6 Sessions

1.Unpack User Management Form

  • User’s Specification & Image Browser
  • User ID & Password Definition Form
  • User Company & Year Path Definition Form
  • User ID CARDS Reporter
  • In-class Group Presentation 1- Paper 1

2.Unpack User Access Definition Form

  • Hierarchical User Access Tree Object
  • Recursively On/Off Access Tree Branch
  • Save User Access to Other Company &Year
  • Load User Access From Other Company &Year
  • Save Current Access For Equal Users
  • Load Default Accesses
  • In-Class Group Presentation 2- Paper2

3.Unpack User Parameters Form

  • Multi Pages Parameters
  • Show One Page at The Time
  • Load & Save Parameters
  • Hidden User Conditions/Filters
  • In-Class Presentation 3- Paper3

4.Unpack System Parameters Form

  • Formset-Base Menu Call Panel
  • Child Forms/Parameter Pages
  • Page frame of Parameter Pages
  • Load & Save Parameters
  • Load Default Parameters
  • Parameter Loader From Other Company &Year
  • In-Class Presentation 4- Paper4

5.Unpack Menu System & Access Controls

  • Main menu with large Icons
  • Submenus, Pagefrmaes, Container Class
  • PopUp Menu with Access Control
  • Right-Click PopUp Menu
  • In-class Group Presentation 5- Paper 5

6.Unpack Account-Journal Complex Report

  • Account Journal Browser Functionality
  • Physical/Logical Order A Journal Report
  • Report Selective/in-range Journals
  • Number-to-Letter Function’s Algorithm
  • Design Journal Account Structure
  • Preview & Print Report of Journals J1- J2
  • In-class Group Presentation 6- Paper 6

Part 2- User Define Query & Report Generators (Ordering, Grouping, Save, Load) – 6 Sessions

7.Unpack CITY Base-Table Query Gen1

  • Data Environment: Tables & Relations
  • VT FL(Field list Array)/ Cells Arrangement
  • VT SEA_CELL CLASS: Property Setting
  • VT REPORT1CLASS: Property Setting
  • In-class Group Presentation 7- Paper 7

8.Unpack CITY Base-Table Query Gen 2

  • VT SEARCH Form’s Methods
  • Create SEA_CITY Form, City/State Q.Gen
  • VT SEARCH Form’s Functionality
  • Make 10 User Define Queries/Logical Operators
  • Save & Load VT User Define Queries
  • Order User Define Query/Multiple KEYs
  • In-Class Group Presentation 8- Paper8

9.Unpack CITY Base-Table Query Gen 3

  • Browse Selective Fields
  • VT Search Reserved Reports
  • Sum & Grouping Search Reports
  • Create User Search Reports
  • In-Class Presentation 9- Paper9

10.Unpack Complex SEA Forms

  • Create SEA_CUSTOMER/ 80 cells
  • Get SEARCH KEY from Base-Tables
  • Create A CUSTOMER Report/10 Columns
  • Create SEA_CHKP/Account Payable
  • Customizing SEA Reports
  • AP Monthly/Weekly SEA Report
  • In-Class Presentation 10- Paper10

11.Unpack Cyclic Parent/Child Relations

  • SET SKIP TO Command/1:1,1:n Relation
  • SEA_amv Parent/Childs Relation Manager
  • User Change Parent/Childs/1:1/1:n in SEA
  • Create 10 Cyclic Queries & Analyze Results
  • In-class Group Presentation 11- Paper 11

12.Usage of SEA/Filters in VTOTAL Browsers/Viewers

  • 10 Query in Account Journal Browser
  • Unpack SEA/Filter Programming in Viewer
  • 10 Query in Buy/Sell Invoice Viewer
  • 10 Query in Return of Buy/Sell Invoice Viewer
  • 10 Query in Account Receivable Viewer
  • SEA/Filter Programming in FORMSET Viewer
  • In-class Group Presentation 12- Paper 12