Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Rattrap1
Level 1

Getting Unit Price

For reasons I am not aware of, the publishing company I work for accounts for freight under a single code and production cost under item SKU. I am trying to put together a total unit cost but I have not found an easy way to do this. When I receive an item from the PO, the Item Receipt window shows me all the information I need, but I have not found a way to access it in reports. 

I am sharing an image of an Item Receipt. In the image: A is the sum of B (stored under Item SKU) and C (stored under a generic SKU for all freight). I would like a report that has E (Item SKU), D (Quantity) and A (Cost). 

 

Is such a report possible and if so, how do I get it? 

1 Comment 1
ChristineJoieR
QuickBooks Team

Getting Unit Price

I appreciate you sending us a screenshot, @Rattrap1. It helps a lot to identify your concern.

 

When we customize the reports, default columns are available in QuickBooks Desktop. I'll show you a workaround to help those details appear on your report file.  

 

Since the details you outlined in the screenshot are unavailable in the default columns, what we have to do is to export the report to an excel file. Then, you can add additional columns you want to show in the report file.

 

Follow the steps below:

 

  1. Go to the Reports tab.
  2. Select the Inventory, then look for the Inventory Stock Status by Item. Sort the date and press the Customize Report button.
  3. Once a box appears, you can put a check mark on all the Columns. Then double-check the data that fits your preferences and click OK.
  4. If you need to add more, you can export the data by pressing the Excel button and choosing the Create New worksheet.
  5. Next, click the Export box. 

 

You're now ready to modify the file.

 

Furthermore, we can also submit feedback to our product developer for this option.

 

Here's how:

 

  1. Select the Help option.
  2. Select the Send Feedback Online option.
  3. Select the Product Suggestion option. A pop-up window displays.
  4. Enter your feedback suggestion.
  5. Click the Send Feedback button. 

 

Please know you are always welcome to post here again in the Community. Have a great day.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us