-
引子
最近在2016年保障性住房跟踪审计中,采集房管局租赁补贴财务数据,用的财务软件是用友T3,在AO2011中好像不能直接用模板导入(没一一尝试),于是在网上搜索有无相关的导入方法,在安徽省审计厅找到了相关文章:“用友财务软件T3标准版数据在AO2011中的采集方法”,于是照猫画虎,按照介绍方法学着导入上述数据,但在导入过程中还是和文章介绍的不一致,且该文章未对AO2011导入步骤做说明,所以我自己决定根据该帐套完善用友T3导入AO2011的导入方法。
-
准备
- 备份用友T3的财务数据库(SQLServer)。
-
提取
- 导入到AO只需要三张表:code(科目表)、GL_accsum(余额表)、GL_accvouch(凭证表);
- 科目表
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDEyMjQxMjgtMTk5MDg1NzQ2MS5wbmc%3D.png?w=700)
我们只需要科目代码(code)、科目名称(code_name)两个字段,SQL语句为:
SELECT ccode AS 科目代码 ,
ccode_name AS 科目名称
INTO 科目表
FROM code
- 余额表
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDEyNTcyMDYtOTE3MDQzMDE5LnBuZw%3D%3D.png?w=700)
SQL语句为:
SELECT ccode AS 科目代码 ,
iperiod AS 会计月份 ,
cbegind_c AS 年初余额借贷方向 ,
cendd_c AS 年末余额借贷方向 ,
mb AS 年初余额 ,
md AS 年末余额
INTO 余额表
FROM GL_accsum
- 凭证表
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE0MDg1NjYtMTA1MDg0MTY3My5wbmc%3D.png?w=700)
SELECT iperiod AS 会计月份 ,
cdigest AS 摘要 ,
dbill_date AS 会计日期 ,
ino_id AS 凭证号 ,
ccode AS 科目代码 ,
md AS 借方发生额 ,
mc AS 贷方发生额
INTO 凭证表
FROM GL_accvouch
-
导入
导入到AO2011采用财务软件数据库方式导入,如图:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE0MzgwODEtMTc5NTk5NjAzNC5wbmc%3D.png?w=700)
选择对应的数据库:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE0NDk0MjUtMTc4MzE2MjkyNC5wbmc%3D.png?w=700)
选择生成的三张表:“科目表、凭证表、余额表”。
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE1MDQ4NDctMjAyNDY4MDczMC5wbmc%3D.png?w=700)
导入完成后,新建会计数据:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE1MjQ1NjYtMTMzMzA4MTg2NC5wbmc%3D.png?w=700)
导入方式选择:“源数据凭证表为一个表”:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE1Mzg1MTktMjEwMzU0MDI1My5wbmc%3D.png?w=700)
选择辅助导入,保存,关闭:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE1NTQwNjYtMTU2MTcxNDYyOS5wbmc%3D.png?w=700)
选择“余额表”:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE2MDQ4NjMtMTYxMzQ2ODIyNS5wbmc%3D.png?w=700)
选择“分别存储余额和余额借贷方向”:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE2MTI1NTAtMTY5MjEyMDMxNC5wbmc%3D.png?w=700)
期初余额选择“年初余额”,余额借贷方向选择“年初余额借贷方向”,借方贷方对应选择“借、贷”:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE2MjQ5NDEtMTQ3NjY1NTExNi5wbmc%3D.png?w=700)
选择科目编码:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE2MzcyNjktMTQyMzQzNzYzOS5wbmc%3D.png?w=700)
选择余额按月存储:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE2NDQ3NTMtODM2NDQyNTAzLnBuZw%3D%3D.png?w=700)
导入成功
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE2NTMzMDAtODkwNzUxMzIucG5n.png?w=700)
选择会计科目表:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE3MDAwMTktMTcyNjAwOTQwMi5wbmc%3D.png?w=700)
选择科目编码:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE3MDY2OTEtNzAzMzM3MDMyLnBuZw%3D%3D.png?w=700)
选择科目名称:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE3NTEwMDMtMzY0NjM2MjQyLnBuZw%3D%3D.png?w=700)
导入会计科目成功
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4MDAzMDAtMTYwNTczNzgxNi5wbmc%3D.png?w=700)
科目设置-批量生产-验证-保存-关闭
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4MDY5ODgtMzI2MjczMDkwLnBuZw%3D%3D.png?w=700)
选择会计凭证表:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4MTQ1OTctMTMwNDYwMzk0Ni5wbmc%3D.png?w=700)
选择凭证日期
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4MTk4MDAtODA2MzQ1OTcwLnBuZw%3D%3D.png?w=700)
选择凭证号:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4MzI4NDctNzczNTUyMDAzLnBuZw%3D%3D.png?w=700)
选择“分别存储借方发生额和贷方发生额”
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4NDMyNTMtMjM0NDkyNzgyLnBuZw%3D%3D.png?w=700)
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE4NTI3MjItOTIwNDk4MTU3LnBuZw%3D%3D.png?w=700)
选择摘要和科目编码:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE5MDE0NTYtMTc1NzQ0NjgyOS5wbmc%3D.png?w=700)
选择凭证号:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE5MDgwMTktMTE0NjU3NDQzNi5wbmc%3D.png?w=700)
源凭证库分录序号选择自动生成
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE5MTI2NTktMTY1MTg2NzYzLnBuZw%3D%3D.png?w=700)
导入
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE5MjczMTYtMTM0MDE0NjQzOS5wbmc%3D.png?w=700)
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE5NDAwMzQtMTE2NzA1NDgyMS5wbmc%3D.png?w=700)
关闭生成财务数据临时表:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDE5NDY4NzgtMjM5MDg4Mjg2LnBuZw%3D%3D.png?w=700)
科目调整
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDIwMDAwOTctMTA3MTgyMTQ5NS5wbmc%3D.png?w=700)
右下角选择帐表重建
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDIwMDY4MzEtMTk0MzcyOTUwMi5wbmc%3D.png?w=700)
帐套重建完成
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvMTU4NzI4LzIwMTcxMi8xNTg3MjgtMjAxNzEyMDYxMDIwMTIyMzgtMTg0NjQ5MDkyLnBuZw%3D%3D.png?w=700)
导入完成。