Customer Return (Window ID-53097)

From iDempiere en

Table of Contents

Window: Customer Return

Description: Customer Return (Receipts)

Help: The Customer Return Window defines the receipt of product or material from a Customer Return.

Tab: Customer Return

Description: Enter Customer Returns

Help: The Customer Return Tab allows you to generate, maintain, enter and process Returns from a Customer.

Customer Return - Customer Return - Window (iDempiere 1.0.0).png

Fields
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
Order Order The Order is a control document. The 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 to) 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
Sales Representative Sales Representative or Company Agent The Sales Representative indicates the Sales Rep for this Region. 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
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: Customer Return Line

Description: Customer Return Line

Help: The Customer Return Line Tab defines the individual items in a Customer Return.

File:Customer Return - Customer Return Line - Window (iDempiere 1.0.0).png

Fields
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
Customer Return Customer Return Document The Customer Return M_InOutLine.M_InOut_ID
numeric(10)
Search
RMA Line Return Material Authorization Line Detail information about the returned goods M_InOutLine.M_RMALine_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: Attributes

Description: Product Instance Attribute Material Allocation

Help:

File:Customer Return - Attributes - Window (iDempiere 1.0.0).png

Fields
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
Shipment/Receipt Line Line on Shipment or Receipt document The Shipment/Receipt Line indicates a unique line in a Shipment/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

Tab: Confirmations

Description: Optional Confirmations of Receipt Lines

Help: The quantities are in the storage Unit of Measure!

File:Customer Return - Confirmations - Window (iDempiere 1.0.0).png

Fields
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
Shipment/Receipt Line Line on Shipment or Receipt document The Shipment/Receipt Line indicates a unique line in a Shipment/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: Matched POs

Description: Purchase Order Lines matched to this Material Receipt Line

Help:

File:Customer Return - Matched POs - Window (iDempiere 1.0.0).png

Fields
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
Shipment/Receipt Line Line on Shipment or Receipt document The Shipment/Receipt Line indicates a unique line in a Shipment/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
Sales Order Line Sales Order Line The Sales 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
Quantity Quantity The Quantity indicates the number of a specific product or item for this document. M_MatchPO.Qty
numeric
Quantity
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

Tab: Matched Invoices

Description: Invoice Lines matched to this Material Receipt Line

Help:

File:Customer Return - Matched Invoices - Window (iDempiere 1.0.0).png

Fields
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
Shipment/Receipt Line Line on Shipment or Receipt document The Shipment/Receipt Line indicates a unique line in a Shipment/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
Quantity Quantity The Quantity indicates the number of a specific product or item for this document. M_MatchInv.Qty
numeric
Quantity
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


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.