创建结算清单报错
金蝶云社区-demo@大连汇海佳国际贸易有限公司_1
demo@大连汇海佳国际贸易有限公司_1
0人赞赏了该文章 902次浏览 未经作者许可,禁止转载编辑于2015年08月06日 13:03:13

创建结算清单后查看结算日志,提示下列错误:
会计核算体系【财务会计核算体系】,将截断字符串或二进制数据。
语句已终止。 INSERT INTO #TM_IOS_CREATESETTLEBIZDATA (FFormID, FConfigId, FUpDownConfigId, FFormName, FEntryId, FBizID, FBizBillNo, FBizDate, FBizBillTypeId, FOutOwnerID, FInOwnerId, FTransferBizType, FMaterialID, FUnitID, FQty, FBaseUnitID, FBaseQty, FAuxpropID, FOutStockOrgID, FInStockOrgID, FVestonWay, FVestonQty, FVestonBaseQty, FNote, FTransferDirect, FCreateInDefault, FCreateType, FIOSItemType, FBizPriceUnitId, FBizPrice, FBizCurrencyId, FSourceKey, FUpDownFormID, FUpDownFID, FUpDownEntryId, FIsUpDownData, FAcctSystemId, FAcctPolicyId, FOutDeptId, FInDeptId) SELECT 'SAL_OUTSTOCK', 10263, 10263, '销售出库单', t2.FENTRYID, t0.FID, t0.FBILLNO fbillno, t0.FDATE fdate, t0.FBILLTYPEID fbilltypeid, t2.FOWNERID fownerid, t1.FSETTLEORGID fsettleorgid, t0.FTRANSFERBIZTYPE ftransferbiztype, t2.FMATERIALID fmaterialid, t2.FUNITID funitid, t2.FREALQTY frealqty, t2.FBASEUNITID fbaseunitid, t2.FBASEUNITQTY fbaseunitqty, t2.FAUXPROPID fauxpropid, t0.FSTOCKORGID fstockorgid, t0.FSTOCKORGID fstockorgid, 0, 0, 0, ' ', 'GENERAL', 1, 'RECEIVE;PAY', 'MATERIAL', 0, t2_F.FPRICE fprice, t1.FSETTLECURRID fsettlecurrid, 'OverOrg_SAL_OUTSTOCK', 'SAL_OUTSTOCK', t0.FID, t2.FENTRYID, 1, 1, 0, 0, 0 FROM T_SAL_OUTSTOCK t0 LEFT OUTER JOIN T_SAL_OUTSTOCKFIN t1 ON t0.FID = t1.FID LEFT OUTER JOIN T_SAL_OUTSTOCKENTRY t2 ON t0.FID = t2.FID LEFT OUTER JOIN T_SAL_OUTSTOCKENTRY_F t2_F ON t2.FENTRYID = t2_F.FENTRYID INNER JOIN T_ORG_ACCTSYSDETAIL TOADIN ON t1.FSETTLEORGID = TOADIN.FSUBORGID INNER JOIN T_ORG_ACCTSYSENTRY TOAEIN ON ((TOAEIN.FENTRYID = TOADIN.FENTRYID AND TOAEIN.FACCTSYSTEMID = 1) AND TOAEIN.FACOUNTTYPE = 1) INNER JOIN T_ORG_ACCTSYSDETAIL TOADOUT ON t2.FOWNERID = TOADOUT.FSUBORGID INNER JOIN T_ORG_ACCTSYSENTRY TOAEOUT ON ((TOAEOUT.FENTRYID = TOADOUT.FENTRYID AND TOAEOUT.FACCTSYSTEMID = 1) AND TOAEOUT.FACOUNTTYPE = 1) WHERE (((((((((((((t2_F.FISOVERLEGALORG = 0 AND (t0.FBUSINESSTYPE <> 'VMI')) AND t1.FISGENFORIOS = 0) AND t2.FOWNERTYPEID = 'BD_OwnerOrg') AND (t2.FOWNERID <> t1.FSETTLEORGID)) AND (t2.FOWNERID > 0)) AND (t1.FSETTLEORGID > 0)) AND (TOAEOUT.FMAINORGID = 100003 OR TOAEIN.FMAINORGID = 100003)) AND (t0.FDATE >= CONVERT(DATETIME, '2015-06-01 00:00:00'))) AND (t0.FDATE <= CONVERT(DATETIME, '2015-06-30 23:59:59'))) AND t2.FENTRYID NOT IN (SELECT FENTRYID FROM #TM_IOS_CREATESETTLEBIZDATA WHERE (FFORMID = 'SAL_OUTSTOCK' AND FCONFIGID = 10263))) AND t0.FDOCUMENTSTATUS = 'C') AND t0.FCANCELSTATUS = 'A') AND (((t0.FTRANSFERBIZTYPE IN (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12) AND t0.FOBJECTTYPEID = 'SAL_OUTSTOCK') AND (t2.FBASEUNITQTY <> 0)) AND (t2.FREALQTY <> 0))) 在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteWithTime(Context ctx, String strSQL, IEnumerable`1 paramList, Int32 commandTimeout)
在 Kingdee.K3.SCM.App.IOS.Core.CreateOverOrgAccount.GetIOSBizData(Context ctx, SettlementConfig config)
在 Kingdee.K3.SCM.App.IOS.Core.CreateOverOrgAccount.ErgodicConfig(Context ctx, List`1 sourceConfigs)
在 Kingdee.K3.SCM.App.IOS.Core.CreateOverOrgAccount.CreateSettlement(IOSCreateResult iosCreateResult)
在 Kingdee.K3.SCM.App.IOS.Core.OverOrgAccountService.CreateSettle(Context ctx, IOSSettleParams iosParams)