Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello. We are trying to create or use a report that will allow us to select only certain inventory items not all. We are publishing company and pay royalties to our authors and would like to be able to pull a report for only those books not all of our inventory. We only need to see the quantity sold not the pricing. I went into the QuickReport but it only lets you select one item. I was wondering if there is a similar report we could generate or modify to only include the items we need and then memorize it for future sales. Thank you for your assistance.
Solved! Go to Solution.
"I went into the QuickReport"
Run QuickReport or Sales, such as Reports menu > Sales by Item Summary or Detail, or Sales by Customer Summary, Columns by Item Type or Item Detail.
Filter on item.
Scroll UP. You overlooked "Multiple Items." Now you get the Pop up to checkmark what applies.
Retitle this report, such as "Sales for J Jones Royalty" and memorize it. Update the Item Filter, retitle it for the Next Royalties, memorize it as New, not Replace. Memorize these all into a Group you named "Royalty reports." Now you double-click the Group, and they all run at once.
"I went into the QuickReport"
Run QuickReport or Sales, such as Reports menu > Sales by Item Summary or Detail, or Sales by Customer Summary, Columns by Item Type or Item Detail.
Filter on item.
Scroll UP. You overlooked "Multiple Items." Now you get the Pop up to checkmark what applies.
Retitle this report, such as "Sales for J Jones Royalty" and memorize it. Update the Item Filter, retitle it for the Next Royalties, memorize it as New, not Replace. Memorize these all into a Group you named "Royalty reports." Now you double-click the Group, and they all run at once.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here