How to Generate Labor Reports for Accruals and WIP

Calculate  prepaid and accrued labor to make the necessary adjusting journal entries. From Provider's Earnings History in Order Entry (Order Entry > Reports > Provider's Earnings History):

Report 1 to calculate Work In Process Labor:

• Delivered Status= Undelivered
• Paid Status= Paid
• Use Pay Date= From 01/01/80  To (last day of  month being closed)
• Stores=ALL

This report reflects labor that has been paid in the month being closed for orders that have not been job costed.

Report 2 to calculate Prepaid Labor:

• Delivered Status= Delivered
• Paid Status= Paid
• Delivery Date=
•          From     1st day of the month that follows the month being close
•          To           Current Date
• Use Pay Date=
•          From     01/01/80
•          To           Last  day of  month being closed

This report reflects the prepaid labor for the month you are closing. This is the labor paid in the current month on jobs that are job costed in the following month.

Report 3 to calculate Negative Prepaid Labor:

• Delivered Status= Delivered
• Paid Status= Paid
• ¦  Delivery Date=
•            From     1st day of month being closed
•            To           Last day of the month being closed
• ¦  Use Pay Date=
•            From     1st day of the month that follows the month being closed
•            To           Current Date

This report reflects the labor that has been paid in the following month(s) for orders that were job costed during the month being closed.

If paying labor through HR, then using the  HR paid date for reports not paid date.will make the number more accurate.

Work in Progress = Report 1 + Report 2 - Report3