Sage 100

 View Only

  • 1.  Importing into TimeTracker (would also have applied to TimeCard)

    Posted 05-29-2025 10:53

    There is a SeqNo on each record in TimeTracker. If I were manually entering, it would start over with 0 on each new employee for a particular date. When I'm importing, I can't figure out a way to trigger it to reset on each employee (while using the Increment function).  Is there a way, or do you have to end up doing some calculation in the background?



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------


  • 2.  RE: Importing into TimeTracker (would also have applied to TimeCard)

    Posted 05-30-2025 09:25

    I've used a separate Sequence # column in Excel (1, 2, 3) which resets (in Excel) when the employee # changes.



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



  • 3.  RE: Importing into TimeTracker (would also have applied to TimeCard)

    Posted 05-30-2025 09:29

    Yeah, I was hoping to be able to do it within the import without their having to mess with the export each week.



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------

    Original Message


  • 4.  RE: Importing into TimeTracker (would also have applied to TimeCard)

    Posted 05-31-2025 13:24

    I'm guessing a Script or something inside the import job could help to automate the Seq #'s.



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

    Original Message


Related Content