Add AR Sales Tax
Use this service to import Accounts Receivable Sales Tax information.
WSDL: Update_AR_Sales_Tax.jws
Method: Update_AR_Sales_Tax
Underlying File Maintenance
Prior to importing Accounts Receivable Sales Tax information, the following file maintenance areas must be completed:
Assumptions and Dependencies
If the Company_Code is blank then use the Authorization ID default value.
The Accounts Receivable Sales Tax web service will either create a new Sales Tax code or update an existing Sales Tax code. The changes are recorded in the Rate History information.
If the Sales_Tax_Code field does not exist then it will be added.
The Rate History will populate using the current AR processing date and display Initial Entry in the Comments field.
If the Effective_Date and Comments fields are populated they will be ignored since they are used for changes and defined on the Rate History information.
If the Sales_Tax_Code field does exist then it will update all the detail information provided.
The Effective_Date and Comments fields are used for the Rate History information.
Duplicate Effective dates cannot exist for a given Use_Tax_Code.
The service does not delete values that exist in Spectrum; it only changes data defined in the layout.
Comments that exceed the Max character length will be truncated.
Field Descriptions
Use the table below for reference when using this service.
Excel |
Element Name |
Description |
Req |
Type |
Max |
Format |
Validation |
---|---|---|---|---|---|---|---|
Authorization_ID |
Authorization ID to access the server |
YES |
Text |
20 |
Data Exchange Installation Screen |
||
GUID |
Unique reference number created by programming |
Text |
36 |
** See GUID definition |
|||
B |
Company_Code |
Company Code |
YES |
Text |
3 |
Valid Company in Spectrum. Defaults from the Authorization ID if not populated. |
|
C |
Sales_Tax_Code |
Sales tax code |
YES |
Text |
15 |
If it exists then update the information. |
Accounts Receivable Sales Tax Maintenance |
D |
Description |
Description |
Text |
20 |
|||
E |
GL_Account |
G/L account code |
YES |
Numeric |
12 |
Must be a non-direct GL Account. No dashes. |
General Ledger Account Maintenance |
F |
Freight_Tax_Flag |
Tax on freight? |
Text |
1 |
Y(es) or N(o) only. Default to N if blank. |
||
G |
Sales_Tax_Percent |
Tax rate |
Numeric |
7 |
Positive number only. Format = xx.xxxx |
||
H |
Effective_Date |
Effective as of |
Date |
10 |
If left blank then use current processing date. Enter as: MM/DD/CCYY (for example, 01/05/2010). ** See Assumptions and Dependencies |
Must be current or future date for AP Processing date. Rate change cannot exist for the defined date. |
|
I |
Comments |
Comments |
Text |
40 |
** See Assumptions and Dependencies |