There is a standard Inventory Item Price list report.
For consistency could we get the same for Non-Inventory items (we have a lot of saleable services defined as non-inventory items).
The (now not so) new Custom reports still don’t support master data reports - all transaction based so could we get a price list for non-inventory items please to address at least?
Thanks for considering.
I put this into ideas.
Meanwhile, copying/pasting/printing the non-inventory items list from Settings works fairly well. You get item codes, names, descriptions, and prices.
Report transformation do provide access to this data, so could be used in the interim. I agree they are a bit more complex to use (but much more powerful). Lubos has suggested he wants to make further improvements to “Report Transformations” (& possibly change the name) so perhaps writing such reports via “Report Transformations” will be easier in the future.
Thanks Patch. Yes, I need to learn more about report transformations. A pity because I had a price list using the ‘old’ custom report function - took 5 minutes to create and grouped everything nicely by my item sales category (a custom field). I’m still keeping my fingers crossed that custom reports functionality gets expanded a little to at least ‘restore’ some of what was lost with the more recent incarnation with respect to master data table access and reporting although I’m not overly optimistic. So, in the meantime I’d be happy to make do with a standard price list report either expanding the current inventory item price list to ‘All item’ price list or a separate Non-Inventory item price list - whatever is quickest and easiest from a developer perspective.
I am also facing the same problem. I have a number of sales services listed in the non-inventory Items area and need a report similar to the inventory Item Price list as well.
I will investigate Report Transformations as I don’t know much about it and hopefully this will work. I also tried to do a custom report but it is not possible to include only some groups as not everything in the non inventory items needs to be on that price list.
Otherwise, I can just export the information to excel.
A post was split to a new topic: Course listings as items
You can now create custom report for non-inventory items.
So this will allow you to create a price list among other things.
When on non-inventory items screen, click Custom Reports to create new custom report.
The custom report definition can be as simple as this:
I just updated my desktop to the lates version(24.2.26.1322) and I dont have this screen. I want to find the price list. My screen looks like this
the report looks like this
@Wornout, see
You are in the wrong tab.
The new reports are not in
Reports → Custom Reports
You need to go to the tab containing the data you want eg Non inventory items and construct the Search / Report / Advance query there
Sorry @lubos , I didnt see the original post you did. I wasn’t specifically looking. I was looking at new posts and click on this one and thought I would try glad I can. Thanks for another wonder feature
@ Lubos can you at Active/inActive to the advanced list cause I have a few inactive one
