Open Forum

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
------------------------------

Original Message------

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
------------------------------

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:
Sent: Nov 20, 2019 09:17 PM
From: Dave Woodley
Subject: Including hours worked in a Genl Jrnl entry

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
------------------------------

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:
Sent: Nov 20, 2019 09:17 PM
From: Dave Woodley
Subject: Including hours worked in a Genl Jrnl entry

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
------------------------------