We have a number of customers with individual price schedules which are updated annually. We have exceeded the "200 available", now it is a matter of reusing old ones and data entering all product price into the price level. When price levels are available we can duplicate our generic one and only change the products that have different rates. Manually entering all rates over and over again increases the risk of data entry errors. Whilst I can delete old price levels they still appear
Hi Amanda. This is actually a limit of the Intuit / SQL Anywhere database. We have accepted the provided recommendations, and they are not to exceed the limits noted HERE.
That said, we have gone back to our developers to see if there is anything we can do. We'll update once we know more.
We have talked to longer serving team members and they have advised that this was attempted some years back, and there were 2 issues. Reports were not creating as expected, and there was a significant reduction in database efficiency. Therefore due to these known issues, as well as the unknown risks, we have made the decision to not exceed the database manufacturers recommendations.
Depending on the age of your database, and size, and number of transactions, it may be time to create a clean database and archive your existing company file. The QBW file statistics can be found by opening your company file and selecting Ctrl+1 on your keyboard. If in doubt, you can contact either our tech support, or a local accredited partner - see https://partnersearch.reckon.com/ - many partners specialise in database archiving so it's a good idea to ask about their experience with both inventory and pricing rules.
Finally if you are finding your business is outgrowing our rudimentary pricing rules it may be time to consider one of our specialist partners. Ostendo and Fishbowl Inventory are two of note. See https://www.reckon.com/marketplace/