Skip to main content

Drop Ship Set-up and Steps

To process a Drop Ship for Standard Item from entry to invoice for different orgs in different set of books.

Item
Functional Test
Steps/References
Values/Entries
1
Enter order
Login to the Ordering Organization
The person entering the order must be setup as a 'Buyer' in Purchasing: Purchasing > Setup > Personnel > Buyers

OM Responsibility > Order, Returns > Sales Order
Main Tab:
Customer: Enter your customer
Order Type: Enter a standard order type
Price List: Enter Price List
Salesperson: Select any from LOV
Others Tab:
Warehouse: Select your Receiving Organization from the LOV
Line Items Tab:
Line 1.1
Ordered Item: Enter the item to be dropped shipped
Qty:  2
Request Date: Sysdate
Shipping Tab:
Source Type: External
Receiving Org: Your receiving organization
Save
Sales Order Number:
2
Book the order
Click the Book Order Button
Verify:
Order Header Status: Booked
Line Status: Awaiting Receipt
If line status is not at 'Awaiting Receipt', run the Workflow Background Process
OM Responsibility > Report, Requests > Run Requests: Workflow Background Process
Item Type: OM Order Line
Process Deferred: Yes
Process Timeout: No
Click Submit
Line Status:
3
Run Requisition Import
Login to the Receiving Organization
It is best to logon with a different user id then the ordering person.  This new user id must be associated with a person who has been setup as an 'Approver' in the new Set of Books.
Refer to Note: 295070.1 for detailed instructions.
OM Responsibility > Orders, Returns > Requisition Import:
Import Source: Order Entry
Click OK
Click Submit
Request Id:
4
View Requisition Information
Log on to the responsibility where the order is created
OM Responsibility > Orders, Returns > Order Organizer
Query the Sales Order
Line Items:
Place the cursor at line 1.1
Click on Actions > Additional Line Information > Drop Ship Tab
Document the Requisition Number
Requisition Number:
5
Create Purchase Order from the Requisition
Login to the Receiving Organization
Purchasing Responsibility > AutoCreate
Find Requisition Lines:
Requisition: Enter Requisition No.
Clear the Buyer Field
Click the Find Button
AutoCreate Documents:
Select the Requisition Line
Click the Automatic Button
Select the Supplier
Click the Create Button
Document the PO Number
PO Number:
6
Approve the PO
AutoCreate to Purchase Orders:
Click the Approve Button
Approval:
Submit for Approval: Checked
Click Ok
Verify that the Status of the PO is 'Approved'
Status:
7
View the PO Information
View the PO Information in the Responsibility where the order is created.  See Step 4.
Purchase Order:
Status:
8
Receive the full Qty
Login to the Receiving Organization
Purchasing Responsibility > Receiving > Receipts
Find Expected Receipts:
Purchase Order: Enter Purchase Order No
Click Find
Radio Button: New Receipt.
Lines Tab:
Check the Line
Destination Type: Inventory
Subinventory: Enter Subinventory
Save
A receipt number will be generated and will be visible in the Receipts Header Form
Receipt Number:
9
Verify the Receiving Transactions
Purchasing Responsibility > Receiving > Receiving Transactions Summary
Supplier and Internal Tab:
Receipt: Enter Receipt Number
Click Find
Click Transactions
Verify there are two transactions: Receiving and Deliver Type
 Transaction Types:
10
Verify the status of the line
Login to the Ordering Organization
OM Responsibility > Orders, Returns > Order Organizer.
Query the Order
Click the Open Button
Line Items Tab
Main Tab
Line 1.1
Status: Shipped
Shipping Tab
Quantity Shipped: 2 
Status:
Qty Shipped:
11
Verify the Workflow Status of the Line
Tools > Workflow Status
If the Line Status is 'Fulfilled - Deferred'
Run the Workflow Background Process
See Step 2
Workflow Line Status:
12
Run Auto Invoice
Receivables > Interfaces > AutoInvoice > AutoInvoice Master Program
Invoice Source: ORDER ENTRY
Default Date: Sysdate
(Low) Sales Order Number: Order Number
(High) Sales Order Number: Order Number
Click OK
Click Submit

13
Verify Invoice
OM Responsibility > Orders, Returns > Order Organizer
Query the Sales Order
Line Items:
Place the cursor at line 1.1
Click on Actions > Additional Line Information > Invoices/Credit Memo Tab
Document Invoice Number
Invoice Number:


Key Setups

1.  System Administrator - The person entering and executing Requisition Import must be setup as a 'Buyer' and 'Approver'.  See Note: 295070.1 - Setup Buyer and Approver for Drop Ships.
2.  Inventory - Drop Ship items must be defined in the ordering and receiving organization.
3.  Item Attributes:
            Inventory: Inventory Item, Stockable, Transactable, Reservable
         Purchasing: Purchased, Purchasable, List Price - must be entered
         Order Management: Customer Ordered, Customer Orders Enabled, OE Transactable
         Receiving: If set to 'Direct Delivery', the Receiving process completes in one step instead of two or more
***Checked for relevance on 10-04-2013**

Comments

Popular posts from this blog

General Ledger FAQ

1.  What responsibility should I use when doing the set up for General Ledger? Use a seeded responsibility like 'Oracle General Ledger Super User'. You may also need to use the System Administrator responsibility. 2.  What are the pre-requisites required to define a new calendar? According to your business needs you need to decide the calendar type required i.e. monthly, weekly or biweekly, the number of periods, adjusting periods and the maximum number of periods within a fiscal year. 3. What are the pre-requisites required to define a new Ledger? Define a Calendar, Chart of Accounts and enable the functional Currency  and convention of subledger accounting method. 4. Why must I check the calendar definition before assigning to a Ledger? The calendar definition cannot be changed once it is assigned to a set of books so it is very important to check that the calendar definition is suitable to the specific business needs, has been d

Difference Between MTS, ATO, MTO ,PTO ,CTO and ETO.

 Make-to-stock (MTS) In MTS environments, products are created before receipt of a customer order. Customer orders are then filled from existing stock, and then those stocks are replenished through production orders. MTS environments have the advantage of decoupling manufacturing processes from customer orders. Theoretically, this enables customer orders to be filled immediately from readily available stock. It also allows the manufacturer to organize production in ways that minimize costly changeovers and other disruptions. However, there are risks associated with placing finished goods into inventory without having a firm customer order or an established need. These risks tend to limit MTS environments to simple, low-variety, or commodity products whose demand can be forecasted readily.  Assemble-to-order (ATO) In ATO environments, products are assembled from components after the receipt of a customer order. The key components in the assembly or finishing process are pla

Accounting entries in Oracle Purchasing and Payables

This document gives in detail different accounts used and the accounting impact of various transactions that take place in Oracle Purchasing and Oracle Payables. Both Standard costing and Average costing methods are considered. The accounts are Oracle Applications specific and might differ from the conventional accounting names. Examples are given wherever required for better understanding of the concept. The sources of these accounts are given. PURCHASING:  Receiving – For Accrual Process for perpetual Accruals Receipts for inventory purchases are always accrued upon receipt. And also use perpetual accruals for expense purchases you want to record uninvoiced purchase liabilities immediately upon the receipt of the expense goods. Receiving Account (Receiving Account) To record the current balance of the material in receiving and inspection. Where to define in Apps: Define Organization                                          Define Receiving Options