6月份新成立的公司,要怎么建账?需要注意什么问题?7月份就要开始报税了吗?
2017-9-14 0:0:0 wondial6月份新成立的公司,要怎么建账?需要注意什么问题?7月份就要开始报税了吗?
6月份新成立的公司,要怎么建账?需要注意什么问题?7月份就要开始报税了吗?[]应该做了税务登记吧,应该建账,7月开始报税--是去税局报道吗?@左右77:是的,你去了吗--昨天刚拿回的营业执照,还没去呢
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 用友t3怎样取消审核2020-4-26 23:29:31
- 用友t6如何取消审核凭证2020-4-26 13:22:2
- t3现金流量表公式2019-4-23 8:0:0
- T3现金流量表2019-4-23 8:0:0
- T3现金流量2019-4-23 8:0:0
- t3如何取消审核2019-4-23 8:0:0
- t3取消审核凭证2019-4-23 8:0:0
- t3取消审核2019-4-23 8:0:0
- t3反结账反记账2019-4-23 8:0:0
- t3反结账到几个月前2019-4-23 8:0:0
最新信息
- 用友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 在用U821报表时,取当年的数是对的但是取上年度的数时是错的,且与总账余额表的数不相同。](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友U8 在用U821报表时,取当年的数是对的但是取上年度的数时是错的,且与总账余额表的数不相同。用友U8 在用U821报表时,取当年的数是对的但是取上年度的数时是错的,且与总账余额表的数不相同。
问题原因:程序问题 解决方法:请下载并安装U821总帐、UFO最新补丁,安装补丁前请做好数据备份如出现问题请联系当地服务商
解决方案:
问题原因:程序问题 解决方法:请下载并安装U821总帐、UFO最新补丁,安装补丁前请做好数据备份如出现问题请联系当地服务商
www.kuaiji66.com 天龙瑞德
![用友U8 销售系统发货结算勾对表查出有很多负数未结算,但在开销售发票时参照不到这些未结算的发货单。](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
用友U8 销售系统发货结算勾对表查出有很多负数未结算,但在开销售发票时参照不到这些未结算的发货单。用友U8 销售系统发货结算勾对表查出有很多负数未结算,但在开销售发票时参照不到这些未结算的发货单。
问题原因:发货结算勾对表错,当红字发货单(即退货单)已关闭时,在发货结算勾对表中还是显示未结算数量,而兰字发货单已关闭时则未结算数量为零,导致发货结算勾对表中有很多负数未结算,而开票时参照发货单时已关闭的发货单不显示,故两处显示结果不一致。 解决方法:修改存储过程SA_MoveOutIncome,在判断发货单是否已关闭的条件前加上abs,使判断条件考虑红、兰两种发货单后两处显示结果一致。存储过程SA_MoveOutIncome:/* 当有退补业务时发货结算勾对表查询无数据 江苏省药材公司 2003.06.27 当发货单关闭时发货结算勾对表未结数量为0 而当退货单关闭时发货结算勾对表未结数量为退货数量 江苏省中医药科技发展总公司 2003.07.18 南京用友维护部 丁德安*/IF EXISTS(SELECT * FROM sysobjects WHERE name='Sa_MoveOutIncome' and type='P')DROP PROCEDURE Sa_MoveOutIncomeGOCREATE PROCEDURE Sa_MoveOutIncome( -- 取得发货发货明细账存储过程 作者:刘小东 --@chrtable varchar(200) = null , --保存发货结算勾兑明细临时表--@chrWhere1 varchar(255) =null , --查询条件名称--@chrOutDate varchar(100) = null ,-- 发货日期 --@chrSaleDate varchar(100) = null, -- 开票日期 --@chrVouchType varchar(100) = null -- 单据类型 --) ASdeclare @chrSQL varchar(8000)declare @chrCost varchar(50)declare @chrWhere varchar(1000) declare @chrstartDate varchar(50)declare @chrstartDate1 varchar(50)declare @chrstartdate2 varchar(50)if ltrim(rtrim(@chrwhere1 )) = 'newReport_ParameterFromTempTable' begin --条件参数通过临时表传递 --set @chrwhere = (select name from tempdb..newReportParameter )end else --条件参数直接传递 --begin set @chrwhere = rtrim(ltrim(@chrwhere1))end -- 取销售系统启用日期 --set @chrStartDate = (select isnull(cValue,'1900-01-01') from accinformation where cSysid='Sa' and cName='dStartDate' ) if @chrstartdate <> '' begin if len(ltrim(rtrim(@chrstartdate))) <= 8 set @chrstartdate = convert(varchar(10),convert(smalldatetime,@chrstartdate,2),121) set @chrstartDate1 = ' Dispatchlist.dDate>=''' + @chrstartdate + ''''set @chrstartDate2 = ' and SalebillVouch.dDate>=''' + @chrstartdate + ''''end if exists(select * from tempdb..sysobjects where name ='po_DispatchFirst ') drop table tempdb..po_DispatchFirst print '发货'--取得发货单内容 -- --2003.06.27 增加两字段iTB,TBQuantityset @chrsql = 'Select Dispatchlist.DLID as DLID ,Dispatchlist.cDLCode AS cDLCode,Dispatchlist.cSTCode AS cSTCode ,Dispatchlist.ddate AS ddate ,Dispatchlist.cDepCode as cDepCode,Dispatchlist.cPersonCode as cPersonCode , Dispatchlist.cCusCode as cCusCode, Dispatchlist.iExchRate as iExchRate , Dispatchlist.bFirst as bFirst , Dispatchlist.cVerifier as cVerifier, Dispatchlist.cMaker as cMaker, Dispatchlists.iDlsid as iDlsid, Dispatchlists.cWhCode as cWHCode , Dispatchlists.cInvCode as cInvCode , Dispatchlists.iQuantity as iQuantity , Dispatchlists.iNum as iNum , Dispatchlists.iTaxUnitPrice as iTaxUnitPrice , Dispatchlists.iMoney as iMoney , Dispatchlists.iTax as iTax , Dispatchlists.iSum as iSum , Dispatchlists.iDisCount as iDisCount , Dispatchlists.iNatUnitPrice as iNatUnitPrice, Dispatchlists.iNatMoney as iNatMoney , Dispatchlists.iNatTax as iNatTax , Dispatchlists.iNatSum as iNatSum , Dispatchlists.iNatDisCount as iNatDisCount , Dispatchlists.cBatch as cBatch , Dispatchlists.cFree1 as cFree1, Dispatchlists.cFree2 as cFree2 , Dispatchlists.iTaxRate as iTaxRate , Dispatchlists.cDefine22 as cDefine22 , Dispatchlists.cDefine23 as cDefine23, Dispatchlists.cDefine24 as cDefine24, Dispatchlists.cDefine25 as cDefine25, Dispatchlists.cDefine26 as cDefine26 , Dispatchlists.cDefine27 as cDefine27 ,Dispatchlist.cVouchtype as cVouchtype,Dispatchlist.cDefine1 as cDefine1 , Dispatchlist.cDefine2 as cDefine2 ,Dispatchlist.cDefine3 as cDefine3 ,Dispatchlist.cDefine4 as cDefine4 ,Dispatchlist.cDefine5 as cDefine5 ,Dispatchlist.cDefine6 as cDefine6 ,Dispatchlist.cDefine7 as cDefine7 ,Dispatchlist.cDefine8 as cDefine8 ,Dispatchlist.cDefine9 as cDefine9 ,Dispatchlist.cDefine10 as cDefine10 ,Dispatchlists.bSettleall as bsettleall , Dispatchlists.iSettleQuantity as iSettleQuantity , Dispatchlists.iSettleNum as iSettlenum ,Dispatchlists.iTB as iTB ,Dispatchlists.TBQuantity as TBQuantity ,Dispatchlists.iUnitPrice INTO tempdb..po_DispatchFirst From Dispatchlists inner join Dispatchlist On DispatchLists.DLID = Dispatchlist.DLID WHERE ( Dispatchlist.bFirst=1 or ' + @chrstartdate1 + ' ) '--追加单据类型条件 if not (@chrVouchtype is null ) and ltrim(rtrim(@chrVouchType)) <> '' set @chrsql = @chrsql + ' and ' + @chrVouchtype if not (@chrOutDate is null ) and ltrim(rtrim(@chrOutDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrOutDate if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrWhere exec (@chrsql )--取得发票内容,发票按发货单子表ID汇总 --print '开票'if exists(select * from tempdb..sysobjects where name ='po_SaleBillFirst ') drop table tempdb..po_salebillfirst set @chrsql = 'Select SaleBillVouchs.iDLSID as iDLSID ,SaleBillVouchs.iQuantity as iQuantity , SaleBillVouchs.iNum as iNum , SaleBillVouchs.iMoney as iMoney , SaleBillVouchs.iSum as iSum , SaleBillVouchs.iTax as iTax , SaleBillVouchs.iNatMoney as iNatMoney , SaleBillVouchs.iNatSum as iNatSum , SaleBillVouchs.iNatTax as iNatTax INTO tempdb..po_SaleBillfirst From SaleBillVouchs inner join SaleBillVouch On SalebillVouchs.SBVID = SalebillVouch.SBVID inner join tempdb..po_dispatchfirst on tempdb..po_dispatchfirst.idlsid = Salebillvouchs.idlsidWhere Salebillvouchs.idlsid <> 0 and Salebillvouchs.idlsid is not null and isnull(Salebillvouch.cInvalider,'''')=''''and isnull(Salebillvouch.cSTCode,'''') <> '''' ' + @chrstartdate2 --作废发票不能计算在内,开票日期必须大于系统起用日期 --if not (@chrSaleDate is null ) and ltrim(rtrim(@chrSaleDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrSaleDate --不要其它条件 --if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrwhere exec( @chrsql )-- 发票内容按发货单子表ID号合计--if exists(select * from tempdb..sysobjects where name ='po_SaleBill') Drop Table tempdb..po_salebill Select iDlsid ,Sum( iQuantity ) as js_iQuantity,Sum( iNum) as js_iNum , Sum( iMoney ) as js_iMoney , Sum( iSum ) as js_iSum , Sum( iTax ) as js_iTax, Sum( iNatMoney ) as js_iNatMoney, Sum( iNatSum ) as js_iNatSum ,Sum( iNatTax ) as js_iNatTaxINTO tempdb..po_SaleBill from tempdb..po_salebillfirst Group by Idlsid if exists( select * from tempdb..sysobjects where name='po_DispSale')Drop table tempdb..po_DispSale -- 关联发货单和结算单 -- -- ye_iNatSum,ye_iNatTax 考虑退补问题 -- 2003.06.27 -- 退货单关闭时问题, -- case when a.bsettleall = 1 and ( a.iQuantity -a.iSettleQuantity ) > 0 then -- 改成 case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then -- 2003.07.18set @chrsql = 'Select a.DLID as DLID ,a.cDLCode AS cDLCode,a.cSTCode AS cSTCode ,a.ddate AS ddate ,a.cDepCode as cDepCode,a.cPersonCode as cPersonCode , a.cCusCode as cCusCode, a.iExchRate as iExchRate , a.bFirst as bFirst , a.cVerifier as cVerifier, a.cMaker as cMaker, a.cWhCode as cWHCode , a.cInvCode as cInvCode , a.iQuantity as iQuantity , a.iNum as iNum , a.iTaxUnitPrice as iTaxUnitPrice , a.iMoney as iMoney , a.iTax as iTax , a.iSum as iSum , a.iDisCount as iDisCount , a.iNatUnitPrice as iNatUnitPrice, a.iNatMoney as iNatMoney , a.iNatTax as iNatTax , a.iNatSum as iNatSum , a.iNatDisCount as iNatDisCount , a.cBatch as cBatch , a.cFree1 as cFree1, a.cFree2 as cFree2 , a.iTaxRate as iTaxRate , a.cDefine22 as cDefine22 , a.cDefine23 as cDefine23, a.cDefine24 as cDefine24, a.cDefine25 as cDefine25, a.cDefine26 as cDefine26 , a.cDefine27 as cDefine27 , a.cVouchtype as cVouchtype , tempdb..po_SaleBill.js_iQuantity as js_iQuantity,tempdb..po_SaleBill.js_iNum as js_iNum , tempdb..po_SaleBill.js_iMoney as js_iMoney , tempdb..po_SaleBill.js_iSum as js_iSum , tempdb..po_SaleBill.js_iTax as js_iTax, tempdb..po_SaleBill.js_iNatMoney as js_iNatMoney, tempdb..po_SaleBill.js_iNatSum as js_iNatSum ,tempdb..po_SaleBill.js_iNatTax as js_iNatTax ,case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)else a.iQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)end as ye_iQuantity,case when a.bSettleall =1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleNum - isnull(tempdb..po_salebill.js_inum,0)else a.iNum - isnull(tempdb..po_salebill.js_inum,0 )end as ye_iNum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then iUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iMoney,0 )else a.iMoney - isnull(tempdb..po_salebill.js_iMoney, 0 ) end as ye_iMoney , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iTaxUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_isum , 0 )else a.isum - isnull(tempdb..po_salebill.js_isum , 0 )end as ye_iSum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then ( a.iTaxUnitPrice - a.iUnitPrice) * a.iSettleQuantity - isnull (tempdb..po_salebill.js_itax, 0 )else a.iTax - isnull(tempdb..po_salebill.js_iTax,0 )end as ye_iTax, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iNatUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatMoney,0 )else a.iNatMoney - isnull(tempdb..po_salebill.js_iNatMoney,0)end as ye_iNatMoney, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then(a.iNatSum / a.TBQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )else(a.iNatSum / a.iQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )endelse a.iNatSum - isnull(tempdb..po_salebill.js_iNatSum,0 )end as ye_iNatSum ,case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then ((a.iNatSum - a.iNatMoney) / a.TBQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )else ((a.iNatSum - a.iNatMoney) / a.iQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )endelse a.iNatTax - isnull(tempdb..po_salebill.js_iNatTax, 0 )end as ye_iNatTax , a.cDefine1 ,a.cDefine2 ,a.cDefine3 ,a.cDefine4 ,a.cDefine5 ,a.cDefine6 ,a.cDefine7 ,a.cDefine8 ,a.cDefine9 ,a.cDefine10 into tempdb..po_DispSale from tempdb..po_dispatchfirst a left join tempdb..po_salebill On a.idlsid = tempdb..po_salebill.iDLSID ' exec (@chrsql )print '结果'-- 生成最终的明细账临时表 --if exists(select * from tempdb..sysobjects where name =@chrtable ) exec('drop table tempdb..' + @chrtable )set @chrsql = 'Select tempdb..po_DispSale.* , inventory.cInvName as cInvName , inventory.cInvStd as cInvStd , inventory.cInvM_Unit as cInvM_Unit , inventory.cinvCCode as cInvCCode , Customer.cCusName as cCusName , Customer.cCCCode as cCCCode , SaleType.cSTName as cSTName, Department.cDepName as cDepName , Person.cPersonName as cPersonname , WareHouse.cWHName as cWHName ,Customer.cCusAbbName as cCusAbbName ,Vouchtype.cVouchName as cVouchName into tempdb..'+ @chrtable + ' From tempdb..po_Dispsale left join inventory on tempdb..po_dispsale.cInvCode = inventory.cInvCode left join customer on tempdb..po_dispsale.cCusCode = Customer.cCusCode left join saletype on tempdb..po_dispsale.cSTCode = SaleType.cSTCode left join department on tempdb..po_dispsale.cDepCode = Department.cDepCode left join person on tempdb..po_dispsale.cPersonCode = person.cPersonCode left join warehouse on tempdb..po_dispsale.cWhCode = warehouse.cWhCodeleft join Vouchtype on tempdb..po_dispsale.cVouchtype = Vouchtype.cVouchtypeorder by tempdb..po_dispsale.ddate,tempdb..po_dispsale.dlid 'exec ( @chrsql )
解决方案:
问题原因:发货结算勾对表错,当红字发货单(即退货单)已关闭时,在发货结算勾对表中还是显示未结算数量,而兰字发货单已关闭时则未结算数量为零,导致发货结算勾对表中有很多负数未结算,而开票时参照发货单时已关闭的发货单不显示,故两处显示结果不一致。 解决方法:修改存储过程SA_MoveOutIncome,在判断发货单是否已关闭的条件前加上abs,使判断条件考虑红、兰两种发货单后两处显示结果一致。存储过程SA_MoveOutIncome:/* 当有退补业务时发货结算勾对表查询无数据 江苏省药材公司 2003.06.27 当发货单关闭时发货结算勾对表未结数量为0 而当退货单关闭时发货结算勾对表未结数量为退货数量 江苏省中医药科技发展总公司 2003.07.18 南京用友维护部 丁德安*/IF EXISTS(SELECT * FROM sysobjects WHERE name='Sa_MoveOutIncome' and type='P')DROP PROCEDURE Sa_MoveOutIncomeGOCREATE PROCEDURE Sa_MoveOutIncome( -- 取得发货发货明细账存储过程 作者:刘小东 --@chrtable varchar(200) = null , --保存发货结算勾兑明细临时表--@chrWhere1 varchar(255) =null , --查询条件名称--@chrOutDate varchar(100) = null ,-- 发货日期 --@chrSaleDate varchar(100) = null, -- 开票日期 --@chrVouchType varchar(100) = null -- 单据类型 --) ASdeclare @chrSQL varchar(8000)declare @chrCost varchar(50)declare @chrWhere varchar(1000) declare @chrstartDate varchar(50)declare @chrstartDate1 varchar(50)declare @chrstartdate2 varchar(50)if ltrim(rtrim(@chrwhere1 )) = 'newReport_ParameterFromTempTable' begin --条件参数通过临时表传递 --set @chrwhere = (select name from tempdb..newReportParameter )end else --条件参数直接传递 --begin set @chrwhere = rtrim(ltrim(@chrwhere1))end -- 取销售系统启用日期 --set @chrStartDate = (select isnull(cValue,'1900-01-01') from accinformation where cSysid='Sa' and cName='dStartDate' ) if @chrstartdate <> '' begin if len(ltrim(rtrim(@chrstartdate))) <= 8 set @chrstartdate = convert(varchar(10),convert(smalldatetime,@chrstartdate,2),121) set @chrstartDate1 = ' Dispatchlist.dDate>=''' + @chrstartdate + ''''set @chrstartDate2 = ' and SalebillVouch.dDate>=''' + @chrstartdate + ''''end if exists(select * from tempdb..sysobjects where name ='po_DispatchFirst ') drop table tempdb..po_DispatchFirst print '发货'--取得发货单内容 -- --2003.06.27 增加两字段iTB,TBQuantityset @chrsql = 'Select Dispatchlist.DLID as DLID ,Dispatchlist.cDLCode AS cDLCode,Dispatchlist.cSTCode AS cSTCode ,Dispatchlist.ddate AS ddate ,Dispatchlist.cDepCode as cDepCode,Dispatchlist.cPersonCode as cPersonCode , Dispatchlist.cCusCode as cCusCode, Dispatchlist.iExchRate as iExchRate , Dispatchlist.bFirst as bFirst , Dispatchlist.cVerifier as cVerifier, Dispatchlist.cMaker as cMaker, Dispatchlists.iDlsid as iDlsid, Dispatchlists.cWhCode as cWHCode , Dispatchlists.cInvCode as cInvCode , Dispatchlists.iQuantity as iQuantity , Dispatchlists.iNum as iNum , Dispatchlists.iTaxUnitPrice as iTaxUnitPrice , Dispatchlists.iMoney as iMoney , Dispatchlists.iTax as iTax , Dispatchlists.iSum as iSum , Dispatchlists.iDisCount as iDisCount , Dispatchlists.iNatUnitPrice as iNatUnitPrice, Dispatchlists.iNatMoney as iNatMoney , Dispatchlists.iNatTax as iNatTax , Dispatchlists.iNatSum as iNatSum , Dispatchlists.iNatDisCount as iNatDisCount , Dispatchlists.cBatch as cBatch , Dispatchlists.cFree1 as cFree1, Dispatchlists.cFree2 as cFree2 , Dispatchlists.iTaxRate as iTaxRate , Dispatchlists.cDefine22 as cDefine22 , Dispatchlists.cDefine23 as cDefine23, Dispatchlists.cDefine24 as cDefine24, Dispatchlists.cDefine25 as cDefine25, Dispatchlists.cDefine26 as cDefine26 , Dispatchlists.cDefine27 as cDefine27 ,Dispatchlist.cVouchtype as cVouchtype,Dispatchlist.cDefine1 as cDefine1 , Dispatchlist.cDefine2 as cDefine2 ,Dispatchlist.cDefine3 as cDefine3 ,Dispatchlist.cDefine4 as cDefine4 ,Dispatchlist.cDefine5 as cDefine5 ,Dispatchlist.cDefine6 as cDefine6 ,Dispatchlist.cDefine7 as cDefine7 ,Dispatchlist.cDefine8 as cDefine8 ,Dispatchlist.cDefine9 as cDefine9 ,Dispatchlist.cDefine10 as cDefine10 ,Dispatchlists.bSettleall as bsettleall , Dispatchlists.iSettleQuantity as iSettleQuantity , Dispatchlists.iSettleNum as iSettlenum ,Dispatchlists.iTB as iTB ,Dispatchlists.TBQuantity as TBQuantity ,Dispatchlists.iUnitPrice INTO tempdb..po_DispatchFirst From Dispatchlists inner join Dispatchlist On DispatchLists.DLID = Dispatchlist.DLID WHERE ( Dispatchlist.bFirst=1 or ' + @chrstartdate1 + ' ) '--追加单据类型条件 if not (@chrVouchtype is null ) and ltrim(rtrim(@chrVouchType)) <> '' set @chrsql = @chrsql + ' and ' + @chrVouchtype if not (@chrOutDate is null ) and ltrim(rtrim(@chrOutDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrOutDate if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrWhere exec (@chrsql )--取得发票内容,发票按发货单子表ID汇总 --print '开票'if exists(select * from tempdb..sysobjects where name ='po_SaleBillFirst ') drop table tempdb..po_salebillfirst set @chrsql = 'Select SaleBillVouchs.iDLSID as iDLSID ,SaleBillVouchs.iQuantity as iQuantity , SaleBillVouchs.iNum as iNum , SaleBillVouchs.iMoney as iMoney , SaleBillVouchs.iSum as iSum , SaleBillVouchs.iTax as iTax , SaleBillVouchs.iNatMoney as iNatMoney , SaleBillVouchs.iNatSum as iNatSum , SaleBillVouchs.iNatTax as iNatTax INTO tempdb..po_SaleBillfirst From SaleBillVouchs inner join SaleBillVouch On SalebillVouchs.SBVID = SalebillVouch.SBVID inner join tempdb..po_dispatchfirst on tempdb..po_dispatchfirst.idlsid = Salebillvouchs.idlsidWhere Salebillvouchs.idlsid <> 0 and Salebillvouchs.idlsid is not null and isnull(Salebillvouch.cInvalider,'''')=''''and isnull(Salebillvouch.cSTCode,'''') <> '''' ' + @chrstartdate2 --作废发票不能计算在内,开票日期必须大于系统起用日期 --if not (@chrSaleDate is null ) and ltrim(rtrim(@chrSaleDate)) <> '' set @chrsql = @chrsql + ' and ' + @chrSaleDate --不要其它条件 --if not (@chrwhere is null ) and ltrim(rtrim(@chrwhere)) <> '' set @chrsql = @chrsql + ' and ' + @chrwhere exec( @chrsql )-- 发票内容按发货单子表ID号合计--if exists(select * from tempdb..sysobjects where name ='po_SaleBill') Drop Table tempdb..po_salebill Select iDlsid ,Sum( iQuantity ) as js_iQuantity,Sum( iNum) as js_iNum , Sum( iMoney ) as js_iMoney , Sum( iSum ) as js_iSum , Sum( iTax ) as js_iTax, Sum( iNatMoney ) as js_iNatMoney, Sum( iNatSum ) as js_iNatSum ,Sum( iNatTax ) as js_iNatTaxINTO tempdb..po_SaleBill from tempdb..po_salebillfirst Group by Idlsid if exists( select * from tempdb..sysobjects where name='po_DispSale')Drop table tempdb..po_DispSale -- 关联发货单和结算单 -- -- ye_iNatSum,ye_iNatTax 考虑退补问题 -- 2003.06.27 -- 退货单关闭时问题, -- case when a.bsettleall = 1 and ( a.iQuantity -a.iSettleQuantity ) > 0 then -- 改成 case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then -- 2003.07.18set @chrsql = 'Select a.DLID as DLID ,a.cDLCode AS cDLCode,a.cSTCode AS cSTCode ,a.ddate AS ddate ,a.cDepCode as cDepCode,a.cPersonCode as cPersonCode , a.cCusCode as cCusCode, a.iExchRate as iExchRate , a.bFirst as bFirst , a.cVerifier as cVerifier, a.cMaker as cMaker, a.cWhCode as cWHCode , a.cInvCode as cInvCode , a.iQuantity as iQuantity , a.iNum as iNum , a.iTaxUnitPrice as iTaxUnitPrice , a.iMoney as iMoney , a.iTax as iTax , a.iSum as iSum , a.iDisCount as iDisCount , a.iNatUnitPrice as iNatUnitPrice, a.iNatMoney as iNatMoney , a.iNatTax as iNatTax , a.iNatSum as iNatSum , a.iNatDisCount as iNatDisCount , a.cBatch as cBatch , a.cFree1 as cFree1, a.cFree2 as cFree2 , a.iTaxRate as iTaxRate , a.cDefine22 as cDefine22 , a.cDefine23 as cDefine23, a.cDefine24 as cDefine24, a.cDefine25 as cDefine25, a.cDefine26 as cDefine26 , a.cDefine27 as cDefine27 , a.cVouchtype as cVouchtype , tempdb..po_SaleBill.js_iQuantity as js_iQuantity,tempdb..po_SaleBill.js_iNum as js_iNum , tempdb..po_SaleBill.js_iMoney as js_iMoney , tempdb..po_SaleBill.js_iSum as js_iSum , tempdb..po_SaleBill.js_iTax as js_iTax, tempdb..po_SaleBill.js_iNatMoney as js_iNatMoney, tempdb..po_SaleBill.js_iNatSum as js_iNatSum ,tempdb..po_SaleBill.js_iNatTax as js_iNatTax ,case when a.bsettleall = 1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)else a.iQuantity - isnull(tempdb..po_salebill.js_iQuantity,0)end as ye_iQuantity,case when a.bSettleall =1 and abs( a.iQuantity -a.iSettleQuantity ) > 0 then a.iSettleNum - isnull(tempdb..po_salebill.js_inum,0)else a.iNum - isnull(tempdb..po_salebill.js_inum,0 )end as ye_iNum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then iUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iMoney,0 )else a.iMoney - isnull(tempdb..po_salebill.js_iMoney, 0 ) end as ye_iMoney , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iTaxUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_isum , 0 )else a.isum - isnull(tempdb..po_salebill.js_isum , 0 )end as ye_iSum , case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then ( a.iTaxUnitPrice - a.iUnitPrice) * a.iSettleQuantity - isnull (tempdb..po_salebill.js_itax, 0 )else a.iTax - isnull(tempdb..po_salebill.js_iTax,0 )end as ye_iTax, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then a.iNatUnitPrice * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatMoney,0 )else a.iNatMoney - isnull(tempdb..po_salebill.js_iNatMoney,0)end as ye_iNatMoney, case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then(a.iNatSum / a.TBQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )else(a.iNatSum / a.iQuantity) * a.iSettleQuantity - isnull( tempdb..po_salebill.js_iNatSum,0 )endelse a.iNatSum - isnull(tempdb..po_salebill.js_iNatSum,0 )end as ye_iNatSum ,case when a.bSettleall =1 and abs( a.iQuantity - a.iSettleQuantity ) > 0 then case when a.iTB=1 then ((a.iNatSum - a.iNatMoney) / a.TBQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )else ((a.iNatSum - a.iNatMoney) / a.iQuantity) * a.iSettleQuantity - isnull(tempdb..po_salebill.js_iNatTax, 0 )endelse a.iNatTax - isnull(tempdb..po_salebill.js_iNatTax, 0 )end as ye_iNatTax , a.cDefine1 ,a.cDefine2 ,a.cDefine3 ,a.cDefine4 ,a.cDefine5 ,a.cDefine6 ,a.cDefine7 ,a.cDefine8 ,a.cDefine9 ,a.cDefine10 into tempdb..po_DispSale from tempdb..po_dispatchfirst a left join tempdb..po_salebill On a.idlsid = tempdb..po_salebill.iDLSID ' exec (@chrsql )print '结果'-- 生成最终的明细账临时表 --if exists(select * from tempdb..sysobjects where name =@chrtable ) exec('drop table tempdb..' + @chrtable )set @chrsql = 'Select tempdb..po_DispSale.* , inventory.cInvName as cInvName , inventory.cInvStd as cInvStd , inventory.cInvM_Unit as cInvM_Unit , inventory.cinvCCode as cInvCCode , Customer.cCusName as cCusName , Customer.cCCCode as cCCCode , SaleType.cSTName as cSTName, Department.cDepName as cDepName , Person.cPersonName as cPersonname , WareHouse.cWHName as cWHName ,Customer.cCusAbbName as cCusAbbName ,Vouchtype.cVouchName as cVouchName into tempdb..'+ @chrtable + ' From tempdb..po_Dispsale left join inventory on tempdb..po_dispsale.cInvCode = inventory.cInvCode left join customer on tempdb..po_dispsale.cCusCode = Customer.cCusCode left join saletype on tempdb..po_dispsale.cSTCode = SaleType.cSTCode left join department on tempdb..po_dispsale.cDepCode = Department.cDepCode left join person on tempdb..po_dispsale.cPersonCode = person.cPersonCode left join warehouse on tempdb..po_dispsale.cWhCode = warehouse.cWhCodeleft join Vouchtype on tempdb..po_dispsale.cVouchtype = Vouchtype.cVouchtypeorder by tempdb..po_dispsale.ddate,tempdb..po_dispsale.dlid 'exec ( @chrsql )
![其他应收应付单制单,非受控应收应付的科目辅助核算信息不能从单据中带入](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
其他应收应付单制单,非受控应收应付的科目辅助核算信息不能从单据中带入 其他应收应付单制单,非受控应收应付的科目辅助核算信息不能从单据中带入
问题号: | 3461 |
---|---|
解决状态: | 最终解决方案 |
软件版本: | 8.51A |
软件模块: | 应收 |
行业: | 通用 |
关键字: | 科目辅助核算信息不能从单据中带入,补丁解决 |
适用产品: | U851A |
问题名称: | 其他应收应付单制单,非受控应收应付的科目辅助核算信息不能从单据中带入 |
问题现象: | 其他应收应付单制单时,非受控应收应付的科目其客户、供应商辅助核算信息不能从单据中带入。 |
问题原因: | 程序问题 |
解决方案: | 补丁解决 |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
- 用友t3怎样取消审核
- 用友t6如何取消审核凭证
- 请问下,我建账选择的是小企业会计准则(2013年)行业性质,但是为什么在会计科目那里显示的都是小企业会计制度的会计科目?
- 前台收银程序T+pos启动后,提示数据库错误,编号11,绑定数据库错误。如何处理啊?
- 老师请问:怎么样才能把不能够按照默认供货商为单位来查询诸如销量、库存等等各类参数的问题反馈给开发团队??我们超市这单是和各个供货商对接库存和销售量都快疯了。这样一个带前端销售的软件怎么会这个基本的功能都没有……还需要做什么自定义项那么麻烦
- 请问t3标准版为什么从系统卸载不掉,请问怎么才能卸载掉?
- 为什么卸载的时候提示这个??
- 请问这是怎么一回事,老是说登录不上服务器,防火墙都已经关闭了,提示下面这种
- T3卸载不了提示这个是什么意思?
- 我用的是用友T3普及版 ,现在我点击注册登录时输入密码之后没有账套出来,我确定密码和用户名都是对的!还有点击系统管理的时候电脑没有反应,打不开系统管理!这个是什么原因呢?
![房地产企业没有收入年度广告费如何处理](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
房地产企业没有收入年度广告费如何处理 房地产企业没有收入年度广告费如何处理
问题内容:新办开发企业未取得开发产品实际销售收入年度发生的,与建造、销售开发产品相关的广告费执行国税发[2006]31号,而有收入年度的广告费执行国税发[2001]89号,对吗?
答复:在结转年度期限上,你的理解是对的。但销售收入的确认应按照国税发[2006]31号文执行,即在预售收入转为实际收入时,再将其作为税前扣除的计算依据。
![发票在应收信用报警查询中显示不出来](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
发票在应收信用报警查询中显示不出来 发票在应收信用报警查询中显示不出来
问题号: | 11167 |
---|---|
解决状态: | 最终解决方案 |
软件版本: | 8.61 |
软件模块: | 应收 |
行业: | 通用 |
关键字: | 信用报警 |
适用产品: | U861–财务会计–应收款管理 |
问题名称: | 发票在应收信用报警查询中显示不出来 |
问题现象: | 销售发票传到应收后,在发票未审核的状态下,从信用报警查询中显示不出来,但过滤条件有包含未审核的单据。 |
问题原因: | 销售发票未复核。 |
解决方案: | 销售发票复核即可。 |
补丁编号: | |
录入日期: | 2016-03-16 15:23:45 |
最后更新时间: |
![抵押土地使用权需要缴税](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
抵押土地使用权需要缴税 抵押土地使用权需要缴税
问:我公司用土地使用权抵押给银行而取得贷款,现无力偿还贷款,银行将该土地抵债,并将该土地出租使用。由于种种原因我公司至今仍未办理土地使用权属变更手续,请问需要纳税吗?
答:你公司应按规定缴纳营业、土地增值税等相关税费。根据规定,土地使用者转让、抵押或置换土地,无论其是否取得了该土地的使用权属证书,无论其在转让、抵押或置换土地过程中是否与对方当事人办理了土地使用权属证书变更登记手续,只要土地使用者享有占有、使用、收益或处分该土地的权利,且有合同等证据表明其实质转让、抵押或置换了土地并取得了相应的经济利益,土地使用者及其对方当事人应当依照税法规定缴纳营业税、土地增值税等相关税收。
- 年结的时候出现,本机已经运行【系统控制台程序】,请退出再运行
- 填制凭证类别时显示互斥站点
- 用友软件访问数据库是要通过SA来访问的,是否可以用其他的用户名
- 12.0普及版,盘点单保存报“计量单位2必须为空”。经检查是某个存货单计量,在盘点单带出了计量单位2,在别的单据不会带出单位2.怎么解决,有补丁解决么?
- 版本号-12.100.001.0076.0514 票据类型无法记忆,设置单据中已经打开票据类型记忆功能,同客户无法实现记忆,升级到新版之后,出现的问题!
- 产成品入库单删除报错, 查询联查没有任何单据
- 更新了最新补丁提示微信结算方式与其他结算方式冲突是什么原因
- 为啥客户端老是提示这个
- T3 卸载不了,怎么解决
- 安装T3后没有服务启动项,点击卸载就又是安装,安装时没有任何报错,请问是什么原因造成的,怎么解决
![你好请问下T1新安装后没有备份如何恢复物理文件?](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
你好请问下T1新安装后没有备份如何恢复物理文件? 你好请问下T1新安装后没有备份如何恢复物理文件?[]
在新电脑上安装数据库和软件,然后通过原安装路径下服务器下data里面的ldf和mdf文件恢复数据
具体操作方法:新建一个同名账套,停止数据库服务,将元安装路径下的ldf和mdf文件拷贝覆盖现在安装路径下的ldf和mdf,再开启数据库服务,打开软件操作。
物理数据恢复可以参考知识库的恢复方法:
http://service.chanjet.com/zhi ... b45e3用数据库源文件附加
![利润表中“本期金额”与“上期金额”的填列](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
利润表中“本期金额”与“上期金额”的填列 利润表中“本期金额”与“上期金额”的填列
经常有网友向我提出利润表中的“本期金额”与“上期金额”到底如何填列,新颁布以前利润表的栏目是“本期数”与“本年累计数”,而新准则颁布后,《企业会计准则——应用指南》中指出,“利润表”格式中给出了“本期金额”和“上期金额”两栏,但没有对“本期”和“上期”的所属期间作出解释。在实际执行过程中,有务机关要求企业按《指南》给出的“本期金额”和“上期金额”填报利润表,但对所属期间同样没有做出明确规定或规定不一致。“本期金额”有填年初至本月末累计数的,有填本月数的,也有填本季数的;“上期金额”有填上年初至上年同期月未累计数的,有填本年上月数的,有填本年上季数的,也有填上年同月数的。企业按各自理解的期间填报的利润表各级机关都予以受理,广大会计人员感到困惑。目前这种困惑局面也可从互联网上众多会计人员的提问和不同的答复中得到证明。利润表“本期金额”和“上期金额”栏所属期间的理解和填报不统一,严重影响了宏观统计部门的统计数字质量,扭曲宏观经济指标,干扰宏观经济决策,所属期间必须明确统一。
![T+12.1的凭证打印,怎么设置默认的模板,我在打印模板里面另存为一份之后,为什么预览里面还要重新选择,直接打印也不行呢?](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
T+12.1的凭证打印,怎么设置默认的模板,我在打印模板里面另存为一份之后,为什么预览里面还要重新选择,直接打印也不行呢? T+12.1的凭证打印,怎么设置默认的模板,我在打印模板里面另存为一份之后,为什么预览里面还要重新选择,直接打印也不行呢?[]
选择新模版,打印一次,就记忆了,这功能比较坑尤其是打印存货条码的时候。。。。。@qq332055283:啊,自己也不能选择打印机了是吧?您好,设置好模板以后,第一次打印以后就会记忆,以后就变成默认。可以选择打印机的,选则模版打印后下次记住上次打印设置@鸣人服务陈媛:打印页面 左边有选择打印机,下拉选择@畅捷服务苏文强 苏老师,12.1条码打印感觉好繁琐,没次都得去预览打印才行@董江川:是的,打印组件跟之前不同的了,格式有些变化。@畅捷服务苏文强:那发票版的打印凭证纸,在打印机应该选择什么纸型@鸣人服务陈媛:您好,打印凭证有发票版打印模板,具体要看客户的纸型和针式打印还是激光打印。
![我在10.3人事通的薪资管理中,给一个人员在停发。怎么不能做停发了呢。](https://www.kuaiji66.com/nc/zb_users/plugin/MiniTu/noimg.png)
我在10.3人事通的薪资管理中,给一个人员在停发。怎么不能做停发了呢。 我在10.3人事通的薪资管理中,给一个人员在停发。怎么不能做停发了呢。[]
您说的不能停发是有什么提示还是什么情况呢?@服务社区刘小艳:选择一个人员做停发,这个功能不能正常使用@宗盈YRV:您是在薪资档案中,选择人员点击薪资状态下的处理操作的吗?@服务社区刘小艳:是的,点击处理后没有反应@宗盈YRV:那您到社区—产品更新中下载人事通的补丁更新下看。这种情况是由于什么原因造成的,客户对这个很关心,需要一个解释@宗盈YRV:这个没有具体提示也判断不了具体原因,您先更新补丁看下能否正常。能确定打补丁就可以解决这个问题吗,要是不能是不是把账套发给你们测试一下。@宗盈YRV:因为这边没有出现这样得情况,只能建议先更新下补丁,您可以到其他账套查看下是否也这样,如果都这样发送账套是没有用的。请先备份账套更新下补丁。或者您可以尝试下把电脑的杀毒软件关闭再看下。好的,我先试试