We’ve recently found out that unfortunately the TikTok Shop sales channel with Shopify inserts the entire product title as the tax ID on sales orders.
This causes Acumatica to trip up with “The following tax IDs received from the external system are too long and cannot be saved: Product Sales tax: XXXXX. Map these tax IDs to tax IDs of up to 60 characters in the SPCTAXCODES substitution list on the Substitution Lists (SM206026) form.” errors
Problem is, because TikTok Shop items have such long titles to improve their searchability, per that app’s recommendations, that is very long. These end up exceeding the 130 max character count in the substitution list field, and then that causes the ids to not match and sync to still fail.
With some research, it seemed it should be possible to forcibly truncate the value if it exceeds 60 with a rule like this in sales order entities:
In the above, I’m stuck at which “ERP field” it is. It is not in the dropdown, but we’ve been able to type custom fields here if we get the correct one before. I tried Document.taxID and CurrentDocument.taxID but both didn’t work. Inspecting a sales order for the field didn’t seem to help:
Has anyone successfully targeted TaxID from the sales order entity?
Or do you otherwise have a doable solution for what a tax id comes in from a third party (whose API locks down that field, go figure) that exceeds 130 characters thus cannot accept the full title into the substitution list?
