Sep 16 2019
I've given layout of an excel file below which has three sheets out of which "invoice" and "packaging" sheets are inputs whilst the "output" sheet contains the desired output I want.
I'm finding it difficult to frame an query for the same - It'll be great if someone can help me on that.
Thanks in Advance.
METADATA- SO is Sales Order | The output is based on FIFO Logic | Packaging stage is primary whilst Invoice stage is secondary