Corneliu

Hi Virgil, Would you use OneSaas if we would deploy in Europe? We have a large number of European customers already but we were nevere aware of those laws. If you contact me (corneliu at onesaas.com) with some details/links about the laws we'll look into deploying an instance in Europe. Regards, Corneliu

Hello, Anyone from @support willing to answer this or should I just drop it in the "we don't support you bucket"? Thanks, Corneliu

Hi, We try to get data through the WHMCS REST API from multiple WHMCS servers. The call to GetInvoice on some of them returns the (line)item amounts including tax while on others it returns it excluding tax. Here are two samples from two servers. They both run the same WHMCS version 4.5.2: 1. Subtotal = sum of Item Amounts (13.50+25.00=38.50) Clearly no tax is applied on the line item. Applying tax brings the total to 42.35 <?xml version="1.0" encoding="iso-8859-1"?> <whmcsapi version="4.5.2"> <action>getinvoice</action> <result>success</result> <invoiceid>91001399</invoiceid> <invoicenum>0910369</invoicenum> <subtotal>38.50</subtotal> <credit>0.00</credit> <tax>3.85</tax> <tax2>0.00</tax2> <total>42.35</total> <balance>0.00</balance> <taxrate>10.00</taxrate> <taxrate2>0.00</taxrate2> <status>Paid</status> <items> <item> <id>1069</id> <type>DomainRegister</type> <relid>261</relid> <description>.....</description> <amount>13.50</amount> <taxed>1</taxed> </item> <item> <id>1070</id> <type>DomainRegister</type> <relid>262</relid> <description>...</description> <amount>25.00</amount> <taxed>1</taxed> </item> </items> </whmcsapi> 2. Line Items Amounts all include the tax amount: 100.00+100.00+100.00-68.18 = 231.82 Subtotal is 210.75 so clearly the sum of the line items includes the tax this time. <?xml version="1.0" encoding="utf-8"?> <whmcsapi version="4.5.2"> <action>getinvoice</action> <result>success</result> <invoiceid>3452</invoiceid> <invoicenum></invoicenum> <subtotal>210.75</subtotal> <credit>0.00</credit> <tax>21.07</tax> <tax2>0.00</tax2> <total>231.82</total> <balance>231.82</balance> <taxrate>10.00</taxrate> <taxrate2>0.00</taxrate2> <items> <item> <id>1334</id> <type>Addon</type> <relid>37</relid> <description>...</description> <amount>100.00</amount> <taxed>1</taxed> </item> <item> <id>1335</id> <type>Addon</type> <relid>39</relid> <description>...</description> <amount>100.00</amount> <taxed>1</taxed> </item> <item> <id>1336</id> <type>Addon</type> <relid>38</relid> <description>...</description> <amount>100.00</amount> <taxed>1</taxed> </item> <item> <id>1337</id> <type>GroupDiscount</type> <relid>0</relid> <description>...</description> <amount>-68.18</amount> <taxed>1</taxed> </item> </items> </whmcsapi> Any idea why we get different results from different servers? Is this an option somewhere that has to be turned on/off? Is it possible to get a consistent result from this API? Thanks, Corneliu.

Hi, We try to access the API remotely via the /includes/api.php for a customer and we get back: result=error;message=Invalid Access Key So we asked the customer for the API key as configured in the configuration.php and we tried to call the API again with the apikey hashed with md5: This call fails with the same error: accesskey=7211a0afe032b432838e9f6903ec&username=whmcs&password=98ae70a9441a054 ba125663c1a&action=getpaymentmethods This also fails accesskey=7211a0afe032b432838e9f6903ec&action=getpaymentmethods How are we supposed to be push the apikey to the api? I could not find any documentation on using the API key, only on using the username/password but that does not seem to work anymore if the api key is configured. Thanks, Corneliu.

Guys, You might want to checkout OneSaas (http://www.onesaas.com). We have a cloud base integration between WHMCS and Saasu (http://www.saasu.com) and Xero (http://www.xero.com) two of the best online accounting systems. http://www.onesaas.com/integrate/whmcs We can automatically read all the invoices from WHMCS and transform them and push them into the accounting system all coded in the correct accounts and with the correct tax information and tax codes. Give it a try. You might need some advice from your accountant regarding how to properly configure your accounting system but we can help you setup the automatic link between WHMCS and your accounting. Regards, Corneliu

Hi, We noticed that in one of the last releases (not sure which) the order of the invoices returned by the "getinvoices" API call has changed. Page 0 now has the newest invoices while the last page has the oldest ones. 1. Is there a way to control this behaviour? This broke our integration with other products that were trying to read the last page only. Can we force them to always be in a specific order? 2. Is there a way through the API to check the version of WHMCS so we can adjust the reading order through the API (first page first in the new version or last page for older version of whmcs)? 3. Could we ask for only the invoices that were changed since a timestamp? Currently we need to reload all the invoices in order to see if any was paid or changed. This implies for few of our customers loading over 10000 invoices every hour to check for changes. Thanks, Corneliu.

Hi Matt, Thanks for the answers. At no 2 I wanted to say: 2. If an invoice is paid with two methods (e.g. 50% deposit 50% paypal) we don't know that and there is no way to get that via the API. This is a major issue as we can't push the correct payment of the invoice into an accounting system as we don't know in which accounts the payments were made. Thanks, Corneliu.

Hi, We are currently trying to use the WHMCS API to integrate WHMCS with several accounting systems however we encounter issues with it. 1. The most critical issue is that in some (unknown) scenarios the API does not give us the payment details of an order. We have an order with a payment attached (see attachment). When we ask the order via the API (with getinvoice as action) we get the following: Call: username=*****&password=******&action=getinvoice&invoiceid=1574 Response: <?xml version="1.0" encoding="utf-8"?> <whmcsapi version="4.4.2"> <action>getinvoice</action> <result>success</result> <invoiceid>1574</invoiceid> <invoicenum></invoicenum> <userid>****</userid> <date>2011-03-14</date> <duedate>2011-03-14</duedate> <datepaid>0000-00-00 00:00:00</datepaid> <subtotal>2200.00</subtotal> <credit>0.00</credit> <tax>220.00</tax> <tax2>0.00</tax2> <total>2420.00</total> <balance>1220.00</balance> <taxrate>10.00</taxrate> <taxrate2>0.00</taxrate2> <status>Unpaid</status> <paymentmethod>banktransfer</paymentmethod> <notes><![CDATA[]]></notes> <items> <item> <id>110</id> <type></type> <relid>0</relid> <description>******* </description> <amount>2420.00</amount> <taxed>1</taxed> </item> </items> </whmcsapi> There is no date paid: http://wiki.whmcs.com/API:Get_Invoice We also don't know the amount paid. 2. On top of that, if an order is paid with two methods (e.g. 50% deposit 50% paypal) we don't know that and there is no way to get that via the API. This is a major issue as we can't push the correct payment of the invoice into an accounting system as we don't know in which accounts the payments were made. 3. Now the last issue is that we can't request via the API all invoices (http://wiki.whmcs.com/API:Get_Invoices) that have been changes since a specific date (e.g. updated_from=2011-03-01) so the only way to get the changed invoices is to go and request for all invoices starting with the first one via the get them all which means we can get hundreds of invoices. On top of that the invoices returned from the GetInvoices call don't carry a lastupdated timestamp so to see if they were changed we then have to call GetInvoice on each one of them. So all the process of pushing invoices into an accounting system becomes extremely intensive in terms of API calls. It would be really great if the API could be updated to cater for the following scenarios: 1. Get updates (updated_since=[timestamp]) and get all the changes since that time 2. All entities (Invoices, Orders, Contacts) to have a LastUpdated field with a timestamp of the last change 3. GetInvoices should contain the LastUpdated for the Invoice 4. Support multiple payments on an Invoice via the API and return the complete details of _each_ payment on the invoice. (date of each payment, method, amount, transaction id, fees) Thanks, Corneliu.