Forum Discussion

Flav45's avatar
Flav45
Experienced User
3 years ago

Report on Locations

Is there a Report that gives you the total prices of all items in each location ?

 

I can get a list of items in each location but not the total values there isn't an option to use in Insert/Modify

Show Hide Columns

 

A great tool when you need to know total stock value in each store  

 

thanks 

5 Replies

Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

     

    Just a suggestion

     

    Is it possible to sort the report once it is produced ( under filters) to have the information in the format that you want?

     

    Lisa

  • Flav45's avatar
    Flav45
    Experienced User
    3 years ago

     

    Lisa

     

    I tried different reports and different filters but cannot find one that give the item price 

    Which report do you suggest ?

     

    thanks 

    Flavia

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi 

    is there a report that gives you what you want but doesn't total?

     

    if there is I am suggesting that you use the sort option, not a filter, to sort the report in a way to give the totals you want

     

    Lisa

  • Flav45's avatar
    Flav45
    Experienced User
    3 years ago

    I tried report item list (Summary )report with location but it doesn't give an option to put a date

    e.g. 1/7/21-30/6/22

    if there is a report that does all 3 things Item, Location & price that would be great 

     

    thanks 

    Flavia 

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

    rather than the summary try the detail 

    report

     

    also you say location is that job or category- not familiar with what that is

     

    Lisa

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.