用友U8 在存货核算模块中,最近查询单据列表,发现元月份好多采购入库单,产成品入库单,无税单价成空白内容,通过单价升序可全部过滤出来.不如怎么处理-
2016-1-4 0:0:0 用友NC小编用友U8 在存货核算模块中,最近查询单据列表,发现元月份好多采购入库单,产成品入库单,无税单价成空白内容,通过单价升序可全部过滤出来.不如怎么处理-
用友U8 在存货核算模块中,最近查询单据列表,发现元月份好多采购入库单,产成品入库单,无税单价成空白内容,通过单价升序可全部过滤出来.不如怎么处理? 问题原因:数据问题 解决方法:UPDATE RdRecords SET RdRecords.iUnitCost =IA_Subsidiary.iInCost, RdRecords.iPrice =IA_Subsidiary.iAInPrice FROM RdRecords INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID INNER JOIN IA_Subsidiary ON RdRecords.AutoID = IA_Subsidiary.ID WHERE (RdRecords.iUnitCost IS NULL) AND (RdRecords.iPrice IS NULL) and (IA_Subsidiary.cVouType in('08','10','01'))and (RdRecord.cAccounter IS NOT NULL) UPDATE RdRecords SET RdRecords.iUnitCost =IA_Subsidiary.iInCost, RdRecords.iPrice =IA_Subsidiary.iAOutPrice FROM RdRecords INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID INNER JOIN IA_Subsidiary ON RdRecords.AutoID = IA_Subsidiary.ID WHERE (RdRecords.iUnitCost IS NULL) AND (RdRecords.iPrice IS NULL) and (IA_Subsidiary.cVouType in('09','11')) and (RdRecord.cAccounter IS NOT NULL)解决方案:
问题原因:数据问题 解决方法:UPDATE RdRecords SET RdRecords.iUnitCost =IA_Subsidiary.iInCost, RdRecords.iPrice =IA_Subsidiary.iAInPrice FROM RdRecords INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID INNER JOIN IA_Subsidiary ON RdRecords.AutoID = IA_Subsidiary.ID WHERE (RdRecords.iUnitCost IS NULL) AND (RdRecords.iPrice IS NULL) and (IA_Subsidiary.cVouType in('08','10','01'))and (RdRecord.cAccounter IS NOT NULL) UPDATE RdRecords SET RdRecords.iUnitCost =IA_Subsidiary.iInCost, RdRecords.iPrice =IA_Subsidiary.iAOutPrice FROM RdRecords INNER JOIN RdRecord ON RdRecords.ID = RdRecord.ID INNER JOIN IA_Subsidiary ON RdRecords.AutoID = IA_Subsidiary.ID WHERE (RdRecords.iUnitCost IS NULL) AND (RdRecords.iPrice IS NULL) and (IA_Subsidiary.cVouType in('09','11')) and (RdRecord.cAccounter IS NOT NULL)
www.kuaiji66.com 天龙瑞德
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 用友NC软件凭证打印设置方法2018-11-5 13:51:36
- 调拨单审核生成的其他入库单将其它手工填写的其他入库单覆盖2016-9-7 12:11:10
- 调整固定资产折旧2016-8-30 11:5:55
- 用友U8 保存凭证时提示有人正在保存凭证。2016-8-10 0:0:0
- 用友U8 保存凭证时提示有人正在保存凭证。_02016-8-10 0:0:0
- 用友U8 保存凭证时,提示有其他人在使用,无法保存。2016-8-10 0:0:0
- 用友U8 保存凭证时,提示有其他人在使用,无法保存。_02016-8-10 0:0:0
- 用友U8 保存单据时提示存货自由项结构不合法2016-8-10 0:0:0
- 用友U8 保存发货单时又提示:本单据已被他人修改,保存不成功。2016-8-10 0:0:0
- 用友U8 保存委托结算单时提示结算数量不能大于发货数量。2016-8-10 0:0:0