ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Finished Production and WO statusing
http://www.istechforum.com/YaBB.pl?num=1045689068

Message started by aricon on 02/19/03 at 15:11:07

Title: Finished Production and WO statusing
Post by aricon on 02/19/03 at 15:11:07

From a consulting point of view, one enhancement I would like to see would be the ability to have a 2 tier approach to Finish Production/closing.

Tier 1- Call it Update WO Status or some such: This would allow a user to put in a date and a work order number range (with blank suffixes allowed to ensure tagging ALL suffixes with that prefix) and a quantity complete field. This would update sheduling and remove/reduce the W/C allocations and update MRP requirements as well. What it would NOT do, is to calculate/post any cost fields. This ensures that if there are any additional costs from labor, materials, purchases, etc. that they would still get included and calculated as normal when finishing production, without going to WIP Variance or some such.

Tier 2 - Would be the normal Finish Production routine which would run as is today.

I would be interested in seeing what you think Lynn, as well as seeing what the other users think of this.

Title: Re: Finished Production and WO statusing
Post by aricon on 03/11/03 at 13:33:59

Would love to get some feedback on this post..... ???

Title: Re: Finished Production and WO statusing
Post by Karen Mason on 03/12/03 at 08:35:22

Lorne,
There was a thread under General DBA Topics called WO & Finished production costing, started by BOXMAN. Several of us are struggling to get the numbers right for costing yet needing to post invoices before production costs are in. Would this proposal solve this issue?
???

Title: Re: Finished Production and WO statusing
Post by aricon on 03/12/03 at 08:39:48

Not sure what you mean by "get the numbers right for costing".

Title: Re: Finished Production and WO statusing
Post by Karen Mason on 03/12/03 at 08:45:04

Sorry,
Get the right dollar value for posting the finished product to inventory so I can post the sales invoice. As the final labor, foh, and p.o. amounts come in, we are always dealing with a variance if we have posted finished production ahead of the costs coming in.
Geez, this sounds convoluted even to me.

Title: Re: Finished Production and WO statusing
Post by aricon on 03/12/03 at 08:50:34

And assumably you are doing finish production in order to update scheduling and/or MRP and thus any PO invoicing costs or outside servicing costs, etc. come in a day or 2 or 4 later and all get posted to WIP Variance account, right?

If that is correct, than yes, that is EXACTLY what this is intended for. I was looking to convince Lynn that it would be worthwhile to split up the functionality that WO-I currently does into a 2 tier process.

Title: Re: Finished Production and WO statusing
Post by helmar36 on 03/13/03 at 16:08:07

Lorne,
I too posted under Boxman's costing thread. If I understood your two tier suggestion correctly, I would definately be a proponent of it.

Title: Re: Finished Production and WO statusing
Post by Lynn_Pantic on 03/13/03 at 16:16:57

Not a bad idea but not as easy as it sounds. You can get quantities out of WIP but how do you cost that inventory while you are waiting for the rest of the costs to come in? And what about higher level assemblies that use the subassemblies that have been put into stock quantity-wise? What cost goes into the next level WO? Or if they get shipped, what number do you use for COGS? Unfortunately, the two processes really need to go hand-in-hand.

Best approach if you can do it is to use Standard Cost on all partial receipts so they go into stock at a reasonable number regardless whether the costs have been entered into the work order yet or not. Then just be sure all the costs are in the work order before you close it and any difference between actual work order costs coming in and standard cost going out will post to variance. Or, if you can delay the final entry of Finished Production until all costs are in, then those unit(s) will carry the variance.

Title: Re: Finished Production and WO statusing
Post by aricon on 03/13/03 at 17:52:25

Lynn,

Went through this as a mod for my major client with the programmer, and he understands what I am looking for here.

The whole point was to NOT deal with the issues you brought up. Split the functionality so that there is an ability to tell the system that QUANTITIES have been completed, THEN do essentially normal finished production when everything is in which will calculate and post the costs fields.

Title: Re: Finished Production and WO statusing
Post by NovaZyg on 03/13/03 at 19:11:50

Lorne,

I Lynn has a very valid point. if you add to inventory you need to assign a $ value to it. you can't just put it in inventory at $0.

Title: Re: Finished Production and WO statusing
Post by aricon on 03/13/03 at 19:59:09

Through this functionality you are not really "adding to inventory" at stage 1. You are merely doing a status update for scheduling purposes primarly and MRP to a very secondary nature.

What I am intending here is for scheduling, as the most important, to be able to be kept VERY current, without the associated pains that go with posting costing.

Title: Re: Finished Production and WO statusing
Post by helmar36 on 01/18/08 at 13:35:23

I see that I am posting to this over 4 years from the original post, so this may have been answered already (or put to rest). I am one that notices the pain of costs not matching actual because not all costs are in at the time of entering finished goods. My main problems are that I enter labor costs once a week, and have some open POs that have prices that vary due to quantities (such as plating). After going to one of Lynne's seminars, I have changed my process to try to get costs in line with actual costs. In order to make sure all labor costs are in, I keep a list of products that are complete, but not yet put into the system until the weeks worth of labor is entered. For the varying plating costs, I guesstimate so that costs are entered when receiving the PO. I then Release Sales Orders knowing the sytem will warn me that I do not have enough in inventory (since I did not enter finish goods yet). An example is an employee tells me on Tuesday that he finished 20 widgets that I need to ship Thursday. I currently have to note that I have 20, but not in the system. Then release and print packing slips on Thursday, knowing the system will warn me. Then on the following Monday, enter everyone's labor hours, which includes labor towards the 20 widgets. Then enter finish goods. Then print and post invoices.

I now understand why it is difficult/impossible for Lynne to make the changes that are described in the earlier posts, but it would be very helpful if it was. In order to see how much "widgets" cost, I look at the Job costing reports, since they allow costs to be entered/change as long as the Work Order is still open.

If there has been any changes to the above post, I'd like to know.