ManPageW MaterialReceipt
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
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 and Vendor Returns
Help : The Shipments Tab allows you to generate, maintain, enter and process Shipments from a Vendor or Returns to a Vendor.
Table Name : M_InOut
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| 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 cloase an order, unshipped (backordered) quantities are cancelled. | C_Order_ID
NUMBER(10) Search |
| Date Ordered | Date of Order | Indicates the Date an item was ordered. | DateOrdered
DATE Date |
| RMA | Return Material Authorization | A Return Material Authorization may be required to accept returns and to create Credit Memos | M_RMA_ID
NUMBER(10) TableDir |
| 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). |
DocumentNo
NVARCHAR2(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. | POReference
NVARCHAR2(20) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) Text |
| Document Type | Document type or rules | The Document Type determines document sequence and processing rules | C_DocType_ID
NUMBER(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. | MovementDate
DATE 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. | DateAcct
DATE Date |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
| Partner Location | Identifies the (ship from) address for this Business Partner | The Partner address indicates the location of a Business Partner | C_BPartner_Location_ID
NUMBER(10) TableDir |
| 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 | AD_User_ID
NUMBER(10) TableDir |
| Warehouse | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_Warehouse_ID
NUMBER(10) TableDir |
| Priority | Priority of a document | The Priority indicates the importance (high, medium, low) of this document | PriorityRule
CHAR(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. | DeliveryViaRule
CHAR(1) List |
| Shipper | Method or manner of product delivery | The Shipper indicates the method of delivering product | M_Shipper_ID
NUMBER(10) TableDir |
| Company Agent | Purchase or Company Agent | Purchase agent for the document. Any Sales Rep must be a valid internal user. | SalesRep_ID
NUMBER(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. | DeliveryRule
CHAR(1) List |
| Freight Cost Rule | Method for charging Freight | The Freight Cost Rule indicates the method used when charging for freight. | FreightCostRule
CHAR(1) List |
| Freight Amount | Freight Amount | The Freight Amount indicates the amount charged for Freight in the document currency. | FreightAmt
NUMBER Amount |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Charge_ID
NUMBER(10) Table |
| Charge amount | Charge Amount | The Charge Amount indicates the amount for an additional charge. | ChargeAmt
NUMBER Amount |
| 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. | CreateFrom
CHAR(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. | GenerateTo
CHAR(1) Button |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID
NUMBER(10) TableDir |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID
NUMBER(10) TableDir |
| 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. | C_Campaign_ID
NUMBER(10) TableDir |
| 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. | AD_OrgTrx_ID
NUMBER(10) Table |
| User List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | User1_ID
NUMBER(10) Table |
| User List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | User2_ID
NUMBER(10) Table |
| Movement Type | Method of moving the inventory | The Movement Type indicates the type of movement (in, out, to production, etc) | MovementType
CHAR(2) List |
| Create Confirmation | Create Confirmations for the Document | The confirmations generated need to be processed (confirmed) before you can process this document | CreateConfirm
CHAR(1) Button |
| In Transit | Movement is in transit | Material Movement is in transit - shipped, but not received.
The transaction is completed, if confirmed. |
IsInTransit
CHAR(1) YesNo |
| Date received | Date a product was received | The Date Received indicates the date that product was received. | DateReceived
DATE 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 | DocStatus
CHAR(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. | DocAction
CHAR(2) Button |
| In Dispute | Document is in dispute | The document is in dispute. Use Requests to track details. | IsInDispute
CHAR(1) YesNo |
| Posted | Posting status | The Posted field indicates the status of the Generation of General Ledger Accounting Lines | Posted
CHAR(1) Button |
Tab: Receipt Line
Description : Shipment Line
Help : The Shipment Line Tab defines the individual items in a Shipment.
Table Name : M_InOutLine
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Receipt | Material Receipt Document | The Material Shipment / Receipt | M_InOut_ID
NUMBER(10) Search |
| Purchase Order Line | Purchase Order Line | The Purchase Order Line is a unique identifier for a line in an order. | C_OrderLine_ID
NUMBER(10) TableDir |
| 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. | Line
NUMBER(10) Integer |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(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_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | M_Locator_ID
NUMBER(10) Locator |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Charge_ID
NUMBER(10) TableDir |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) Text |
| Quantity | The Quantity Entered is based on the selected UoM | The Quantity Entered is converted to base product UoM quantity | QtyEntered
NUMBER Quantity |
| UOM | Unit of Measure | The UOM defines a unique non monetary Unit of Measure | C_UOM_ID
NUMBER(10) TableDir |
| Movement Quantity | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | MovementQty
NUMBER Quantity |
| Picked Quantity | PickedQty
NUMBER Quantity | ||
| Target Quantity | Target Movement Quantity | The Quantity which should have been received | TargetQty
NUMBER Quantity |
| Confirmed Quantity | Confirmation of a received quantity | Confirmation of a received quantity | ConfirmedQty
NUMBER Quantity |
| Scrapped Quantity | The Quantity scrapped due to QA issues | ScrappedQty
NUMBER Quantity | |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | C_Project_ID
NUMBER(10) TableDir |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID
NUMBER(10) TableDir |
| Project Phase | Phase of a Project | C_ProjectPhase_ID
NUMBER(10) TableDir | |
| Project Task | Actual Project Task in a Phase | A Project Task in a Project Phase represents the actual work. | C_ProjectTask_ID
NUMBER(10) TableDir |
| 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. | C_Campaign_ID
NUMBER(10) TableDir |
| 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. | AD_OrgTrx_ID
NUMBER(10) Table |
| User List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | User1_ID
NUMBER(10) Table |
| User List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | User2_ID
NUMBER(10) Table |
Tab: Confirmations
Description : Optional Confirmations of Receipt Lines
Help : The quantities are in the storage Unit of Measure!
Table Name : M_InOutLineConfirm
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Receipt Line | Line on Receipt document | M_InOutLine_ID
NUMBER(10) Search | |
| Ship/Receipt Confirmation | Material Shipment or Receipt Confirmation | Confirmation of Shipment or Receipt - Created from the Shipment/Receipt | M_InOutConfirm_ID
NUMBER(10) TableDir |
| Ship/Receipt Confirmation Line | Material Shipment or Receipt Confirmation Line | Confirmation details | M_InOutLineConfirm_ID
NUMBER(10) ID |
| Confirmation No | Confirmation Number | ConfirmationNo
NVARCHAR2(20) String | |
| Target Quantity | Target Movement Quantity | The Quantity which should have been received | TargetQty
NUMBER Quantity |
| Confirmed Quantity | Confirmation of a received quantity | Confirmation of a received quantity | ConfirmedQty
NUMBER Quantity |
| Difference | Difference Quantity | DifferenceQty
NUMBER Quantity | |
| Scrapped Quantity | The Quantity scrapped due to QA issues | ScrappedQty
NUMBER Quantity | |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Tab: Matched POs
Description : Purchase Order Lines matched to this Material Receipt Line
Help :
Table Name : M_MatchPO
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Receipt Line | Line on Receipt document | M_InOutLine_ID
NUMBER(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). |
DocumentNo
NVARCHAR2(30) String |
| Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | DateTrx
DATE Date |
| Purchase Order Line | Purchase Order Line | The Purchase Order Line is a unique identifier for a line in an order. | C_OrderLine_ID
NUMBER(10) Search |
| Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | C_InvoiceLine_ID
NUMBER(10) Search |
| Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | Qty
NUMBER Quantity |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(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_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
Tab: Matched Invoices
Description : Invoice Lines matched to this Material Receipt Line
Help :
Table Name : M_MatchInv
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Receipt Line | Line on Receipt document | M_InOutLine_ID
NUMBER(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). |
DocumentNo
NVARCHAR2(30) String |
| Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | DateTrx
DATE Date |
| Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | C_InvoiceLine_ID
NUMBER(10) Search |
| Quantity | Quantity | The Quantity indicates the number of a specific product or item for this document. | Qty
NUMBER Quantity |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(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_AttributeSetInstance_ID
NUMBER(10) ProductAttribute |
