Method:Classic General Q&A

Re: CompanyName limit on Customer table

Nick — Tue, 10 Feb 2015 17:27:35 GMT

Thank you Justin

Re: CompanyName limit on Customer table

Method_Justin — Mon, 09 Feb 2015 20:34:03 GMT

Hi Nick,

Due to limitations on the QuickBooks side, it is not possible to change the properties of any core accounting fields in Method. In this specific example, QuickBooks allows 41 characters for the CompanyName field in its Entity table. We adhere to this limitation so to avoid any synchronization conflicts that might result from doing otherwise.

If you'd like, you could create a custom Method-only field to store longer Company Names. You could hide the QuickBooks CompanyName field on screen in Method and auto-populate it with the value from your custom field, truncated to 41 characters, using the Lose Focus event on your custom field. You could then use your custom field for reports, mailers, etc. and still have something that syncs over to QuickBooks.

Hope this helps.

- Justin

CompanyName limit on Customer table

Nick — Mon, 09 Feb 2015 15:54:10 GMT

Hi,

Trying to import external Customer Lead data into Method. I have many customer names that are longer than 41 characters (i.e. the max char limit on CompanyName). I tried to modify the CompanyName field on the Customers table and got an error message "This is a core accounting field and cannot be edited.".

What can I do?

Regards,

Nick