Forum Discussion
Dax Help to Crack Qty Sold In FIFO Order
Hello Experts how can we Sale this item in Fifo Order. once the 1st Purchase is consumed then only it should take from the 2nd Purchase what is the way to acheive it. In this Eg: once item A has w...
Hello Anonymous
Cost will weighteed average cost, Total item cost/ Total Qty
Item sale should be in fifo Order
here the issue is we cant add index column why because the data soruce is from cloud. so there may be issue in refresh (i think so)
we have entry type column is there to differenciate sales and purhcase and Posting date is there
Sample Data and Output
Hello Anonymous
Could you pls look into this.