Aware IM User Forums

Agreed. Was researching posts and posted one. But our system is a low cost 20-30 a month subscription, self signup, self-service besides lots of tutorials and some phone support staff. So we cannot setup BSV's for each customer. They come and hopefully, they don't go. Which means we have to use mult...

Some more pro's and cons Single Database for Single Tenant The main advantage of “one database–one tenant” design is that it ensures the highest level of data safety. Each database instance is located on a separate server, so instances are physically separated. This means that one tenant simply can’...

Whereas I was a strong advocate of single tenant databases, the more I read up the more it seems that multi-tenancy in one database seems to be the method used by most large companies. Salesforce, Xero, etc. See link below for excellent article. My biggest concern data reliability and recovery. My l...

Thanks Tom, The way I use this is it only about when I reduce the query, and I see a variance, I click to see the detail. Its sales tax so I end up having to check the rates with the state websites to see if they changed. When the app was first developed, the customers would never log in, never prin...

When I say schema's I meant databases. Mf

In researching this further, there are pro's and con's for different methods, including performance, costs. etc. Because with our C/S app, the client was always responsible for their data, and with our method of having each tenant with their own set of independent data, it was easy to manage and nev...

Looked up what Xero is doing. They provide a history. https://www.xero.com/blog/2016/07/xeros-platform-structure-history 1. From One database 2. Then clustering 40,000 per cluster - outgrew this 3. Now implementing Cell method. Not sure this is what they want but they are trying to accommodate milli...

I have one app running in an older version of AIM which has the option to reduce. It is invaluable. I create a set of tax data each month, for a couple of hundred clients. I run a query each month to look for an unusual variance. The reduce lets me instantly limit the transactions to whatever month ...

I feel # 5 is the best option. When you first login, AIm could have an option to assign a tenant. A schema gets created for that tenant and subsequent tenants. All data works with the tenant's schema selected. If the bsv table is modified, instead of modifying one tenant as the system works now, it ...

Actually, when I was working with Vladimir on this issue, he suggested 2 fields as well. He was saying Invoice # and Reference # with one auto-increment. But when we were talking I was thinking he meant two fields on the screen and thought that would be confusing and discounted it. But in reading yo...

Bob, actually you are correct and I was aware of that but forgot. But I could not use Auto Increment because when you do so, it makes it a calculated field, which is non-editable. In my case, they need to have both, auto-increment with an override option. The only way I could do it, is with managing...

Very interesting. Xero is trying to make inroads in the US market and have to review again what they do. They let you create a number but they also create a number like INV-001. Need to go back and exactly see what they are doing and why (maybe that's why I thought it was gobbledygook). Freshbooks h...

Thanks for the info. So this is a commercial mass market app for small businesses. We have found with our C/S that some companies want to enter their own, some want to have auto increment, and some do a combo of both. Also, I have to take in consideration the tenant since it one database for all ten...

I wasn't able to read all the posts here, but you can use the 'Duplicate' to duplicate the header and references. You can use NO RULES statement and assign attributes using This and That. Or you can Duplicate with rules, using the Except xxxatribute. For example, I Duplicate an Invoice Header which ...

I don't know why I didn't look on the forum earlier. I was using the Duplicate function which duplicated the header perfectly and bumped up the invoice # automatically. I used the Duplicate function to duplicate the lines and that seems to work perfectly. Then as I did more, on certain invoices it w...