Sage 100

 View Only

  • 1.  VI import bringing in numeric fields as integer values instead of decimal values beyond the decimal point

    Posted 01-28-2021 13:56
    Importing numeric UDF data into PR_Employee (v2020.1/PR 2.21). Fields represent Vacation & Sick Available,. Data in source file goes out to 2 decimal places. Data is importing integer values. What do I need to do to bring in the decimal values?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: VI import bringing in numeric fields as integer values instead of decimal values beyond the decimal point

    Posted 01-28-2021 15:46
    Hi @Barbara Goldstein I don't see anything wrong with what you have.  Have you tried importing as a Temp, then Calculate the UDF as the Temp field?​

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 3.  RE: VI import bringing in numeric fields as integer values instead of decimal values beyond the decimal point

    Posted 01-28-2021 15:49
    Are you sure the UDF mask isn't set to no decimals?

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



  • 4.  RE: VI import bringing in numeric fields as integer values instead of decimal values beyond the decimal point

    Posted 01-28-2021 18:48
    The UDFs were converted from legacy PR.  When I do manual data entry in new system, it rounds to integer value.  Do I need to change the mask?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 5.  RE: VI import bringing in numeric fields as integer values instead of decimal values beyond the decimal point

    Posted 01-28-2021 19:00
    Fixed.  I added another field to the UDF table and updated.  Data imports properly now.  Thanks Michelle and Kevin!​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 6.  RE: VI import bringing in numeric fields as integer values instead of decimal values beyond the decimal point

    Posted 01-29-2021 08:59
    Edited by Bruce Kern 01-29-2021 09:07


Related Content