Add Inventory Cost Adjustments
Use this service to import Inventory Cost Adjustments information.
WSDL: AddInventoryCostAdjustments.jws
Method: AddInventoryCostAdjustments
Underlying File Maintenance
Prior to importing Inventory Cost Adjustments information, the following file maintenance areas must be completed:
Assumptions and Dependencies
The Web Service will not support the following logic:
Items with a 'Not Used' status
Warehouses that have a physical inventory in progress
The Web Service follows the majority of the same logic as manually entering Inventory Cost Adjustments, with the exceptions of the data defined here. The Spectrum Help Files can be used for troubleshooting errors along with the details defined here.
The Transaction Type for all imported transactions will be 'Cost Adjustment'
The import has a record limit of 990 records per Transaction_Reference
The inventory item must exist in the defined warehouse
If Transaction_Reference is blank in the Web Service, then the following logic will apply:
If a Transaction_Reference exists within the unposted Inventory transaction table then the web service will add additional records until it reaches the 990 record limits then create additional Transaction_Reference as needed. A numeric type Transaction_Reference will be added to first then followed by any alpha type Transaction_Reference that exists.
If a Transaction_Reference does not exist within the unposted Inventory transaction table then the web service will follow standard Spectrum logic and create auto-assigned reference numbers
The Cost Adjustment amount must be non-zero and within the qualifying range, based on the Extended Cost of the item in the defined warehouse:
Following recognition of the imported entry, Cost adjustment amount cannot result in the total extended cost being negative (for example, negative adjustment amount cannot exceed the current valuation in the warehouse)
The GL_Credit_Account field defaults from the GL_Department field if left blank and must be a non-direct cost account.
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 |
|
C |
Batch_Code |
Batch code |
YES |
Text |
10 |
If the Batch code exists then records will be added to the existing batch code and Reference # group |
** See Assumptions and Dependencies |
D |
Transaction_Reference |
Reference # |
Text |
7 |
Reference # must not be in use or been used. Limit of 990 records per Reference # |
** See Assumptions and Dependencies |
|
E |
Transaction_Date |
Transaction date |
YES |
Date |
10 |
MM/DD/YYYY Format |
Must be within Inventory Control Processing date range |
F |
From_Warehouse |
Warehouse |
YES |
Text |
10 |
Valid warehouse code in Spectrum |
|
G |
Item_Code |
Item code |
YES |
Text |
15 |
Item must be a valid combination of Inventory Item and Warehouse code |
Valid item code in Spectrum, with a status other than 'Not used' |
H |
Extended_Cost |
Cost adjustment amount |
YES |
Num |
10 |
Format = -6.2 |
** See Assumptions and Dependencies |
I |
Source_Code |
YES |
Text |
2 |
Valid Source code in Spectrum |
||
J |
GL_Department |
Department |
YES |
Text |
4 |
Valid G/L Department code in Spectrum |
|
K |
Reason |
Message |
Text |
30 |
|||
L |
GL_Credit_Account |
G/L credit account |
Num |
12 |
Defaults from Inventory G/L Department if left blank. Must be a non-direct cost account |
Valid G/L account code in Spectrum, with a status other than 'Not used' |