Material Receipt (Window ID-184)
Window: Material Receipt
Description: Vendor Shipments (Receipts)
Help: The Vendor Shipment Window defines the receipt of product or material from a Vendor. The Shipment may be manually entered or may be generated from a Purchase Order or Vendor Invoice.
Tab: Material Receipt
Description: Enter Receipts
Help: The Shipments Tab allows you to generate, maintain, enter and process Shipments from a Vendor.
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_InOut.AD_Client_ID numeric(10) Table Direct |
Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_InOut.AD_Org_ID numeric(10) Table Direct |
Purchase Order | Purchase Order | The Purchase Order is a control document. The Purchase Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you close an order, unshipped (backordered) quantities are cancelled. | M_InOut.C_Order_ID numeric(10) Search |
Date Ordered | Date of Order | Indicates the Date an item was ordered. | M_InOut.DateOrdered timestamp without time zone Date |
RMA | Return Material Authorization | A Return Material Authorization may be required to accept returns and to create Credit Memos | M_InOut.M_RMA_ID numeric(10) Search |
Document No | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".
If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
M_InOut.DocumentNo character varying(30) String |
Order Reference | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | The business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference. A standard number can be defined in the Business Partner (Customer) window. | M_InOut.POReference character varying(20) String |
Description | Optional short description of the record | A description is limited to 255 characters. | M_InOut.Description character varying(255) Text |
Document Type | Document type or rules | The Document Type determines document sequence and processing rules | M_InOut.C_DocType_ID numeric(10) Table |
Movement Date | Date a product was moved in or out of inventory | The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement. | M_InOut.MovementDate timestamp without time zone Date |
Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | M_InOut.DateAcct timestamp without time zone Date |
Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | M_InOut.C_BPartner_ID numeric(10) Search |
Partner Location | Identifies the (ship from) address for this Business Partner | The Partner address indicates the location of a Business Partner | M_InOut.C_BPartner_Location_ID numeric(10) Table Direct |
User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | M_InOut.AD_User_ID numeric(10) Table Direct |
Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_InOut.M_Warehouse_ID numeric(10) Table Direct |
Priority | Priority of a document | The Priority indicates the importance (high, medium, low) of this document | M_InOut.PriorityRule character(1) List |
Delivery Via | How the order will be delivered | The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped. | M_InOut.DeliveryViaRule character(1) List |
Shipper | Method or manner of product delivery | The Shipper indicates the method of delivering product | M_InOut.M_Shipper_ID numeric(10) Table |
Company Agent | Purchase or Company Agent | Purchase agent for the document. Any Sales Rep must be a valid internal user. | M_InOut.SalesRep_ID numeric(10) Table |
Delivery Rule | Defines the timing of Delivery | The Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available. | M_InOut.DeliveryRule character(1) List |
Freight Cost Rule | Method for charging Freight | The Freight Cost Rule indicates the method used when charging for freight. | M_InOut.FreightCostRule character(1) List |
Freight Amount | Freight Amount | The Freight Amount indicates the amount charged for Freight in the document currency. | M_InOut.FreightAmt numeric Amount |
Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | M_InOut.C_Charge_ID numeric(10) Table |
Charge amount | Charge Amount | The Charge Amount indicates the amount for an additional charge. | M_InOut.ChargeAmt numeric Amount |
Drop Shipment | Drop Shipments are sent directly to the Drop Shipment Location | Drop Shipments are sent directly to the Drop Shipment Location using the Drop Ship Business Partner name and contact. | M_InOut.IsDropShip character(1) Yes-No |
Drop Ship Business Partner | Business Partner to ship to | If empty the business partner will be shipped to. | M_InOut.DropShip_BPartner_ID numeric(10) Search |
Drop Shipment Location | Business Partner Location for shipping to | M_InOut.DropShip_Location_ID numeric(10) Table | |
Drop Shipment Contact | Business Partner Contact for drop shipment | M_InOut.DropShip_User_ID numeric(10) Table | |
Tracking No | Number to track the shipment | M_InOut.TrackingNo character varying(60) String | |
Create lines from | Process which will generate a new document lines based on an existing document | The Create From process will create a new document based on information in an existing document selected by the user. | M_InOut.CreateLinesFrom character(1) Button |
Generate Invoice from Receipt | Create and process Invoice from this receipt. The receipt should be correct and completed. | Generate Invoice from Receipt will create an invoice based on the selected receipt and match the invoice to that receipt. You can set the document number only if the invoice document type allows to set the document number manually. | M_InOut.GenerateTo character(1) Button |
Project | Financial Project | A Project allows you to track and control internal or external activities. | M_InOut.C_Project_ID numeric(10) Table Direct |
Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | M_InOut.C_Activity_ID numeric(10) Table Direct |
Campaign | Marketing Campaign | The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. | M_InOut.C_Campaign_ID numeric(10) Table Direct |
Trx Organization | Performing or initiating organization | The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | M_InOut.AD_OrgTrx_ID numeric(10) Table |
User Element List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | M_InOut.User1_ID numeric(10) Search |
User Element List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | M_InOut.User2_ID numeric(10) Search |
Movement Type | Method of moving the inventory | The Movement Type indicates the type of movement (in, out, to production, etc) | M_InOut.MovementType character(2) List |
Create Confirmation | Create Confirmations for the Document | The confirmations generated need to be processed (confirmed) before you can process this document | M_InOut.CreateConfirm character(1) Button |
In Transit | Movement is in transit | Material Movement is in transit - shipped, but not received.
The transaction is completed, if confirmed. |
M_InOut.IsInTransit character(1) Yes-No |
Date Received | Date a product was received | The Date Received indicates the date that product was received. | M_InOut.DateReceived timestamp without time zone Date |
Document Status | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | M_InOut.DocStatus character(2) List |
Process Shipment | Process Shipment/Receipt (Update Inventory) | Process Shipment/Receipt will move products out of/into inventory and mark line items as shipped/received. | M_InOut.DocAction character(2) Button |
In Dispute | Document is in dispute | The document is in dispute. Use Requests to track details. | M_InOut.IsInDispute character(1) Yes-No |
Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | M_InOut.Posted character(1) Button |
Tab: Receipt Line
Description: Shipment Line
Help: The Shipment Line Tab defines the individual items in a Shipment.
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_InOutLine.AD_Client_ID numeric(10) Table Direct |
Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_InOutLine.AD_Org_ID numeric(10) Table Direct |
Receipt | Material Receipt Document | The Material Shipment / Receipt | M_InOutLine.M_InOut_ID numeric(10) Search |
Purchase Order Line | Purchase Order Line | The Purchase Order Line is a unique identifier for a line in an order. | M_InOutLine.C_OrderLine_ID numeric(10) Table Direct |
Line No | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | M_InOutLine.Line numeric(10) Integer |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_InOutLine.M_Product_ID numeric(10) Search |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_InOutLine.M_AttributeSetInstance_ID numeric(10) Product Attribute |
Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | M_InOutLine.M_Locator_ID numeric(10) Locator (WH) |
Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | M_InOutLine.C_Charge_ID numeric(10) Table Direct |
Description | Optional short description of the record | A description is limited to 255 characters. | M_InOutLine.Description character varying(255) Text |
Quantity | The Quantity Entered is based on the selected UoM | The Quantity Entered is converted to base product UoM quantity | M_InOutLine.QtyEntered numeric Quantity |
UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | M_InOutLine.C_UOM_ID numeric(10) Table Direct |
Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | M_InOutLine.MovementQty numeric Quantity |
Picked Quantity | M_InOutLine.PickedQty numeric Quantity | ||
Target Quantity | Target Movement Quantity | The Quantity which should have been received | M_InOutLine.TargetQty numeric Quantity |
Confirmed Quantity | Confirmation of a received quantity | Confirmation of a received quantity | M_InOutLine.ConfirmedQty numeric Quantity |
Scrapped Quantity | The Quantity scrapped due to QA issues | M_InOutLine.ScrappedQty numeric Quantity | |
Project | Financial Project | A Project allows you to track and control internal or external activities. | M_InOutLine.C_Project_ID numeric(10) Table Direct |
Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | M_InOutLine.C_Activity_ID numeric(10) Table Direct |
Project Phase | Phase of a Project | M_InOutLine.C_ProjectPhase_ID numeric(10) Table Direct | |
Project Task | Actual Project Task in a Phase | A Project Task in a Project Phase represents the actual work. | M_InOutLine.C_ProjectTask_ID numeric(10) Table Direct |
Campaign | Marketing Campaign | The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. | M_InOutLine.C_Campaign_ID numeric(10) Table Direct |
Trx Organization | Performing or initiating organization | The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | M_InOutLine.AD_OrgTrx_ID numeric(10) Table |
User Element List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | M_InOutLine.User1_ID numeric(10) Search |
User Element List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | M_InOutLine.User2_ID numeric(10) Search |
Tab: Confirmations
Description: Optional Confirmations of Receipt Lines
Help: The quantities are in the storage Unit of Measure!
File:Material Receipt - Confirmations - Window (iDempiere 1.0.0).png
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_InOutLineConfirm.AD_Client_ID numeric(10) Table Direct |
Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_InOutLineConfirm.AD_Org_ID numeric(10) Table Direct |
Receipt Line | Line on Receipt document | M_InOutLineConfirm.M_InOutLine_ID numeric(10) Search | |
Ship/Receipt Confirmation | Material Shipment or Receipt Confirmation | Confirmation of Shipment or Receipt - Created from the Shipment/Receipt | M_InOutLineConfirm.M_InOutConfirm_ID numeric(10) Search |
Ship/Receipt Confirmation Line | Material Shipment or Receipt Confirmation Line | Confirmation details | M_InOutLineConfirm.M_InOutLineConfirm_ID numeric(10) ID |
Confirmation No | Confirmation Number | M_InOutLineConfirm.ConfirmationNo character varying(20) String | |
Target Quantity | Target Movement Quantity | The Quantity which should have been received | M_InOutLineConfirm.TargetQty numeric Quantity |
Confirmed Quantity | Confirmation of a received quantity | Confirmation of a received quantity | M_InOutLineConfirm.ConfirmedQty numeric Quantity |
Difference | Difference Quantity | M_InOutLineConfirm.DifferenceQty numeric Quantity | |
Scrapped Quantity | The Quantity scrapped due to QA issues | M_InOutLineConfirm.ScrappedQty numeric Quantity | |
Description | Optional short description of the record | A description is limited to 255 characters. | M_InOutLineConfirm.Description character varying(255) String |
Tab: Attributes
Description: Product Instance Attribute Material Allocation
Help:
File:Material Receipt - Attributes - Window (iDempiere 1.0.0).png
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_InOutLineMA.AD_Client_ID numeric(10) Table Direct |
Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_InOutLineMA.AD_Org_ID numeric(10) Table Direct |
Receipt Line | Line on Receipt document | M_InOutLineMA.M_InOutLine_ID numeric(10) Search | |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_InOutLineMA.M_AttributeSetInstance_ID numeric(10) Product Attribute |
Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | M_InOutLineMA.MovementQty numeric Quantity |
Date Material Policy | Time used for LIFO and FIFO Material Policy | This field is used to record time used for LIFO and FIFO material policy | M_InOutLineMA.DateMaterialPolicy timestamp without time zone Date |
Auto Generated | Record is Auto Generated by System. | M_InOutLineMA.IsAutoGenerated character(1) Yes-No |
Tab: Matched POs
Description: Purchase Order Lines matched to this Material Receipt Line
Help:
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_MatchPO.AD_Client_ID numeric(10) Table Direct |
Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_MatchPO.AD_Org_ID numeric(10) Table Direct |
Receipt Line | Line on Receipt document | M_MatchPO.M_InOutLine_ID numeric(10) Search | |
Document No | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".
If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
M_MatchPO.DocumentNo character varying(30) String |
Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | M_MatchPO.DateTrx timestamp without time zone Date |
Purchase Order Line | Purchase Order Line | The Purchase Order Line is a unique identifier for a line in an order. | M_MatchPO.C_OrderLine_ID numeric(10) Search |
Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | M_MatchPO.C_InvoiceLine_ID numeric(10) Search |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_MatchPO.M_Product_ID numeric(10) Search |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_MatchPO.M_AttributeSetInstance_ID numeric(10) Product Attribute |
Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | M_MatchPO.Qty numeric Quantity |
Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | M_MatchPO.Posted character(1) Button |
Tab: Matched Invoices
Description: Invoice Lines matched to this Material Receipt Line
Help:
Name | Description | Help | Technical Data |
---|---|---|---|
Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | M_MatchInv.AD_Client_ID numeric(10) Table Direct |
Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | M_MatchInv.AD_Org_ID numeric(10) Table Direct |
Receipt Line | Line on Receipt document | M_MatchInv.M_InOutLine_ID numeric(10) Search | |
Document No | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".
If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order). |
M_MatchInv.DocumentNo character varying(30) String |
Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | M_MatchInv.DateTrx timestamp without time zone Date |
Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | M_MatchInv.C_InvoiceLine_ID numeric(10) Search |
Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_MatchInv.M_Product_ID numeric(10) Search |
Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | M_MatchInv.M_AttributeSetInstance_ID numeric(10) Product Attribute |
Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | M_MatchInv.Qty numeric Quantity |
Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | M_MatchInv.Posted character(1) Button |