We use Dynamics AX 2012. Our product is maintained in AX by our accounting and sales department on a linear measurement unit. That is, the product is in various profiles shown in total meters per profile. We physically make the product into individual coils. These coils are associated with an item number that exists in AX but, they are also provided an individual coil ID that records the profile, create date, length. Sales says it's too hard for them to do their job if we have the product listed by individual coil ID. I know that we in the warehouse are trying to track various SPECIFIC coils to compile orders and this information is not in AX, we're using Access databases and Excel spreadsheets to do this.
This leads to a SEVERE breakdown in communication because all of the information is not contained in the ERP in real time. Movements, quality holds, shorts, etc... are not captured in AX so pinpointing what to pick, what to inspect, what's on hold, what's been released, etc... is a nightmare.
My question, is it possible for sales to maintain selling by the meter while still allowing the production, QA, and warehouse teams to be able to track by the individual coil? What does that look like and how do we start the process to make that happen?