topic Re: Interesting Query: Order must deliver as per FIFO method in App Development

Interesting Query: Order must deliver as per FIFO method

Anku — Sun, 03 Jul 2022 05:40:03 GMT

Hi all,

I have 2 data set, they don't have any PK.

1. Orders data:
These are the orders being placed by customer.

2. ShopperStock:
Stock detail of each outlet

Desired Outcome:
If multiple similar orders are in queue for a specific shop then it must deliver them according to the order placed, if not then it's an error/ red flag.
I have attached .qvf & excel for better understanding.

Please assist. Thank you.

Re: Interesting Query: Order must deliver as per FIFO method

Anku — Sun, 03 Jul 2022 05:41:53 GMT

Re: Interesting Query: Order must deliver as per FIFO method

MarcoWedel — Sun, 03 Jul 2022 13:16:57 GMT

Whats' your question?

Can you show what you already did that did not work?

Re: Interesting Query: Order must deliver as per FIFO method

Anku — Tue, 05 Jul 2022 10:27:31 GMT

@MarcoWedel apologies for delayed response.

Please refer attached qvf file. Further, In case you have a better way to do it, please do guide me.

Thanks