Dropship的流程

原创 2012年04月06日 15:52:50
做的一个Dropship流程的实录(包括流程期间遇到问题的解决)

What are the advantages of Drop Shipment Orders?

These are the benefits:
  • No inventory is required
  • Reduced order fulfillment processing costs
  • Reduced flow times
  • Elimination of losses on non-sellable goods
  • Elimination of packing and shipping costs
  • Reduced inventory space requirements
  • Reduced shipping time to your customer
  • Allows you to offer a variety of products to your customers

1.png
2.png
3.jpg
How to understand the dataflow for Drop shipment Orders?
To understand, here are the processes divided in sub process and the underline activity is highlighted here:
4.png


Here are the Details as per Mark

1.Order Entry
Here the activity is entering process where oe_order_headers_all (flow_status_code as entered) oe_order_lines_all . The order is booked asDROP SHIP
2. Order Booking
3.
The Purchase Release program passes information about eligible drop-ship order lines toOracle Purchasing.The interface table which gets populated is
po_requisitions_interface_all
4. After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders
7. After the goods are successfully received invoices for vendors are created in accounts payables as in normal purchase orders.
8. Invoices are generated for customers In account receivables.
9. oe_order_lines_all (flow_status_code 'shipped', open_flag "N")
10. oe_order_lines_all (flow_status_code 'closed', open_flag "N")

DropShip的工作场景:
企业A向客户B销售产品,但是企业A本身并不生产该产品,而是向供应商C来采购,并且在大部分的情况都是C向B直接发货,也就是说企业A大部分的交易都是贸易,属于贸易型企业,除了贸易型企业,对于一些集团公司的销售公司或门店也采用这种销售方式。即‘左手倒右手’。

1.create a item,and ensure this item have purchasable and salable properties.
(according step 4 error,we should also type a value to list price field).
5.png
2.Create a sale order,and ensure 'Source Type'  is 'External'.
if source type is 'Internal',it stand for that you will sale item from your stock.
if source type is 'External',it stand for that you will sale item from other supplier.(Drop ship Way)
6.png

3.The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is
po_requisitions_interface_all
7.png

4.After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders
8.png

After requisition import,In PR summary form,Try to find your PR.
9.png
10.png


But can Not find my PR.
Execute below query,
SELECTe.error_message
FROM   po_requisitions_interface_all i, PO_INTERFACE_ERRORS e
WHERE   i.TRANSACTION_ID=e.INTERFACE_TRANSACTION_IDAND item_id =25875
Error is:This item is missing a list price in the item master setup window. Please enter a list price greater than zero (0) in the item master.

Then go back to Master item form,type a value to List price,

11.png

Becasue Req Import does not pick up interface records that previously failed.we also need updateprocess_flag from 'ERROR' to 'FUTURE'.
Script like:
update po_requisitions_interface_allset process_flag='FUTURE'where item_id= 25875


Then re-run Requisition Import request.PR got generated sucessfully.
12.png

5.Auto create PO
13.png
6.PO approve
14.png


7.Receipt&Delivery
15.png

9.After receipt,a sale order issue txn will automaticlly generate.
16.png
Sale order line is closed.
17.png

Once customer receipt the PO,Then you can take the AR which created by SO to customer,
Customer will give amount 1350 to you
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7432647

 

版权声明:转载请以链接形式注明出处

相关文章推荐

最新系統簽核流程類源碼

  • 2017年11月17日 14:07
  • 103.93MB
  • 下载

24. Dubbo原理解析-编码解码之编码解码流程

这里把ExchangeCodec和DubboCodec放一起来讲解dubbo传输的底层协议组成以及它的编码解码过程。   传输协议 协议格式 协议头 :header 是16个字节的定长数据    = ...

驰骋OA, 工作流程引擎采用了CCFlow

  • 2017年11月15日 09:28
  • 81.23MB
  • 下载

wpf流程设计界面

  • 2017年11月02日 15:41
  • 397KB
  • 下载

Android 音量控制流程分析

在Android平台上,音量键,主页键(home),都是全局按键,但是主页键是个例外不能被应用所捕获。下面分析一下音量按键的流程,主要从framework层处理开始,至于 EventHub 从驱动的/...

Android 4.4Telephony流程分析SIM卡开机时的初始化

本文代码以MTK平台Android 4.4为分析对象,与Google原生AOSP有些许差异,请读者知悉。 本文主要介绍MTK Android开机时,SIM卡的Framework部分初始化过程。 ...
  • jwc2436
  • jwc2436
  • 2015年12月03日 17:43
  • 1038

STM32启动流程

  • 2017年10月13日 11:02
  • 270KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Dropship的流程
举报原因:
原因补充:

(最多只允许输入30个字)