Please don't worry about names and such being mentioned inside the worksheets. All of the personal information in the sheets has been fictionalized so I could upload it here along with my question.
At the moment I am trying to create a single list/overview of orders that have had their "Pick Line Created" before 19:05 on any given day and will be shipped through DHL but weren't marked "Ready For Shipment" on the same day. The shipment method conditional is based on column F (Shipment Method) of the Order Inquiry file. The status of the order is based on column E (TransactionType) and F (TransactionDate) combined, both shown in the Transactions export. Preferably, this new overview would only show the products for each order for which these conditions are met in case of partial fulfillment.
Column N (Order ID) in the Transactions file corresponds to column M (Order ID) in the Order Inquiry file. Similarly, column H (Product ID) in the Transactions export corresponds to column T (Product5) in the Order Inquiry export.
I've also added an example of the information I'd ideally get from this new overview. Just to clarify, order 5394545 would be excluded since DHL is not mentioned within the Shipment Method column in the Order Inquiry file. Similarly, orders 5428798 and 5433397 are excluded because both have a "Ready For Shipment" status on the same day they had their "Pick Line Created" for every single product ID within the order. Both 5427747 and 5430880 only show the relevant product IDs (when expanded) because some product lines did have a "Ready For Shipment" status on the same day.
If any more info is required to be able to answer the question or put me into the right direction, please let me know and I'll do so as soon as possible. Thanks in advance to anyone that was able to help me with this.
Bookmarks