Report on Locations

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Flav45
Experienced User
30 Posts
Experienced User
Experienced User

30Posts

2Kudos

0Solutions

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 5
LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Report on Locations

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
Experienced User
30 Posts
Experienced User
Experienced User

30Posts

2Kudos

0Solutions

Re: Report on Locations

 

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
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Report on Locations

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
Experienced User
30 Posts
Experienced User
Experienced User

30Posts

2Kudos

0Solutions

Re: Report on Locations

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
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

211Kudos

124Solutions

Re: Report on Locations

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

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post