1. Activate sale_opportunity module. This module add _history = True in product.product and product.template. 2. Create one or two products. Date creation in the past.  ``` # select id, create_date, write_date from product_template;  id |        create_date         |         write_date         ----+----------------------------+----------------------------   2 | 2024-06-01 06:45:53.007706 | 2024-12-20 06:47:55.497668   1 | 2024-06-01 06:45:53.007706 | 2024-12-20 06:48:02.45285 ``` Edit those products that create history records. ``` # select id, __id, create_date, write_date from product_template__history;  id | __id |        create_date         |         write_date         ----+------+----------------------------+----------------------------   2 |    3 | 2024-06-01 06:45:53.007706 | 2024-12-20 06:47:55.497668   1 |    4 | 2024-06-01 06:45:53.007706 | 2024-12-20 06:48:02.45285   1 |    1 | 2024-06-01 06:45:53.007706 | 2024-12-20 06:46:02.15285   2 |    2 | 2024-06-01 06:45:53.007706 | 2024-12-20 06:46:02.15285 ``` 3. Create supplier moves; effective move from product ID 1 is from the past. ``` # select id, create_date, effective_date, product from stock_move;  id |        create_date         | effective_date | product ----+----------------------------+----------------+---------   1 | 2024-12-20 06:46:26.758077 | 2024-12-01     |       1   2 | 2024-12-20 06:47:34.08745  | 2024-12-20     |       2 ``` 4. Menu Stock / locations. Click Warehouse. In date filter: 12/05/2024 Rows show #ERROR -from cost_value field-.  5. In trytond -vvv server show AccessError (from company model): ``` trytond.model.modelstorage.AccessError: You are trying to read records "1" of "Company" that don't exist. - At date/time: 12/05/2024 23:59:59 ``` At version 6.8 server show AccessError (from product.template model): ``` trytond.model.modelstorage.AccessError: Está intentando leer los registros "24059" del modelo "Plantilla de producto" que no existen. - ``` 6. I discovered that the SQL history returns empty rows because all records have a non-null write_date, the latest create_date is 2024-06-01, and the context date is 2024-05-12. ``` # select count(*) from product_template__history where id = 1 and COALESCE(write_date, create_date) <= '2024-05-12';  count -------      0 ``` Detect at version 7.2 Traceback: ``` 55926 140033538488000 [2024-12-20 08:45:09,366] DEBUG trytond.wsgi Exception when processing <JSONRequest 1@127.0.0.1 'http://localhost:38002/nan72sale_opportunity/' [POST] model.stock.products_by_locations.read> Traceback (most recent call last): File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/wsgi.py", line 110, in dispatch_request return endpoint(request, **request.view_args) │ │ └ <JSONRequest 1@127.0.0.1 'http://localhost:38002/nan72sale_opportunity/' [POST] model.stock.products_by_locations.read> │ └ <JSONRequest 1@127.0.0.1 'http://localhost:38002/nan72sale_opportunity/' [POST] model.stock.products_by_locations.read> └ <function rpc at 0x7f5c45f84400> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/protocols/dispatcher.py", line 44, in rpc return methods.get(request.rpc_method, _dispatch)( File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/wsgi.py", line 76, in wrapper return func(request, *args, **kwargs) │ │ │ └ {} │ │ └ ('nan72sale_opportunity', [1], ['active', 'consumable', 'cost_value', 'default_uom', 'forecast_quantity', 'id', 'product', 'quan... │ └ <JSONRequest 1@127.0.0.1 'http://localhost:38002/nan72sale_opportunity/' [POST] model.stock.products_by_locations.read> └ <function _dispatch at 0x7f5c45b289a0> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/protocols/wrappers.py", line 208, in wrapper result = func(request, pool, *args, **kwargs) │ │ │ │ └ {} │ │ │ └ ([1], ['active', 'consumable', 'cost_value', 'default_uom', 'forecast_quantity', 'id', 'product', 'quantity', 'default_uom.rec_n... │ │ └ <trytond.pool.Pool object at 0x7f5c183b6d80> │ └ <JSONRequest 1@127.0.0.1 'http://localhost:38002/nan72sale_opportunity/' [POST] model.stock.products_by_locations.read> └ <function _dispatch at 0x7f5c45b28900> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/protocols/dispatcher.py", line 216, in _dispatch result = rpc.result(meth(*c_args, **c_kwargs)) │ │ │ └ {} │ │ └ [[1], ['active', 'consumable', 'cost_value', 'default_uom', 'forecast_quantity', 'id', 'product', 'quantity', 'default_uom.rec_n... │ └ <bound method ModelSQL.read of <class 'trytond.modules.stock.location.ProductsByLocations'>> └ <trytond.rpc.RPC object at 0x7f5c1886e030> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelsql.py", line 1200, in read getter_results = field.get( File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 27, in wrapper return func(self, *args, **kwargs) │ │ │ └ {'values': [{'active': True, 'product': 1, 'write_date': datetime.datetime(2024, 12, 20, 6, 45, 53, 7706), 'id': 1}]} │ │ └ ([1], <class 'trytond.modules.stock.location.ProductsByLocations'>, ['consumable', 'default_uom', 'forecast_quantity', 'cost_val... │ └ <trytond.model.fields.function.Function object at 0x7f5c18874510> └ <function Function.get at 0x7f5c463b27a0> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/transaction.py", line 50, in wrapper return func(*args, **kwargs) │ │ └ {'values': [{'active': True, 'product': 1, 'write_date': datetime.datetime(2024, 12, 20, 6, 45, 53, 7706), 'id': 1}]} │ └ (<trytond.model.fields.function.Function object at 0x7f5c18874510>, [1], <class 'trytond.modules.stock.location.ProductsByLocati... └ <function Function.get at 0x7f5c463b2700> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 168, in get return dict((name, call(name)) for name in names) │ │ │ │ └ ['consumable', 'default_uom', 'forecast_quantity', 'cost_value', 'quantity'] │ │ │ └ ['consumable', 'default_uom', 'forecast_quantity', 'cost_value', 'quantity'] │ │ └ ['consumable', 'default_uom', 'forecast_quantity', 'cost_value', 'quantity'] │ └ <function Function.get.<locals>.call at 0x7f5c1822dbc0> └ ['consumable', 'default_uom', 'forecast_quantity', 'cost_value', 'quantity'] File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 168, in <genexpr> return dict((name, call(name)) for name in names) │ │ │ └ 'cost_value' │ │ └ 'cost_value' │ └ <function Function.get.<locals>.call at 0x7f5c1822dbc0> └ 'cost_value' File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 134, in call return { File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 135, in <dictcomp> r.id: convert(method(r, name), name) for r in records} File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/modules/stock/location.py", line 738, in get_product value = getattr(self.product, name) │ └ 'cost_value' └ Pool().get('stock.products_by_locations')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 192, in __get__ return super().__get__(inst, cls) │ └ <class 'trytond.pool.product.product'> └ Pool().get('product.product')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/field.py", line 393, in __get__ return inst.__getattr__(self.name) │ └ <trytond.model.fields.function.Function object at 0x7f5c18a05b10> └ Pool().get('product.product')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelstorage.py", line 1859, in __getattr__ read_data = self.read(list(index.keys()), list(ffields.keys())) │ │ └ {'cost_value': <trytond.model.fields.function.Function object at 0x7f5c18a05b10>} │ └ {1: 0} └ Pool().get('product.product')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelsql.py", line 1200, in read getter_results = field.get( File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 27, in wrapper return func(self, *args, **kwargs) │ │ │ └ {'values': [{'id': 1}]} │ │ └ ([1], <class 'trytond.pool.product.product'>, ['cost_value']) │ └ <trytond.model.fields.function.Function object at 0x7f5c18a05b10> └ <function Function.get at 0x7f5c463b27a0> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/transaction.py", line 50, in wrapper return func(*args, **kwargs) │ │ └ {'values': [{'id': 1}]} │ └ (<trytond.model.fields.function.Function object at 0x7f5c18a05b10>, [1], <class 'trytond.pool.product.product'>, ['cost_value']) └ <function Function.get at 0x7f5c463b2700> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 168, in get return dict((name, call(name)) for name in names) │ │ │ │ └ ['cost_value'] │ │ │ └ ['cost_value'] │ │ └ ['cost_value'] │ └ <function Function.get.<locals>.call at 0x7f5c1822d940> └ ['cost_value'] File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 168, in <genexpr> return dict((name, call(name)) for name in names) │ │ │ └ 'cost_value' │ │ └ 'cost_value' │ └ <function Function.get.<locals>.call at 0x7f5c1822d940> └ 'cost_value' File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 127, in call values = method(records, name) │ │ └ 'cost_value' │ └ [Pool().get('product.product')(1)] └ <bound method Product.get_cost_value of <class 'trytond.pool.product.product'>> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/modules/stock/product.py", line 262, in get_cost_value Decimal(str(product.quantity)) * product.cost_price) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 192, in __get__ return super().__get__(inst, cls) │ └ <class 'trytond.pool.product.product'> └ Pool().get('product.product')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/field.py", line 393, in __get__ return inst.__getattr__(self.name) │ └ <trytond.model.fields.function.Function object at 0x7f5c18a06f10> └ Pool().get('product.product')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelstorage.py", line 1859, in __getattr__ read_data = self.read(list(index.keys()), list(ffields.keys())) │ │ └ {'quantity': <trytond.model.fields.function.Function object at 0x7f5c18a06f10>} │ └ {1: 0} └ Pool().get('product.product')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelsql.py", line 1200, in read getter_results = field.get( File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 27, in wrapper return func(self, *args, **kwargs) │ │ │ └ {'values': [{'id': 1}]} │ │ └ ([1], <class 'trytond.pool.product.product'>, ['quantity']) │ └ <trytond.model.fields.function.Function object at 0x7f5c18a06f10> └ <function Function.get at 0x7f5c463b27a0> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/transaction.py", line 50, in wrapper return func(*args, **kwargs) │ │ └ {'values': [{'id': 1}]} │ └ (<trytond.model.fields.function.Function object at 0x7f5c18a06f10>, [1], <class 'trytond.pool.product.product'>, ['quantity']) └ <function Function.get at 0x7f5c463b2700> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 168, in get return dict((name, call(name)) for name in names) │ │ │ │ └ ['quantity'] │ │ │ └ ['quantity'] │ │ └ ['quantity'] │ └ <function Function.get.<locals>.call at 0x7f5c18239080> └ ['quantity'] File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 168, in <genexpr> return dict((name, call(name)) for name in names) │ │ │ └ 'quantity' │ │ └ 'quantity' │ └ <function Function.get.<locals>.call at 0x7f5c18239080> └ 'quantity' File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/function.py", line 127, in call values = method(records, name) │ │ └ 'quantity' │ └ [Pool().get('product.product')(1)] └ <bound method Product.get_quantity of <class 'trytond.pool.product.product'>> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/modules/stock/product.py", line 222, in get_quantity return cls._get_quantity( File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/modules/stock/move.py", line 92, in _get_quantity with Transaction().set_context(cls._quantity_context(name)): File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/modules/stock/move.py", line 49, in _quantity_context today = Date.today() └ <class 'trytond.pool.ir.date'> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/modules/company/ir.py", line 41, in today if company.timezone: File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/fields/field.py", line 393, in __get__ return inst.__getattr__(self.name) │ └ <trytond.model.fields.selection.Selection object at 0x7f5c18bbee50> └ Pool().get('company.company')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelstorage.py", line 1859, in __getattr__ read_data = self.read(list(index.keys()), list(ffields.keys())) │ │ └ {'timezone': <trytond.model.fields.selection.Selection object at 0x7f5c18bbee50>, 'cancel_invoice_out': <trytond.model.fields.bo... │ └ {1: 0} └ Pool().get('company.company')(1) File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelsql.py", line 1113, in read cls.__check_domain_rule(ids, 'read') │ └ [1] └ <class 'trytond.pool.company.company'> File "/home/raimon/projectes/nandev2/nan72/trytond/trytond/model/modelsql.py", line 1672, in __check_domain_rule raise AccessError(msg, '\n'.join(ctx_msg)) │ │ └ ['At date/time: 12/05/2024\xa023:59:59'] │ └ 'You are trying to read records "1" of "Company" that don\'t exist.' └ <class 'trytond.model.modelstorage.AccessError'> trytond.model.modelstorage.AccessError: You are trying to read records "1" of "Company" that don't exist. - At date/time: 12/05/2024 23:59:59 ```