Spreadsheet: 677677d1589469144-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
[NAME] | [NAME]. | Order creation date | Material | ShortTextOrderItem | OrderQty | INVENTORY STOCK   Qty | Manual Allocation of Qty | Balance Stock Quantity | Remarks
 | 051924 | 2019-08-12 00:00:00 | 90142500 | E WLU | 1 | 35 | 0
 | 00067464 | 2019-10-30 00:00:00 | 90142500 | E WLU | 1 | 35 | 0
2 | 3039753 | 2020-01-03 00:00:00 | 16018000 | N PARO | 1 | 1513 |  |  | 1st Lot
7 | 3053590 | 2020-02-08 00:00:00 | 90142500 | E WLU | 3 | 35 | 1
2 | 3053615 | 2020-02-08 00:00:00 | 90142500 | E WLU | 2 | 35
2 | 3141501 | 2020-03-01 00:00:00 | 16018000 | N PARO | 10 | 1513 |  |  | 1st Lot
2 | 3141524 | 2020-03-01 00:00:00 | 16018000 | N PARO | 10 | 1513 |  |  | 1st Lot
2 | 3141549 | 2020-03-01 00:00:00 | 16018000 | N PARO | 10 | 1513 |  |  | 1st Lot
2 | 3143369 | 2020-03-01 00:00:00 | 16018000 | N PARO | 15 | 1513 |  |  | 1st Lot
2 | 3143370 | 2020-03-01 00:00:00 | 16018000 | N PARO | 20 | 1513 |  |  | 1st Lot
2 | 3145131 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3145142 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3145160 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3145177 | 2020-03-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3201263 | 2020-03-02 00:00:00 | 90142500 | E WLU | 3 | 35
2 | 3141596 | 2020-03-10 00:00:00 | 90142500 | E WLU | 3 | 35
2 | 3141615 | 2020-03-10 00:00:00 | 90142500 | E WLU | 2 | 35
2 | 3219826 | 2020-03-10 00:00:00 | 16018000 | N PARO | 4 | 1513 |  |  | 1st Lot
2 | 3219837 | 2020-03-10 00:00:00 | 16018000 | N PARO | 4 | 1513 |  |  | 1st Lot
2 | 3219844 | 2020-03-10 00:00:00 | 16018000 | N PARO | 35 | 1513 |  |  | 1st Lot
2 | 3144806 | 2020-03-11 00:00:00 | 16018000 | N PARO | 30 | 1513 |  |  | 1st Lot
2 | 3144820 | 2020-03-11 00:00:00 | 16018000 | N PARO | 10 | 1513 |  |  | 1st Lot
2 | 3144831 | 2020-03-11 00:00:00 | 16018000 | N PARO | 5 | 1513 |  |  | 1st Lot
2 | 3144845 | 2020-03-11 00:00:00 | 16018000 | N PARO | 5 | 1513 |  |  | 1st Lot
 | 3229996 | 2020-03-11 00:00:00 | 16018000 | N PARO | 50 | 1513 |  |  | 3rd lot
2 | 3230061 | 2020-03-11 00:00:00 | 16018000 | N PARO | 25 | 1513 |  |  | 1st Lot
 | 3149313 | 2020-03-13 00:00:00 | 16018000 | N PARO | 16 | 1513 |  |  | 3rd lot
2 | 3239274 | 2020-03-16 00:00:00 | 90142500 | E WLU | 3 | 35
2 | 3239274 | 2020-03-16 00:00:00 | 90142500 | E WLU | 3 | 35
2 | 3240699 | 2020-03-16 00:00:00 | 16018000 | N PARO | 2 | 1513 |  |  | 1st Lot
 | 3246661 | 2020-03-20 00:00:00 | 16018000 | N PARO | 12 | 1513 |  |  | 3rd lot
 | 3254436 | 2020-03-30 00:00:00 | 16018000 | N PARO | 20 | 1513 |  |  | 3rd lot
 | 063877 | 2020-03-31 00:00:00 | 16018000 | N PARO | 1 | 1513 |  |  | 3rd lot
2 | 3227972 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3227973 | 2020-04-01 00:00:00 | 90142500 | E WLU | 2 | 35
2 | 3227974 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3227976 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3232118 | 2020-04-01 00:00:00 | 90142500 | E WLU | 1 | 35
 | 3217030 | 2020-04-05 00:00:00 | 90142500 | E WLU | 2 | 35
2 | 3219401 | 2020-04-07 00:00:00 | 16018000 | N PARO | 10 | 1513 |  |  | 1st Lot
2 | 3219952 | 2020-04-09 00:00:00 | 16018000 | N PARO | 20 | 1513 |  |  | 1st Lot
 | 3223898 | 2020-04-09 00:00:00 | 16018000 | N PARO | 30 | 1513 |  |  | 3rd lot
 | 3223904 | 2020-04-09 00:00:00 | 16018000 | N PARO | 30 | 1513 |  |  | 3rd lot
 | 3225785 | 2020-04-09 00:00:00 | 16018000 | N PARO | 16 | 1513 |  |  | 3rd lot
2 | 3228540 | 2020-04-10 00:00:00 | 90142500 | E WLU | 1 | 35
2 | 3229791 | 2020-04-10 00:00:00 | 90142500 | E WLU | 3 | 35
2 | 3229810 | 2020-04-10 00:00:00 | 90142500 | E WLU | 2 | 35
 | 3229898 | 2020-04-10 00:00:00 | 16018000 | N PARO | 25 | 1513 |  |  | 3rd lot
 | 3229917 | 2020-04-10 00:00:00 | 16018000 | N PARO | 25 | 1513 |  |  | 3rd lot
2 | 3230055 | 2020-04-10 00:00:00 | 16018000 | N PARO | 4 | 1513 |  |  | 1st Lot
2 | 3230078 | 2020-04-10 00:00:00 | 16018000 | N PARO | 25 | 1513 |  |  | 1st Lot
2 | 3230114 | 2020-04-10 00:00:00 | 16018000 | N PARO | 4 | 1513 |  |  | 1st Lot
2 | 3230173 | 2020-04-10 00:00:00 | 16018000 | N PARO | 22 | 1513 |  |  | 1st Lot
2 | 3230223 | 2020-04-10 00:00:00 | 16018000 | N PARO | 4 | 1513 |  |  | 1st Lot
2 | 3230223 | 2020-04-10 00:00:00 | 90142500 | E WLU | 2 | 35
2 | 3230469 | 2020-04-10 00:00:00 | 16018000 | N PARO | 12 | 1513 |  |  | 1st Lot
2 | 3233594 | 2020-04-11 00:00:00 | 16018000 | N PARO | 40 | 1513 |  |  | 1st Lot
2 | 3233598 | 2020-04-11 00:00:00 | 16018000 | N PARO | 10 | 1513 |  |  | 1st Lot
2 | 3233608 | 2020-04-11 00:00:00 | 16018000 | N PARO | 5 | 1513 |  |  | 1st Lot
2 | 3233619 | 2020-04-11 00:00:00 | 16018000 | N PARO | 5 | 1513 |  |  | 1st Lot
 | 3233662 | 2020-04-11 00:00:00 | 16018000 | N PARO | 8 | 1513 |  |  | 3rd lot
7 | 3283040 | 2020-04-15 00:00:00 | 90142500 | E WLU | 9 | 35 | 0
 | 064270 | 2020-04-16 00:00:00 | 16018000 | N PARO | 1 | 1513 |  |  | 3rd lot
 | 064341 | 2020-04-21 00:00:00 | 16018000 | N PARO | 1 | 1513 |  |  | 3rd lot
7 | 3312074 | 2020-04-23 00:00:00 | 16018000 | N PARO | 6 | 1513 |  |  | 2nd Lot
7 | 3317381 | 2020-04-27 00:00:00 | 16018000 | N PARO | 20 | 1513 |  |  | 2nd Lot
7 | 3320279 | 2020-04-28 00:00:00 | 16018000 | N PARO | 25 | 1513 |  |  | 2nd Lot
7 | 3322509 | 2020-04-29 00:00:00 | 16018000 | N PARO | 2 | 1513 |  |  | 2nd Lot
 | 3325576 | 2020-04-30 00:00:00 | 16018000 | N PARO | 9 | 1513 |  |  | 3rd lot
 | 064236 | 2020-05-03 00:00:00 | 16018000 | N PARO | 1 | 1513 |  |  | 3rd lot
 | 3331774 | 2020-05-05 00:00:00 | 16018000 | N PARO | 30 | 1513 |  |  | 3rd lot
 | 3339453 | 2020-05-09 00:00:00 | 16018000 | N PARO | 40 | 1513 |  |  | 3rd lot
 | 3292465 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 |  |  | 3rd lot
 | 3292466 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 |  |  | 3rd lot
2 | 3292477 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 |  |  | 1st Lot
 | 3341652 | 2020-05-11 00:00:00 | 16018000 | N PARO | 12 | 1513 |  |  | 3rd lot
 | 064914 | 2020-05-12 00:00:00 | 16018000 | N PARO | 1 | 1513 |  |  | 3rd lot
7 | 3346477 | 2020-05-12 00:00:00 | 16018000 | N PARO | 100 | 1513 |  |  | 2nd Lot
7 | 3333728 | 2020-05-13 00:00:00 | 16018000 | N PARO | 30 | 1513 |  |  | 2nd Lot
 | 3348160 | 2020-05-13 00:00:00 | 16018000 | N PARO | 15 | 1513 |  |  | 3rd lot