Forum Discussion
Formula Excel/VBA
if BOM = 1 then SPI, if BOM = 10 then CPI when we disptach the item from warehouse to store then first prority goes to CPI and then SPI. But due to some technical issue, in many cases SPI went to s...
When we disptach the item from warehouse to store then first prority goes to CPI (complex pack which is 10 BOM) and then SPI(simple pack, which has 1 BOM).
But due to some technical issue, in many cases system is sending Simple pack to to store first and then complex pack.
if BOM = 1 then SPI, if BOM = 10 then CPI
Now, I have to find out if system is sending any style "123" to branch "456" (based on date)
1) both SPI and CPI on same date (together).
2) SPI first
3) CPI first
But due to some technical issue, in many cases system is sending Simple pack to to store first and then complex pack.
if BOM = 1 then SPI, if BOM = 10 then CPI
Now, I have to find out if system is sending any style "123" to branch "456" (based on date)
1) both SPI and CPI on same date (together).
2) SPI first
3) CPI first