logo
down
shadow

Trial Balance Update accounts


Trial Balance Update accounts

Content Index :

Trial Balance Update accounts
Tag : php , By : Andrew Bailey
Date : November 29 2020, 09:01 AM

seems to work fine Am looking to update my chartofaccount to get an trial balance here what i have in the table of chartofaccount
$select2="SELECT Distinct(parent) FROM chartofaccount
                            ORDER BY parent DESC";
            $run2=mysql_query($select2,$con);
            if(!$run2)die("ERROR22".mysql_error());

            for($counter=0;$row1=mysql_fetch_assoc($run2);$counter++){

                $parentid=$row1['parent'];

                $select3="SELECT sum(debit),sum(credit),parent
                            FROM chartofaccount
                            WHERE parent='$parentid'
                            group by parent";
                $run3=mysql_query($select3,$con);
                if(!$run3)die("ERROR22".mysql_error());

                for($counter=0;$row2=mysql_fetch_array($run3);$counter++){

                        $parentidz=$row2[2];

                            $update3="UPDATE chartofaccount
                                        SET debit='$row2[0]',
                                            credit='$row2[1]'
                                            WHERE Id='$parentidz'";
                            $run4=mysql_query($update3,$con);
                            if(!$run4)die("ERROR1".mysql_error());
                }
            }

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Creating a view that shows the balance of accounts on every day, when the "balance" table only has entries on


Tag : sql , By : Eugenio
Date : March 29 2020, 07:55 AM
this will help It would be easier to provide more correct query, if you'll provide description for tables and some sample data. However, I think this query would work - it'll return the closest to given date row from BALANCE:
SELECT * FROM DATES d, BALANCE b
WHERE d.date >= b.date
      AND b.date >= ALL (SELECT b1.date FROM BALANCE b1
                    WHERE b1.date <= d.date
                          AND b1.account = b.account)
SELECT d.date, b.account, b.balance FROM DATES d, BALANCE b
WHERE d.date >= b.date
      AND b.date >= ALL (SELECT b1.date FROM BALANCE b1
                         WHERE b.account = b1.account
                               AND d.date >= b1.date)
ORDER BY d.date, b.account

Create Trial Balance via Sql in MySql


Tag : mysql , By : negonicrac
Date : November 14 2020, 05:16 PM
hope this fix your issue You could achieve that result with a select over a union of two queries, one for the month to date and one for the year to date figures.
select accno, accopbal, sum(mtd_d), sum(mtd_c), sum(ytd_d),sum(ytd_c)
from 
(   select ao.accno
         , ao.accOpBal
         , 0 as mtd_d
         , 0 as mtd_c
         , 0 as ytd_d
         , 0 as ytd_c
    from accounts ao
    left outer join transactions tn on tn.accno = ao.accno
    where tn.accno is null
    union
    select tm.accno
         , a.accOpBal
         , sum(tm.transdebit) as mtd_d
         , sum(tm.transcredit) as mtd_c
         , 0 as ytd_d
         , 0 as ytd_c
    from accounts a
    right outer join transactions tm on tm.accno = a.accno
    where tm.transdt between '2014-01-01' and '2014-01-31'
    group by a.accno, a.accopbal
    union 
    select ty.accno
         , a.accOpBal
         , 0
         , 0
         , sum(ty.transdebit)
         , sum(ty.transcredit)
    from accounts a
    right outer join transactions ty on ty.accno = a.accno
    and ty.transdt between '2013-07-01' and  '2014-01-31'
    group by a.accno, a.accopbal
) alltxn
group by accno, accopbal
-- january
insert into transactions values (1, 'alfki', '2014-01-01', 1,3); 
insert into transactions values (1, 'alfki', '2014-01-02', 1,3); 
insert into transactions values (1, 'alfki', '2014-01-03', 1,3); 

-- last year
insert into transactions values (1, 'alfki', '2013-09-01', 5,2);

-- txn without acc
insert into transactions values (1, 'noexi', '2014-01-03', 4,2); 


-- acc with txn
INSERT INTO Accounts values ( 'alfki', 'alfred', 4);
-- acc without txn
INSERT INTO Accounts values ( 'lefto', 'lefto', 6);
ACCNO | ACCOPBAL |SUM(MTD_D)|SUM(MTD_C)|SUM(YTD_D)|SUM(YTD_C)
------+----------+----------+----------+----------+-----------
alfki |  4       |      3   |     9    |    8     |   11
lefto |  6       |      0   |     0    |    0     |    0
noexi | (null)   |      4   |     2    |    4     |    2

PHP/MySQL Multidimensional/Associative Arrays 3 Trial Balance


Tag : php , By : eferro
Date : March 29 2020, 07:55 AM
This might help you Ok (I should've paid more concentration during those accounts lectures). Now I don't know if an account (except Bank and Cash) can have debit and credit at the same time, but since your example entries didn't indicate, I'm guessing it doesn't. Also, the below code assumes (like indicated in the comment above) that you have a column (I named it transaction) which says whether it's a Dr or Cr entry.
//this array will hold bank and cash values
$main_acc=array('bank'=>array('Dr'=>0,'Cr'=>0), 'cash'=>array('Dr'=>0,'Cr'=>0));

//this one to hold other accounts and their amounts, transaction etc.
$acc = array();
while($rowin = mysqli_fetch_array($rein, MYSQLI_ASSOC)) {
    /* store bank transaction type and amount */
    if($rowin['paymode']=='Cheque'){
        $main_acc['bank'][$rowin['transaction']] =$main_acc['bank'][$rowin['transaction']] + $rowin['amount'];
    }
    /* store cash transaction type and amount */
    if($rowin['paymode']=='Cash'){
        $main_acc['cash'][$rowin['transaction']] = $main_acc['cash'][$rowin['transaction']] + $rowin['amount'];
    }
    /* store other account transaction type and increment
       amount if already exists */
    if(isset($acc[$rowin['account']])){
        $acc[$rowin['account']]['amount'] = $acc[$rowin['account']]['amount'] +$rowin['amount'];
    }
    else
    {
        $acc[$rowin['account']]['trans'] = $rowin['transaction'];
        $acc[$rowin['account']]['amount'] = $rowin['amount'];

    }

}

echo '
<table>
<tr>
    <td align="left"><b>ACCOUNT</b></td>
    <td align="right"><b>DEBIT</b></td>
    <td align="right"><b>CREDIT</b></td>
</tr>
';

$bg = '#eeeeee';
//displaying bank and cash
foreach($main_acc as $key=>$val){

            $bg = ($bg=='#eeeeee') ? '#ffffff' : '#eeeeee';
            echo '<tr bgcolor="'. $bg .'">
                    <td align="left">'. $key .'</td>
                    <td align="left">'. (($val['Cr']!=0)?$val['Cr']:'') .'</td>
                    <td align="right">'. (($val['Dr']!=0)?$val['Dr']:'').'</td>
                  </tr>
        ';
}

//displaying other accounts
foreach($acc as $key=>$val){

            $bg = ($bg=='#eeeeee') ? '#ffffff' : '#eeeeee';
            echo '<tr bgcolor="'. $bg .'">
                    <td align="left">'. $key .'</td>
                    <td align="left">'. (($val['trans']=='Dr')?$val['amount']:'') .'</td>
                    <td align="right">'. (($val['trans']=='Cr')?$val['amount']:'') .'</td>
                  </tr>
        ';
}
echo '</table>';
ACCOUNT DEBIT   CREDIT
bank    5000    
cash    2000      500
TUITION          7000
Repairs 500

SQL Query for Aged Trial Balance Report in MySQL


Tag : mysql , By : wpoch
Date : March 29 2020, 07:55 AM
I hope this helps you . So far my query produces customers' accounts' current balance and the total amounts that were invoiced during the following groups of days after the report is generated: 0-30, 30-60, 60-90, 90+.
SELECT account_number,
       Balance,
       `0-30` - (total_invoices - Balance - LEAST(`90+` + `60-90` + `30-60`, total_invoices - Balance)) AS `0-30`,
       `30-60` - (total_invoices - Balance - LEAST(`90+` + `60-90`, total_invoices - Balance)) AS `30-60`,
       `60-90` - (total_invoices - Balance - LEAST(`90+`, total_invoices - Balance)) AS `60-90`,
       GREATEST(0, `90+` - (total_invoices - Balance)) AS `90+`
FROM (...)

Google cloud free trial billing account closed after 1 week with balance remaining


Tag : google-cloud-platfor , By : John Studdert
Date : March 29 2020, 07:55 AM
help you fix your problem The free trial account was suspended. Reason - "Unfortunately, we were unable to verify billing instrument ownership using the documents you submitted" says Google.
Solution
Related Posts Related QUESTIONS :
  • Does PhpStorm allow to skip PHPDoc tags when type hints is declared?
  • html classes are changed to Attributes
  • Using json to import multidimensional data
  • passing data from the view to the controller, where the data comes from another controller
  • How to extract integer and decimal numbers in PHP string correctly?
  • Parsing Sub-Object from an XML Feed with objects
  • Getting error "Unknown column 'text' in 'field list'"
  • How to properly get onedrive access token via php and curl
  • How to add spell check to a php function
  • Is it posible to create css rules with php?
  • Pretty URL with $_GET method
  • Wordpress always load same page - index.php
  • Find value in array and return with new from different array
  • PHP multiple file upload with different keys
  • Can't modify times one a time without weird errors
  • Get size of scraped image with domcrawler (Goutte)
  • Laravel - Ordering a collection of models
  • PHP Fatal error: Uncaught Error: Call to a member function setFetchMode() on boolean
  • Strict Standards: Only variables should be passed by reference in /main_dir/sub_dir/backup.php
  • Uncaught Google_Exception: (update) unknown parameter: 'copyRequiresWriterPermission'
  • Laravel 5 form does not redirect with old input
  • How to get values greater than or equal to in Mysql database sql when its a value like 1:00 PM?
  • PHP datediff overday issue
  • Masking an auto incrementing primary key
  • How to grab a String BEFORE a certain word
  • ZF2 Routing Multiple Controllers based on route constraints
  • How to deregister/dequeue jquery.sticky.js in Elementor (Pro)?
  • How to fix errors counting words in text plain with PHP?
  • How to get View data in Laravel in custom helper or directive
  • Creating a new data entry into a database with eloquent and trying to access the variable in the url
  • How to test authentication using Laravel Dusk?
  • PHP parse_str not getting all $_GET variables
  • Variable issues in php class
  • Get orders between dates in Codeigniter
  • Eloquent Special Chars Issue
  • Keeping leading zeros column Mysql
  • Current level navigation in Wordpress
  • Add a custom text to WooCommerce cart items if the product has a specific shipping class
  • Error connecting to CommissionJunction Token : [60] SSL certificate problem: unable to get local issuer certificate
  • How do I add a new key value pair to an object in PHP?
  • Http post request to php with dart
  • How to add a route in with blade into parameters of a component
  • How can i get the source of a 777 - CHMOD php file?
  • Convert 2010-04-16 16:30:00 to "Tomorrow Afternoon"
  • How can I hide a $_GET variable to be more secured in PHP?
  • Login to Gmail Inbox using Curl?
  • Upload Excel or CSV file to MySQL with PHP
  • Outlook Marking Email as Junk Email
  • Upload an image using class.upload.php via AJAX, display image in form using jQuery
  • mysql_connect() causes page to not display (WAMP)
  • How to limit a users uploaded image size using PHP
  • What's the difference whether or not to run PHP in safe mode?
  • Logging in to a website cURL
  • Using php to create a password system with chinese characters
  • PHP is not called properly in IE using set interval function in Javascript
  • How to read pdf, ppt, xl, doc files content into a string in php/python
  • php script for currency conversion
  • In PHP... best way to turn string representation of a folder structure into nested array
  • PayPal for Indian Rupees (INR) any solution
  • PHP Deployment to Live Server
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com