Ganesh Vankadaru
New Member
Hi,
I have a situation to allocate Batch Stock against certain Outstanding Sales Orders. To further explain,
Sheet-1: It will have sales order wise, Material wise Quantities for which orders have been placed.
Sheet-2: It will have material wise, Batch wise Stock available.
Requirement: I'm looking for some formula which will help me in plotting the Batch against the Outstanding Sales order. The batch plotted shall not exceed it's qty availability in Sheet-2.
For better understanding I have attached one sample excel sheet.
Excel formula or VBA Solution will help.
I have a situation to allocate Batch Stock against certain Outstanding Sales Orders. To further explain,
Sheet-1: It will have sales order wise, Material wise Quantities for which orders have been placed.
Sheet-2: It will have material wise, Batch wise Stock available.
Requirement: I'm looking for some formula which will help me in plotting the Batch against the Outstanding Sales order. The batch plotted shall not exceed it's qty availability in Sheet-2.
For better understanding I have attached one sample excel sheet.
Excel formula or VBA Solution will help.