Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI am trying to figure out our top 50 sellers from August through today. The problem I keep running into is that all the sales reports seem to only pull sales that were invoiced. I need to be able to run a report that will show me all items on sales orders - invoiced or not - over the past six months.
Anyone have any idea how to accomplish this?
Thanks in advance,
Rick
Solved! Go to Solution.
Sale by Item or Sales by Customer reporting is fine. Pay attention to Cash or Accrual Basis. If you want Orders, not Sales, that is different; you can filter on Posting Status = Non-Posting = SO only. If you want Posting Status = Both, you just Double-reported a whole lot of things.
Sale by Item or Sales by Customer reporting is fine. Pay attention to Cash or Accrual Basis. If you want Orders, not Sales, that is different; you can filter on Posting Status = Non-Posting = SO only. If you want Posting Status = Both, you just Double-reported a whole lot of things.
So, it sounds like you are saying there is no way to pull a report with both open sales and invoiced sales and get accurate numbers, is that correct? It seem to me that if an order has been invoiced (posting) then it shouldn't also show as open (non-posting).
They are two different things: in the accrual accounting world nothing is actually "sold" until it is invoiced (posted). You would need to take two reports into a spreadsheet to put them together and get the results you want.
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.