I need some SQL Expert advise from Snowflake community. I have the following PO Schedule Line Table. Also, I do have PO Purchase history table. I need Expected output as shown, a transformed table constituted out of PO Schedule Line Table and PO Purchase history table. Can someone pls help here?
The schedule line for expected output table would be constructed out of column StatisticalReleventDeliveryDate from PO Schedule Line and PostingDate from PO Purchase History and by taking quantity into consideration too.
This is a classic example of First In First out of Goods Receipt Qty against Scheduled Qty
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.