用友U6普及版3.1 plus1材料出库单定位过滤出的材料出库单是空白
2016-3-14 0:0:0 用友T1小编用友U6普及版3.1 plus1材料出库单定位过滤出的材料出库单是空白
U6普及版3.1 plus1材料出库单定位过滤出的材料出库单是空白
U6普及版3.1 plus1-材料出库单定位过滤出的材料出库单是空白
自动编号: | 19138 | 产品版本: | U6普及版3.1 plus1 |
产品模块: | 库存管理 | 所属行业: | 通用 |
适用产品: | U6 | 关 键 字: | |
问题名称: | 材料出库单定位过滤出的材料出库单是空白 | ||
问题现象: | 材料出库单定位过滤出的材料出库单是空白 | ||
原因分析: | 数据库视图recordoutlist损坏 | ||
解决方案: | 从别的帐套中导出此视图覆盖坏的帐套,或执行语句 SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE view dbo.recordoutlist as select dbo.recordoutq.id, dbo.recordoutq.brdflag, dbo.recordoutq.cvouchtype, dbo.recordoutq.cwhcode, dbo.recordoutq.ddate, dbo.recordoutq.ccode, dbo.recordoutq.crdcode, dbo.recordoutq.cdepcode, dbo.recordoutq.imquantity, dbo.recordoutq.cpersoncode, dbo.recordoutq.cprobatch, dbo.recordoutq.bpufirst, dbo.recordoutq.biafirst, dbo.recordoutq.chandler, dbo.recordoutq.cmemo, dbo.recordoutq.caccounter, dbo.recordoutq.cmaker, dbo.recordoutq.cdefine1, dbo.recordoutq.cdefine2, dbo.recordoutq.cdefine3, dbo.recordoutq.cdefine4, dbo.recordoutq.cdefine5, dbo.recordoutq.cdefine6, dbo.recordoutq.cdefine7, dbo.recordoutq.cdefine8, dbo.recordoutq.cdefine9, dbo.recordoutq.cdefine10, dbo.recordoutq.cwhname, dbo.recordoutq.cdepname, dbo.recordoutq.cpersonname, dbo.recordoutq.cinvname as cinvname_1, dbo.recordoutq.ufts, dbo.recordoutq.crdname, dbo.recordoutq.csource, dbo.recordoutq.cbustype, dbo.recordoutq.cpspcode,dbo.recordoutq.cmpocode, dbo.recordoutq.ipurorderid, dbo.recordoutq.ipurarriveid, dbo.recordoutq.iproorderid, dbo.recordoutq.iarriveid,dbo.recordoutq.isalebillid, dbo.recordoutsq.autoid, dbo.recordoutsq.id as id_1, dbo.recordoutsq.cinvcode, dbo.recordoutsq.cinvaddcode, dbo.recordoutsq.cinvname, dbo.recordoutsq.cinvstd, dbo.recordoutsq.cinvm_unit, dbo.recordoutsq.cinva_unit, dbo.recordoutsq.creplaceitem, dbo.recordoutsq.cposition, dbo.recordoutsq.cinvdefine1, dbo.recordoutsq.cinvdefine2, dbo.recordoutsq.cinvdefine3, dbo.recordoutsq.cfree1, dbo.recordoutsq.cfree2, dbo.recordoutsq.cbatch, dbo.recordoutsq.iinvexchrate, dbo.recordoutsq.inum, dbo.recordoutsq.iquantity, dbo.recordoutsq.iunitcost, round(dbo.recordoutsq.iprice,2) as iprice, dbo.recordoutsq.ipunitcost, round(dbo.recordoutsq.ipprice,2) as ipprice, dbo.recordoutsq.dvdate, dbo.recordoutsq.cobjcode, dbo.recordoutsq.isoutquantity, dbo.recordoutsq.isoutnum, dbo.recordoutsq.dsdate, dbo.recordoutsq.ifquantity, dbo.recordoutsq.ifnum, dbo.recordoutsq.cvouchcode, dbo.recordoutq.cbuscode, dbo.recordoutsq.cdefine22, dbo.recordoutsq.cdefine23, dbo.recordoutsq.cdefine24, dbo.recordoutsq.cdefine25, dbo.recordoutsq.cdefine26, dbo.recordoutsq.cdefine27, dbo.recordoutsq.citemcode, dbo.recordoutsq.citem_class, dbo.recordoutq.dveridate, dbo.recordoutsq.cname, dbo.recordoutsq.citemcname, dbo.recordoutq.darvdate, dbo.recordoutq.cchkcode, dbo.recordoutq.dchkdate, dbo.recordoutq.cchkperson, dbo.recordoutq.bisstqc, dbo.recordoutq.vt_id, dbo.recordoutq.cdefine11, dbo.recordoutq.cdefine12, dbo.recordoutq.cdefine13, dbo.recordoutq.cdefine14, dbo.recordoutq.cdefine15, dbo.recordoutq.cdefine16, dbo.recordoutq.imquantity as expr1, dbo.recordoutsq.cinvdefine4, dbo.recordoutsq.cinvdefine5, dbo.recordoutsq.cinvdefine6, dbo.recordoutsq.cinvdefine7, dbo.recordoutsq.cinvdefine8, dbo.recordoutsq.cinvdefine9, dbo.recordoutsq.cinvdefine10, dbo.recordoutsq.cinvdefine11, dbo.recordoutsq.cinvdefine12, dbo.recordoutsq.cinvdefine13, dbo.recordoutsq.cinvdefine14, dbo.recordoutsq.cinvdefine15, dbo.recordoutsq.cinvdefine16, dbo.recordoutsq.iid, dbo.recordoutsq.cfree3, dbo.recordoutsq.cfree4, dbo.recordoutsq.cfree5, dbo.recordoutsq.cfree6, dbo.recordoutsq.cfree7, dbo.recordoutsq.cfree8, dbo.recordoutsq.cfree9, dbo.recordoutsq.cfree10, dbo.recordoutsq.cbarcode, dbo.recordoutsq.inquantity, dbo.recordoutsq.innum, dbo.recordoutsq.cassunit, dbo.recordoutsq.dmadedate, dbo.recordoutsq.cdefine28, dbo.recordoutsq.cdefine29, dbo.recordoutsq.cdefine30, dbo.recordoutsq.cdefine31, dbo.recordoutsq.cdefine32, dbo.recordoutsq.cdefine33, dbo.recordoutsq.cdefine34, dbo.recordoutsq.cdefine35, dbo.recordoutsq.cdefine36, dbo.recordoutsq.cdefine37, dbo.recordoutsq.impoids, dbo.recordoutsq.icheckids, dbo.recordoutsq.cbvencode, dbo.recordoutsq.cvenname, dbo.recordoutsq.cinvouchcode, dbo.recordoutsq.imassdate, dbo.recordoutsq.cposname from dbo.recordoutq left outer join dbo.recordoutsq on dbo.recordoutq.id = dbo.recordoutsq.id GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 删除常用凭证 _02016-8-15 8:45:9
- 设置工资管理所得税税率2016-5-20 0:0:0
- 设置帐户的意义及分类与结构2016-5-20 0:0:0
- 设置开户银行2016-5-20 0:0:0
- 设置成套件时选不到存货2016-5-20 0:0:0
- 设置打印模板后预览没有变化2016-5-20 0:0:0
- 设置报表关键字打印颜色2016-5-20 0:0:0
- 设置排版样式——Word 2007书籍排版完全手册22016-5-20 0:0:0
- 设置权限2016-5-20 0:0:0
- 设置的禁发规则无效2016-5-20 0:0:0
最新信息
- 请问:修改制单人后以前做账的制单人不能同步修改吗?以前做好的账的制单人姓名?
- 请问,我们缴纳的税款入库到哪里了?在哪里可以看出入哪个金库了?三方协议上能看出吗?
- 请问,我先前收到一笔货款,不知道是谁付的,借:银行存款,贷:应收账款-未知;现在确认是谁付的后,我该怎样调账
- 请问,我公司是一般纳税人,供应商开给我们的进项名字开错了,已经被我们认证了,但是客户那边作废重开了一张,重开的未认证,这种进项转出要怎么做的?直接做一张红字红冲就可以了么?
- 请问,我看她写的期限是一年,那么一年以后,现在建立的帐套还在么
- 请问,我进项一个东西含税价是62元,税负率算1.2%,进销都是17%的税钱收,卖出去我要卖多少钱才不会亏呢?有公式吗
- 请问,新版的国税季报利润表里,本期金额和上期金额怎么填,取哪个数呢,谢谢
- 请问,用友建账建筑行业行业性质选哪个?
- 请问,财务做帐时后面附的合同必须是原件吗?
- 请问:店铺转让费10万元放在什么科目核算?新店。如果要摊消,几年摊完比较合理。坐得各位高手解答。谢谢。
请问大家捐赠以及接受捐赠怎么做分录,对于货币性和非货币性有什么区别吗 请问大家捐赠以及接受捐赠怎么做分录,对于货币性和非货币性有什么区别吗[]
#财税实务#有一个课件讲到这个问题。捐赠支出方式符合所得税法相关规定的利润总额12%以内部分可税前扣除。@会计家园-戴崇恩: 谢谢哦 这个分录很有用 捐赠方那个分录应该是贷 应缴税费 销@ioio132_YDifu:目前一级科目通常是用“应交税费”吧
运维服务
更多解决方案
热点文章
- 经常出现账套年度演示期限已到期,怎么办?
- 麻烦问下,T3升级T6,是不是要先安装6.1,用工具升级,再导出帐套,安装6.5,再升级到6.5?
- 麻烦问下,账簿交接怎么操作
- 麻烦问下:增值税普票次月开了负数发票,做账时是否都要把财务联和发票联附在记账凭证后,另外当月作废的增值税普票怎么处理呢?谢谢!
- 黄色的加密狗驱动不了,在服务社区下载的驱动安装后也是不行,win2003的系统
- 黄色部分的最新成本错了,如何修改
- (-0.2)的2009次方乘(-5)的2010次方
- (时间是11点多的时候还没吃饭)体育考试立定跳远 和跑完50米后 然后走20几分钟去车站搭车
- ,小额纳税企业在营业大厅开增值税专用发票税点是多少
- 1。T3升级上来,增加了 人事管理模块 ,加密狗刷新了 薪资管理还是系那是演示版……--2.还有就是 登录进去经常会出现登录子系统失败,退出再登录进去就行-请教
用友热销产品
- 最新文章排行
- 热门文章排行
- T3普及版,资产负债表,追加表页,看不到了,是什么原因?
- T3打开乱码,安装软件时,弹出菜单也是乱码
- T+12.1标准版,科目明细账无法导出
- T+12.1用今天这个补丁升级失败。请解
- T+12.1 往来单位设置自动编码,新增往来单位编码一直是最后一个,点哪个分类都一样
- T+标12.1 用8.17日的补丁升级失败。请问什么办?
- T+怎么把停用的员工永久显示出来
- 1。T3升级上来,增加了 人事管理模块 ,加密狗刷新了 薪资管理还是系那是演示版……--2.还有就是 登录进去经常会出现登录子系统失败,退出再登录进去就行-请教
- ,小额纳税企业在营业大厅开增值税专用发票税点是多少
- (时间是11点多的时候还没吃饭)体育考试立定跳远 和跑完50米后 然后走20几分钟去车站搭车