Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Need help with creating a Sales Order report by customer that also shows the COGS per order. I've tried a few of the other Solutions on here and none have worked for what we are looking for.
Running QB Desktop: Premier Plus Manufacturing and Wholesale 2022
Solved! Go to Solution.
I'm here to provide some insights about the report that you need, Keila.
A Sales Order (SO) is a non-posting transaction. It doesn't impact the financial statements in QuickBooks.
Also, the inventory Cost of Goods Sold (COGS) is only affected when you sell inventory items on invoices or sales receipts. Hence, COGS won't show up on the Sales Order by Customer report.
When you sell an inventory item, run the Transaction Journal Report for the invoice/sales receipt and you see the Sales/Accounts Receivable transaction. The Inventory/COGS transactions credit the Inventory Asset account and debit the COGS accounts.
In addition to this, you need to create an invoice and record the payment to see the COGS account. You can follow the Accounts Receivable workflow to organize your transactions.
Check out this link for instructions and detailed steps: Get started with customer transaction workflows in QuickBooks Desktop.
Stay in touch with me if there's anything else I can help you with the Sales Order report. Don't hesitate to leave a comment below, and I'll get back to you.he
I'm here to provide some insights about the report that you need, Keila.
A Sales Order (SO) is a non-posting transaction. It doesn't impact the financial statements in QuickBooks.
Also, the inventory Cost of Goods Sold (COGS) is only affected when you sell inventory items on invoices or sales receipts. Hence, COGS won't show up on the Sales Order by Customer report.
When you sell an inventory item, run the Transaction Journal Report for the invoice/sales receipt and you see the Sales/Accounts Receivable transaction. The Inventory/COGS transactions credit the Inventory Asset account and debit the COGS accounts.
In addition to this, you need to create an invoice and record the payment to see the COGS account. You can follow the Accounts Receivable workflow to organize your transactions.
Check out this link for instructions and detailed steps: Get started with customer transaction workflows in QuickBooks Desktop.
Stay in touch with me if there's anything else I can help you with the Sales Order report. Don't hesitate to leave a comment below, and I'll get back to you.he
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