Sage 100

 View Only
  • 1.  Possible to VI into Memo Manager Maintenance?

    Posted 08-26-2019 11:06
    I've seen that importing to customer memo maintenance is possible with  VI.

    Is it possible to import to Memo Manager Maintenance which controls the behavior of memos by company/module/role?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Possible to VI into Memo Manager Maintenance?

    Posted 09-04-2019 14:47
    Edited by David Speck II 09-04-2019 14:48
    Not by default.

    I was able to get the table to appear in the VI import table selection but unfortunately, the import kept failing every attempted import claiming the ModuleCode is required.

    Turns out, the SY_MemoManager_Bus expects to be launched from one of the known modules that memos can exist under, i.e. A/P, A/R, S/O, etc and because launching the VI job causing the module to be set to V/I, this would prevent the records from being written.

    So it requires some perform logic on the Execution and Completion events.

    Below are the steps I used to get the table to be available to select in the VI Import table selection.
    File > Run > SYZCON > DD, locate the "GL_CompanyMemoManagerSettings" table, click "Custom Info", you should see the the row for "Business Object" is blank.
    If you enter "SY_MemoManager_Bus" as seen below and update the file.
     

    Then VI Import will let you select the table.

    Here is the perform logic overview.


    Completion:
    coSession'SetProgram(StartTask) ! '
    Execution:
    StartTask=coSession'StartTask; coSession'DropObject(coBusiness); coSession'SetProgram(coSession'LookupTask("SY_MemoManager_UI")); coBusiness=coSession'GetObject("SY_MemoManager_Bus") ! '


    The perform logic is just saving the existing task id to a variable and then dropping the current coBusiness object handle that was created under the VI module. 
    It then gets a new object handle for coBusiness after setting the start program to the SY_MemoManager_UI.



    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: Possible to VI into Memo Manager Maintenance?

    Posted 09-04-2019 15:49
    Nice job! Thanks!!

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------