Sage 100

 View Only
  • 1.  I have a VI job importing into GL_GeneralJournalHe

    Posted 07-29-2013 14:42
    I have a VI job importing into GL_GeneralJournalHeader and have 1 conditional expression using an AND function and 1 using an IOR function. Both of these previously used only 2 qualifying critierion. However, now I need to add a 3rd, but the AND and IOR functions do not seem to like the additional criterion as I am getting a syntax error. Any suggestions on better functions to use? I think maybe IN would work to replace the AND statement, but still unsure on what to use in place of IOR? Any suggestions are welcome. Thanks,


  • 2.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-29-2013 15:03
    Shawn, post the statement so we can take a gander at them.


  • 3.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-30-2013 08:07
      |   view attached
    Jeff, here are the current statements: IOR(Temp004$=""1114-"" ,Temp004$=""2380-"") and AND(Temp004$<>""1114-"",Temp004$<>""2380-"") I simply need to add the same criteria to each of these for account 1113. I am also attaching the VI job for your review.

    Attachment(s)

    EXP
    OME_IMPORT.EXP   90 KB 1 version


  • 4.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-30-2013 08:18
    What version?


  • 5.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-30-2013 08:24
    Version 4.50


  • 6.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-30-2013 08:41
    How about: Temp004$=""1114-"" or Temp004$=""2380-"" Temp004$<>""1114-"" and Temp004$<>""2380-


  • 7.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-30-2013 10:58
    That worked. Thanks Therese, I guess I was trying to make it too difficult :)


  • 8.  RE: I have a VI job importing into GL_GeneralJournalHe

    Posted 07-31-2013 05:49
    That was my thought, why not keep it simple? Glad it worked!