Ideas

Dear Team Find attached COGS and Cost variance of attached bar code for given period. You are required to provide option to change default LIFO method of cost capture for COGS purpose and difference between average cost and COGS under LIFO reporting under Cost variance column in Stock Movement Report to moving average cost method. Cost variance method it self is not applicable to trading and does not warrant this which unnecessarily creates confusion and difficult to explain to tax authorities. When we look at margin analysis Sales – cogs but in reality we have define Sales – COSG+Cost variance. How the user remember and create cube and analyse margin % We would like to have moveing weighted average cost which was captured in attached excel sheet and that cost should be item cost, which is standard universal practice by and large. We are not for cost variance method under any circumstance. Ist scenario – LIFO Only for issue purpose 2nd Scenario -Cost var - Simple avg cost 3rd Scenario - moving avg cost OB 979.20 979.20 979.20 Site Transfer IN 2,992.00 2,992.00 2992.00 Sales - COS -2,176.00 -2,176.00 -2203.20 Cost vari due to avg cost change -27.20 CB 1,795.20 1,768.00 1,768.00