Hi I love SuiteCrm (especially the apps where you can create invoices and proposals) there are just some missing features I need help withā¦where can I buy/how can I develop them:
inventory
bookkeeping (double entry)
human resources
bankstatemants-import
WooCommerce connection
payment gateway to pay invoices
notification when someone hasnāt paid his invoice, and enter partial payments
Please suggest available apps, or connections to opensource software :-). Any help will be greatly appreciated
The reason those features are missing in SuiteCRM is because is not Accounting. Now there is some leverage we can get inside SuiteCRM. Specially by using integrations. One way to integrate accounting is by using Quickbooks and using the paid modules available in the store: https://store.suitecrm.com/search/1/quickbooks/
First @cherub-chum knows suitecrm really well and can build stuff if you need. Iāve been chatting with him on the side as well about accounting this week (strange timing). I have made the decision to jump into this project https://akaunting.com/ Itās really great and in my opinion the closest thing to a āquick books experienceā without QB. I really donāt like the way QB held me hostage to give me the āfeatureā of making a bill. A āfeatureā ?? Charge extra to create a bill?? that was the final straw. I jumped ship. However, itās not perfect over there and Iām still in an āevaluation stageā but Iām going to try for more than one business. I feel that if SuiteCRM were to connect to Akaunting, we might have a real āthingā. They both open source, similar models with āinstallable paid appsā and really good foundation. I would encourage all devs and business owners to start looking at this.
Iāve also already looked into this, and it seems great . Do you think it would be easy to build a connector to SuiteCrm? Than we maybe would have the best out of both worlds . If docker maintainers are here, the akaunting docker project is looking for maintainers . https://github.com/akaunting/docker/issues/13
This could be a great app to buildā¦ I would pay the usual āapp priceā to be able to integrate with suitecrm for sure to save the time of building it etc.
I repeat that from what I can see Akaunting seems like the accounting home-run weāve been looking for. You canāt expect SuiteCRM to be a āreal accounting softwareā. Accountants need to be able to log in and do their āusual workā. They canāt be distracted with the āsuitecrm stuffā. Akaunting is very clean and promising. Once the bugs are gone, I can fully promote it to every business owner but right now itās still a little for the adventurousā¦ I wrote a document somewhere about how to set it upā¦ forgot to blog it. remind me and Iāll ātryā to blog it in next few months ha
Curious if this āAkauntingā worked out well. Im in Quickbooks but finding that even the paid quickbooks SUITECRM options in the store are works in progress. For example this one - Dreamers tech works best, but brings in fields that arent useful to me. (No Invoice numbers or Status) So I will require custom mods that hopefully get what I require.
The other ā Smackcoders look s promising but Iāve spent many late night / morning remote sessions with them that havent been very productive, Started with server perm issues, then general functionality issues. Will also require custom mods to get useful info like Invoice numbers or Status.
Sounds like there is no connector for Akaunting for SuiteCRM. Now, Im considering just exporting out invoices from QB and then importing them periodically into SuiteCRM,
Although my searches here show thats not as easy as I might hope.
One accounting system Iām evaluating right now is FrontAccounting. Itās an opens source model much like SuiteCRM and itās built with PHP and MySQL just like SuiteCRM. It takes some getting use to, the learning curve from quickbooks is a little steep because itās not all graphical interface like quickbooks, however it does everything a proper accounting system does and possibilities for integration are promising. Iām kind of stuck on data import at the moment which is hampering my switch from Quickbooks, but might be worth a look for anyone else whoās a dev and likes the PHP/MySQL environment.
I use Frontaccounting for 6 different businesses. I also use SuiteCRM for those same busiunesses. Once Iāve submitted my taxes later this week, I will be looking at ways to better integrate SuiteCRM and FA.
I have some partially finished code that pushes Accounts and Customers from FA into SuiteCRM. It isnāt polished to be a functioning module in FA yet, but it isnāt far away. I also have code that polls SuiteCRM for Accounts/Contacts, as well as separate code that creates Accounts/Customers in FA. Once I tie these all together there will be a bridge between FA and SuiteCRM.
As an aside, I use FA as the system of record for integrations. I also have code that generates CSVs for import into SquareUP and WooCommerce of products out of FrontAccouting, and I am almost done code to import Square and Woo exports of orders, customers, etc into FA. I just finished code that imports QFX/OFX downloads, as well as Walmart MC exports into FA.
Same. I feel rest can be used in some way for this and am possibly going to develop some type of connector for it depending on if my needs dictate or a full integration (nightmare) if required. It would be sooner rather than later. Iāll keep everyone posted
My current issue is importing all my records from Quickbooks. At the moment having trouble with the import feature of FrontAccounting. But ideally, Iād like to push quotes, invoices, and customers/contacts back and forth.
I see, QB and FA are different data models, so exports to CSV and converting to the FA data structure with your QB data is necessary. I donāt envy that if you have gobs of data.
Regarding FA and SCRM, looking for a bi-directional solution will require a method for syncing data between the two, whether by real-time or batch (real-time being the obvious goal). Thatās kind of yikes. (Sync, Polling, Session Mgmt, Network Availability). Since FA doesnāt support webhooks out of the box it complicates things but there is a Rest addon. Iām poking around at it today. Going to see if I can get rest for FA chugging along first and going from there. May see how complicated it would be to create a webhook solution for FA (Likely a nightmare but why not right )
@AeroDonkey Ive got all my qb data exported and formatted properly just cant figure out the import plugin. I think SuiteCRM and Frontaccounting would be a great pair if it could work.
Hey @AeroDonkey I created all my customers/contacts directly in the DB, Iāve imported my Chart of Accounts. Iām stuck on importing transactions. I canāt even get a single transaction to import. Even the example transaction! There were a couple minor PHP 8 issues in the log that I fixed, other than that Iām stuck. The documentation is kind of sketchy, Iāve tried a million different ways to format the data for import and I just canāt get it to go. Iām still figuring out the software so debugging is kind of tough. It really is a fantastic solution if I can get my past data in. I donāt really want to start fresh with no historical data.