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.

6 replies

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    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

    • Alain.1
    • 2 yrs ago
    • Reported - view

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

    • Fred
    • 2 yrs 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.

    • Antonello_Stabile_71
    • 2 yrs ago
    • Reported - view

    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

    • Alain.1
    • 2 yrs ago
    • Reported - view

    Ok. I’ll try. Thanks. 

      • Bruce_McMullin
      • 2 yrs ago
      • Reported - view

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

Content aside

  • 2 yrs agoLast active
  • 6Replies
  • 89Views
  • 4 Following