The Inventory Receipt Transaction Record View allows users to record the receipt of inventory from an outside entity. This transaction allows multiple line items to be received into a single site. The 'Include open Receipt transactions in Available balances' preference will determine whether Available balances are updated before the transaction is posted. Once the transaction is posted, it will update the On Hand lot balance of the item(s).
To view the help page for the NorthScope 2.0 IM Receipt Record View, please click here: Receipt Transaction Record View
Software Version: 20222023.0411.2230 and newer
Table of Contents | ||
---|---|---|
|
...
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Delete |
If the Receipt Transaction was linked to a PO #, the PO will be updated to reflect the changes. | ||||||||||||||||
Help |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
New |
The list contains all the 'Active' Receipt Transaction Class IDs displayed as [TransactionType] - [ClassID]. For example: "Receipt - Packaging". Note: The Transaction Class will not display after the Transaction Type if the Class ID is named "Default" | ||||||||||||||||
Notes |
| ||||||||||||||||
| |||||||||||||||||
Process Correction |
| ||||||||||||||||
Save |
| ||||||||||||||||
Save & Close |
|
Home Tab
REC#: [TransID] PO#: [PO] REQ#: [REQ#] [Received From] | |||||||||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Comment |
The 'Comment' can be overwritten and is always editable even after the transaction is posted Database Field: ERPx_IMTransactionHeader.Description | ||||||||||||||||||||||||||||||||
Date |
The Date must be on or before the GL Date when Approving or Posting the transaction. If not, the message "The GL Date must be on or after the Transaction Date." will be displayed on Save. This is editable while the transaction is in a Status of "New". Database Field: ERPx_IMTransactionHeader.TransactionDate | ||||||||||||||||||||||||||||||||
PO # |
Once a valid PO# has been selected, or manually entered, all the Purchase Order line items (with a remaining quantity) that are not already on the transaction will be auto-added to the transaction and both the 'PO #' and 'Rec. From' values will be set and disabled. A 'PO #' is considered valid for Receipts based on:
Database Fields: ERPx_APPoHeader.PurchaseOrderID, ERPx_IMTransactionHeader.POHeaderSK | ||||||||||||||||||||||||||||||||
Rec. From | Identifies the name of the entity (Vendor, Fisherman, Grower, etc.) the product was received from. This is text box that is only required if a PO # has been entered and it defaults as:
This is editable when the transaction is in a Status of "New" for Receipts that are not linked to a PO #. For Receipts that are linked to a PO #, this is not editable. This value will be stamped on the Production Batch for all lot tracked items when the transaction is saved as Ready to Post/Posted. Database Fields: Database Field: ERPx_IMTransactionHeader.RecFrom | ||||||||||||||||||||||||||||||||
Reference |
If the Receipt transaction is created as a result of a Grower Accounting ticket that has linked inventory items, this value will default as the Ticket # of the corresponding posted Grower ticket. The Reference will not default from the Reference on a linked Purchase Order. These are treated as separate reference fields.
Database Field: ERPx_IMTransactionHeader.Reference | ||||||||||||||||||||||||||||||||
Site Name |
This is editable while the transaction is in a Status of "New" and until a line item (with full lot information) is saved. The Site can be changed; it is not restricted to the Site on the linked Purchase Order.
This lookup contains a blank value, the current assigned value, and a list of all active Sites. Database Fields: ERPx_IMTransactinHeader.SiteSK, ERPx_MFSite.SiteID | ||||||||||||||||||||||||||||||||
Status |
The Statuses that apply to transactions in this Record View include:
Database Fields: ERPx_IMTransactionHeader.TransactionStatusSK |
Properties Tab
Fields | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Group: 1 | |||||||||||||||||
GL Date |
Database Field: ERPx_IMTransactionHeader.GLDate | ||||||||||||||||
Transaction Date | This is a non-editable control that shows the 'Transaction Date' from the Home Tab. This is informational only from here. Database Field: ERPx_IMTransactionHeader.TransactionDate | ||||||||||||||||
Auto-Create New Lots |
This lookup contains the values in the IMAutoCreateNewLots Enumeration Class. Database Field: ERPx_IMTransactionHeader.AutoCreateLotsEN | ||||||||||||||||
Negative Available Balances |
This lookup contains the values in the IMAllowNegativeAvailableBalances Enumeration Class. If Sales Order allocation preferences are set to either “Available Only” or “Available and On Hand” and a Sales order has been allocated prior to a user updating the Inventory “Negative Available Balances” property, it is possible to draw the lots negative. Database Field: ERPx_IMTransactionHeader.NegativeBalancesEN | ||||||||||||||||
Group: 2 | |||||||||||||||||
Created |
Database Field: ERPx_IMTransactionHeader.CreatedDate | ||||||||||||||||
Created By |
Database Field: ERPx_IMTransactionHeader.CreatedBy | ||||||||||||||||
Last Updated |
Database Field: ERPx_IMTransactionHeader.LastUser | ||||||||||||||||
Last Updated By |
Database Field: ERPx_IMTransactionHeader.LastUser | ||||||||||||||||
Group: 3 | |||||||||||||||||
Void Date |
Database Field: ERPx_IMTransactionHeader.VoidDate | ||||||||||||||||
Voided By |
Database Field: ERPx_IMTransactionHeader.VoidedBy | ||||||||||||||||
Group: 4 | |||||||||||||||||
Transaction Class ID |
Database Field: ERPx_IMTransactionHeader.TransactionClassSK, ERPx_IMTransactionClass.TransactionClassID | ||||||||||||||||
Linked AP Transaction ID | Identifies the transaction ID for the AP Invoice/Credit Memo transaction that is linked to this transaction. This is not required and not editable. This will be populated if a Receipt was created from the AP Invoice/Credit Memo or if the AP Invoice/Credit Memo was created from the Receipt. If a Receipt was linked but was either deleted or voided, the link will be removed. | ||||||||||||||||
Transaction SK | Identifies the SK value of the Transaction. This is a non-editable text box that is informational only. Database Field: ERPx_IMTransactionHeader.TransactionHeaderSK |
Attributes Tab
Fields | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Attributes |
| ||||||||
Required | 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 - Receipt). | ||||||||
Value |
|
Page Details
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Add Item |
| ||||||||||||||||
Column Filter Show/Hide |
| ||||||||||||||||
Excel |
| ||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||
Mass Update |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
Quick Column Filter |
| ||||||||||||||||
Remove Items |
| ||||||||||||||||
Saved Layouts |
| ||||||||||||||||
Fields | Description | ||||||||||||||||
Checkbox |
| ||||||||||||||||
Item |
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.
The lookup contains a list of all active Inventory type Items in the Items 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:ItemDescription, ERPX_IMTransactionDetail.ItemSK | ||||||||||||||||
Line Comment |
This is not required and is always editable, even after the transaction is posted. If entered, it must be <=100 characters.When Receipts are auto created from an AP Transaction, this will default as the 'Line Comment' on those transactions. This feature has not been implemented yet. When Receipts are loaded from a PO, this will default as the 'Line Comment' on those transactions. Database Fields: ERPX_IMTransactionDetail.LineComment, ERPx_APPoLine.LineComment | ||||||||||||||||
Line Description |
Database Fields: ERPX_IMTransactionDetail.LineDescription, ERPx_APPoLine.LineDescription | ||||||||||||||||
Ln. |
For example, if you had 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). Database Field: ERPx_IMTransactionDetail.LineNumber.LineNumber | ||||||||||||||||
Market Cost |
| ||||||||||||||||
PO Ln. | Identifies the Purchase Order line item that the Receipt line item is linked to. This is a single-select lookup that is not required. If a 'PO #' is entered/selected for this transaction, as line items are added to the Receipt, if they are also on the Purchase Order, this will default from the Purchase Order's 'Ln.' as [PO#]: [Ln]. This is editable while the transaction is in a Status of "New". The lookup contains a blank value, the current assigned value, and a list of all the Purchase Order Line Numbers (from the PO # assigned to this transaction) that matches the selected Item ID. When AP Invoices, Credit Memos, and IM Receipts are loaded from a PO, this will default from the 'Ln.' of the Purchase Order Item. Database Field: ERPx_IMTransactionDetail.PoLnSK | ||||||||||||||||
Owner |
If the transaction was created as a result of a Grower Accounting ticket that has linked inventory items, this value will default from the 'Default Lot Owner' property on the associated Grower Accounting Ticket Class record.
The lookup contains a list of all Lot Owners. Database Field: ERPx_IMLotOwner.OwnerName | ||||||||||||||||
Production Batch |
Database Fields: ERPx_IMProductionLot.ProductionLotID, ERPx_IMTransactionDetail.ItemSK | ||||||||||||||||
Site |
The lookup contains a blank value, the current assigned value and all 'Active' Sites. Database Fields: ERPx_MFSite.SiteName, ERPx_IMTransactionDetail.SiteLineSK | ||||||||||||||||
Units |
'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 | ||||||||||||||||
Units UOM |
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.
Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionUnitsUOMSK | ||||||||||||||||
Warehouse Lot |
If the transaction was created as a result of a Grower Accounting ticket that has linked inventory items, this value will default from the 'Create Warehouse Lot As' property on the associated Grower Accounting Ticket Class record. Database Field: ERPx_IMWarehouseLot.WarehouseLotID | ||||||||||||||||
Weight |
'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 | ||||||||||||||||
Weight UOM |
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
Database Fields: ERPx_IMUOM.UOMName, ERPX_IMItem.UOMScheduleSK, ERPx_IMTransactionDetail.TransactionWeightUOMSK |
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
...