+- 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