We have a customer who wants serialized GS1-128 labels on shipments tracked to which Part#'s (ShipDtl lines) are in which Cartons in the CartonTrkDtl table. However, Epicor’s schema has CartonTrkDtl related to ShipHead not ShipDtl.
Anyone have ideas on how we can determine which ship lines are in which case?
Example: Packslip has 2 lines (parts) and 12 cases. As the tables are setup, each part would be in each case in a query.
I am working on something similar. It is my understanding the phantom pack details know nothing of the actual lines at all. I may be rolling out a custom solution soon to deal with this.
Like @Chris_Conn said you can’t its called a “Phantom” cause its not real. Basically it just gives you X boxes to pack stuff into it doesn’t care what goes in each box. You could do a customization with a UD table to relate lines to boxes i supose
Yes, that’s my dilemma. Even with a UD table, how do we determine which lines are in which box/pallet? I’m trying to avoid manually entry but I’m not seeing any other way.
You should be able to relate the UD table as a Child of the carton (each carton) and then have them select enter which lines go where. But yeah you’ll need some manual entry.
Better yet you could use a dropdown on each line (where the dropdown is the different cartons) then some logic to assign it in the UD table.
Trying to account for all the different ways shipments have gone out. This is customer specific at this time, but could expand. The number of cases/lines vary but in the nutshell I think the variations are:
Next question is when and how to get the user to enter this? Open to suggestions, I’m thinking a pop-up either at time of creating phantoms or before ship-confirm.
It’s been awhile since I messed with BPM Forms but thinking a dynamic chekbox grid based on the number of ShipDtl lines and Cases would be easiest for our team to use. No idea if a BPM form can be dynamic like this ugly Excel mock-up:
Only problem with that is if you have more than a handful of lines and/or cases, that matrix can get unweildy.
I think I prefer @josecgomez idea - have UD added to teh phantom with dropdowns for available lines to select
I like that too, but would it allow multiple per Case line? Case 1 could contain multiple ShipDtl lines.
Edit: I checked, we’ve had ShipDtl lines up to a max of 8 for this customer and that order had a total of 13 cases. So the dynamic checkbox idea isn’t as good as it sounded.
HMM, If true and a dropdown could select multiple Lines, could it save as a comma-separated list of lines for each carton?
Yeah that’s the beauty of adding a Child t to the Carton so each Carton can have XX children in the UD table
What did you use for the relationships between CartonTrkDtl and the UD Table? I can’t think of enough to make it unique per UD table row
PackNum = Key1
CaseID = Key2
Key5 auto increment 1,2,3,4
It may be easier for the shipping team to add part and qty to the phantom. They could scan the barcodes off the pick sheet.
Can you attach the ud table to the phantom lines?
If you did, you can add weights automatically from the part table to the phantom cases.
He wants multiple parts per phantom though… I think
I like that idea and it could still work with the child table. Jose is right, a case could be a pallet with multiple parts, so a UD on CartonTrkDtl wouldn’t really work. The EDI team can determine the shipdtl lines from the part number.
@Randy What solution did you end up going with? I’m curious if anyone has heard if Epicor will eventually roll in a more permanent solution for serialized labels for cartons. Currently @Chris_Conn solution worked great for one of our facilities. But they are wanting to implement EDI to cover the basis of ship notifications and order entry. But were trying to figure out how to implement EDI in which it can also send the serialized information with the ship notifications. But sense it seems Epicor does not have the serialized piece it will have to be custom.
PCID is the solution i think. I know they’ve brought some of the features in, but i think it’s still incomplete. Btw - I can suggest an AWESOME edi solution that directly integrates into E10. Miles above the Tie Kinnects solution imho.
Well, @tfenwick11 you won’t like the answer. Siffron moved to a different ERP with Manhattan SCALE WMS system that supports serialized cartons and sub-cartons. 
We had looked at SCALE for Epicor but now I know why that project was put on hold for so long. I think Chris is right, PCID looks to be the direction Epicor is going for this.
@Chris_Conn, please what EDI solution can you recommend?
