HZ_CUST_SITE_USES_ALL SHIP,
HZ_CUST_ACCT_SITES_ALL SHCASA,
(SELECT FV.FLEX_VALUE, FV.FLEX_VALUE_MEANING, FV.DESCRIPTION
FROM FND_FLEX_VALUES_VL FV, FND_FLEX_VALUE_SETS FS
WHERE FV.FLEX_VALUE_SET_ID = FS.FLEX_VALUE_SET_ID
And FS.FLEX_VALUE_SET_NAME = 'XYG_ORDER_TYPE') OTP
Where WDV.source_header_id = OEH.header_id
And WDV.source_line_id = OEL.LINE_ID
And WDV.delivery_id = WNV.Delivery_Id
And WDV.organization_id = MSI.ORGANIZATION_ID
And WDV.inventory_item_id = MSI.INVENTORY_ITEM_ID
And OEH.sold_to_org_id = CIX.CUSTOMER_ID
And OEL.INVENTORY_ITEM_ID = CIX.INVENTORY_ITEM_ID
And OEH.order_type_id = OTT.TRANSACTION_TYPE_ID
And OTT.ATTRIBUTE1 = OTP.FLEX_VALUE
And OEH.invoice_to_org_id = BILL.SITE_USE_ID
And BILL.SITE_USE_CODE = 'BILL_TO'
And BILL.CUST_ACCT_SITE_ID = BHCASA.CUST_ACCT_SITE_ID
AND BILL.ORG_ID = BHCASA.ORG_ID
AND BHCASA.CUST_ACCOUNT_ID = OEH.sold_to_org_id
And OEH.ship_to_org_id = SHIP.SITE_USE_ID
And SHIP.SITE_USE_CODE = 'SHIP_TO'
And SHIP.CUST_ACCT_SITE_ID = SHCASA.CUST_ACCT_SITE_ID
And SHIP.ORG_ID = SHCASA.ORG_ID
And SHCASA.CUST_ACCOUNT_ID = OEH.sold_to_org_id
And WDV.SOURCE_HEADER_NUMBER = '221111030001'
And WDV.released_status = 'C' --已发运或已连接
And WDV.INV_INTERFACED_FLAG = 'Y' --表示发运事务处理下一步“不适应”
And WDV.shipped_quantity > 0 --发运数量一定大于0才产生应收
And Not Exists ---不存在接口表中
(Select 'x'
From RA_INTERFACE_LINES_ALL RIL
Where RIL.Org_Id = OEH.org_id
And RIL.INTERFACE_LINE_ATTRIBUTE6 = WDV.source_line_id
And RIL.INTERFACE_LINE_ATTRIBUTE3 = WNV.Name)
And Not Exists ---未产生应收事务处理
(Select 'X'
From RA_CUSTOMER_TRX_LINES_ALL RAL
Where RAL.ORG_ID = OEH.ORG_ID
And RAL.INTERFACE_LINE_ATTRIBUTE1 = WDV.SOURCE_HEADER_NUMBER
And RAL.INTERFACE_LINE_ATTRIBUTE6 = WDV.source_line_id);
接口表插入需要的数据。注意:以上SQL仅供考参非准标。
下面应收-->接口-->自动开票,提交“自动开票主程序”并且录入对应的参数。但是请求提交完成不是很顺利。发生不少错误。
1.此库存项的“启用发票”标志设置为“否”，请在“项目”窗体中将此库存项的“启用发票”标志设置为“是”
2.如果没有使用自动开票结算帐户，则提供的金额必须与销售单价乘以数量而算出的金额匹配；输入的金额没有正确的币种精确度.
再次提交“自动开票主程序”，就成功导入到应收事务处理中。
最后，终于明白为什么销售订单发运确认没有产生数据到应收接口表中，原来是订单中的物料在主组织物料中没有设置“启用开票”为是。