用友U8 有一用户在8.21核销制单时,生成凭证借贷不平衡,不知道是何原因? 注-例如在核销制单时选择客户编码为10200500进行制单,即会出现制单不平衡.用友U8 有一用户在8.21核销制单时,生成凭证借贷不平衡,不知道是何原因? 注:例如在核销制单时选择客户编码为10200500进行制单,即会出现制单不平衡.
问题原因:因为SALEBILLVOUCHS表中的有些记录与AP_DETAIL 中的对应记录的金额不一致,不知什么原因(因为无上年的数据),用AP_DETAIL中的价税合计更新SALEBILLVOUCHS表中的价税合计及累计收款额。 解决方法:SELECT sum(idamount) as idamount,sum(idamount_f) as idamount_f,sum(icamount_f) as icamount_f,sum(icamount) as icamount,ibvidINTO aFROM Ap_DetailWHERE (cFlag = ‘ar‘) AND (cCoVouchType IN 9‘26‘, ‘27‘,‘28‘,‘29‘))and (iFlag <> ‘5‘ or cprocstyle<>‘xj‘)group by ibvid --包括了核销、预收冲应收、应收冲应付操作。update salebillvouchsset imoneysum=a.icamount,iexchsum=a.icamount_ffrom salebillvouchs b inner join a on a.ibvid = b.autoid and a.idamount=b.inatsum and a.idamount_f=b.isumSELECT sum(idamount) as idamount,sum(idamount_f) as idamount_f,sum(icamount_f) as icamount_f,sum(icamount) as icamount,ibvidINTO aFROM Ap_DetailWHERE (cFlag = ‘ar‘) AND (cCoVouchType IN 9‘26‘, ‘27‘,‘28‘,‘29‘))and (iFlag <> ‘5‘ or cprocstyle<>‘xj‘)group by ibvid --包括了核销、预收冲应收、应收冲应付操作。update salebillvouchsset imoneysum=a.icamount,iexchsum=a.icamount_ffrom salebillvouchs b inner join a on a.ibvid = b.autoid and a.idamount=b.inatsum and a.idamount_f=b.isum 因为SALEBILLVOUCHS表中的有些记录与AP_DETAIL 中的对应记录的金额不一致,不知什么原因(因为无上年的数据),用AP_DETAIL中的价税合计更新SALEBILLVOUCHS表中的价税合计及累计收款额。 而如果不取消核销的话,以前的核销的数据会有错误,建议把相关客户的核销取消,如已制单,把凭证删去,或把凭证冲销,再做以下更新。 SELECT sum(idamount) as idamount,sum(idamount_f) as idamount_f,sum(icamount_f) as icamount_f,sum(icamount) as icamount,ibvid INTO a FROM Ap_Detail WHERE (cFlag = ‘ar‘) AND (cCoVouchType IN (‘26‘, ‘27‘,‘28‘,‘29‘)) and (iFlag <> ‘5‘ or cprocstyle<>‘xj‘) group by ibvid --包括了核销、预收冲应收、应收冲应付操作。 update salebillvouchs set imoneysum=a.icamount,iexchsum=a.icamount_f from salebillvouchs b inner join a on a.ibvid = b.autoid --因为有的红字发票的金额为零的记录在AP_DETAIL中的IDAMOUNT不为零,如CY00021081号发票,只能用更新ISUM,INATSUM的方法了。但不知数据是否在上一年度有错,现在只能按AP_DETAIL为正确的进行调整了。update salebillvouchs set imoneysum=a.icamount,iexchsum=a.icamount_f, inatsum=a.idamount,b.isum=a.idamount_f from salebillvouchs b inner join a on a.ibvid = b.autoid
解决方案:
问题原因:因为SALEBILLVOUCHS表中的有些记录与AP_DETAIL 中的对应记录的金额不一致,不知什么原因(因为无上年的数据),用AP_DETAIL中的价税合计更新SALEBILLVOUCHS表中的价税合计及累计收款额。 解决方法:SELECT sum(idamount) as idamount,sum(idamount_f) as idamount_f,sum(icamount_f) as icamount_f,sum(icamount) as icamount,ibvidINTO aFROM Ap_DetailWHERE (cFlag = ‘ar‘) AND (cCoVouchType IN 9‘26‘, ‘27‘,‘28‘,‘29‘))and (iFlag <> ‘5‘ or cprocstyle<>‘xj‘)group by ibvid --包括了核销、预收冲应收、应收冲应付操作。update salebillvouchsset imoneysum=a.icamount,iexchsum=a.icamount_ffrom salebillvouchs b inner join a on a.ibvid = b.autoid and a.idamount=b.inatsum and a.idamount_f=b.isumSELECT sum(idamount) as idamount,sum(idamount_f) as idamount_f,sum(icamount_f) as icamount_f,sum(icamount) as icamount,ibvidINTO aFROM Ap_DetailWHERE (cFlag = ‘ar‘) AND (cCoVouchType IN 9‘26‘, ‘27‘,‘28‘,‘29‘))and (iFlag <> ‘5‘ or cprocstyle<>‘xj‘)group by ibvid --包括了核销、预收冲应收、应收冲应付操作。update salebillvouchsset imoneysum=a.icamount,iexchsum=a.icamount_ffrom salebillvouchs b inner join a on a.ibvid = b.autoid and a.idamount=b.inatsum and a.idamount_f=b.isum 因为SALEBILLVOUCHS表中的有些记录与AP_DETAIL 中的对应记录的金额不一致,不知什么原因(因为无上年的数据),用AP_DETAIL中的价税合计更新SALEBILLVOUCHS表中的价税合计及累计收款额。 而如果不取消核销的话,以前的核销的数据会有错误,建议把相关客户的核销取消,如已制单,把凭证删去,或把凭证冲销,再做以下更新。 SELECT sum(idamount) as idamount,sum(idamount_f) as idamount_f,sum(icamount_f) as icamount_f,sum(icamount) as icamount,ibvid INTO a FROM Ap_Detail WHERE (cFlag = ‘ar‘) AND (cCoVouchType IN (‘26‘, ‘27‘,‘28‘,‘29‘)) and (iFlag <> ‘5‘ or cprocstyle<>‘xj‘) group by ibvid --包括了核销、预收冲应收、应收冲应付操作。 update salebillvouchs set imoneysum=a.icamount,iexchsum=a.icamount_f from salebillvouchs b inner join a on a.ibvid = b.autoid --因为有的红字发票的金额为零的记录在AP_DETAIL中的IDAMOUNT不为零,如CY00021081号发票,只能用更新ISUM,INATSUM的方法了。但不知数据是否在上一年度有错,现在只能按AP_DETAIL为正确的进行调整了。update salebillvouchs set imoneysum=a.icamount,iexchsum=a.icamount_f, inatsum=a.idamount,b.isum=a.idamount_f from salebillvouchs b inner join a on a.ibvid = b.autoid
www.kuaiji66.com 天龙瑞德