Sql Function inventory qty and value fifo
Budget: $10 – $30 USD
I have the following table
table1
ProductID ,MDate ,in_Qty,out_Qty,in_Price,out_Price,WhID,TransTypeID
I need two sql function for this table
1- calculate total qty and inventory value using fifo
2- using fifo list of all out products and the list should include in_Price calculation
for more info kindly see excel file
table1
ProductID ,MDate ,in_Qty,out_Qty,in_Price,out_Price,WhID,TransTypeID
I need two sql function for this table
1- calculate total qty and inventory value using fifo
2- using fifo list of all out products and the list should include in_Price calculation
for more info kindly see excel file