用友T6企业管理软件数据权限控制
2019-4-23 8:0:0 用友T1小编用友t6企业管理软件数据权限控制
用友t6企业管理软件数据权限控制设置好‘凭证类别’和‘仓库’的数据权限后,在生成凭证和做业务单据时,还是能够使用无权限的凭证类别和仓库。启用‘凭证类别’和‘仓库’的数据权限后,还需要在‘总账’选项和供应链‘选项’中启用权限控制。进入‘总账’–‘设置’–‘选项’中,点击‘编辑’按钮,勾选‘制单权限控制到凭证类别’;在供应链模块中,例如库存模块,在‘库存管理’–‘初始设置’–‘选项’中,勾选‘检查仓库权限’。如有用友t6其它问题,请在下面回复疑问,我们将第一时间与您联系,帮助您解决问题。同时您也可以联系用友畅捷服务联盟
用友天龙瑞德。用友天龙瑞德专业销售用友软件,用友财务软件,寻找用友t6服务商,咨询用友t6价格,用友t6多少钱,用友t6报价,联系电话:010-59798025。网址:http://yun.kuaiji66.com用友云基地
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友T6企业管理软件库存期初数据2019-4-23 8:0:0
- 用友T6企业管理软件工资变动2019-4-23 8:0:0
- 用友T6企业管理软件成本中心名称手工录入不了2019-4-23 8:0:0
- 凭证如何反记账?2019-4-23 8:0:0
- 凭证输错,已记账,怎么恢复到审核前修改凭证?2019-4-23 8:0:0
- 已经记账,做错的凭证可以修改吗?2019-4-23 8:0:0
- 应收科目在没有勾客户辅助核算时录了期初余额.后来勾了客户辅助核算,做了凭证,现在想把应收期初删了,如何删-2019-4-23 8:0:0
- 总账凭证如何反结账反记账反审核,详细一点的,谢谢2019-4-23 8:0:0
- 总账与辅助帐对账不平怎么办收支科目都不平2019-4-23 8:0:0
- 总账与明细账不符,用总账对账不平工具检测了也没有查出来。2019-4-23 8:0:0
最新信息
应付款与总帐对帐不平 应付款与总帐对帐不平
问题号: | 9127 |
---|---|
解决状态: | 临时解决方案 |
软件版本: | 8.60sp |
软件模块: | 应付 |
行业: | 通用 |
关键字: | 日常操作 |
适用产品: | U860SP—-应付款管理 |
问题名称: | 应付款与总帐对帐不平 |
问题现象: | 应付款管理〉帐表管理〉业务帐表〉与总帐对帐,供应商hzzmhd,qdghhy应付票据总帐有400000的贷方发生额,应付系统没有,但实际上应付明细帐可以查询到相应的单据和凭证,为何在对帐时,应付系统不显示? |
问题原因: | 经检查,发现付款单在生成凭证的时候少生成了一条记录。因此导致与总帐对不平。 |
解决方案: | 执行下列语句,即可解决供应商hzzmhd,qdghhy对帐不平的现象。 另,该语句只能执行一遍,并请在执行之前做好数据备份。 INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,’49’,’49’,’2005042700188′,’2005-04-27′,’2005-04-27′,’HZZMHD’,NULL,NULL,NULL,0,’2111′,NULL,NULL,NULL,4,2,’付款单’,0.0,’人民币’,1.0,.0000,400000.0000,.0000,400000.0000,0.0,0.0,NULL,null,NULL,’49’,’AP492005042700188′,’AP0000000000200′,0,3,’49’,’2005042700188′,’AP’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,’转’,15,’2005-04-28′,NULL,NULL,NULL,NULL,NULL INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,’49’,’49’,’2005041500128′,’2005-04-15′ ,’2005-04-15′ ,’QDGFHY’,’01’,’YWZJH’,NULL,0,’2111′,NULL,NULL,NULL,4,2,’付248号凭证 支付货款’,0.0,’人民币’,1.0,.0000,200000.0000,.0000,200000.0000,0.0,0.0,NULL,null,NULL,’49’,’AP492005041500128′,’AP0000000000159′,0,3,’49’,’2005041500128′,’AP’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,’转’,11,’2005-04-28′,NULL,NULL,NULL,NULL,NULL INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,’49’,’49’,’2005042800189′,’2005-04-28′,’2005-04-28 ‘,’QDGFHY’,NULL,NULL,NULL,0,’2111′,NULL,NULL,NULL,4,2,’付款单’,0.0,’人民币’,1.0,.0000,200000.0000,.0000,200000.0000,0.0,0.0,NULL,null,NULL,’49’,’AP492005042800189′,’AP0000000000201′,0,3,’49’,’2005042800189′,’AP’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,’转’,16,’2005-04-28′,NULL,NULL,NULL,NULL,NULL |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |