Sage 100

 View Only

  • 1.  Question is it possible to put a variable like sys

    Posted 04-30-2015 06:48
    Question is it possible to put a variable like system date on the records tab of a VI job? The client is on Sage 100 ERP 2014. I am having problems find any documentation to support if and what would be allowed. I thought I would put it out here to experience the magic of 90minds.


  • 2.  RE: Question is it possible to put a variable like sys

    Posted 04-30-2015 07:08
    I think you create temp variable with calculated and simply type DAY in the calculation


  • 3.  RE: Question is it possible to put a variable like sys

    Posted 04-30-2015 07:28
      |   view attached
    screen shot: I haven't tested the results but I did not get any syntax errors setting this up


  • 4.  RE: Question is it possible to put a variable like sys

    Posted 04-30-2015 07:44
    some addt'l info: https://90minds-com.socialcast.com/messages/22734383?ref=stream https://90minds-com.socialcast.com/messages/23377346?ref=stream


  • 5.  RE: Question is it possible to put a variable like sys

    Posted 04-30-2015 10:14
    Great! Thank you all. Now that I have the variable I will see if I can set a skip record on the record tab to DAY -30. I want to import all records where the due date is in the next 90 days. The source file has many more records than I want to import AND it has not been imported previously...


Related Content