Re: [CK-Ledger-users] accno ...

[C K Wu <ck...@ch...>]

Robert,

With project accounting, there is the issue of allocating common expenses
across diff projects.  I guess it is better to leave this as a 2nd stage
development, and merely add a comment at the index page indicating
expense allocation is to be done manually for the moment.

Since all modules do feed journals into the gl table, and we may not
be able to update the entire code base too swiftly, it may be a good
idea to do a little experiment.

1.    Start with a clean ck-ledger install.
2.    Generate a clean set of test data.
3.    Add in the attribute fields via console command.
4.    Go back to ck-ledger.
5.    Add in a few invoices, settle a few invoices, ... etc.
6.    Check to see how broken the system becomes

This would also generate a list of hidden errors or bugs to
be expected while you are progressing with the Rental module.

Would you like to work on the experiment ?

Cheers,
CK

C K Wu wrote:

> Adding fields to the gl table is definitely the best way to go about it.
> However, I would suggest generalising the setup a little bit, since the
> same feature can be utilized for product line P/L, regional P/L and/or
> departmental P/L reporting for commercial organizations.  The added
> fields could be termed something like, attrib1, attrib2, attrib3 (I think
> three attribute fields is about right).  The
> 'defaults' table will carry the captions for these fields.  Whenever
> these fields are displayed on screen or in report, the caption title will
> be extracted from the 'defaults' table.  This is how I handle the primary
> and secondary tax fields.  This way, the same code base can be
> implemented in public agencies to handle fund/project accounting,
> and in commercial business to handle product line/departmental accounting.
>
> I'll send you a separate email to cover other issues.
>
> Got to catch some zzzzzzz's.
>
> Cheers,
> CK
>
> robert del huerto wrote:
>
> > On Saturday 25 May 2002 10:46 am, C K Wu wrote:
> > > The account number is fine.  Lengthy account code can be a pain in
> > > the neck for the person performing the actual journal entry coding/input.
> > >
> >
> > I know it's a pain.  But, some people have to use fund and project accounting.
> > :(  For example, a public agency that is awarded a new grant to complete
> > certain new projects.  They would need to use the same account numbers they
> > already have plus attach a prefix to track the new grant fund and another
> > prefix for each of the different projects.  They would have to provide
> > financial statements for each fund (sometimes per project) and consolidated
> > financial statements which include all funds and projects.
> >
> > I'm wondering if you think it'd be alright for me to add fund and project
> > fields to the gl table (instead of the chart table.)
> >
> > Assuming we keep account numbers the same, we could add fund and project
> > accounting by doing this:
> >
> > $where = " WHERE 1=1 " ;
> >   if ($fund) {
> >       $where .= " AND fund = $fund_source";
> >       if ($project)     $where .= " AND project = $project_source";
> >   }
> >   if ($from)            $where .= " AND transdate >= $from_date ";
> >   if ($to)              $where .= " AND transdate <= $to_date " ;
> >   if ($source)          $where .= " AND lower(source) like lower('%$source%') " ;
> >   if ($description)     $where .= " AND lower(description) like
> > lower('%$description%') " ;
> > $where = urlencode($where) ;
> >
> > This would give you fund and fund/project views of the general ledger/journal
> > entries.  We could probably do something similar in all other modules (I
> > haven't taken a look at all the code yet.)
> >
> > What do u think?  Would there be a better way to implement this in the current
> > code?
> >
> > robert
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users