0

how to lock a cell at a given value?

hello, I have a catalog with the price of the parts and this price is reported on the estimate.  the concern is that if the price changes, the amount of the estimate is modified, how to lock the estimate so that it is not modified if a catalog price changes?  I have the same problem when I create the invoice according to the estimate.

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Alain

    Transactional data, like quotes, orders and invoices should not change over time so I would have a price field in the estimate line and this is populated from the current price in the stock record at the time of creation.

    Regards John

    Like
    • Alain
    • Alain.1
    • 1 mth ago
    • Reported - view

    that's it, but how to proceed on ninox?  I have only vague programming knowledge.  thank you  

    Like
    • Fred
    • Fred
    • 1 mth ago
    • Reported - view

    take a look at the Invoices template built into Ninox. When you create a new DB it is one of the templates available.

    We can answer any specific question after you had a look around.

    Like
  • Nel mio caso procedo così:

    Prezzo:= articoli.prezzo

    Prezzo è il campo numerico all'interno delle mie righe del documenti

    articoli.prezzo è il prezzo nel archivio degli articoli

    Like
    • Alain
    • Alain.1
    • 1 mth ago
    • Reported - view

    Ok. I’ll try. Thanks. 

    Like
    • Alain Having same issue, did you get this figured out?

      Like
Like Follow
  • 1 mth agoLast active
  • 6Replies
  • 57Views
  • 4 Following