Need Sequential # for Orders, Payments, etc.

BLOMASKY

Aware has one master list of the next assigned number, so, for instance, if it is currently 1,000 and I enter 10 orders, then 10 payments, then 10 more orders, my order file has IDs of 1,000-1009, 1020-1029. The customer would like a contiguous range of order #'s (which, is diff from the unique ID that Aware assigns)

I can think of 2 ways to do this.
1) Create a new BO with 1 record with an attribute "nextOrderNumber", "nextPaymentNumber", etc. and then, I would increment this anytime I create a new order. While this does embrace the "Aware" philosophy, I can see both a lot of extra work and some potential errors in a multi-user system

2) Once aware creates the table, use SQL to change the quoteNumber field to an IDENTITY field. (Yes, I am using MSSQL). This seems easy, less work and there is no way I can ever get duplicate order #'s.

Anyone else have this requirement? Found a better solution?

Thanks
Bruce

BenHayat

When it comes to special IDs like order #, payment # and etc. (other than internal ID #), I always maintain my own seed and incremental system.
If your app NOT a Multi Tenant app, you can keep them in SystemSettings BO which it's always available to you. But if your app app is a Multi Tenant app, then these ID storage attributes would be in the Tenant BO.

In one part of my app, my ID (seq #) must always be in correct Seq #, i.e. if you delete record, 123, then all the records after 123, would be shifted and so as their children would be affected accordingly.

tford

All number attributes can be configured to handle sequential numbering:

auto 1.jpg

auto 2.jpg

BLOMASKY

Thanks Tom.

Silly me, I forgot about that.... So many things I keep finding (and forgetting) in Aware

Bruce

hpl123

Yeah, most things Aware can do out of box. You can also create more advanced sequential numbering solutions using business rules. I for example had a scenario where I needed to reuse previous sequence positions when an instance was deleted and that was a bit of a challenge but possible using rules. The rules are incredibally åpowerful and a lot of things can be done.