print pick slip does not pick lot based on lot expiration date
Dear All ,
we use commitment method 3 (lot expiration date ) .
But , let's say we have 2 sales orders with the same item codes with order qty as 15KG and 20KG and qty available is in different lots .as below
| 11.0000 | 201611090039 | 07/08/2017 | |
| 18.0000 | 201612030057 | 01/09/2017 | |
| 18.0000 | 201701070027 | 04/10/2017 |
what is happening is , it is picking 1st 2 lots only for both the orders as below
| CH01 | 201611090039 | 17009025 | 11.0000 | SO | 540 | 560 | 20002 |
| CH01 | 201612030057 | 17009025 | 4.0000 | SO | 912 | 560 | 20002 |
| CH01 | 201611090039 | 17009026 | 11.0000 | SO | 540 | 560 | 20023 |
| CH01 | 201612030057 | 17009026 | 9.0000 | SO | 912 | 560 | 20023 |
ideally , it should take remaining 14 Qty from lot 201612030057 and then remaining 16 qty from 3rd lot 201701070027