Feature - Add Support for Customer Tax Codes to the Mass Change Customer CSV Import
Release date: 5/6/2019
If provided:
If provided:
Version: 8.5 and up
Added support for columns AC, AD, AE (Customer Tax Codes) to the Mass Change Customer CSV Import.
TaxCode1
If provided:
If Global Setup --> Add-Ons --> Vertax Sales Tax --> Use Vertax Sales Tax = "Y," providing a value will produce an error.
Maximum size is 3 characters.
Must be on file in the ARCODES table.
Cannot be the same as Customer file Tax Code2 if TaxCode2 is not provided.
Maximum size is 3 characters.
Must be on file in the ARCODES table.
Cannot be the same as Customer file Tax Code2 if TaxCode2 is not provided.
If TaxCode2 is provided, it cannot match.
Cannot be the same as Customer file Tax Code3 if Taxcode3 is not provided.
If TaxCode3 is provided, it cannot match.
Note: The field is converted to upper case before processing.
$$BLANK$$ option is not applicable and will produce an error.
$$GETTAX$$ option is not allowed if AR Global Control--> Auto Assign Tax Code is not = "Y." If it is = "Y, and $$GETTAX$$ is entered, the ARGETTAX program is called and customer file Tax Code 1, 2, and 3 are filled with the results of that call.
Cannot be the same as Customer file Tax Code3 if Taxcode3 is not provided.
If TaxCode3 is provided, it cannot match.
Note: The field is converted to upper case before processing.
$$BLANK$$ option is not applicable and will produce an error.
$$GETTAX$$ option is not allowed if AR Global Control--> Auto Assign Tax Code is not = "Y." If it is = "Y, and $$GETTAX$$ is entered, the ARGETTAX program is called and customer file Tax Code 1, 2, and 3 are filled with the results of that call.
TaxCode2
If provided:
if Gobal Setup --> Add-Ons --> Vertax Sales Tax --> Use Vertax Sales Tax = "Y", providing a value will produce an error.
Maximum size is 3 characters.
Must be on file in the ARCODES table.
Cannot be the same as Customer file Tax Code 1 if TaxCode1 is not provided.
If TaxCode1 is provided, it cannot match.
Cannot be the same as Customer file Tax Code 3 if TaxCode3 is not provided.
If TaxCode3 is provided, it cannot match.
Note: The field is converted to upper case before processing.
Maximum size is 3 characters.
Must be on file in the ARCODES table.
Cannot be the same as Customer file Tax Code 1 if TaxCode1 is not provided.
If TaxCode1 is provided, it cannot match.
Cannot be the same as Customer file Tax Code 3 if TaxCode3 is not provided.
If TaxCode3 is provided, it cannot match.
Note: The field is converted to upper case before processing.
$$BLANK$$ option is applicable if Customer file Tax Code 3 = Spaces or if provided TaxCode3 = $$BLANK$$. Otherwise $$BLANK$$ should produce an error.
If $$GETTAX$$ is provided in TaxCode1, TaxCode2 should not be provided.
TaxCode3
If provided:
If Global Setup --> Add-Ons --> Vertax Sales Tax --> Use Vertax Sales Tax = "Y", providing a value will produce an error.
Maximum size is 3 characters.
Must be on file in the ARCODES table.
Cannot be the same as Customer File Tax Code 1if TaxCode1 is not provided.
If Global Setup --> Add-Ons --> Vertax Sales Tax --> Use Vertax Sales Tax = "Y", providing a value will produce an error.
Maximum size is 3 characters.
Must be on file in the ARCODES table.
Cannot be the same as Customer File Tax Code 1if TaxCode1 is not provided.
If TaxCode1 is provided, it cannot match.
Cannot be the same as Customer file Tax Code 2 if TaxCode2 is not provided.
If TaxCode2 is provided, it cannot match.
If TaxCode2 was not provided and the current Customer file Tax Code 2 = spaces, this will produce an error.
Note: The field is converted to upper case before processing.
Cannot be the same as Customer file Tax Code 2 if TaxCode2 is not provided.
If TaxCode2 is provided, it cannot match.
If TaxCode2 was not provided and the current Customer file Tax Code 2 = spaces, this will produce an error.
Note: The field is converted to upper case before processing.
$$BLANK$$ option is allowed.
If $$GETTAX$$ is provided in TaxCode1, TaxCode3 should not be provided.
If $$GETTAX$$ is provided in TaxCode1, TaxCode3 should not be provided.
Modified programs: SYCUSMAS, SYCUSMAP
DLM
Related Articles
Change - CSV Import Programs to Support File Names Longer Than 20 Characters
Release date: 5/5/2021 Version 8.5 & Up There were many Elliott CSV Import programs which had a limitation that the maximum file name could not be greater than 20 characters. See the following KB article: ...Avalara - Item Tax Codes
Release Date: 4/28/23 Version: 8.6 and Above Tax codes (_GOODSERVICES attribute) are used to determine what tax category an item belongs to for taxing purposes. Tax codes can be assigned at the product category, user-defined code, and item levels. ...Avalara Attribute Support
Release Date: 4/28/23 Updated: 1/26/28 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...Change Customer Number or Create New Customer and Import Ship-To
Release Date: 02/18/2022 Version: 8.5 & Up Q - We had to create a new customer number for our T&EAZ account. We are doing a web project and the website does not like the "&" symbol that is in this customer number. My question for you is…. Is it ...CP1200 Customer Order Processing Mass Price Change
Mass Price Change Application Overview The Mass Price Change application allows you to modify the prices for a range of items. The program will request a range of item numbers, a specific product category, the percentage of increase or decrease and ...