infor.com
concierge
infor u
developer portal
Home
Groups
VISUAL - Enterprise Customer Community
Multiple Parts, One Traveler
Legacy Contributor
My company does many smaller jobs that, in many cases, include multiple parts at multiple price points that are run together as one job. (We are a metal plater, so we don't actually make anything, we plate other company's parts.) Is there a way I can get multiple parts to print out on one Work Order Traveler?
For example, today I received 5 pieces from one customer. We are nickel teflon plating them all with all the same specs, however, there are 3 different price points for this job. (2 pcs @ 1 price, 2 @ higher price and 1 larger piece with its own price.) In order for these to invoice with their own respective prices, they have to be separate part numbers. If they are separate part numbers, they print separate travelers. Since they plate on the same rack, that means my guys are filling out / scanning 3 sets of travelers and inputting the information 3 times.
How can I get these parts to all be on the same Traveler?
Find more posts tagged with
Comments
Legacy Contributor
Perhaps switching to the production schedule report?
Legacy Contributor
Can that be personalized to show all of the information on the Traveler? Our AS certification requires us to note what steps were done, who they were done by and a few other details that we have built into the traveler.
Gelangens_Anlage_Entwurf.pdf
Legacy Contributor
Anything is do-able. Time and or money. You can do it yourself through extended query or hire someone.
As far as the traveler, you're trying to get multiple work orders to print as one traveler, correct?
Legacy Contributor
It’ll take a little overhead and thinking but you could setup co-products for them and use the print co-product option on the work order. So you’re plating the big piece as Part A and 2 smaller as Part B and another as Part C. You can create the work order for Part A and add the Part B and C as co-products and figure out the percentage of cost to spread. Or you could have a generic part called nickel plating and all three parts are co-products
Wichtige Lösungen in der Wissensdatenbank April 2012.pdf
Legacy Contributor
The Engineering Masters are all identical. This means that, if I were to print all 3 Travelers, they would be identical except for the part number and quantity. So what I want is to be able to print one Traveler with 3 parts listed.
The example I gave is actually simplified from what actually came in. We received 48 pieces that had 15 different price pionts. That means that for 48 pieces that were all running together, they were going to have to fill out 15 Travelers. They literally would have spent more time filling out Travelers than working with the parts.
I don't know enough about Co-Products yet, as we don't use them. I'll look that up and see how that works. Thank you!
Legacy Contributor
How are you collecting labor and how complicated are your builds? You could just print a bar coded dispatch report to the floor. The operator would just have the one report (not the travelers) and would be a list of jobs they need to complete. Each job would have a bar code for that operation and they could just scan on there what they accomplished (or I guess even document on there what they got done for their labor tickets to be entered later on). I don’t know how many operations you have, but the simpler your builds are the easier it would be to implement.
We doing a similar project here with the intent to go paperless (no travelers). Our operators often run multiple jobs at the same time and then deal with all the paperwork of scanning all of them complete. Sometimes the handling of paperwork is more labor intensive than actually performing the work done to the jobs.
I also agree with Scott, Co-Products would also be worth testing. Assuming your work orders are directly linked to your customer orders, you could just link the same work order to all line items. You can then report the labor in “bulk”, and as it ships it will receive and close out the co-products just fine. I just tested it and it worked slick. Let me know if you need help walking through that.
Legacy Contributor
Terri,
Technically, price has nothing to do with any of this. I could sell the exact same part for 10 different prices on the same customer order. I would assume that price is not the driver but the part size and/or specification of the plating that needs to be done to the customer supplied material is the key and, ultimately, how you track and translate that efficiently to the work order/shop floor. The co-products are found by opening the work order header and pressing the co-products button. As stated, it gives you the ability to make multiple parts from one work order. This is commonly used in molding applications where they have multiple piece molds – every time you mold part A you also get Part B, C and D. You could have one work order for everything. The trick is deciding the percentage of cost to associate with each piece. If management looks at the entire order for profitability then that’s less important but it is something to understand and make sure your profitability analysis doesn’t get messed up.
Legacy Contributor
Thank you for the info Scott! I'm going to check out the co-products option today. We are less concerned with profitability analysis than with getting this to work for us. In our industry, we generally can't firmly pinpoint any of our costs beyond labor anyway, so we already go with "close enough". My main concern was getting these prices listed separately on the invoice without forcing my biller to do manual inputs. Thank you!!
Legacy Contributor
I think I've figured out the Co-Products thing - I've been able to establish and allocate the co-products so that I can follow it all the way through - Customer Order through Shipping and Invoicing. The only glitch is that when I print the Traveler - which consists of the actual traveler for the first part and a list of what other parts go with it - the Co-Products form doesn't print. The Traveler looks perfect but the Co-Products Form that should print afterward is just a blank screen (when "printed' to View).
I'm assuming I'm just missing a step somewhere. Does anyone have any idea what I'm doing wrong? I have not done anything to personalize this form yet, so it is still set on the Infor-designed report.
Thank you!!
Legacy Contributor
I believe it’s a defect that’s pending a fix. Personally, I’ve never used the Co-products format while printing the work order traveler. We have the co-products printing on the main traveler. The QRP has the following variables you can add to the header if they're already not there:
CP_PART_IDS
CP_PART_DESCRIPTIONS
CP_DESIRED_QTIES
Hopefully that will work for you.
Scott
Legacy Contributor
That's it! I deleted those when I customized the Traveler. I'll go put them back and it'll work perfectly. Thank you so much!!!!
Legacy Contributor
We use co-products and since there is no cp_customer_part_id and the Cust_customer_part_ID only shows for the workorder, I am trying to do an extended query to obtain the Customer Part ID (not our part Id). Unfortunately I am only able to retrieve one of the customer part ID's for the co-products and there are multiple co-products on the work order. Any idea on how to have the traveller show this information?
Legacy Contributor
If I understand you correctly, this is similar to a situation I once encountered. I was trying to write an extended query to pull Part_Location quantity information not available to the Work Order Traveler report. Extended queries only allow you to pull in one record, but I needed to pull quantity information for multiple Part_Location rows. I wrote a function to string together Part_Location information from multiple rows with a carriage return between each row's information, and a view to execute the function and gather other needed data. My extended query pulled in the needed data from the view, and the string of Part_Location data displayed on the report as multiple lines. Hope this helps.
Legacy Contributor
I managed to get the parts to show doing something similar, however, it appears to hang up if a certain number of characters is reached.
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
ION Connect
ION Workflow
ION API Gateway
Syteline Development
CPQ Discussion Ask a Colleague
Infor Data Fabric
Infor Document Management (IDM)
LN Development
API Usage
FAQs, How-To, and Best Practices