I 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.
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.
