软件由直营店切换成加盟店解决方案(龚建情、廖诚)

国泽堂直营店切换成加盟店解决方案国泽堂直营店切换成加盟店解决方案 前景 1 部分门店在软件里走的直营模式 走配送退仓单 现在软件里又走了配送单 现由于 想对直营店各门店配送价进价加价或低价处理 技术分析 1 门店把所有的单据都处理完 门店验收确认单 配送单 退仓单 店间调拨单等 2 单据处理完毕后 得把 DIS DIR 修改成 ADD ADR 第一步 业务机构编码 配送类型修改为 加价配送 机构类型修改为 本区域加 盟店 总部 update c org busi set orgtype 30 sendtype 2 whlgroup 001 where busno 0001 第二步 配送单屏蔽触发器处理 总部与门店都得处理总部与门店都得处理 更新门店验收确认单回写 u dist c验收数量 更新u dist c里md wareqty if object id tempdb disable u dist m is null create table disable u dist m id int update u dist m set billcode case when billcode ADD then DIS when billcode ADR then DIR else billcode end distype case when billcode add then dis when billcode adr then dir else billcode end drop table disable u dist m if object id tempdb disable u dist C is null create table disable u dist C id int update u dist C set addpurprice purprice avgpurprice purprice md wareqty wareqty 门店验收确认单回写u dist c验收数量 drop table disable u dist C 3 关于之前产生的 ACC 批次处理的处理 不再产生新批次 直接修改 u store i 表里 总部总部 第三步 修改批准里srcbatchno srcidno update u store i set srcbatchno batchno srcidno idno 4 第四步 登记门店往来账u busno account 总部总部 门店财务往来登记存储过程 if OBJECT ID p busno account is not null drop proc p busno account go 登记门店往来账u busno account create proc p busno account as select srcbusno case when a billcode in ADD DIS THEN a srcbusno else a objbusno end direct case when a billcode in ADD DIS THEN 1 else 1 end objbusno case when a billcode in ADD DIS THEN a objbusno else a srcbusno end a billcode billno a distno b wareid batchno case when a billcode ADR THEN b objbatchno else b batchno end idno case when a billcode ADR THEN b objidno else b idno end stallno case when a billcode in ADD DIS THEN b srcstallno else b objstallno end b wareqty a execdate a paytype payedqty 0 status 0 purprice case when dbo f sys ini 2693 2 then isnull d distprice b purprice else case when a billcode in ADD ADR THEN b addpurprice else b purprice end end b purtax notes null into a from u dist m a u dist c b c org busi c u store i d where a distno b distno and a billcode in ADD ADR DIS DIR and case when a billcode in ADD DIS THEN a objbusno else a srcbusno end c busno and c orgtype 30 and b wareid d wareid and b batchno d batchno and b idno d idno and a status 1 INSERT INTO u busno account srcbusno direct objbusno billcode billno wareid batchno idno stallno wareqty execdate paytype payedqty status purprice purtax notes select srcbusno direct objbusno billcode billno wareid batchno idno stallno sum wareqty max isnull execdate GETDATE max paytype payedqty max status purprice purtax notes from a a where not exists select from u busno account b where a objbusno b objbusno and a billcode b billcode and a billno b billno and a wareid b wareid and a batchno b batchno and a idno b idno and a stallno b stallno group by srcbusno direct objbusno billcode billno wareid batchno idno stallno payedqty purprice purtax notes if error 0 begin rollback raiserror 生成加盟店往来明细出错 16 1 return end drop table a go 执行存储过程 exec p busno account go 避免后期麻烦 给客户造成困扰 干净处理 统一库存清0 再进行期初库存切换 5 期初库存导入 分门店导入 导成 未生效的未生效的 验收入库单 select IDENTITY int 1 1 as idno 1 as direct b wareid 0001 as stallno isnull a wareqty 0 as wareqty i purprice as purprice 17 as purtax isnull i makeno as makeno i makedate as makedate i invalidate as invalidate as acb batchno as acb no as acb idno 0 0000 as acb qty as cker1 as cker2 as cker3 as notes 0 0000 as leastpriceo 0 0000 as leastpricen f saleprice as saleprice 0 0000 as whlpriceo 0 0000 as whlpricen i purprice as purpriceo 1 as rowid 0 0000 as indentqty replace convert varchar 10 case when ISDATE i invalidate 1 then 2035 12 31 else i invalidate end 121 as invalidate char i vendorno as bak1 as bak2 as bak3 as bak4 as bak5 as bak6 as bak7 as bak8 1 00 as maxqty 1 00 as midqty null as batchno act null as idno act 0 as indentprice case when f prod add like batchno then 001 else null end as prodid as seal stall 0 as flag2 as indentno as checkstallno as chkcont as chkresult i purprice as backprice 0 as Bioavailability as sterilemakeno as chk as groupid i purprice as purprice no i vendorno as vendorno case when f producer like batchno then 001 else null end as prod addid a busno into tempacceptc from u store c a u ware ext b u ware q f u store i i where a wareid b wareid and b wareid f wareid and f wareid i wareid and a batchno i batchno and a idno i idno and a busno 0001 and a wareqty 0 declare acceptno varchar 30 BEGIN exec p skip ACC if error 0 begin rollback raiserror 20003 生成入库单编号失败 return end select acceptno rtrim serialno from dbo f get serialno ACC if error 0 begin rollback raiserror 20004 生成入库单编号失败 return end INSERT u accept c acceptno idno direct wareid stallno wareqty purprice purta x makeno makedate invalidate acb batchno acb no acb idno acb qty cker1 cker2 cker3 notes leastpriceo leastpric en saleprice whlpriceo whlpricen purpriceo rowid indentqty invalidate char bak1 bak2 bak3 bak4 bak5 bak6 bak7 bak8 max qty midqty batchno act idno act indentprice prodid seal stall flag2 indentno checkstallno chkcont chkresult backprice Bi oavailability sterilemakeno chk groupid purprice no prod addid select acceptno a busno max idno max direct wareid max stallno sum wareq ty max purprice max purtax max makeno max makedate max invalidate max acb batchno max acb no max acb id no max acb qty max cker1 max cker2 max cker3 max a notes max le astpriceo max leastpricen max saleprice max whlpriceo max whlpricen max purpriceo max rowid max inden tqty max invalidate char max a bak1 max a bak2 max a bak3 max a bak4 max a bak5 max a b ak6 max a bak7 max a bak8 max maxqty max midqty null null max indentprice max prodid max seal stall max flag2 max indentno max checkstallno max chkcont max chkresult max backprice max Bioavailability m ax sterilemakeno max chk max groupid max purprice no max prod add id from tempacceptc a group