I spent a lot of time checking all the formulae and they seem correct, but still I got the wrong figures at last.
For example, the instruction says "The Confirmed Purchase Order Receipt value has updated to 8,194 is also in Week 3 FY20 column" whereas my result is 8,020.
I also found that only the Beginning Inventory of week 1 is the same as the given example, as time goes by, the result goes further away from the correct result.
Could someone give an idea of a solution?
Go to Solution.
View solution in original post
@Yunshu I think you're very close. Check your formula:
Confirm Purchase Order Receipt = IF Confirmed PO Delivery = 0 THEN 0 ELSE POST(Final Shipment Amount, Final Shipping Time Weeks)
You should be getting 8,194.
If your formula is the same, check the "Final Shipment Amount"
Hi @JaredDolich ,
Thanks for your reply.
I think it might be the problem of my beginning inventory line item as the example shows the 1st 4 figure are 13000, 10952, 8902 and 15048 whereas mine being 13000, 10995, 8990 and 15005.
My Beginning Inventory formula is IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
I have also checked my DAT01 and found nothing wrong.
So the reason for this deviation is really confusing.