Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello, I have created a custom field for my items call Commodity Code, and populated same. Unfortunately, when I run Custom/Transaction Reports/ and add in the column "Commodity Code", none appear except those associated with credit memos? Can anyone help me out here? Much appreciated.
Todd
Thank you for posting here in the Community, @TDSDen.
Let me share some insights on how the custom field works on your report.
Your custom field's associated items or transactions will not appear to be working as designed.
If it's the column header that is not showing in your report, it may be caused by a corrupted file. Let's run the Verify Rebuild Utility Tool in QuickBooks Desktop to detect the damaged data. Here's how:
Once done, pull up the report again to check the figures on the custom fields you've created.
You can also check this reference on how to fix data damage on your QuickBooks Desktop company.
I'm adding this article for additional tips on how to customize a report: Customize reports in QuickBooks Desktop
If you need anything else, let me know in the comment. I'll be happy to help you further with reports and other topics in QuickBooks.
Transaction-based reports will include the custom field values only when the values have been added to transactions.They won't include the values on the item records.
Could this be what you're seeing? Have you added the values to your transactions?
Re: Transaction-based reports will include the custom field values only when the values have been added to transactions.They won't include the values on the item records.
How can the values on the item records be automatically added during invoicing or order entry so those values appear on a transaction report? I have many products with differing cable lengths and want to ultimately calculate how much cable was used periodically.
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