Forum Discussion

Flav45's avatar
Flav45
Experienced User
4 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
    4 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