johnCronin
Technical User
If I have manually created work orders. What would be the best method to automate the relase of this work order without operator intervention.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Release Work Orders in POP 1
- Thread starter johnCronin
- Start date
- Status
The only thing I can think of is to launch a keyboard macro from flexibility at the loss of focus event on the reference field which would simulate the grand total of 2 mouse clicks that it would take the user to do this manually.
Doesn't sound like theres much ROI in that.
What is it that you are experiencing that makes this so desireable to be automated?
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Doesn't sound like theres much ROI in that.
What is it that you are experiencing that makes this so desireable to be automated?
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #3
johnCronin
Technical User
The work order is being created in VB by inserting the proper information into the Macola tables. Now I would like to launch Macola's release work order from with in VB program if possible. You should know that the VB program is being invoked through Fexibility during Purchase Order Entry.
Thank You
Thank You
Why is the work order being created via VB instead of manually or through forced demand=pull? Is there an event that is supposed to make this happen? If so what is the event?
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
-
1
- #5
MacolaHelp
Instructor
Did you create the corresponding records in IMORDBLD (caputered bill) when you created PPORDFIL & did you create PPLINCMT, IMREFDES, IMITMNOT files or copy these records to the corresponding files that relate to captured work orders? If not, why not just use PP/pull to create work orders from sales orders by forced demand?
If you haven't already created at least IMORDBLD, your work orders will not allocate or relieve component inventory when released either through macola or VB. If you are trying to create WO totally outside macola, you have to re-invent all the cobol programming logic in VB that happens via PP/pull or in manual work order creation/release.
If you haven't already created at least IMORDBLD, your work orders will not allocate or relieve component inventory when released either through macola or VB. If you are trying to create WO totally outside macola, you have to re-invent all the cobol programming logic in VB that happens via PP/pull or in manual work order creation/release.
Is this happening at Purchase Order Entry or Sales Order Entry? It makes no sense to enter a purchase order for an item and a production order for the same item. Please confirm.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #8
johnCronin
Technical User
The customer sells finished good that are either assembled locally or off shore. The customer maintains and owns the inventory at the off shore locations. When a line item is entered into a purchase order the item is interrogated to determine if it’s manufacturing method is PP (Production Order Processing). If it is then the bill of materials is exploded and a if a component which has material cost type of “x” (outside process) is found, then that part number is substituted into the order line item and the original part number is maintained in a user-defined field. Remember the customer is only purchasing the labor, they already own the raw materials.
Upon completion of the purchase order a routine is invoked that determines which work orders now need to be created for the finished goods and using the bill of materials creates the unreleased work orders. The purchase order number is maintained in the work orders for reference. Inventory location codes are derived from the vendor info.
It is these work orders that I would like to automatically release. Currently the customer has to manually release them each day. I sure don’t want to try and code the releasing of a work order.
Upon completion of the purchase order a routine is invoked that determines which work orders now need to be created for the finished goods and using the bill of materials creates the unreleased work orders. The purchase order number is maintained in the work orders for reference. Inventory location codes are derived from the vendor info.
It is these work orders that I would like to automatically release. Currently the customer has to manually release them each day. I sure don’t want to try and code the releasing of a work order.
MacolaHelp
Instructor
unless you hava thousands of work orders unreleased at a time . . .
The PP/process/release work orders allows you to release in a range of dates, items, customers, sales orders, etc. I just released 20 orders with a total of 525 components, many of which had insufficient quantity messages in about a minute. You have to answer the questions at release time of whether or not to N,W or Y on components & to print or not & to print reference designators or not, so intervention is required to set these switches. Maybe you can defaults the screens & prompts & put a button on the release screen to release all? The release screen changes the ppordfil_sql.ord_status to X from U. I just tried editing that field & it did allow me to print the WO, but didn't create my allocations. It is answering this question during the release process that allow the program to handle the disposition of component inventory. I would steer clear of this.
I would suggest you rethink using the sales order to drive the work orders & use reorder advice or MRP to create POs for the labor items since the work order will drive the PO demand. The sales order number is referenced in work order if pp/pull. You can use comments or references in the PO to tie back to the work order or sales order. Seems like you are doing a lot of programming that generic macola already handles in a different design.
The PP/process/release work orders allows you to release in a range of dates, items, customers, sales orders, etc. I just released 20 orders with a total of 525 components, many of which had insufficient quantity messages in about a minute. You have to answer the questions at release time of whether or not to N,W or Y on components & to print or not & to print reference designators or not, so intervention is required to set these switches. Maybe you can defaults the screens & prompts & put a button on the release screen to release all? The release screen changes the ppordfil_sql.ord_status to X from U. I just tried editing that field & it did allow me to print the WO, but didn't create my allocations. It is answering this question during the release process that allow the program to handle the disposition of component inventory. I would steer clear of this.
I would suggest you rethink using the sales order to drive the work orders & use reorder advice or MRP to create POs for the labor items since the work order will drive the PO demand. The sales order number is referenced in work order if pp/pull. You can use comments or references in the PO to tie back to the work order or sales order. Seems like you are doing a lot of programming that generic macola already handles in a different design.
I agree with Macolahelp 100%
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
MacolaHelp
Instructor
unless you hava thousands of work orders unreleased at a time . . .
The PP/process/release work orders allows you to release in a range of dates, items, customers, sales orders, etc. I just released 20 orders with a total of 525 components, many of which had insufficient quantity messages in about a minute. You have to answer the questions at release time of whether or not to N,W or Y on components & to print or not & to print reference designators or not, so intervention is required to set these switches. Maybe you can defaults the screens & prompts & put a button on the release screen to release all? The release screen changes the ppordfil_sql.ord_status to X from U. I just tried editing that field & it did allow me to print the WO, but didn't create my allocations. It is answering this question during the release process that allow the program to handle the disposition of component inventory. I would steer clear of this.
I would suggest you rethink using the sales order to drive the work orders & use reorder advice or MRP to create POs for the labor items since the work order will drive the PO demand. The sales order number is referenced in work order if pp/pull. You can use comments or references in the PO to tie back to the work order or sales order. Seems like you are doing a lot of programming that generic macola already handles in a different design.
The PP/process/release work orders allows you to release in a range of dates, items, customers, sales orders, etc. I just released 20 orders with a total of 525 components, many of which had insufficient quantity messages in about a minute. You have to answer the questions at release time of whether or not to N,W or Y on components & to print or not & to print reference designators or not, so intervention is required to set these switches. Maybe you can defaults the screens & prompts & put a button on the release screen to release all? The release screen changes the ppordfil_sql.ord_status to X from U. I just tried editing that field & it did allow me to print the WO, but didn't create my allocations. It is answering this question during the release process that allow the program to handle the disposition of component inventory. I would steer clear of this.
I would suggest you rethink using the sales order to drive the work orders & use reorder advice or MRP to create POs for the labor items since the work order will drive the PO demand. The sales order number is referenced in work order if pp/pull. You can use comments or references in the PO to tie back to the work order or sales order. Seems like you are doing a lot of programming that generic macola already handles in a different design.
- Status
Similar threads
- Locked
- Question