It would be good if you can add heading in inventory items, for us to group them and quick find. same as you did for jobs
"Heading for stock items"
I have set up Customs lists to group my inventory but cannot group them in one report. Is there are way to do this?
Hey there! I see that this is posted as an AccountRight Idea though are asking how to do something, I would recommend posting this kind of question on one of the AccountRight boards like Getting Started or Sales and purchases.
In terms of your question though, my understanding is that Custom Lists are designed for Filtering purposes so that you can separate the data on your report as opposed to grouping them specifically. Which is why it only allows 1 selection per field in the Advanced Filters.
That said, I decided to play around in the software to see what I answer I can pull up and found that while I can't produce a report with 2 values in the Custom List filtering, I can play around with the Filtering in the Item List screen.
Here's what I did (Tested in 2018.2):
1. I created 2 Values in my Custom List 1 option (Lists > Custom Lists > Item > Custom List 1). These values were: Location1 & Location2.
2. I then assigned Location1 & Location2 to separate Items.
3. On the Item List window (Items > Item List) I added the Custom List Column (Right click the Headers > Click Column Chooser > Double Click Custom List 1)
4. I then clicked the Filtering button on the Header to begin filtering by this column:
5. After dropping it down, I could choose multiple values by ticking them off:
6. This then filtered my List to show all Items with those 2 values in that field.
7. I right clicked and copied to Clipboard on the list:
8. I opened an Excel Spreadsheet and just hit Ctrl + V to paste the values there and I can now see a report.
I hope this helps you with the current scenario!
~TingSpace