Dropship的流程
来源:互联网 发布:胶州搭建网络 编辑:程序博客网 时间:2024/05/16 09:23
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
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:
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).
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)
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
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
After requisition import,In PR summary form,Try to find your PR.
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,
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.
5.Auto create PO
6.PO approve
7.Receipt&Delivery
9.After receipt,a sale order issue txn will automaticlly generate.
Sale order line is closed.
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
- Dropship的流程
- Dropship的流程
- Dropship的流程
- zencart中Dropship与wholesale模块设置
- ZenCart中Dropship与wholesale模块设置
- Dropship 无sales order issue产生
- 流程行业的MTS流程
- ccflow 的子流程与多线程流程
- 网站开发流程-WEB开发的流程
- 网站开发流程-WEB开发的流程
- nginx的启动流程和接客流程
- 流程填报-新版分支流程的使用
- 【最好的流程是没有流程】
- 播放器的流程和解码流程
- struts2的启动流程与请求流程
- struts的开发流程和执行流程
- app的启动流程和打包流程
- MapReduce的数据流程、执行流程
- seo优化-SEO实战密码—60天网站流量提高20倍
- 低价神话缔造者!宏碁A500最全面评测
- Jetty 分析
- 使用WinPcap编程
- java程序之出差补助计算
- Dropship的流程
- Oracle表分区
- 关于linux和windows的CR, LF, CR/LF 回车 换行问题
- 使用Apache Shiro进行身份认证-proxool配置
- 程序员面试宝典中的关于指针的题
- tomcat部署项目的另外一种方式
- ASP.NET MVC3中的Controller
- 腾讯微博开放平台API SDK vb版源码发布
- PB游标编程套路