AvocentX

I reach out to the community, as we have somewhat of an accounting problem with WHMCS. Here is the background: Client 1 buys a service and pays his €100 invoice. The VAT is calculated on the invoice and everything is fine. We have an invoice with a related transaction and ID. Client 2 chooses Add Funds to his account, paying a €100 invoice. No VAT is added to the "Add Funds" invoice, but the transaction is added as reference. At a later stage, the client orders the same €100 service and VAT is calculated and part of the invoice. One problem is that the invoice will not have any reference to an actual transaction. Client 3 is mainly an affiliate and earns €100 that is added to his credit balance. Client 3 orders the same €100 service and uses the credit to pay for the invoice. VAT is calculated and added just as in the other two scenarios. Our problem is how to calculate our totals, such as in sales figure, VAT amounts etc. We have to be able to show each and every transaction coming in, as well as round up the VAT amount for each EU member country. We have been doing this based on transactions, but realizes that any Add Funds payment goes unaccounted for. We are not very keen on paying VAT on affiliate earnings, as we never actually sold a product for money - but more gave that away for free (i e not VAT) How are we supposed to find a logic that will get us the actual figures and mainly the VAT amount? We can't go on transactions, as that is clearly wrong. We can't use paid invoices, as it may very well be paid by credits where we never took any money from that client? I realize that the accounting rules may differ between countries, but still the logic should be just about the same? Any help or input will be greatly appreciated!

It's been quite some time since those questions were asked. What is the status on those? Furthermore, how does the monitoring work - as in how can notifications be delivered to staff members?

We are looking at sending a 'coupon' that adds a given amount to their credit balance, though we need to mass email this to our client database in WHMCS. Is this doable with your addon or does it require each GC to be set manually?

I am in need of a custom report tools. Right now we have sales with and without VAT. We also have 4 different currencies, with exchange rates updated daily. Basically I would like a report that can present (besides the existing report results): Total VAT per one specific country Total VAT per remaining EU countries Conversion of all daily sales into ONE specific currency Ideally one daily view with each transaction, invoice ID, client name, amount, fee, gross amount, VAT (two different as mentioned above) and the sales listed in one particular currency. Right now the "default" currency is EURO, but due to taxation rules the amounts needs to be in another currency.

Could you consider doing that and if so, how much?

We are currently looking for someone to code a WHMCS Hooks that will create a MySQL db and set PHPMyAdmin access and email the info. Another hook for termination of the MySQL db and access on WHMCS service termination. Have someone already got this running and would like to share/sell the solution? Another possible solution would be someone else looking for the same features and where we can split the costs of having the scripts coded.

Hello, We are currrently using WHMCS and TCAdmin (game server control panel) We have started to look into the possibility to offer MySQL hosting through PLESK as an option to the game server, but we are not sure if this is doable. We need everything to be automated, so it's important that the same order form can be used, the services are set automatically as well as suspended/terminated when expired. Can anyone share some light on this? We currently have WHMCS 4.2.1 and Plesk Panel 9.5

I have set my WHMCS install to redirect the buyers to the payment gateway automatically. It did work before, but since I enabled the IGN service at Paypal - the redirect doesnt work anymore. I see the Paypal Pay Now and Subscribe buttons flashing by and then the customer is taken back to my Cart. Any clue what might causing the problem? I have been forced to take the customer to their invoice for the time being.