Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Visual Integrator Rounding?

  • 1.  Visual Integrator Rounding?

    Posted 09-08-2021 18:12
    Is anyone aware of a function to round to the nearest whole number in Visual Integrator?  PRC doesn't get the job done.  Thanks in advance!

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------


  • 2.  RE: Visual Integrator Rounding?

    Posted 09-08-2021 18:30
    What is the formula you are using?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Visual Integrator Rounding?

    Posted 09-08-2021 18:49
    PRC(temp field) returns the exact same number with decimals.  INT(temp) rounds DOWN (example, 74.90 becomes 74.00).

    I want to round to the nearest whole number:  74.49 would become 74.00; 74.50 would become 75.00.
    ​​

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------

    Original Message


  • 4.  RE: Visual Integrator Rounding?

    Posted 09-08-2021 19:01
    Try:
    PRC(TempField,0)



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

    Original Message


  • 5.  RE: Visual Integrator Rounding?

    Posted 09-08-2021 20:01
      |   view attached
    In case anyone wants a PVX manual.  14 years old, not sure if there is a newer one.  Maybe someone could post if there is.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Attachment(s)

    pdf
    PVXLanguage.pdf   7.41 MB 1 version
    Original Message


  • 6.  RE: Visual Integrator Rounding?

    Posted 09-09-2021 08:15
    @Kevin Moyes thank you, that works perfectly!  @Jeff Schwenk thank you for this little gem!​​

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------

    Original Message


  • 7.  RE: Visual Integrator Rounding?

    Posted 09-09-2021 10:41
    Thanks, @Jeff Schwenk, the one I had was v7 (16 years old), lol.​

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

    Original Message


  • 8.  RE: Visual Integrator Rounding?

    Posted 09-09-2021 13:40

    The most recent one I have as a download is also from 2007

    But you can get the latest one here (I don't think this requires any sort of login).

     

    https://manual.pvxplus.com/

     

     

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     




    Original Message


  • 9.  RE: Visual Integrator Rounding?

    Posted 09-10-2021 07:33
    @David Overholt - Is this manual downloadable?  Not seeing a download button.​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 10.  RE: Visual Integrator Rounding?

    Posted 09-10-2021 08:48

    Not that I've been able to find. I wanted to download it myself to have handy, but haven't seen a way to do that. I just added the link to my favorites. 

     

     

     

    Thanks

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     




    Original Message


  • 11.  RE: Visual Integrator Rounding?

    Posted 09-10-2021 10:07
    Gotcha!  I guess PDF's are so last decade......

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content