Template: Inventory Adjustment

	Column Name	Required	Default Value	Unique By	Note
Adjustment Transaction	TransactionDate	X		X	Date must be for a period open to inventory.
	SiteID	X		X	Must be a valid & active site ID.
	Reference			X
	AutoCreateNewLots		Allowed
	NegativeAvailableBalances		Not Allowed
	HeaderNote
	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.
	LineItemReasonCode				Must be a valid reason code.
	LineItemNote
Production Batch	ProductionSite	X			Required when new production batch is imported.
	ProductionDate	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.
	BatchComment
	OutsidePurchase
	VendorPurchasedFrom				Must be blank for non lot tracked items.
	BatchClass		No		If entered, the value must be Yes or No. Must be blank for non lot tracked items.
	QualityTestClass				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.