GetInvoiceNumber(optional prefix As String) As String

 

Returns a new invoicenumber in the form of the current year plus a counter, like "2018-53".

 

This function retrieves a new invoicenumber for the current year, from the database table invoicecounter.

If there is no invoicenumber existing yet, a new number will be created.

 

  

Parameters:

 

Name

Type

Description

prefix

String

A optional string which will be added to the beginning of the invoicenumber. Example:

GetInvoiceNumber("CH-") may result in "CH-2018-53"

GetInvoiceNumber may result in "2018-53"

 

Returns:

 

Type

Value

Description

String

invoicenumber

The number of the current year plus a counter. The counter is saved in table invoicecounter of the database. With each call to GetInvoiceNumber, the counter will be increased by 1. The counter restarts at 1 with the beginning of a new year.

 

Available in:

 

WindowMain

WindowLink

YES

YES

 

 Used in:

 

XojoScript Name

GUID

Create Seminar Invoice in Word

D2036EFA-D283-481A-9A93-D00547680749

 

Example XojoScript:

 

Dim invoicenumber As String = GetInvoiceNumber