Sage 100

 View Only
  • 1.  I'm working on an Access application to pre-proces

    Posted 01-07-2014 12:46
      |   view attached
    I'm working on an Access application to pre-process data for import into Sage 100 Premium, version 2013. I found a document on the web with instructions for calling VI from a command line. The first part of the command is to reference the PVXWIN32.EXE file. In a note on the document, it states to user the path that corresponds to the Server Install rather than the client install for Advanced (MAS 200). I'm assuming this is the same for Premium as well. Thoughts? Warnings? I attached the document just in case.


  • 2.  RE: I'm working on an Access application to pre-proces

    Posted 01-08-2014 07:46
    That sounds accurate that the PVXWIN32.EXE should correspond to ther server install. I believe you need to set the working directory to the ..\MAS90\HOME directory first, then do the command line for the import.


  • 3.  RE: I'm working on an Access application to pre-proces

    Posted 01-08-2014 08:01
    Thanks for the confirmation William. I am going to run a test today from a batch file to make sure it works before putting it into the Access routine.


  • 4.  RE: I'm working on an Access application to pre-proces

    Posted 01-21-2014 15:26
      |   view attached
    I finally found the source of my troubles. I didn't set up an app for running a VI job through the Application Server. I have attached a copy of a word doc with the important pieces from a knowledgebase article. This is specific to the Advanced and Premium editions only. Also note that the command line syntax has additional arguments required.

    Attachment(s)

    docx
    VI_Setup.docx   14 KB 1 version


  • 5.  RE: I'm working on an Access application to pre-proces

    Posted 01-24-2014 10:35
    Interesting. I didn't know about this. Thanks for sharing!