Skip to main content
Best answer

Quickbooks Custom Field values not accessible

  • December 9, 2020
  • 5 replies
  • 794 views

This has nothing to do with Line, and we’re not sure why “Line” was added to our posting title?

We’re trying to fetch a QuickBooks custom field VALUE located on an Invoice, and pass it to the next action.

We don’t see any Custom Field values.  We only see the ID, Name, and Type.

We’re looking for “Custom Field String Value” but we don’t see it in the list

See screenshot below

 

Best answer by Liz_Roberts

@TPECorp circling back I see that you were able to connect with Support on this and they provided the below workaround and have added you to a Quickbooks feature request. Sharing below to assist other folks:

Workaround:
1. Create invoice that has values in the custom fields
2. Add Find Invoice step as step #2
3. Map the Custom Field String Value field to their paths steps

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Check the data points returned from the QBO trigger step.

If you can find the data point you’re looking for in the trigger step, then make sure you’re searching/scrolling for the same named field in the Filter step of the Zap.


  • Author
  • Beginner
  • 3 replies
  • December 9, 2020

In Quickbooks, the custom field is named Sales Rep and has a value of “AAA”

On the ZAP trigger step, I see the custom fields, but there are no VALUEs on the custom fields.

 

 


Troy Tessalone
Forum|alt.badge.img+14

Did you try searching for “AAA” on the returned trigger data points to see if there is another field that contains the desired data?


  • Author
  • Beginner
  • 3 replies
  • December 10, 2020

For the benefit of others:

I’m using a free plan which has a 15 minute delay when fetching data from the source.

It appears that I was observing a stale value of NULL.

The Custom Field String Value did not appear in the list when containing a NULL value.

The Custom Field String Value does appear in the list when the value is NON NULL.


Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • 1366 replies
  • Answer
  • March 4, 2021

@TPECorp circling back I see that you were able to connect with Support on this and they provided the below workaround and have added you to a Quickbooks feature request. Sharing below to assist other folks:

Workaround:
1. Create invoice that has values in the custom fields
2. Add Find Invoice step as step #2
3. Map the Custom Field String Value field to their paths steps