Author Topic: Formula function may result in difference for data in interface and database.  (Read 348 times)


  • Pro Enterprise
  • Full Member
  • *
  • Posts: 121
    • View Profile
When using fomula to input product code in column A and autumatically show product name in column B in sales order, somedays later, the name of a product is changed( in master data), in old sales order the old name should be expected to be show but in the  new created order the new name is expected to be shown. If formula is used, the old sales order will show the new name, even old name is recorded in the table of sales order lines in database. If there is a solution for this condition? 

In some case the price of product always changes, if using formula get price in database, it'll make trouble too, especially when there is redundance design in database table structure.
The price in interface will be different with price in database.
Any advice?
« Last Edit: December 25, 2022, 06:10:12 pm by hyh888 »