Open Forum

Innovia - July 2020
Back to discussions
Expand all | Collapse all

Including hours worked in a Genl Jrnl entry

  • 1.  Including hours worked in a Genl Jrnl entry

    Posted Nov 20, 2019 09:18 PM
    Hi folks.
    We use ADP for our payroll, and we post monthly General Journal entries into NAV that are a based on a summary of our payroll costs from ADP.
    I'm trying to find a way to include hours worked in the GJ so I can analyze from data in NAV.
    Has anyone ever tried this?  Is there a throw-away field I can use that would typically be exposed and available in NAV's canned reports?
    We are running NAV 2013 R2.
    Thanks.

    ------------------------------
    Dave Woodley
    O'Neil Digital Solutions, LLC
    LOS ANGELES CA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Including hours worked in a Genl Jrnl entry

    TOP CONTRIBUTOR
    Posted Nov 21, 2019 06:55 AM
    Haven't played with them in a long time,but check out statistical accounts in G/L and post nonfinancial numbers onto them.



    Sent from my T-Mobile 4G LTE Device




    Original Message
    Academy - Online Interactive Learning from Experts


  • 3.  RE: Including hours worked in a Genl Jrnl entry

    GOLD CONTRIBUTOR
    Posted Nov 21, 2019 08:45 AM
    We also use ADP but post entries through jobs.  You can capture resource hours or GL quantities using a Job G/L Journal.  Then analyze hours and costs through a job.  However, job setup is another level of complexity to deal with.

    ------------------------------
    Patti Parrish
    Finance Project Manager
    EthosEnergy Power Plant Services
    Alpharetta, Ga
    ------------------------------

    Original Message
    Academy - Online Interactive Learning from Experts


  • 4.  RE: Including hours worked in a Genl Jrnl entry

    TOP CONTRIBUTOR
    Posted Nov 21, 2019 11:44 AM
    There is a quantity field in the general journal and the general ledger entry table. You might try populating this and make sure it posts from the journal to the ledger.

    ------------------------------
    Kim Dallefeld
    Kim@Dallefeld.com
    Dallefeld Consulting, LLC
    Member of Dynamics Consulting Group
    Ft. Worth, TX
    2019 NAVUG Board of Advisors
    Past NAVUG Board Chairman
    NAVUG Programming Committee
    ------------------------------

    Original Message
    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role