LiveCloud Forums
Creating unique number for a Invoicing - Printable Version

+- LiveCloud Forums (https://forums.livecloud.io)
+-- Forum: General (https://forums.livecloud.io/forumdisplay.php?fid=1)
+--- Forum: General (https://forums.livecloud.io/forumdisplay.php?fid=3)
+--- Thread: Creating unique number for a Invoicing (/showthread.php?tid=60)



Creating unique number for a Invoicing - Peter - 07-24-2019

Is it possible to create a Unique number forĀ ie: for invoicing:


RE: Creating unique number for a Invoicing - sid - 04-07-2020

Hi Peter

Mark has kindly done a new API that will help with this. Please see:

The APIs available are:
cdb_calcUpdate pDataA,pOperator,pTable,pRecordID,pTarget
cdb_calcBatchUpdate pDataA,pTarget

You will be able to batch as many calculations as you like on as many keys as you like.

Valid operators: "add,subtract,multiply,divide"


i would create a record in the database that holds a start number , use this api to add a number to it , store the number to use as your invoice number in a variable

The fact that it adds a number instead of overwriting it should eliminate the possiblility of duplicate numbers

Im busy myself with a POS ERP system and im pretty new to this. We can probably help each other out if you want to connect

Sid