0

N of determined record

I have a table where I generate invoices and budgets. A selection field marks whether it is an invoice or a budget. How can I automatically get the next invoice or budget number? a scrip can make the total document but does not discriminate whether it is an invoice or a budget

thanks

1 reply

null
    • coral_sail.1
    • 4 yrs ago
    • Reported - view

    I have solved it with a button that assigns the number based on the variable field that determines whether it is invoice or budget, where 1 is invoice and 2 is budget
    'NUMBER': = if number (TYPE) = 1 then
    cnt ((select INVOICE) [number (TYPE) = 1])
    else
    cnt ((select INVOICE) [number (TYPE) = 2])
    end

Login to reply

Content aside

  • 4 yrs agoLast active
  • 1Replies
  • 478Views