K3工业购销存手册

1、目 录目 录1一、工业物流初始设置111.1工业初始化111.1.1初始化参数设置111.1.1处理流程111.1.1.2相关的数据结构：111.1.1.3其他131.1.2初始化功能流程131.1.2.1.初始数据录入131.1.2.2流程131.1.2.3传递余额到总帐151.1.2.4初始余额数据录入和保存：icinvinitial181.1.2.5初始化数据的规则191.1.3结束初始化211.3.1检查条件如下211.1.3.2结束初始化过程211.1.3.3结束初始化的处理内容211.1.4 反初始化211.1.5初始化以前三类单据221.2工业系统参数设置231.2.1系统设置2

2、31.2.2编码规则设置231.2.3打印控制241.2.4单据科目类型241.2.5工业整体选项：共17项241.2.6采购系统选项：共10项241.2.7销售系统选项：共11项251.2.8仓存系统选项251.2.9核算系统选项 共11项251.2.10成本核算共4项261.2.11生产系统选项共11项261.2.12车间1项261.2.13 业务流程设计应用:261.2.14其他：271.3工业辅助功能271.3.1多级审核271.3.2供应商供货信息281.3.3物料对应表291.3.4价格资料301.3.5折扣资料311.3.6信用管理321.3.7批号管理331.3.8条形码，条形

3、码关联341.3.9客户bom和批号对应表34二、采购系统362.1采购申请单362.1.1采购申请单的生成362.1.1.1采购申请单的手工录入362.1.1.2单据新增362.1.1.3单据模板362.1.1.4相关的数据结构372.1.1.5采购申请单根据库存生成（足缺料分析）382.1.1.6根据物料配套查询生成：略382.1.1.7选单录入（关联销售订单生成采购申请单）382.1.2采购申请单的业务和操作402.1.2.1审核和反审核402.1.2.2关闭和反关闭402.1.2.3作废和反作废，单据合并412.2采购订单422.2.1采购订单单据功能422.2.1.1新增采购订单42

4、2.2.1.2采购订单通过关联采购申请单生成442.2.1.3采购订单通过关联采购合同生成442.2.1.4单据复制452.2.2订单的业务462.2.2.1审核与反审核462.2.2.2关闭和反关闭462.2.2.3部分关联472.2.2.4订单追加执行472.2.3关联和下推生成472.2.4采购业务报表482.2.4.1采购订单执行情况汇总表482.2.4.2采购订单执行情况明细表492.3收料通知单492.3.1收料通知单据功能492.3.1.1手工新增492.3.1.2审核与反审核512.3.1.3关闭与反关闭512.3.2收料通知单业务功能522.3.2.1下推生成质检单522.3

5、.2.2下推退料通知单522.4外购入库单532.4.1业务描述532.4.1.1单价的传递关系532.4.1.2库存更新、数量反填532.4.2单据功能542.4.2.1.新增单据542.4.2.2选单生成条件542.4.3业务功能552.4.3.1单据审核、反审核552.4.3.2作废、反作废552.4.4表结构562.5购发票582.5.1业务描述582.5.1.1发票钩稽费用发票的计算与分配582.5.2数据流程592.5.2.1新增单据592.5.2.2关联生成592.5.2.3复制单据：同单据新增602.5.2.4发票审核602.5.2.5反审核622.5.2.6作废与反作废622

6、.5.2.7单据拆分与合并632.5.2.8下推生成收货单642.5.2.9下推生成外购入库单642.5.2.10生成费用发票642.5.2.11下推生成反向发票：652.5.3采购发票对等核销652.5.3.1对等核销条件652.5.3.2对等核销对发票状态的影响662.5.3.3对等核销发票的账务处理662.5.3.4数据处理662.5.3.5反对等核销662.5.4采购发票报表671.5.4.1采购发票明细表672.6退料通知单672.6.1退料通知单的反向作用672.6.2数据流程682.6.2.1单据模板682.6.2.2新增单据682.6.2.3 审核、反审核682.6.2.4作废

7、、反作废692.6.2.5下推生成外购入库单692.6.2.6关闭和反关闭692.7委外加工702.7.1委外加入库工业务702.7.1.1委外加工入库单据模板702.7.1.2单据新增702.7.1.3审核与反审核712.7.1.4关联生产任务单生成712.7.2红字和蓝字委外加工入库单的对等核销712.7.2.1对等核销条件712.7.2.2对等核销对入库单状态的影响722.7.2.3对等核销单据的账务处理722.7.2.4数据处理过程722.7.3委外加工出库732.7.3.1单据模板732.7.3.2生成单据732.7.3.3单据审核与反审核742.7.3.4关闭、反关闭742.7.3

8、.5作废与反作废742.7.4 委托加工报表742.7.4.1委托加工材料明细表（委托加工出库材料）742.7.4.2委托加工材料汇总表752.8费用发票762.8.1费用发票的业务762.8.1.1费用发票的业务要求762.8.1.2委外加工入库单和费用发票的钩稽审核772.8.2业务数据描述772.8.2.1单据模板772.8.2.2新增772.8.2.3采购发票连属生成费用发票782.8.2.4委外加工入库单连属生成费用发票782.8.2.5费用发票审核，反审核（以委外加工入库为例）792.8.3费用发票报表802.8.3.1费用发票明细表802.8.3.2汇总费用发票汇总表80三、销售

9、系统833.1销售报价单833.1.1业务描述833.1.2数据过程描述833.1.2.1单据模板833.1.2.2单据新增833.1.2.3审核、反审核843.1.2.4按价格折扣信息查询录入843.1.2.5销售报价单通过下推式关联按购货单位（来源）生成销售订单843.1.2.6作废、反作废853.3.1表结构853.2销售订单863.2.1业务描述（销售请见订单帮助）863.2.2 单据业务863.2.2.1单据模板863.2.2.2单据新增873.2.2.3 审核、反审核873.2.2.4作废、反作废873.2.2.5关闭和反关闭883.2.2.6锁库与解锁883.2.2.7可签约量查

10、询、冲减、反冲893.2.2.8销售订单追加执行903.2.2.9销售订单下推关联直接生成发货通知单913.2.2.10 销售订单下推关联直接生成产品入库923.2.2.11销售订单下推关联直接生成生产任务单933.2.2.12销售订单下推关联直接生成生成销售发票生成销售发票（普通）943.2.2.13销售订单关联合同生成943.2.3销售订单报表943.2.3.1销售订单统计表943.2.3.2销售订单执行情况汇总表953.2.4表结构953.3发货通知单993.3.1数据流程描述993.3.1.1单据模版993.3.1.2新增993.3.1.3审核、反审核993.3.1.4关闭、反关闭，作

11、废、反作废1003.3.1.5下推单据（发货通知单下推生成生成销售出库）1003.3.1.6发货通知单下推生成调拨1003.3.1.7 发货通知单下推生成退货通知单1013.3.2表结构1013.4销售出库单1033.4.1数据描述1033.4.1.1单据模版1033.4.1.2单据新增1033.4.1.3审核，反审核1033.4.1.4作废、反作废1043.4.2销售出库单和销售出库单的拆单和合并1043.4.2.1拆单和合并的条件1043.4.2.2拆分单据的影响和单据存在形式：（可以参考帮助）1053.4.2.3拆分过程1053.4.3合并单据1053.4.4销售出库单的对等核销1063

12、.4.4.1对等核销条件1063.4.4.2对等核销对出库单状态的影响1073.4.4.3核销过程1073.4.4.4反核销过程1073.4.5单据关联生成1083.4.5.1销售出库生成红字销售出库1083.4.6 销售出库报表1083.4.6.1销售出库汇总表1083.4.6.2销售出库明细表1093.4.7表结构：见出入库单据表，单据类型为211093.5销售发票1093.5.1数据描述1093.5.1.1单据模版（专用）1093.5.1.2单据新增1103.5.1.3审核、反审核1103.5.1.4作废、反作废1113.5.1.5拆分、合并1113.5.1.6下推生成发货通知单1113

13、.5.1.7下推退货通知单1123.5.1.8下推红字发票（以专用为例）1123.5.1.9下推生成出库单1133.5.1.10.对等核销、反核销1133.5.2销售发票报表1133.5.2.1销售收入统计表1133.5.2.2客户单位销售情况明细表功能1143.5.2.3销售退货统计表1143.5.3销售表结构1143.6退货通知单1163.6.1数据描述1163.6.1.1单据模版1163.6.1.2单据新增1173.6.1.3审核、反审核1173.6.1.4.关闭、反关闭1173.6.1.5. 下推生成出库单1173.6.1.6关联发票生成1183.6.1.7表结构同发货通知单1183.

14、7销售报表1193.7.1销售毛利润表1193.7.2产品销售增长分析表1193.7.3产品销售增长流向表1193.7.4产品销售结构分析表1203.7.5信用数量分析表1203.7.6信用额度分析表1213.7.7信用期限分析表121四、仓存系统1234.1其他入库1234.1.1业务描述1234.1.2业务数据描述1234.1.2.1单据模板1234.1.2.2单据新增1234.1.2.3审核、反审核1244.1.3其他入库单分类表1254.2其他出库1254.2.1业务描述1254.2.2业务数据描述1264.2.2.1单据模板1264.2.2.2单据新增1264.2.2.3审核、反审核

15、1264.2.3其他出库单分类表1274.3仓库调拨1274.3.1业务定义1274.3.2业务数据描述1274.3.2.1单据模板1274.3.2.2新增单据1274.3.2.3审核和反审核（审核更新及时库存）1284.4虚仓管理1294.4.1赠品管理业务1294.4.1.1赠品形式主要有以下几种1294.4.2赠品入库1294.4.2.1模板1294.4.2.2新增单据1304.4.2.3审核、反审核（审核更新及时库存）1304.4.2.4下推生成其他入库单1304.4.2.5下推生成赠品出库单1314.4.2.6外购入库连属生成赠品入库单1314.4.3赠品出库1324.4.3.1模板

16、1324.4.3.2.新增单据1324.4.3.3审核、反审核（审核更新及时库存）1324.4.3.4下推生成赠品入库单1334.4.4虚仓调拨1334.4.4.1业务内容1334.4.4.2 单据模板1334.4.4.3新增单据1344.4.4.4审核和反审核（审核更新及时库存）1344.4.5报表1344.4.5.1赠品出入库汇总表1344.4.5.2赠品出入库明细表1364.4.5.3代管待检物料收发台账1364.4.5.4代管待检物料收发日报表1374.5盘点作业1374.5.1盘点业务业务描述1374.5.2盘点作业的数据流程1384.5.3录入盘点数据1394.5.4.盘点报告单1

17、394.6库存调整业务1404.6.1盘盈入库单1404.6.1.1单据模板1404.6.1.2新增单据1404.6.1.3审核和反审核（审核更新及时库存）1414.6.2盘亏出库单1414.6.2.1单据模板1414.6.2.2新增单据1414.6.2.3审核和反审核（审核更新及时库存）1424.7库存查询1424.7.1即时库存查询业务描述1424.7.2数据描述1424.8库存状态查询1444.8.1库存状态查询业务1444.8.2数据描述1444.9报表1454.9.1库存台账1454.9.2出入库流水账1484.9.3物料收发汇总表1514.9.4物料收发明细1544.9.5收发业务

18、汇总表1564.9.6物料收发日报表1574.9.7生产任务执行情况明细表1594.9.8超储短缺库存分析表1614.9.9库存账龄分析表1624.9.10库存abc分析1634.9.11库存呆滞料分析表1644.9.12保质期预警分析表1654.9.13生产批次跟踪表1664.9.14物料批次跟踪1674.9.15库存配套分析表1694.10质量检验1704.10.1业务描述1704.10.2数据描述1704.10.2.1质检方案1704.10.2.2检验单1714.10.2.3采购质量检验统计表：1724.10.2.4 物料鉴别供应商质量比较表1724.10.2.5完工入库质量表172五、

19、核算1735.1外购入库核算1735.1.1参与核算的发票1735.1.2费用分配过程1735.1.3核算过程1735.2出库核算1745.2.1各种计价方法的基本算法1745.2.1.1加权平均法1745.2.1.2先进先出法1755.2.1.3后进先出法1765.2.1.4计划成本法1775.2.2总仓/分仓/分仓组核算1775.2.3所有计价方法都遵循的规则1785.2.4不足以发出的核算规则1785.2.4.1加权平均/计划成本法1785.2.4.2移动平均1795.2.4.3分批认定法1795.2.4.4先进/后进先出法1795.2.4.5计划成本法1795.2.5红字入库单据的核算

20、规则（所有计价方法）1795.2.5.1红字入库的规则是：1805.2.5.2红字出库核算规则1805.2.5.3移动平均、分批认定、先进/后进先出法的红字出库核算规则1815.2.5.4加权平均、计划成本法的红字出库核算规则1815.2.6调拨单核算规则1835.3计划价调价1835.4金额调整1835.5物流与总帐对帐1845.5.1总帐的存货科目做了手工凭证1855.5.2物流中的库存单据未生成凭证1855.5.3库存单据的金额 凭证的金额1855.5.4物流结帐后，上期的期末余额与下期的期初余额不符1855.5.5计划成本法，做了计划价调价单，且在数据库中做了反结帐，重新结帐回来，计划

21、价调价单失效；1865.5.6计划成本法，物料在期末无结存数量和金额，只有结存差异，差异不能结转下期；1865.5.7 941之前的版本，暂估入库单做了对等核销，而且两张单据的金额的绝对值不等；1875.5.8调拨单的调出或调入仓库丢失1885.5.9凭证模板设置错误1885.5.10物料对应的存货类科目丢失1885.6生成凭证1885.6.1凭证模板数据表1885.7结帐1895.7.1工业物流结帐过程189一、工业物流初始设置1.1工业初始化1.1.1初始化参数设置1.1.1处理流程 核算参数得设置流程： 启用年度和启用期间-税率-核算方式-库存结余控制-库存更新控制-销售模块设置参数说明

22、：启用年度和启用期间：业务实际的启用年度和期间，其自定义得期间规则参照总帐的设置税率：系统默认为17，输入时只输入%前面的数据即可，不要输入0.17等数据，参照总帐核算方式：数量核算”和“数量、金额核算”两种方式，“数量核算”，系统以后只核算数量，不核算金额，数量、金额核算”是对材料的数量和成本都核库存结余控制：确定是否允许负结存，负结存是库存即时数量为负数库存更新控制：单据审核后才更新，单据保存后立即更新，在新增、修改、复制、删除、作废、反作废该库存单据时进行库存调整销售模块设置：日常业务中是否存在企业集团内部销售业务，1.1.1.2相关的数据结构：整个核算参数涉及的数据流程如下1表示销售模

23、块设置是否启用集团分销0:不区分 1:区分数据存放于: t_systemprofile系统参数表 fcategory=gl and fkey=discivilexportsale)例如:设置保存过程if exists(select * from t_systemprofile where fcategory=gl and fkey=discivilexportsale)update t_systemprofile set fvalue=1 where fcategory=gl and fkey=discivilexportsaleelse insert into t_systemprofile

24、(fcategory,fkey,fvalue) values(gl,discivilexportsale,1)2-税率参照总帐税率, 数据存放于fcategory=gl and fkey=taxrate例如:设置保存过程if exists(select * from t_systemprofile where fcategory=gl and fkey=taxrate)update t_systemprofile set fvalue=17 where fcategory=gl and fkey=taxrateelse insert into t_systemprofile(fcategory

25、,fkey,fvalue) values(gl,taxrate,17)3表示启用年度和期间，目前年度和期间,数据存放于currentperiod currentyear，startperiod，startyear例如:设置保存过程if exists(select * from t_systemprofile where fcategory=ic and fkey=currentperiod)update t_systemprofile set fvalue=7 where fcategory=ic and fkey=currentperiodelse insert into t_systemp

26、rofile(fcategory,fkey,fvalue) values(ic,currentperiod,7)if exists(select * from t_systemprofile where fcategory=ic and fkey=currentyear)update t_systemprofile set fvalue=2003 where fcategory=ic and fkey=currentyearelse insert into t_systemprofile(fcategory,fkey,fvalue) values(ic,currentyear,2003)goi

27、f exists(select * from t_systemprofile where fcategory=ic and fkey=startperiod)update t_systemprofile set fvalue=7 where fcategory=ic and fkey=startperiodelse insert into t_systemprofile(fcategif exists(select * from t_syory,fkey,fvalue) values(ic,startperiod,7)gostemprofile where fcategory=ic and f

28、key=startyear)update t_systemprofile set fvalue=2003 where fcategory=ic and fkey=startyearelse insert into t_systemprofile(fcategory,fkey,fvalue) values(ic,startyear,2003)4.历史遗留的暂估凭证 , 数据存放于fcategory=ic and fkey=zanguvoucher例如:设置保存过程：if exists(select * from t_systemprofile where fcategory=ic and fke

29、y=zanguvoucher)update t_systemprofile set fvalue=0 where fcategory=ic and fkey=zanguvoucherelse insert into t_systemprofile(fcategory,fkey,fvalue) values(ic,zanguvoucher,0)5.库存结余控制（是否允许负结存（1-允许，0-不允许）数据存放于understock例如:设置保存过程if exists(select * from t_systemprofile where fcategory=ic and fkey=understo

30、ck)update t_systemprofile set fvalue=1 where fcategory=ic and fkey=understockelse insert into t_systemprofile(fcategory,fkey,fvalue) values(ic,understock,1)6.-核算方式 0：数量核算，1：数量、金额核算, 数据存放于fcategory=ic and fkey=auditchoice例如:设置保存过程if exists(select * from t_systemprofile where fcategory=ic and fkey=aud

31、itchoice)update t_systemprofile set fvalue=1 where fcategory=ic and fkey=auditchoiceelse insert into t_systemprofile(fcategory,fkey,fvalue) values(ic,auditchoice,1)go7.库存更新控制 0：审核更新，1：保存更新 数据存放于fcategory=ic and fkey=upstockwhensave)例如:设置保存过程if exists(select * from t_systemprofile where fcategory=ic

32、and fkey=upstockwhensave)update t_systemprofile set fvalue=1 where fcategory=ic and fkey=upstockwhensaveelse insert into t_systemprofile(fcategory,fkey,fvalue) values(ic,upstockwhensave,1)1.1.1.3其他核算参数的设置前提有两个：工业供需链系统处于初始化阶段工业供需链系统中不存在任何已录入的初始余额和业务单据1.1.2初始化功能流程1.1.2.1.初始数据录入处理流程采用加权平均法、移动平均法计价的物料：不

33、进行批次管理，直接在“初始数据录入”界面的右边录入期初数量、期初金额；进行批次管理，物料必须保证所有批次的年初余额、期初余额的单价一致，录入每批次的初始数据，对于期初余额，只在“合计行”录入计划成本法计价的物料：直接在“初始数据录入”界面的右边录入期初数量、差异类数采用先进先出法、后进先出法计价的物料：需要通过单击“物料”和“批次/顺序号”对应的空白按钮、调出顺序录入数据分批认定法计价：必须进行业务批次管理，因此需要通过单击“物料”和“批次/顺序号”对应的空白按钮初始录入：初始数据分仓库、仓位录入如果是年中启用：年初金额，年初差异，本年累计收入数量，本年累计收入金额，本年累计收入差异，本年累计

34、发出数量，本年累计发出金额，本年累计发出差异等根据帮助说明，进行相关入录，平衡得到。1.1.2.2流程初试化界面数据入录的显示过程数据流程；过滤计量单位，从计量单位表t_measureunit，如： select fmeasureunitid,funitgroupid,fnumber,fname,fstandard from t_measureunit order by fnumber过滤实仓和仓位：从仓库stock表，stockplacegroup仓位组表，stockplace存放地点表select fitemid,0 as fparentid, 0 as fspid, fnumber,fs

35、hortnumber,fname,fisstockmgr from t_stock where ftypeid = 500 union all select t1.fitemid,t1.fitemid,t3.fspid,t3.fnumber,t3.fshortnumber,t3.fname,0 from t_stock t1, t_stockplacegroup t2, t_stockplace t3 where t1.ftypeid=500 and t1.fisstockmgr=1 and t1.fspgroupid=t2.fspgroupid and t2.fspgroupid = t3.

36、fspgroupid and t3.fdetail = 1 order by fparentid,fnumber显示数据的过程，从初始余额icinvinitial ，物料表t_icitem,计量单位表t_measureunit ,辅助信息表t_submessage 如：select u1.fitemid,t1.fnumber,t1.fshortnumber,t1.fname as fitemname,t1.fmodel, u1.funitid,t2.fname as funitname,t1.ftrack,t3.fname as ftrackname, t1.fqtydecimal,t1.fp

37、ricedecimal,t1.fplanprice,t1.fkfperiod, (case when t1.fbatchmanager=1 then 1 else 0 end) as fbm, (case when t1.fiskfperiod=1 then 1 else 0 end) as fkf, sum(u1.fytdauxbegqty) as finitytdbegqty,sum(u1.fytdbegbal-u1.fytdbegdiff) as finitytdbegbal,sum(u1.fytdbegdiff) finitytdbegdiff, sum(u1.fytdauxrecei

38、ve) as finitytdreceive,sum(u1.fytddebit-u1.fytdreceivediff) as finitytddebit,sum(u1.fytdreceivediff) finitytdreceivediff, sum(u1.fytdauxsend) as finitytdsend,sum(u1.fytdcredit-u1.fytdsenddiff) as finitytdcredit,sum(u1.fytdsenddiff) finitytdsenddiff, sum(u1.fauxbegqty) as finitbegqty,sum(u1.fbegbal-u

39、1.fbegdiff) as finitbegbal,sum(u1.fbegdiff) finitbegdifffrom icinvinitial u1,t_icitem t1,t_measureunit t2,t_submessage t3 where u1.fitemid=t1.fitemid and u1.funitid=t2.fmeasureunitid and t1.ftrack=t3.finterid and t3.ftypeid = 200 and u1.fperiod =7 group by u1.fitemid,t1.fnumber,t1.fshortnumber,t1.fn

40、ame,t1.fmodel, u1.funitid, t2.fname,t1.ftrack,t3.fname, t1.fqtydecimal,t1.fpricedecimal,t1.fplanprice,t1.fkfperiod, (case when t1.fbatchmanager=1 then 1 else 0 end), (case when t1.fiskfperiod=1 then 1 else 0 end) order by t1.fnumber2）物流和总帐对帐：按照物料设置的存货科目分类汇总数据从初始余额表icinvinitial提取数据，涉及的表有物料表t_icitem，计

41、量单位表,t_measureunit，辅助信息表t_submessageselect u1.fitemid,t1.fnumber,t1.fshortnumber,t1.fname as fitemname,t1.fmodel, u1.funitid,t2.fname as funitname,t1.ftrack,t3.fname as ftrackname, t1.fqtydecimal,t1.fpricedecimal,t1.fplanprice,t1.fkfperiod, (case when t1.fbatchmanager=1 then 1 else 0 end) as fbm, (c

42、ase when t1.fiskfperiod=1 then 1 else 0 end) as fkf, sum(u1.fytdauxbegqty) as finitytdbegqty,sum(u1.fytdbegbal-u1.fytdbegdiff) as finitytdbegbal,sum(u1.fytdbegdiff) finitytdbegdiff, sum(u1.fytdauxreceive) as finitytdreceive,sum(u1.fytddebit-u1.fytdreceivediff) as finitytddebit,sum(u1.fytdreceivediff

43、) finitytdreceivediff, sum(u1.fytdauxsend) as finitytdsend,sum(u1.fytdcredit-u1.fytdsenddiff) as finitytdcredit,sum(u1.fytdsenddiff) finitytdsenddiff, sum(u1.fauxbegqty) as finitbegqty,sum(u1.fbegbal-u1.fbegdiff) as finitbegbal,sum(u1.fbegdiff) finitbegdiff from icinvinitial u1,t_icitem t1,t_measure

44、unit t2,t_submessage t3 where u1.fitemid=t1.fitemid and u1.funitid=t2.fmeasureunitid and t1.ftrack=t3.finterid and t3.ftypeid = 200 and u1.fperiod =7 and t1.facctid in (select faccountid from t_account where fnumber like 123%) group by u1.fitemid,t1.fnumber,t1.fshortnumber,t1.fname,t1.fmodel, u1.fun

45、itid, t2.fname,t1.ftrack,t3.fname, t1.fqtydecimal,t1.fpricedecimal,t1.fplanprice,t1.fkfperiod, (case when t1.fbatchmanager=1 then 1 else 0 end), (case when t1.fiskfperiod=1 then 1 else 0 end) order by t1.fnumber1.1.2.3传递余额到总帐不带数量核算、核算项目的传递删除总帐余额表t_balance数据， 如：delete from t_balance where fyear=？ and

46、 fperiod=？and fdetailid=？ and faccountid=？插入数据到余额表insert into t_balance（.）执行存储过程，转化为符合约束的数据exec sp_updatebalance带数量核算、核算项目的传递判断科目是否带核算项目，是否已经有组合在核算项目表t_itemdetail如果没有，则插入核算项目到核算项目表t_itemdetail删除数量余额表t_quantitybalance和科目余额t_balance表数据插入数据到数量t_quantitybalance和科目余额表t_balance过程如下：select * from t_itemdet

47、ail where (f4=-1 or f5=-1) and fdetailcount2) and fdetailid=1select * from t_itemdetail where (f4=-1) and fdetailcount=1) and fdetailid=1select fquantities from t_account where faccountid=1011 select t1.fnumber,t1.fshortnumber,t1.fname as fitemname,t1.fmodel, u1.funitid,t2.fname as funitname,t1.ftra

48、ck,t3.fname as ftrackname, t1.fqtydecimal,t1.fpricedecimal,t1.fplanprice, (case when t1.fbatchmanager=1 then 1 else 0 end) as fbm, sum(u1.fytdauxbegqty) as ftytdbegqty,sum(u1.fytdbegqty) as ftytdbasebegqty,sum(u1.fytdbegbal-u1.fytdbegdiff) as ftytdbegbal,sum(u1.fytdbegdiff) ftytdbegdiff, sum(u1.fytd

49、auxreceive) as ftytdreceive,sum(u1.fytdreceive) as ftytdbasereceive,sum(u1.fytddebit-u1.fytdreceivediff) as ftytddebit,sum(u1.fytdreceivediff) ftytdreceivediff, sum(u1.fytdauxsend) as ftytdsend,sum(u1.fytdsend) as ftytdbasesend,sum(u1.fytdcredit-u1.fytdsenddiff) as ftytdcredit,sum(u1.fytdsenddiff) f

50、tytdsenddiff,sum(u1.fauxbegqty) as ftbegqty,sum(u1.fbegqty) as ftbasebegqty,sum(u1.fbegbal-u1.fbegdiff) as ftbegbal,sum(u1.fbegdiff) ftbegdiff,u1.fitemid from icinvinitial u1,t_icitem t1,t_measureunit t2,t_submessage t3 where u1.fitemid=t1.fitemid and u1.funitid=t2.fmeasureunitid andt1.ftrack=t3.fin

51、terid and t3.ftypeid = 200 and u1.fperiod =7 and t1.facctid in (select faccountid from t_account where fnumber like 123%) group by u1.fitemid,t1.fnumber,t1.fshortnumber,t1.fname,t1.fmodel, u1.funitid, t2.fname,t1.ftrack,t3.fname, t1.fqtydecimal,t1.fpricedecimal,t1.fplanprice,(case when t1.fbatchmanager=1 then 1 else 0 end),u1.fitemid，order by t1.fnumberselect fdetailid from t_itemdetail where fdetailcount=1 and f4=73select max(isnull(f