Thanks for the solutions and suggestions. @Notrinos, your solution was spot on. The field "id" never had auto increment flag enabled. Once I enabled it, all went through seamless. Thank you for the support in resolving this.
How many users can Front Accounting take concurrently? Coz I plan to deploy it in about 5 outlets. The challenge I observed, is if we are all on the same form e.g Sales Order and we have both opened it at the same time, on clicking place order, it reports duplicate records.
Have you ever encountered a situation like this?
Once again thank you @notrinos and @apmuthu for the support rendered.