Welcome, Guest. Please Login.
10/31/24 at 23:29:51
News:
Home Help Search Login


Pages: 1
Send Topic Print
Finished Production and WO statusing (Read 1346 times)
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Finished Production and WO statusing
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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Finished Production and WO statusing
Reply #1 - 03/11/03 at 13:33:59
 
Would love to get some feedback on this post..... ???
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Finished Production and WO statusing
Reply #2 - 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?  
 ???
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Finished Production and WO statusing
Reply #3 - 03/12/03 at 08:39:48
 
Not sure what you mean by "get the numbers right for costing".
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Finished Production and WO statusing
Reply #4 - 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.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Finished Production and WO statusing
Reply #5 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
helmar36
Browser
*




Posts: 13
Gender: male
Re: Finished Production and WO statusing
Reply #6 - 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.
Back to top
 
 

Eric Schmidt
Micron Industries of Rochester, Inc.
  IP Logged
Lynn_Pantic
Ex Member



Re: Finished Production and WO statusing
Reply #7 - 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.
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Finished Production and WO statusing
Reply #8 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
NovaZyg
Ex Member



Re: Finished Production and WO statusing
Reply #9 - 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.  
 
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Finished Production and WO statusing
Reply #10 - 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.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
helmar36
Browser
*




Posts: 13
Gender: male
Re: Finished Production and WO statusing
Reply #11 - 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.
Back to top
 
 

Eric Schmidt
Micron Industries of Rochester, Inc.
  IP Logged
Pages: 1
Send Topic Print