[Web-erp-svn] SF.net SVN: web-erp:[7871] trunk

[<dai...@us...>]

Revision: 7871
          http://sourceforge.net/p/web-erp/reponame/7871
Author:   daintree
Date:     2017-12-02 23:30:00 +0000 (Sat, 02 Dec 2017)
Log Message:
-----------


Modified Paths:
--------------
    trunk/doc/Change.log
    trunk/includes/MainMenuLinksArray.php
    trunk/sql/mysql/upgrade4.14.1-4.14.2.sql

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2017-12-02 13:19:00 UTC (rev 7870)
+++ trunk/doc/Change.log	2017-12-02 23:30:00 UTC (rev 7871)
@@ -1,5 +1,7 @@
 webERP Change Log
 
+
+3/12/17 Phil commited Tim's BankAccountBalances.php script
 2/12/17 Exson: Fixed the outstanding quantity is not right in PO_SelectOSPurchOrder.php.
 2/12/17 Phil committed Tim Schofield's fix for javascript date picker for US date formats
 2/12/17 Phil/Paul Becker: Purchases report - also deleted id non-exsitent in css committed changes suggested by VortecCPI http://www.weberp.org/forum/showthread.php?tid=7943 

Modified: trunk/includes/MainMenuLinksArray.php
===================================================================
--- trunk/includes/MainMenuLinksArray.php	2017-12-02 13:19:00 UTC (rev 7870)
+++ trunk/includes/MainMenuLinksArray.php	2017-12-02 23:30:00 UTC (rev 7871)
@@ -367,7 +367,8 @@
 												'/BankMatching.php?Type=Receipts',
 												'/GLJournal.php?NewJournal=Yes');
 
-$MenuItems['GL']['Reports']['Caption'] = array(	_('Bank Account Reconciliation Statement'),
+$MenuItems['GL']['Reports']['Caption'] = array(	_('Bank Account Balances'),
+												_('Bank Account Reconciliation Statement'),
 												_('Cheque Payments Listing'),
 												_('Daily Bank Transactions'),
 												_('Account Inquiry'),
@@ -383,7 +384,8 @@
 												_('Tag Reports'),
 												_('Tax Reports'));
 
-$MenuItems['GL']['Reports']['URL'] = array(	'/BankReconciliation.php',
+$MenuItems['GL']['Reports']['URL'] = array( '/BankAccountBalances.php',
+											'/BankReconciliation.php',
 											'/PDFChequeListing.php',
 											'/DailyBankTransactions.php',
 											'/SelectGLAccount.php',

Modified: trunk/sql/mysql/upgrade4.14.1-4.14.2.sql
===================================================================
--- trunk/sql/mysql/upgrade4.14.1-4.14.2.sql	2017-12-02 13:19:00 UTC (rev 7870)
+++ trunk/sql/mysql/upgrade4.14.1-4.14.2.sql	2017-12-02 23:30:00 UTC (rev 7871)
@@ -28,5 +28,5 @@
 ALTER TABLE `custbranch` CHANGE `lng` `lng` FLOAT(12,8) NOT NULL DEFAULT '0.00000000';
 
 ALTER TABLE pcashdetails MODIFY receipt text COMMENT 'Column redundant. Replaced by receipt file upload. Nov 2017.';
+INSERT INTO `scripts` (`script` ,`pagesecurity` ,`description`) VALUES ('BankAccountBalances.php',  '1',  'Shows bank accounts authorised for with balances');
 
-