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

Items need custom field to indicate if organic and sales, inventory and purchase reports need to be filtered

We need to create a custom field on our Items to reflect if the item is certified organic. We then need to create purchse, sales and inventory reports, filtering for just the organic items. I have created the field on one item, and it is reflecting on inventory reports when I filter for Organic Certified. But I cannot get sales or purchase reports to reflect the same organic item. When I filter for Organic Certified, nothing comes up though I know that there have been transaction with this SKU.

I am on Right Networks hosted QB.

 

1 Comment 1
Clark_B
QuickBooks Team

Items need custom field to indicate if organic and sales, inventory and purchase reports need to be filtered

Thank you for reaching out to the Community, Sally. Let's ensure you'll be able to reflect the same organic item when running the sales or purchase reports.

 

To begin with, you'll have to customize the data layout of your transaction and check the header of the created custom field for it to show in the sales interface. To do so, follow the steps below:

 

  1. Go to your created sales transactions or invoice and then select Formatting.
  2. Choose the Customize Data Layout.
  3. Scroll down and check the created custom field.

 

In my case, I created an invoice and named the field to Sample product, check below for reference:

 

image_720.png

After that, make sure to set up the custom field to Any text to your sales and Purchases forms or Custom Fields for names. Here's how:

 

  1. Go to the Customers menu and select Customer Centers.
  2. Select the specific customer and double-click it.
  3. Go to the Additional Info and select Define Fields.
  4. In the What kind of data dropdown, select Any Text.
  5. Select OK and then click OK again.

 

image_720.png

Once done, you can run the Sales report to check if it reflects. To do so, follow the steps below:

 

  1. Go to the Reports menu and select Sales.
  2. Select Sales by Customer Detail report and click the Customize Report in the Upper middle.
  3. Go to Filters and enter the specific item name.
  4. Select the item and then click OK.
  5. Check if the item shows or reflects in the reports.

 

However, if you're referring to something else, can you please provide more information or a screenshot as a visual guide to explain your scenario more clearly.

 

I'll also add this article to guide you when customizing any report that you generate: Customize reports

 

Please don't hesitate to ask if you have any further questions about the sales or purchase reports to reflect the same organic item. I'm always here to help, Sally. Take care.

Need to get in touch?

Contact us