Issues to Manufacturing Orders (Transaction Type "W")

Use the screens in Production Control to create manufacturing orders. You can view successfully loaded Manufacturing Order (MO) Issue transactions on the Enter Manufacturing Order Issues screen.

Positive issues (reducing inventory quantities) are stored as a negative transaction quantity in the input file. If you provide an MO Requirement line and any matching MO Requirement component line numbers, the system uses them to determine the part, revision, inventory abbreviation, and issue quantity if these values are not provided.

If the part being issued is serial and/or lot controlled, you must include the serial and lot number in the input file line.

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.

Input File

Column Name	Column	Type	Length	Start/End Position	Source	Notes and Defaults
Inventory Transaction Type	S_INVT_TRN_TYPE	Character	1	1	Input file	Required; must be set to W for MO Issue.
Inventory Transaction ID	INVT_TRN_ID	Alphanumeric	10	2 - 11	Input file	If you selected the Use Input File Values option, enter an Inventory Transaction ID. If you selected the Auto-Assign Transaction IDs option, the system will assign the Inventory Transaction ID if the Auto-Assign field is Y for the Issue to MO option for the Warehouse ID in the Transaction IDs subtask of the Manage Warehouses screen.
Manufacturing Order	MO_ID	Alphanumeric	10	12 - 21	Input file	Required; must be valid MO ID.
Material Handler Employee ID	MATL_HNDLR_EMPL_ID	Alphanumeric	12	22 - 33	Input file	Required; must be active and valid employee ID.
Requirement Line Number	RQMT_LN_NO	Numeric	4	34 - 37	Input File	Required if Part ID is not entered.
Part ID	PART_ID	Alphanumeric	30	38 - 67	Input File	Required if Requirement Line Number is not entered. For fixed length file format, limit to 30 characters. For delimited file format, increase field size to 50.
Part Revision ID	PART_RVSN_ID	Numeric	3	68 - 70	Input File	If the Allow Multiple Revisions for Each Item check box is checked in the Product Definition Corporate Settings subtask in Product Definition Settings, a valid Revision ID for the entered part must be entered if Requirement Line Number is not provided. For fixed length file format, limit to 3 characters. For delimited file format, increase field size to 10.
"From" Inventory Location ID	INVT_LOC_ID_FR	Alphanumeric	15	71 - 85	Input file	Required; must be valid Warehouse Location.
Transaction Quantity	TRN_QTY	Numeric/Decimal (14,4) (- 999999999.9999)	15	86 - 100	Input file	Required; negative quantity is a positive issue, and inventory quantity is reduced.
"From" Inventory Abbreviation Code	INVT_ABBRV_ CD_FR	Alphanumeric	6	101 - 106	Input File or MO Requirement's Inventory Abbreviation Code	Required if Requirement Line Number is not entered. For fixed length file format, limit to 6 characters. For delimited file format, increase field size to 20.
Serial Number	SERIAL_ID	Alphanumeric	20	107 - 126	Input File	Required if Part Project and/or Part requires Serial tracking (in the Manage Parts screen in Product Definition).
Lot Number	LOT_ID	Alphanumeric	20	127 - 146	Input File	Required if Part Project and/or Part requires Lot tracking (in the Manage Parts screen in Product Definition).
Consume Reservation	CONSUME_RES_FL	Character	1	147	Input file	If null, is set to Y (Yes).
Material Cost Amount	MATL_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	148 161	Input file	Ignored for positive issues (transaction quantity is negative).
Material Burden Cost Amount	MATL_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	162 - 175	Input file	Ignored for positive issues (transaction quantity is negative).
Labor Cost Amount	LAB_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	176 - 189	Input file	Ignored for positive issues (transaction quantity is negative).
Labor Burden Cost Amount	LAB_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	190 - 203	Input file	Ignored if transaction quantity is negative.
Subcontract Cost Amount	SUBCT_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	204 - 217	Input file	Ignored for positive issues (transaction quantity is negative).
Subcontract Burden Cost Amount	SUBCT_BURD_CST_AMT	Numeric/Decimal (14,4)	14	218 - 231	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 1 Cost Amount	MISC1_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	232 - 245	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 1 Burden Cost Amount	MISC1_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	246 - 259	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 2 Cost Amount	MISC2_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	260 - 273	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 2 Burden Cost Amount	MISC2_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	274 - 287	Input file	Ignored for positive issues (transaction quantity is negative).
Entry User ID	ENTR_USER_ID	Alphanumeric	20	288 - 307	Input File or Process User ID	Use current User ID if null.
Entry Date	ENTR_DTT	Date (MM/DD/YYYY)	10	308 - 317	Input File	Use system current date if null.
"From" Reference Number 1	REF_STRUC_1_ID_FR	Alphanumeric	20	318 - 337	Input file	Must be valid (established in General Ledger).
"From" Reference Number 2	REF_STRUC_2_ID_FR	Alphanumeric	20	338 - 357	Input file	Must be valid (established in General Ledger).
"To" Reference Number 1	REF_STRUC_1_ID_TO	Alphanumeric	20	358 - 377	Input file	Required if From Reference Number 1 is null. Must be valid.
"To" Reference Number 2	REF_STRUC_2_ID_TO	Alphanumeric	20	378 - 397	Input file	Required if From Reference Number 2 is null. Must be valid.
Comments	COMMENT_NT	Alphanumeric	254	398 - 651	Input file
Transaction Date	TRN_DT	Date (MM/DD/YYYY)	10	652 - 661	Input file	If null, set to system current date.

Error Messages

Error Message	Error Condition/ > Solution	Column(s)
The (XXXXXXXXXXXX) field must be entered.	Not supplied in input file.	All Required Fields
A transaction ID must be entered.	You elected to use the input file's Transaction ID (selected the Use Input File Values option on the Import Inventory Transactions screen), but the field is null/space. Enter a transaction ID in theTransaction ID input file field.	Transaction ID
This transaction ID has been used.	You elected to use the input file's Transaction ID (selected the Use Input File Values option on the IImport Inventory Transactions screen), but the Warehouse, Transaction Type, and Transaction ID combination already exists. Enter a transaction ID that has not been used.	Transaction ID
Auto-Assign Transaction IDs not turned on for this warehouse.	You elected to auto-assign the Transaction ID (selected the Auto-Assign Transaction IDs option in the Import Inventory Transactions screen), but Auto-Assign is not turned on for this transaction type/warehouse in the Transaction IDs subtask of the Manage Warehouses screen. Enter a transaction ID in theTransaction ID input file field.	Transaction ID
Transaction date period is not open.	The transaction date is not null and not in an open fiscal year/period/subperiod for inventory posting. Accounting Periodmust be open for inventory in the Accounting Periods screen in General Ledger.	Transaction Date
Current Date period is not open.	The transaction date is null, and the current date is not in an open fiscal year/period/subperiod for inventory posting. Accounting Periodmust be open for inventory in the Accounting Periods screen and Subperiods screen in General Ledger.	Transaction Date
This MO ID is not valid.	The MO ID is invalid.	Manufacturing Order
This MO does not currently allow issues.	The Allow Issue flag for the MO is N. Refer to the Manage Manufacturing Orders screen. The Allow Inventory Issues check boxes must be selected for the MOs.	Manufacturing Order
The XXX does not exist or is inactive.	The employee is invalid or inactive. Enter a valid and active employee ID from the Manage Employee Information screen.	Material Handler Employee
Invalid Part/Rev.	The part/revision does not exist. Enter a valid and active part from the Manage Parts screen in Product Definition.	Part ID/Revision
Inactive Part/Rev.	The part/revision is inactive. Enter a valid and active part from the Manage Parts screen in Product Definition.	Part ID/Revision
Non-Inventory Part/Rev.	The part/revision is non-inventory. Enter an inventory part.	Part ID/Revision
Invalid Part Status.	The part status is Pre-Release or Estimating Only. Enter a released part.	Part ID/Revision
Invalid From Inventory Abbreviation.	The inventory abbreviation code is invalid. Enter a valid and active inventory abbreviation code.	From Inventory Abbreviation Code
Inactive From Inventory Abbreviation.	Active field is N in the Inventory Abbreviations subtask of the Manage Inventory Projects screen. Enter a valid and active inventory abbreviation code.	From Inventory Abbreviation Code
Inactive From Inventory Abbreviation.	Active field is O (inventory can be moved out only) in the Inventory Abbreviations subtask of the Manage Inventory Projects screen, and transaction quantity is a negative issue.	From Inventory Abbreviation Code
Invalid Inventory Location.	Invalid inventory warehouse/location. Enter a valid inventory warehouse/location from the Manage Locations screen in Inventory.	From Inventory Location
Invalid Inventory Location Type.	Location type cannot be I (Incoming inspection) or M (MRB). Enter a valid location.	From Inventory Location
Either a part or MO Rqmt line must be entered.	Part is null and MO requirement line is null.
Either a From Inv Abbrev or MO Rqmt line must be entered.	From inventory abbreviation is null, and MO requirement line is null.
Inv Abbrev does not allow issues to other projects.	From Project (From Inventory Abbreviation)/To Project (MO's Build To Project ID) do not match; From project does not allow outside issues and adjustments. Refer to the From project's No Issues/Adj Outside Project Allowed option in the Issues/Adjustments Options group box in the Manage Inventory Projects screen.
Inv Abbrev does not allow issues to other top-level projects.	From Project (From Inventory Abbreviation)/To Project (MO's Build To Project ID) do not match; From/To projects do not have the same top-level project; and From project allows issues and adjustments only within the same top-level project. Refer to the From project'sAllow Issues/Adj Within Top-Level Project option in the Issues/Adjustments Options group box in the Manage Inventory Projects screen.
Inv Abbrev does not allow issues to other netting groups.	From Project (From Inventory Abbreviation)/To Project (MO's Build To Project ID) do not match; From/To projects do not have the same netting group; and From project allows issues and adjustments only within the same netting group. Refer to the From project's Allow Issues/Adj Within Netting Group Only option in the Issues/Adjustments Options group box in the Manage Inventory Projects screen.
Location Quantity is less than transaction quantity.	Not enough quantity in inventory to issue on the transaction.
Serial Number is required.	Serial number is null, and part/project or part (if part project does not exist) requires a serial number. Enter a valid serial number for the part/project.
Lot Number is required.	Lot is null, and part/project or part (if part project does not exist) requires a lot number. Enter a valid lot number for the part/project.
Serial/Lot Quantity is less than transaction quantity.	Serial/Lot is not null. Not enough quantity for the serial or lot to cover for this serial/lot to issue quantity entered.
Input files with serial numbers can only have a transaction quantity of 1.	Serial Number is not null, and transaction quantity is greater than 1.
Invalid ENTR USER ID in W USER UGRP LIST	Input file ENTR_USR_ID no null, and value does not match any row Web - compare with W_USER_UGRP_LIST.SEC_OBJ_ID for company of user executing the process.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Issues to Manufacturing Orders (Transaction Type "W")

Use the screens in Production Control to create manufacturing orders. You can view successfully loaded Manufacturing Order (MO) Issue transactions on the Enter Manufacturing Order Issues screen.

Positive issues (reducing inventory quantities) are stored as a negative transaction quantity in the input file. If you provide an MO Requirement line and any matching MO Requirement component line numbers, the system uses them to determine the part, revision, inventory abbreviation, and issue quantity if these values are not provided.

If the part being issued is serial and/or lot controlled, you must include the serial and lot number in the input file line.

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.

Costpoint 8.1 Developer Resources
Costpoint 8.2 Developer Resources

Input File

Column Name	Column	Type	Length	Start/End Position	Source	Notes and Defaults
Inventory Transaction Type	S_INVT_TRN_TYPE	Character	1	1	Input file	Required; must be set to W for MO Issue.
Inventory Transaction ID	INVT_TRN_ID	Alphanumeric	10	2 - 11	Input file	If you selected the Use Input File Values option, enter an Inventory Transaction ID. If you selected the Auto-Assign Transaction IDs option, the system will assign the Inventory Transaction ID if the Auto-Assign field is Y for the Issue to MO option for the Warehouse ID in the Transaction IDs subtask of the Manage Warehouses screen.
Manufacturing Order	MO_ID	Alphanumeric	10	12 - 21	Input file	Required; must be valid MO ID.
Material Handler Employee ID	MATL_HNDLR_EMPL_ID	Alphanumeric	12	22 - 33	Input file	Required; must be active and valid employee ID.
Requirement Line Number	RQMT_LN_NO	Numeric	4	34 - 37	Input File	Required if Part ID is not entered.
Part ID	PART_ID	Alphanumeric	30	38 - 67	Input File	Required if Requirement Line Number is not entered. For fixed length file format, limit to 30 characters. For delimited file format, increase field size to 50.
Part Revision ID	PART_RVSN_ID	Numeric	3	68 - 70	Input File	If the Allow Multiple Revisions for Each Item check box is checked in the Product Definition Corporate Settings subtask in Product Definition Settings, a valid Revision ID for the entered part must be entered if Requirement Line Number is not provided. For fixed length file format, limit to 3 characters. For delimited file format, increase field size to 10.
"From" Inventory Location ID	INVT_LOC_ID_FR	Alphanumeric	15	71 - 85	Input file	Required; must be valid Warehouse Location.
Transaction Quantity	TRN_QTY	Numeric/Decimal (14,4) (- 999999999.9999)	15	86 - 100	Input file	Required; negative quantity is a positive issue, and inventory quantity is reduced.
"From" Inventory Abbreviation Code	INVT_ABBRV_ CD_FR	Alphanumeric	6	101 - 106	Input File or MO Requirement's Inventory Abbreviation Code	Required if Requirement Line Number is not entered. For fixed length file format, limit to 6 characters. For delimited file format, increase field size to 20.
Serial Number	SERIAL_ID	Alphanumeric	20	107 - 126	Input File	Required if Part Project and/or Part requires Serial tracking (in the Manage Parts screen in Product Definition).
Lot Number	LOT_ID	Alphanumeric	20	127 - 146	Input File	Required if Part Project and/or Part requires Lot tracking (in the Manage Parts screen in Product Definition).
Consume Reservation	CONSUME_RES_FL	Character	1	147	Input file	If null, is set to Y (Yes).
Material Cost Amount	MATL_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	148 161	Input file	Ignored for positive issues (transaction quantity is negative).
Material Burden Cost Amount	MATL_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	162 - 175	Input file	Ignored for positive issues (transaction quantity is negative).
Labor Cost Amount	LAB_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	176 - 189	Input file	Ignored for positive issues (transaction quantity is negative).
Labor Burden Cost Amount	LAB_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	190 - 203	Input file	Ignored if transaction quantity is negative.
Subcontract Cost Amount	SUBCT_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	204 - 217	Input file	Ignored for positive issues (transaction quantity is negative).
Subcontract Burden Cost Amount	SUBCT_BURD_CST_AMT	Numeric/Decimal (14,4)	14	218 - 231	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 1 Cost Amount	MISC1_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	232 - 245	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 1 Burden Cost Amount	MISC1_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	246 - 259	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 2 Cost Amount	MISC2_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	260 - 273	Input file	Ignored for positive issues (transaction quantity is negative).
Miscellaneous 2 Burden Cost Amount	MISC2_BURD_CST_AMT	Numeric/Decimal (14,4) (999999999.9999)	14	274 - 287	Input file	Ignored for positive issues (transaction quantity is negative).
Entry User ID	ENTR_USER_ID	Alphanumeric	20	288 - 307	Input File or Process User ID	Use current User ID if null.
Entry Date	ENTR_DTT	Date (MM/DD/YYYY)	10	308 - 317	Input File	Use system current date if null.
"From" Reference Number 1	REF_STRUC_1_ID_FR	Alphanumeric	20	318 - 337	Input file	Must be valid (established in General Ledger).
"From" Reference Number 2	REF_STRUC_2_ID_FR	Alphanumeric	20	338 - 357	Input file	Must be valid (established in General Ledger).
"To" Reference Number 1	REF_STRUC_1_ID_TO	Alphanumeric	20	358 - 377	Input file	Required if From Reference Number 1 is null. Must be valid.
"To" Reference Number 2	REF_STRUC_2_ID_TO	Alphanumeric	20	378 - 397	Input file	Required if From Reference Number 2 is null. Must be valid.
Comments	COMMENT_NT	Alphanumeric	254	398 - 651	Input file
Transaction Date	TRN_DT	Date (MM/DD/YYYY)	10	652 - 661	Input file	If null, set to system current date.

Error Messages

Error Message	Error Condition/ > Solution	Column(s)
The (XXXXXXXXXXXX) field must be entered.	Not supplied in input file.	All Required Fields
A transaction ID must be entered.	You elected to use the input file's Transaction ID (selected the Use Input File Values option on the Import Inventory Transactions screen), but the field is null/space. Enter a transaction ID in theTransaction ID input file field.	Transaction ID
This transaction ID has been used.	You elected to use the input file's Transaction ID (selected the Use Input File Values option on the IImport Inventory Transactions screen), but the Warehouse, Transaction Type, and Transaction ID combination already exists. Enter a transaction ID that has not been used.	Transaction ID
Auto-Assign Transaction IDs not turned on for this warehouse.	You elected to auto-assign the Transaction ID (selected the Auto-Assign Transaction IDs option in the Import Inventory Transactions screen), but Auto-Assign is not turned on for this transaction type/warehouse in the Transaction IDs subtask of the Manage Warehouses screen. Enter a transaction ID in theTransaction ID input file field.	Transaction ID
Transaction date period is not open.	The transaction date is not null and not in an open fiscal year/period/subperiod for inventory posting. Accounting Periodmust be open for inventory in the Accounting Periods screen in General Ledger.	Transaction Date
Current Date period is not open.	The transaction date is null, and the current date is not in an open fiscal year/period/subperiod for inventory posting. Accounting Periodmust be open for inventory in the Accounting Periods screen and Subperiods screen in General Ledger.	Transaction Date
This MO ID is not valid.	The MO ID is invalid.	Manufacturing Order
This MO does not currently allow issues.	The Allow Issue flag for the MO is N. Refer to the Manage Manufacturing Orders screen. The Allow Inventory Issues check boxes must be selected for the MOs.	Manufacturing Order
The XXX does not exist or is inactive.	The employee is invalid or inactive. Enter a valid and active employee ID from the Manage Employee Information screen.	Material Handler Employee
Invalid Part/Rev.	The part/revision does not exist. Enter a valid and active part from the Manage Parts screen in Product Definition.	Part ID/Revision
Inactive Part/Rev.	The part/revision is inactive. Enter a valid and active part from the Manage Parts screen in Product Definition.	Part ID/Revision
Non-Inventory Part/Rev.	The part/revision is non-inventory. Enter an inventory part.	Part ID/Revision
Invalid Part Status.	The part status is Pre-Release or Estimating Only. Enter a released part.	Part ID/Revision
Invalid From Inventory Abbreviation.	The inventory abbreviation code is invalid. Enter a valid and active inventory abbreviation code.	From Inventory Abbreviation Code
Inactive From Inventory Abbreviation.	Active field is N in the Inventory Abbreviations subtask of the Manage Inventory Projects screen. Enter a valid and active inventory abbreviation code.	From Inventory Abbreviation Code
Inactive From Inventory Abbreviation.	Active field is O (inventory can be moved out only) in the Inventory Abbreviations subtask of the Manage Inventory Projects screen, and transaction quantity is a negative issue.	From Inventory Abbreviation Code
Invalid Inventory Location.	Invalid inventory warehouse/location. Enter a valid inventory warehouse/location from the Manage Locations screen in Inventory.	From Inventory Location
Invalid Inventory Location Type.	Location type cannot be I (Incoming inspection) or M (MRB). Enter a valid location.	From Inventory Location
Either a part or MO Rqmt line must be entered.	Part is null and MO requirement line is null.
Either a From Inv Abbrev or MO Rqmt line must be entered.	From inventory abbreviation is null, and MO requirement line is null.
Inv Abbrev does not allow issues to other projects.	From Project (From Inventory Abbreviation)/To Project (MO's Build To Project ID) do not match; From project does not allow outside issues and adjustments. Refer to the From project's No Issues/Adj Outside Project Allowed option in the Issues/Adjustments Options group box in the Manage Inventory Projects screen.
Inv Abbrev does not allow issues to other top-level projects.	From Project (From Inventory Abbreviation)/To Project (MO's Build To Project ID) do not match; From/To projects do not have the same top-level project; and From project allows issues and adjustments only within the same top-level project. Refer to the From project'sAllow Issues/Adj Within Top-Level Project option in the Issues/Adjustments Options group box in the Manage Inventory Projects screen.
Inv Abbrev does not allow issues to other netting groups.	From Project (From Inventory Abbreviation)/To Project (MO's Build To Project ID) do not match; From/To projects do not have the same netting group; and From project allows issues and adjustments only within the same netting group. Refer to the From project's Allow Issues/Adj Within Netting Group Only option in the Issues/Adjustments Options group box in the Manage Inventory Projects screen.
Location Quantity is less than transaction quantity.	Not enough quantity in inventory to issue on the transaction.
Serial Number is required.	Serial number is null, and part/project or part (if part project does not exist) requires a serial number. Enter a valid serial number for the part/project.
Lot Number is required.	Lot is null, and part/project or part (if part project does not exist) requires a lot number. Enter a valid lot number for the part/project.
Serial/Lot Quantity is less than transaction quantity.	Serial/Lot is not null. Not enough quantity for the serial or lot to cover for this serial/lot to issue quantity entered.
Input files with serial numbers can only have a transaction quantity of 1.	Serial Number is not null, and transaction quantity is greater than 1.
Invalid ENTR USER ID in W USER UGRP LIST	Input file ENTR_USR_ID no null, and value does not match any row Web - compare with W_USER_UGRP_LIST.SEC_OBJ_ID for company of user executing the process.