资源描述:
《用友时空采购流程讲解课件》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、采购沙盘用友时空供应链管理CDMKSOACCERPSCMSV7注册正版注册QQ84777206提纲采购入库流程采购退出流程采购退补价流程提纲采购入库流程采购退出流程采购退补价流程采购入库流程图采购入库流程及考核点分析采购订单采购订单可以不需要审核。考核点:单据高级选项。实现方法:【提取审核后订单】设置为“否”。2.订单数据允许分批提取。考核点:单据高级选项。实现方法:【允许订单多次执行】设置为“是”。采购入库3.自动生成订单。考核点:函数zidshchqhd的使用方法。zidshchqhd函数可以自动按库存上限、合理库存、往日销售商品、当日销售商品、实际销售量提取商品填写单据。实现方法
2、:【操作项—单据菜单】添加一个二级菜单,执行函数为“zidshchqhd”。采购入库采购开票采购开票单能导入excel格式数据。考核点:时空数据导入方法。DJExcel.ini应用。实现方法:1.维护DJExcel.ini中字段;插入1=insertintotmp_excel_dj(gzid,spbh,spmch,shpgg,jlgg,shpchd,dw,shl,je,pihao,sxrq,插入2=baozhiqi,itemlength,itemheight,itemwidth,weight,beizhu,jixing,tongym,pizhwh)IN[ODBC]插入3=[ODBC;D
3、river=SQLServer;UID=sa;PWD=:password;Server=:server;DataBase=:database]插入4=select:gzid,a.商品编号,a.商品名称,a.商品规格,a.包装数量,a.产地,a.包装单位,插入5=a.数量,a.金额,a.批号,a.有效期至,a.生产日期,插入6=a.单品长,a.单品高,a.单品宽,a.单品重量,a.备注,a.剂型,a.通用名,a.批准文号插入7=from[Sheet1$]a采购入库2.创建临时表,维护临时表tmp_excel_dj中字段;gzidcharspbhcharspmchcharshpggchar
4、dwcharbaozhshlcharlingsshlcharjlggcharshlintkoulchardjdecimalhshjdecimaljedecimalshedecimalspidcharitemlengthcharitemheightcharitemwidthcharweightcharjixingchartongymcharpizhwhcharsxrqdatetimebaozhiqidatetimehscbjdecimalhescbjdecimalhsjedecimallshjdecimalpihaocharshpchdcharbeizhuchar采购入库3.修改存储过程
5、(添加、减少字段)select*from(selectb.spid,a.spbh,casewhenb.spidisnullthen'新品!'elseb.spmchendasspmch,b.shpgg,b.shpchd,b.dw,b.jlgg,a.pihao,a.sxrq,casewhenisdate(a.baozhiqi)=1thenconvert(char(10),cast(a.baozhiqiasdatetime),20)elseisnull(a.baozhiqi,'')endbaozhiqi,sum(a.shl)asshl,cast((isnull(sum(a.je),0)/ca
6、sewhenisnull(sum(a.shl),0)=0then99999999999elsesum(a.shl)end)asdecimal(14,5))asdj,(isnull(sum(a.je),0)/casewhenisnull(sum(a.shl),0)=0then99999999999elsesum(a.shl)end)ashshj,casewhenb.spidisnullthen'clRed'else'clBlack'endas__fcolor,'default'as__bcolor,a.jixing,a.itemlength,a.itemheight,a.itemwidt
7、h,a.weight,a.beizhu,a.pizhwh,a.tongymfromtmp_excel_dja(nolock)leftjoinspkfkb(nolock)onb.beactive='是'anda.spmch=b.spmchanda.shpgg=b.shpgganda.jlgg=b.jlggwherea.gzid=@gzidgroupbyb.spid,a.spbh,b.spmch,b.shpgg,b.shpchd,b.dw,b.jl