ACCOUNTING ERP 的问题（痛苦中求问）
来源: fountaingrass 于 2011-06-17 14:21:27
我的帖子快被淹没了，只能再发一遍ACCOUNTING ERP，有童鞋去自费学ORACLE，SAP 的ERP吗，很多人据说都是工作中学的，但DILIMMA是没有ERP的经验怎么去找ERP的工作呢？有ERP经验的童鞋们你们都是在哪里学的？给些HINT， 还想问大家，学ORACLE 好还是SAP好？有ORACLE，SAP 是不是就有ACCOUNTING职业发展的空间，我指的是JOB SECURITY，JOB MARKET DEMAND，SALARY等。 望各位给与指教，谢谢。
---------------
回复：ACCOUNTING ERP 的问题（痛苦中求问）
来源: 美国老土 于 2011-06-17 14:48:50
-- Many ERP systems are being used in all sorts of business, for example, to get the cheaper one: google Open Source ERP, you will get many. For the large ERP system, you can find the top ten by click here: The top 10 ERP.
-- ERP means Enterprise Resource Planing, it contains many differnet packages and modules. The most popular is Finance package, it contains basic modules like AR, AP, GL, AM, no matter what kind of business the company do , they will always need Finance modules.
-- Depends on the business, the other packages are Supply Chain Mamagement, Manufacture, HR, CRM, BI etc.
-- Since the Financial package is the most popular one, as a Accounting expert you have advantage than other people who do not know what AR, AP, GL meant.
-- However, directly jump into EPR position is hard, because you do not have basic database skill.
-- No matter what kind of ERP the company use, Oracle, SAP, or Microsoft, or Open Source free ERP, there always be databases behind it, and always require you to know SQL language to put database into database and pull data out to generate the report, like daily report, weekly report, end of the month, end of the quater, end of year report, or, like trial balance report (which many people don't know what it means.)
-- Therefore, the first step toward ERP job is not about Oracle or SAP or Microsoft, its about do you know business concept (which you already knew) and database, do you know SQL?
-- Without Database foundamental skills, any ERP training will be rootless.
-- Get Database skill, find a Analyst job as the enter point, then find out what ERP system is being used in that company, then get familiar with it, then join the company paied training.
This is the best and shortest way to become a ERP professional.
Wish this answered your question.
Email me if you need more answers. I do teach ERP system modules. Therefore, I know GL, AR, AP, set of books and 3C. (Do you know 3C?)
You are in the right direction...
------------------------------
你的会计背景？目标职位？
来源: 醉里吴音 于 2011-06-17 18:55:43
如果你是AR AP General accountant的话，越大型的ERP，end user 界面应该越简单好用，不用去上什么ERP速成班，那种培训根本没意义，不太笨的人上班2周就培训得差不多了。
如果你想申请Analyst 以上职位，或者想在ERP 方面有发展，ERP的基础是数据库，我当年入行凭的是：
－ accounting degree & designation
－ MIS degree, database courses
如果你想懂多点，去上database 基础课程，和SQL。
如果你非要去上ERP课，去念SAP吧，SAP business process比较强，Oracle database比较强，很多SAP的后台还是Oracle。还要准备大笔银子，我上过几个 SAP课程，3天2千美金的价位，只cover非常小的一块内容，而且要照顾到课堂里一小半中年老会计，进程极度缓慢，上得我直打瞌睡。
要记得财务行业的根本还是designation，业内最牛的SAP functional consultant，都是有会计拍照的。
回复：你的会计背景？目标职位？
来源: fountaingrass 于 2011-06-17 19:10:09
谢谢吴音，你的建议非常实用，俺正在等分数的焦虑中，做好一颗红心两种准备，你说得database 基础课程是什么？
----------------------
比如SQL, 数据之间的关系..
来源: si*****io 于 2011-06-18 13:58:08
什么Inner join, outer join 之类的..table relationship.
-----------------------
没明白你所谓学是指什么，Hyperion 和SAP是最常见的
来源: Crystaldowns 于 2011-06-18 07:39:57
常见的两种Financial System，大公司一般都会用，上手也不难，有用过的经验会是你更Marketable。但是专门去学好像没有比要吧。
-------------------
看我答复你的有没有帮助
来源: si*****io 于 2011-06-18 14:11:24
Business analyst 一般是有会计背景(证书), 同时有工业经验(比如熟悉零售业, retail, or manufactory 制造业流程的..).
ERP, 目前大型的就是你说的SAP, ORACLE,
微软的就是Dyanmics AX. 数据库是SQL. 就是吴音说的database.确其中SQL 2008, 有目前最流行的SSRS, (report service).
进入ERP, 最大的问题, 是出差. functional consutlant, travel rate can be 80%-100%. Developer, travel rate can be 50%-70%.
除非你进入client公司, 像我这次找到的工作, 就是用户公司. 你就不用出差, 慢慢的干, 也没有人计算你的billable hour, 否则在咨询consulting firm 你是很辛苦的. 对女性有孩子要照顾的人不合适.
ERP 不难, 就是用多了就会了. 对我来说:) 你要不笨, 喜欢到处 click button, 到处看看, post 一下你的帐目, 从销售到应收款到总GL, 你走一遍就知道了..
做ERP 最大的好处, 就是将来工作的机会挺大的, 几乎像点样子的公司都用它. 所以你从data manager, 到warehouse manager, 有个CPA做controller, 好像都和ERP 有关. 我不做developer, 考考cpa, 估计我是最容易找工作的了, 因为我连系统背后的程序都做了, 对数据流程太熟悉.
总之, 你的学历背景, 应该将来挺容易杂找工作. 发现一个机会进入一个公司工作, 只要那个公司用了一套ERP, 你就上手了. 至于你以后学到多少, 看你自己花多少工夫了..
回复：ACCOUNTING ERP 的问题（痛苦中求问）
来源: vegelife 于 2011-06-18 21:12:50
It does not take long to learn AR, AP and GL modules in the ERP system. The most important is if you truely understand the accounting concepts. Many companies are willing to train the ones without ERP background and many people learn ERP in their jobs. Cost accounting is more complex. Manufacturing experience is always a plus.
Once you work in the ERP sytem, the next thing is how you learn. If you just want to do the data entry, it is easy.
If you want to understand accounting modules throughly, my recommendation is to read the ERP instructions, not just accounting department's but purchasing, receiving, QA, sales, shipping even planning and engineering's, etc. Try company's test data base if there is one. Accounging is the ERP end user. Many manufacturing transactions are transalated into accounting language. If you understand the accounting concepts, you can put them together.You will understand what I meant if you have the chance to be exposed to accounting set ups. No ERP system is perfect. You learn ERP in the practice.
You may use SQL and Hyperion to generat different reports. In some companies, the reports are done by the IT dept or experts. If not, you will learn SQL and Hyperion techniques and utilize your ERP knowledge to pull the data from the right table and spot.
No matter what, ERP system is just a tool. Don't be scared if you do not have the background. It makes your resume more impressive if you have some ERP training. Anyway, do not feel shy to show the employer you are a communicator, quick learner, team player, hard worker, a person they can trust....
Be confident and good luck!
