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 agoFri, August 12, 2022 at 1:09 PM UTC
    • 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 agoFri, August 12, 2022 at 3:21 PM UTC
    • Reported - view

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

    • Fred
    • 2 yrs agoSat, August 13, 2022 at 2:44 PM UTC
    • 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 agoSat, August 13, 2022 at 2:53 PM UTC
    • 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 agoSun, August 14, 2022 at 8:50 PM UTC
    • Reported - view

    Ok. I’ll try. Thanks. 

      • Bruce_McMullin
      • 2 yrs agoTue, August 16, 2022 at 1:03 PM UTC
      • Reported - view

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

Login to reply

Content aside

Categories

View all topics
  • 2 yrs agoTue, August 16, 2022 at 1:03 PM UTCLast active
  • 6Replies
  • 91Views
  • 4 Following