Sage 100

 View Only

  • 1.  Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 12:01

    Does anyone know why this VI formula  SUB(Temp008$,"|",$0d$)  for replacing pipes ( | ) with a carriage return isn't working on the S/O Entry line comment field, even though it works fine for item extended description?  Is it maybe cause of the type of field?  It's weird, it's actually putting like a hidden space instead.  Not sure if $0A$ is needed which is mentioned in a kb article for doing this for a udf, but it was no-go when I tried.  It also appears the carriage return is present when printing the sales order, but not on-screen in Lines.  Am I running into a carriage return / line feed thing here?



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------


  • 2.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 12:06
    Edited by Kevin Moyes 03-29-2023 12:07

    I ran into that a couple years ago.  Here are my notes from then:

    For future reference:

      • It should be chr(13)+chr(10)
        • Sub(Temp001$,"^",chr(13)+chr(10))
      • ^ works just fine
      • ~ does not work for this method.
      • | cannot just be typed into a formula / temp field's default value because it corrupts the VI job maintenance interface, but you can set a temp field calculation to chr(124) and do the | substitution that way.
        • Sub(Temp001$,Temp002$,chr(13)+chr(10))



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 12:17
    Edited by Brett Zimmerman 03-29-2023 13:50

    Looks like I now have it working:  SUB(Temp008$,"|",$0d$+$0A$)

    Thanks, @Kevin Moyes



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 4.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 13:50

    Looks like I now have it working:  SUB(Temp008$,"|",$0d$+$0A$)

    Thanks, @Kevin Moyes.  I saw your info just after, but still helpful.  Similar concept it appears.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 5.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 13:59
    Edited by Brett Zimmerman 03-29-2023 16:27



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 6.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 14:01

    Hmm, having some trouble with missing text in my posts.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 7.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 14:04

    Oh, it's the pipe in the formula that causes the VI interface to get messed up?  i.e. field is diff than what was clicked into, missing info, etc. @Kevin Moyes 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 8.  RE: Importing carriage return into S/O Entry line comment field

    Posted 03-29-2023 14:43

    It seems so, since I've seen that in more than one place (within grid displays).  I'm guessing that Sage programming may use pipe as a separator in memory, meaning that character as data messes things up.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


Related Content