Active Query Builder vs. Bizview vs. Prophix

This is a good framework to use if your project requires frequent database queries. The product is made for both complete amateurs and seasoned experts. Prompt, courteous, and expert assistance; any problems are addressed and fixed without delay. Relatively inexpensive Inadequate, if there are new people involved, delays due to a lack of documentation are likely, and issues with code completion may arise.

Incentivized

My favorite part is using if for analytical review reports, especially budget to actual reviews. I can make changes to the GL based on issues found during the review and the report updates immediately without having to update, re-key, verify changes, etc. I know it is going to be updated and correct every time.

If the budgeting is done with Excel spreadsheets, and your company is small to medium in size, Prophix is the system for you! Additionally, if your company is also doing monthly forecasting in Excel, Prophix will save you time and reduce errors. There are also many other worthwhile features, such as Account Reconciliation and consolidations.

Incentivized

• Pull data from SQL even if you do not know SQL.
• Provides clear database information.
• Works with multiple databases at once.
• Data access and security.

Incentivized

• Once a worksheet has been created, you can change a single cell and update the entire report. This makes it much easier than recreating a report every time you start.
• It draws data directly from our database that can be filtered down in various ways. This allows us to get the data that we really need quicker.

Incentivized

• Reporting - single report that can be opened by multiple users, each will see only aspect specific to them based on their security access.
• Budgeting - workflow driven budget data collection, visibility of its current status, ability to take action to ensure timely completion. Ability to snapshot budget data at a point in time. Ability to perform what-if scenarios.
• Forecasting - as above with added benefit of either reusing budget level of grain or forecasting at high level.
• Granular planning - ability to create unlimited number of subsidiary models to assist with the planning process. Non-financial data collected during budget/forecast process help with operation planning and variance analysis.

Incentivized

• Features are good but lacks documentation
• It would be great it were adaptive to Embarcadero/Dev Express Skins that would be very cool
• Modifying SQL code is difficult

Incentivized

• Access to comprehensive training for new users is lacking. While the pay-based BizNet University has some useful videos it doesn't allow for other learning styles.
• Having to create a separate OCBC data source and linked server for each arm of business opened is sometimes a hassle.

• Prophix could improve on its dashboarding capability - it is very basic and we always present our graphs/visuals in Excel.
• We would love it if Prophix could improve its line item detail reports. They are not great right after downloading and require a lot of manipulation in Excel.
• It would be awesome if we could fully integrate our invoicing software with Prophix. This would allow us to view invoices within Prophix rather than having to go into another tool.

Lack of communication from BizNet on new policies with the resellers, changes in the policies that affect the client aren't positive in my opinion

Incentivized

The system works well for us, and meets all of our needs. All of our future plans can and will be achieved within Prophix, so there is no need to pursue another product. Prophix has continuously proven to improve their product over the years, which provides an even higher level of confidence in this tool, and future developments

Excel knowledge is a prerequisite to use BizNet well.

I have used other reporting software over the years and so far this has been the simplest to set up, the most flexible to use and we have not yet used Prophix to its full capacity. Over the next year or so I can see us extending our use of Prophix to include any number of other functions.

Incentivized

The availability in Prophix is relatively good. We have occurred random outages in different versions that wipe out data, which can be brought back. Or we have ran into system wide slowness that impacts all users in the system, but we have been able to get more capacity to supply our performance.

Incentivized

Prophix has always performed consistently. We are using on-premise so many factors can contribute to slower than desired performance, most having nothing to do with Prophix itself. If we move to the web-client cloud based solution I believe performance will even be better.

Incentivized

We have only had a few occasions to call on the support team over 4 years, but every time our need was met in a superior manner.

The Prophix staff is very helpful and quick to respond. I like that they teach me instead of doing it for me when possible, so I don't have to contact them as often! Never talked to anyone at Prophix that I didn't respect or think highly of! Very professional, great customer service!

Incentivized

Training is essential for this software to be successful for any company. We unfortunately had a bad implementation and training manager so I can say with confidence that if we had the CSM we have now - we would be light years ahead of our knowledge of the system. I highly suggest taking all training opportunities and not rushing the implementation training

Incentivized

We used our system and created a test cube to work with our own data. We ran through the different functions of Prophix and covered alot of material. We did two sessions a week, with homework tasks assigned. We were able to ask questions and cover any questions during the followup sessions.

Incentivized

We went pretty seamlessly into BizNet, but could have had lots of trouble if the professional service was not aware of our set up and use.

Prophix Consulting should bring, in house, chargeable expertise in Oracle EBS table access for Drill Across and provide reasonable limits on dimension member combinations so there are no unreasonable expectations about the application of multi dimensional cubes to detail, such as revenue by product and customer.

Incentivized

I have used Flutter to begin and with flutter you need learn a language called Dart which is not needed with AQB, which is the main reason for us to pick Active Query Builder as a choice over Flutter. AQB supports all the merchant SQL databases with native syntax support, query optimizations and more

Incentivized

FRX - Great Plains Report Writer - These do produce financial reports but are much more tedious to set up. BizNet is much more flexible and easier to use. The functionality is an Excel add-on which allows us to use the powerful functionality of Excel as well as Biznet's functionality to do data retrieval from Sage 100 general ledger.

Incentivized

We felt Prophix was much more flexible than Briq and offered a more solid financial reporting and budgeting package. Briq is more custom built solution-focused. They build solutions to fit your specific needs. The primary reason we went with Prophix is that we wanted something we could tweak and design on our own after the initial build-out of the solution.

Incentivized

I gave Prophix a 10 on scalability because we currently deploy the solution to department heads across our entire organization and never have any issues with those individuals using or accessing the system to look at their financial information within premade templates . They currently enter budgets and review reports within the system currently. The only issue is they cannot typically use the ad hoc functionality because that would require higher level licenses that cost more and it is not worth it to give them more costly licenses since they really aren't working in the system quite like the robust finance users

Incentivized

• better business decisions allow us to maximize revenue for the company
• awesome ROI

Incentivized

• BizNet continues to pay for itself.
• I am sure we haven't even learned to use half of what it is capable of and their customer service is top notch.
• I would say that BizNet continues to have a positive impact on our entire financial portion of our business.

Incentivized

• Prophix has made it possible to move away from some Excel reporting we were doing, which allows for 50% quicker reporting on a monthly basis.
• Although it has saved us time, an improved PowerPoint feature that automatically updates our decks would save an additional 75% on top of what we already do.
• Our Board Reporting has improved by 10 hours by moving our reports fully into Prophix.