Skip to main content

Window: Return to Vendor

[Created: 11/09/2009 - Updated: 11/09/2009 ]
Description: Vendor Returns
Help: The Return to Vendor Window defines shipments made or to be made to a vendor as part of a return.

Tab: Return to Vendor

[Created: 11/09/2009 - Updated: 30/09/2009 ]
Description: Vendor Returns
Help: The Return to Vendor Tab allows you to generate, maintain, enter and process Shipments to a Vendor because of a Return
Tab Level: 0

Table 10: Return to Vendor - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 OrderPurchase OrderThe 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 OrderedDate of OrderIndicates the Date an item was ordered.m_inout.DateOrdered timestamp without time zone
Date
RMAReturn Material AuthorizationA Return Material Authorization may be required to accept returns and to create Credit Memosm_inout.M_RMA_ID numeric(10)
Search
Document NoDocument sequence number of the documentThe 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_", where TableName is the actual name of the table (e.g. C_Order).m_inout.DocumentNo character varying(30)
String
Order ReferenceTransaction Reference Number (Sales Order, Purchase Order) of your Business PartnerThe 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
DescriptionOptional short description of the recordA description is limited to 255 characters.m_inout.Description character varying(255)
Text
Document TypeDocument type or rulesThe Document Type determines document sequence and processing rulesm_inout.C_DocType_ID numeric(10)
Table
Movement DateDate a product was moved in or out of inventoryThe 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 DateAccounting DateThe 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 PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonm_inout.C_BPartner_ID numeric(10)
Search
Partner LocationIdentifies the (ship from) address for this Business PartnerThe Partner address indicates the location of a Business Partnerm_inout.C_BPartner_Location_ID numeric(10)
Table Direct
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactm_inout.AD_User_ID numeric(10)
Table Direct
WarehouseStorage Warehouse and Service PointThe Warehouse identifies a unique Warehouse where products are stored or Services are provided.m_inout.M_Warehouse_ID numeric(10)
Table Direct
PriorityPriority of a documentThe Priority indicates the importance (high, medium, low) of this documentm_inout.PriorityRule character(1)
List
Delivery RuleDefines the timing of DeliveryThe 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
Pick DateDate/Time when picked for Shipmentm_inout.PickDate timestamp without time zone
Date+Time
Company AgentPurchase or Company AgentPurchase agent for the document. Any Sales Rep must be a valid internal user.m_inout.SalesRep_ID numeric(10)
Table
Delivery ViaHow the order will be deliveredThe 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
ShipperMethod or manner of product deliveryThe Shipper indicates the method of delivering productm_inout.M_Shipper_ID numeric(10)
Table
Create PackageCreate Package for Shipmentm_inout.CreatePackage character(1)
Button
Ship DateShipment Date/TimeActual Date/Time of Shipment (pick up)m_inout.ShipDate timestamp without time zone
Date+Time
No PackagesNumber of packages shippedm_inout.NoPackages numeric(10)
Integer
Tracking NoNumber to track the shipmentm_inout.TrackingNo character varying(60)
String
Freight Cost RuleMethod for charging FreightThe Freight Cost Rule indicates the method used when charging for freight.m_inout.FreightCostRule character(1)
List
Freight AmountFreight AmountThe Freight Amount indicates the amount charged for Freight in the document currency.m_inout.FreightAmt numeric
Amount
Create lines fromProcess which will generate a new document lines based on an existing documentThe 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
Drop ShipmentDrop Shipments are sent directly to the Drop Shipment LocationDrop 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 PartnerBusiness Partner to ship toIf empty the business partner will be shipped to.m_inout.DropShip_BPartner_ID numeric(10)
Search
Drop Shipment LocationBusiness Partner Location for shipping tom_inout.DropShip_Location_ID numeric(10)
Table
Drop Shipment ContactBusiness Partner Contact for drop shipmentm_inout.DropShip_User_ID numeric(10)
Table
Generate Invoice from ReceiptCreate 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
ChargeAdditional document chargesThe Charge indicates a type of Charge (Handling, Shipping, Restocking)m_inout.C_Charge_ID numeric(10)
Table
Charge amountCharge AmountThe Charge Amount indicates the amount for an additional charge.m_inout.ChargeAmt numeric
Amount
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.m_inout.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingm_inout.C_Activity_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe 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 OrganizationPerforming or initiating organizationThe 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 1User defined list element #1The 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 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.m_inout.User2_ID numeric(10)
Search
Movement TypeMethod of moving the inventoryThe Movement Type indicates the type of movement (in, out, to production, etc)m_inout.MovementType character(2)
List
Create ConfirmationCreate Confirmations for the DocumentThe confirmations generated need to be processed (confirmed) before you can process this documentm_inout.CreateConfirm character(1)
Button
In TransitMovement is in transitMaterial Movement is in transit - shipped, but not received.The transaction is completed, if confirmed.m_inout.IsInTransit character(1)
Yes-No
Date ReceivedDate a product was receivedThe Date Received indicates the date that product was received.m_inout.DateReceived timestamp without time zone
Date
Document StatusThe current status of the documentThe Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action fieldm_inout.DocStatus character(2)
List
Process ShipmentProcess 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 DisputeDocument is in disputeThe document is in dispute. Use Requests to track details.m_inout.IsInDispute character(1)
Yes-No
PostedPosting statusThe Posted field indicates the status of the Generation of General Ledger Accounting Linesm_inout.Posted character(1)
Button

Tab: Return to Vendor Line

[Created: 11/09/2009 - Updated: 09/08/2013 ]
Description: Return to Vendor Line
Help: The Return to Vendor Line Tab defines the individual items in a Return to Vendor.
Tab Level: 1

Table 20: Return to Vendor Line - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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
Return to VendorReturn to Vendor DocumentThe Return to Vendorm_inoutline.M_InOut_ID numeric(10)
Search
RMA LineReturn Material Authorization LineDetail information about the returned goodsm_inoutline.M_RMALine_ID numeric(10)
Table Direct
Line NoUnique line for this documentIndicates 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
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_inoutline.M_Product_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe 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
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.m_inoutline.M_Locator_ID numeric(10)
Locator (WH)
ChargeAdditional document chargesThe Charge indicates a type of Charge (Handling, Shipping, Restocking)m_inoutline.C_Charge_ID numeric(10)
Table Direct
DescriptionOptional short description of the recordA description is limited to 255 characters.m_inoutline.Description character varying(255)
Text
QuantityThe Quantity Entered is based on the selected UoMThe Quantity Entered is converted to base product UoM quantitym_inoutline.QtyEntered numeric
Quantity
UOMUnit of MeasureThe UOM defines a unique non monetary Unit of Measurem_inoutline.C_UOM_ID numeric(10)
Table Direct
Movement QuantityQuantity of a product moved.The Movement Quantity indicates the quantity of a product that has been moved.m_inoutline.MovementQty numeric
Quantity
Picked Quantitym_inoutline.PickedQty numeric
Quantity
Target QuantityTarget Movement QuantityThe Quantity which should have been receivedm_inoutline.TargetQty numeric
Quantity
Confirmed QuantityConfirmation of a received quantityConfirmation of a received quantitym_inoutline.ConfirmedQty numeric
Quantity
Scrapped QuantityThe Quantity scrapped due to QA issuesm_inoutline.ScrappedQty numeric
Quantity
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.m_inoutline.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingm_inoutline.C_Activity_ID numeric(10)
Table Direct
Project PhasePhase of a Projectm_inoutline.C_ProjectPhase_ID numeric(10)
Table Direct
Project TaskActual Project Task in a PhaseA Project Task in a Project Phase represents the actual work.m_inoutline.C_ProjectTask_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe 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 OrganizationPerforming or initiating organizationThe 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 1User defined list element #1The 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 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.m_inoutline.User2_ID numeric(10)
Search

Tab: Confirmations

[Created: 11/09/2009 - Updated: 09/08/2013 ]
Description: Optional Confirmations of Return to Vendor Lines
Help: The quantities are in the storage Unit of Measure!
Tab Level: 2

Table 30: Confirmations - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 LineLine on Receipt documentm_inoutlineconfirm.M_InOutLine_ID numeric(10)
Search
Ship/Receipt ConfirmationMaterial Shipment or Receipt ConfirmationConfirmation of Shipment or Receipt - Created from the Shipment/Receiptm_inoutlineconfirm.M_InOutConfirm_ID numeric(10)
Search
Ship/Receipt Confirmation LineMaterial Shipment or Receipt Confirmation LineConfirmation detailsm_inoutlineconfirm.M_InOutLineConfirm_ID numeric(10)
ID
Confirmation NoConfirmation Numberm_inoutlineconfirm.ConfirmationNo character varying(20)
String
Target QuantityTarget Movement QuantityThe Quantity which should have been receivedm_inoutlineconfirm.TargetQty numeric
Quantity
Confirmed QuantityConfirmation of a received quantityConfirmation of a received quantitym_inoutlineconfirm.ConfirmedQty numeric
Quantity
DifferenceDifference Quantitym_inoutlineconfirm.DifferenceQty numeric
Quantity
Scrapped QuantityThe Quantity scrapped due to QA issuesm_inoutlineconfirm.ScrappedQty numeric
Quantity
DescriptionOptional short description of the recordA description is limited to 255 characters.m_inoutlineconfirm.Description character varying(255)
String

Tab: Attributes

[Created: 11/09/2009 - Updated: 16/04/2014 ]
Description: Product Instance Attribute Material Allocation
Help:
Tab Level: 2

Table 40: Attributes - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant 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
OrganizationOrganizational entity within tenantAn 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 LineLine on Receipt documentm_inoutlinema.M_InOutLine_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe 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 QuantityQuantity of a product moved.The Movement Quantity indicates the quantity of a product that has been moved.m_inoutlinema.MovementQty numeric
Quantity
Date Material PolicyTime used for LIFO and FIFO Material PolicyThis field is used to record time used for LIFO and FIFO material policym_inoutlinema.DateMaterialPolicy timestamp without time zone
Date