We do not currently have Tulip connected with our ERP. I am trying to create an app that does the following:
- Sorts the data, lists the data by single load number
Our company manufactures trailers and our logistics department currently manually creates a load sheet as to how the trailers are stacked by size on a flat bed based off of location and build date.
We currently copy the information from Epicor, paste it into Google Docs. Then we have to sort the information by how we want to stack our loads. The information that comes in can have 5-10 lines more or less of different order numbers with the same load number. This is currently a 15+ step process with a lot of copying, cutting and pasting.
Ideally, we realize that until we get connected with our ERP that we will still have to pull the information into Google Docs to manipulate unless we can data dump it into Tulip but where I get stuck is how to organize the orders by size/location within the app. And, we would have to be able to adjust because we have add-on trailers etc. that can happen last minute which would require us to update the load sheet.
I’ve included a snip of what our current load sheet looks like…
Thanks for any advice or ideas!!