Forum Discussion

abc1232's avatar
abc1232
Experienced User
5 years ago
Solved

COS allocation when inventory sold

I am wondering if there is any reports I can run to track how much COS has been allocated when I sold my product.I have run GL detail report. But i still want to track the exactly amount has been allocated for each individual product in invoices.

 

  • Hi abc1232

     

    Thanks for your response. Can you please check to see if you are running both reports for the same exact date range. If you are, can you please clear your AccountRight cache and then re run the report. Do the reports match now ?

     

    Additionally can you run the Item Transactions Report for the exact same date range, does this match the Items Register Detail Report ? If it doesn't match can you please provide me a screenshot of the all 3 reports:

    • Analyse Sales report 
    • Items Register report 
    • Item Transactions report

7 Replies

Replies have been turned off for this discussion
  • Hi abc1232

     

    Thank you for your post. The Analyse Sales (Item) report displays sales, cost of sales, gross profit, units, average cost and per cent margin for specific items within a range of accounting periods, based on recorded invoices, not including quotes and orders. This report can be found by going to Reports > Index to reports > Sales > Analyse Sales (Item). 

     

    Additionally our article Sales reports has a list of sales reports for available for inventory. 

    • abc1232's avatar
      abc1232
      Experienced User

      Hi Melisa,

      Thank you for your reply. I have run the Analyse Sales (item) report and Item register (detail) report to compare COS and I found some difference. I would like to do some further investigation to figure out which one cause the difference. I am wondering how can I do the further investigation to figure out which cause the problem.

       

      • Melisa_D's avatar
        Melisa_D
        Former Staff

        Hi abc1232

         

        Can you please clarify what type of difference you have found ?