Sage 100

 View Only

  • 1.  Temp Field for PM Labor Import to Auto Fill Zeroes

    Posted 05-10-2023 15:02

    Version 2022, PU2 - For a PM labor import, the step is one of the fields which is 6 characters.  The steps can range from being 6 zeroes up to 2 pre-ceding zeroes.  I know the import file can be formatted using Custom, General and then typing in 6 zeroes.  If the csv file is opened, the formatting is lost and has to be done again.  Is there a formula I can put on a temp field to figure out how many zeroes to auto fill?  Temp1 would be a replace to the step column, Temp2 would then be the calculation on Temp1 and the Step would then use the Temp2.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------


  • 2.  RE: Temp Field for PM Labor Import to Auto Fill Zeroes

    Posted 05-10-2023 16:44

    Mid("000000"+Temp1,-1,6)



    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------



  • 3.  RE: Temp Field for PM Labor Import to Auto Fill Zeroes

    Posted 05-11-2023 01:26

    Thanks @Eric Lunceford , I tried that and received the below.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


  • 4.  RE: Temp Field for PM Labor Import to Auto Fill Zeroes

    Posted 05-11-2023 06:56

    Michele, 

    Try using the formula below it will add leading zeros to make the string a total of 6 characters. Is that what you are looking for?

    PAD(Temp001$,6,0,"0")




    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------

    Original Message


  • 5.  RE: Temp Field for PM Labor Import to Auto Fill Zeroes

    Posted 05-11-2023 14:00

    Thanks @David Overholt , that worked!  Thanks @Eric Lunceford



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


  • 6.  RE: Temp Field for PM Labor Import to Auto Fill Zeroes

    Posted 05-11-2023 09:13
    Edited by Eric Lunceford 05-11-2023 09:13

    You took my syntax literally. The temp1 was a placeholder. Needs to be the correct temp field name you imported to. 

    David did a better job of giving you exactly what you need. 



    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------

    Original Message


Related Content