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

Customize item reports - Item Actual Cost Detail, add P.O.# and a Custom Field

I am placing orders with vendors using purchase orders and defined items, where the items frequently include data in a custom field.  When I enter a bill for these purchases, I receive the order against the PO so the PO# is associated with each line of the bill.  When I later run the Item Actual Cost Detail report on the items included in these orders I can customize the report to add columns for PO# and our Custom Field.  However, when I produce the report with these columns there is no data in the PO# or the Custom Field columns. How to I fix this?

4 Comments 4
FritzF
Moderator

Customize item reports - Item Actual Cost Detail, add P.O.# and a Custom Field

I see this is your first question so let me take the time to welcome you here to the Intuit Community, @krtekkie.

 

I'm here to help get this taken care of, but I have some question about your concern first.

 

I tried to do this on my end, but I wasn't able to pull up the report that you've mentioned. That said, can you please send me a screenshot of that specific report? Also, may I know what version of QuickBooks you're currently using? Any additional information will be much appreciated.

 

Just in case, you can also check out this article for future reference: Customize item reports.

 

I'm looking forward to your response, @krtekkie. Take care and have a great rest of the day!

FritzF
Moderator

Customize item reports - Item Actual Cost Detail, add P.O.# and a Custom Field

Hi there, @krtekkie.

 

I just want to follow-up on you about this. Are you still having the same issue? If so, let's run the QuickBooks built-in diagnostic and repair tools called rebuild and verify data utilities. These tools comb through, repair, and notify you of data damage within the file.

 

Here's how:

 

1. Go to File, then select Utilities and Rebuild Data.
2. Choose OK. Follow the prompts to save a backup.
3. Click OK when you see Rebuild has completed.
4. Now, go back to File, then Utilities and select Verify Data this time.
5. Should the Verify find an issue with your data, you will be prompted to Rebuild Now or View Errors. Choose Close, then perform the steps below.
     a. Find QBWin.log or QuickBooks.log files.
     b. Check the log file.
     c. Scroll all the way to the bottom for the most recent Verify information.
     d. Find the line that contains the LVL_ERROR, then check Top data damage errors in QuickBooks Desktop.

 

For your reference, you can also check out this article for further guidance: Resolve data damage on your company file.

 

That should do it. Please let me know how it goes by posting a comment. I'm always here to help. Wishing all the best!

solis02
Level 1

Customize item reports - Item Actual Cost Detail, add P.O.# and a Custom Field

I keep getting $0.00 for Act. Cost when running Item Actual Cost Detail.  How can I fix that?

 

MorganB
Content Leader

Customize item reports - Item Actual Cost Detail, add P.O.# and a Custom Field

Good morning, solis02.

 

Thanks for following up on this thread and letting me know how things are looking in your account. I want to make sure you're able to see the correct amount on the report in your QuickBooks Desktop.

 

My first recommendation is to double check the data entered to generate the report (especially the date). If everything is correct and the amount still shows as $0.00, I would suggest completing the steps mentioned above to fix data damage on your QuickBooks Desktop company file. Doing so will resolve any potential issue that's causing the report to not display the correct amount for the actual cost in the report.

 

If the problem persists after giving these steps a try, you may need to call in to speak with a member of the Desktop Support Team. Agents have specialized tools, like screen-sharing, to take a closer look at your account to determine what's causing the amount to show as $0.00, even after verifying everything has been entered correctly. Here's how to get in touch with the team:

 

1. Press the F1 key on your keyboard.

2. Select Contact Us.

3. Enter Support in the field and click Continue.

4. From here you can choose to message an agent, or set up a callback for a time that's convenient for you.

 

This linked article provides these steps if you ever need them again in the future: Contact the QuickBooks Desktop Customer Support Team

 

With the info listed above you'll be able to successfully run the Item Actual Cost Detail report with correct amounts in no time. Please know I'm only a comment or post away if you have any other questions.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us