在外地设立的办事处(为销售方便),是否就得算是“设点经营”而去注册?若没注册,其租用固定场所所发生的费用(如物业、水电、房租等)收到发票(写公司名字)若是入账是否有问题? _0
2017-11-28 0:0:0 wondial在外地设立的办事处(为销售方便),是否就得算是“设点经营”而去注册?若没注册,其租用固定场所所发生的费用(如物业、水电、房租等)收到发票(写公司名字)若是入账是否有问题? _0
在外地设立的办事处(为销售方便),是否就得算是“设点经营”而去注册?若没注册,其租用固定场所所发生的费用(如物业、水电、房租等)收到发票(写公司名字)若是入账是否有问题?[]1?外地设立办事处不用办理工商登记
2?可以在本公司记账--那太好了,谢谢老师那怎么才是设点经营呢?
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- T3卸载就会跳到安装界面去,用360工具也卸载不了。请问这种情况哪位老师遇见过,我们应该如何处理。谢谢、在线等。2019-4-30 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-用友通标准版明细账选择月份的下拉框中没有1、2月份2019-4-23 8:0:0
- 用友T3-用友通标准版材料出库单上的自定义项点击后没反应2019-4-23 8:0:0
- 用友T3-用友通标准版登入用友T3软件,提示演示期限已过期,请插加密狗进行远程注册。2019-4-23 8:0:0
- 用友T3-用友通标准版登入系统管理,账套两个字是灰色2019-4-23 8:0:0
- 用友T3-用友通标准版登录固定资产模块失败2019-4-23 8:0:0
最新信息

用友通2005现存量整理后还是不对怎么办-通2005现存量整理后还是不对怎么办?
通2005-现存量整理后还是不对怎么办?
自动编号: | 6311 | 产品版本: | 通2005 |
产品模块: | 总账 | 所属行业: | 通用 |
适用产品: | 关 键 字: | 现存量整理有误 | |
问题名称: | 现存量整理后还是不对怎么办? | ||
问题现象: | 现存量整理后还是不对怎么办? | ||
原因分析: | 见问题答案 | ||
解决方案: | 执行如下脚本: SELECT * FROM sysobjects WHERE name = 'tempcurrentstock' DROP TABLE TempCurrentStock SELECT cWhCode, cInvCode, (CASE WHEN cFree1 = '' THEN NULL ELSE cFree1 END) AS cFree1, (CASE WHEN cFree2 = '' THEN NULL ELSE cFree2 END) AS cFree2, iainquantity AS iQuantity, CAST(0 AS FLOAT) AS fOutQuantity, CAST(0 AS FLOAT) AS fInQuantity INTO TempCurrentStock FROM ia_subsidiary WHERE cvoutype = '34' GROUP BY ia_subsidiary.cWhCode, ia_subsidiary.cInvCode, ia_subsidiary.cFree1, ia_subsidiary.cFree2, ia_subsidiary.iainquantity INSERT INTO TempCurrentStock (cWhCode, cInvCode, cFree1, cFree2, iQuantity) SELECT cWhCode, cInvCode, (CASE WHEN cFree1 = '' THEN NULL ELSE cFree1 END) AS cFree1, (CASE WHEN cFree2 = '' THEN NULL ELSE cFree2 END) AS cFree2, (CASE WHEN bRdFlag <> 0 THEN iQuantity ELSE - iQuantity END) AS iQuantity FROM RdRecord INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID WHERE cVouchType <> '33' AND cVouchType <> '34' AND RdRecord.dDate >= '2007-1-01' INSERT INTO TempCurrentStock (cWhCode, cInvCode, cFree1, cFree2, fOutQuantity) SELECT EnDispatchs.cWhCode, EnDispatchs.cInvCode, (CASE WHEN EnDispatchs.cFree1 = '' THEN NULL ELSE EnDispatchs.cFree1 END) AS cFree1, (CASE WHEN EnDispatchs.cFree2 = '' THEN NULL ELSE EnDispatchs.cFree2 END) AS cFree2, (ISNULL(iQuantity, 0) - ISNULL(fOutQuantity, 0)) AS fOutQuantity FROM EnDispatch INNER JOIN EnDispatchs ON EnDispatch.EDID = EnDispatchs.EDID WHERE ISNULL(EnDispatchs.cWhCode, '') <> '' AND ISNULL(EnDispatch.cSTCode, '') <> '' AND EnDispatchs.iQuantity > 0 AND bReturnFlag = 0 INSERT INTO TempCurrentStock (cWhCode, cInvCode, cFree1, cFree2, fOutQuantity) SELECT DispatchLists.cWhCode AS cWhCode, DispatchLists.cInvCode AS cInvCode, (CASE WHEN DispatchLists.cFree1 = '' THEN NULL ELSE DispatchLists.cFree1 END) AS cFree1, (CASE WHEN DispatchLists.cFree2 = '' THEN NULL ELSE DispatchLists.cFree2 END) AS cFree2, (ISNULL(iQuantity, 0) - ISNULL(fOutQuantity, 0)) AS fOutQuantity FROM DispatchLists INNER JOIN DispatchList ON DispatchLists.DLID = DispatchList.DLID WHERE DispatchList.cVouchType = '05' AND ISNULL(DispatchLists.cWhCode, '') <> '' AND ISNULL(DispatchList.cSTCode, '') <> '' AND (DispatchList.iSale = 0 OR DispatchList.iSale IS NULL) AND DispatchLists.iQuantity > 0 INSERT INTO TempCurrentStock (cWhCode, cInvCode, cFree1, cFree2, fOutQuantity) SELECT cWhCode, cInvCode, (CASE WHEN cFree1 = '' THEN NULL ELSE cFree1 END) AS cFree1, (CASE WHEN cFree2 = '' THEN NULL ELSE cFree2 END) AS cFree2, (ISNULL(iQuantity, 0) - ISNULL(fOutQuantity, 0)) AS fOutQuantity FROM SaleBillVouchs INNER JOIN SaleBillVouch ON SaleBillVouch.SBVID = SaleBillVouchs.SBVID WHERE ISNULL(SaleBillVouchs.cWhCode, '') <> '' AND (SaleBillVouch.iDisp = 0 OR SaleBillVouch.iDisp IS NULL) AND ISNULL(cBusType, '') <> '委托' AND ISNULL(cSTCode, '') <> '' AND ISNULL(cInvalider, '') = '' AND SaleBillVouchs.iQuantity > 0 INSERT INTO CurrentStock (cWhCode, cInvCode, cFree1, cFree2, iQuantity, fOutQuantity, fInQuantity) SELECT cWhCode, cInvCode, cFree1, cFree2, SUM(iQuantity) AS iQuantity, SUM(ISNULL(fOutQuantity, 0)) AS fOutQuantity, SUM(ISNULL(fInQuantity, 0)) AS fInQuantity FROM TempCurrentStock GROUP BY cWhCode, cInvCode, cFree1, cFree2 DELETE FROM CurrentStock WHERE (iQuantity IS NULL) AND (fOutQuantity = 0) AND (fInQuantity = 0) 温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |