工程物资与材料的区别
2018-4-1 0:0:0 wondial工程物资与材料的区别
工程物资与材料的区别[]材料一般属于存货的种类,是流动资产,工程物资是为了建造不动产等购入的,属于非流动资产。那天刚听东奥的凤姐讲过--您好是这样的今天做账时发现,用于在建工程的电线发票摘要写成了材料。我不知道 能不能做到在建工程。@老虎1:现在营改增了,不知道购入的用于在建工程的材料怎么个抵扣法,嘿嘿。不过你可以改成工程物质呀综合账务调整法
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 年结的时候出现,本机已经运行【系统控制台程序】,请退出再运行2020-4-28 8:53:21
- 填制凭证类别时显示互斥站点2020-4-28 8:40:34
- 用友软件访问数据库是要通过SA来访问的,是否可以用其他的用户名2020-4-26 23:40:53
- 12.0普及版,盘点单保存报“计量单位2必须为空”。经检查是某个存货单计量,在盘点单带出了计量单位2,在别的单据不会带出单位2.怎么解决,有补丁解决么?2019-5-22 8:0:0
- 产成品入库单删除报错, 查询联查没有任何单据2019-5-22 8:0:0
- 更新了最新补丁提示微信结算方式与其他结算方式冲突是什么原因2019-5-22 8:0:0
- 版本号-12.100.001.0076.0514 票据类型无法记忆,设置单据中已经打开票据类型记忆功能,同客户无法实现记忆,升级到新版之后,出现的问题!2019-5-22 8:0:0
- 为啥客户端老是提示这个2019-5-13 9:0:0
- T3 卸载不了,怎么解决2019-4-30 8:0:0
- 我的标准版 安装包 按setup都是卸载的?卸了按第二次也是卸载 不能安装2019-4-30 8:0:0
最新信息
#十堰同城会# #本月进项已到,但进项发票未认证,而销项发票已开怎么做分录?是暂估入库还是计入待抵扣进项税?具体分录怎么做呀- #十堰同城会# #本月进项已到,但进项发票未认证,而销项发票已开怎么做分录?是暂估入库还是计入待抵扣进项税?具体分录怎么做呀?[]
先暂时估价入帐,
借:原材料 (金额暂时先估的)
贷:应付帐款 (金额暂时先估的)
材料发票来了之后
1.先把之前估价入帐的分录冲减掉,分录如下:
借:原材料 (金额暂时先估的)红字
贷:应付帐款 (金额暂时先估的) 红字
2.重新做个分录:
借:原材料
应交税费--应交增值税(进项)
贷:应付帐款
3.付款时
借:应付帐款
贷:银行存款@看世间繁华:谢谢你的回答
我一直有个问题,那么多会计核算方法出来,成了规定,那些制定游戏规则的人有没有想过全国这么多企业,怎么实行,我学习会计的人,也只不过通过了考试,没有实践经验的人怎么适应新的变化呢?这么多问题的发生,是不是国家建设出了什么问题呢? 我一直有个问题,那么多会计核算方法出来,成了规定,那些制定游戏规则的人有没有想过全国这么多企业,怎么实行,我学习会计的人,也只不过通过了考试,没有实践经验的人怎么适应新的变化呢?这么多问题的发生,是不是国家建设出了什么问题呢?[]
玩游戏首先看规则,如果不适应,或玩得不好,就不建议玩,想玩,就得适应规则,除非有一天,你成为制定规则的人,否则,想让规则适应你,难……达尔文早就说过:适者生存@李淑梅:嗯
- 用友U8 仓库(A、B)计价方式:移动平均 存货X在仓库A的结存单价为0 存货X在仓库B的结存单价为5 操作如下:做调拨单从A到B,记账后,其他出库单单价为0,而其他入库单单价为5,不是为0 补充:存货选项中的入库金额和零出库金额选择为结存成本
- 用友U8 软件无法登陆,在管理工具的服务中发现SQL无法启动,提示可能是WINDOWS错误
- 用友U8 客户能够ping通服务器,但是不能登陆用友软件。
- 用友U8 录入银行对账单保存、退出后再进入,数就变了,有些数总会重复多出一条,估计需要跟一下数据库。客户今天发现问题的时候,已经让客户把有问题的帐套做了帐套输出。
- 用友U8 总帐和存货总帐对不上
- 在录入凭证或查询辅助余额表时,能__否改成以表的形式显示项目辅助核算?
- 用友NC物资管理系统解决方案
- NC资产管理系统解决方案
- NC销售管理系统解决方案
- 用友NC软件凭证打印设置方法
用友U8 U811A升级U821,升级SQL SERVER数据库报错:账套升级失败!错误号13类型不匹配。用友U8 U811A升级U821,升级SQL SERVER数据库报错:账套升级失败!错误号13类型不匹配。
问题原因:是由于数据库中缺少justinlist,JustInQ,justinsq,justoutlist,JustOutQ,justoutsq6个视图 解决方法:执行以下脚本,生成视图:(1)if exists (select * from sysobjects where id = object_id(N'[dbo].[justinlist]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justinlist]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justinlist as SELECT JustInQ.cJVCode, JustInQ.cVouchType, JustInQ.cWhCode, JustInQ.dJVDate,JustInQ.cUnitCode, JustInQ.cDepCode, JustInQ.cPersonCode, JustInQ.cRdCode,JustInQ.cJVMemo, JustInQ.cJVDefine1, JustInQ.cJVDefine2, JustInQ.cJVDefine3, JustInQ.cAccounter, JustInQ.cMaker, JustInQ.cWhName, JustInQ.cVenAbbName,JustInQ.cDepName, JustInQ.cPersonName, JustInQ.cRdName, JustInQ.bRdFlag,JustInQ.cHandler, JustInQ.cPersonName_1, justinsq.cJVCode AS cJVCode_1,justinsq.cInvCode, justinsq.AutoID, justinsq.cInvName, justinsq.cInvStd, justinsq.cCorCode, justinsq.iJVPrice, justinsq.cFree1, justinsq.cFree2, justinsq.CorID,JustInQ.cDefine1, JustInQ.cDefine2, JustInQ.cDefine3, JustInQ.cDefine4,JustInQ.cDefine5, JustInQ.cDefine6, JustInQ.cDefine7, JustInQ.cDefine8,JustInQ.cDefine9, JustInQ.cDefine10,JustInsQ.cDefine22, JustInsQ.cDefine23, JustInsQ.cDefine24,justinsq.cdefine25 , justinsq.cdefine26, justinsq.cdefine27 FROM JustInQ LEFT OUTER JOIN justinsq ON JustInQ.cJVCode = justinsq.cJVCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(2)if exists (select * from sysobjects where id = object_id(N'[dbo].[JustInQ]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[JustInQ]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOCreate View JustInQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Vendor.cVenAbbName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10FROM JustInVouch LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Vendor ON JustInVouch.cUnitCode = Vendor.cVenCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCodeWHERE (JustInVouch.cVouchType = '20') GOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(3)if exists (select * from sysobjects where id = object_id(N'[dbo].[justinsq]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justinsq]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justinsq as SELECT JustInVouchs.cJVCode, JustInVouchs.cInvCode, JustInVouchs.AutoID,JustInVouchs.cDefine22, JustInVouchs.cDefine23, JustInVouchs.cDefine24,JustInVouchs.cDefine25, JustInVouchs.cDefine26, JustInVouchs.cDefine27,Inventory.cInvName, Inventory.cInvStd, JustInVouchs.cCorCode,JustInVouchs.iJVPrice, JustInVouchs.cFree1, JustInVouchs.cFree2,JustInVouchs.CorID FROM JustInVouchs LEFT OUTER JOIN Inventory ON JustInVouchs.cInvCode = Inventory.cInvCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(4)if exists (select * from sysobjects where id = object_id(N'[dbo].[justoutlist]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justoutlist]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justoutlist as SELECT JustOutQ.cJVCode, JustOutQ.cVouchType, JustOutQ.cWhCode, JustOutQ.dJVDate,JustOutQ.cUnitCode, JustOutQ.cDepCode, JustOutQ.cPersonCode, JustOutQ.cRdCode,JustOutQ.cJVMemo, JustOutQ.cJVDefine1, JustOutQ.cJVDefine2, JustOutQ.cJVDefine3,JustOutQ.cAccounter, JustOutQ.cMaker, JustOutQ.cWhName, JustOutQ.cDepName,JustOutQ.cPersonName, JustOutQ.cRdName, JustOutQ.bRdFlag, JustOutQ.cHandler,JustOutQ.cPersonName_1, JustOutQ.cCusAbbName,justoutsq.cJVCode AS cJVCode_1, justoutsq.cInvCode, justoutsq.AutoID,justoutsq.cInvName, justoutsq.cInvStd, justoutsq.iJVPrice, justoutsq.cFree1,justoutsq.cFree2, justoutsq.cObjCode, justoutsq.cName, JustOutQ.cDefine1,JustOutQ.cDefine2, JustOutQ.cDefine3, JustOutQ.cDefine4, JustOutQ.cDefine5,JustOutQ.cDefine6, JustOutQ.cDefine7, JustOutQ.cDefine8, JustOutQ.cDefine9,JustOutQ.cDefine10 , justoutsq.cdefine22, justoutsq.cdefine23, justoutsq.cdefine24, justoutsq.cdefine25, justoutsq.cdefine26, justoutsq.cdefine27 FROM JustOutQ LEFT OUTER JOIN justoutsq ON JustOutQ.cJVCode = justoutsq.cJVCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(5)if exists (select * from sysobjects where id = object_id(N'[dbo].[JustOutQ]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[JustOutQ]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOCreate View JustOutQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, Customer.cCusAbbName, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10FROM JustInVouch LEFT OUTER JOIN Customer ON JustInVouch.cUnitCode = Customer.cCusCode LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCodeWHERE (JustInVouch.cVouchType = '21')GOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(6)if exists (select * from sysobjects where id = object_id(N'[dbo].[justoutsq]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justoutsq]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justoutsq as SELECT JustInVouchs.cJVCode, JustInVouchs.cInvCode, JustInVouchs.AutoID,JustInVouchs.cDefine22, JustInVouchs.cDefine23, JustInVouchs.cDefine24,JustInVouchs.cDefine25, JustInVouchs.cDefine26, JustInVouchs.cDefine27,Inventory.cInvName, Inventory.cInvStd, JustInVouchs.iJVPrice, JustInVouchs.cFree1,JustInVouchs.cFree2 , JustInVouchs.cObjCode, CostObj.cName FROM JustInVouchs LEFT JOIN CostObj ON JustInVouchs.cObjCode = CostObj.cCode LEFT JOIN Inventory ON JustInVouchs.cInvCode = Inventory.cInvCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO
解决方案:
问题原因:是由于数据库中缺少justinlist,JustInQ,justinsq,justoutlist,JustOutQ,justoutsq6个视图 解决方法:执行以下脚本,生成视图:(1)if exists (select * from sysobjects where id = object_id(N'[dbo].[justinlist]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justinlist]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justinlist as SELECT JustInQ.cJVCode, JustInQ.cVouchType, JustInQ.cWhCode, JustInQ.dJVDate,JustInQ.cUnitCode, JustInQ.cDepCode, JustInQ.cPersonCode, JustInQ.cRdCode,JustInQ.cJVMemo, JustInQ.cJVDefine1, JustInQ.cJVDefine2, JustInQ.cJVDefine3, JustInQ.cAccounter, JustInQ.cMaker, JustInQ.cWhName, JustInQ.cVenAbbName,JustInQ.cDepName, JustInQ.cPersonName, JustInQ.cRdName, JustInQ.bRdFlag,JustInQ.cHandler, JustInQ.cPersonName_1, justinsq.cJVCode AS cJVCode_1,justinsq.cInvCode, justinsq.AutoID, justinsq.cInvName, justinsq.cInvStd, justinsq.cCorCode, justinsq.iJVPrice, justinsq.cFree1, justinsq.cFree2, justinsq.CorID,JustInQ.cDefine1, JustInQ.cDefine2, JustInQ.cDefine3, JustInQ.cDefine4,JustInQ.cDefine5, JustInQ.cDefine6, JustInQ.cDefine7, JustInQ.cDefine8,JustInQ.cDefine9, JustInQ.cDefine10,JustInsQ.cDefine22, JustInsQ.cDefine23, JustInsQ.cDefine24,justinsq.cdefine25 , justinsq.cdefine26, justinsq.cdefine27 FROM JustInQ LEFT OUTER JOIN justinsq ON JustInQ.cJVCode = justinsq.cJVCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(2)if exists (select * from sysobjects where id = object_id(N'[dbo].[JustInQ]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[JustInQ]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOCreate View JustInQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Vendor.cVenAbbName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10FROM JustInVouch LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Vendor ON JustInVouch.cUnitCode = Vendor.cVenCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCodeWHERE (JustInVouch.cVouchType = '20') GOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(3)if exists (select * from sysobjects where id = object_id(N'[dbo].[justinsq]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justinsq]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justinsq as SELECT JustInVouchs.cJVCode, JustInVouchs.cInvCode, JustInVouchs.AutoID,JustInVouchs.cDefine22, JustInVouchs.cDefine23, JustInVouchs.cDefine24,JustInVouchs.cDefine25, JustInVouchs.cDefine26, JustInVouchs.cDefine27,Inventory.cInvName, Inventory.cInvStd, JustInVouchs.cCorCode,JustInVouchs.iJVPrice, JustInVouchs.cFree1, JustInVouchs.cFree2,JustInVouchs.CorID FROM JustInVouchs LEFT OUTER JOIN Inventory ON JustInVouchs.cInvCode = Inventory.cInvCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(4)if exists (select * from sysobjects where id = object_id(N'[dbo].[justoutlist]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justoutlist]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justoutlist as SELECT JustOutQ.cJVCode, JustOutQ.cVouchType, JustOutQ.cWhCode, JustOutQ.dJVDate,JustOutQ.cUnitCode, JustOutQ.cDepCode, JustOutQ.cPersonCode, JustOutQ.cRdCode,JustOutQ.cJVMemo, JustOutQ.cJVDefine1, JustOutQ.cJVDefine2, JustOutQ.cJVDefine3,JustOutQ.cAccounter, JustOutQ.cMaker, JustOutQ.cWhName, JustOutQ.cDepName,JustOutQ.cPersonName, JustOutQ.cRdName, JustOutQ.bRdFlag, JustOutQ.cHandler,JustOutQ.cPersonName_1, JustOutQ.cCusAbbName,justoutsq.cJVCode AS cJVCode_1, justoutsq.cInvCode, justoutsq.AutoID,justoutsq.cInvName, justoutsq.cInvStd, justoutsq.iJVPrice, justoutsq.cFree1,justoutsq.cFree2, justoutsq.cObjCode, justoutsq.cName, JustOutQ.cDefine1,JustOutQ.cDefine2, JustOutQ.cDefine3, JustOutQ.cDefine4, JustOutQ.cDefine5,JustOutQ.cDefine6, JustOutQ.cDefine7, JustOutQ.cDefine8, JustOutQ.cDefine9,JustOutQ.cDefine10 , justoutsq.cdefine22, justoutsq.cdefine23, justoutsq.cdefine24, justoutsq.cdefine25, justoutsq.cdefine26, justoutsq.cdefine27 FROM JustOutQ LEFT OUTER JOIN justoutsq ON JustOutQ.cJVCode = justoutsq.cJVCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(5)if exists (select * from sysobjects where id = object_id(N'[dbo].[JustOutQ]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[JustOutQ]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOCreate View JustOutQ AS SELECT JustInVouch.cJVCode, JustInVouch.cVouchType, JustInVouch.cWhCode, JustInVouch.dJVDate, JustInVouch.cUnitCode, JustInVouch.cDepCode, JustInVouch.cPersonCode, JustInVouch.cRdCode, JustInVouch.cJVMemo, JustInVouch.cJVDefine1, JustInVouch.cJVDefine2, JustInVouch.cJVDefine3, JustInVouch.cAccounter, JustInVouch.cMaker, Warehouse.cWhName, Department.cDepName, Person.cPersonName, Rd_Style.cRdName, JustInVouch.bRdFlag, JustInVouch.cHandler, Person1.cPersonName AS cPersonName_1, Customer.cCusAbbName, JustInVouch.cDefine1, JustInVouch.cDefine2, JustInVouch.cDefine3, JustInVouch.cDefine4, JustInVouch.cDefine5, JustInVouch.cDefine6, JustInVouch.cDefine7, JustInVouch.cDefine8, JustInVouch.cDefine9, JustInVouch.cDefine10FROM JustInVouch LEFT OUTER JOIN Customer ON JustInVouch.cUnitCode = Customer.cCusCode LEFT OUTER JOIN Department ON JustInVouch.cDepCode = Department.cDepCode LEFT OUTER JOIN GL_bdigest ON JustInVouch.cJVMemo = GL_bdigest.cid LEFT OUTER JOIN Person ON JustInVouch.cPersonCode = Person.cPersonCode LEFT OUTER JOIN Person Person1 ON JustInVouch.cHandler = Person1.cPersonCode LEFT OUTER JOIN Rd_Style ON JustInVouch.cRdCode = Rd_Style.cRdCode LEFT OUTER JOIN Warehouse ON JustInVouch.cWhCode = Warehouse.cWhCodeWHERE (JustInVouch.cVouchType = '21')GOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO(6)if exists (select * from sysobjects where id = object_id(N'[dbo].[justoutsq]') and OBJECTPROPERTY(id, N'IsView') = 1)drop view [dbo].[justoutsq]GOSET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GOcreate view justoutsq as SELECT JustInVouchs.cJVCode, JustInVouchs.cInvCode, JustInVouchs.AutoID,JustInVouchs.cDefine22, JustInVouchs.cDefine23, JustInVouchs.cDefine24,JustInVouchs.cDefine25, JustInVouchs.cDefine26, JustInVouchs.cDefine27,Inventory.cInvName, Inventory.cInvStd, JustInVouchs.iJVPrice, JustInVouchs.cFree1,JustInVouchs.cFree2 , JustInVouchs.cObjCode, CostObj.cName FROM JustInVouchs LEFT JOIN CostObj ON JustInVouchs.cObjCode = CostObj.cCode LEFT JOIN Inventory ON JustInVouchs.cInvCode = Inventory.cInvCodeGOSET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO
www.kuaiji66.com 天龙瑞德
用友U8 一客户刚刚启用采购库存及存货核算系统,存货档案输入时既无自定义项也无自由项,当然更谈不上结构性自由项. 但是,在输入存货期初或填制出入库单据时,有几个存货就是不能保存,提示”单据保存失败,修改或稍后再试!无此自由项组合,存货XX结构自由项不合法!”_0用友U8 一客户刚刚启用采购库存及存货核算系统,存货档案输入时既无自定义项也无自由项,当然更谈不上结构性自由项. 但是,在输入存货期初或填制出入库单据时,有几个存货就是不能保存,提示”单据保存失败,修改或稍后再试!无此自由项组合,存货XX结构自由项不合法!”
问题原因:跟踪一下发现select bas_part.PartId From bas_part, Inventory where bas_part.InvCode = Inventory.cInvCode and bas_part.InvCode = '0204001'and (Inventory.bConfigFree1 = 1 and bas_part.Free1 = '' or Inventory.bConfigFree1 = 0 and bas_part.Free1 = '') and (Inventory.bConfigFree2 = 1 and bas_part.Free2 = '' or Inventory.bConfigFree2 = 0 and bas_part.Free2 = '') and (Inventory.bConfigFree3 = 1 and bas_part.Free3 = '' or Inventory.bConfigFree3 = 0 and bas_part.Free3 = '') and (Inventory.bConfigFree4 = 1 and bas_part.Free4 = '' or Inventory.bConfigFree4 = 0 and bas_part.Free4 = '') and (Inventory.bConfigFree5 = 1 and bas_part.Free5 = '' or Inventory.bConfigFree5 = 0 and bas_part.Free5 = '') and (Inventory.bConfigFree6 = 1 and bas_part.Free6 = '' or Inventory.bConfigFree6 = 0 and bas_part.Free6 = '') and (Inventory.bConfigFree7 = 1 and bas_part.Free7 = '' or Inventory.bConfigFree7 = 0 and bas_part.Free7 = '') and (Inventory.bConfigFree8 = 1 and bas_part.Free8 = '' or Inventory.bConfigFree8 = 0 and bas_part.Free8 = '') and (Inventory.bConfigFree9 = 1 and bas_part.Free9 = '' or Inventory.bConfigFree9 = 0 and bas_part.Free9 = '') and (Inventory.bConfigFree10 = 1 and bas_part.Free10 = '' or Inventory.bConfigFree10 = 0 and bas_part.Free10 = '') 解决方法:打开表bas_part一看,发现不能保存的存货在这里都没有对应的记录,添加上去后即可正常使用该存货,问题解决.
解决方案:
问题原因:跟踪一下发现select bas_part.PartId From bas_part, Inventory where bas_part.InvCode = Inventory.cInvCode and bas_part.InvCode = '0204001'and (Inventory.bConfigFree1 = 1 and bas_part.Free1 = '' or Inventory.bConfigFree1 = 0 and bas_part.Free1 = '') and (Inventory.bConfigFree2 = 1 and bas_part.Free2 = '' or Inventory.bConfigFree2 = 0 and bas_part.Free2 = '') and (Inventory.bConfigFree3 = 1 and bas_part.Free3 = '' or Inventory.bConfigFree3 = 0 and bas_part.Free3 = '') and (Inventory.bConfigFree4 = 1 and bas_part.Free4 = '' or Inventory.bConfigFree4 = 0 and bas_part.Free4 = '') and (Inventory.bConfigFree5 = 1 and bas_part.Free5 = '' or Inventory.bConfigFree5 = 0 and bas_part.Free5 = '') and (Inventory.bConfigFree6 = 1 and bas_part.Free6 = '' or Inventory.bConfigFree6 = 0 and bas_part.Free6 = '') and (Inventory.bConfigFree7 = 1 and bas_part.Free7 = '' or Inventory.bConfigFree7 = 0 and bas_part.Free7 = '') and (Inventory.bConfigFree8 = 1 and bas_part.Free8 = '' or Inventory.bConfigFree8 = 0 and bas_part.Free8 = '') and (Inventory.bConfigFree9 = 1 and bas_part.Free9 = '' or Inventory.bConfigFree9 = 0 and bas_part.Free9 = '') and (Inventory.bConfigFree10 = 1 and bas_part.Free10 = '' or Inventory.bConfigFree10 = 0 and bas_part.Free10 = '') 解决方法:打开表bas_part一看,发现不能保存的存货在这里都没有对应的记录,添加上去后即可正常使用该存货,问题解决.
期初结存中批审如何使用? 期初结存中批审如何使用?
问题号: | 41031 |
---|---|
适用产品: | T6系列 |
软件版本: | T6-企业管理软件V6.1 |
软件模块: | 库存管理 |
问题名称: | 期初结存中批审如何使用? |
问题现象: | 库存模块中,期初结存中的批审有何作用? |
问题原因: | 见问题答案。 |
关键字: | 期初 |
解决方案: | 选择需要批审的仓库,点击批审后,该仓库的所有存货期初全部审核。 |
行业: | 通用 |
补丁编号: | |
解决状态: | 最终解决方案 |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 用友t3怎样取消审核
- 用友t6如何取消审核凭证
- 请问下,我建账选择的是小企业会计准则(2013年)行业性质,但是为什么在会计科目那里显示的都是小企业会计制度的会计科目?
- 老师请问:怎么样才能把不能够按照默认供货商为单位来查询诸如销量、库存等等各类参数的问题反馈给开发团队??我们超市这单是和各个供货商对接库存和销售量都快疯了。这样一个带前端销售的软件怎么会这个基本的功能都没有……还需要做什么自定义项那么麻烦
- 前台收银程序T+pos启动后,提示数据库错误,编号11,绑定数据库错误。如何处理啊?
- 为什么卸载的时候提示这个??
- 请问t3标准版为什么从系统卸载不掉,请问怎么才能卸载掉?
- T3卸载不了提示这个是什么意思?
- 请问这是怎么一回事,老是说登录不上服务器,防火墙都已经关闭了,提示下面这种
- 我用的是用友T3普及版 ,现在我点击注册登录时输入密码之后没有账套出来,我确定密码和用户名都是对的!还有点击系统管理的时候电脑没有反应,打不开系统管理!这个是什么原因呢?
房产企业的会计假设 房产企业的会计假设 作为会计核算的一个分支,它应具备会计核算的基本前提,这种前提也被称为会计假设。这些假设分别从空间范围,时间界限和计量单位几个基本方面规定了会计核算会计核算基本假设的内容: 会计基本假设 又称会计核算的基本前提或会计假定,是指在进行会计核算时必须明确是企业会计确认,计量和报告的前提条件,是对会计核算所处时间,空间环境等所做的合理假定分为会计主体,持续经营,会计分期和货币计量 会计主体 是指企业会计确认,计量和报告的空间范围,在会计主体假设下,企业应当对其本身发生的交易或者事项进行会计确认、计量和报告。反映企业本身所从事的各项生产经营活动,明确界定会计主体是开展会计确认、计量和报告工作的重要前提。首先,明确会计主体,才能划定会计索要处理的各项交易或事项的范围。其次,明确会计主体,才能将会计主体的交易或者事项与会计主体所有者的交易或者事项以及其他会计主体的交易或者事项区分开来 持续经营 是指在可以预见的将来、企业将会按当前的规模和状态继续不断的经营下去,不会停业,也不会大规模削减业务,即在可预见的未来,该会计主体不会破产清算,所持有的资产将正常运营,所负的债务将正常偿还,它明确了会计确认,计量和报告的时间范围。 会计分期 是指将一个企业持续经营的生产经营活动期间划分为若干连续的,长短相同的期间。在会计分期假设下,企业应当划分期间,分期结算账目和编制,会计期间分为年度和中期,中期,是指短于一个完整的会计年度的报告期间 货币计量 是指会计主体在进行会计确认,计量和报告时,采用货币作为计量单位,计量,记录会计主体的经营活动,反映会计主体的财务状况,经营成果和现金流量,在会计的确认,计量和报告过程中选择货币作为基础进行计量,是由货币本身的属性决定的,货币计量的假设必须以货币的稳定为前提,在币值稳定或相对稳定时,不同时点的资产价值才能具有可比性,不同时点的收入和费用才能进行比较、会计核算的信息才能及时地反映企业的经营状况,而如果币值发生很大的波动,货币计量成立的条件就会丧失。
饭店餐饮成本管理五法 饭店餐饮成本管理五法
是现代社会中必不可少的经济管理工作。随着市场经济竞争的日趋激烈,饭店企业要在竞争中立于不败之地,必须要强化成本管理。因为,在饭菜质量、服务质量相同的情况下,竞争最终体现的是价格的竞争,谁的成本低,就意味着谁可以在同行业价格上显出优势,去争取更多的用户和市场,从而获得更多的利润。
目前饭店大多数管理人员把大部分精力都用于餐饮经营上,对于餐饮成本的管理关注很少,一些饭店尽管顾客盈门,但由于餐饮成本高,企业收益却很低,有的甚至亏损,因此,强化饭店餐饮成本管理是当前饭店紧迫的一项主要工作。本文就如何加强饭店企业成本管理作如下探讨。
U8其他登陆总帐时提示“登陆失败”U8其他登陆总帐时提示“登陆失败”
U8其他-登陆总帐时提示“登陆失败”
自动编号: | 3063 | 产品版本: | U8其他 |
产品模块: | 其他 | 所属行业: | 通用 |
适用产品: | 852 | 关 键 字: | 登陆失败 |
问题名称: | 登陆总帐时提示“登陆失败” | ||
问题现象: | 登陆总帐时提示“登陆失败” | ||
原因分析: | 硬件问题 | ||
解决方案: | 把加密盒由前面的USB口换到后面的USB口问题解决,可能是前置USB口供电不足 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
- 年结的时候出现,本机已经运行【系统控制台程序】,请退出再运行
- 填制凭证类别时显示互斥站点
- 用友软件访问数据库是要通过SA来访问的,是否可以用其他的用户名
- 产成品入库单删除报错, 查询联查没有任何单据
- 更新了最新补丁提示微信结算方式与其他结算方式冲突是什么原因
- 版本号-12.100.001.0076.0514 票据类型无法记忆,设置单据中已经打开票据类型记忆功能,同客户无法实现记忆,升级到新版之后,出现的问题!
- 12.0普及版,盘点单保存报“计量单位2必须为空”。经检查是某个存货单计量,在盘点单带出了计量单位2,在别的单据不会带出单位2.怎么解决,有补丁解决么?
- 为啥客户端老是提示这个
- T3 卸载不了,怎么解决
- 我的标准版 安装包 按setup都是卸载的?卸了按第二次也是卸载 不能安装
在NC系统里能把帐表等导出成EXCEL格式的么?如何操作?在NC系统里能把帐表等导出成EXCEL格式的么?如何操作?用友系统中所有可以打印的地方,都可以作为EXCEL格式文件导出来。方法:把查询出来的“账页”等点打印,出来预览界面,在预览界面点“输出”或“EXCEL”,第一次输入文件名可以随意输,第二次要输入自己想要的文件名,文件名加.XLS,输出文件保存在桌面。
期初应付单在哪录入呢? 期初应付单在哪录入呢?
查询界面进入后点击增加@畅捷服务孙志强:点应付单,单据类型是其他应付单,单据上也是期初其他应付单@冯娜娜: 在您的第一个会计月没有结账前期初中录入的都是期初单据。@畅捷服务孙志强:启用月份当月录入,预付单这些都可以,但是应付单,单据类型是其他应付单@畅捷服务孙志强:@冯娜娜: 你在期初中录入的就是期初应单,你在应付单中录入的是本期的应付单@畅捷服务孙志强:期初应付单是不是录入的是采购发票不是,期初应付单录入的是一些供应商未付款,您的期初采购发票是为了和您的采购入库单进行结算的@畅捷服务孙志强:但是应付单点进去表头显示的是期初其他应付单@畅捷服务孙志强:单据类型只有其他应付单您要录入的不就是期初其他应付单吗@畅捷服务孙志强:我要录入的是期初应付账款使用期初其他应付单就可完成