Solved

Updating table values - history settings

  • 20 March 2023
  • 2 replies
  • 51 views

I have loaded a table with some initial data  (== initial stoock). The key is quiet simple  Company, Warehouse and Item

Now I want to update the amounts every day so that it reflects the actual stock level of data day

The initial load was done from one source , the updates come from another sources 

History settings  have natural jkey set , and all non lookup fields are updsated  (type 1)

Nevertheless the record is not updated 

Any idea ‘why’ the update is not working

icon

Best answer by alain.thire 20 March 2023, 15:24

View original

2 replies

Userlevel 6
Badge +5

Hi @alain.thire 

Can you please add some screenshots of the table and the history settings similar to below?

 

Thanks

 

I got it working now. In fafct I have a feeder for historical data and an incremental insert for the updates.  I remloved the incremental insert , and things work. 

Not sure ‘why’ because the proposed settings were always used but it looks like working 

Thanks anyway

Reply