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
    • 1 yr 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
    • 1 yr ago
    • Reported - view

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

    • Fred
    • 1 yr 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
    • 1 yr 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
    • 1 yr ago
    • Reported - view

    Ok. I’ll try. Thanks. 

      • Bruce_McMullin
      • 1 yr ago
      • Reported - view

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

Content aside

  • 1 yr agoLast active
  • 6Replies
  • 87Views
  • 4 Following