错误 #359
Shortage process change
由 liuliguo liuliguo 在 将近 3 年 之前添加. 更新于 超过 2 年 之前.
描述
Hi Alan,
We are starting with just the highlighted changes, correct?
1. Have KD add the following text to Kingdee Order Notes when a Correction Order (replenishment（补货）) is created (with the rep manually populating the yellow values):
THIS IS A CORRECTION FROM SAL#______, INV_____. WE HAVE BILLED AND SHIPPED PARTS MISSING FROM YOUR ORDER.
CREDIT HAS BEEN ISSUED ON THE ORIGINAL INVOICE FOR PARTS NOT RECEIVED. PLEASE ACCEPT OUR APOLOGIES FOR THE SHORTAGE.
2. Have KD enable PO Approval creating WinDECS orders for Correction Orders
Thanks,
Steve
文件
| #359 方案(1).docx (16.5 KB) #359 方案(1).docx | 鑫 王, 2021-10-11 03:18 | ||
| #359测试报告.docx (469 KB) #359测试报告.docx | 鑫 王, 2021-10-14 06:46 |
由 鑫 王 更新于 超过 2 年 之前
修改视图
CREATE OR REPLACE VIEW V_SCM_SOTOPO AS
SELECT 'wYkAAAAACAjM567U' FPurchaseOrgUnitID,
'wYkAAAAAC3c3xn38' FSupplierID,
so.FSaleOrgUnitID FSaleOrgUnitID,
'91f078d7-fb90-4827-83e2-3538237b67a06BCA0AB5' FPaymentTypeID,
'e09a62cd-00fd-1000-e000-0b33c0a8100dE96B2B8E' FSettlementTypeID,
'wYkAAAAACiLetY/c' FCurrencyID,
100 FPrepaymentRate,
1 FExchangeRate,
so.FCompanyOrgUnitID FCompanyOrgUnitID,
1 FIsInTax,
so.cfsftransport cfsftransport,
so.FOrderCustomerID CFOrderCustomerID,
so.CFComplianceProfile CFCOMPLIANCEPROFILE,
so.CFDeliveryAddress CFDeliveryAddress,
so.CFBusinessPerson CFBusinessPerson,
so.CFBusinessNumber CFBusinessNumber,
so.CFBusinessEmail CFBusinessEmail,
so.CFLogisticPerson CFLogisticPerson,
so.CFLogisticNumber CFLogisticNumber,
so.CFLogisticEmail CFLogisticEmail,
so.CFSOType CFSOType,
so.CFNeedBookKeeping CFNeedBookKeeping,
so.CFHKDeliveryVendorID CFHKDeliveryVendorID,
so.CFIndustryID CFIndustryID,
so.CFUsage CFUsage,
so.CFDetailUsage CFDetailUsage,
so.CFDestinationID CFDestinationID,
so.CFEndUser CFEndUser,
so.CFSettlementNo CFSettlementNo,
so.CFOriginalPONo CFOriginalPONo,
so.Fdescription CFSoRemark,
so.FCustomerOrderNumber CFCustOrderNum,
so.CFWholevat CFWholevat,
so.CFShipmentType CFShipmentType,
so.CFRetentionDays CFRetentionDays,
so.CFOtherInfo CFKehuyaoqiu,
so.CFLogisticCom CFLogisticCom,
so.CFLogisticCode CFLogisticCode,
cust.FForeignName CFForeignName,
so.CFFinalUserWebSite CFFinalUserWebSite,
so.CFYongtu2ID CFYongtu2ID,
so.CFJutiyongtu2ID CFJutiyongtu2ID,
so.CFMingxiyongtuzhongwen CFMingxiyongtuzhongwen,
so.CFMingxiyongtuyingwen CFMingxiyongtuyingwen,
so.CFEndUser CFEnduseren,
cust.CFYingwendizhi CFKehushouhuodizhiyw7,
person.Fname_l2 CFSalesman,
so.CFExportcountry01I CFExportcountry01I,
so.CFExportcountry02I CFExportcountry02I,
so.CFExportcountry03I CFExportcountry03I,
so.CFExportcountry04I CFExportcountry04I,
so.CFExportcountry05I CFExportcountry05I,
so.CFExportcountry06I CFExportcountry06I,
so.CFCustRequest CFCustRequire,
so.CFDeliveryProvince CFDeliveryProvince,
so.CFDeliveryCity CFDeliveryCity,
so.CFDECSoID CFDECSoID,
so.CFProductResale CFProductResale,
so.CFEXCOUNTRYID CFEXCOUNTRYID,
so.CFEXCOMPANYBUSINESS CFEXCOMPANYBUSINESS,
so.CFEXADDRESS1 CFEXADDRESS1,
so.CFEXCITY CFEXCITY,
so.CFEXPOSAL CFEXPOSAL,
so.CFEXADDRESS2 CFEXADDRESS2,
so.CFEXPROVINCE CFEXPROVINCE,
so.CFEXCOMPANYBUSINESSEN CFEXCOMPANYBUSINESSEN,
so.CFEXCITYEn CFEXCITYEn,
so.CFEXADDRESS1EN CFEXADDRESS1EN,
so.CFEXADDRESS2EN CFEXADDRESS2EN,
so.CFIndustryNewID CFIndustryNewID,
so.CFIndustryDesc CFIndustryDesc,
so.CFYongtu2NewID CFYongtu2NewID,
so.CFJutiyongtu2NewID CFJutiyongtu2NewID,
so.CFMingxiyongtu_new CFMingxiyongtu_new,
so.CFMingxiyongtu_newen CFMingxiyongtu_newen,
so.CFEXPROVINCEEN CFEXPROVINCEEN,
so.FBizTypeID FBizTypeID,
so.FBillTypeID FSourceBillTypeID,
so.FBillTypeID FBillTypeID,
sysdate FBizDate,
so.CFINDUSTRYDESCEN CFINDUSTRYDESCEN,
to_number(TO_CHAR(sysdate,'yyyy')) FYEAR,
to_number(TO_CHAR(sysdate,'q')) FPERIOD,
0 FPREPAYMENT,
soe.fqty FTOTALAMOUNT,
0 FTotalTax,
soe.fqty FTOTALTAXAMOUNT,
1 FISPRICEINTAX,
1 fbasestatus,
so.CFProductResale CFReSales,
so.FID FSourceBillID,
newbosid('3171BFAD') fid,
so.CFContinousStripFlag ,
so.CFDateCodeFlag ,
so.CFDateCodeMonths ,
so.CFLotCodeFlag ,
so.CFCertComplianceFlag ,
so.CFAcceptPartialOrderFlag ,
so.CFPreference CFPreference,
so.CFShipCarrier CFShipCarrier,
so.CFCustRequest cfbeizhuyw2,
so.fid srcId,
so.cfcomwebsite cfcompanywebsite
FROM T_SD_SaleOrder so
LEFT JOIN T_BD_Person person
ON so.fsalepersonid = person.fid
LEFT JOIN t_bd_customer cust
ON so.fordercustomerid = cust.fid
LEFT JOIN
(SELECT SUM(fqty) fqty,
fparentid soId
FROM t_sd_saleorderentry
GROUP BY fparentid
) soe
ON so.fid = soe.soId
WHERE so.fbasestatus = 4;