Template: Inventory Production

	Column Name	Required	Default Value	Note
Production Transaction	TransactionID		Next Document Number.	The Transaction ID defaults from the default/provided Transaction Class if not provided.
	TransactionDate	X		Date must be for a period open to inventory.
	SiteID	X		Must be a valid & active site ID.
	Reference
	Transaction Class			The default production transaction class is used, if not provided.
	AutoCreateNewLots			The value defaults from the transaction class, if not provided.
	NegativeAvailableBalances			The value defaults from the transaction class, if not provided.
	AutoCreateNewLots-Input			The value defaults from the transaction class, if not provided.
	NegativeAvailableBalances-Input			The value defaults from the transaction class, if not provided.
	HeaderNote
	LineType		Primary	Must be blank, Input, Primary or By Product.
	ItemID	X		Must be a valid item ID.
	LineItemUnits	X		Required if item managed by 'Units Only' or 'Units & Weight'.
	UnitsUOMID		Item's Inventory UOM.	Must contain a valid Units UOM from the Item's UOM schedule.
	LineItemWeight	X		Required if item managed by 'Weight Only' or 'Units & Weight'.
	WeightUOMID		Item's Inventory UOM.	Must contain a valid Weight UOM from the Item's UOM schedule.
	ProductionBatch	X		Required when new production batch is imported. Must be blank for non lot tracked items.
	WarehouseLotID			Must be blank for non warehouse lot tracked sites.
	WorkOrder
	LineItemNote
	LotOwner		Default Owner Preference
Production Batch	BatchProductionSite	X		Required when new production batch is imported.
	BatchDate	X		Required when new production batch is imported.
	ProductionLine			If entered, the value must be a valid production line value. Must be blank for non lot tracked items.
	ProductionShift			If entered, the value must be a valid production shift value. Must be blank for non lot tracked items.
	CountryOfOrigin			If entered, the value must be an active country. Must be blank for non lot tracked items.
	ExpirationDate			If entered, the value must be a valid date. Must be blank for non lot tracked items.
	BatchClass
	QualityTestClass
	BatchComment			Must be blank for non lot tracked items.
	OutsidePurchase		No	If entered, the value must be Yes or No. Must be blank for non lot tracked items.
	VendorPurchasedFrom			Must be blank for non lot tracked items.
	QualityTestID
	Traded		No	If entered, the value must be Yes or No. Must be blank for non lot tracked items.
	Project			If entered, the value must be a valid open project. Must be blank for non lot tracked items.

Note: User defined production transaction and production batch attributes are also displayed in the template.

NorthScope

Template: Inventory Production

Related content