Versions Compared

Old Version 1

changes.mady.by.user Kati Huttunen (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Kati Huttunen (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 

Column NameRequiredDefault Value
Unique By
Note
Adjustment
  Transaction
TransactionTransacctionID
Next Document Number.The Transaction ID defaults from the default/provided Transaction Class if not provided. 
TransactionDateX 
X
Date must be for a
 
period open to inventory.
SiteIDX 
X
Must be a valid &
  active
 active site ID.
Reference  
X
 
AutoCreateNewLots
Transaction Class

The default Adjustment transaction class is used, if not provided. 
Allowed
AutoCreateNewLots 
 The value defaults from the transaction class if not provided. 
NegativeAvailableBalances 
Not Allowed 

 The value defaults from the transaction class if not provided. 
HeaderNote   
 
ItemIDX 
 
Must be a valid
item   ID
item ID.
LineItemUnitsX
 
 Required if
item   managed
item managed by 'Units Only' or 'Units & Weight'.
UnitsUOMID Item's Inventory UOM.
 
Must contain a
valid   Units
valid Units UOM from the Item's UOM schedule. 
LineItemWeightX 
 
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. 
ProductionBatchX
 
 Required when
new   production
new production batch is imported. Must be blank for non lot tracked items. 
WarehouseLotID  
 
Must be blank for
non   warehouse
non warehouse lot tracked sites. 
LineItemReasonCode
 
  Must be a
valid   reason
valid reason code. 
LineItemNote   
 LotOwner  Preference Default Owner 

Production

 

Batch

          

ProductionSite
BatchProductionSiteX 
 
Required when
new   production
new production batch is imported.
ProductionDate
BatchDateX 
 
Required when
new   production
new production batch is imported.
ProductionLine  
 
If entered, the
value   must
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
value must be an active country. Must be blank for non lot tracked items. 
ExpirationDate  
 
If entered, the
value   must
value must be a valid date. Must be blank for non lot tracked items. 
BatchComment
 
   
OutsidePurchase
 
   
VendorPurchasedFrom  
 
Must be blank for
non   lot
non lot tracked items. 
BatchClass No
 
If entered, the
value   must
value must be Yes or No. Must be blank for non lot tracked items. 
QualityTestClass  
 
Must be blank for
non   lot
non lot tracked items. 
QualityTestID   
 
Traded No
 
If entered, the
value   must
value must be Yes or No. Must be blank for non lot tracked items. 
Project  
 
If entered, the
value   must
value must be a valid open project. Must be blank for non lot tracked items. 


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