Question on Logic in Allocating Orders

Hello,

I am trying to create logic to allocate and check which order can be fulfilled and from which WH Locations. Previously I am handling this using Excel VBA, but I need to move the logic to AlteryX, anyone have similar problem and know how to create the logic that not only check if we can fulfill the order, but also check from which WH Locations it need to be picked?

Stock Information:

Order Information:

Expected Output:

edit: make mistake in the output, fixed it

Thank you,

Anthonny

Order Fullfilment.yxmd

Data.xlsx

Workflow

Preparation

Accepted answers

atcodedog05

Hi @Anthonny

If you have multiple sources you might need an iterative macro approach.

All comments

atcodedog05

Hi @Anthonny

A classic resource allocation problem. Nice !!

This weekly challenge which help/guide you in solving this

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-14-Warehouse-Distribution/td-p/36743

Hope this helps 🙂

Anthonny

Hello atcodeddog05,

Thank you very much for pointing me an existing challenge and solutions. I have take a look at that challenges, my problem here is that when I expand the data to include "extra" warehouses that contain the same items, the logic does not works, some Store will be getting the order fulfilled from both warehouse (thus getting double the expected Qty)

What I add here is a second warehouse that contain the same item as the Main WH:

Then the output will make some Store that require Item 1 will get double the allocations, here is the request that each store have (in this case focus on Store "F" and "H"

The output are these store will get double the allocations:

Any logic need to be adjusted here to only allocate it once?

Thanks,

Anthonny

challenge_14_solution_1_adj.yxmd

atcodedog05

Hi @Anthonny

If you have multiple sources you might need an iterative macro approach.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703