Forum Discussion

Sharon2311's avatar
Sharon2311
User
30 days ago

Can i customise an item report by date

Is there a report I can run, that identifies items used by date order.  For example we keep metal plates for printing, each plate has an item number. We would like to run a report to show which items...
Earl_HD's avatar
Earl_HD
MYOB Moderator
30 days ago

Hi Sharon2311,

Thanks for your post. You can generate the Item Register Detail Report to view all inventory items used in transactions within a specific date range. This report provides detailed information about these transactions. For more details, refer to this help article. Inventory reports

Feel free to post again, we're happy to help!

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Regards,
Earl

  • Sharon2311's avatar
    Sharon2311
    User
    28 days ago

    Thankyou for your response, unfortunately it has not solved my request.  To be more detailed my request is quite industry specific. So I will try my best to explain.  We are a printing company that uses metal printing plates to print.  Each Printing plate has been set up with an item number.  I am trying to achieve a report that shows me what item number have not been used for the last 7 years, so I want to be able to put in a date range and show which items have not been used (on a invoice), or a complete list that show what has been used, and what has not. ie a zero balance would indicate no use, a dollar value a plate that has been used. I have tried to run a item Register summary and /or detail, however it comes up no data available, could this be because of how it was set up?  I have also tried to run a sales history by customer, this is what I could use, if i could run it via item aswell or instead of by customer.

     

    Sharon2311

     

    If you could offer any advise that would be great

    • Genreve_S's avatar
      Genreve_S
      MYOB Moderator
      28 days ago

      Hi Sharon2311, 

       

      Thanks for the follow-up question.

       

      The Item Sales History report seems to be the closest match to the report you're seeking. However, you may need to reduce the number of columns to fit the page if you're not exporting to Excel.

       

      If this report doesn't provide the information you're looking for, we recommend posting this as a suggestion on the Ideas Exchange board for our development team to consider.

       

      Should you need further assistance, don't hesitate to create a new thread.

       

      If my response has answered your inquiry, please click "Accept as Solution" to assist other users find this information.

       

      Thanks,
      Genreve