Skip to content

Feature - Production Time Not Captured Report

Release Date - 1/9/17

Labor and overhead are only being posted from BOMP when a quantity is reported. For example if , let's say a worker is working on building one parent item for 5 days. Every day he reports zero completed until the fifth day when he completes it. The first 4 days, no production transactions are created when the zero quantity is reported. On the fifth day when the parent item is completed, ALL the labor and overhead goes to that one day.  

This report will look at all production time card data that currently has not created a production transaction because a quantity of zero was reported. You can use this report to find out the total WIP value of labor and burden (not including materials) for the production time at month end. This will allow you to make an accrual journal entry to capture the WIP value.

This report must run at month end in order for the value to be accurate. You can use deferred processing to ensure that it will run at the month end at the right time.

The new report is available from Bill Of Material Processor-> Reports-> Work in Process Report-> Print-> Prod Time Not Captured Report.


The following selection criteria is available for the report:


Starting Operator Department - Enter the starting operator department for a range of operators to print. Press the F7 Key to search for an existing department ID. Press the F1 Key if you want to print only operators without a department. Defaults to All.

Ending Operator Department  - Enter the ending operator department for a range of operators to print. Press the F7 Key to search for an existing department ID. Defaults to the starting operator department.   

Shift - Enter the shift for the range of operators to print. Press the F1 Key to select operators without a shift ID. Press the F7 Key to search for an existing shift ID. Defaults to All.

Starting Operator ID - Enter the starting operator ID for a range of operators to print. Press the F7 Key to search for an existing operator ID. Defaults to All.   

Ending Operator ID - Enter the ending operator ID for a range of operators to print. Press the F7 Key to search for an existing operator ID. Defaults to the starting operator ID.            

Detail Level - Valid entries are D=Detail and S=Summary. Defaults to S=Summary.  If D=Default is chosen, the breakdown of the burden calculation will print for each time transaction.

Create CSV File? - Y or N. Enter Y to export results to a CSV file. Defaults to the last entry.

CSV File Name - Enter the file name and path for the CSV file. Defaults to last entry.

Below is an example of a summary report.


Below is an example of the burden detail printed when the detail option is chosen:


The CSV file option supports the following fields:

Dept - Department
Shift - Shift
Operator - Operator ID
Session Start Date - Time Clock Start Date
Session Start Time - Time Clock Start Time
Session End Date - Time Clock End Date
Session End Time - Time Clock End Time
Detail Start Date  - Time Clock Detail Start Date
Detail Start Time  - Time Clock Detail Start Time
Detail End Date - Time Clock Detail End Date
Detail End Time - Time Clock Detail End Time
Elapse Hrs - Elapsed Detail Hours
Dir/Share - Direct or Shared Labor
Loc Type - Location Type (Work Center or Department)
WorkCenter - Work Center
Labor Amt - Labor Amount
Burden Amt - Burden Amount
WO No - Work Order Number
Oper No - Operation Number
Oper Tp - Operation Type
Oper ID - Operation ID
Item No - Item Number
Labor Abs Acct - Labor Absorded Account from Work Center
Burden Abs Acct - Burden Absorbed Account from Work Center


Programs Modifed: BMWIPSCN, BMWPCALC

Programs Added: BMPRDTIS, BMPRDTIM, BMPRDTIW.SL, BMPRDTIW.FD, BMPRDTIW.WS, BMPRDTIW.DS, BMPRDTIW.IO

CLS

Feedback and Knowledge Base