Menu
▾
▴
[Web-erp-svn] SF.net SVN: web-erp:[5775] trunk
|
From: <dai...@us...> - 2012-12-24 05:01:06
|
Revision: 5775
http://sourceforge.net/p/web-erp/reponame/5775
Author: daintree
Date: 2012-12-24 05:01:04 +0000 (Mon, 24 Dec 2012)
Log Message:
-----------
manual details of variances on goods received
Modified Paths:
--------------
trunk/OutstandingGRNs.php
trunk/doc/Manual/ManualAccountsPayable.html
trunk/includes/MainMenuLinksArray.php
Removed Paths:
-------------
trunk/GoodsReceivedNotInvoiced.php
Deleted: trunk/GoodsReceivedNotInvoiced.php
===================================================================
--- trunk/GoodsReceivedNotInvoiced.php 2012-12-24 03:29:35 UTC (rev 5774)
+++ trunk/GoodsReceivedNotInvoiced.php 2012-12-24 05:01:04 UTC (rev 5775)
@@ -1,118 +0,0 @@
-<?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 INNER JOIN purchorderdetails
- ON grns.podetailitem=purchorderdetails.podetailitem
- INNER JOIN suppliers
- ON grns.supplierid = suppliers.supplierid
- INNER JOIN currencies
- ON suppliers.currcode = currencies.currabrev
- WHERE 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 currency calculated at Purchasing Price converted at current exchange rate, not Standard cost!'). '<br />'
- . '</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['CompanyRecord']['currencydefault']);
-
- if ($i==15){
- $i=0;
- echo $TableHeader;
- } else {
- $i++;
- }
- }
- printf('<td colspan="9">%s</td>
- <td>%s</td>
- <td class="number">%s</td>
- <td>%s</td>
- </tr>',
- '',
- _('Total').':',
- locale_number_format($TotalHomeCurrency,$_SESSION['CompanyRecord']['decimalplaces']),
- $_SESSION['CompanyRecord']['currencydefault']);
-
- echo '</table>
- </div>
- </form>';
-}
-
-include ('includes/footer.inc');
-
-?>
\ No newline at end of file
Modified: trunk/OutstandingGRNs.php
===================================================================
--- trunk/OutstandingGRNs.php 2012-12-24 03:29:35 UTC (rev 5774)
+++ trunk/OutstandingGRNs.php 2012-12-24 05:01:04 UTC (rev 5775)
@@ -232,7 +232,7 @@
$i++;
}
}
- printf('<td colspan="10">%s</td>
+ printf('<td colspan="9">%s</td>
<td>%s</td>
<td class="number">%s</td>
<td>%s</td>
Modified: trunk/doc/Manual/ManualAccountsPayable.html
===================================================================
--- trunk/doc/Manual/ManualAccountsPayable.html 2012-12-24 03:29:35 UTC (rev 5774)
+++ trunk/doc/Manual/ManualAccountsPayable.html 2012-12-24 05:01:04 UTC (rev 5775)
@@ -215,7 +215,15 @@
<li>With Shipment costing - the total amount of the charge is posted to the debit of the goods received clearing account - variances are taken up only once all shipment charges are in and the user explicity "closes" the shipment</li>
</ul>
</li>
-</ul><!-- Help End: SupplierInvoices -->
+</ul>
+<h3>Inventory Costing and GL Postings</h3>
+<p>
+The Outsanding Goods Received report shows the calculation of the cost of goods received but not yet invoiced. This calculation is done using the standard cost as it is this figure that is used for the posting to the GL at the time the goods are received. Note that the "standard cost" field is actually the weighted average cost if you are using the weighted average cost method. The standard cost should be reflective of the purchase cost in FX as converted to local currency plus all landing costs. The FX cost as converted to local currency will of course exclude any landing costs and obviously it will be different each time the currency rates of exchange are updated.</p>
+<p>
+Variances are only taken to the GL based on the comparison of the standard cost (at the time the goods were received) compared to what the purchase invoice at the rate used during the purchase invoice entry. If weighted average costing is used then actually the variance is taken to the value of inventory and the unit weighted average cost is updated to reflect the new value.</p>
+<p>
+Exchange differences subsequent i.e. when the purchase invoice is paid is taken to exchange differences and not against the cost of the items that were purchased.</p>
+<!-- Help End: SupplierInvoices -->
<!-- Help Start: SupplierPayments -->
</p>
<div class="floatright"><a class="minitext" href="#top">⬆ Top</a></div>
Modified: trunk/includes/MainMenuLinksArray.php
===================================================================
--- trunk/includes/MainMenuLinksArray.php 2012-12-24 03:29:35 UTC (rev 5774)
+++ trunk/includes/MainMenuLinksArray.php 2012-12-24 05:01:04 UTC (rev 5775)
@@ -145,8 +145,7 @@
_('Outstanding GRNs Report'),
_('Supplier Balances At A Prior Month End'),
_('List Daily Transactions'),
- _('Supplier Transaction Inquiries'),
- _('All Goods Received Not Invoiced'));
+ _('Supplier Transaction Inquiries'));
$MenuItems['AP']['Reports']['URL'] = array ('/AgedSuppliers.php',
'/SuppPaymentRun.php',
@@ -154,9 +153,7 @@
'/OutstandingGRNs.php',
'/SupplierBalsAtPeriodEnd.php',
'/PDFSuppTransListing.php',
- '/SupplierTransInquiry.php',
- '/GoodsReceivedNotInvoiced.php'
- );
+ '/SupplierTransInquiry.php');
$MenuItems['AP']['Maintenance']['Caption'] = array (_('Add Supplier'),
_('Select Supplier'),
|
