Skip to main content
Solved

60 characters limit on Tax IDs

  • October 31, 2024
  • 6 replies
  • 69 views
Yuri Karpenko
Captain II
Forum|alt.badge.img+6

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!

Best answer by Yuri Karpenko

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

View original
Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP

Yuri Karpenko
Captain II
Forum|alt.badge.img+6

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

Thank you!

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • November 1, 2024

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.

https://community.acumatica.com/archive-281/known-issue-when-the-tax-identifier-on-the-sales-order-was-more-than-30-characters-long-the-following-tax-identifiers-could-not-be-matched-error-occured-during-the-order-synchronization-between-commerce-online-store-and-acumatica-erp-9340?tid=9340&fid=281

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

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Yuri Karpenko
Captain II
Forum|alt.badge.img+6

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

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@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.

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • January 15, 2025

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Yuri Karpenko
Captain II
Forum|alt.badge.img+6

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

Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved