Forum Discussion

abc1232's avatar
abc1232
Experienced User
5 years ago

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.

 

  • Melisa_D's avatar
    Melisa_D
    5 years ago

    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

Sort By
Replies have been turned off for this discussion
  • Melisa_D's avatar
    Melisa_D
    Former Staff
    5 years ago

    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
      5 years ago

      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
        5 years ago

        Hi abc1232, 

         

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