reconcileglaccountorganization.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
 *  
 *  @author Leon Torres [e-mail]
-->

<#-- TODO: security validation, uiLabelMap -->

<#-- custom CSS formatting -->
<style type="text/css">
<!--
div.scroll {
  height: 400px;
  width: 95%%;
  overflow: auto;
  border: 0px;
  background-color: #FFFFFF;
  padding: 0px;
}

.currencyinput {
  font-size: 10px;
  background-color: #FFFFFF;
  border: 1px solid #000000;
  padding: 2px;
  text-align: right;
}

.textinput {
  font-size: 10px;
  color: #000000;
  background-color: #FFFFFF;
  border: 1px solid #000000;
  padding: 2px;
}

.textlabel {
  font-size: 10px;
  color: #000000;
  background-color: #FFFFFF;
  border: 0px;
  padding: 2px;

}

.textlabelright {
  font-size: 10px;
  color: #000000;
  background-color: #FFFFFF;
  border: 0px;
  padding: 2px;
  text-align: right;
}

.smallSubmitDisabled { 
  color: #666666;
  border: #666666 solid 1px;
} 

.smallSubmitDisabled:hover {
  color: #666666;
  border: #666666 solid 1px;
}

.firstnotice {
  font-size: 10px;
  color: #333333;
}

td.gray1 { background:  #EEEEEE; }
td.gray2 { background:  #FCFCFC; }
td.red1  { background:  #FFDDDD; }
td.red2  { background:  #FFEEEE; }
td.blue1 { background:  #DDDDFF; }
td.blue2 { background:  #EEEEFF; }

-->
</style>

<form name="reconcileForm" method="POST">

<#-- outline box -->
<table border="0" width='100%' cellspacing='0' cellpadding='0' class='boxoutside'>
<tr><td width='100%'>

<#-- Main Header with Title -->
<table width='100%' border='0' cellspacing='0' cellpadding='0' class='boxtop'>
<tr>
<td><div class='boxhead'>Reconciliation for ${glAccount.accountCode} - ${glAccount.accountName}</div></td>
</tr>
</table>

<#-- Rest of stuff Box-->
<table width='100%' border='0' cellspacing='0' cellpadding='2' class='boxbottom'>
<tr><td>


<#if (entries?exists) && (entries.size() > 0)> <#-- BEGIN ENTRIES EXIST -->

<#-- Description and balance table -->

<table border="0" cellpadding="2" cellspacing="0" class="calendarTable">


  <#-- Balance subtable -->

  <#-- store our last reconciled balance for form script use -->
  <input type="hidden" name="lastReconciledBalance" value="${lastReconciledBalance?string("0.00")}"/>
  <input type="hidden" name="organizationPartyId" value="${organizationPartyId}"/>
  <#-- Beginning Balance -->
  <tr>
    <td align="right" width="200px"><span class="tableheadtext">Beginning Balance</span></td>
    <td>&nbsp;</td>
    <td><input class="textlabelright" type="textbox" disabled="true" size="12" name="beginningBalance" value="${lastReconciledBalance}" onChange="javascript:recalculateBalance(this.form)"/></td>
    <td>&nbsp;</td>

    <#-- display reconcile date if exists -->
    <#if lastReconciledDate?exists>
      <td><span class="tableheadtext">as of</span></td>
      <td>&nbsp;</td>
      <td>
        <table border='0' cellspacing='0' cellpadding='0'>
          <tr>
            <td nowrap>
              <input type='text' size='30' class='textlabel' disabled="true" name='lastReconciledDate' value='${lastReconciledDate}'/>
            </td>
          </tr>
        </table>
      </td>
    <#else>
      <td colspan="3"><span class="firstnotice">(First Reconciliation for this GL Account)</span></td>
    </#if>
  </tr>

  <#-- Ending Balance -->
  <tr>
    <td align="right" width="200px"><span class="tableheadtext">Ending Balance</span></td>
    <td>&nbsp;</td>
    <td><input class="textlabelright" type="textbox" disabled="true" size="12" name="endingBalance" value="${reconciledBalance}" onChange="javascript:recalculateBalance(this.form)"/></td>
    <td>&nbsp;</td>
    <td><span class="tableheadtext">as of</span></td>
    <td>&nbsp;</td>
    <td>
      <table border='0' cellspacing='0' cellpadding='0'>
        <tr>
          <td nowrap>
            <input type='hidden' name='reconciledDate' value='${reconciledDate}'/>
            <input type='textbox' size='30' class='textlabel' disabled="true" value='${reconciledDate}'/>
          </td>
        </tr>
      </table>
    </td>

  </tr>

  <#-- Calculated Balance -->
  <#--
       This is inefficient, but we need to loop through the list once to add up the partly reconciled entries for the calculated balance.
       TODO: refactor this into the main loop somehow.
  -->
  <#assign calcBalance = lastReconciledBalance/>
  <#list entries as entry>
    <#if entry.reconcileStatusId?exists && (entry.reconcileStatusId == "AES_PARTLY_RECON")>
      <#assign flag = entry.debitCreditFlag/>
      <#if ((flag == "D") && (accountIsDebit == "TRUE")) || ((flag == "C") && (accountIsDebit == "FALSE"))>
          <#assign calcBalance = calcBalance + entry.amount/>
      <#else>
          <#assign calcBalance = calcBalance - entry.amount/>
      </#if>
    </#if>
  </#list>
  <tr>
    <td align="right" width="200px"><span class="tableheadtext">Calculated Balance</span></td>
    <td>&nbsp;</td>
    <td><input class="textlabelright" type="textbox" disabled="true" size="12" name="reconciledBalance" value="${calcBalance?string("0.00")}"/></td>
    <td>&nbsp;</td>

    <#-- Refresh and Save -->
    <td colspan="3" rowspan="2" valign="center" align="center">
      <table border="0" cellpadding="0" cellspacing="0" class="calendarTable">
        <input type="button" class="smallSubmit" name="recalculate" value="Refresh" onClick="javascript:recalculateBalance(this.form)"/>
        &nbsp;
        <input type="button" class="smallSubmit" name="save" value="Check All" onClick="javascript:checkAll(this.form)"/>
        &nbsp;
        <input type="button" class="smallSubmit" name="save" value="Uncheck All" onClick="javascript:uncheckAll(this.form)"/>
      </table>
    </td>

  </tr>

  <#-- Difference -->
  <#-- TODO: reconciledBalance is passed in as a what? it complains about this not being numeric -->
  <#assign difference = reconciledBalance?number - calcBalance/>
  <tr>
    <td align="right" width="200px"><span class="tableheadtext">Difference</span></td>
    <td>&nbsp;</td>
    <td><input class="textlabelright" type="textbox" disabled="true" size="12" name="difference" value="${difference?string("0.00")}"/></td>
  </tr>

</table>


<#-- Name and description subtable -->

<table border="0" cellpadding="2" cellspacing="0" class="calendarTable">
  <tr>
    <td align="right" width="200px"><span class="tableheadtext">Name</span></td>
    <td>&nbsp;</td>
    <td><input class="textinput" type="textbox" size="30" maxlength="100" name="glReconciliationName" value=""/></td>
    <td>&nbsp;</td>
    <td><input type="button" class="smallSubmit" name="save" value="Save For Later" onClick="javascript:submitSave(this.form)"/></td>
  </tr>
  <tr>
    <td align="right" width="200px"><span class="tableheadtext">Description</span></td>
    <td>&nbsp;</td>
    <td><input class="textinput" type="textbox" size="30" maxlength="255" name="description" value=""/></td>
    <td>&nbsp;</td>
    <td><input type="button" class="smallSubmit smallSubmitDisabled" name="reconcile" value="Reconcile" disabled="true" 
               onClick="javascript:submitReconcile(this.form)"/>
    </td>
  </tr>
</table>