K3 单据,单据体自定义字段显示及时库存
来源:互联网 发布:金大川和melody知乎 编辑:程序博客网 时间:2024/05/22 14:19
--1、解决了显示可发数量的单据,且已经审核的单据,库存数据更新后,单据上的可发数量随库存变化,现在能实现当时的可发数量和件数保存到单据中
--2、解决了负库存数据显示为0的问题
--2011.09.28 by 申宪峰
--更改显示现库存和可发件数的单据模板的取数方式
--领料单
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='B04' and ffieldname='FEntrySelfB0426'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='B04' and ffieldname='FEntrySelfB0427'
--产成品入库
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='A02' and ffieldname='FEntrySelfA0225'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='A02' and ffieldname='FEntrySelfA0226'
--其他入库
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='A97' and ffieldname='FEntrySelfA9726'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='A97' and ffieldname='FEntrySelfA9727'
--其他出库
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='B09' and ffieldname='FEntrySelfB0924'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='B09' and ffieldname='FEntrySelfB0925'
--销售订单
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='S01' and ffieldname='FEntrySelfS0133'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='S01' and ffieldname='FEntrySelfS0134'
--发货通知单
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='S02' and ffieldname='FEntrySelfS0218'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='S02' and ffieldname='FEntrySelfS0221'
--采购申请单
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='P01' and ffieldname='FEntrySelfP0118'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='P01' and ffieldname='FEntrySelfP0119'
--采购订单
update ictemplateentry set frelationid='fitemid',faction='.,f_104' where fid='P02' and ffieldname='FEntrySelfP0223'
update ictemplateentry set frelationid='fitemid',faction='.,f_105' where fid='P02' and ffieldname='FEntrySelfP0226'
select * from ictemplateentry where fid='p01'
update ictemplateentry set frelationid='fitemid',faction='.,FLOWLIMIT' where fid='P01' and ffieldname='FEntrySelfP0116'
update ictemplateentry set frelationid='fitemid',faction='.,FHIGHLIMIT' where fid='P01' and ffieldname='FEntrySelfP0117'
update ictemplateentry set frelationid='fitemid',faction='.,FFIXLEADTIME' where fid='P01' and ffieldname='FEntrySelfP0120'
--采购订单,上限,下限,计划单价
select * from ictemplateentry where fid='p02'
update ictemplateentry set frelationid='fitemid',faction='.,FLOWLIMIT' where fid='P02' and ffieldname='FEntrySelfP0224'
update ictemplateentry set frelationid='fitemid',faction='.,FHIGHLIMIT' where fid='P02' and ffieldname='FEntrySelfP0225'
update ictemplateentry set frelationid='fitemid',faction='.,FPLANPRICE' where fid='P02' and ffieldname='FEntrySelfP0227'
--购货发票,计划单价
select * from ictemplateentry where fid='I02'
update ictemplateentry set frelationid='fitemid',faction='.,FPLANPRICE' where fid='I02' and ffieldname='FEntrySelfI0231'
- K3 单据,单据体自定义字段显示及时库存
- 金蝶K3单据新增页面在单据体体现物料即时库存数据
- '调用K3组件删除库存单据
- 向八张出入库老单据体中插入同一个字段k3
- 单据
- K3 BOS 单据添加审核日期
- 金蝶K3工业单据二次开发指导汇总
- '调用K3组件反审核单据
- NC单据表体显示合计行
- 根据勾选的单据显示每个库房商品库存是否配齐
- K3自定义sql报表字段显示标题
- 金蝶K3对特定单据表体数据进行列锁定
- 引入单据体数据
- 单据的自定义纸张打印
- K3中注册同一个单据内部的操作插件
- K3 ERP 出入库单据日期的控制
- K3工业老单单据的相关表
- K3 工业单据的对应相关表作用
- 固态电容应用及电气特性
- 【一】 Chrome的多线程模型
- 1sting
- 用fiddler监测手机端网络请求
- Google Chrome源码剖析【二】:进程通信
- K3 单据,单据体自定义字段显示及时库存
- 个人学习c++经验
- 隐藏键盘方法
- Hibernate(1)关联映射之一对多
- Google Chrome源码剖析【三】:进程模型
- Cocos2dx 3.0 过渡篇(五) 随机数的获取
- Google Chrome源码剖析【四】:UI绘制
- Centos 搭建golang环境,vim高亮go关键字设置
- android 支持的语言列表(汇总)