Skip to Content
  2. Mailing Lists
  3. Contributors

Archives

  • punchout and cxml 
    Hello

One of our customers would like to have his Odoo instance available 
through "punchout", possibly using cXML

"""
PunchOut is not a link to a web site. PunchOut is an easy-to-implement 
protocol for interactive sessions managed across the Internet. PunchOut 
is a communication from one application to another, achieved through a 
dialog of real-time, synchronous cXML messages, which support user 
interaction at a remote site. It is the best way to manage user sessions 
distributed across web applications.

This protocol is most commonly used today in the form of Procurement 
PunchOut, which specifically supports interactions between a procurement 
application and a supplier’s eCommerce web site and possibly includes an 
intermediary for authentication and version matching. Procurement 
PunchOut describes the "traditional" PunchOut scenarios that use the 
regular PunchOut Setup Request and PunchOut Setup Response. The PunchOut 
session is initiated with a PunchOutSetupRequest and terminates with a 
posting of a PunchOutOrderMessage, which contains the initiating 
transaction’s cookie and a shopping cart or “quote”.
"""
(http://cxml.org/faq.html)

Anyone already faced a similar requirement?

Thanks for your feedback



-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.com
    by Alexandre Fayolle - 10:14 - 28 Apr 2021
  • Special way of searching for products 
    Hello,

I have been asked few times by users if it is possible to search for products 
in a way omitting special characters (like dash or space for exmaple) from 
product's default_code (or even input string). Let me give an example:

Let's say we have a product with default_code like CD-12345-XYZ In current 
situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice 
versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 
12345" nothing is retrieved either. So the solution would be to first remove 
those special characters from the string being searched for and then search 
for default_code transformed with some (SQL?) function.

Is anything like that possible? One idea comes to mind using computed field 
where that stripped deault_code would be stored and extending default search 
to use this. However that would require stored computed field. Any way to 
prevent this?

Thank you. Best regards

	Radovan Skolnik
    by Radovan Skolnik - 10:14 - 28 Apr 2021

    6 replies 6 replies

    • Re: Special way of searching for products
      Hi Radovan,

      I had a similar problem in my company. I partially solved it by developping some module like https://github.com/grap/grap-odoo-incubator/tree/12.0/multi_search_product
      Basically, I say to the user to don't enter special char.
      In your exemple, searching "CD*12345" will return all product containing "CD" and "12345" in any order.

      Maybe it can help you.

      Note : the wildcard caracter "*" is a global setting that can be changed.

      Kind regards.



      Sylvain LE GAL - Twitter
      GRAP - Service informatique (Groupement Régional Alimentaire de Proximité)
      Site Web | FramaSphere | Facebook
      3 Grande rue des Feuillants, 69001 Lyon
      Standard : (+33) 09.72.32.33.17
      Service Informatique : (+33) 09.73.79.64.40
      Astreinte Informatique : (+33) 06.81.85.61.43
      Member of the OCA (Odoo Community Association)


      Le jeu. 29 avr. 2021 à 11:32, Graeme Gellatly <gdgellatly@gmail.com> a écrit :
      Well if you can't use trigram, you need to suffer the performance penalty of using Btree indexes for openended text searches. You could partially mitigate by sanitizing to just lowercase and using a like search rather than ilike but probably only worth it for 25k+ products by the time you massage inputs.

      But odoo.sh lets you connect via psql, so you can try. pg_trgm is bundled in contrib, same as pg_unaccent so should be there. Just whether you have rights to create extensions.


      On Thu, Apr 29, 2021 at 9:07 PM Radovan Skolnik <radovan@skolnik.info> wrote:
      Graeme,

thanx for input. This part of your email caught my attention:




> Stored computed sanitized code, then sanitize search args on way in. Trigram



> index that stored field

Stored computed sanitized code - no problem. I can do that and had that in 
mind.

Sanitize search args on way in - you say search for bank accounts shows how to 
do this? Will check that out.

Trigram index that stored field - I am on odoo.sh not sure if that is possible 
there. However if I am able to sanitize both stored code and input that should 
generally be enough. I am looking specifcally to work with internal reference 
(default_code) so no need to handle cases like "Red Cat" or "Cat Red" although 
it would nice also.

Best regards

	Radovan Skolnik

On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote:



> I've done this for years in one way or another. OCA does have trgm module



> which allows similarity search but for most use cases I find mostly the



> issue is one of order of search terms.  Product search is particularly



> sucky because it has all sorts of overrides. This is in general my simple



> approach.



> 1. Install pg_trgm or else you will feel the pain. 2. Override search and



> split the name argument into multiple ilikes. In my case I typically split



> on spaces, which means users can search "Red Car" or "Car Red" and get same



> result. I do it on spaces only. I know you want to avoid but actually for



> your use case you are better just copying the way bank accounts are



> sanitized and searched. Stored computed sanitized code, then sanitize



> search args on way in. Trigram index that stored field On Thu, Apr 29, 2021



> at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few



> ideas based on postgresql:



> * not sure if it's possible with SIMILAR TO or ~ operators



> * investigate extension   * fuzzystrmatch:



> https://www.postgresql.org/docs/13/fuzzystrmatch.html [2]    * pgtrgm:



> https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3]  *



> create your own unaccent rules:



> https://www.postgresql.org/docs/current/unaccent.html [4] regards,



> Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a



> écrit : Hello,



> I have been asked few times by users if it is possible to search for



> products in a way omitting special characters (like dash or space for



> exmaple) from product's default_code (or even input string). Let me give an



> example: Let's say we have a product with default_code like CD-12345-XYZ In



> current situation if user enteres "CD12345" or "CD 12345" nothing is



> retrieved. Vice versa, if the default_code is CD12345XYZ and user enters



> "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would



> be to first remove those special characters from the string being searched



> for and then search for default_code transformed with some (SQL?) function.



> Is anything like that possible? One idea comes to mind using computed field



> where that stripped deault_code would be stored and extending default search



> to use this. However that would require stored computed field. Any way to



> prevent this?



> Thank you. Best regards



> Radovan Skolnik



> 



> 



> _______________________________________________



> Mailing-List: https://odoo-community.org/groups/contributors-15 [6]



> Post to: mailto: contributors@odoo-community.org [7]



> Unsubscribe: https://odoo-community.org/groups?unsubscribe [8]



> 



> --



> Pierre



> 



> _______________________________________________



> Mailing-List: https://odoo-community.org/groups/contributors-15 [9]



> Post to: mailto: contributors@odoo-community.org [10]



> Unsubscribe: https://odoo-community.org/groups?unsubscribe [11]



> 



> 



> _______________________________________________



> Mailing-List: https://odoo-community.org/groups/contributors-15 [12]



> Post to: mailto:contributors@odoo-community.org



> Unsubscribe: https://odoo-community.org/groups?unsubscribe [13]



> 



> 



> 



> [1] mailto:pierreverkest84@gmail.com



> [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html



> [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6



> [4] https://www.postgresql.org/docs/current/unaccent.html



> [5] mailto:radovan@skolnik.info



> [6] https://odoo-community.org/groups/contributors-15



> [7] mailto:contributors@odoo-community.org



> [8] https://odoo-community.org/groups?unsubscribe



> [9] https://odoo-community.org/groups/contributors-15



> [10] mailto:contributors@odoo-community.org



> [11] https://odoo-community.org/groups?unsubscribe



> [12] https://odoo-community.org/groups/contributors-15



> [13] 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 Sylvain LE GAL - 11:55 - 29 Apr 2021
    • Re: Special way of searching for products
      Well if you can't use trigram, you need to suffer the performance penalty of using Btree indexes for openended text searches. You could partially mitigate by sanitizing to just lowercase and using a like search rather than ilike but probably only worth it for 25k+ products by the time you massage inputs.

      But odoo.sh lets you connect via psql, so you can try. pg_trgm is bundled in contrib, same as pg_unaccent so should be there. Just whether you have rights to create extensions.


      On Thu, Apr 29, 2021 at 9:07 PM Radovan Skolnik <radovan@skolnik.info> wrote:
      Graeme,

thanx for input. This part of your email caught my attention:



> Stored computed sanitized code, then sanitize search args on way in. Trigram


> index that stored field

Stored computed sanitized code - no problem. I can do that and had that in 
mind.

Sanitize search args on way in - you say search for bank accounts shows how to 
do this? Will check that out.

Trigram index that stored field - I am on odoo.sh not sure if that is possible 
there. However if I am able to sanitize both stored code and input that should 
generally be enough. I am looking specifcally to work with internal reference 
(default_code) so no need to handle cases like "Red Cat" or "Cat Red" although 
it would nice also.

Best regards

	Radovan Skolnik

On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote:


> I've done this for years in one way or another. OCA does have trgm module


> which allows similarity search but for most use cases I find mostly the


> issue is one of order of search terms.  Product search is particularly


> sucky because it has all sorts of overrides. This is in general my simple


> approach.


> 1. Install pg_trgm or else you will feel the pain. 2. Override search and


> split the name argument into multiple ilikes. In my case I typically split


> on spaces, which means users can search "Red Car" or "Car Red" and get same


> result. I do it on spaces only. I know you want to avoid but actually for


> your use case you are better just copying the way bank accounts are


> sanitized and searched. Stored computed sanitized code, then sanitize


> search args on way in. Trigram index that stored field On Thu, Apr 29, 2021


> at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few


> ideas based on postgresql:


> * not sure if it's possible with SIMILAR TO or ~ operators


> * investigate extension   * fuzzystrmatch:


> https://www.postgresql.org/docs/13/fuzzystrmatch.html [2]    * pgtrgm:


> https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3]  *


> create your own unaccent rules:


> https://www.postgresql.org/docs/current/unaccent.html [4] regards,


> Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a


> écrit : Hello,


> I have been asked few times by users if it is possible to search for


> products in a way omitting special characters (like dash or space for


> exmaple) from product's default_code (or even input string). Let me give an


> example: Let's say we have a product with default_code like CD-12345-XYZ In


> current situation if user enteres "CD12345" or "CD 12345" nothing is


> retrieved. Vice versa, if the default_code is CD12345XYZ and user enters


> "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would


> be to first remove those special characters from the string being searched


> for and then search for default_code transformed with some (SQL?) function.


> Is anything like that possible? One idea comes to mind using computed field


> where that stripped deault_code would be stored and extending default search


> to use this. However that would require stored computed field. Any way to


> prevent this?


> Thank you. Best regards


> Radovan Skolnik


> 


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15 [6]


> Post to: mailto: contributors@odoo-community.org [7]


> Unsubscribe: https://odoo-community.org/groups?unsubscribe [8]


> 


> --


> Pierre


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15 [9]


> Post to: mailto: contributors@odoo-community.org [10]


> Unsubscribe: https://odoo-community.org/groups?unsubscribe [11]


> 


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15 [12]


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe [13]


> 


> 


> 


> [1] mailto:pierreverkest84@gmail.com


> [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html


> [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6


> [4] https://www.postgresql.org/docs/current/unaccent.html


> [5] mailto:radovan@skolnik.info


> [6] https://odoo-community.org/groups/contributors-15


> [7] mailto:contributors@odoo-community.org


> [8] https://odoo-community.org/groups?unsubscribe


> [9] https://odoo-community.org/groups/contributors-15


> [10] mailto:contributors@odoo-community.org


> [11] https://odoo-community.org/groups?unsubscribe


> [12] https://odoo-community.org/groups/contributors-15


> [13] 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 - 11:31 - 29 Apr 2021
    • Re: Special way of searching for products 
      Graeme,

thanx for input. This part of your email caught my attention:


> Stored computed sanitized code, then sanitize search args on way in. Trigram

> index that stored field

Stored computed sanitized code - no problem. I can do that and had that in 
mind.

Sanitize search args on way in - you say search for bank accounts shows how to 
do this? Will check that out.

Trigram index that stored field - I am on odoo.sh not sure if that is possible 
there. However if I am able to sanitize both stored code and input that should 
generally be enough. I am looking specifcally to work with internal reference 
(default_code) so no need to handle cases like "Red Cat" or "Cat Red" although 
it would nice also.

Best regards

	Radovan Skolnik

On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote:

> I've done this for years in one way or another. OCA does have trgm module

> which allows similarity search but for most use cases I find mostly the

> issue is one of order of search terms.  Product search is particularly

> sucky because it has all sorts of overrides. This is in general my simple

> approach.

> 1. Install pg_trgm or else you will feel the pain. 2. Override search and

> split the name argument into multiple ilikes. In my case I typically split

> on spaces, which means users can search "Red Car" or "Car Red" and get same

> result. I do it on spaces only. I know you want to avoid but actually for

> your use case you are better just copying the way bank accounts are

> sanitized and searched. Stored computed sanitized code, then sanitize

> search args on way in. Trigram index that stored field On Thu, Apr 29, 2021

> at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few

> ideas based on postgresql:

> * not sure if it's possible with SIMILAR TO or ~ operators

> * investigate extension   * fuzzystrmatch:

> https://www.postgresql.org/docs/13/fuzzystrmatch.html [2]    * pgtrgm:

> https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3]  *

> create your own unaccent rules:

> https://www.postgresql.org/docs/current/unaccent.html [4] regards,

> Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a

> écrit : Hello,

> I have been asked few times by users if it is possible to search for

> products in a way omitting special characters (like dash or space for

> exmaple) from product's default_code (or even input string). Let me give an

> example: Let's say we have a product with default_code like CD-12345-XYZ In

> current situation if user enteres "CD12345" or "CD 12345" nothing is

> retrieved. Vice versa, if the default_code is CD12345XYZ and user enters

> "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would

> be to first remove those special characters from the string being searched

> for and then search for default_code transformed with some (SQL?) function.

> Is anything like that possible? One idea comes to mind using computed field

> where that stripped deault_code would be stored and extending default search

> to use this. However that would require stored computed field. Any way to

> prevent this?

> Thank you. Best regards

> Radovan Skolnik

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [6]

> Post to: mailto: contributors@odoo-community.org [7]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [8]

> 

> --

> Pierre

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [9]

> Post to: mailto: contributors@odoo-community.org [10]

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [11]

> 

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 [12]

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe [13]

> 

> 

> 

> [1] mailto:pierreverkest84@gmail.com

> [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html

> [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6

> [4] https://www.postgresql.org/docs/current/unaccent.html

> [5] mailto:radovan@skolnik.info

> [6] https://odoo-community.org/groups/contributors-15

> [7] mailto:contributors@odoo-community.org

> [8] https://odoo-community.org/groups?unsubscribe

> [9] https://odoo-community.org/groups/contributors-15

> [10] mailto:contributors@odoo-community.org

> [11] https://odoo-community.org/groups?unsubscribe

> [12] https://odoo-community.org/groups/contributors-15

> [13] https://odoo-community.org/groups?unsubscribe
      by Radovan Skolnik - 11:06 - 29 Apr 2021
    • Re: Special way of searching for products
      I've done this for years in one way or another. OCA does have trgm module which allows similarity search but for most use cases I find mostly the issue is one of order of search terms.  Product search is particularly sucky because it has all sorts of overrides.

      This is in general my simple approach.

      1. Install pg_trgm or else you will feel the pain.
      2. Override search and split the name argument into multiple ilikes. In my case I typically split on spaces, which means users can search "Red Car" or "Car Red" and get same result. I do it on spaces only.

      I know you want to avoid but actually for your use case you are better just copying the way bank accounts are sanitized and searched. Stored computed sanitized code, then sanitize search args on way in. Trigram index that stored field

      On Thu, Apr 29, 2021 at 9:42 AM Pierre Verkest <pierreverkest84@gmail.com> wrote:
      Few ideas based on postgresql:

      * not sure if it's possible with SIMILAR TO or ~ operators
      * investigate extension

      regards,

      Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :
      Hello,

I have been asked few times by users if it is possible to search for products 
in a way omitting special characters (like dash or space for exmaple) from 
product's default_code (or even input string). Let me give an example:

Let's say we have a product with default_code like CD-12345-XYZ In current 
situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice 
versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 
12345" nothing is retrieved either. So the solution would be to first remove 
those special characters from the string being searched for and then search 
for default_code transformed with some (SQL?) function.

Is anything like that possible? One idea comes to mind using computed field 
where that stripped deault_code would be stored and extending default search 
to use this. However that would require stored computed field. Any way to 
prevent this?

Thank you. Best regards

	Radovan Skolnik

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



      --
      Pierre

      _______________________________________________
      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 - 01:00 - 29 Apr 2021
    • Re: Special way of searching for products
      "Similar to" operator is the % sign.
      You can train users to use it, but I don't think this is what they are expecting.

      PostgreSQL fuzzy matching might work.
      You can try https://odoo-community.org/shop/product/fuzzy-search-698

      Or, you can add a stored computed field to use for search, that copies the product code removing special character.
      Then use that field as the search target.

      /Daniel


      On 28/04/2021 22:41, Pierre Verkest wrote:
      Few ideas based on postgresql:

      * not sure if it's possible with SIMILAR TO or ~ operators
      * investigate extension

      regards,

      Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :
      Hello,

I have been asked few times by users if it is possible to search for products 
in a way omitting special characters (like dash or space for exmaple) from 
product's default_code (or even input string). Let me give an example:

Let's say we have a product with default_code like CD-12345-XYZ In current 
situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice 
versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 
12345" nothing is retrieved either. So the solution would be to first remove 
those special characters from the string being searched for and then search 
for default_code transformed with some (SQL?) function.

Is anything like that possible? One idea comes to mind using computed field 
where that stripped deault_code would be stored and extending default search 
to use this. However that would require stored computed field. Any way to 
prevent this?

Thank you. Best regards

	Radovan Skolnik

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



      --
      Pierre

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


      --
      Daniel Reis
      Managing Director
      M: +351 919991307
      E: DReis@OpenSourceIntegrators.com
      Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


      by Daniel Reis - 12:11 - 29 Apr 2021

  • Following the bank statement changes in v14
    Dear OCA friends,

    Now that most of the key OCA accounting modules are ported to Odoo v14 and that the features that were moved to Odoo Enterprise have been restored in OCA (account_reconciliation_widget in OCA/account-reconcile and account_statement_import in OCA/bank-statement-import), I'm starting to do some real life end-to-end accounting scenarios in Odoo Community v14.

    The scenario I'm currently testing is the following:
    - create several vendor bills
    - add vendor bills to payment order
    - confirm SEPA payment order
    - import bank statement with 1 statement line with total amount of payment

    In previous odoo version, if the payment mode was configured with "offsetting_account" = "bank_account", it would generate an account move with the bank account as counterpart account ; and then, in the bank statement reconcile interface, you would match with a proposed blue line and it would not create a new account move but it would update the account move generated by the payment order and link it to the bank statement line.

    As far as I understand (please correct me if I'm wrong !), this accounting scenario is not possible in Odoo v14. According to my tests on runbot Enterprise, when you are in the bank statement reconcile interface, you can still see blue lines in the proposals, but selecting blue lines will generate a new journal entry, it won't update the journal entry of the payment.

    In short, the accounting scenario of vendor bill => SEPA payment => bank statement :
    - with Odoo v9 to v13 with "offsetting_account" = "bank_account" : expense account => supplier account => bank account (total : 3 accounts)
    - with odoo v14 : expense account => supplier account => Outstanding Payments Account => bank account (total : 4 accounts)
    So the accounting scenario is similar to what we used to do in v8 with the transfer account (now named "Outstanding Payments Account") before the introduction of the concept of "blue lines" on the bank statement reconcile interface.

    If this is confirmed, I plan to update the following OCA modules:
    - account_payment_order from OCA/bank-payment : remove the fields "offsetting_account" and "transfer_account_id" on account.payment.mode. We would keep the field "transfer_journal_id" because you may want to have the journal entry "supplier account => Outstanding Payments Account" in a specific journal that may not be the bank journal.
    - on account_check_deposit in OCA/account-financial-tools (pending PR https://github.com/OCA/account-financial-tools/pull/1088) : remove the fields "check_deposit_offsetting_account" and "check_deposit_transfer_account_id" on res.company.

    As these are important changes, I prefer to post this message before modifying the code.

    And I made a PR to remove the condition payment_id != false on account.move.line in the module account_reconciliation_widget:

    --
    Alexis de Lattre
    by Alexis de Lattre - 10:13 - 28 Apr 2021

    1 replies 1 replies

    • Re: Following the bank statement changes in v14
      As this message was blocked during several days, I copied it on this github issue : https://github.com/OCA/bank-payment/issues/740
      Please refer to the conversion that took place there. The module account_check_deposit has already been updated ; the account_payment_order module will be updated soon.

      Le mer. 21 avr. 2021 à 21:28, Alexis de Lattre <alexis.delattre@akretion.com> a écrit :
      Dear OCA friends,

      Now that most of the key OCA accounting modules are ported to Odoo v14 and that the features that were moved to Odoo Enterprise have been restored in OCA (account_reconciliation_widget in OCA/account-reconcile and account_statement_import in OCA/bank-statement-import), I'm starting to do some real life end-to-end accounting scenarios in Odoo Community v14.

      The scenario I'm currently testing is the following:
      - create several vendor bills
      - add vendor bills to payment order
      - confirm SEPA payment order
      - import bank statement with 1 statement line with total amount of payment

      In previous odoo version, if the payment mode was configured with "offsetting_account" = "bank_account", it would generate an account move with the bank account as counterpart account ; and then, in the bank statement reconcile interface, you would match with a proposed blue line and it would not create a new account move but it would update the account move generated by the payment order and link it to the bank statement line.

      As far as I understand (please correct me if I'm wrong !), this accounting scenario is not possible in Odoo v14. According to my tests on runbot Enterprise, when you are in the bank statement reconcile interface, you can still see blue lines in the proposals, but selecting blue lines will generate a new journal entry, it won't update the journal entry of the payment.

      In short, the accounting scenario of vendor bill => SEPA payment => bank statement :
      - with Odoo v9 to v13 with "offsetting_account" = "bank_account" : expense account => supplier account => bank account (total : 3 accounts)
      - with odoo v14 : expense account => supplier account => Outstanding Payments Account => bank account (total : 4 accounts)
      So the accounting scenario is similar to what we used to do in v8 with the transfer account (now named "Outstanding Payments Account") before the introduction of the concept of "blue lines" on the bank statement reconcile interface.

      If this is confirmed, I plan to update the following OCA modules:
      - account_payment_order from OCA/bank-payment : remove the fields "offsetting_account" and "transfer_account_id" on account.payment.mode. We would keep the field "transfer_journal_id" because you may want to have the journal entry "supplier account => Outstanding Payments Account" in a specific journal that may not be the bank journal.
      - on account_check_deposit in OCA/account-financial-tools (pending PR https://github.com/OCA/account-financial-tools/pull/1088) : remove the fields "check_deposit_offsetting_account" and "check_deposit_transfer_account_id" on res.company.

      As these are important changes, I prefer to post this message before modifying the code.

      And I made a PR to remove the condition payment_id != false on account.move.line in the module account_reconciliation_widget:

      --
      Alexis de Lattre


      --
      Alexis de Lattre
      Akretion France - 27 rue Henri Rolland - 69100 Villeurbanne - France
      Mail : alexis.delattre@akretion.com
      Mobile : +33 6 99 08 92 45
      by Alexis de Lattre - 09:20 - 30 Apr 2021
  • By pass security rule on some situation.
    Dear community,

    I want to bypass some field model's security rule. So far, we pass context to tell search/read function to use sudo().

    But I found this module as the solution we need https://apps.odoo.com/apps/modules/10.0/dynamic_bypass_record_rule/

    May to double check if community already has something already, else I will ask the author to include it in OCA.

    Thanks!
    Kitti U.
    by Kitti Upariphutthiphong - 10:13 - 28 Apr 2021

    3 replies 3 replies

  • Migration new api sentry - server-tools
    Hi everyone!

    A few months ago I made following PR:


    In order to migrate to new api sentry in v12, however I think that we need to discuss if that migration should be in a new module or keep it in the same module, last option is considering that some parameters no longer exist in migration (such sentry_transport and sentry_processors).

    I look forward to your comments.

    Regards
    by "Fernanda Hernández" <fernanda@vauxoo.com> - 10:12 - 28 Apr 2021
  • multichannel sales with different marketplaces 
    Hello,

I'm in contact with a german company who would like to interface Odoo 
with different marketplaces, such as amazon, ebay but also local german 
actors. I don't have yet a full list, and the list is likely to evolve 
over time anyway, so I would not like to use 1 connector backend per 
marketplace...

I think the most cost effective approach would be to use a 3rd party 
broker which would take care of the nitty gritty details and present 
Odoo with a single, unified interface. I think lengow does this, and we 
have a connector_lengow project in the OCA repositories.

I'm happy to hear some feedback (on the lengow connector, or on using a 
broker for this purpose), doubtless some of you already had to walk this 
path.

Thanks


-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.com
    by Alexandre Fayolle - 12:11 - 15 Apr 2021

    4 replies 4 replies

    • Re: multichannel sales with different marketplaces 
      Thanks Xavier for your feedback I'll keep this in mind.

Alexandre

On 15/04/2021 13:16, Xavier Brochard wrote:

> Hello

> 

> Using a multi-channel dispatcher is the best option, as it is allways

> very complicated to handle all the marketplaces that you need in Odoo.

> It is exactly like using a multi shipping provider.

> 

> Lengow is only for big companies wich sells lot of products.

> 

> We work with Iziflux, a french multi-channel feed (a «broker» as you

> said, one can see it as a dispatcher). Price is really cheap compared to

> Lengow and you can start with, for example, 100 products. There is a lot

> of multi-channel feeders. Local feeders are recommended at there is also

> a lot of local marketplaces.

> 

> We have asked it-projects (Yelizariev's company) to code a connector

> Odoo 13 - Iziflux. It works well and we would like to release it as GPL.

> 

> However, a simpler module would be good enough for starting as nearly

> all multi-channel feeds can handle CSV files. It would work as follow :

> - check products to sell

> - check require fields and transform format

> And a cron job would

> - CSV product and stock

> - CSV stored in dedicated directory

> - ftp your CSV to the multichannel feed (some multichannel feeds will

> directly take it)

> - ftp the multichannel CSV (sales)

> - CSV sale import

> Such a general module could be immediatly usable with every

> multi-channel feed as soon as you will setup the fields and adapt

> formats.

> 

> If you need to search for multi channel providers, use these keywords :

> multi-channel, feed, connector, flux

> 

> ---

> Librement,

> Xavier Brochard xavier@alternatif.org

> La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre

> Rosnay)

> 

> Le 15.04.2021 12:12, Alexandre Fayolle a écrit :

>> I'm in contact with a german company who would like to interface Odoo

>> with different marketplaces, such as amazon, ebay but also local german

>> actors. I don't have yet a full list, and the list is likely to evolve

>> over time anyway, so I would not like to use 1 connector backend per

>> marketplace...

>> I think the most cost effective approach would be to use a 3rd party

>> broker which would take care of the nitty gritty details and present

>> Odoo with a single, unified interface. I think lengow does this, and we

>> have a connector_lengow project in the OCA repositories.

>> I'm happy to hear some feedback (on the lengow connector, or on using a

>> broker for this purpose), doubtless some of you already had to walk 

>> this

>> path.

> 

> _______________________________________________

> Mailing-List: https://odoo-community.org/groups/contributors-15 

> <https://odoo-community.org/groups/contributors-15>

> Post to: mailto:contributors@odoo-community.org

> Unsubscribe: https://odoo-community.org/groups?unsubscribe 

> <https://odoo-community.org/groups?unsubscribe>

> 



-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.com
      by Alexandre Fayolle - 10:14 - 28 Apr 2021
    • Re: multichannel sales with different marketplaces
      Hi Alexandre,


      I would personally go for a UBL standard XML file to import and export data to the third party provider, whatever it is. We used Lobster for example in one project. 

      Then Odoo 'just' need to speak and understand UBL and most is already done in OCA/EDI repo. 

      IMO it is, and should probably remain, that the customer have a hand on the third party app that communicate with Odoo and other tools. If we have one interface, fine we take the responsibility. If it starts to be many, and moreover moving target, then better the customer take this part. 

      Strategically speaking, it's also important that the customer has its data and flows under control. 

      Call me anytime, 

      All the best, 

      Joël 


      Le jeu. 15 avr. 2021 à 13:17, Xavier Brochard <xavier@alternatif.org> a écrit :
      Hello

Using a multi-channel dispatcher is the best option, as it is allways 
very complicated to handle all the marketplaces that you need in Odoo. 
It is exactly like using a multi shipping provider.

Lengow is only for big companies wich sells lot of products.

We work with Iziflux, a french multi-channel feed (a «broker» as you 
said, one can see it as a dispatcher). Price is really cheap compared to 
Lengow and you can start with, for example, 100 products. There is a lot 
of multi-channel feeders. Local feeders are recommended at there is also 
a lot of local marketplaces.

We have asked it-projects (Yelizariev's company) to code a connector 
Odoo 13 - Iziflux. It works well and we would like to release it as GPL.

However, a simpler module would be good enough for starting as nearly 
all multi-channel feeds can handle CSV files. It would work as follow :
- check products to sell
- check require fields and transform format
And a cron job would
- CSV product and stock
- CSV stored in dedicated directory
- ftp your CSV to the multichannel feed (some multichannel feeds will 
directly take it)
- ftp the multichannel CSV (sales)
- CSV sale import
Such a general module could be immediatly usable with every 
multi-channel feed as soon as you will setup the fields and adapt 
formats.

If you need to search for multi channel providers, use these keywords : 
multi-channel, feed, connector, flux

---
Librement,
Xavier Brochard xavier@alternatif.org
La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre 
Rosnay)

Le 15.04.2021 12:12, Alexandre Fayolle a écrit :


> I'm in contact with a german company who would like to interface Odoo


> with different marketplaces, such as amazon, ebay but also local german


> actors. I don't have yet a full list, and the list is likely to evolve


> over time anyway, so I would not like to use 1 connector backend per


> marketplace...


> I think the most cost effective approach would be to use a 3rd party


> broker which would take care of the nitty gritty details and present


> Odoo with a single, unified interface. I think lengow does this, and we


> have a connector_lengow project in the OCA repositories.


> I'm happy to hear some feedback (on the lengow connector, or on using a


> broker for this purpose), doubtless some of you already had to walk 


> this


> path.

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

      by Joël Grand Guillaume - 10:12 - 28 Apr 2021
    • Re: multichannel sales with different marketplaces 
      Hello

Using a multi-channel dispatcher is the best option, as it is allways 
very complicated to handle all the marketplaces that you need in Odoo. 
It is exactly like using a multi shipping provider.

Lengow is only for big companies wich sells lot of products.

We work with Iziflux, a french multi-channel feed (a «broker» as you 
said, one can see it as a dispatcher). Price is really cheap compared to 
Lengow and you can start with, for example, 100 products. There is a lot 
of multi-channel feeders. Local feeders are recommended at there is also 
a lot of local marketplaces.

We have asked it-projects (Yelizariev's company) to code a connector 
Odoo 13 - Iziflux. It works well and we would like to release it as GPL.

However, a simpler module would be good enough for starting as nearly 
all multi-channel feeds can handle CSV files. It would work as follow :
- check products to sell
- check require fields and transform format
And a cron job would
- CSV product and stock
- CSV stored in dedicated directory
- ftp your CSV to the multichannel feed (some multichannel feeds will 
directly take it)
- ftp the multichannel CSV (sales)
- CSV sale import
Such a general module could be immediatly usable with every 
multi-channel feed as soon as you will setup the fields and adapt 
formats.

If you need to search for multi channel providers, use these keywords : 
multi-channel, feed, connector, flux

---
Librement,
Xavier Brochard xavier@alternatif.org
La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre 
Rosnay)

Le 15.04.2021 12:12, Alexandre Fayolle a écrit :

> I'm in contact with a german company who would like to interface Odoo

> with different marketplaces, such as amazon, ebay but also local german

> actors. I don't have yet a full list, and the list is likely to evolve

> over time anyway, so I would not like to use 1 connector backend per

> marketplace...

> I think the most cost effective approach would be to use a 3rd party

> broker which would take care of the nitty gritty details and present

> Odoo with a single, unified interface. I think lengow does this, and we

> have a connector_lengow project in the OCA repositories.

> I'm happy to hear some feedback (on the lengow connector, or on using a

> broker for this purpose), doubtless some of you already had to walk 

> this

> path.
      by xavier - 01:15 - 15 Apr 2021
    • Re: multichannel sales with different marketplaces
      We're interested in this topic as well and maybe we run a project based on that soon. Lengow and Tradebyte are the main actors, maybe you want to take a look at both of them. What we've heard, based on the experience of our customers, is that they both provide great service but the cost is high, so it seems that the number of marketplaces involved has to be more than 5 or so.

      The OCA Lengow connector is outdated, have in mind that maybe it's not working out of the box.

      There's an opensource alternative Cenit.io [1] (and I think it was something related to our odoo world in their beginning), but we haven't tried. 

      But also, willing to hear more feedback.

      [1] https://github.com/cenit-io/

      El jue, 15 abr 2021 a las 12:12, Alexandre Fayolle (<alexandre.fayolle@camptocamp.com>) escribió:
      Hello,

I'm in contact with a german company who would like to interface Odoo 
with different marketplaces, such as amazon, ebay but also local german 
actors. I don't have yet a full list, and the list is likely to evolve 
over time anyway, so I would not like to use 1 connector backend per 
marketplace...

I think the most cost effective approach would be to use a 3rd party 
broker which would take care of the nitty gritty details and present 
Odoo with a single, unified interface. I think lengow does this, and we 
have a connector_lengow project in the OCA repositories.

I'm happy to hear some feedback (on the lengow connector, or on using a 
broker for this purpose), doubtless some of you already had to walk this 
path.

Thanks



-- 
Alexandre Fayolle
Senior Software Engineer
Tel : +33 4 58 48 20 30

Camptocamp France SAS
18 rue du Lac Saint André
73 370 Le Bourget-du-Lac
France

http://www.camptocamp.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 Carlos Liébana Anero. - 01:15 - 15 Apr 2021
  • If I am not logged in, I cannot open a mail discussion
    Hello,

    I am not sure if this is the right place to report...

    If I am not logged in, I cannot open a mail discussion, I get a 403 error message.

    You can check with this link for instance:

    image.png
    Regards,

    Jean-Charles


    Komit Logo
      Jean-Charles Drubay
    Managing Director
      Mobile: +84 (0) 9 09 64 34 69
    jc@komit-consulting.com | Skype: jc.drubay
    204/34 Nguyen Van Huong, Thao Dien, D2, HCMC, Vietnam
    https://komit-consulting.com
      

    by Jean-Charles Drubay - 12:01 - 15 Apr 2021

    1 attachments 1 attachments

    image.png

    2 replies 2 replies

  • Changing quantities and adding products after confirmation of Purchase orders
    Hi all,

    I wonder how, in Odoo 12, handle correctly the change of received quantity and the add of new products, once purchase order has been confirmed.

    Here is my context :

    - Quantity billed are based on "Delivered Quantity".
    - purchase order can be quite big. (> 500 lines).
    - After a purchase is confirmed, people receiving goods have to change quantity many time with all the cases possibles :
    Case A) received qty > ordered qty
    Case B) received qty < ordered qty
    Case C) received qty = 0 (out of stock)
    Case D) new product received (no ordered).

    Typical Case

    		 Ordered Qty Received Qty
    Product A - Corner Desk Right Sit 10 12
    Product B - Storage Box 20 18
    Product C - Cabinet with Doors 30 0
    Product D - Pedal Bin 0 100


    Draft Purchase Order
    image.png
    Receiving Stock Picking
    For case A, B and C, i can change the received values on the stock picking : the received quantity on the purchase order will be correctly updated / computed.
    But if I add a new line (new stock.move), the line is not added on the purchase order, and so, the bill will not contain the correct value.

    image.png

    Purchase order, (once the picking is confirmed)
    image.png
    Desired purchase order

    image.png

    The only solution I see for the time being is
    - for the case A, B, C : change values on the picking : OK.
    - for the case D, add a line on the purchase.order, and then, go to the picking, and then, set the correct received quantity.

    That is really not user friendly for end users, and so generates a lot of errors.

    - Do you know how to handle the 4 cases in the same screen ?
    - Do you know an (OCA) module that could add a purchase.order.line when adding an stock.move on a ready stock.picking ? (not sure it's the good design)


    thanks for your help.




    Sylvain LE GAL - Twitter
    GRAP - Service informatique (Groupement Régional Alimentaire de Proximité)
    Site Web | FramaSphere | Facebook
    3 Grande rue des Feuillants, 69001 Lyon
    Standard : (+33) 09.72.32.33.17
    Service Informatique : (+33) 09.73.79.64.40
    Astreinte Informatique : (+33) 06.81.85.61.43
    Member of the OCA (Odoo Community Association)
    by Sylvain LE GAL - 11:25 - 15 Apr 2021

    4 attachments 4 attachments

    image.png
    image.png
    image.png
    image.png
  • Proposing Dorin Hongu as Romanian PSC member
    Hello,

    i would like to propose Dorin Hongu as a Romanian PSC member
    so that he can help us manage issues and pull requests.

    He is involved a lot in the project:
    https://github.com/OCA/l10n-romania/commits?author=dhongu


    Thanks

    Regards,
    Mihai Fekete

    NextERP Romania S.R.L.
    600B, Peciu Nou, Romania

    E-mail: feketemihai@nexterp.ro
    Telefon: ‪0788-749989‬
    Website: https://nexterp.ro

    by Mihai Fekete - 12:56 - 14 Apr 2021

    4 replies 4 replies

  • FWD: REACH Odoo Customers

    Hi – I hope this email finds you well!!

     

    Quick question, would you be interested in acquiring a list of Odoo users/ customers based contact as well as their competitors customers.

     

    List Contains: Business Name, website url, Contact Name, Job Title, email address, phone number, mailing address, Industry type, fax number, social media links (LinkedIn , twitter) if available.

     

    Let me know your target product users and geography so that I can come up with data counts and pricing structure for your review.

     

    I look forward to your response.

     

    Best Regards,

    Symona Valery | Sr. Business Development Expert

     

     

                                                                                                                                                           

     

     

    by "Symona Valery" <symona.valery@updatedverifiedcontact.com> - 02:15 - 13 Apr 2021
  • Performance of /shop controller
    Hi all,

    in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.

    We already cache \/web\/(static|image|content)\/ in nginx and installed website_js_below_the_fold, but odoo server is the bottleneck at the moment.

    I profiled these requests with py-spy and noticed that execute function (odoo/sql_db.py) takes most of the time.

    Did anybody analyze these queries and have experience or modules to share?

    Thanks!

    by Lorenzo Battistini. - 09:30 - 11 Apr 2021

    3 replies 3 replies

    • Re: Performance of /shop controller
      El dom, 11 de abr de 2021 a las 07:31, Lorenzo Battistini <elbaddy@gmail.com> escribió:
      in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.

      v13 framework fixed this problem. Upgrade ASAP, that'll be the only real fix you can do.

      Otherwise, try removing category filters. Those use `child_of`, which is very expensive in v12.

      by Jairo Llopis - 09:30 - 13 Apr 2021
    • Re: Performance of /shop controller
      If you use profiler module,

      Port this and measure only /shop request

      https://github.com/OCA/server-tools/pull/1986

      Or use this directly with workers=0 in controlled environment:

      https://github.com/OCA/server-tools/pull/1369

      Then you can know which python function calls the sql_db and which ORM call was it, and know more about what generates the offending SQL.

      And of course follow Moises advice in order to actually get the offending SQL



      Apr 11, 2021 09:31:56 Lorenzo Battistini <elbaddy@gmail.com>:

      Hi all,

      in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.

      We already cache \/web\/(static|image|content)\/ in nginx and installed website_js_below_the_fold, but odoo server is the bottleneck at the moment.

      I profiled these requests with py-spy and noticed that execute function (odoo/sql_db.py) takes most of the time.

      Did anybody analyze these queries and have experience or modules to share?

      Thanks!

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

      by Tom Blauwendraat - 10:50 - 11 Apr 2021
    • Re: Performance of /shop controller
      It could be a lot of things

      I was realized that computing prices is heavy.
      But prefetching tables too as
       - website.user_id.partner_id.lang
      Missing indexes and so on.

      There are fixes using LRU cache in newer versions but if you have detected that queries are slow you can try getting the postgresql log in order to analyze it


      On Sun 11 Apr 2021 at 2:31 a.m. Lorenzo Battistini <elbaddy@gmail.com> wrote:
      Hi all,

      in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.

      We already cache \/web\/(static|image|content)\/ in nginx and installed website_js_below_the_fold, but odoo server is the bottleneck at the moment.

      I profiled these requests with py-spy and noticed that execute function (odoo/sql_db.py) takes most of the time.

      Did anybody analyze these queries and have experience or modules to share?

      Thanks!

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

      --
      Moisés López Calderón
      Mobile: (+521) 477-752-22-30
      Twitter: @moylop260
      hangout: moylop260@vauxoo.com
      http://www.vauxoo.com - Odoo Gold Partner
      Twitter: @vauxoo
      by Moisés López Calderón - 09:41 - 11 Apr 2021
  • package in a package?
    Hello community,

    with standard or OCA Odoo modules, is there the feature to put a stock.move.line in the destination package (like a small unit as parcel/package) and after several minutes to put the same stock.move.line in a bigger unit like a pallet without losing the information that the stock.move.line is both in the package and in the pallet? 
    At use, it seems to me that, by default, a stock.move.line is only in a package at the same time, and not in a package (parcel) which is in a package (pallett).
    Maybe I missed something?

    Regards,

    Romain Deheele
    by romain@avosdim.com - 11:11 - 6 Apr 2021

    2 replies 2 replies

    • Re: package in a package?
      Hi Denis,

      Thanks for your reply, I understand this pick-pack-ship flow,
      I clarify my use case: I have two companies A and B:
      Company A picks products, packs them in several packages, and puts packages on a pallett and ships the pallett to the company B.
      Company B unpacks the pallett, and needs to know the origin package information (stock.move.line A in the package PACK001, stock.move.line in the package PACK002, ...). Maybe naively, I thought that Odoo was going to keep the multi level package information, but it seems that a stock.move.line always goes from an origin package to a destination package.

      Romain



      Le mar. 6 avr. 2021 à 11:32, Roussel, Denis <denis.roussel@acsone.eu> a écrit :
      Hi Romain,

      In your case, it is recommended to do the packings in several operations.

      STOCK =PICKING> |PICK ZONE| =PACK> |PACK ZONE| =SHIP> |CUSTOMERS|

      So, during picking you can put your products in a pack, and in packing operation you can put your packs on a pallet.

      I hope this would help you.


      Regards,

      On Tue, Apr 6, 2021 at 11:12 AM Romain Deheele <romain@avosdim.com> wrote:
      Hello community,

      with standard or OCA Odoo modules, is there the feature to put a stock.move.line in the destination package (like a small unit as parcel/package) and after several minutes to put the same stock.move.line in a bigger unit like a pallet without losing the information that the stock.move.line is both in the package and in the pallet? 
      At use, it seems to me that, by default, a stock.move.line is only in a package at the same time, and not in a package (parcel) which is in a package (pallett).
      Maybe I missed something?

      Regards,

      Romain Deheele

      _______________________________________________
      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
      Acsone SA, Succursale de Liège (Val Benoît)
      Tel    : +32 2 888 31 49
      Fax   : +32 2 888 31 59
      Gsm : +32 472 22 00 57

      Acsone sa/nv
      Boulevard de la Woluwe 56 Woluwedal | B-1200 Brussels  | Belgium
      Quai Banning, 6 (Val Benoît) | B-4000 Liège | Belgium
      Zone Industrielle 22 | L-8287 Kehlen | Luxembourg

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

      by romain@avosdim.com - 12:10 - 6 Apr 2021
    • Re: package in a package?
      Hi Romain,

      In your case, it is recommended to do the packings in several operations.

      STOCK =PICKING> |PICK ZONE| =PACK> |PACK ZONE| =SHIP> |CUSTOMERS|

      So, during picking you can put your products in a pack, and in packing operation you can put your packs on a pallet.

      I hope this would help you.


      Regards,

      On Tue, Apr 6, 2021 at 11:12 AM Romain Deheele <romain@avosdim.com> wrote:
      Hello community,

      with standard or OCA Odoo modules, is there the feature to put a stock.move.line in the destination package (like a small unit as parcel/package) and after several minutes to put the same stock.move.line in a bigger unit like a pallet without losing the information that the stock.move.line is both in the package and in the pallet? 
      At use, it seems to me that, by default, a stock.move.line is only in a package at the same time, and not in a package (parcel) which is in a package (pallett).
      Maybe I missed something?

      Regards,

      Romain Deheele

      _______________________________________________
      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
      Acsone SA, Succursale de Liège (Val Benoît)
      Tel    : +32 2 888 31 49
      Fax   : +32 2 888 31 59
      Gsm : +32 472 22 00 57

      Acsone sa/nv
      Boulevard de la Woluwe 56 Woluwedal | B-1200 Brussels  | Belgium
      Quai Banning, 6 (Val Benoît) | B-4000 Liège | Belgium
      Zone Industrielle 22 | L-8287 Kehlen | Luxembourg
      by Denis Roussel. - 11:31 - 6 Apr 2021
  • Login as Admin like in Odoo.SH

    Hi community,


    Does anyone know how to have a button like in Odoo.SH:
    image.png

    Is that possible to connect as a certain user? I get a session token then use it as a Header?

    Thanks!

    by Diogo Duarte - 11:31 - 1 Apr 2021

    1 attachments 1 attachments

    image.png
  • Field Service PSC
    Hello,

    I would like to propose my 2 colleagues Steve Campbell (osi-scampbell) and Sandeep Mangukiya (smangukiya) to join the Field Service PSC.

    Thank you and stay safe!

    MAXIME CHAMBREUIL
    MANAGING DIRECTOR LATAM
    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 - 09:41 - 31 Mar 2021

    10 replies 10 replies

  • Odoo load balancing

    Hi community,

    I'm looking for advice and experience regarding the topic of load balancing.

    There are two unrelated cases in which I would like to use it:

    1. Balancing over a pool of servers running Odoo

    We have a client with a horizontal setup with a pool of 4 servers running Odoo. Requests are now routed to the servers by means of round-robin, but that's not very smart - I'd rather pass the load to the server that I know has enough free workers, and perhaps memory/CPU/IO available to take on a new task. I've looked around and the only thing I've found so far is the UWSGI FastRouter: https://uwsgi-docs.readthedocs.io/en/latest/Fastrouter.html. Does someone have other suggestions?

    2. Smart balancing over worker pools on one server

    For a responsive Odoo you want to have many Odoo workers, but you don't want to run out of memory. This is a tradeoff. If you configure too few workers, your memory will sit idle, but if you configure many workers, you run the risk that occasional high memory requests (a heavy computation, a heavy report) come in and if by unlucky chance it's several at a time, your server can overload. Is there a load balancer or WSGI application server that can keep a track record of which requests generally take the most memory, and then throttle these requests to a limited "heavy pool" of Odoo workers that serve high-memory requests, whereas the "happy pool" will have many workers and process the trustworthy requests with much better responsiveness?

    Sorry if this is not the right place to ask - I will be happy about any pointers.

    -Tom

    by Tom Blauwendraat - 12:26 - 31 Mar 2021

    1 replies 1 replies

    • Re: Odoo load balancing
      HAProxy?

      Verstuurd vanaf mijn iPhone

      Op 31 mrt. 2021 om 12:27 heeft Tom Blauwendraat <tom@sunflowerweb.nl> het volgende geschreven:

      

      Hi community,

      I'm looking for advice and experience regarding the topic of load balancing.

      There are two unrelated cases in which I would like to use it:

      1. Balancing over a pool of servers running Odoo

      We have a client with a horizontal setup with a pool of 4 servers running Odoo. Requests are now routed to the servers by means of round-robin, but that's not very smart - I'd rather pass the load to the server that I know has enough free workers, and perhaps memory/CPU/IO available to take on a new task. I've looked around and the only thing I've found so far is the UWSGI FastRouter: https://uwsgi-docs.readthedocs.io/en/latest/Fastrouter.html. Does someone have other suggestions?

      2. Smart balancing over worker pools on one server

      For a responsive Odoo you want to have many Odoo workers, but you don't want to run out of memory. This is a tradeoff. If you configure too few workers, your memory will sit idle, but if you configure many workers, you run the risk that occasional high memory requests (a heavy computation, a heavy report) come in and if by unlucky chance it's several at a time, your server can overload. Is there a load balancer or WSGI application server that can keep a track record of which requests generally take the most memory, and then throttle these requests to a limited "heavy pool" of Odoo workers that serve high-memory requests, whereas the "happy pool" will have many workers and process the trustworthy requests with much better responsiveness?

      Sorry if this is not the right place to ask - I will be happy about any pointers.

      -Tom

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

      by Willem Hulshof - 08:56 - 31 Mar 2021
  • Web_gannt for CE

    Hello,

    I'm looking for a module web_gantt replacement that was moved to Enterprise a couple of years ago. This module adds view-type gantt-view that is useful for project planning and others. I have found OCA-module project_timeline that is part of what I'm looking for.

    --
    Med vänlig hälsning / Best regards/ 顺祝商祺,
    Anders Wallenquist

    VERTEL AB | Anders Wallenquist | anders.wallenquist@vertel.se
    +46 (0)13 99 19 480 | +46 (0) 709 565 160 | vertel.se
    by Anders Wallenquist - 08:46 - 31 Mar 2021

    3 replies 3 replies

  • Propose myself as PSC for OCA/calendar
    I can't find which OCA team manages the https://github.com/OCA/calendar/ repo.

    I'm pushing some modules there, and modern branches are mostly empty, so I guess I should be PSC there.

    My github profile, just in case: https://github.com/Yajo

    Thanks everyone!
    by Jairo Llopis - 11:41 - 29 Mar 2021

    9 replies 9 replies

  • updating module no recreate removed `noupdate="True"` data
    Hi there,

    I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

    Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

    I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

    I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

    --
    Pierre Verkest
    06 81 12 25 20
    Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest
    by Pierre Verkest - 11:05 - 29 Mar 2021

    3 replies 3 replies

    • Re: updating module no recreate removed `noupdate="True"` data
      Oh thanks a lot I missed this one, you save my day :-)

      Le lun. 29 mars 2021 à 12:11, Iván Todorovich <ivan.todorovich@gmail.com> a écrit :
      Hello Pierre,

      This already exists in core, you can set the forcecreate="False" or forcecreate="0" to prevent odoo from re-creating a deleted record


      I hope it helps :)

      Best

      Iván Todorovich

      Odoo Techno-Functional Consultant



      On Mon, 29 Mar 2021 at 06:27, Pierre Verkest <pierreverkest84@gmail.com> wrote:
      hum... in fact this would required to overwrite BaseModel, Is there a nice way in v14.0 to change such class from a module ?

      I'm not very confident if I overwrite a BaseModel method because if such module is present in the python path it will take place event if the module is not install I suppose.
      And I'm not sure how to properly monkey patch BaseModel at run time :thinking:

      Le lun. 29 mars 2021 à 11:04, Pierre Verkest <pierreverkest84@gmail.com> a écrit :
      Hi there,

      I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

      Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

      I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

      I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

      --
      Pierre Verkest
      06 81 12 25 20
      Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest


      --
      Pierre

      _______________________________________________
      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



      --
      Pierre
      by Pierre Verkest - 01:11 - 29 Mar 2021
    • Re: updating module no recreate removed `noupdate="True"` data
      Hello Pierre,

      This already exists in core, you can set the forcecreate="False" or forcecreate="0" to prevent odoo from re-creating a deleted record


      I hope it helps :)

      Best

      Iván Todorovich

      Odoo Techno-Functional Consultant



      On Mon, 29 Mar 2021 at 06:27, Pierre Verkest <pierreverkest84@gmail.com> wrote:
      hum... in fact this would required to overwrite BaseModel, Is there a nice way in v14.0 to change such class from a module ?

      I'm not very confident if I overwrite a BaseModel method because if such module is present in the python path it will take place event if the module is not install I suppose.
      And I'm not sure how to properly monkey patch BaseModel at run time :thinking:

      Le lun. 29 mars 2021 à 11:04, Pierre Verkest <pierreverkest84@gmail.com> a écrit :
      Hi there,

      I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

      Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

      I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

      I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

      --
      Pierre Verkest
      06 81 12 25 20
      Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest


      --
      Pierre

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

      by Iván Todorovich - 12:11 - 29 Mar 2021
    • Re: updating module no recreate removed `noupdate="True"` data
      hum... in fact this would required to overwrite BaseModel, Is there a nice way in v14.0 to change such class from a module ?

      I'm not very confident if I overwrite a BaseModel method because if such module is present in the python path it will take place event if the module is not install I suppose.
      And I'm not sure how to properly monkey patch BaseModel at run time :thinking:

      Le lun. 29 mars 2021 à 11:04, Pierre Verkest <pierreverkest84@gmail.com> a écrit :
      Hi there,

      I'm wondering if there is any good reason for this default behavior from odoo that if I (as a user) remove a record created by a module using `noupdate="True"` this records is re-created by the ORM at the next update ?

      Is there some module that changes that behaviour to let the record unlink while there is ir_model_data record without its related record ?

      I'm on the way to suggest ir_model_norecreate module in server-bakend repo to change that behaviour.

      I would be happy to hear from you, I think it could be a nice feature for next odoo version and maybe with a new tag `norecreate=True`, any thoughts ?

      --
      Pierre Verkest
      06 81 12 25 20
      Github: petrus-v - Twitter: petrusv84 - Linkedin: pierre-verkest


      --
      Pierre
      by Pierre Verkest - 11:26 - 29 Mar 2021
  • New module for data synchronization between Odoo instances
    Hello,

    I'm working on a module to synchronize data between Odoo instances.
    It will support one master with many slave databases, and allow for bidirectional sync.
    My design builds on top of, and expands, the great auditlog module (https://github.com/OCA/server-tools/tree/14.0/auditlog)

    I'm considering my options on:

    a) the repo to contribute the module to, and
    b) the name for the module.

    Suggestions are welcome.

    Thank you

    --
    Daniel Reis
    Managing Director
    M: +351 919991307
    E: DReis@OpenSourceIntegrators.com
    Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal


    by Daniel Reis - 01:15 - 19 Mar 2021

    13 replies 13 replies

  • Sale stock: widget qty_to_date
    Hello everyone,

    We recently went live with a customer on Odoo 14.0. On sales order lines, Odoo added this widget with the green/red graph icon and the quantity available/forecasted.

    The widget assumes that all the products in the warehouse are available for sales. It takes the view location "WH" to compute the quantities available/forecasted and provides that information to sales people.

    In previous versions, it was documented that the "Location Stock field on the warehouse shows the place of products available for delivery to a customer directly from this warehouse. Availability is given by all the products in that location and any child locations."

    This was the reason locations like Output, RMA, Repair or any use case where a company store items that are not for sales were NOT created under "Stock", so that they would not show up as available to salespeople.

    I reported an issue to Odoo support but their answer is to create a location outside of any warehouse using the Rental location as an example.

    This sounds terribly wrong to me and disconnected from the reality.

    Short term solution, we patched the stock and sale_stock modules to use the Stock location, but there are risks of breaking something.

    What do you think? What's your opinion?

    MAXIME CHAMBREUIL
    MANAGING DIRECTOR LATAM
    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:31 - 17 Mar 2021

    5 replies 5 replies