Deletes the transaction, batch, or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

_{WARNING: Records cannot be recovered once they are deleted!}

 Allows users to select the type of transaction or record they want to add. The drop-down displays all active Production type transaction classes configured in the system.

Identifies the date of the transaction. This is a date picker that is required. If missing, the message "Transaction Date is required" will be displayed on Save. It defaults to the current date, formatted from the users 'Date Format' preference. This field is always editable while the transaction is in a Status of 'New'. 

Database Field: ERPx_IMTransactionHeader.TransactionDate

Identifies the Reference entered for the transaction.  This is a text box that is not required. It defaults as blank. If entered, this field must be <= 100 characters. This field is always editable while the transaction is in a Status of 'New'. The value entered in this field will act as a default Line Reference value for all line items after the transaction is saved.

Database Field: ERPx_IMTransactionHeader.Reference

Identifies the name of the Site (Warehouse) that the transaction, shipment, receipt, item, or lot is associated with. This is a single-select standard lookup that is required. If missing, the message "Site is required." will be displayed on Save. This defaults as blank and is not editable after initial Save. 

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances.

The lookup contains a list of all the 'Active' Inventory Sites.

Database Fields: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.SiteSK

Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type.  The Statuses that apply to transactions in this List View include:

New: This is the default Status for all new Transactions. While in the Status of 'New' transactions are considered open and all editable fields are open for edit, no posting or approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist.  

Approved: Performs all the data validations required to post the transaction and applies to all Transactions. While in the Status of 'Approved' transactions are considered open but have limited fields open for edit. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), journal entries are created/updated, journal ID's are assigned to the journal entry, and blank 'GL Dates' are assigned.

Ready to Post: Runs the Approval validations and applies to all transactions. While in the Status of 'Ready to Post' transactions are considered closed and all the fields are disabled with the exception of a few fields that are always editable. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled with the exception any fields that are always editable and updates the Transaction Status to "Posted".

Database Fields: ERPx_IMTransactionStatus.TransactionStatusName, ERPx_IMTransactionHeader.TransactionStatusSK

The unique identifier of the Transaction Class. This is a non-editable text box that is required and defaults to the Production Transaction Class that was selected/specified when creating the transaction. This field is never editable. 

Database Fields: ERPx_IMTransactionClass.TransactionClassID, ERPx_IMTransactionClass.TransactionClassID

Identifies the unit of measure that will be used to calculate the Yield %. All line item quantities will be converted to this UOM to calculate yield.
  This is an editable text box that is required. It defaults from the Yield UOM specified on the corresponding Production Order (if assigned), else it defaults from the corresponding transaction class assigned to the Production transaction.  It is editable while the transaction is in a status of 'New'. If this value is changed the yield quantities will be recalculated. 

Database Fields: ERPx_IMProductionOrderHeader.YieldUOMSK

A non editable text box that shows the name of the Attribute. Attributes are user-definable fields that are used on master files and transactions and are editable from the Attributes List View. The Attribute will only be displayed if the Applies property on the Assign Attribute Rules by page is set to either "Yes - Required" or "Yes - Not Required". Attributes set to "No" will not be displayed. The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Inventory). 

 A non-editable text box that shows whether the Attribute Value is required or not. If the Attribute Value is required, it will display "Yes". If it is optional, it will display as blank. This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → Inventory → Transactions hyperlink → Inventory - Production). 

Identifies the value assigned to the corresponding attribute.

Because Attributes are configurable as either Text, List, Date, or Date/Time the data entry is either a text box, lookup, or date picker. The value defaults to blank and is only required if the Attribute's 'Applies' property is set to "Yes - Required" in the Assign Attribute Rules page. Attribute Values for Master Flies are always editable. Attribute Values for transactions are always editable for unposted transactions.

 Adds a new line in the grid with a line type of Input to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item. This toolbar icon is only enabled when the transaction status is New.

 Opens the Find Inventory Lots page in a new window. This feature allows users to find existing lots and view their on hand and available balances. This toolbar icon is only enabled when the transaction status is New. When a lot is added to a transaction from the Find Inventory Lots page it is added as an 'Input' line type. 

Opens the mass update dialog, which allows to mass update the following properties: 

•  Transaction
  • Production Batch - This may only be updated if the Item is Lot tracked and if the Status of the transaction is 'New'.  Else the message "Production Batch may only be updated for transactions in the status of New." will be displayed on Save. 
  • Warehouse Lot - This may only be updated if the Site is warehouse lot tracked and if the Status of the transaction is 'New'. Else the message "Warehouse Lot may only be updated for transactions in the status of New." will be displayed on Save.
  • Include in Yield - This may only be updated if the Status of the transaction is 'New'. Else the message "Include in Yield may only be updated for transactions in the status of New." will be displayed on Save.
• Production Batch Properties
  • Batch Date, Batch Expiration Date, Batch Comment and Country of Origin
• Production Batch Attributes
  • Each Batch Attribute will be available
• Production Batch Certifications
  • Each applicable certification will be available
• Warehouse Lot Properties
  
  • Storage Begin Date
  • Storage Renewal Day
• Warehouse Lot Attributes
  • Each Warehouse Lot Attribute will be available

 Production Batch Properties and Attributes will only be updated via Mass Update when the Production Batch value is saved. 

 Warehouse Lot Properties and Attributes will only be updated via Mass Update when the Warehouse Lot value is saved.

This toolbar icon is always enabled.

 Displays a drop down menu of related actions. The list of options includes: 

• LV: Warehouse Lot - Opens the Warehouse Lot List View, in a new tab, filtered for the selected record's Warehouse Lot. This is only applicable to Warehouse Lot tracked Sites where a Warehouse Lot value has been saved, else the message "No Warehouse Lot exists for this item." is displayed. 
• RV: Item - Open the item Record View for the selected item.
• RV: Production Batch - Open the Production Batch Record View for the selected line item.  This is only applicable to Lot tracked Items where a Production Batch value has been saved, else the message "No Production Batch exists for this item." is displayed. 

Displays the batch comment assigned to the corresponding Production Batch. This is a non-editable textbox that is not required.  It defaults from the corresponding Production Batch record for an existing lot if a value exists, else it defaults to blank.  This can be edited from the Production Batch Record View or via Mass Update. 

Database Field: ERPx_IMProductionLot.LotComment

Displays the date the Production Batch was produced, formatted from the users 'Date Format' preference. This is the date used to age the product. This is a non-editable textbox that defaults to the Batch Date from the corresponding Production Batch record for an existing lot if a value exists, else it defaults to the transaction's 'Date' value on Save. This can be edited from the 'Batch Date' field on the Properties tab of the Production Batch record view or via Mass Update.

Database Field: ERPx_IMProductionLot.DateProduced

Displays the "Batch Expiration Date" assigned to the Production Batch. This defaults by adding the value set on the Item's 'Expiration Days' to the 'Batch Date' assigned to the Production Batch.  This is a non-editable textbox that is not required.  It defaults from the corresponding Production Batch record for an existing lot if a value exists, else it defaults to blank.  This can be edited from the Production Batch Record View or via Mass Update. 

Database Field: ERPx_IMProductionLot.ExpirationDate

Displays the name of the Country that the Production Batch originated in. The value is stored in the 'Country of Origin' Tab on the Production Batch Record View. If no 'Country of Origin' has been assigned, this will be blank, if there is only one 'Country of Origin' assigned to the Production Batch then the name of that country will be displayed. If there is more than one country assigned on the 'Country of Origin' Tab then this will indicate "Multiple". This is editable from the 'Country of Origin' tab on the Production Batch Record View or via Mass Update. 

The Country of Origin identifies the country that produced the product. It is stored on the Production Batch and a Production Batch can have more than one Country assigned. 

Database Field: ERPx_IMProductionLot.CountryOfOrigin

Identifies the Item, displayed as Item ID: Item Description.  This is a text box that is required. It defaults as blank and is not editable once the line item has been saved to the transaction.

When the 'Add Item' icon is clicked, users may enter all or part of an Item ID or Description and hit the Enter key on the keyboard. If a complete Item ID was entered, the line item will be saved, if not, the Item Lookup dialog box will open with a list of items containing the data entered. From the 'Item Lookup' dialog box, users may check the checkbox next to one or multiple item(s) to add to the transaction using the Save & Close button.

Item IDs are the unique identifier for Items. 

The lookup contains a list of all active Inventory type Items in the Item Master File.

 Selecting an Item will default the 'Inventory Unit UOM' and 'Inventory Weight UOM' properties specified on the Item Record View.

Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_IMTransactionDetail.ItemSK

Identifies the type of the line item. This is a single-select standard lookup that is required. It defaults to "Output", but can be changed to By-Product, and is always editable.

This lookup contains all the values in the IMLineItemType Enumeration Class where Enumeration Value = 1,3.

Database Field: ERPx_IMTransactionDetail.LineItemTypeEN

In some instances the Production transaction is used to enter production results in bulk, across multiple Work Orders. When this occurs, assigning the Work Order as the default 'Work Order' on the transaction header would not work. In situations like this, the Work Order can be specifically assigned to each line item. This is a text box that is not required. This field defaults from the 'Work Order' field in the 'Home' tab of this Record View. This field is always editable while the transaction is in a Status of 'New'. This field must be <= 100 characters.

A Work Order is used to link multiple transactions together, usually for Lot Tracing and/or yield analysis. Unlike a Production Order which is a NorthScope object, a work order is a free text field. 

Database Field: ERPx_IMTransactionDetail.WorkOrder

Identifies the Line # for each Transaction Line Item. The Line # sets the sort of the items on grids, list views, inquiries, and reports. This is an editable text box that defaults to the next available base-10 number per Line Type. It is required, and is editable while the transaction is in a Status of "New". To re-sequence the line items, edit one or more lines with a new positive number that would put the line item where you want it sorted, and click the Save button. On save, the line items will be resorted per Line Type, and the Ln. values will be re-set to base-10 values.

For example, if you had three Input line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e., 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30).

Note: Since the Ln. values are per Line Type, it is possible to have duplicate Ln. values across the types. 

Database Fields: ERPx_IMTransactionDetail.IMItemSort, ERPx_IMTransactionDetail.IMItemSortOverride

Identifies whether or not item balances are maintained for "Production Batches". This is a non-editable text box that is not required. This value defaults from the 'Lot Tracked' field in the 'Properties' tab of the Item Record View. It displays as "Yes" if the line item is a lot tracked item. It displays as blank if the item is not a lot tracked item. This field is for informational use only and cannot be edited.   

Database Fields: ERPx_IMItem.TrackMethodEN, ERPx_IMTransactionDetail.ItemSK

Identifies the Production Batch ID of the Lot. This is a text box that is only required to save a line item on a transaction in 'Approved' or greater status if the item selected is Lot Tracked. It defaults as blank and is only editable if the selected item is Lot Tracked and the transaction is in a Status of 'New'. This field must be <= 50 characters.

A Production Batch is the identifier that contains all the Traceability information (Production Batch Properties and Attributes) for Lot Tracked Items. This number stays attached to the product, even if it is transferred to another Site. Production Batch is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line for a Lot Tracked Item. This value will be blank and/or disabled for all non-Lot Tracked items on screens that include a Production Batch field.

Database Fields: ERPx_IMProductionLot.ProductionLotID, ERPx_IMTransactionDetail.ItemSK

Identifies the date a cold storage began (or will begin) charging storage. This is typically set to a value of one month after the initial receipt date. Cold Storages typically charge for both "Storage" and "Handling", and this is the date the storage portion begins. Storage is typically billed monthly and is calculated by multiply a pre-determined storage rate * Lbs in the Warehouse Lot. This defaults to the value saved on the Warehouse Lot record if one exists, else it is blank.  It is never editable on the grid of this page, however users can mass update a value for a line item that has a Warehouse Lot value saved, and this value can be edited on the Warehouse Lots List View. 

Database Field: ERPx_IMWarehouseLot.StorageBeginDate

Identifies the day of the month that the cold storage will bill for a Warehouse Lot. If there are any quantity balances remaining on that day, a new storage bill will be issued.
 This defaults to the value saved on the Warehouse Lot record if one exists, else it is blank.  It is never editable on the grid of this page, however users can mass update a value for a line item that has a Warehouse Lot value saved, and this value can be edited on the Warehouse Lots List View.  It must be a number between 1 - 31 that represents the day of the 'Storage Begin Date'. If a Storage Begin Date is provided and the Storage Renewal Day is blank, the value will be automatically calculated and assigned.  For example, if the Storage Begin Date = 02/26/2024, the Storage Renewal Day would be 26.  Users cannot enter 0 as a value, but the field is not required and may be blank.

Database Field: ERPx_IMWarehouseLot.StorageRenewalDay

Identifies the number of units to be added or subtracted for the corresponding item in the inventory lot.This is a numeric text box that is sometimes required. This field is required and editable only if the item is managed by Units Only or Units or Weight. This field defaults to 0 and is always editable while the transaction is in a Status of 'New'. This field can be both positive or negative. This field will display the number of decimals set for the selected item on the 'Unit Decimals' property on the 'Properties' tab of the Item Record View. If this field is editable, the following will be enforced:

• For an item that is fixed weight and requires whole units:

  • When Units are entered: the value will be rounded up to the nearest integer then the Weight will automatically be calculated based on the Units integer value.

• For an item that is fixed weight and does not require whole units:

  • When Units are entered: the Weight will automatically be calculated based on the Units value. The Units value does not have to be an integer.

• For an item that is variable weight and requires whole units:

  • When Units go from empty to a value: the value will be rounded up to the nearest integer then the Weight will automatically be calculated based on the Units integer value.

  • When Units go from one value to another: the value will be rounded up to the nearest integer but the Weight will NOT be recalculated.

 If Units are edited and the Line Source is either 'BOM' or 'Production Order BOM', the 'BOM Qty Override' field will be set to 'Yes'.  Additionally, the Units value will not recalculate if the related BOM Output item's Quantity is edited. 

'Units' and 'Unit UOM' fields will always display as the values entered by the user. However for consistency, Units that are saved using a UOM that is different than the 'Inventory Unit UOM' will be converted and subsequently stored in the default Inventory Unit UOM. 

Database Field: ERPx_IMTransactionDetail.TransactionUnits

Identifies the unit of measure that the units are stored in (Box, Bag, Case, Each, Tote, etc.) for a line item or on the transaction. This is a single-select standard lookup that is required to save a line item on transactions with a Status of 'Approved' or greater. This field will be disabled if the item is managed by Weight Only. If enabled, it will default from the 'Inventory Unit UOM' property on the 'Properties' tab of the Item Record View for the selected Item. If enabled, this field will be editable while the transaction is in a Status of 'New'.

This lookup contains all 'Active' Unit UOMs on the selected Item's UOM Schedule.

A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionUnitsUOMSK

Identifies the Warehouse Lot to which the selected item or inventory lot belongs. This is a single-select standard lookup that is sometimes required to save a line item on transactions with a Status of 'Approved' or greater. It is required when the 'Site', identified on the transaction header, is a warehouse lot tracked Site and is disabled when it is not. If required and blank, the message "Warehouse Lot is required for Warehouse Lot Tracked sites when Approving or Posting." will be displayed on Save of Statuses of 'Approved' or greater. This field defaults as blank and will be disabled if the 'Site' field on the transaction is not warehouse lot tracked. If enabled, this field is editable via the Mass Update Dialog while the transaction is in a Status of 'New'. This field must be <= 50 characters.

The transaction will validate the Warehouse Lot based on the following:

• If the selected Site is warehouse lot tracked and allows multiple items, the transaction will allow multiple items to be coded to the same warehouse lot and will create the warehouse lot with the default item selection of 'All Items Selected'.
• If the selected Site is warehouse lot tracked and allows multiple items and the warehouse lot ID entered for an item on the transaction already exists, the transaction will verify the warehouse lot is either set to 'All Items Selected' or the specific item is selected.
• If the selected Site is warehouse lot tracked and only allows single items, the transaction will restrict multiple items from being coded to the same warehouse lot and it will create the warehouse lot for the first item code on the transaction and will prompt an error for the next item trying to save to the same warehouse lot.
• If the selected Site is warehouse lot tracked and only allows single item and the warehouse lot ID entered for an item on the transaction already exists, the transaction will verify the warehouse lot is set to the specific item that is selected.
• If the selected site is not warehouse lot tracked, no warehouse lots can be entered.

A Warehouse Lot (aka Storage Lot) is used by 3rd party distribution sites to identify a unique quantity of product they are storing. Unlike a Production Batch number that never changes, Warehouse Lots will change as product is transferred to other Sites and/or transferred into exiting Warehouse Lots within the same Site. The 'Warehouse Lot' is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line on a transaction for a Warehouse Lot Tracked Site. This value will be blank and/or disabled for all non-Warehouse Lot Tracked Sites on screens that include a Warehouse Lot field.

Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK

Identifies the weight amount to be added or subtracted for the corresponding item in the inventory lot. This is a numeric text box that is sometimes required. This field is required and editable only if the item is managed by Weight Only or Units or Weight Only. This field defaults to 0 and is editable while the transaction is in a Status of 'New'. This field can be both positive or negative. Once an item has been selected, this field will display with the number of decimals set for the 'Weight Decimals' property on the 'Properties' tab of the Item Record View. If this field is editable, the following will be enforced:

• For an item that is fixed weight and requires whole units:

  • When Weight is entered: the value will be rounded up to the nearest Weight that results in a whole Unit then the Units will automatically be calculated based on the Weight value.

• For an item that is fixed weight and does not require whole units:

  • When Weight is entered: the Units will automatically be calculated based on the Weight value. The Weight value does not have to result in an integer Units value. However, because the Units and Weight values round to two decimal places, if the rounded Units value produced by the weight value does not convert to equal the weight value, the weight value will automatically update to equal the converted value of the units since the item is a fixed weight item.

• For an item that is variable weight and requires whole units:

  • When Weight goes from empty to a value: the Units will automatically be calculated based on the Weight value and then be rounded to the next whole Unit. Weight will remain as the user entered Weight, per the Item's 'Weight Decimals'.
    

  • When Weight goes from one value to another: the Units will NOT be recalculated.

 If Weight is edited and the Line Source is either 'BOM' or 'Production Order BOM', the 'BOM Qty Override' field will be set to 'Yes'.  Additionally, the Weight value will not recalculate if the related BOM Output item's Quantity is edited. 

'Weight' and 'Weight UOM' fields will always display as the values entered by the user. However for consistency, weight that is saved using a UOM different than the 'Inventory Weight UOM' will be converted and subsequently stored in the default Inventory Weight UOM.

Database Field: ERPx_IMTransactionDetail.TransactionWeight

Identifies the unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for a line item or on the transaction. This is a single-select standard lookup that is required to save a line item on transactions with a Status of 'Approved' or greater. This field will be disabled if the item is managed by Units Only. If enabled, it will default from the 'Inventory Weight UOM' property on the 'Properties' tab of the Item Record View for the selected Item. If enabled, this field will be editable while the transaction is in a Status of 'New'.

This lookup contains all 'Active' Weight UOMs on the selected Item's UOM Schedule.

A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionWeightUOMSK

 Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.

Cost Items that are associated with a BOM record cannot be deleted, the message "[Cost Item ID] could not be deleted because it was added from a BOM." will be displayed on Save.