会计同事反映,在关几个外包(OSP)工单时,系统报错.错误讯息如下.检查错误讯息,发现Number of jobs failed in Delivered Quantity : 2.检查工单数据,均无异常.检查PO的数据,发现如下图,仓库人员作了Return to Receiving,共做了两笔.用Receiving Transactions再作回来,再请会计关工单,成功! 要注意的是,做完Receiving Transactions,系统会抛一笔完工入库到Interface,如果是多的,要删除
需求:按单按库生产的CRTD状态半成品工单重复创建问题 绑定成功案例: SELECT DEMANDLINEID,SUPPLYORDERID,DEMANDORDERID,QTYALLOCATED,ITEM FROM ABPPMGR.SUPPLYDMDPEGPLAN WHERE ITEM='000000102002000817CZ';--前台显示 --SO:5000156623 模拟创建了成品MO:5000156623/70_1-MFG001,成品MO号供给者为半成品MO:001201126508
Created by 蓝色布鲁斯,QQ32876341,blog http://www.cnblogs.com/zzyan/ iDempiere官方中文wiki主页 http://wiki.idempiere.org/zh iDempiere 中文社区www.idempiere.org.cn iDempiere 中文社区QQ群 65713012 Visit demo.aidee.cn/idempiere/ or for http://demo.osssme.org/ demo, GardenA
一.取用户第一次下单时间 SELECT city,username,`order_date` AS 首单日期,金额 AS 首单金额 FROM ( SELECT city,username,`order_date`,SUM(`pay_money`) AS 金额 FROM `test_a03order` GROUP BY username,order_date ORDER BY username,order_date#按日期升序 ) AS a GROUP BY username#只用username
Job status update 1. Job的几种状态 unreleased --未核发 released--已核发 complete --完成 complete no charges--完成不计费 on hold --保留 cancelled--取消 closed--关闭 2. 开立工单可以给的状态 Unreleased Released On hold 3. 关于unreleased Unreleased可以切成除complete no charge之外的任意状态