Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Configurable Item (SOC) Export

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: Tue, 27 Jul 2021 14:42



General Information

Default Menu Location Transaction >> Importers/Exporters >> Configurable Item (SOC) Export

Screen Name SOCEXPORT

Function This screen will export the SOC questions and answers for the specified items. This screen is used to generate the import template for the Configurable Item (SOC) Import.

Image



Fields

Class - This field is a range of alphabetically based item classes

Item Range - This field is a range of items to export from

Item Like Block - This field is for searching with multiple "contains" statements. (Example: PR in the first box followed by %BLUE in the second would bring back any SOC items with leading "PR" and "blue" anywhere in the itemcode)

Commodity Code - This field is a range of different commodity codes for items to pull SOC questions from

HeldFor - This will pull SOC questions for any items with that specific HeldFor

Owner - This will pull SOC questions for any items with that specific Owner

Export Format 1 - This will export the data in the format needed for the SOCIMPORT screen.

Export Format 2 - This will export the data in the format needed for the SOCIMPORT2 screen.

Export/Import Template Fields

Note: The column layout is slightly different between the Format 1 and Format 2 options, but the column definitions are the same.

KeyNo - Keyno value of the exported SOC Question. This column should be cleared of all data prior to import, but the column position or header should not be changed.

Item - Item number in Adjutant

QuestNo - SOC question number

Question - SOC question text (maximum 50 characters)

QType - SOC question type code. Valid entries are LIST, TEXT, NUM, and CAL.

RCode - Report code for the associated question. Question 1 should always be report code A. The Length question is always report code B and generally the second question. Some other standard report codes are S=Roof Slope, Q=Square Feet, and W=Weight.

CalcVal - Enter 'Y' to indicate this is a calculated value, which sets the CALC checkbox. Enter 'N' otherwise.

CalcExp - Enter a custom formula using report codes, numerical values, and Excel-style formula codes. An example of the formula structure would be (B/2) + 100.

DecQty - Updates the Dec. Quantity for the associated question. Valid entries are 0 through 5.

InOnly - Enter 'Y' to check the Inches box for the associated question. Either the InOnly or the FtInOnly box should be checked for length questions, but not both.

FtInOnly - Enter 'Y' to check the Ft-Inch box for the associated question. Either the InOnly or the FtInOnly box should be checked for length questions, but not both.

MinLen - Enter the minimum length, if needed, for the length question. Enter 0 if there is no minimum length.

MaxLen - Enter the maximum length, if needed, for the length question. Enter 0 if there is no maximum length.

Inc - Enter the length increment value (in decimal form) to control the valid length entries. For example, to limit length entries by the 16th of an inch, enter 0.0625.

AItem - Additional item number that can be used for contract or special pricing options

Unit - UNit of measure associated with the Additional Item number

PAdjustable - Enter 'Y' to check the Price/Cost Adjust box in the Price and/or Other Adjustment Settings area

PriceAdj - Enter the dollar value for the price adjustment, or if no price adjustment, enter 0

QNum1 - Price/Cost Adjustment question number. Enter the SOC question number to fill in the 'or From Q#' value for the Price/Cost Adjust fields

ConQuest - Enter 'Y' to check the Controlling Qty box

ShowAdj - Enter 'Y' to check the Display Price Adjustment box

OtherAdj - Enter the dollar value for the Other Adjustment field, or if not other adjustment, enter 0.

QNum4 - Other Adjustment question number. Enter the SOC question number to fill in the 'To Q#' value.

QNum2 - Pass 1 question number. Enter the SOC question number to fill in the Pass 1 'Multiply Q#' value.

QNum3 - Pass 2 question number. Enter the SOC question number to fill in the Pass 2 'Adjustment by Q#' value.

CostAdj - Enter the dollar value for the cost adjustment, or if no cost adjustment, enter 0

Spacer1-Spacer10 - The spacer fields are placeholder entries for future expansion. They should not be used.

Ans1-Ans43 - List item descriptive name (max 100 characters) for LIST type questions. 43 list item entries are available for each question. List items display in the order according to the sequence identifier (1-43) on the import.

AnsPA1-AnsPA43 - Price adjustment dollar value for the associated list item.

AnsCA1-AnsCA43 - Cost adjustment dollar value for the associated list item.

AnsOPA1-AnsOPA43 - Other adjustment dollar value for the associated list item.

Item1-Item43 - Additional item number for special or contract pricing for the associated list item.







Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions