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


  1. Diego Guzman
    August 31, 2010 at 8:03 pm

    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

  2. September 4, 2010 at 6:22 pm

    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

  3. KD
    November 8, 2010 at 6:58 am

    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

  4. KD
    November 8, 2010 at 8:04 am

    Pls help me

  5. November 8, 2010 at 2:56 pm

    @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

  6. KD
    November 9, 2010 at 6:22 am

    Thank you sir

  7. KD
    November 9, 2010 at 6:28 am

    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?

  8. November 9, 2010 at 12:22 pm

    @KD welcome
    brother i start an example for you in form of series of tutorials.
    first tutorial in this regard is below.
    https://mohsinpage.wordpress.com/2010/11/09/creating-partners-products-chart-of-accounts-invoicescustomers-and-suppliers-partner-balances-in-openerp/
    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

  9. KD
    November 10, 2010 at 7:29 am

    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

  10. November 10, 2010 at 8:12 am

    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.

  11. Kashif
    December 23, 2010 at 7:34 am

    Hi Mohsin
    i want to implement Openerp in my company can u support me.
    my contact no is +923002571702.

    • December 23, 2010 at 9:39 am

      @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

  12. KD
    December 28, 2010 at 6:50 am

    Please please tell me how to deal with company contributions (Provident Fund, ESIC) via hr_payroll module in open ERP.

  13. KD
    January 4, 2011 at 12:24 pm

    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.

  14. January 4, 2011 at 2:02 pm

    @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

    • KD
      January 5, 2011 at 7:42 am

      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?

      • January 5, 2011 at 8:48 am

        @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.

  15. KD
    January 5, 2011 at 10:57 am

    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?

    • January 5, 2011 at 11:17 am

      @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

      • KD
        January 6, 2011 at 6:12 am

        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.

        • January 6, 2011 at 6:28 am

          @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)

  16. KD
    January 6, 2011 at 7:50 am

    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’.

    • January 6, 2011 at 8:35 am

      @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

  17. KD
    January 6, 2011 at 11:49 am

    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)

    • January 7, 2011 at 5:42 am

      @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)

  18. KD
    January 11, 2011 at 8:31 am

    after clicking ‘approve sheet’ the following error comes.

    An Application Error has been reported
    Let me fix it
    Fix it for me

  19. KD
    January 11, 2011 at 9:10 am

    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?

  20. January 15, 2011 at 5:40 pm

    @KD in ver 6 Human Resources -> Configuration -> Payroll -> Salary Heads (New Head)
    here you can find the contribution from company.

  21. KD
    January 19, 2011 at 12:59 pm

    where is the ‘encoding by line’ part in version 6? can you pls help me. i want to post general entries.

    • January 19, 2011 at 1:07 pm

      @KD
      in ver 6:
      Accounting -> Journal Entries -> Journal Items.
      in ver 5:
      Financial Management -> Entries Encoding -> Entries Encoding by line

  22. KD
    January 20, 2011 at 5:04 am

    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.

  23. KD
    January 20, 2011 at 5:51 am

    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.

    • January 28, 2011 at 5:55 am

      @KD don’t need to install separate module for analytical. see the invoice lines.

  24. KD
    January 29, 2011 at 5:31 am

    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.

  25. February 10, 2011 at 1:17 am

    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

  26. February 10, 2011 at 11:01 am

    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.

  27. February 10, 2011 at 11:17 pm

    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.

  28. February 11, 2011 at 5:08 am

    @posicionami, @frostwire and @limewire thanks buddies

  29. February 11, 2011 at 11:41 pm

    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.

  30. Vernon Hornak
    February 19, 2011 at 10:07 am

    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.

  31. langton
    February 22, 2011 at 1:50 pm

    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

  32. High School Diploma
    February 25, 2011 at 4:22 pm

    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.

  33. Pamala Verma
    February 27, 2011 at 4:01 pm

    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!

  34. Ermelinda Seppanen
    February 27, 2011 at 11:30 pm

    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

  35. March 15, 2011 at 5:27 pm

    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

    • March 18, 2011 at 5:31 pm

      @gustavo thanks brother. Pray for me so that i can contribute in community more.
      I will try to contact openerp personal thanks for advice

  36. Lahori
    May 14, 2011 at 10:52 am

    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!

    • Lahori
      May 14, 2011 at 10:52 am

      Lahori :

      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!

  37. Atif
    May 21, 2011 at 5:52 am

    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

  38. JC
    June 15, 2012 at 5:03 pm

    Hi mohsin,
    Is it possible to set up 2 separate, unrelated business entities which I own in OpenErp?

    • June 18, 2012 at 6:01 am

      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.

  39. Nandan
    July 20, 2012 at 9:49 am

    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

  40. Dhinesh
    August 14, 2012 at 7:07 am

    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

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: