用友ERP-U8
garong
这个作者很懒,什么都没留下…
展开
-
查找单据删除却还在汇总表里显示的单据
<br />select * from IA_Subsidiary where ID not in (select autoid from rdrecords)<br />或select * from IA_Subsidiary where ID not in (select autoid from rdrecords)and cinvcode='存货编码'<br />查到后还得进总帐查<br />IA_Summary<br />原创 2010-06-23 12:22:00 · 380 阅读 · 0 评论 -
查询未审核或未记账单据U870
<br />select * from rdrecord where isnull(cHandler,'')='' or isnull(cAccounter,'')=''原创 2010-06-23 12:23:00 · 834 阅读 · 0 评论