Forum Discussion

Lee_SGilmore's avatar
Lee_SGilmore
Qrew Cadet
7 years ago

Incrementing Number based on parent record total - Legacy Accounting Software requirement

My company's accounting software requires that we create Purchase Order Numbers with nine digits starting with the first 5 numbers being the Job Number and the last four digits being an incrementing n...
App builders
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
.. also be sure to prevent any users from deleting Purchase Orders.  If necessary allow them to marked as "Cancelled", but not allow anyone, even the Admin Role to delete.
  • ForrestParker's avatar
    ForrestParker
    Qrew Cadet
    7 years ago
    That's a great call-out.  If a purchase order is deleted, then there is potential for a duplicate Purchase Order number.  
  • Lee_SGilmore's avatar
    Lee_SGilmore
    Qrew Cadet
    7 years ago
    I've removed their delete privileges just now and am a big fan of the cancelled/void/etc option. Thanks!