关闭

Dropship的流程

标签: interfaceimportvalidationtableoraclelist
6802人阅读 评论(1) 收藏 举报
分类:
做的一个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

 

5
0
查看评论

Oracle EBS 中直发订单Drop Ship流程的系统操作记录

Oracle EBS 中直发订单Drop Ship流程的系统操作记录应用场景:A公司向客户B销售产品,但是自己不生产该产品,而是向供应商C来采购,并且通常是要供应商C直接把货发到B客户处,属于贸易型企业经常用到的业务流程,有些集团公司下的子公司销售业务也用这种方式。系统功能和流程:Oracle EB...
  • u012025054
  • u012025054
  • 2016-04-27 11:14
  • 8550

Dropship的流程

做的一个Dropship流程的实录(包括流程期间遇到问题的解决) What are the advantages of Drop Shipment Orders? These are the benefits: No inventory is requiredReduced order...
  • zhanzhib
  • zhanzhib
  • 2014-12-05 16:07
  • 265

Dropship

Dropship, 直运,即从供应商采购直接发送给客户的业务流程。
  • cmzhuang
  • cmzhuang
  • 2018-01-04 10:16
  • 24

Oracle EBS 中背靠背订单B2B订单流程的系统操作记录

Oracle EBS 中背靠背订单B2B订单流程的系统操作记录"背靠背"订单(Back To Back, B2B ) 是指订单行物料具有"采购"属性,但实际销售订单行需求生成之前,不预先作库存,而是由系统直接根据销售订单行生成采购需求(PR/PO) ,然后在采...
  • u012025054
  • u012025054
  • 2016-04-27 14:06
  • 4920

Dropship 无sales order issue产生

当做Dropship的测试时,只能在物料事务处理中查看到PO接收的事物处理,没有SO出库的记录 原因:查看Inv-->setup-->事务处理-->接口管理器 物料事物处理是否有效,工具-->启动 可以计划这个程序,然后就变为有效的了 Material Transac...
  • u011743883
  • u011743883
  • 2014-04-03 10:22
  • 317

zencart中Dropship与wholesale模块设置

在zencart首页导航里面的wholesale和 Dropship 页面里面文字是不能后台修改的,如果是我们的客户请组织替换材料,发给我们。这个模块主要功能是显示后台设定的wholesale 或者 Dropship分类, 这个可以zencart后台设置。如下后台进入 Wholesale ...
  • wengman
  • wengman
  • 2010-03-11 01:09
  • 546

ZenCart中Dropship与wholesale模块设置

在zencart首页导航里面的wholesale和 Dropship 页面里面文字是不能后台修改的,如果是我们的客户请组织替换材料,发给我们。这个模块主要功能是显示后台设定的wholesale 或者 Dropship分类, 这个可以zencart后台设置。如下Wholesale Categories...
  • yangjixiang_hao123
  • yangjixiang_hao123
  • 2010-04-21 16:54
  • 726

流程合理化的重要性

这周末我发现自己在前阵子陷入一种错误的唯心论中,认为只要培养起健康的团队文化,就可以做好开发,做好项目。从前面这半年的管理经验来看,这种强调团队文化思路下的确取得了一定成绩,但把这种思路放到更宏观的角度来看就不行了。一、在小型团队中,成员个人业务能力的总和是提高团队业绩的主要矛盾。我分析了一下,之所...
  • walzer
  • walzer
  • 2007-12-16 17:21
  • 2746

关于那些流程可视化

现在很多人才说数据可视化, 其实有无都接触过流程可视化呢?其实大家都有的,我们用的ide就是,mvc框架也是,事件驱动也是流程化(未必可视),但是下面这些我都做过,想想就可怕啊 最早要追溯到 2006年vb做的印刷工厂生产流程workflow (估计很难找到截图了,找到了发一下,真是经典啊)...
  • avi9111
  • avi9111
  • 2016-08-11 12:22
  • 943

Activiti 流程定义实例

流程定义实例 ProcessDefinition
  • caoyue_new
  • caoyue_new
  • 2016-08-09 17:39
  • 1062
    个人资料
    • 访问:4811895次
    • 积分:51495
    • 等级:
    • 排名:第66名
    • 原创:907篇
    • 转载:54篇
    • 译文:5篇
    • 评论:348条