We don’t do Misc Shipments so this hasn’t popped up as a problem for us, but …
How do people handle the fact that you can have a Misc Ship and Cust ship with the same PackNum?
It doesn’t really cause any problem with DB integrity as they are from different tables.
One could say that its just like the fact that you can have a Quote with the same Number as an Oder has. But that’s really not the same. Quotes use the field name Quotenum
, while Orders use OrderNum
, and there’s little confusion between the purpose of a quote and an order.
While the printed PackSlip looks a tad different, there’s nothing on it to indicate which type it was.
Just find it odd that Epicor thought there was a big enough difference between the two (Misc and Cust), to use entirely different tables, both using the same initial pack num. Where as things like invoices (Shipment vs Misc) are all done in one table, using a field to indicate the invoice type.