Sage 100

 View Only
  • 1.  v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-10-2014 11:02
    v2014 pu3.. Setting up a VI import to Sales Order header. trying to get the System date to import to the order date field. Anyone know the correct syntax? See error message attached.


  • 2.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-10-2014 11:07
    If you just leave the file off the import it will use that date, won't it?


  • 3.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-10-2014 11:26
    Never occurred to me to try that. Thank you!


  • 4.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-10-2014 11:36
    oper = calc: day [Legacy: SYS(date)]


  • 5.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-10-2014 11:40
    Tried that one Brett. It doesn't work in 2014. I'm actually upgrading from 3.71 to 2014 and recreating a VI job. The SYS(date) is what is used in my 3.71 VI job.


  • 6.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-10-2014 11:42
    Oh, interesting. Thanks for letting me know.


  • 7.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-11-2014 07:09
    Did you get this figured out? If not, try {DAY}


  • 8.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-11-2014 07:21
    @MichelleBennion (DAY) works! thank you. is there a list of VI commands somewhere?


  • 9.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-11-2014 08:02
      |   view attached
    I use the attached for such references.

    Attachment(s)

    pdf
    PVXLanguage.pdf   7.41 MB 1 version


  • 10.  RE: v2014 pu3.. Setting up a VI import to Sales Order

    Posted 12-11-2014 08:06
    Thanks @MarkKotyla For some reason it didn't occur to me that all VI is is a front end to creating a ProvideX program. In fact several years ago I remember modifying the PVX code created by import master to overcome feature deficiencies.