<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wssbdbdbb的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wssbdbdbb</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wssbdbdbb]]></copyright><item><title><![CDATA[U8/触发器，把自定义项写入批次档案]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/169268415</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/169268415</guid><author>wssbdbdbb</author><pubDate>Tue, 27 Oct 2026 21:51:19 +0800</pubDate><description><![CDATA[GOGOGOASBEGINENDGO。]]></description><category></category></item><item><title><![CDATA[U8/触发器，修改收付款单摘要显示‘应/预，付款/收款‘]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/164464724</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/164464724</guid><author>wssbdbdbb</author><pubDate>Mon, 07 Sep 2026 15:24:54 +0800</pubDate><description><![CDATA[WHEN CONCAT(cVouchType,Ap_CloseBills.iType) = '480' THEN '应收款'WHEN CONCAT(cVouchType,Ap_CloseBills.iType) = '481' THEN '预收款'WHEN CONCAT(cVouchType,Ap_CloseBills.iType) = '490' THEN '应付款'WHEN CONCAT(cVouchType,Ap_CloseBills.iType) = '491' THEN '预付款']]></description><category></category></item><item><title><![CDATA[U8/总账和明细账对账不平-凭证是外部传进来的]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/162075928</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/162075928</guid><author>wssbdbdbb</author><pubDate>Wed, 17 Jun 2026 19:19:56 +0800</pubDate><description><![CDATA[从对账上看，总金额是对的，只是总账的总额和明细账的明细金额对上了。所以问题应该出在明细表里面，某个字段没统一导致对账的时候分开了。正常单据对账没有问题，但是记完账后总账和明细账对账就不一致。估计OA空值，传的是空格，他应该是NULL。cexch_name（这个最核心）核心关注空值和NULL。]]></description><category></category></item><item><title><![CDATA[U8/固定资产反结账报错]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/161600380</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/161600380</guid><author>wssbdbdbb</author><pubDate>Mon, 01 Jun 2026 19:53:53 +0800</pubDate><description><![CDATA[1.账套数据结构不正确2.对于850及以前版本账套数据,固定资产系统不支持升级后当月就恢复月结至上月3.本账套正执行数据复制。WHERE t1.name IS NULL OR t2.name IS NULL  -- 只显示不一样的列。【只在源表有】    9999    78        --这两个是正常的本来就有的。WHEN t2.name IS NULL THEN '【只在目标表有】'CASE WHEN t1.name IS NULL THEN '【只在源表有】'（特地改成13了不要试）]]></description><category></category></item><item><title><![CDATA[U8/材料出库单触发器，有条件的修改出库类别]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/161118464</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/161118464</guid><author>wssbdbdbb</author><pubDate>Fri, 15 May 2026 17:01:33 +0800</pubDate><description><![CDATA[GOGOGOASBEGIN/**/CASEENDEND。]]></description><category></category></item><item><title><![CDATA[U8/材料出库单触发器，把出库类别=仓库编码]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/161117857</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/161117857</guid><author>wssbdbdbb</author><pubDate>Fri, 15 May 2026 16:33:02 +0800</pubDate><description><![CDATA[GOGOGOASBEGINEND。]]></description><category></category></item><item><title><![CDATA[U8/中途启用批次管理-批次档案无效]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/160895562</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/160895562</guid><author>wssbdbdbb</author><pubDate>Fri, 08 May 2026 17:02:47 +0800</pubDate><description><![CDATA[-UPDATE rdrecords08 SET cBatchProperty6 = 'luanma' WHERE cInvCode = @CINVCODE        试图修改批次属性，没用。UPDATE rdrecords09 SET cBatch = '期初' WHERE cInvCode = @CINVCODE。UPDATE rdrecords08 SET cBatch = '期初' WHERE cInvCode = @CINVCODE。]]></description><category></category></item><item><title><![CDATA[U8/UAP报表存储过程简单模板（包含列组合多值查询）]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/160475019</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/160475019</guid><author>wssbdbdbb</author><pubDate>Fri, 24 Apr 2026 14:25:12 +0800</pubDate><description><![CDATA[SELECT WZDM[物资代码],XGXH[序号],WZXH[物资型号],WZGG[物资规格],WZDM+XGXH[U8存货编码],WZDM+WZXH+WZGG[唯一ID代码加型号加规格]]]></description><category></category></item><item><title><![CDATA[U8/历史数据修改，重新结转期初]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/160108269</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/160108269</guid><author>wssbdbdbb</author><pubDate>Mon, 13 Apr 2026 11:36:56 +0800</pubDate><description><![CDATA[-总账开账--取消总账月结SELECT *--取消凭证记账。]]></description><category></category></item><item><title><![CDATA[U8/修改采购入库单辅计量单位]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/159749423</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/159749423</guid><author>wssbdbdbb</author><pubDate>Thu, 02 Apr 2026 09:00:07 +0800</pubDate><description><![CDATA[SELECT cAssUnit,Inventory.cSTComUnitCode,* 
--UPDATE rdrecords01 SET cAssUnit = Inventory.cSTComUnitCode
FROM rdrecords01 LEFT JOIN Inventory ON rdrecords01.cInvCode = Inventory.cInvCode]]></description><category></category></item><item><title><![CDATA[U8/领料申请单SQL server触发器，如果自定义项13有值，把数量修改成件数乘以自定义项13，如果恰好件数等于现存量，则数量同步出空]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/159698746</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/159698746</guid><author>wssbdbdbb</author><pubDate>Tue, 31 Mar 2026 23:58:53 +0800</pubDate><description><![CDATA[-----GOGOASBEGINBEGINENDELSEBEGINENDENDGO。]]></description><category></category></item><item><title><![CDATA[U8/对比一级科目，快速判断需要调整的报表]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/157138961</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/157138961</guid><author>wssbdbdbb</author><pubDate>Mon, 19 Jan 2026 16:57:55 +0800</pubDate><description><![CDATA[SELECT YC.ccode[原来科目编码],YC.ccode_name[原来科目名称],YC.igrade[原来科目及次],YC.bproperty[原来科目性质]SELECT XC.ccode[现在科目编码],XC.ccode_name[现在科目名称],XC.igrade[科目及次],XC.bproperty[科目性质]FROM #XC FULL OUTER JOIN #YC ON #XC.现在科目编码 = #YC.原来科目编码。]]></description><category></category></item><item><title><![CDATA[U8/不同账套总账期初余额对账]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/156995221</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/156995221</guid><author>wssbdbdbb</author><pubDate>Thu, 15 Jan 2026 22:46:32 +0800</pubDate><description><![CDATA[现在科目编码],[现在方向],[现在币种],ISNULL([现在本币],0)[现在本币],ISNULL([现在原币],0)[现在原币],SELECT [对账科目编码],[对账方向],[对账币种],ISNULL([对账本币],0)[对账本币],ISNULL([对账原币],0)[对账原币],SELECT ccode[对账科目编码],cbegind_c[对账方向],cexch_name[对账币种],mb[对账本币],mb_f[对账原币]]]></description><category></category></item><item><title><![CDATA[U8/固定资产后台常用表]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/156729719</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/156729719</guid><author>wssbdbdbb</author><pubDate>Thu, 08 Jan 2026 17:28:00 +0800</pubDate><description><![CDATA[固定资产折旧数据明细表 （有）             fa_DeprTransactions_Detail。固定资产明细表（有）                            fa_Cards_Detail。固定资产折旧数据表（有）                     fa_DeprTransactions。固定资产汇总表（无）                            fa_Total。固定资产卡片主表（有）                        fa_Cards。]]></description><category></category></item><item><title><![CDATA[U8/用户权限合并查询]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/155676460</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/155676460</guid><author>wssbdbdbb</author><pubDate>Sun, 07 Dec 2025 19:35:10 +0800</pubDate><description><![CDATA[LEFT JOIN ua_auth ON UA_HoldAuth.cAuth_Id = ua_auth.cAuth_Id        --权限说明表。LEFT JOIN ua_user ON UA_HoldAuth.cUser_Id = ua_user.cUser_Id        --操作员表。select [功能名称ID],[权限名称],操作员,s.cAuth_Name[对应功能],x.cSub_Id,cSub_Name[隶属系统]UA_HoldAuth.cAuth_Id[功能名称ID],]]></description><category></category></item><item><title><![CDATA[U8/新增采购发票参照订单，只允许应税劳务存货]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/155107351</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/155107351</guid><author>wssbdbdbb</author><pubDate>Fri, 21 Nov 2025 17:31:24 +0800</pubDate><description><![CDATA[这个界面的数据源手工不需要点筛选框，就是新增定义的，直接输入字段。解决思路，新建一个隐藏的过滤条件，查询的时候默认进行筛选。然后用缺省值进行默认设置。]]></description><category></category></item><item><title><![CDATA[U8/领料申请单参照生产订单显示界面增加一个BOM版本说明]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154950210</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154950210</guid><author>wssbdbdbb</author><pubDate>Tue, 18 Nov 2025 13:48:10 +0800</pubDate><description><![CDATA[(select VersionDesc from (select top 1 BomId from (select mocode,BomId,modid as id from mom_order a join mom_orderdetail b on a.moid=b.moid)c where id=$<子表标识>)d join bom_bom as bom on d.BomId=bom.BomId)--核心是这个改不了，照着仿写吧，整个语句最前面最后面都要加英文括号。]]></description><category></category></item><item><title><![CDATA[U8/历史凭证在有辅助核算的情况下新增自定义项1的内容]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154795620</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154795620</guid><author>wssbdbdbb</author><pubDate>Fri, 14 Nov 2025 11:39:46 +0800</pubDate><description><![CDATA[-UPDATE GL_AccMultiAss SET cDefine1 = '自筹资金'--UPDATE GL_accvouch SET cDefine1 = '自筹资金'业务场景，客户需要对研发项目区分资金来源。--修改多辅助明细账汇总表自定义项1。]]></description><category></category></item><item><title><![CDATA[U8/UAP自定义报表_跨账套的凭证和发票的核对]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154646267</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154646267</guid><author>wssbdbdbb</author><pubDate>Mon, 10 Nov 2025 12:58:50 +0800</pubDate><description><![CDATA[PZ_KH.ccode_name[客户名称],PZ_SR.ccode_name[存货分类],PZ_SR.mc_f[原币金额],PZ_SR.mc[本币金额],PZ_SR.nc_s[数量],PZ_KH.inid[客户行号],PZ_KH.Next_inid[下一行号],PZ_SR.inid。SELECT [存货分类],[客户名称],SUM([原币金额])[凭证原币金额],SUM([本币金额])[凭证本币金额],CAST(SUM([数量]) AS float)[凭证数量],ELSE 0  -- 不包含"外销"]]></description><category></category></item><item><title><![CDATA[U8/查询所有的账套信息]]></title><link>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154481489</link><guid>https://blog.youkuaiyun.com/wssbdbdbb/article/details/154481489</guid><author>wssbdbdbb</author><pubDate>Thu, 06 Nov 2025 11:26:26 +0800</pubDate><description><![CDATA[SELECT cAcc_Id 账套编码,cAcc_Name 账套名称,* FROM UA_Account。在UFsystem库下执行。]]></description><category></category></item></channel></rss>