Am I correct in thinking, with the enhancement for JC-M dated 11/21/03, the wip summary should equal wip gl account for any given date??
 
Thank you for you help..
Pam
 

Since our management prefers to separate WIP $ by components of material, labor and load, we use JC-P for material $; manually track labor $ using a beginning balance, adding JC-C (labor) for the month, and subtracting labor associated with units transferred to finished production; then loads are calculated as a % of labor $.
 
We are unable to find one report in DBA to provide  monthend WIP by these 3 individual components.  JC-M only provides one number for monthend WIP and does not allocate it among these 3 components.

We have some class codes that direct costs for certain product codes to expense accounts instead of wip( for instance, R&D)  The wip summary shows the amount for the work order in the totals, but the GL account doesn't have the costs included.  We have to be sure to subtract these work orders from the wip summary before we compare totals. Does your company build any work orders for product codes whose costs are not collected in your gl account for wip?
The wip summary does have columns for labor and overhead and materials.  As long as none of the work orders have any finished production, these column totals should accurately reflect the totals for labor and materials that are in wip.
A while back we made the first adjustment to WIP GL to match our wip report, and since then the only time we have more than minor differences is when we do something that just doesn't work like finish production with a negative number on a reopened work order.  This correctly debits the wip gl but puts a negative number in the wip summary.
Just a couple of things to think about...

Karen - I don't think you CAN close a WO without a date.  If you can, tell me how you did it so I can prevent it.  Shouldn't be able to.
 
Cathy - if you make your work orders that post to expense accounts Status I (for Indirect) they can be easily excluded from the WIP Summary report.  They will also make no variance posting when they are closed because the system assumes status I work orders are for recording expense items and will not have Finished Production and consequently will also not have a Variance.

Thank you Lynn!  Everyone around here thinks I know all there is to know about DBA and with the help of you and IS Tech support, and all the forum members I don't really need to set them straight!  I have been struggling with "indirect" work orders for a long time and with one keystroke the problem is solved. I feel   but I'm very  

It should be including the transactions through the as of data on open work orders plus transactions through that date on work orders now closed that were open as of that date.

WE set the quantity to one, and we do finish production and close at the end of each month.  
Here is an example: We have a part number R&D with a class code R&D.  The class code has the same expense account for R&D in asset, COGS, and WIP account codes.  We have an absorbed labor account for R&D and this account is in all the absorbed labor accounts for the class code.   We build a work order for R&D ( a type N part) for quantity 1. WE issue materials, issue labor all month long. The costs are collected in "WIP"  which is the expense account for R&D.  When we finish and close at the end of the month we do it at actual cost.  The $$ go in and out( in asset out WIP, out asset in COGS for a net change of $0) and  since the part is an N type, there is no inventory to manage.  The costs, both labor and parts have been collected in the R&D expense account, and the absorbed labor has reduced the direct, variable, and fixed  labor costs, which are in  R&D expense.
We have a work order every month for general R&D expense, and sometime make a particular work order for a particular project.  WE use the same part number R&D(type N), we can fill in the description, and can even enter a routing and BOM.  
Hope thiis helps.

While we have been using indirect work orders for some time, we are just now using the correct type for the work order!
This forum is really a great help, and I don't know how I got along with out it before!

Lynn,
 
I am noticing everytime I print JC-M using prior date of 12/31/04 and accepting the other default dates work order status R and F, each time I print on another date I am getting different results...it looks like when a work order is closed it does not show open on the as of date...is there a way to fix???
 
Thanks Pam

Yes, Cyndee, you are right, you need to leave ALL the defaults (including the WO Status) the way the program wants them if you are running as of a prior date.