Skip to Content
  • Functional question: ISR based on customer [l10n_ch_payment_slip]
    Hi OCA,



    We are trying to understand and use this module for one of our customer based in Geneva:
    https://github.com/OCA/l10n-switzerland/tree/11.0/l10n_ch_payment_slip



    We would like to get an ISR reference depending on the res.partner (so that each time the same customer pays, he can use the same ISR reference, even if he has 5 different invoices).

    We found this documentation on the module about the ISR generation by Odoo:
    123456000000500002018000149
    \____/\_____/\___________/|
      1      2         3      4
    The ISR is a 27 interger long string that is created upon VALIDATION of an invoice. It consists of the following parts:
    (1) ISR-B Customer ID number (size: may vary) - this number identifies your company and is set in the bank account of your company’s partner as 'l10n_ch_isrb_id_number'.
    To set this number, create a bank and bank account through Contacts > Configuration. There, you can assign the created bank, your company and an ISR-B number to the bankaccount.
    (2) Partner reference filled by 0 on the left (size: 7) - this number is taken from the 'ref' field of a customer (partner).
    (3) Invoice reference filled by 0 on the left (size: what is left) - this number can be found (for the most part) in the name of an invoice
    (4) Control digit (size: 1)

    But our tests are not OK. For example, we have one partner with internal reference 999 and another with internal reference 001.
    For the 001 customer we generated 2 invoices, and it gave those 2 ISR:
    01 12341 00000 00002 02000 06921
    01 12341 00000 00002 02000 07941

    For the 999 partner, we generated 1 invoice and the BVR generated is:
    01 12341 00000 00002 02000 04980

    We don't see the partner internal reference in the generated BVR.

    What did we miss?

    Thanks a lot for your help,
    Virginie
    Coop IT Easy (Belgium)

    by Virginie Dewulf. - 09:55 - 25 Feb 2020
  • GSSAPI support to connect Odoo 12 to MS Exchange
    Hello,

    I have a project where I need to connect Odoo 12 to Microsoft Exchange requiring GSSAPI for outgoing emails.

    Any experience or recommendation around this topic?

    Thank you.

    MAXIME CHAMBREUIL
    PROJECT MANAGER/CONSULTANT
    O: 1.855.877.2377 EXT. 710
    M: 602.427.5632
    E: MChambreuil@OpenSourcelntegrators.com
    P.O. BOX 940, HIGLEY, AZ 85236

    by Maxime Chambreuil - 04:46 - 24 Feb 2020
  • Call for PayPal users
    Dear community,

    There are two PRs related to PayPal that could be useful to active PayPal users (e.g. B2C):
    https://github.com/OCA/bank-statement-import/pull/234 - adds support for automatic import of PayPal statements
    https://github.com/OCA/bank-statement-import/pull/236 - improves off-line importing of PayPal reports, yet doesn’t have backwards compatibility with previous mapping configurations

    It would be great to get more visibility as it’s really odd that such features are not in high demand.

    Kind regards,
    Alexey




    by Alexey Pelykh <alexey.pelykh@gmail.com> - 04:31 - 22 Feb 2020
  • Analytic Account: different currency than company
    Dear community, 
    
    Is there a module that would allow analytic account to have different currency than company?
    
    Kind regards,
    Alexey

    by Alexey Pelykh <alexey.pelykh@gmail.com> - 12:31 - 21 Feb 2020
  • Salary Structures
    Dear community,
    
    Is there a good readme or explanation (or real-life examples) on salary structures and rules? It seems like a complete voodoo at first :D We’re diving into this part of Odoo for the first time
    
    Kind regards,
    Alexey
    
    

    by Alexey Pelykh <alexey.pelykh@gmail.com> - 03:36 - 19 Feb 2020
  • How to use /ocabot merge correctly?
    Dear community,

    We have seen this document, yet it not tell in great detail. https://odoo-community.org/blog/the-oca-blog-1/post/the-oca-github-bot-can-now-merge-pull-requests-92 so may we ask in detailed here,

    1) What is the difference between /ocabot merge patch/minor/major and the symantic of x.y.z - breaking.feature.fix in another document. Is it so that,
      - /ocabot merge patch, 13.0.1.0.0 -> 13.0.1.0.1 (patch = fix)
      - /ocabot merge minor, 13.0.1.0.0 -> 13.0.1.1.0 (minor = feature)
      - /ocabot merge major, 13.0.1.0.0 -> 13.0.2.0.0 (major = breaking)

    2) For the new [ADD] module, should be click merge manually, or use /ocabot merge (don't want to add any digit, but we test it and it seem to try to change last digit).

    3) What is "/ocabot merge" alone, it default to patch or minor?

    4) What is the practice to work with some module that has HISTORY. For example, some author (not the PSC), may add in history as new Minor revision, 13.0.1.0.0 -> 13.0.1.1.0 but the merger think it is just a fix. And so, he might do /ocabot merge patch . This could result in the version diff between HISTORY and manifest file?

    Thank you!
    Kitti U.






    by Kitti Upariphutthiphong - 10:10 - 17 Feb 2020
  • Github OCA do not have runbot and codecov in v13
    Dear contributors,

    Has been  experiences this a while now. For example,

    Only Travis seem working.
    Thank you,



    by Kitti Upariphutthiphong - 09:11 - 17 Feb 2020
  • Re: How can functional people "really" participate in OCA?
    Lek, Bill and others,

    I was somewhat expecting some responses.

    My opinion anyway, that this is pretty emblematic of the OCA "functional" issue.  Lots of conversation "about them" but little visible response "to them".  3 functionals chimed in and no response other than this small micro eddy.

    Perhaps we coukd form a sub-group and see of we can outline issues, resources and methods for involvement to have clear paths and bridges between elements.

    Fog may not seem thick when you are in a forest.  From the outside, it is hard to find the landing strip none the less.

    Thoughts?  Methods?  I did log into the wiki referenced above.  Is there one "GitHub Issue" set that coukd be used as a focal point for discussion?

    hope to hear more.

    Landis Arnold


    From: Lek Ecosoft <wipawiij@ecosoft.co.th>
    Sent: Feb 13, 2020 7:57 PM
    To: Contributors
    Subject: Re: How can functional people "really" participate in OCA?

    Hello,


    I am pure blood functional, who cannot even query database. 

    Thank you all to talk about this topic and share many ideas/suggestions. This is a good example of opening space to talk and share but email or mailing list flows and gone, not suits as knowledge and content management.

    IMHO, functional consists of End Users and Implementor.

    If we talk about an End user, we should have place to chat and ask + knowledge or Content management because they want to decide to use our app or not. If so, how to use it > This should be Easy to access and find information > User documents, user manual.

    If we talk about functional Implementor, they should work as a team with technical. I think this group doesn't need Easy tool but it should be simple tool and simple way to work together. Functional spec or Requirements Spec is out of date for agile methodology, no longer writing this for technical. We need to discuss and share different aspects and ideas from Technical and functional then summarise, code and Test absolutely.

    > No doubt for runbot for testing but discussion, I would say

    > Wiki is easy but not in line with github which is powerful for technical and have to manage?

    > +1 github issue and link to google doc/sheet.

    Personally, github itself look scary for non-technical but not too difficult to use. Functional who really want to be in, they got strong passion to learn 'new world of techies'. They open thier mind to give and take. On the other hands, github will filter out Newbies because its structure. We have to accept that github born for technical. (Of I am not wrong)

    +1 Forum no reason, just experience it.

    ... TOTB...

    1. Let's try to change this thread topic to be Does OCA "really" need implementor functional and user?

     - If the answer is no, it's crystal clear. No need any action.
     - If your answer is yes, I believe you will find the way to let them it and be a part of team.

    2. Opensource is an area of technical or hybrid functional while Proprietary is an area of Functional, is this true?

    Last but not least, shall technical open mind to learn a new world of Functional?

    Thanks all.

    Regards,

    Wipawii

    www.ecosoft.co.th

    Your ERP Partner

    On Fri, 14 Feb 2020, 06:12 Bill Ennals, <bill@billennals.net> wrote:
    Hi Community,

    I’m also ‘mostly' functional.  I have no formal IT qualification or education but have self-taught the basics of administering a Ubuntu server and an Odoo CE installation for a small not-for-profit business (reversegarbageqld.com.au) in Australia.  I can’t really code, but I’m a stubborn googler and can do some low-level tinkering and can sometimes get to where I’m aiming for, sometimes not.

    It’s taken many years and we’re still only 50% implemented - no POS, public facing website, ecommerce and accounting yet, though all of that should be ready in the next six months.  Started on V7, open upgraded to v8, then leap frogged to V11 via a gruelling export/import process.  It’s been a crazy and unsustainable way to do it in many respects, but our hope is that the efficiency gains of using an integrated ERP will help to generate enough operational profit to be able to engage a professional local implementer, the costs of which (up until now at least) have been prohibitive.

    I agree with Landis about the welcoming landing place, and through all of this, the thing that I have most missed is a healthy discussion forum.  Having to piece together clues from the Odoo help forum (which is mostly awful), Stack Overflow, this mailing list and the patchy official documentation has absorbed hundreds of hours of my time, often for no return.  Sure, a comprehensive wiki would be awesome, but that would seem to require a gargantuan effort to make it any more useful than pointers to the current Github repositories.  Github is a little daunting and opaque for non-IT professionals, but it’s not terrible and a healthy community forum with a few good stickies about how to approach navigating the various parts of the Odoo universe for newbies would make it far less daunting.  If the standard of the ‘readme’s was improved, I think a separate wiki might be unnecessary duplication.

    Lastly (sorry for the long email), one comparable experience I’ve had lately is mucking about with custom roms on mobile devices, which I know nothing about apart from what I’ve learned from xda-developers.com.  Although it’s far from perfect, if I spend an hour there researching a particular topic or problem I’m having, I can feel pretty confident about whether it’s something that is worth pursuing, or if it’s just going to be a waste of my time, and therefore something I should drop altogther.  A combination of the stickies and guides for newbies, and the vibrant participation of the community there enables that.  I rarely feel that way after an hour of trying to figure out if a particular thing is possible in Odoo - more often I’m left with a bunch of unresolved questions.  Obviously the xda forums member base is huge, but if the Odoo claim about 4 million users is true, then a proper discussion forum should have something to work with - no?

    Bill.








    On 14 Feb 2020, at 12:21 AM, Landis Arnold <larnold@nomadic.net> wrote:

    Well, Being mostly "functional" I would say, first off, there needs to be a place to go and get information, ask questions, profer advise.  Documentation is important, even in Wiki form, but most important is a true and welvoming landing pad and place.  Branches should go out from there to subjects of the different repositories.

    As an example.  Information and sharing about upgrade paths and methods.  Fundamental changes, for users and system implementers about requirement changes generation to generation...  Is it possible to skip versions in upgrade sequencing.  say v 8, v10, v12, v14?  If so how?

    "Open" needs to be open and not obscure.  Installations and upgrades can be methodical and complex, but they must also be understandable. 

    Customization, which is essence, is what OCA is about, should be welcome, and also seen to be something that users can also do without creating a whole repository and running through a week of testing and approvals.  Interface changes, as an example, like moving an "add task" button to a project, or rearranging a menu interface etc.

    And on bigger customizations, how to have "funcionals" express a desire for a more efficient work flow.  A "wish list" is different than a "issue" until it becomes one.

    Anyway, it is an important subject, how to integrate "functionals" which really everyone is on some level.

    Landis Arnold
    Nomadic Inc
    Colorado USA


    Sent from Nine

    From: "Pedro M. Baeza (Tecnativa)" <pedro.baeza@tecnativa.com>
    Sent: Thursday, February 13, 2020 6:47 AM
    To: Contributors
    Subject: Re: How can functional people "really" participate in OCA?


    Jean-Charles, here there's no such OCA strategy of not wanting functional people, just as Lois says: there's no more physical time to perform what you want to do to attract more people. I still think laziness is a point, because some functional people have already contributed and be part of the community with a low barrier, but it's very easy to say "I'm not able to contribute because things are not easy". Think that we are all employees of a company that pays our time and have a lot of duties, and some of us have invested spare free time for trying to raise OCA, but this time is limited. So any of you can apply for being in the OCA board next year and conduct this, or simply arise at contributor for that specific task this year. My colleagues at board will love some help on this (I'm not anymore there due to the time restrictions I have and after being there during 3 years).

    Regards.
    <span id="cid:D10EFA06-18B5-49B7-9C55-57158B7F1E0A@home.gateway"><attachment>

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe


    by Landis Arnold - 04:51 - 15 Feb 2020
  • OCA members list on odoo-community.org
    Hello everybody,

    just a quick notice to tell you that we are aware of an issue w/ members listing.

    Some of them are not appearing even if their membership status should be correct.
    Some of them were fixed already, some need further investigation.

    Meanwhile, if you don't appear there, please make sure you've completed the survey for being published https://odoo-community.org/survey/start/oca-website-privacy-13.

    Side note: we are thinking about shuffling the ordering randomly from time to time in order to not have always the same people on top or bottom.

    We'll keep you posted.

    Bests,
    Simone
    OCA board

    by Simone Orsi. - 08:41 - 14 Feb 2020
  • Proposing Lois Rilo as PSC for server-ux
    Hi all,

    I would like to help maintain pulls requests and issues at server-ux. I've contributed as author and core maintainer of base_tier_validation and there are several related PR still open that I would like to push forward. I also contributed to document_quick_access addons and would like to help on migration and reviews.

    I see the only team with rights in that repo is "Tools maintainers". I wouldn't need to be part of such wide group, but I also understand that segregating the PSC teams even more is not a good approach for maintainability reasons. Any of those two options would be good for me.

    Regards,

    --
    Lois Rilo Antelo - Odoo consultant at ForgeFlow
    twitter: @LoisRForgeFlow

    by Lois Rilo Antelo - 04:35 - 12 Feb 2020
  • Help on Email Marketing
    Hello community,
    
    To be honest, the Email Marketing App is not something I have used before.
    I was expecting it to be like an upgraded version of email templates, 
    but AFAICS it uses a fixed QWeb template, and you can't add dynamic 
    fields, like the Contact's name of job/function.
    
    Am I missing something?
    If not, has anyone worked on some module to allow rendering dynamic 
    fields on the outgoing email, similarly to email templates?
    
    
    Thank is advance for your insights
    Daniel Reis
    

    by Daniel Reis <dgreis@sapo.pt> - 11:50 - 12 Feb 2020
  • Can Odoo create asset on Stock IN, instead on Invoice Post?
    Hi community,

    As we know, about Asset in Odoo. Normally, asset is created when Invoice is posted.

    AFIK, other ERP system will create asset on Stock In. Which make more sense to me. What is your opinion about this?

    Are there OCA modules that did that?

    Thank you!

    by Kitti Upariphutthiphong - 07:36 - 12 Feb 2020
  • l10n-italy on apps.odoo.com

    Hello,

    i'm looking for owner of the l10n-italy repository on apps.odoo.com because that repository is not updated,

    odoo helpdesk says the owner is openerp-community-reviewer@lists.launchpad.net but this email is very old and i've got no answer

    someone could help me?

    thanks

    --
    Andrea Cometa | Cybersecurity Manager
    Presidente Associazione Odoo Italia
    Responsabile Commerciale ed Amministrativo Apulia Software srl
    Taranto / Milano / Potenza
    Tel: 0999915404 http://www.apuliasoftware.it
    a.cometa@apuliasoftware.it pec: apulia.software@pec.it
    linkedin: http://it.linkedin.com/in/andreacometa

    by Andrea Cometa - 04:40 - 11 Feb 2020
  • Activity: reminders
    Dear community,
    
    Is there a module that sends a notification (email or chat) about upcoming activity e.g. 5-3-1 days before the deadline? I’ve been looking into the Odoo sources and OCA repositories, yet it seems that there’s no such feature.
    
    Kind regards,
    Alexey

    by Alexey Pelykh <alexey.pelykh@gmail.com> - 06:01 - 8 Feb 2020
  • How can functional people "really" participate in OCA?
    Dear community,

    I have a pretty hard question :)

    We always say that functional people  is vital to ERP system, for sure in the project. But are functional people have places in OCA?

    Are there forum or any place where functional can fully contribute their business knowledge without friction of tech, github and programmer languages?

    Any pure functional people in OCA can help answer this? :)
    Thanks!

    Note: This question is passed here by my functional peer who want to participate in OCA. But I also don't have that good suggestion too.

    by Kitti Upariphutthiphong - 08:46 - 5 Feb 2020
  • Pandoc Odoo Tables
    Hi All,

    For those working with pandoc markdown as their preferred publishing pipeline,
    I made a little integration to fetch tables from an odoo instance.

    BR, David A.

    by dar - 08:46 - 5 Feb 2020
  • Website sale : products restriction based on logged user
    Hello Community,

    I need some help for a specific Use Case. I hope this mailing list can be used for this type of question (if not, excuse me and tell me which way of asking would be best).

    Here is the context : there are a lot of products sold on the Website through eCommerce. All the non-logged in customers can choose in the whole list.
    For certain customers who have a login in Odoo, the list of the products available should be restricted.

    To make it clear:
    - Products A, B, C, D are on the website.
    - Customer of Category 1 (no login required for them) can buy A, B, C, D without restriction.
    - Customer of Category 2 (they should be logged in) can only by B and C.

    Another Use Case in the same idea of making some products appear/disappear on the eCommerce (from Sylvain Le Gal) : is there a way to make Products appear on the website based on a frequency (concept of date_range somewhere). Example :
    - Product A and B on Week 1
    - Product C and D on Week 2
    - Product A and B on Week 3
    - Product C and D on Week 4
    - etc.

    Have you seen any module making the job for one of these Use Cases?
    Thanks a lot!
    -- 
    Virginie
    0477/64.17.20
    --
    Si vous avez un contrat de support, posez-nous vos question à l'adresse "support@coopiteasy.be"
    --
    Lors de l'envoi d'un mail, renseignez le nom de la structure pour laquelle vous travaillez. Merci.

    by Virginie Dewulf. - 05:50 - 5 Feb 2020
  • Proposing Sergio Zanchetta for Italy PSC
    Hi all,

    I would like to propose Sergio Zanchetta
    for Italian PSC so that he can help us managing issues and pull requests.

    Thanks

    --
    Lorenzo Battistini
    https://github.com/eLBati


    by Lorenzo Battistini. - 12:30 - 5 Feb 2020
  • "Project Use Case" or "Customer References"
    Hi community,

    I remember seeing and testing a module to publish "success stories" from projects in previous Odoo versions. But my memory and our knowledge base is empty on this subject for most recently versions...

    We want to share with clients and partners our experiences and projects. The name of the customer is not systematically published (NDA), but the history of the project, its scope, the tools and technicals, the team involved, screenshots, maybe video ...

    I think the main model is project.
    We had until Odoo v10 the addon website_project

    We found this addon https://github.com/baba75/website_case_history where we can input several informations, for example this screenshot

    image.png

    This addon depends on website, not project at all.

    Before we plan the development of a new module or offer a contribution to this one, do you know modules with similar features?

    Bruno Joliveau - Architecte applications - Président
    NUMIGI SOLUTIONS INC.
    (514) 317-7944

    Longueuil, Québec, Canada

    linkedinyoutubecustom-icontwitter

    by Bruno Joliveau - 12:25 - 4 Feb 2020
  • stock.picking very slow and some are not validating
    Hello Contributors,

    We are using Odoo 11 for a retail chain. They have over 60 POS locations (and increasing across the country) and over 17000 products (also increasing).

    Recently, for past two months, we are facing strange problem. The retail chain do purchase order once in a month to the vendor and the PO contains over hundreds of products. They are using lot based tracking. When we are receiving products with lot number it takes forever to validate. Even some pickings are stuck and can't be validated. We tried all the possible workarounds but still no luck. There are no errors too.

    The instance is running on AWS with RDS. RDS configuration:
    PostgreSQL - 10.10
    4 vcpu x 16 GB RAM
    100 GB SSD
    IOPS: 100 * 3 = 300

    How can we validate the stock.pickings? Any idea or thoughts appreciated.

    Best Regards,
    MD. Tanzilul Hasan Khan

    by ponkhi403 - 08:00 - 3 Feb 2020