*SOLVED* QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

*SOLVED* QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

Integration with QuickBooks is easy if you know the OAuth flow. QuickBooks uses the OAuth 1.0 specification. They provide libraries for PHP, Java and other popular languages. For ColdFusion/Railo, you can use the OAuth implementation from http://oauth.riaforge.org/. Usually the error messages from QB are self-explanatory and are mostly related with Signature...Read more

Mysql join and sum is doubling result

The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue, Sum(cost) cost FROM revenue GROUP BY revenue.title_id) r LEFT JOIN (SELECT title_id, Sum(interest) interest FROM fund GROUP BY title_id) f...Read more