Jump to content
Sign in to follow this  

How much I earned by product? Sum balance by product

Recommended Posts

I'd like to know how do I find the sum of the total balance per product. I mean full paid invoices and partial invoices.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Blasgo
      Good morning community
      How do I make all the services to be renewed appear on the "Customer Invoice"?
      In all "Customer Invoice" emails I only see that the hosting service appears and does not add the domain, both services were purchased the same day.
      The domain renewal is sent in different mail.
      I will greatly appreciate your help

    • By Tengri
      For some reasons sometimes our banks don't accept invoice from customers without stamp, name of CEO and signature. Is there any way that when the user chooses payment via a Bank under the invoice had the name of the Director signature and stamp.
      Thank you!
    • By sokalsondha
      Dear everyone.. greetings from me.
      i just need some suggestion from the experts.
      currently i am in ireland and using my whmcs for irish market. so my currency is euro. and my website all the products shows as in euros.
      i am planning to start a brand for host in bangladesh where i am originally from but i have the different price set for bangladesh website..
      just to let u know i made another website for bangladesh market. and in the website prices are set in BDT not in euro
      i am looking for some solution when a visitor visit bangladesh website and select the product it will be shows the product sets for bangladesh and price will shown BDT not in euros
      but when client from ireland will visit the website they will see euros.. i want to set euros as default. also like visitor from UK will see product sets for UK and price will shown in GBP.
      do i need hook make for this? or what thing i need to customise? or need some module?
      can someone help me with some suggestion?
      thanks in advance
    • By sokalsondha
      Hello community...
      I came back again. Can someone help me with my system.
      What happened is..
      We sell yearly service. Let's say client bought service 01/04/2018
      And his next due date is 31/03/2019.
      Now system generate invoice on 15/03/209
      But he didn't paid.
      He decide to pay on may..
      I knw the service will be suspended. But it's not a problem.
      Now if he pay on may .. I see his next due date will be 31/03/2020 not 01/05/2020
      So he is loosing a month when he didn't used the service in April.
      Can we have a hook to update the next invoice date the customer paid+365 days? 
      Please help me
    • By eliasaphram
      Im trying to use Githubs version of AutoAuth:
      I've followed the steps in the description, but are getting wrong login credentials error. Below you can see the different steps and the code that i have;
      To install this script you need to place all files in your root directory of WHMCS
      example: /home/user/public_html/domain/whmcs/
      Generate a hash and enter it in configuration.php above the last ?>
      $autoauthkey = "REPLACE-WITH-SYSTEM-KEY";
      Also include it into the script.
      You can generate a hash using; openssl rand -hex 32 on linux.
      Then add this value to the top of your email template;
      {assign var='hash' value=$client_email|cat:"REPLACE-THIS-PART-WITH-SECRET-KEY"}
      Then add this link anywhere in your email template.
      Login Auth: {$whmcs_url}lauth.php?email={$client_email}&zmkey={$hash|md5}
      Invoice Auth: {$whmcs_url}iauth.php?email={$client_email}&invoice={$invoice_num}&zmkey={$hash|md5}
      Quote Auth: {$whmcs_url}qauth.php?email={$client_email}&quote={$quote_number}&zmkey={$zmkey|md5}
      Quick not for version 7+
      Due to security settings, you have to modify configuration.php and add the following code to the bottom, above the last ?>
      $smarty_security_policy = array( 'mail' => array( 'php_modifiers' => array( 'md5', 'time', 'sha1', 'urlencode', 'header', ), ), );  
      In the config file:
      $hash = "302BEA0FDBC6ADB8F8A25919318B532D";
      $autoauthkey = "Correct_password";
      $smarty_security_policy = array(
          'mail' => array(
              'php_modifiers' => array(
      In the iauth file:
      Created by JonTheWong @ Zenith Media Canada - www.zenithmedia.ca
      Visit our public repo - https://github.com/JonTheWong/whmcs-autoauth-invoice
      $whmcsurl = "https://www.webbsnacks.se/whmcs/dologin.php"; /* replace with your url */
      $autoauthkey = "Correct_password"; /* same as in configuration.php */
      $secretkey = "A_new_key_generated"; /* generate a new key for this script */
      if (md5($_GET['email'].$secretkey) != $_GET['zmkey'])
      die('Något fel har skett, vänligen kontakta oss på info@webbsnacks.se för att gå vidare.');
      $email = $_GET['email'];
      $timestamp = time();
      $hash = sha1($email.$timestamp.$autoauthkey);
      $goto = "viewinvoice.php?id=".$_GET['invoice'];
      $url = $whmcsurl."?email=$email&timestamp=$timestamp&hash=$hash&goto=".urlencode($goto);
      header("Location: $url");
      Do anyone know what the issue might be? Since im not getting the "die" text, there should be nothing wrong with the hash, correct?
  • Recently Browsing   0 members

    No registered users viewing this page.


Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated