Spreadsheet: 677816d1589540877-material-stock-allocation-based-on-order-date-and-distribute-value-evenly-inventory-stock-allocation
Sheet: Final sheet

First : 2 Second : 7 Third : "blank" |  | FIFO (oldest to newest) | Material number  filter  for reference |  | Alllocation pick reference | Inventory stock for reference | pick - Order Quantity "F"  as per conditional sequence of "A", "C" with "D" , "G" &" I" as reference | Balance Quantity for reference
2 | 7
[NAME] | [NAME]. | Order creation date | Material | ShortTextOrderItem | OrderQty | INVENTORY STOCK   Qty | Manual Allocation of Qty | Balance Stock Quantity after manual allocation | Remarks | FORMULA BASED ALLOCATION
2 | 3039753 | 2020-01-03 00:00:00 | 16018000 | N PARO | 1 | 1513 | 1 | 1512 | 1st Lot
2 | 3053615 | 2020-02-08 00:00:00 | 90142500 | E WLU | 2 | 35 | 2 | 33
2 | 3145131 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 32
2 | 3145142 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 31
2 | 3145160 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 30
2 | 3145177 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 29
2 | 3143370 | 2020-03-01 00:00:00 | 16018000 | N PARO | 20 | 1513 | 20 | 1447 | 1st Lot
2 | 3143369 | 2020-03-01 00:00:00 | 16018000 | N PARO | 15 | 1513 | 15 | 1467 | 1st Lot
2 | 3141501 | 2020-03-01 00:00:00 | 16018000 | N PARO | 10 | 1513 | 10 | 1502 | 1st Lot
2 | 3141524 | 2020-03-01 00:00:00 | 16018000 | N PARO | 10 | 1513 | 10 | 1492 | 1st Lot
2 | 3141549 | 2020-03-01 00:00:00 | 16018000 | N PARO | 10 | 1513 | 10 | 1482 | 1st Lot
2 | 3201263 | 2020-03-02 00:00:00 | 90142500 | E WLU | 3 | 35 | 3 | 26
2 | 3141596 | 2020-03-10 00:00:00 | 90142500 | E WLU | 3 | 35 | 3 | 23
2 | 3141615 | 2020-03-10 00:00:00 | 90142500 | E WLU | 2 | 35 | 2 | 21
2 | 3219844 | 2020-03-10 00:00:00 | 16018000 | N PARO | 35 | 1513 | 35 | 1404 | 1st Lot
2 | 3219826 | 2020-03-10 00:00:00 | 16018000 | N PARO | 4 | 1513 | 4 | 1443 | 1st Lot
2 | 3219837 | 2020-03-10 00:00:00 | 16018000 | N PARO | 4 | 1513 | 4 | 1439 | 1st Lot
2 | 3144806 | 2020-03-11 00:00:00 | 16018000 | N PARO | 30 | 1513 | 30 | 1374 | 1st Lot
2 | 3230061 | 2020-03-11 00:00:00 | 16018000 | N PARO | 25 | 1513 | 25 | 1329 | 1st Lot
2 | 3144820 | 2020-03-11 00:00:00 | 16018000 | N PARO | 10 | 1513 | 10 | 1364 | 1st Lot
2 | 3144831 | 2020-03-11 00:00:00 | 16018000 | N PARO | 5 | 1513 | 5 | 1359 | 1st Lot
2 | 3144845 | 2020-03-11 00:00:00 | 16018000 | N PARO | 5 | 1513 | 5 | 1354 | 1st Lot
2 | 3239274 | 2020-03-16 00:00:00 | 90142500 | E WLU | 3 | 35 | 3 | 18
2 | 3239274 | 2020-03-16 00:00:00 | 90142500 | E WLU | 3 | 35 | 3 | 15
2 | 3240699 | 2020-03-16 00:00:00 | 16018000 | N PARO | 2 | 1513 | 2 | 1327 | 1st Lot
2 | 3227973 | 2020-04-01 00:00:00 | 90142500 | E WLU | 2 | 35 | 2 | 12
2 | 3227972 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 14
2 | 3227974 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 11
2 | 3227976 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 10
2 | 3232118 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 9
2 | 3219401 | 2020-04-07 00:00:00 | 16018000 | N PARO | 10 | 1513 | 10 | 1317 | 1st Lot
2 | 3219952 | 2020-04-09 00:00:00 | 16018000 | N PARO | 20 | 1513 | 20 | 1297 | 1st Lot
2 | 3229791 | 2020-04-10 00:00:00 | 90142500 | E WLU | 3 | 35 | 3 | 5
2 | 3229810 | 2020-04-10 00:00:00 | 90142500 | E WLU | 2 | 35 | 2 | 3
2 | 3230223 | 2020-04-10 00:00:00 | 90142500 | E WLU | 2 | 35 | 2 | 1
2 | 3228540 | 2020-04-10 00:00:00 | 90142500 | E WLU | 1 | 35 | 1 | 8
2 | 3230078 | 2020-04-10 00:00:00 | 16018000 | N PARO | 25 | 1513 | 25 | 1268 | 1st Lot
2 | 3230173 | 2020-04-10 00:00:00 | 16018000 | N PARO | 22 | 1513 | 22 | 1242 | 1st Lot
2 | 3230469 | 2020-04-10 00:00:00 | 16018000 | N PARO | 12 | 1513 | 12 | 1226 | 1st Lot
2 | 3230055 | 2020-04-10 00:00:00 | 16018000 | N PARO | 4 | 1513 | 4 | 1293 | 1st Lot
2 | 3230114 | 2020-04-10 00:00:00 | 16018000 | N PARO | 4 | 1513 | 4 | 1264 | 1st Lot
2 | 3230223 | 2020-04-10 00:00:00 | 16018000 | N PARO | 4 | 1513 | 4 | 1238 | 1st Lot
2 | 3233594 | 2020-04-11 00:00:00 | 16018000 | N PARO | 40 | 1513 | 40 | 1186 | 1st Lot
2 | 3233598 | 2020-04-11 00:00:00 | 16018000 | N PARO | 10 | 1513 | 10 | 1176 | 1st Lot
2 | 3233608 | 2020-04-11 00:00:00 | 16018000 | N PARO | 5 | 1513 | 5 | 1171 | 1st Lot
2 | 3233619 | 2020-04-11 00:00:00 | 16018000 | N PARO | 5 | 1513 | 5 | 1166 | 1st Lot
2 | 3292477 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 | 12 | 1154 | 1st Lot
7 | 3053590 | 2020-02-08 00:00:00 | 90142500 | E WLU | 3 | 35 | 1 | 0
7 | 3283040 | 2020-04-15 00:00:00 | 90142500 | E WLU | 9 | 35 | 0 | 0
7 | 3312074 | 2020-04-23 00:00:00 | 16018000 | N PARO | 6 | 1513 | 6 | 1148 | 2nd Lot
7 | 3317381 | 2020-04-27 00:00:00 | 16018000 | N PARO | 20 | 1513 | 20 | 1128 | 2nd Lot
7 | 3320279 | 2020-04-28 00:00:00 | 16018000 | N PARO | 25 | 1513 | 25 | 1103 | 2nd Lot
7 | 3322509 | 2020-04-29 00:00:00 | 16018000 | N PARO | 2 | 1513 | 2 | 1101 | 2nd Lot
7 | 3346477 | 2020-05-12 00:00:00 | 16018000 | N PARO | 100 | 1513 | 100 | 1001 | 2nd Lot
7 | 3333728 | 2020-05-13 00:00:00 | 16018000 | N PARO | 30 | 1513 | 30 | 971 | 2nd Lot
 | 051924 | 2019-08-12 00:00:00 | 90142500 | E WLU | 1 | 35 | 0 | 0
 | 00067464 | 2019-10-30 00:00:00 | 90142500 | E WLU | 1 | 35 | 0 | 0
 | 3229996 | 2020-03-11 00:00:00 | 16018000 | N PARO | 50 | 1513 | 50 | 921 | 3rd lot
 | 3149313 | 2020-03-13 00:00:00 | 16018000 | N PARO | 16 | 1513 | 16 | 905 | 3rd lot
 | 3246661 | 2020-03-20 00:00:00 | 16018000 | N PARO | 12 | 1513 | 12 | 893 | 3rd lot
 | 3254436 | 2020-03-30 00:00:00 | 16018000 | N PARO | 20 | 1513 | 20 | 873 | 3rd lot
 | 063877 | 2020-03-31 00:00:00 | 16018000 | N PARO | 1 | 1513 | 1 | 872 | 3rd lot
 | 3217030 | 2020-04-05 00:00:00 | 90142500 | E WLU | 2 | 35
 | 3223898 | 2020-04-09 00:00:00 | 16018000 | N PARO | 30 | 1513 | 30 | 842 | 3rd lot
 | 3223904 | 2020-04-09 00:00:00 | 16018000 | N PARO | 30 | 1513 | 30 | 812 | 3rd lot
 | 3225785 | 2020-04-09 00:00:00 | 16018000 | N PARO | 16 | 1513 | 16 | 796 | 3rd lot
 | 3229898 | 2020-04-10 00:00:00 | 16018000 | N PARO | 25 | 1513 | 25 | 771 | 3rd lot
 | 3229917 | 2020-04-10 00:00:00 | 16018000 | N PARO | 25 | 1513 | 25 | 746 | 3rd lot
 | 3233662 | 2020-04-11 00:00:00 | 16018000 | N PARO | 8 | 1513 | 8 | 738 | 3rd lot
 | 064270 | 2020-04-16 00:00:00 | 16018000 | N PARO | 1 | 1513 | 1 | 737 | 3rd lot
 | 064341 | 2020-04-21 00:00:00 | 16018000 | N PARO | 1 | 1513 | 1 | 736 | 3rd lot
 | 3325576 | 2020-04-30 00:00:00 | 16018000 | N PARO | 9 | 1513 | 9 | 727 | 3rd lot
 | 064236 | 2020-05-03 00:00:00 | 16018000 | N PARO | 1 | 1513 | 1 | 726 | 3rd lot
 | 3331774 | 2020-05-05 00:00:00 | 16018000 | N PARO | 30 | 1513 | 30 | 696 | 3rd lot
 | 3339453 | 2020-05-09 00:00:00 | 16018000 | N PARO | 40 | 1513 | 40 | 656 | 3rd lot
 | 3292465 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 | 12 | 644 | 3rd lot
 | 3292466 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 | 12 | 632 | 3rd lot
 | 3341652 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 | 12 | 620 | 3rd lot
 | 064914 | 2020-05-12 00:00:00 | 16018000 | N PARO | 1 | 1513 | 1 | 619 | 3rd lot
 | 3348160 | 2020-05-13 00:00:00 | 16018000 | N PARO | 15 | 1513 | 15 | 604 | 3rd lot
 |  |  |  | Total