Menu
▾
▴
[Web-erp-svn] SF.net SVN: web-erp:[5769] trunk
|
From: <te...@us...> - 2012-12-22 13:37:30
|
Revision: 5769
http://sourceforge.net/p/web-erp/reponame/5769
Author: tehonu
Date: 2012-12-22 13:37:17 +0000 (Sat, 22 Dec 2012)
Log Message:
-----------
Pak Ricard: Added new script to show all goods received but not invoiced yet.
Modified Paths:
--------------
trunk/includes/MainMenuLinksArray.php
trunk/sql/mysql/upgrade4.09-4.10.sql
Added Paths:
-----------
trunk/GoodsReceivedNotInvoiced.php
Added: trunk/GoodsReceivedNotInvoiced.php
===================================================================
--- trunk/GoodsReceivedNotInvoiced.php (rev 0)
+++ trunk/GoodsReceivedNotInvoiced.php 2012-12-22 13:37:17 UTC (rev 5769)
@@ -0,0 +1,127 @@
+<?php
+
+/* Session started in session.inc for password checking and authorisation level check config.php is in turn included in session.inc*/
+
+include ('includes/session.inc');
+$title = _('Goods Received But Not Invoiced Yet');
+include ('includes/header.inc');
+
+$SQL = "SELECT grns.supplierid,
+ purchorderdetails.orderno,
+ grns.itemcode,
+ grns.qtyrecd,
+ grns.quantityinv,
+ purchorderdetails.unitprice,
+ suppliers.currcode,
+ currencies.rate,
+ currencies.decimalplaces
+ FROM grns, purchorderdetails, suppliers, currencies
+ WHERE grns.podetailitem=purchorderdetails.podetailitem
+ AND grns.supplierid = suppliers.supplierid
+ AND suppliers.currcode = currencies.currabrev
+ AND grns.qtyrecd - grns.quantityinv > 0
+ ORDER BY grns.supplierid, purchorderdetails.orderno, grns.itemcode";
+$result = DB_query($SQL, $db);
+
+if (DB_num_rows($result) != 0){
+ echo '<p class="page_title_text" align="center"><strong>' . _('Goods Received but not invoiced Yet') . '</strong></p>';
+
+ echo '<div class="page_help_text">'
+ . _('Shows the list of Goods Received Not Yet Invoiced, both in supplier currency and home currency.'). '<br />'
+ . _('Total in home curency should match the GL Account for Goods received not invoiced.'). '<br />'
+ . _('Any discrepancy is due (probably) to multicurrency errors and must be fixed via GL Journal.')
+ . '</div>';
+
+ echo '<div>';
+ echo '<table class="selection">';
+ $TableHeader = '<tr>
+ <th>' . _('Supplier') . '</th>
+ <th>' . _('PO#') . '</th>
+ <th>' . _('Item Code') . '</th>
+ <th>' . _('Qty Received') . '</th>
+ <th>' . _('Qty Invoiced') . '</th>
+ <th>' . _('Qty Pending') . '</th>
+ <th>' . _('Unit Price') . '</th>
+ <th>' .'' . '</th>
+ <th>' . _('Line Total') . '</th>
+ <th>' . '' . '</th>
+ <th>' . _('Line Total') . '</th>
+ <th>' . '' . '</th>
+ </tr>';
+ echo $TableHeader;
+ $k = 0; //row colour counter
+ $i = 1;
+ $TotalHomeCurrency = 0;
+ while ($myrow = DB_fetch_array($result)) {
+ if ($k == 1) {
+ echo '<tr class="EvenTableRows">';
+ $k = 0;
+ } else {
+ echo '<tr class="OddTableRows">';
+ $k = 1;
+ }
+ $QtyPending = $myrow['qtyrecd'] - $myrow['quantityinv'];
+ $TotalHomeCurrency = $TotalHomeCurrency + ($QtyPending * $myrow['unitprice'] / $myrow['rate']);
+ printf('<td>%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ <td class="number">%s</td>
+ <td class="number">%s</td>
+ <td class="number">%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ </tr>',
+ $myrow['supplierid'],
+ $myrow['orderno'],
+ $myrow['itemcode'],
+ $myrow['qtyrecd'],
+ $myrow['quantityinv'],
+ $QtyPending,
+ locale_number_format($myrow['unitprice'],$myrow['decimalplaces']),
+ $myrow['currcode'],
+ locale_number_format(($QtyPending * $myrow['unitprice']),$myrow['decimalplaces']),
+ $myrow['currcode'],
+ locale_number_format(($QtyPending * $myrow['unitprice'] / $myrow['rate']),$_SESSION['CompanyRecord']['decimalplaces']),
+ $_SESSION['CountryOfOperation']
+ );
+ $i++;
+ }
+ printf('<td>%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ <td class="number">%s</td>
+ <td class="number">%s</td>
+ <td class="number">%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ <td class="number">%s</td>
+ <td>%s</td>
+ </tr>',
+ "",
+ "",
+ "",
+ "",
+ "",
+ "",
+ "",
+ "",
+ "",
+ _('Total').':',
+ locale_number_format($TotalHomeCurrency,$_SESSION['CompanyRecord']['decimalplaces']),
+ $_SESSION['CountryOfOperation']
+ );
+
+ echo '</table>
+ </div>
+ </form>';
+}
+
+include ('includes/footer.inc');
+
+?>
\ No newline at end of file
Modified: trunk/includes/MainMenuLinksArray.php
===================================================================
--- trunk/includes/MainMenuLinksArray.php 2012-12-20 08:38:22 UTC (rev 5768)
+++ trunk/includes/MainMenuLinksArray.php 2012-12-22 13:37:17 UTC (rev 5769)
@@ -145,7 +145,8 @@
_('Outstanding GRNs Report'),
_('Supplier Balances At A Prior Month End'),
_('List Daily Transactions'),
- _('Supplier Transaction Inquiries')
+ _('Supplier Transaction Inquiries'),
+ _('Goods Received Not Invoiced Yet')
);
$MenuItems['AP']['Reports']['URL'] = array ('/AgedSuppliers.php',
@@ -154,7 +155,8 @@
'/OutstandingGRNs.php',
'/SupplierBalsAtPeriodEnd.php',
'/PDFSuppTransListing.php',
- '/SupplierTransInquiry.php'
+ '/SupplierTransInquiry.php',
+ '/GoodsReceivedNotInvoiced.php'
);
$MenuItems['AP']['Maintenance']['Caption'] = array (_('Add Supplier'),
Modified: trunk/sql/mysql/upgrade4.09-4.10.sql
===================================================================
--- trunk/sql/mysql/upgrade4.09-4.10.sql 2012-12-20 08:38:22 UTC (rev 5768)
+++ trunk/sql/mysql/upgrade4.09-4.10.sql 2012-12-22 13:37:17 UTC (rev 5769)
@@ -10,6 +10,5 @@
);
ALTER TABLE `gltrans` ADD INDEX ( `tag` );
INSERT INTO scripts VALUES ('CustomerPurchases.php','5','Shows the purchases a customer has made.');
+INSERT INTO scripts VALUES ('GoodsReceivedButNotInvoiced.php','15','Shows the list of Goods Received Not Yet Invoiced, both in supplier currency and home currency. Total in home curency should match the GL Account for Goods received not invoiced. Any discrepancy is due to multicurrency errors.');
UPDATE config SET confvalue='4.10.0' WHERE confname='VersionNumber';
-
-
|
