inventoryvaluedetail.ftl

Sequoia ERP是一个真正的企业级开源ERP解决方案。它提供的模块包括：电子商务应用(e-commerce), POS系统(point of sales),知识管理,存货与仓库管理

<#--
 * Copyright (C) 2006  Open Source Strategies, Inc.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 *  
-->

<#assign currencyUomId = parameters.orgCurrencyUomId>  <!-- for some reason, putting this in context in main-decorator.bsh does not work -->

<table>
  <tr><td colspan="5" class="tableheadtext">${uiLabelMap.FinancialsInventoryValueDetail} for ${parameters.organizationName?if_exists} (${organizationPartyId}) ${uiLabelMap.AsOf} ${Static["org.ofbiz.base.util.UtilDateTime"].nowTimestamp()?string("EEEE, MMMM dd, yyyy")}</td></tr>
  <tr><td colspan="5">&nbsp;</td></tr>
  <tr><td class="tableheadtext">Inventory Item</td><td class="tableheadtext">Product</td><td class="tableheadtext" align="right">QOH Quantity</td><td class="tableheadtext" align="right">Unit Cost</td><td class="tableheadtext" align="right">Value</td></tr>

<#assign total = 0/>
<#list inventoryValueDetail.keySet() as inventoryItem>
  <tr>
    <td class="tabletext">${inventoryItem.inventoryItemId}</td>
    <td class="tabletext">${inventoryItem.productId}</td>
    <td class="tabletext" align="right">${inventoryItem.quantityOnHandTotal}</td>
    <td class="tabletext" align="right"><@ofbizCurrency amount=inventoryItem.unitCost isoCode=currencyUomId/></td>
    <td class="tabletext" align="right"><@ofbizCurrency amount=inventoryValueDetail(inventoryItem) isoCode=currencyUomId/></td>
    <#assign total = total + inventoryValueDetail(inventoryItem)/>
  </tr>
</#list>
<tr><td colspan="5"><hr/></td></tr>
<tr>
  <td colspan="3" class="tableheadtext">Inventory Items Sub-Total</td><td colspan="2" class="tableheadtext" align="right"><@ofbizCurrency amount=total isoCode=currencyUomId/></td>
</tr>

<#-- also display the inventory average cost valuation account balances -->

  <tr><td colspan="5">&nbsp;</td></tr>
  <tr><td class="tableheadtext" colspan="5">Adjustments</td></tr>

<#list adjustmentAccounts as account>
  <tr>
    <td class="tabletext" colspan="4">${account.accountCode}: ${account.accountName}</td>
    <td class="tabletext" align="right"><@ofbizCurrency amount=account.postedBalance isoCode=currencyUomId/></td>
    <#if account.postedBalance?exists>
       <#assign total = total + account.postedBalance/>
    </#if>
  </tr>
</#list>

<tr><td colspan="5"><hr/></td></tr>
<tr>
  <td colspan="3" class="tableheadtext">Total Inventory Value</td><td colspan="2" class="tableheadtext" align="right"><@ofbizCurrency amount=total isoCode=currencyUomId/></td>
</tr>
<tr><td colspan="5">&nbsp;</td></tr>
</table>