cancel
Showing results for 
Search instead for 
Did you mean: 
kandmengineering1
Level 1

Quickbooks Desktop Open Sales Orders by Item Report

I am transitioning my company from Excel to Quickbooks and part of this process is finding a replacement for an Excel spreadsheet that we have used to keep track of our jobs. The closest feature that I have found on Quickbooks to this excel document is the Open Sales Order by Item Report. As with all reports, Quickbooks gives you the option of customizing the report  by  including additional columns such as: Notes, Deliv Date, Pay Period, etc.

 

I have added several of these columns that I feel would convey useful information to whomever is using the report. But, most of the columns I have added via the Customize Report option appear blank.

 

My question: I know QuickBooks displays reports based on a set of instructions known as a Report set, but how is each specific column on the report populated? I would like to know so I can determine what columns will actually be of use.

 

Thank you

1 Comment 1
JoesemM
Moderator

Quickbooks Desktop Open Sales Orders by Item Report

Thanks for posting in the Community, @kandmengineering1

 

Yes, you're right QuickBooks displays reports based on Report set. It extracts information from the data file and shown as a set of transaction lines. 

 

QuickBooks Desktop also uses the Source and Targets concept. This is to apply accounting principles and processes in your reports. Understanding Source and Targets help you maximize Report Filters. This way, you'll know how each column on the report is populated and you can create more effective reports.

 

Source- is the summary information about a transaction and contains all source data (source account, source name, source memo and source amount, etc.).

Target- it provides detailed information about the transaction and includes all target data (target accounts, target names, target memos, target amounts, etc.).

 

For more information about this, kindly visit this article's How QuickBooks generates reports section: Understand reports. It also contains the complete list of available reports in the system.

 

Additionally, you can set your report preferences to fit your style and business needs. To learn more about it, check out this article: Set report preferences. It contains other sets of related articles that covers basic information about reports in QuickBooks Desktop.

 

Please leave a comment below if you have any questions or concerns. I'm more than happy to answer them. Have a great day!

Need to get in touch?

Contact us