【GoodERP实施笔记二】原始资料——用GoodERP替代用友U8普及版笔记二
in GoodERP with 0 comment

【GoodERP实施笔记二】原始资料——用GoodERP替代用友U8普及版笔记二

in GoodERP with 0 comment

如果还没部署可参考站内前文 :第一篇:GoodERP首测win2003server纯净+GoodERP20170302绿色版
部署后简体中文语言等参数配置:第二篇:部署GoodERP启动成功! 修改为默认简体中文语言
【GoodERP实施笔记一】 :Ubuntu14.04源码安装GoodERP最新版记录
GoodERP绿色版升级更新方法(含32位和64位):GoodERP绿色版升级更新
案例:用GoodERP替代用友U8普及版

上篇安装GoodERP运行环境:http://www.duuge.com/archives/gooderp-ubuntu14.html

本篇:收集整理

1、先从用友U8普及版入手,凭证的导出得到上海开阖-jeff的指点,发来链接:https://wenku.baidu.com/view/5c7f1dc605087632311212d5.html?qq-pf-to=pcqq.c2c
【凭证打印】->【输出】

2、本司使用了用友U8普及版含总账、固定资产、报表、供应链、应收款管理这些模块,供应链这里已有存货数据,出库入库有记录,订单无记录以后不会查询到。导出得到一个txt文档:1月凭证.txt,内容项目包括:

"F1日期F2类别","F3凭证号F4附单据数","F5摘要F6科目编码","F7借方F8贷方","F9数量F10外币","F11汇率","F12制单人","F13结算方式","F14票号","F15发生日期","F16部门编码","F17个人编码","F18客户编码","F19供应商编码","F20业务员","F21项目编码","F22自定义项1","F23自定义项2","F24自由项1","F25自由项2","F26自由项3","F27自由项4","F28自由项5","F29自由项6","F30自由项7","F31自由项8","F32自由项9","F33自由项10","F34外部系统标识","F35业务类型","F36单据类型","F37单据日期","F38单据号","F39凭证是否可改","F40分录是否可增删","F41合计金额是否保值","F42数值是否可改","F43科目是否可改","F44受控科目","F45往来是否可改","F46部门是否可改","F47项目是否可改","F48往来项是否必输","F49账套号","F50核算单位","F51会计年度","F52会计期间","F53类别顺序号","F54凭证号","F55审核人","F56记账人","F57是否记账","F58出纳人","F59行号","F60外币名称","F61单价","F62科目名称","F63部门名称","F64个人名称","F65客户简称","F66供应商简称","F67项目名称","F68项目大类编码","F69项目大类名称","F70对方科目","F71银行两清标志","F72往来两清标志","F73银行核销标志","F74外部系统名称","F75外部账套号","F76外部会计年度","F77外部会计期间","F78外部制单日期","F79外部系统版本","F80凭证标识","F81分录自动编号","F82唯一标识","F83主管签字","F84自由项11","F85自由项12","F86自由项13","F87自由项14","F88自由项15","F89自由项16"

3、导出【科目表.txt】内容如下:

"类型","级次","科目编码","科目名称","助记码","外币币种","计量单位","辅助账类型","账页格式","余额方向"

4、导出【供应商档案.txt】内容如下:

"序号","供应商编码","供应商名称","地区名称","发展日期","电话","联系人","专营业务员名称","分管部门名称"

5、导出【客户档案.txt】内容如下:

"序号","客户编码","客户名称","地区名称","发展日期","联系人","电话","专营业务员名称","分管部门名称"

6、导出【职员档案.txt】内容如下:

"序号","职员编码","职员名称","部门名称","职员属性","Email地址","手机号","信用额度","信用天数","信用等级"

7、导出【存货档案.txt】内容如下:

"序号","存货编码","存货名称","规格型号","税率","ABC分类","启用日期","计量单位组名称","主计量单位名称"

8、导出【期初余额.txt】内容如下:

内容保密。

另外,
再追加【2月凭证.txt】和【3月凭证.txt】导出来,并由开阖-财务囡囡帮忙审验之后,导入到GoodERP。

开阖-财务囡囡提问:广州三棉、广州三棉纺织品有限公司和广州三棉公司是一家公司吗? 

如果是一家公司的话,期初里面的广州三棉公司借方6039.5,客户里有广州三棉纺织品有限公司,那我就认为应收账款为6039.5,供应商里有广州三棉,应付账款为0,这样对吗?还有期初余额是2016年12月31日的吗?

三棉是供应商同时也是客户。
![33.png][6]
开阖-财务囡囡提出:
期初里面的应付账款都是供应商吧,但是在供应商里却找不到,比如鸿图彩印

开阖-Jeff王剑峰(85822082) 
数据质量问题比较大。一般ERP实施过程中历史数据整理要占整个实施工作量的1/4,辛苦囡姐了

财务提出:
应付账款的二级明细科目似乎不需要先录入供应商档案里
![4.png][7]
开阖-Jeff王剑峰(85822082) 
那这个软件太不严谨了

财务:
科目设置时要选择设置辅助核算才会受限于供应商档案
![5.png][8]
像应收账款有设置应该就没这个问题

三天后,

开阖-财务囡囡
能把2017年1月份的资产负债表和利润表发我一份吗?1月份的凭证已导入,我需要验证下是否正确。

七天后,

开阖-财务囡囡
所有的数据都已经可以导入了,我在先测试,所以没有按照顺序导入,现在测试的话会有一点儿小问题,我重新建个数据库然后备份在发给你。

2017年2月份的记账凭证只有46张吗?报表的金额对不上

备份的数据库已发到群530326001文件里,1月的报表是对的,2月因为少凭证所以不对

复制粘贴的水平很差,仅给自己留个笔记记录一下。

Responses