Method:Classic General Q&A

Re: Custom Field in QB Items Table sync with Method

Method_Inderdeep — Thu, 04 Feb 2016 21:26:49 GMT

I am glad that your issue is resolved now.

-Inder

Re: Custom Field in QB Items Table sync with Method

MikeB — Thu, 04 Feb 2016 19:41:09 GMT

Of course. QB does not let you use more than 5. There's no option to add more.

Anyway, it eventually worked. I'm not sure why it didn't work the first time.

Perhaps there was a syncing lag/issue.

Re: Custom Field in QB Items Table sync with Method

Method_Inderdeep — Thu, 04 Feb 2016 19:08:28 GMT

Hello MikeB,

There first thing I would check is how many custom fields you have in your QB file. The item list has a limit of 5 custom fields in Pro and Premier version. In Enterprise (starting with V10) you can add up to 15 custom fields in the item list.

Please check it and let me know if that is the issue.

-Inder

Custom Field in QB Items Table sync with Method

MikeB — Thu, 04 Feb 2016 15:19:35 GMT

I created a custom field in QB:

The label/name is "SPECIAL ORDER"
When I export the IIF file from QB for the Items table, the field has the official name "CSTFLD4"

In Method, the Column "SPECIAL ORDER" shows up in the Items table, which is good.

However, as a test, I populated an item in QB with a value in the Special Order field, and the value does not sync

Please outline the steaps I need to take to get the values to populate/sync.

I want to to a batch upload to Method for a bunch of special order items, and I want them to sync with QB afterwards.

I have done this sort of thing with a field in the Customer table, but this process is not intuitive and I forget how I managed to get it to work.