This content has been marked as final.
Show 3 replies

1. Re: Calculated : Auto suggestion
Jim Dehner Mar 26, 2020 4:01 AM (in response to Michael Mc Brayer) 
2. Re: Calculated : Auto suggestion
Michael Mc Brayer Mar 26, 2020 9:06 AM (in response to Jim Dehner)Hi Jim,
Column E will be a calculated field which will determine the number of qty based on Max Qty (Column D)
For instance, on what in circled in black, two orders for product B both have an order qty of 20 however the max qty per order is 30, so the remaining 10 qty's.
For on what in circled in red, three order for Product C has 100, 80, 20 however the max qty per order is 180, qty of order 2 will be added to order 1 as it meets the max qty, no changes for order 3 (order qty 20).
I hope my explanation is clear.
Thank you
Mike

3. Re: Calculated : Auto suggestion
Deepak Rai Mar 26, 2020 9:46 AM (in response to Michael Mc Brayer)
AutoSuggestion_v2018.3.twbx 13.2 KB
