Order with Conditional Fulfillment

Conditional Order (Batch-Level Filtering)

1. Set “Batch Wise Picking” = Yes

The user can provide maximum of two conditions with AND or OR operators from these set of batching attributes:
mrp, exp, mfg, batch_no

Mrp : batch mrp of the product
Exp : expiry date 
Mfg : manufacturing date
Batch_no: batch no. of the items

These values are filled in at the time taking GRN for fresh inward

1. On the item-entry screen, provide batch-based conditions:
   Examples:
   mrp = 500
   mrp > 500
   exp > 2024-12-03
   Combine conditions using AND (max 2):
   mrp > 500 AND exp > 2024-12-03

 Location-Based Picking

Restrict order fulfillment to specific bins using:

bin_fk_id IN (1,2,3) 
or bin_fk_id IN (10)

Bin IDs can be obtained from: Reporting → Location Master Dump