Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have got a requirement as explained below,
Please take an example of above data.
Avail OH is Available stock in warehouse.
There are two stores requesting for stock: Store A and Store B.
Store A is requesting for 4 (Propose) and Store B is requesting for 8 (Propose).
Store A has been allocated 4. So the remaining in ware house is (10-4) 6 and so Store B is allocated only 6.
The allocation would be in ascending order of store name.
Please note the warehouse can have any number of items and stores.
Could anyone please help on this to achieve it?
Thanks & Regards,
Karthikeyan.
And this is something you are trying to do in the script or front end?
In script I need to consider the looping method, but there would be millions of iteration.
Is there is a way to achieve in UI without the performance issue?
There might be ways to do it in UI, but I think back-end would be more efficient because this sort of thing is not filter dependent (at least that's how I see it). Would be better if calculated in the script.
Would you be able to provide few rows of raw data in any format other than image?
Sunny is right, this is a script job. No iterations required, just use peek() function.
But I would furfill requests based on sales performance desc, not alphabetically.
Another useful table that you can do in the interface is the existing stock optimisation, by moving excess stock from one store to another based on sales performance.
For chains with tens/hundreds of stores and thousands products, who is gonna provide requests for each product in each store? You have to calculate the request based on previous sales.