Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHello,
I am trying to create a build assembly summary report that includes only transactions entered/edited today, but has a total that includes the quantity on hand for the fiscal year to date. Similar to an inventory item quickreport, but for multiple items. The intention is to have a report that I can use to see only items that were assembled yesterday and compare the total inventory after the assemblies to a physical count given to me from my employees. The problem is that I cannot both have the only assemblies I want show up on the report, while also having a YTD inventory count. I can do this now by just looking at two different reports but I was wondering if I could combine them into one to make it simpler.
If this needs clarifying, just ask. Thanks for the help
Solved! Go to Solution.
Hi, @Blibla4774. It's great having you here in the QuickBooks Community.
Since the values displayed in reports in QuickBooks Desktop (QBDT) depend on the reporting date, it isn't possible to create a report that showcases only transactions entered today, with a total that encompasses the quantity on hand for the fiscal year-to-date. However, I can suggest an alternative report to display multiple items much like the QuickReport from your Item list. You can then export the relevant reports to Excel and combine the data outside the software.
You can consider running the Inventory Valuation Detail report to display data for multiple items like the QuickReport from your Item list and show the current quantity on hand. Here are the customizations you can follow:
After this, export the report and the other relevant report that shows the total quantity on hand for the fiscal year-to-date, and combine them outside the software.
If you want to save the customizations of your reports in QBDT, let me add this article as a reference: Create, access and modify memorized reports.
We'll be here in the Community should you have further questions about running the Build Assembly report or creating custom reports in QBDT. We'll do our best to assist. Take care.
Hi, @Blibla4774. It's great having you here in the QuickBooks Community.
Since the values displayed in reports in QuickBooks Desktop (QBDT) depend on the reporting date, it isn't possible to create a report that showcases only transactions entered today, with a total that encompasses the quantity on hand for the fiscal year-to-date. However, I can suggest an alternative report to display multiple items much like the QuickReport from your Item list. You can then export the relevant reports to Excel and combine the data outside the software.
You can consider running the Inventory Valuation Detail report to display data for multiple items like the QuickReport from your Item list and show the current quantity on hand. Here are the customizations you can follow:
After this, export the report and the other relevant report that shows the total quantity on hand for the fiscal year-to-date, and combine them outside the software.
If you want to save the customizations of your reports in QBDT, let me add this article as a reference: Create, access and modify memorized reports.
We'll be here in the Community should you have further questions about running the Build Assembly report or creating custom reports in QBDT. We'll do our best to assist. Take care.
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