Skip to Content
  2. Mailing Lists
  3. Contributors

Archives

Contributors

  • Re: Install postgres unaccent lib at travis yml
    If you find the travis file for the repo with base search fuzzy it should show you. It use pg trigram which is installed in the same way as unaccent.

    On Thu, 2 Dec 2021, 8:31 am Vincent Lucy, <vincent.lucy@coopaname.coop> wrote:
    Hi,

    connect to your postgresql db :
    psq -U psql_user psql_db

    list the extensions installed:
    \dx

    You should not see unaccent.

    Then this commands:

    DROP FUNCTION unaccent;
    CREATE EXTENSION IF NOT EXISTS \"unaccent\";

    list again the extensions installed:
    \dx

    restart odoo with the config line:
    unaccent = True

    That should work.

    Regards,

    Vincent
    De : Luiz Felipe Divino <lf.divino@gmail.com>
    Envoyé : mardi 30 novembre 2021 21:07
    À : Contributors <contributors@odoo-community.org>
    Objet : Install postgres unaccent lib at travis yml
     
    Hello Everyone!

    I'm developing a  Pull Request at Brazilian location (l10n-brazil) and I'm getting error at some Travis jobs because we need that our Postgres database has the unaccent lib installed.

    My Travis build is:


    Could anyone help me on how to set this unaccent lib in my Travis yml configuration?

    Thanks for your help!

    Regards,
    Luiz Felipe

    --
    Luiz Felipe do Divino
    Bacharel em Ciências da Computação
    UNIFEI - Itajubá

    _______________________________________________
    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 Graeme Gellatly - 09:05 - 1 Dec 2021
  • RE: Install postgres unaccent lib at travis yml
    Hi,

    connect to your postgresql db :
    psq -U psql_user psql_db

    list the extensions installed:
    \dx

    You should not see unaccent.

    Then this commands:

    DROP FUNCTION unaccent;
    CREATE EXTENSION IF NOT EXISTS \"unaccent\";

    list again the extensions installed:
    \dx

    restart odoo with the config line:
    unaccent = True

    That should work.

    Regards,

    Vincent
    De : Luiz Felipe Divino <lf.divino@gmail.com>
    Envoyé : mardi 30 novembre 2021 21:07
    À : Contributors <contributors@odoo-community.org>
    Objet : Install postgres unaccent lib at travis yml
     
    Hello Everyone!

    I'm developing a  Pull Request at Brazilian location (l10n-brazil) and I'm getting error at some Travis jobs because we need that our Postgres database has the unaccent lib installed.

    My Travis build is:


    Could anyone help me on how to set this unaccent lib in my Travis yml configuration?

    Thanks for your help!

    Regards,
    Luiz Felipe

    --
    Luiz Felipe do Divino
    Bacharel em Ciências da Computação
    UNIFEI - Itajubá

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

    by Vincent Lucy - 08:30 - 1 Dec 2021
  • Install postgres unaccent lib at travis yml
    Hello Everyone!

    I'm developing a  Pull Request at Brazilian location (l10n-brazil) and I'm getting error at some Travis jobs because we need that our Postgres database has the unaccent lib installed.

    My Travis build is:


    Could anyone help me on how to set this unaccent lib in my Travis yml configuration?

    Thanks for your help!

    Regards,
    Luiz Felipe

    --
    Luiz Felipe do Divino
    Bacharel em Ciências da Computação
    UNIFEI - Itajubá
    by Luiz Felipe Divino - 09:06 - 30 Nov 2021
  • FAQ on OCB github's wiki 
    Hi everyone

I am working on the OCB wiki.
I've already renamed with "OLD-" prefix all the pages related to 
migration from Launchpad to Github, and I started an OCB purpose page 
and a draft FAQ. Could you help to answer these simple questions (short 
answers, please)? 

- Can I fix bugs directly in OCB ?

   OCB only accept changes if you submit your fix against the official 
version to prevent to be a fork in the end. All updates must be 
submitted to the official odoo branch for adoption in the official odoo 
release before they can be considered for the OCB version.

- Do I need the Odoo CLA signed to submit a patch to OCB branches ?

   No. But as you need to submit your patch upstream, Odoo SA will 
probably ask you to sign it. The OCA encourages you to carefully read 
this document, as it allows Odoo s.a. to relicense your contribution. 
Some important contributors from the OCA have signed that document 
because this eases the work of the core maintainers and the OCB 
maintainers.

- Does it contains backports ?
- Does it contains fixes that are not on same Odoo version, but on 
higher versions ?
- Does it maintains versions that are no more maintained by Odoo ?
- Does OCA's runbot use OCB ?
- Why is it sometimes behind Odoo ? does it concern minor updates ?
- Why should we use OCB instead of Odoo nightly ?

   Because it contains more bug fixes and because it is maintained for a 
longer time.

- How to use OCB ?

  See Odoo documentation about installing from source. Use git clone and 
update frequently.



Best regards


-- 
Librement,
Xavier Brochard xavier@alternatif.org
La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre 
Rosnay)
    by xavier - 11:11 - 27 Nov 2021
  • PEPPOL/UBL Order response - replacement items

    Hello fantastic community!

     

    I’m looking at the “replacement item” case in peppol order response:

    https://docs.peppol.eu/poacc/upgrade-3/profiles/28-ordering/#order-response-with-changes

     

    I’m trying to understand how this is solved in Odoo.

     

    1. From a retailer perspective I want to be able to replace items on a sales order and track the old and new product and respond correctly.

    2. From a purchase perspective I want to be able to handle the case when the retailer exchange a product upon delivery…. I want the PO and the inventory reception to reflect the change and I want to keep historical information (what product has been exchanged).

     

    Can anyone give some insights to how these scenarios might be solved?

     

    We have also started prototyping a replacement module for #1 but I’m not sure if it’s unnecessary work.

     

    We have worked with EDIFACT/ESAP6 and the similar flows with other systems that handle this situation but I don’t see it clearly in odoo.

     

    Best regards

    Teo

     

     

     

     

     

     

    by Teo Pezo - 12:46 - 26 Nov 2021
  • PEPPOL/UBL Order response - replacement items

    Hello fantastic community!

     

    I’m looking at the “replacement item” case in peppol order response:

    https://docs.peppol.eu/poacc/upgrade-3/profiles/28-ordering/#order-response-with-changes

     

    I’m trying to understand how this is solved in Odoo.

     

    1. From a retailer perspective I want to be able to replace items on a sales order and track the old and new product and respond correctly.

    2. From a purchase perspective I want to be able to handle the case when the retailer exchange a product upon delivery…. I want the PO and the inventory reception to reflect the change and I want to keep historical information (what product has been exchanged).

     

    Can anyone give some insights to how these scenarios might be solved?

     

    We have also started prototyping a replacement module for #1 but I’m not sure if it’s unnecessary work.

     

    We have worked with EDIFACT/ESAP6 and the similar flows with other systems that handle this situation but I don’t see it clearly in odoo.

     

    Best regards

    Teo

     

     

     

     

     

     

    by teo.pezo - 09:15 - 26 Nov 2021
  • Odoo 14 bank statement reconciliation
    Hello,

    I hope this email finds you well. Today I was stuck with the way Odoo handles the bank statement reconciliation in v14 and saw Frederic's tweet from a year ago: https://twitter.com/Frederic_C2C/status/1313521444106706944

    What really stuck me is not the use of a suspense account during the bank reconciliation, but the fact that once the bank statement line journal entry has been posted to a suspense account, the posted journal entry is modified once you have matched that statement line with an invoice. Changing a posted journal entry??

    What do you think?

    --
    Jordi Ballester Alomar 
    CEO & Founder  
    Spain: (+34) 629 53 07 07 | USA: (+1) 646 980 46 59 | Denmark: (+45) 78 78 21 89


          

    The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.
    by Jordi Ballester Alomar - 08:16 - 25 Nov 2021
  • Re: Any feedback about centralized user directory / auth
    I second Holger's suggestion. auth_oidc should work fine with auth0.
    If this is the only authentication mechanism you need and want for your Odoo users, you can complement it with auth_oauth_autologin (https://odoo-community.org/shop/product/auth-oauth-autologin-9458) which hides the Odoo login page in normal circumstances.

    -sbi

    On Tue, Nov 23, 2021 at 10:27 PM Holger Brunn <mail@hunki-enterprises.com> wrote:
    > Customer viewed https://auth0.com [1]


> The functionalities are interesting and motivate the customer in relation to


> his park of applications and machines. Some paid modules exist, the


> characters of which can only be seen in the description. Do any of you have


> any feedback to share on this?

they seem to support OIDC, so 
https://odoo-community.org/shop/product/auth_oidc-6545
should work there. I just happened to backport this to v12, and migrating to 
v14, v15 should be pretty straightforward.



-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

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

    by Stéphane Bidoul - 10:01 - 24 Nov 2021
  • Re: Any feedback about centralized user directory / auth
    We used FreeIPA + auth0 + LDAP for multi-system centralized management.

    On 23 Nov 2021, at 22:27, Holger Brunn <mail@hunki-enterprises.com> wrote:

    > Customer viewed https://auth0.com [1]

> The functionalities are interesting and motivate the customer in relation to

> his park of applications and machines. Some paid modules exist, the

> characters of which can only be seen in the description. Do any of you have

> any feedback to share on this?

they seem to support OIDC, so 
https://odoo-community.org/shop/product/auth_oidc-6545
should work there. I just happened to backport this to v12, and migrating to 
v14, v15 should be pretty straightforward.


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
    <signature.asc>

    by Alexey Pelykh - 07:05 - 24 Nov 2021
  • Re: Any feedback about centralized user directory / auth 
    > Customer viewed https://auth0.com [1]

> The functionalities are interesting and motivate the customer in relation to

> his park of applications and machines. Some paid modules exist, the

> characters of which can only be seen in the description. Do any of you have

> any feedback to share on this?

they seem to support OIDC, so 
https://odoo-community.org/shop/product/auth_oidc-6545
should work there. I just happened to backport this to v12, and migrating to 
v14, v15 should be pretty straightforward.


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
    by Holger Brunn - 10:26 - 23 Nov 2021

    1 attachments 1 attachments

    signature.asc
  • Any feedback about centralized user directory / auth
    Hi community

    In the context of a multi-environment project, we need a centralized user directory.

    The creation is initiated on the Odoo side by the future user by providing his email. It inherits a group of default rights in Odoo. So far everything is ok ;-)

    Next, we need these users to be available for other third party applications and want this directory to be managed externally.

    Customer viewed https://auth0.com
    The functionalities are interesting and motivate the customer in relation to his park of applications and machines. Some paid modules exist, the characters of which can only be seen in the description.

    Do any of you have any feedback to share on this?

    Have a nice day
    Bruno Joliveau - Président
    NUMIGI SOLUTIONS INC.
    (514) 317-7944

    Longueuil, Québec, Canada

    linkedinyoutubecustom-icontwitter
    by Bruno Joliveau - 09:46 - 23 Nov 2021
  • Re: OCA 2021 Delegate Election Results plus Financial Auditors Campaign NOW OPEN
    Welcome and congratulations!
    It's great to see more people wanting to become Delegate each year. 
    Let's continue on this vibe ;-)

    Great day to everyone!
    --
    Virginie
    0477/64.17.20

    -----Original Message-----
    From: Rebecca Gellatly <rebecca@o4sb.com>
    Reply-To: Odoo Community Association (OCA) Contributors <contributors@odoo-community.org>
    Subject: OCA 2021 Delegate Election Results plus Financial Auditors Campaign NOW OPEN
    Date: Tue, 23 Nov 2021 05:07:35 -0000

    Hello OCA Contributors,

    I wanted to share with you the 10 new Delegates from the election we have just run:
    • Aaron Henriquez
    • Ben Brich
    • David Vidal
    • Els Van Vossel
    • Fredrik Arvas
    • Jairo Llopis
    • Pierrick Brun
    • Rémi Cazenave
    • Robin Keunen
    • Tom Blauwendraat
    Welcome to those above and a special thank you to all the members that applied. It is great to see motivation and enthusiasm within the group and certainly helps to keep an active and engaged community.

    To let you know we have also just opened the 2021 OCA Board Member and Financial Auditor Campaigns.

    Only Delegates can apply to become Board Members (this includes our new Delegates) but you do not need to be a Member or Delegate to apply to become a Financial Auditor. The application survey is here. This campaign will close on Friday 3rd December.

    Any questions, please let me know.

    Warm regards,
    Rebecca
    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association

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

    by Virginie Dewulf. - 09:16 - 23 Nov 2021

    1 attachments 1 attachments

    face-wink.png
  • OCA 2021 Delegate Election Results plus Financial Auditors Campaign NOW OPEN
    Hello OCA Contributors,

    I wanted to share with you the 10 new Delegates from the election we have just run:
    • Aaron Henriquez
    • Ben Brich
    • David Vidal
    • Els Van Vossel
    • Fredrik Arvas
    • Jairo Llopis
    • Pierrick Brun
    • Rémi Cazenave
    • Robin Keunen
    • Tom Blauwendraat
    Welcome to those above and a special thank you to all the members that applied. It is great to see motivation and enthusiasm within the group and certainly helps to keep an active and engaged community.

    To let you know we have also just opened the 2021 OCA Board Member and Financial Auditor Campaigns.

    Only Delegates can apply to become Board Members (this includes our new Delegates) but you do not need to be a Member or Delegate to apply to become a Financial Auditor. The application survey is here. This campaign will close on Friday 3rd December.

    Any questions, please let me know.

    Warm regards,
    Rebecca
    --
    Rebecca Gellatly
    General Secretary
    Odoo Community Association
    by Rebecca Gellatly - 06:06 - 23 Nov 2021
  • Re: PSC Real Estate
    @Ignacio Yes, it could be great to push a PR.

    That can be a base for beginning.

    Thanks


    On Mon, Nov 15, 2021 at 10:12 AM Ignacio Ibeas (Acysos S.L.) <ignacio@acysos.com> wrote:

    Hello,

    This is correct, but we not commit modules because there aren't compliant with the OCA requirements. The modules are in production but are to extense, i we don't make tests.

    We can make a PR with all our work.

    Greetings

    El 15/11/21 a las 9:52, Stéphane Bidoul escribió:
    The PSC Representative and only member is currently Ignacio Ibeas (https://odoo-community.org/psc-teams/real-estate-116).

    Best regards,

    -sbi

    On Mon, Nov 15, 2021 at 9:07 AM Raphaël Reverdy <raphael.reverdy@akretion.com> wrote:
    +1

    Le ven. 12 nov. 2021 à 15:57, Roussel, Denis <denis.roussel@acsone.eu> a écrit :

    Le ven. 12 nov. 2021 à 15:52, Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> a écrit :
    Not sure which is the PSC for that, but a valuable contributor like you is a sure +1

    Regards.

    _______________________________________________
    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



    --
    Raphaël Reverdy
    Mobile +33 6 38 02 03 93
    Fixe +33 4 82 53 84 60

    _______________________________________________
    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

    --
    Ignacio Ibeas
    Acysos S.L. (www.acysos.com)
    Odoo Partner (https://www.odoo.com/es_ES/partners/acysos-s-l-80090)
    Asociado Asociación Española de Odoo (https://www.aeodoo.org/members/acysos-s-l-24)
    Odoo Community Association (https://odoo-community.org/members/acysos-s-l-ignacio-ibeas-760)
    Github (http://www.github.com/acysos)
    Odoo Apps (https://www.odoo.com/apps/modules/browse?author=Acysos S.L.)
    C/ Miguel Astrain 18, 1º Oficina A
    31006 Pamplona, Navarra.
    ignacio@acysos.com
    Tel. 948238905
    ---------------------- // -------------------
    La información contenida en este mensaje de correo electrónico es
    confidencial, para ser leída por la(s) persona(s) a quién se dirige. El
    acceso a este mensaje por otras personas no está autorizado. Si Ud. no es la
    persona a la que va dirigido, cualquier divulgación, copia o distribución de
    la información queda prohibida y puede ser ilegal. Asimismo, cualquier acción
    tomada o dejada de tomar basada en la información contenida en este mensaje
    queda prohibida y puede ser ilegal.
    The information in this e-mail is confidential and may be legally privileged.
    It is intended solely for the addressee. Access to this e-mail by anyone is
    unauthorised. If you are not the intended recipient, any disclousure,
    copying, distribuition or any action taken or omited to be taken in reliance
    on it, is prohibited and may be unlawful.

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



    --

    Denis Roussel
    Software Engineer
    T    : +32 2 888 31 49
    M : +32 472 22 00 57


    Val Benoit, Quai Banning 6 | B-4000 Liège | Belgium
    Atrium Building, Drève Richelle 167 | B-1410 Waterloo | Belgium
    Zone industrielle 22 | L-8287 Kehlen | Luxembourg
    by Denis Roussel - 02:56 - 21 Nov 2021
  • Re: Inventory on a past date ?

    Clément,

    That sounds like it in a nutshell.

    I did bring up with Odoo support the possibility of allowing a stocktake in such a way, but got unfavourable responses.

    I find it peculiar, as I know from experience with large companies doing a full stock take, they may shut down to perform a count.

    Then they re-open for trading - but the count cards may take some time to be keyed in by operators, and verified.

    The system I developed previously did a freeze, as described, then allowed "first counts" and "second counts" to be keyed (independently so they would not see what was keyed on the first count) (some of our clients would send two teams out and cross count each others areas - important when there minor differences in stock and the counting staff might be temps who are unfamiliar with the product).

    The third count presented lines where there was a mismatch, requesting a check.  If after a third count, there was not a match of two the same, it came for a final report to intervenet what was going on...

    This could take a week to finalise.

    We have not been asked to replicate to this depth in Odoo, but certainly we've had more than one occasion where a client has needed to trade between counting and applying.

    Richard

    Richard deMeester

    Senior Development Analyst

    WilldooIT Pty Ltd

    E: richard.demeester@willdooit.com

    M: +61 403 76 76 76

    P: +61 3 9135 1900

    A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

     

     

    Making growth through technology easy

     

     

    DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

    From: Clément Mombereau <clement.mombereau@akretion.com.br>
    Sent: Friday, 19 November 2021 10:17 PM
    To: Contributors <contributors@odoo-community.org>
    Subject: Re: Inventory on a past date ?
     
    Thanks a lot Lois and Richard !

    Indeed, rewriting history looks very dangerous. Maybe if you are in standard cost method as you did with stock_account_inventory_force_date you achieve something not so bad without too much effort (even if I imagine it won't be trivial to migrate this module to v14 due to the big changes with the new stock.valuation.layer model)... but my client does not use the standard cost method (neither will someone who wants such an advanced feature on Inventory adjustment, i guess).

    But I really liked the strategy suggested by Richard. In fact, when talking with my client on how he would be able to do this "Inventory on past date" with the Odoo actual limits, we were exactly heading towards this idea... but manually at first.

    Thus the process without any development would be :
    1. He registers the physical inventory in Odoo on the day it is done, without double checking
    2. Few days later, he checks the stock changes made by this inventory adjustment. If he finds an error on some inventory lines already registered, he would have to :
        2.1. Check all the new product's stock.move since the inventory date and calculate the related product's quantity variation
        2.2. Make a new inventory adjustment for the correction, including this variation since the inventory.

    So yes, maybe I can make a small module which automates this calculation :
    - Adding a "past_date" field in stock.inventory main form
    - For each inventory line it would calculate the "old_past_qty_on_hand" for the related (product_id, lot_id, location_id), calculating the stock.move.line's variation for this triplet since past_date... (a bit like in stock_account_inventory_force_date's _get_inventory_lines_values)
    - When recording the Inventory lines, it would create an adjustment stock.move on today's date, but with a quantity of
          new_past_qty_on_hand - old_past_qty_on_hand + qty_variation_since_past_date

    Do you agree with this idea ?

    Thanks again!

    Abraço,
    Clément.

    Le ven. 19 nov. 2021 à 10:32, Lois Rilo Antelo <lois.rilo@forgeflow.com> a écrit :
    Hi Clement,

    You can have a look at this module https://github.com/OCA/stock-logistics-warehouse/tree/12.0/stock_account_inventory_force_date. It does not cover all the cases, if you do not use standard cost it can at least get you half the way. I'll be glad to review any improvement you can come up with.

    Best regards,

    El jue, 18 nov 2021 a las 17:12, Richard deMeester (<richard.demeester@willdooit.com>) escribió:

    Hi Clément.

    In older versions, we had a stock freeze function.

    You freeze the figures at the point in time you want to count them.  The adjustment is made when you apply (the stock moves need to be dated at the current date/time) but rather than comparing against the current on hand, we compare them against the frozen quantity.

    Example:

    Freeze quantity: 5
    Current quantity: 9
    Counted quantity: 4

    Stock adjustment is then for -1, creating a new onhand of 8

    Now, it should be possible to instead of having a freeze quantity, pick up the quantity on hand at a past time (with to_date in the context) and that would achieve the same result, in my quick thinking.

    But you really need the adjustment to be written as of now, not as at the past time.  It could screw up so much trying to backdate the move itself....

    Richard

    Richard deMeester

    Senior Development Analyst

    WilldooIT Pty Ltd

    E: richard.demeester@willdooit.com

    M: +61 403 76 76 76

    P: +61 3 9135 1900

    A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

     

     

    Making growth through technology easy

     

     

    DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

    From: Clément Mombereau <clement.mombereau@akretion.com.br>
    Sent: Friday, 19 November 2021 3:01 AM
    To: Contributors <contributors@odoo-community.org>
    Subject: Inventory on a past date ?
     
    Hello contributors,

    There is a few days delay between the moment the physical inventory is done at my client's warehouses and the moment he actually registers this inventory adjustment in Odoo.
    So he would like to make inventory adjustments on a past date (only a few days ago mainly).

    Anyone have an idea on how to achieve this ?

    There is this accounting_date on stock.inventory but it looks like it only forces the account.move's date related to the inventory adjustment.

    As far as I've understood the problem, when we click on Inventory's "action_start" it catches the  quants quantities... And a quant by definition can only shows the actual product quantity in stock.

    So instead, it would mean to recalculate the past stock.moves for each products, a bit like what is done with the _compute_quantities when clicking on "Inventory at date" in the Inventory Report menu... (the big difference with this "_compute_quantities" being that we would have to group the moves calculation by location_id and lot_id because we need to make these distinctions)

    Anyway, it does not look so easy at first glance. At least, would it be the good method to achieve this inventory on a past date?

    Thank you very much for your opinion on this topic! 🙏

    Abraço,
    Clément.

    _______________________________________________
    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



    --
    Lois Rilo Antelo
    Odoo consultant at ForgeFlow S.L.

    _______________________________________________
    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 "Richard deMeester" <richard.demeester@willdooit.com> - 12:36 - 19 Nov 2021

    2 attachments 2 attachments

    Outlook-erej1ktp.png
    Outlook-st01gprj.jpg
  • Re: Inventory on a past date ?
    Thanks a lot Lois and Richard !

    Indeed, rewriting history looks very dangerous. Maybe if you are in standard cost method as you did with stock_account_inventory_force_date you achieve something not so bad without too much effort (even if I imagine it won't be trivial to migrate this module to v14 due to the big changes with the new stock.valuation.layer model)... but my client does not use the standard cost method (neither will someone who wants such an advanced feature on Inventory adjustment, i guess).

    But I really liked the strategy suggested by Richard. In fact, when talking with my client on how he would be able to do this "Inventory on past date" with the Odoo actual limits, we were exactly heading towards this idea... but manually at first.

    Thus the process without any development would be :
    1. He registers the physical inventory in Odoo on the day it is done, without double checking
    2. Few days later, he checks the stock changes made by this inventory adjustment. If he finds an error on some inventory lines already registered, he would have to :
        2.1. Check all the new product's stock.move since the inventory date and calculate the related product's quantity variation
        2.2. Make a new inventory adjustment for the correction, including this variation since the inventory.

    So yes, maybe I can make a small module which automates this calculation :
    - Adding a "past_date" field in stock.inventory main form
    - For each inventory line it would calculate the "old_past_qty_on_hand" for the related (product_id, lot_id, location_id), calculating the stock.move.line's variation for this triplet since past_date... (a bit like in stock_account_inventory_force_date's _get_inventory_lines_values)
    - When recording the Inventory lines, it would create an adjustment stock.move on today's date, but with a quantity of
          new_past_qty_on_hand - old_past_qty_on_hand + qty_variation_since_past_date

    Do you agree with this idea ?

    Thanks again!

    Abraço,
    Clément.

    Le ven. 19 nov. 2021 à 10:32, Lois Rilo Antelo <lois.rilo@forgeflow.com> a écrit :
    Hi Clement,

    You can have a look at this module https://github.com/OCA/stock-logistics-warehouse/tree/12.0/stock_account_inventory_force_date. It does not cover all the cases, if you do not use standard cost it can at least get you half the way. I'll be glad to review any improvement you can come up with.

    Best regards,

    El jue, 18 nov 2021 a las 17:12, Richard deMeester (<richard.demeester@willdooit.com>) escribió:

    Hi Clément.

    In older versions, we had a stock freeze function.

    You freeze the figures at the point in time you want to count them.  The adjustment is made when you apply (the stock moves need to be dated at the current date/time) but rather than comparing against the current on hand, we compare them against the frozen quantity.

    Example:

    Freeze quantity: 5
    Current quantity: 9
    Counted quantity: 4

    Stock adjustment is then for -1, creating a new onhand of 8

    Now, it should be possible to instead of having a freeze quantity, pick up the quantity on hand at a past time (with to_date in the context) and that would achieve the same result, in my quick thinking.

    But you really need the adjustment to be written as of now, not as at the past time.  It could screw up so much trying to backdate the move itself....

    Richard

    Richard deMeester

    Senior Development Analyst

    WilldooIT Pty Ltd

    E: richard.demeester@willdooit.com

    M: +61 403 76 76 76

    P: +61 3 9135 1900

    A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

     

     

    Making growth through technology easy

     

     

    DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

    From: Clément Mombereau <clement.mombereau@akretion.com.br>
    Sent: Friday, 19 November 2021 3:01 AM
    To: Contributors <contributors@odoo-community.org>
    Subject: Inventory on a past date ?
     
    Hello contributors,

    There is a few days delay between the moment the physical inventory is done at my client's warehouses and the moment he actually registers this inventory adjustment in Odoo.
    So he would like to make inventory adjustments on a past date (only a few days ago mainly).

    Anyone have an idea on how to achieve this ?

    There is this accounting_date on stock.inventory but it looks like it only forces the account.move's date related to the inventory adjustment.

    As far as I've understood the problem, when we click on Inventory's "action_start" it catches the  quants quantities... And a quant by definition can only shows the actual product quantity in stock.

    So instead, it would mean to recalculate the past stock.moves for each products, a bit like what is done with the _compute_quantities when clicking on "Inventory at date" in the Inventory Report menu... (the big difference with this "_compute_quantities" being that we would have to group the moves calculation by location_id and lot_id because we need to make these distinctions)

    Anyway, it does not look so easy at first glance. At least, would it be the good method to achieve this inventory on a past date?

    Thank you very much for your opinion on this topic! 🙏

    Abraço,
    Clément.

    _______________________________________________
    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



    --
    Lois Rilo Antelo
    Odoo consultant at ForgeFlow S.L.

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

    by Clément Mombereau - 12:15 - 19 Nov 2021
  • Re: Inventory on a past date ?
    Hi Clement,

    You can have a look at this module https://github.com/OCA/stock-logistics-warehouse/tree/12.0/stock_account_inventory_force_date. It does not cover all the cases, if you do not use standard cost it can at least get you half the way. I'll be glad to review any improvement you can come up with.

    Best regards,

    El jue, 18 nov 2021 a las 17:12, Richard deMeester (<richard.demeester@willdooit.com>) escribió:

    Hi Clément.

    In older versions, we had a stock freeze function.

    You freeze the figures at the point in time you want to count them.  The adjustment is made when you apply (the stock moves need to be dated at the current date/time) but rather than comparing against the current on hand, we compare them against the frozen quantity.

    Example:

    Freeze quantity: 5
    Current quantity: 9
    Counted quantity: 4

    Stock adjustment is then for -1, creating a new onhand of 8

    Now, it should be possible to instead of having a freeze quantity, pick up the quantity on hand at a past time (with to_date in the context) and that would achieve the same result, in my quick thinking.

    But you really need the adjustment to be written as of now, not as at the past time.  It could screw up so much trying to backdate the move itself....

    Richard

    Richard deMeester

    Senior Development Analyst

    WilldooIT Pty Ltd

    E: richard.demeester@willdooit.com

    M: +61 403 76 76 76

    P: +61 3 9135 1900

    A: 10/435 Williamstown Road, Port Melbourne, Vic 3207

     

     

    Making growth through technology easy

     

     

    DISCLAIMER | This electronic message together with any attachments is confidential. If you are not the recipient, do not copy, disclose, or use the contents in any way. Please also advise us by e-mail that you have received this message in error and then please destroy this email and any of its attachments. WilldooIT Pty. Ltd. is not responsible for any changes made to this message and/or any attachments after sending by WilldooIT Pty. Ltd. WilldooIT Pty. Ltd. use virus scanning software but exclude all liability for virus or anything similar in this email or attachment.

    From: Clément Mombereau <clement.mombereau@akretion.com.br>
    Sent: Friday, 19 November 2021 3:01 AM
    To: Contributors <contributors@odoo-community.org>
    Subject: Inventory on a past date ?
     
    Hello contributors,

    There is a few days delay between the moment the physical inventory is done at my client's warehouses and the moment he actually registers this inventory adjustment in Odoo.
    So he would like to make inventory adjustments on a past date (only a few days ago mainly).

    Anyone have an idea on how to achieve this ?

    There is this accounting_date on stock.inventory but it looks like it only forces the account.move's date related to the inventory adjustment.

    As far as I've understood the problem, when we click on Inventory's "action_start" it catches the  quants quantities... And a quant by definition can only shows the actual product quantity in stock.

    So instead, it would mean to recalculate the past stock.moves for each products, a bit like what is done with the _compute_quantities when clicking on "Inventory at date" in the Inventory Report menu... (the big difference with this "_compute_quantities" being that we would have to group the moves calculation by location_id and lot_id because we need to make these distinctions)

    Anyway, it does not look so easy at first glance. At least, would it be the good method to achieve this inventory on a past date?

    Thank you very much for your opinion on this topic! 🙏

    Abraço,
    Clément.

    _______________________________________________
    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



    --
    Lois Rilo Antelo
    Odoo consultant at ForgeFlow S.L.
    by Lois Rilo Antelo - 10:30 - 19 Nov 2021
  • Re: Discount on a separate account move line for odoo v14+
    Hi everyone
    Some news from paradise, I confirm that this thread is to trash away... 
    The expert accountant of our customer here was wrong...
    Sorry for the noise and thank you for your answers...

    -- 

    Best Regards/Cordialement
    --------------------------------
    Cyril VINH-TUNG
    INVITU Computer & Network Engineering
    BP 32 - 98713 Papeete - French Polynesia
    Tél: +689 40 46 11 99 contact@invitu.com www.invitu.com

    P Please consider the environment before printing this e-mail!

       

    Le jeu. 18 nov. 2021 à 11:52, Alexis de Lattre <alexis.delattre@akretion.com> a écrit :
    Dear Cyril,

    My understanding is that, in the French chart of account, account 709 is only for a very specific scenario, when you generate a customer refund after the initial customer invoice to compensate for a defect of the product for exemple.

    This page explains it very well:

    A regular "discount" on a customer invoice line will go to the 707 account (no separation of the discount and the regular price).

    Regards,

    Alexis


    Le jeu. 18 nov. 2021 à 19:26, Cyril VINH-TUNG <cyril@invitu.com> a écrit :
    Thank you Daniel, yes discount might be in separate lines with specific products... but in case of percentage discount, we need to calculate each line and add a new line for every line in the invoice
    It might result into a twice big general ledger.
    The same behavior as taxes would be the best solution but with dynamic percentage... and specific account according to the main account
    I am sure that French Guys like Akretion, C2C or Acsone already had that question because it's France specific to french account chart


    -- 

    Best Regards/Cordialement
    --------------------------------
    Cyril VINH-TUNG
    INVITU Computer & Network Engineering
    BP 32 - 98713 Papeete - French Polynesia
    Tél: +689 40 46 11 99 contact@invitu.com www.invitu.com

    P Please consider the environment before printing this e-mail!


    Le jeu. 18 nov. 2021 à 07:52, Daniel Reis <dreis@opensourceintegrators.com> a écrit :
    Hello Cyrill,

If it is viable to have the discount in a separate line, that would be a 
configuration only solution.

Thanks
Daniel


On 18/11/21 16:52, Cyril VINH-TUNG wrote:




> Dear all




> The accountant experts here in French Polynesia ask to split the 




> discount to a separate account. For example, 707 account is used for 




> the product sale and 709 account is used for discount.




> Use case :




> Product is sold 1000 EUR with 10% discount and 20% VAT.




> Product sale (707) : 1000 credit




> Discount (709) : 100 debit




> VAT (4457) : 180 credit




> Customer (411) : 1080 debit




> Does anybody has a solution for this ?




> Thank you and Best Regards




> Cyril




>




> _______________________________________________




> 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

    _______________________________________________
    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 Cyril VINH-TUNG - 05:36 - 19 Nov 2021
  • Re: Discount on a separate account move line for odoo v14+
    Dear Alexis, thank you for your link.
    In our case, it's a discount that is for a reseller that does a markup. It's a very common business and finally, I wonder if the accounting expert who asks that is right or wrong...
    I will ask to others accounting experts that I know...

    -- 

    Best Regards/Cordialement
    --------------------------------
    Cyril VINH-TUNG
    INVITU Computer & Network Engineering
    BP 32 - 98713 Papeete - French Polynesia
    Tél: +689 40 46 11 99 contact@invitu.com www.invitu.com

    P Please consider the environment before printing this e-mail!

       

    Le jeu. 18 nov. 2021 à 11:52, Alexis de Lattre <alexis.delattre@akretion.com> a écrit :
    Dear Cyril,

    My understanding is that, in the French chart of account, account 709 is only for a very specific scenario, when you generate a customer refund after the initial customer invoice to compensate for a defect of the product for exemple.

    This page explains it very well:

    A regular "discount" on a customer invoice line will go to the 707 account (no separation of the discount and the regular price).

    Regards,

    Alexis


    Le jeu. 18 nov. 2021 à 19:26, Cyril VINH-TUNG <cyril@invitu.com> a écrit :
    Thank you Daniel, yes discount might be in separate lines with specific products... but in case of percentage discount, we need to calculate each line and add a new line for every line in the invoice
    It might result into a twice big general ledger.
    The same behavior as taxes would be the best solution but with dynamic percentage... and specific account according to the main account
    I am sure that French Guys like Akretion, C2C or Acsone already had that question because it's France specific to french account chart


    -- 

    Best Regards/Cordialement
    --------------------------------
    Cyril VINH-TUNG
    INVITU Computer & Network Engineering
    BP 32 - 98713 Papeete - French Polynesia
    Tél: +689 40 46 11 99 contact@invitu.com www.invitu.com

    P Please consider the environment before printing this e-mail!


    Le jeu. 18 nov. 2021 à 07:52, Daniel Reis <dreis@opensourceintegrators.com> a écrit :
    Hello Cyrill,

If it is viable to have the discount in a separate line, that would be a 
configuration only solution.

Thanks
Daniel


On 18/11/21 16:52, Cyril VINH-TUNG wrote:




> Dear all




> The accountant experts here in French Polynesia ask to split the 




> discount to a separate account. For example, 707 account is used for 




> the product sale and 709 account is used for discount.




> Use case :




> Product is sold 1000 EUR with 10% discount and 20% VAT.




> Product sale (707) : 1000 credit




> Discount (709) : 100 debit




> VAT (4457) : 180 credit




> Customer (411) : 1080 debit




> Does anybody has a solution for this ?




> Thank you and Best Regards




> Cyril




>




> _______________________________________________




> 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

    _______________________________________________
    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 Cyril VINH-TUNG - 12:41 - 19 Nov 2021
  • Re: Discount on a separate account move line for odoo v14+
    Dear Cyril,

    My understanding is that, in the French chart of account, account 709 is only for a very specific scenario, when you generate a customer refund after the initial customer invoice to compensate for a defect of the product for exemple.

    This page explains it very well:

    A regular "discount" on a customer invoice line will go to the 707 account (no separation of the discount and the regular price).

    Regards,

    Alexis


    Le jeu. 18 nov. 2021 à 19:26, Cyril VINH-TUNG <cyril@invitu.com> a écrit :
    Thank you Daniel, yes discount might be in separate lines with specific products... but in case of percentage discount, we need to calculate each line and add a new line for every line in the invoice
    It might result into a twice big general ledger.
    The same behavior as taxes would be the best solution but with dynamic percentage... and specific account according to the main account
    I am sure that French Guys like Akretion, C2C or Acsone already had that question because it's France specific to french account chart


    -- 

    Best Regards/Cordialement
    --------------------------------
    Cyril VINH-TUNG
    INVITU Computer & Network Engineering
    BP 32 - 98713 Papeete - French Polynesia
    Tél: +689 40 46 11 99 contact@invitu.com www.invitu.com

    P Please consider the environment before printing this e-mail!


    Le jeu. 18 nov. 2021 à 07:52, Daniel Reis <dreis@opensourceintegrators.com> a écrit :
    Hello Cyrill,

If it is viable to have the discount in a separate line, that would be a 
configuration only solution.

Thanks
Daniel


On 18/11/21 16:52, Cyril VINH-TUNG wrote:



> Dear all



> The accountant experts here in French Polynesia ask to split the 



> discount to a separate account. For example, 707 account is used for 



> the product sale and 709 account is used for discount.



> Use case :



> Product is sold 1000 EUR with 10% discount and 20% VAT.



> Product sale (707) : 1000 credit



> Discount (709) : 100 debit



> VAT (4457) : 180 credit



> Customer (411) : 1080 debit



> Does anybody has a solution for this ?



> Thank you and Best Regards



> Cyril



>



> _______________________________________________



> 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

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

    by Alexis de Lattre - 10:51 - 18 Nov 2021