Hi @Jojo88 , It was a good challenge for me, and thank you for the question. I could make a solution for FIFO calculation, so please consider this. First of all, we should prepare an intermediate module for match productions and orders. It has a Time dimension and a list of purchase orders (Orders #). Intermediate Module If cumulate order quantity exceeds cumulate production quantity, we can say the production in the month is all sold. When the production items in the month are partly sold, we have to separate the cost of sold items from the remaining items. Then we could match the remaining items to the second order. I could hardly describe the idea well it is faster to look at screenshots or grid view excel. This solution works under the condition that production items in the month sold up to 2 orders. If the purchase order would be smaller and production separates into more than three orders, we have to improve this module. FIFO Module Outcome Order Module I would be happy this helps you, and any questions are welcomed Taichi
... 查看更多
