Peoples
Blog moved to:
http://www.solbiztech.com.pk/
Mohsin Yaseen
I am working as OpenERP Functional & Technical Analyst in IMSciences. I have done MSc in Computer Science from Peshawar University. I have completed a couple of projects of ERP, Custom Solutions and Mobile Apps in the domain of Campus Management System, Hospital Information System, Finance, Inventory, Project Management, Survey, Criminal Information System and Police Information System.
Gmail: myasinr@gmail.com
Skype: myasinr
Call: +923349069919
Hafiz Bilal
He is the Student of BCS in IMSciences, Pakistan. I found him a best guy in problem solving, love to learn new things with proper guidelines, energetic, strong grip on CS subjects and hardworking. Now a days he is working in OpenERP with me in functional and technical areas. In future he will be a good resource of OpenERP. InshaAllah.
Gmail: hafizbilal726@gmail.com
Mohsin Blog 
Hi Moshin:
My name is Diego Guzman and live in Cali, Colombia, South America. I have a question for you and I hope you can help me:
I have to do the periodical inventory in OpenERP and when confirm the inventory, the system makes the following account move:
1)If there’s more qty then debt to the location’s account and credt to the product’s stock input account.
2)If there’s less qty then debt to the product’s stock output account and credt to the location’s account.
In my country, these account moves are wrong because 1) is considered a profit and 2) a loss.
The question is: How can I change that behavior in order to obtain the correct account moves ?
Best regards
DG
sorry for late reply,
brother can u tell me which one module u have installed for ur current requirement openerp . so that i can figure out ur problem. if openerp behaves wrongly then i will correct the entry style in coding and resend u the module.
and if plz u explain ur problem with example like http://ccba.jsu.edu/accounting/PERPETUALPERIODICJE.HTML then its much better to understand ur problem and debug ur problem
Hello Mohsin,
Can you please explain me the process of bank reconciliation in openERP. Would like to know the step by step procedure of bank reconciliation.
Best regards,
KD
Pls help me
@KD First of all i will clear you that openerp doesn’t support bank reconciliation.
openerp supports bank statement entry using single form, for example, at the end of the month you received bank statement from ABC Bank of company xyz. OpenERP allows you to enter your whole monthly accounting transactions (occurred in bank statement) using single form rather then entering the per day transaction on daily basis.
let me give another example 2.
customer A: buy machine stock from your shop.
step 1
customer invoice made an accounting transaction like stock -> credit and Acc Receivable –> Debit.
step 2
now you received a check from customer A, you should have to record this transaction like bank acc –> debit and Acc Receivable –> credit on the same date when you received check.
note: to enter the Bank receive voucher as per step 2, there are two steps in openerp. a) enter the bank receive voucher using ‘Entries Encoding by Move’. b) when bank statement comes at the end of the month, you will enter whole months bank accounting entries like step 2 (bank payment and bank receive vouchers) using ‘Entries By Statements’. While using the 2nd approach of entering voucher will not required to enter Bank vouchers on daily basis, its support whole monthly accounting entries (payment and receipt) at one step using ‘Entries By Statements’.
openerp supports your invoices and its reconciliation to its payment and receipt vouchers. Actually not support bank reconciliation.
If you order then I will explain the ”Entries By Statements” method of entering voucher.
You can also confirm my wording from http://doc.openerp.com/book/3/3_7/accounting_entries.html
Thank you sir
Sir I have one more doubt. Is it necessary to have the RECONCILE feild checked for Sundry Debtors and Creditors?
If i am not activating the reconcile feild then can my bank reconciliation process run smoothly?
@KD welcome
brother i start an example for you in form of series of tutorials.
first tutorial in this regard is below.
In this preceding tutorial introduce how to create partner (customers and suppliers), products, chart of account, their invoices and reporting.
in next tutorials, i will show whats different ways of payment and receipt are available in openerp and reconciliation of invoices and its accounting vouchers.
in this i will include the entires encoding by move, entries by statement and direct payment & receipt from invoices forms with supported reconciliation.
soon
Hello Sir,
Thank you for your explanation. I went through your tutorial. I am clear with creation of accounts,partners,products and invoices. Now please explain me the various methods for making payments and receipts of invoices and also explain bank reconciliation in openerp.
Best regards
KD
Invoices payment and its reconciliation in openerp https://mohsinpage.wordpress.com/2010/11/10/invoices-customer-and-supplier-accounting-vouchers-and-its-reconciliation-in-openerp/ soon i will introduce these three methods individually one by one.
Hi Mohsin
i want to implement Openerp in my company can u support me.
my contact no is +923002571702.
@kashif why not brother.
first identify the modules involve in your company, than customize each module if available else need to develop from scratch.
module identification in your company involve deep analysis of your company.
i can help u in customizing the modules.
actually each module customization required that module functional consultant. but if you know each module (financial, hrm, stock etc), then you can also work as functional consultant.
most welcome any time
Please please tell me how to deal with company contributions (Provident Fund, ESIC) via hr_payroll module in open ERP.
@KD
provident fund in openerp
enjoy
Thank you sir for explaining the provident fund process. Can you please define the meaning of various internal types in OpenERP version 6. It would be great to get some explanation from you.
@KD brother are you asking the inter type of account like payable, receivable or other etc
or you asking about some thing else.plz explain
thanks
Actually i wanted to know the meaning of various internal types while creation of general accounts. For example Payable, Receivable, Regular, Liquidity, View. they relate to which type of general accounts?
@KD your answer is already available at http://www.openerp.com/forum/topic12416.html
still is there any confusion;
Payable: companies those account that will treated as liability to company. like salary payable, accrued payable, income tax payable, partner paybale etc
Receivable: companies those account that will treated as asset. like income receivable, interest receivable, partner receivable etc
Others: those account, that not lies in the category of either payable or receivable will be set a others account. like cash, bank, asset, expenses etc
closed: any account, that a company doesn’t want to used in future, will be set as closed.
Consolidated: e.g. if you want that a company four bank accounts balances show in single account, than create single account having type of consolidated and name say ‘Consolidated balances of bank’. simple means used to merged the accounts in single account.
view: its just used for classification.
Sir i have already gone through this link long back. I am a bit confused with the internal types in OpenERP version 6. When is ‘Regular’ internal type applicable?
@KD
don’t b confuse brother, its very simple, in version 5.0.11 ‘other’ internal type is replaced with ‘regular’ in ver 6.
and type ‘Liquidity’ in ver 6 introduced; for bank account, petty cash account or any account whose liquidity (less than a year) is just same bank accounts.
ok now
Can you pls clear my one more query. In Indian Chart of Accounts why is Misc. Expenses(Asset), Capital Account, Reserve and Profit /Loss Account related to ‘Regular’? Earlier they were related to receivables and payables as their internal type.
@KD its a simple accounting concept brother.
Receivable are those account, that a company need to receive from outside entities of company.
Similarly Payable are those accounts, that a company need to pay to outside entities of company.
expense, reserve account, capital account, profit/loss account etc these all are not related to neither receivable nor payable.
so these account will set as other (in ver 5.0.11) or Regular (in ver 6)
No Mohsin. Earlier those were related to Receivable and Payable and not with Other. Then why Regular is linked with them in indian chart of accounts version 6.That point is clear that ‘other’ name got changed to ‘regular’.
@KD ok i got your point. don’t confuse
let me give an example, capital; is the investment by the owner and this amount is liability of company to owner. some people used capital as ‘payable’ as well as ‘other’ in openerp. its depend upon you, how u classified your company chart of account’s internal types.
i think you got it now.
if you use capital as ‘payable’ or ‘other’ both are write.
ok
Yes. Now it’s clear. thank you Mohsin. You explain very nicely. acha tell me one more thing. From where do we link general accounts in Human Resources→ Payroll. Earlier(in ver 5) via employees, accounts could be linked (through Accounting Information Tab). But in ver 6 we have two separate modules for payroll. Can you kindly explain me the process of linking general accounts in payroll part(where accounting is integrated with payroll)
@KD welcome
in ver 5 payroll includes two functionalities. first simple payroll second the integration of payroll with accounts.
in ver 6 they are separate modules
simple payroll=hr_pyroll
payroll integration with accounts = hr_payroll_account.
remember hr_payroll_account (ver 6) depends on hr_payroll (ver 6)
Pls help me. I am getting some application error while approving payslip. how to fix this error?
@KD application error, is this the type of error or title of error.
brother can u explain the error details, or if u can share the snap.
also if possible, plz ask question at this below post, so that other friends also can contribute. thanks
after clicking ‘approve sheet’ the following error comes.
An Application Error has been reported
Let me fix it
Fix it for me
One more thing. In version 5 there was an option named ‘Include in salary’ under contribution configuration in Allowances/Deduction under Human Resources—>Configuration—>Payroll. In version 6 that option is missing. can you tell me where that function is?
@KD in ver 6 Human Resources -> Configuration -> Payroll -> Salary Heads (New Head)
here you can find the contribution from company.
where is the ‘encoding by line’ part in version 6? can you pls help me. i want to post general entries.
@KD
in ver 6:
Accounting -> Journal Entries -> Journal Items.
in ver 5:
Financial Management -> Entries Encoding -> Entries Encoding by line
But sir in Journal items i couldn’t link my entry to an analytic account. instead some analytic distribution is there. i am confused. can you explain me what does analytic distribution mean.
Which module do i need to install to get an analytic account in purchase invoice, sales invoice, posting general entries? please help me in sorting out this problem.
@KD don’t need to install separate module for analytical. see the invoice lines.
Ok will check that. But what about the ‘journal items’ part. you didn’t tell me how i can link analytic account there. the problem is, I can’t see any analytic account field there. rather some analytic distribution field is there where i couldn’t trace my analytic accounts. please help me.
I think this is one of the most vital information for me. And i am glad reading your article. But wanna remark on some general things, The website style is perfect, the articles is really excellent : D. Good job, cheers
Nice post. I was checking continuously this blog and I’m impressed! Extremely useful info particularly the last part 🙂 I care for such info a lot. I was seeking this particular information for a very long time. Thank you and best of luck.
Hey there, You have done a great job. I will definitely digg it and personally recommend to my friends. I’m sure they will be benefited from this web site.
@posicionami, @frostwire and @limewire thanks buddies
Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a bit, but other than that, this is fantastic blog. A great read. I’ll certainly be back.
Excellent blog. I was checking continuously this blog and I’m impressed! Extremely helpful information specifically the last part. I care for such info much. I was looking for this particular information for a very long time. Thank you and best of luck.
i have a client who wants to reconcile all lines from all debtors in a particular month, then deduct(cancel payment received) when he money fail to get through from the bank, can this be done? openerp V6.0.1
Can I submit your put up to my wordpress weblog? I will add a back-link to your forum. That’s one really nice post.
I’m nonetheless learning from you, however I’m improving myself. I actually love reading every thing that is written in your blog.Keep the tales coming. I beloved it!
I truly like the fresh perpective you did on the issue. Truly was not expecting that when I started off studying. Your concepts had been easy to understand that I wondered why I never looked at it before. Glad to know that there’s an individual out there that definitely understands what he’s discussing. Fantastic job
Hi,
This is a very interesting blog. Why don’t you contact the OpenERP personnel and ask them to include it on their planet page? I got to know your blog thanks to a friend who referred it to me. It would be good for the community to know your blog, it has very interesting content
Regards,
Gustavo
@gustavo thanks brother. Pray for me so that i can contribute in community more.
I will try to contact openerp personal thanks for advice
Hi Mohsin. This is a great contribution. We are using OpenERP & Tiny ERP since 2005. Would you be interested in collaboration of some kind? Keep it up!
sure why not
Assalamu alaikum Brother
Very interesting blog! Keep up the good work!
I was just wondering if you will be interested to help us implement OpenERP in our welfare organisation. Please email me your number so we can talk further.
Kind regards
Atif
Hi mohsin,
Is it possible to set up 2 separate, unrelated business entities which I own in OpenErp?
yes you can use two different database in openerp, or you can use single database with multiple company module.
multiple comnapy module will help you in consolidation.
Hi..
Rite now i am working on Microsoft Dynamics from past 3 months as a Functional Consultant , and Previously i worked 2 yeas in inhouse erp product. Now i got offer on OpenERP.
So can any one suggest which one to chose .
Thanks in Advance
Brother its depends your career choice, because some people love to work in opensource and other in close source.
Google Insight can help to see the over view of what people like to work.
http://www.google.com/insights/search/#q=Microsoft%20Dynamics%2COpenERP&cmpt=q
In My view OpenERP is one of the rapidly growing ERP in world.
may be one of our presentation about openerp can help u more
http://slidesha.re/MvhY80
Hi Mohsin,
Let me first thank you for all the hard work you’ve done so far on openERP. I’ve learned a lots from your blog and I never expected to find so many resources under one roof. Cheers to you.
Now, let me now explain my problem. Actually I’m testing openERP 6.1 and trying the Payroll module. I’ve created a Salary rule, given it a name of course, and trying to apply a logic to it. In fact its a deduction.
I explain. If the person salary is less than $12460, lets say $10000, I would deduct 1% of $10000.
Else if the salary is greater than $12460, lets say $20000, I would still deduct 1% but not on $20000, only on $12460.
Hope I’ve explained it clearly.
Kind Regards
Dhinesh