Skip to main content

Hello, our clients who utilize Shopify as order aggregator for Facebook, Instagram, etc. report that the following error happens often:

The following tax IDs received from the external system are too long and cannot be saved: METROPOLITAN ATLANTA RAPID TRANSIT AUTHORITY Local Sales and Use Tax. Map these tax IDs to tax IDs of up to 60 characters in the SPCTAXCODES substitution list on the Substitution Lists (SM206026) form.

Manually fixing these issues is time consuming and our clients fear to expand their marketing on the 3rd party platforms, because many orders will fail importing into Acumatica.

Question:

If we programmatically change the length of the TaxID field to 100 characters, will the error go away? Or do we also need to change some business logic in the code?

Thank you!

@smarenich , @simonliang91 , @KarthikGajendran , can you help with this please?

Thank you!


Hello,

I don’t have an answer but I noticed the same problem happened before and Acumatica fixed it. I hope this leads to a faster solution for you.

I linked a known issue, corrected, from several years ago.  The difference is the length of tax ID’s has grown from previously over 30 characters caused a problem. Now, over 60 characters causes a problem.

On previous versions, Acumatica provided a customization package.

It seems like you are asking for the same customization package again, except make the tax code 100 characters instead of 60.

Laura


@Laura02 , thank you! I saw that thread and will check the solution today,. Thanks for bringing it up here! Have a good Friday!


@Laura02 , I adjusted the customization to have 120 chars limit, but it didn’t work. Still getting the same error in the Sync History screen. I think there is some logic in the connector that needs to be adjusted.


Hi ​@Yuri Karpenko were you able to find a solution? Thank you!


@Chris Hackett , no, we resorted to keep populating the Substitution List with more and more lines.


Reply