Hello Forum,
I have a table with records as shown in the table below
|
Id
|
Email
|
Organization
|
CreatedBy
|
Date
|
|
1
|
klins@gmail.com
|
Klins Global Tech
|
klins@gmail.com
|
09-Sep-20 4:00PM
|
|
2
|
friesland@yahoo.com
|
FriesLand venture
|
friesland@yahoo.com
|
11-Sep-20 1:27PM
|
two organizations are registered (klins Global and Friesland venture) and their records are stored in the table. If Klins Global navigates to invoice page to create an invoice; there is a label on the invoice that will display invoice number. the invoice number will have a prefix before number. This prefix will be the initials of the first two words of an organization. For example Klins Global will be KG followed by number 000001 - (KG000001). Then if Friesland venture also wants to create an invoice, the invoice number of Friesland venture should not mix with that of kilns Global. Friesland venture will FV000001 and klins Global will have KG000001.
There will also be an auto increment in the number but the prefix will remain unchanged as it is the initials of the organization. Invoice number are supposed to be based on organization name. so that when an invoice will be checked, it will based on the invoice number and based on organization's ID in the data table.
I hope that I am able to explain better ?
