Appreciate all the help. Thank you
On Mon, Nov 10, 2008 at 8:36 AM, Michael Black
<[EMAIL PROTECTED]> wrote:
> James,
>
> It is not good practice to delete an account with out first transfering the
> amount in that account to another account. You will also need to make sure
> the account has a ze
Dear Group,
Please note that to avoid confusion with a previously subscribed
member, I have unsubscribed as James N Hitz ([EMAIL PROTECTED]), and I
am now using WaGathoni ([EMAIL PROTECTED]).
After all.. I realized GMail "knits" the threads together better than Yahoo.
Just thought
and general_ledger_transactions.accounting_period =
> PassedPeriodID), 0 ) +
> (CASE WHEN coa.doIhaveChildren THEN
> GetChildAccountDebits(coa.coa_id, PassedPeriodID )
> ELSE
> 0.0
> END)
> FROM coa
> WHERE coa.parent_id = P
Justin was recommending a solution to the Chart of Accounts Problem
posted by jamhitz:
MQUOTE>
One has you chart of Accounts
Create table coa (
coa_id serial not null,
parent_id int not null default 0,
doIhaveChildren boolean default false
account_name text null )
prima
