next fit algorithm bin packing in QV?

shahafei2 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm wondering if there is a way to run a "next fit algorithm" in QV in order to calculate the minimum amount of cartons and movements

in my scenario i have 3 zones at the WH(A, B, C)

In each zone there are unique products and the amount of available inventory per product is known

the carton volume and dimensions are fixed $(v_Car_vol),$(v_Car_length),$(v_Car_width),$(v_Car_width)

The DB is based on the following data

Product:

ProductID,

Unit_length,

Unit_width

Unit_height

Unit_vol,

Zone,

Units_In_Inventory

Orders:

OrderID,

Delivery_Date,

Delivery_Time,

ProductID,

Qty

What will be the best way to calculate the amount of cartons per order

and to present the required daily movements of cartons between the different zones?

topic next fit algorithm bin packing in QV? in QlikView