Finance Progress: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
 
(235 intermediate revisions by 3 users not shown)
Line 7: Line 7:


== Finance Setup ==
== Finance Setup ==
* Currencies (50%)
* Currencies (100%)
** Can't create new
** Can't delete
** Display Format field is displayed in edit frame as "Number of Decimals". Either that needs to be renamed to display format or there needs to be some logic that converts between number of decimals and display format (eg. ->>>,>>>,>>>,>>9.99 displays number of decimals as 2)


* Corporate Exchange Rates (20%)
* Corporate Exchange Rates (90%)
** Import not working yet (bug#765)
** Still a bit more testing required (import + effect of changing used rates)
** No Edit or Delete functionality
** bug when clicking New without saving first (bug#766)
** Inverse rate not automatically created
** Get horrible constraint error if create a new exchange rate for currency and date that already exists (needs proper validation)
** Other bug with grid (bug#767)


* Daily Exchange Rates (20%)
* Daily Exchange Rates (90%)
** Import not working yet (bug#765)
** Still a bit more testing required (import + effect of changing used rates)
** No edit or delete functionality
** bug when clicking New without saving first (bug#766)
** Inverse rate not automatically created
** Get horrible constraint error if create a new exchange rate for currency and date that already exists (needs proper validation)
** Other bug with grid (bug#767)
** Has both a Close and a Cancel button which is confusing


* Method of Giving (50%)
* Method of Giving (95%)
** Needs Edit & Delete buttons
** Although they are shown in Petra as well, it might be worth removing "Used by recurring gifts", "Involves a Trust" and "Involves a tax rebate" unless they are actually going to be used in OpenPetra (they are not used in Petra). (Bug 2526)
** Nasty constraint error if I enter a code that is already used
** Although it is shown in Petra as well, it might be worth removing "Used by recurring gifts" unless it is actually going to be used in OpenPetra (it is not used in Petra).


* Method of Payment (50%)
* Method of Payment (95%)
** Needs Edit & Delete buttons
** Although it does also exist in Petra, it might be worth removing or renaming Special Method of Payment. In Petra it is basically a flag that prevents deletion of the method of payment and is used for Methods of payment that have special functionality associated with them (so is not really relevant on the maintenance screen). If it was to remain then renaming to Not Deletable? might be more helpful. (Bug 2531)
** Nasty constraint error if I enter a code that is already used
** Although it does also exist in Petra, it might be worth removing or renaming Special Method of Payment. In Petra it is basically a flag that prevents deletion of the method of payment and is used for Methods of payment that have special functionality associated with them (so is not really relevant on the maintenance screen). If it was to remain then renaming to Not Deletable? might be more helpful.


* Analysis Types (90%)
* Analysis Types (90%)
** Needs proper error handling for duplicate types (instead of nasty constraint error)
** Grid bug as for exchange rate screens (bug#767)
** Setup Shepherd missing (may be able to live without)
** Setup Shepherd missing (may be able to live without)
** Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it)
** Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it)


* Form Design (0%)
* Form Design (0%)
** Feature bug 1113


* Define HOSA & ICH Email Destinations (70%)
* Define HOSA & ICH Email Destinations (100%)
** Display problem (bug#769)
** No Delete button


== General Ledger Setup ==
== General Ledger Setup ==
* Create Ledger (60%)
* Create Ledger (80%)
** Create button not properly displayed (bug#770)
** Need to add some additional accounts to the default COA (eg. ICH accounts). Will need to ask whether ICH should be asset or liability (bug#2532)
** Need to add some additional accounts to the default COA (eg. ICH accounts). Will need to ask whether ICH should be asset or liability
** Bugs (2156-2159)
** May need to be linked more closely to ledger settings screen


* Accounts (30%)
* Delete Ledger (100%)
** Need accounts displayed in full list, not just hierarchical view
 
* Accounts (60%)
** Need accounts displayed in full list, not just hierarchical view (bug 2533)
** Need print functionality
** Need print functionality
** Need to be able to move accounts within hierarchy
** May need some additional restrictions (eg. summary and posting account types should match)
** Need Account Rename
** Should disallow foreign currency accounts for income and expense accounts (bug 2534)
** Should disallow foreign currency accounts for income and expense accounts
** Need Budget Control flag (should only be available if a_ledger.a_budget_control_flag_l = true) (bug 2535)
** Need warning on Account Delete (eg. Are you sure you want to do this?)
** Need means to specify that an account is a bank account
** Account deletion bug (bug#772)
** Check-box display bug (bug#773)
** Need autopopulation of additional name field after entering the first one (Description Long English)
** Should not be possible to create an account beneath a posting account
** Adding analysis attribute types doesn't work (bug#775)


* Cost Centres (20%)
* Cost Centres (70%)
** Need ability to add/remove foreign cost centres (Ledger->Setup->Tables->Foreign Ledgers in old Petra)
** May need ability to add/remove foreign cost centres (Ledger->Setup->Tables->Foreign Ledgers in old Petra)
** Should not allow cost centres to be created beneath a posting cost centre (eg. I was able to create a cost centre under 9900 in ledger 99)
** Need to be able to set Equity Settings on the Cost Centre (bug 2536)
** Need delete functionality
** Need to be able to set Project Constraints (bug 2537)
** Need Cost Centre Type field (Local/Foreign)
** Need ability to create Non-ICH funds and set clearing account (new functionality as of Petra 2.2.19) (bug 2538)
** Need to be able to set Equity Settings on the Cost Centre
** Need to lock down System Cost Centres (eg. 4300S) (bug 2539)
** Need to be able to set Project Constraints
** Need ability to create Non-ICH funds and set clearing account (new functionality as of Petra 2.2.19)
** Need to lock down System Cost Centres (eg. 4300S)
** Need to be able to move Cost Centres within hierarchy
** Need Cost Centre rename
** Need Cost Centre link to Partner
** Need Print functionality
** Need Print functionality


* Enable/Disable Sub-systems (0%)
* Enable/Disable Sub-systems (70%)
** Screen works but can still get into deactivated modules (bug 2361)


* Define Calendar (only needed as part of ledger creation)
* Define Calendar (100%)
** Need to be able to specify start and end dates of each period (currently can only specify number of periods)
** Decision made to allow only 12 or 13 periods calendars
*** An alternative that might be acceptable would be to only allow 12 or 13 periods and have the 13th period automatically set to the last day of the financial year.


* General Parameters (50%)
* General Parameters (90%)
** "Allow use of suspense accounts?" is there but makes no difference (bug #2376)
** The following parameters cannot yet be entered (even on ledger creation). It should be possible to set these on an existing ledger (not just on creation)
** The following parameters cannot yet be entered (even on ledger creation). It should be possible to set these on an existing ledger (not just on creation)
*** allow use of suspense accounts
*** Specify standard report text on selected reports (need to check if this is used) (see feature bug 1163)
*** enforce budget control
*** data retention
*** enable branch processing (need to check whether this is still needed)
*** Specify standard report text on selected reports (need to check if this is used)
** Needs to be possible to view calendar settings (read only is fine)


== General Ledger ==
== General Ledger ==
* GL Batch Maintenance
* GL Batch Maintenance
** Batch Search (0%)
** Batch Search (90%)
*** bugs 2417, 2588
** Transaction Search (0%)
** Transaction Search (0%)
** Batch/Journal/Transaction grid (60%)
*** There is a transaction filter but that only filters within a batch. A full transaction search facility across all batches is still required. (bug 2542)
*** Moving between rows is much too slow
** Batch/Journal/Transaction grid (90%)
*** Bugs (#803, #804, #807)
*** Year filter needs to cope with non-calendar years (bug 2417)
** Create/Edit/Delete/Print Batch Header (60%)
** Create/Edit/Delete/Print Batch Header (80%)
*** No print option
*** No print option
*** Should not allow blank description
** Create/Edit/Delete/Print Journal Header (40%)
*** Can't enter hash total (also, either hash total field or control total browse column should be renamed as they are the same)
*** Bugs (#800-#802, #805-#806, #841)
** Create/Edit/Delete/Print Journal Header (20%)
*** No print option
*** No print option
*** Should not allow blank description
*** Journal description should default to batch description (bug 2543)
*** Journal description should default to batch description
*** Need Allocation journals (bug 2544)
*** Bugs relating to setting of exchange rate (#811-#814)
*** Need Re-allocation journals (bug 2544)
*** Need Allocation journals
*** Need Revaluation journals?? (may not be necessary if main revaluation screen is flexible enough) (bug 2545)
*** Need Re-allocation journals
*** bug #2419
*** Need Revaluation journals
** Create/Edit/Delete/Print Transactions (70%)
** Create/Edit/Delete/Print Transactions (30%)
*** No print option
*** No print option
*** Should not allow blank narrative
*** Should not allow blank narrative (bug #2418)
*** Moving between fields is too slow (bug#822)
*** Key Ministries not quite working (bug #2420)
*** Bug#821
*** Bug in analysis attributes (#2421)
*** Key Ministry list needs to populate with appropriate list if a foreign cost centre is selected along with account 3300. List should be disabled the rest of the time
*** Needs to check on Save that budget not exceeded (if account has budget control flag set). (this may be there already but not possible to test because no budget control flag on Account setup
*** No way to enter analysis attributes (there is a tab there but no way to add to it)
** Import Transactions (0%)
** Import Transactions (still to test)
*** Can't import transactions into an existing journal (can only import a whole batch currently) (feature bug 1137)
*** Can't import transactions into an existing journal (can only import a whole batch currently)
** Reverse batch (50%)
*** Date format should default the first time based on the culture setting (if comes up with mm/dd/yyyy even though the transaction screen is expecting dd/mm/yyyy) (bug#840)
*** Substantial bugs (2422-2426)
*** Friendlier error messages when incorrect data in file might be nice
** Reverse journal (0%) (bug #2547)
*** There is no validation of batch period on import (I can successfully import a batch for a closed period) (bug#839)
** Post Batch (70%)
** Reverse batch (0%)
*** Posting register (see feature bug 1139)
** Reverse journal (0%)
*** Bug 2427
** Post Batch (still testing)
** Posting Register Reprint (0%) (feature bug 1139)
*** Test Batch and Post Batch need to check debit/credit total against hash total
* Recurring Batch Maintenance
*** Bugs (#808-#810)
** Batch Search (??%)
** Posting Register Reprint (0%)
*** need to test when working
** Journal Search (0%)
*** Probably not necessary
** Transaction Search (0%)
*** There is a transaction filter but that only filters within a batch. A full transaction search facility across all batches is still required.
** Batch/Journal/Transaction grid (100%)
** Create/Edit/Delete/Print Batch Header (??%)
*** bug 2638
*** can't create batch due to bug 2453 so can't test further
*** No print option
** Create/Edit/Delete/Print Journal Header (80%)
*** No print option
*** Remove Transaction Type field? (bug #2452)
*** Need to test filtering when working
** Create/Edit/Delete/Print Transactions (70%)
*** No print option
*** bugs with analysis attributes (2458,2459)
*** bugs with use of inactive account/cc (2461, 2462)
** Submit Batch (70%)
*** bugs 2454, 2455
*** inactive cc/acc not allowed. In Petra a warning was given but the user could choose to continue. (see bug 2462)
* Import/Export
** Import batch (70%)
*** Daily exchange rate record should be created if a foreign currency journal is imported
*** Doesn't provide option to accept, for example, "100" as "0100" (Petra does this, presumably to help with problems caused by csv generation in Excel)
** Export batch (100%)
* Display Balances
** Foreign Currency Accounts (0%)  (see feature bug 1615)
** Suspense Accounts (0%)          (see feature bug 1616)
** All accounts (0%)              (see feature bug 1617)
* Reports  (ignore for now pending new reporting tool)
** Balance Sheet (50%)
*** Needs option to select Cost Centre(s), including Cost Centre Breakdown option and option to toggle between showing inactive cost centres or not
*** Needs Auto-Email option
*** bugs
** I&E (50%)
*** Needs Auto-Email option
*** Cost Centre Breakdown not working
*** Can't test "All Cost Centre" options because of dire performance
*** lots of bugs
** Account Detail (70%)
*** Needs Auto-Email option
*** Needs "Display local CC's First" option
*** Various Bugs
*** Performance needs to improve
** Trial balance (70%)
*** Needs "Display local CC's First" option
*** Needs major performance improvements
*** Need to clarify purpose of Sort by Department option
*** bugs
** AFO Report (0%)
** Analysis Attributes
*** Will test later once firm decision on Alwyn's multi-dimension reporting
** Internal Transfer (70%)
*** Although this doesn't exist yet it is effectively just a very specific account detail report so once Account Detail report is finished this is trivial (and may not even be needed as a separate report?)
** Expense Acct Detail (70%)
*** Ditto Internal Transfer
** Extract Suspense (70%)
*** Ditto above
** HOSA Reprint
** Executive Summary (0%)
** Surplus/Deficit
** Posted Batch (0%)
*** I couldn't find this anywhere
 
* Month-end (70%)
** UI needs improvement (bug 2555)
** Needs suspense account printing(?)
** Needs automatic report printing(?)
** bug 2404
 
* Year-end (20%??)
** Can't test properly because runs out of memory (bug#2409)
** UI needs work (bugs 2403, 2410)
** Remember to test data retention
 
* Foreign Currency Revaluation (90%)
** Doesn't allow selection of Cost Centre (posts automatically to standard CC - maybe that is ok but will need to check) (bug 2558)
** Change reference to match Petra (bug #2487)
** Needs hourglass (bug #2486)
 
* International Currency Revaluation (if necessary - depending on whether intl balances are stored)
 
* Resummarisation of balances (if necessary - depending on whether summarisations are stored)
 
== Budgeting ==
* Budget import (70%)
** No validation of account/cost centre (bug 2568)
* Budget maintenance (70%)
** Needs printing
** Need to show the actual budget period values in the grid (bug 2563)
** bugs 1446, 2561, 2562
** difficult to test fully until data conversion issue fixed (bug 2567)
* Autogenerate Budgets for year (20%)
** Can't get it to actually generate budgets (1473)
** bugs (1470, 1472)
** difficult to test fully until data conversion issue fixed (bug 2567)
* Submit (consolidate) budget (90%)
** Needs more extensive testing with a "real" database but looking good
** need to test summarisation up hierarchy
* Budget Export (90%) - not provided in Petra
** Bugs 2559, 2560
 
== Gift Processing ==
* Setup
** Admin Grants (90%)
*** Needs print
** Motivation Group (90%)
*** bug 2578
** Motivation Detail (50%)
*** Needs Print
*** No Motivation Short Code (for display on receipts) (bug 2581)
*** No local description (bug 2583)
*** No link to Key Ministries (bug 2584)
*** No "Populate Gift Description" (bug 2585)
*** No "Tax deductible" check-box (bug 2585)
*** No "Export to Caleb" check-box (bug 2585)
*** Currently cost centre list only includes local CC's. This might be ok except that Petra allows Foreign CC's so if installing OpenPetra for an existing site there might be a problem (eg. South Africa db has a motivation with cost centre 4100) (bug 2641)
* Gift Batch Maintenance
** Batch Search (90%)
*** bugs 2417, 2588, 2686
** Transaction Search (0%)
*** Filter is there within a batch but need full gift search facility that works across batches (feature bug 2640)
** Batch Header (View/Create/Edit/Delete/Print) (90%)
*** Needs print functionality
** Gifts & Details(View/Create/Edit/Delete/Print) (50%)
*** bugs (2594, 2595, 2669, 2672, 2673)
*** Need to automatically pick up previous gift from selected donor (feature bug 2596)
*** Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY) (feature bug 2597)
*** Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup) (feature bug 2598)
*** Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup) (feature bug 2599)
*** Needs to default Tax Deductible flag based on Motivation (will first need to be added to motivation detail setup) (feature bug 2600)
*** Needs print functionality
*** Grid may still need some re-design to make distinction clearer between normal and split gifts. Really needs some user input.
*** Recipient class currently limited to FAMILY or UNIT. May need to include PERSON.
*** Recipient field doesn't seem to be getting picked up properly (bugs 1001, 2642)
*** Need to add label for donor information (in Petra displays bank account, receipting preference, anonymity) (feature bug 2601)
*** Correct setting of Cost Centre needs to be worked on (once CC link to Partner and Worker Field  [see [[Specification: Worker Field|Specification for Worker Field]] ] properly implemented) (bug 2646)
*** Need "Find Donor by Bank Details" option (bug 867)
*** Need check for new donor with offer to update subscriptions (in Petra there was a menu option to switch this warning on or off) (feature bug 2658)
*** No options for going directly to Donor Subscriptions or Donor Finance Details (not certain if this is needed but could imagine it might be useful) (feature bug 2659)
*** No check for EX-OMER (feature bug 2665)
*** Need to default confidential flag based on anonymity of donor (feature bug 2670)
** Import/Export Gifts (0%)
*** Can only import whole batches at present (feature bug 1123)
** Field Change Adjustment(0%)
*** Not there yet (feature bug 1124)
** Gift reversal (80%)
*** Bug 2647, 2663
** Gift adjustment (80%)
*** Bugs 2661, 2662
*** see bugs for gift reversal
** Gift detail reversal (80%)
*** See Gift Reversal bugs
** Gift Batch reversal (80%)
*** See Gift Reversal bugs
** Post Gift Batch (50%)
*** Fee processing bug (bug 2643)
*** Posting of reversals and adjustments not working (bug 2664)
*** Admin Grant flag (a_charge_flag_l) ignored (bug 2645)
*** No warning currently for gifts to EX-WORKERs. Some equivalent to that is probably needed (in Petra it is based on EX-OMER special type) (feature bug 2665)
*** Needs to check that any Key Ministries being given to are still active (feature bug 2667)
*** Need warning if confidential flag not ticked for any donors that have the anonymous donor flag set (feature bug 2671)
*** Need to get up-to-date recipient field, cost centre and account based on recipient/motivation (leaving cost centre untouched if a reversal) (feature bug 2660)
*** Posting a batch with zero batch total results in gl batch with 0 transactions (bug 2666)
* Recurring Gift Batch Maintenance
** Batch Search (90%)
*** bugs 2685, 2687
** Transaction Search (0%)
*** Need to be able to search for gifts across all recurring batches (feature bug 2689)
** Batch Header (View/Create/Edit/Delete/Print) (90%)
*** Need printing
** Gifts & Details (View/Create/Edit/Delete/Print) (60%)
*** bugs 2691, 2693
*** Need printing
*** Need to add label for donor information (in Petra displays bank account, receipting preference, anonymity). Label is there but not functional (feature bug 2601)
*** Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY) (feature bug 2597)
*** Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup) (feature bug 2598)
*** Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup) (feature bug 2599)
*** Needs to default Tax Deductible flag based on Motivation (will first need to be added to motivation detail setup) (feature bug 2600)
*** Correct setting of Cost Centre needs to be worked on (once CC link to Partner and Worker Field  [see [[Specification: Worker Field|Specification for Worker Field]] ] properly implemented) (bug 2646)
*** Recipient field doesn't seem to be getting picked up properly (bugs 1001, 2642)
*** Grid may still need some re-design to make distinction clearer between normal and split gifts. Really needs some user input.
*** Recipient class currently limited to FAMILY or UNIT. May need to include PERSON.
*** No options for going directly to Donor Subscriptions or Donor Finance Details (not certain if this is needed but could imagine it might be useful) (feature bug 2659)
*** No check for EX-OMER (feature bug 2665)
*** Need to default confidential flag based on anonymity of donor (feature bug 2670)
** Import Recurring Gifts (0%)
*** Not there yet (feature bug 1130)
** Submit Recurring Gift Batch (70%)
*** Bugs 2695, 2698, 2699
*** Donation Period functionality will need further testing once bugs fixed
*** Needs checks for EX-WORKERs and expired Key Ministries (feature bug 2665)
*** Needs to check that any Key Ministries being given to are still active (feature bug 2667)
*** Need to get up-to-date recipient field, cost centre and account based on recipient/motivation (feature bug 2660)
* Import/Export
** Import Gift Batch (70%)
*** Bugs 1025, 1075, 1077, 1078, 1080, 2707
*** Currently processing stops at the first validation error. It may be necessary to change it to process the whole file to present a list of errors. This is a change we made to Petra for iConnect so may not be an immediate priority but should be considered.
** Export Gift Batch (80%)
*** bugs 1345, 2706
* Receipting
** Periodic Receipts (10%)
*** Can't get it to do anything so hard to test further (bug 2725)
*** Appears to only allows annual, not other frequencies (or perhaps it does in which case it should be renamed to Periodic Receipts) (feature bug 2731)
*** No option to print Deceased Donors first (feature bug 2732)
*** No option to restrict by Donor or by Extract (2733)
** Receipt per Gift (on Gift Post) (50%)
*** need to be able to select receipt form to use (once form design is implemented in some way) (feature bug 2735)
*** needs further testing once form design implemented
*** needs connection to print dialog (when there is one)
** Receipt Control
*** Receipt per gift (70%)
**** bugs 2736, 2737
**** needs connection to print dialog (when there is one)
**** need to be able to select receipt form to use (once form design is implemented in some way) (feature bug 2735)
**** needs further testing once form design implemented
*** Change receipt numbering (100%)
* Gift History
** Donor & Receipient history (80%)
*** Add links to donor and recipient statements (not essential but Petra does have them on File menu) (feature bug 2758)
*** No ability to view selected gift (feature bug 2757)
* Reports
** Recipient Gift Statement
** Recipient Gift Totals (0%) - May not be needed?
** Recipient Gift Email (0%)
** Donor Gift Statement
** Donor Gifts to Selected Fields
** Donor Gift Summary to Selected Fields
** Donor Gift Totals
** Donor Gift Tax Claim Report (Selected Fields)
** One year monthly gift report
** Total giving for selected Recipients
** Field Gift Totals
** Field leader gift summary
** Field leader gift summary (2)
** Total gifts through field
* Swiss Tax-Deductibile gift functionality (0%)
** Feature bug 1741 + children
* iConnect Interface Changes (0%)
** Feature bugs 2676, 2677, 2679, 2682, 2683
 
== Accounts Payable ==
* Create and maintain Supplier (100%)
** May need to remove Early Payment Discount if that is not going to be implemented (see below)
* Create and maintain invoice / credit note (90%)
** Missing Early Payment Discount (feature bug 2811)
** "Use Tax Account/CC" missing. Button there but no functionality. Don't know whether this is actually used in Petra (feature bug 2812).
* List of suppliers and outstanding invoices (80%)
** Find facility needed for invoices. May also be worth introducing standard OpenPetra filter/find (feature bug 2815)
* Post an invoice (90%)
** Insists on status Approved before posting, even if AP default is to allow posting of unapproved invoices (bug 2817)
* Approvals (0%)
** Feature bug 2818
* Early Payment Discount (0%)
** Check if needed as implementation in Petra seems to be sub-optimal! (feature bug 2811)
* Invoice Payment (incl. partial payments) (40%)
** "Print Cheque" disabled (feature bug 2820)
** No Early Payment Discount (feature bug 2811)
** Missing Tools Menu (sequential cheque numbering, global reference, global bank account & single invoice per payment) (feature bug 2821)
** No way to remove an invoice from the payment (ie. some sort of remove invoice button) (bug 2822)
** Payment by Transfer is missing
** Can't test multi-supplier payments due to bug in outstanding invoices tab (bug #1991)
** Various bugs
* Analysis Attributes (100%)
* Maintain defaults (0%)
** feature bug 2814
* Reverse Payments
** Can't test due to unhandled exception
* Reverse invoices (80%)
** Can't reverse open invoices (ie. cancel them). Needs to be some way of cancelling an unposted invoice whether using reverse option as in Petra or having a separate cancel button
** A few bugs
* Import/Export (0%)
** Not present currently. Needs checking to see if actually needed (feature bug 2816)
* Cheque/Remittance printing (20%)
** No cheque printing
** Remittance does get printed but no control over output as far as I can see
* Reports
** Account Detail (100%)
** Aged supplier list (90%)
*** Bug 2078
** Current Accounts Payable (80%)
*** Missing "print detailed codes" option. No idea whether that is actually needed.
*** bug 2044
** Invoice list (0%)
** Supplier Statements (0%)
** Payment Report (to be produced on payment and available for reprint) (85%)
*** bug 2097
 
== ICH ==
* Stewardship
** Stewardship calculation (60%)
*** Needs to cope with non-ICH funds (eg. India) (feature bug 2930)
*** bug 2131
 
** Stewardship Reports (1%)
*** HOSA (initial implementation exists)
*** Fees report
*** Stewardship Report
**** Needs to cope with non-ICH funds (feature bug 2931)
*** Auto-Email HOSA & RGS to each field
*** Email Export to head-office (for branch processing)
* ICH Ledger (0%)
** Import Stewardship file
** Automated Bulk Stewardship import
** Reports
*** Fund Balance
*** ICH Statement
*** Stewardship Status Report

Latest revision as of 16:35, 21 March 2014

General Information

This is list of finance functionality along with an indication of progress and a list of things that still need to be done to complete each section. This is a work in progress, I am just adding sections as I go through testing...

Validation needs to be added to all screens so I have not specifically stated that for each one, though I have taken that into account when estimating the percentage done.

Finance Setup

  • Currencies (100%)
  • Corporate Exchange Rates (90%)
    • Still a bit more testing required (import + effect of changing used rates)
  • Daily Exchange Rates (90%)
    • Still a bit more testing required (import + effect of changing used rates)
  • Method of Giving (95%)
    • Although they are shown in Petra as well, it might be worth removing "Used by recurring gifts", "Involves a Trust" and "Involves a tax rebate" unless they are actually going to be used in OpenPetra (they are not used in Petra). (Bug 2526)
  • Method of Payment (95%)
    • Although it does also exist in Petra, it might be worth removing or renaming Special Method of Payment. In Petra it is basically a flag that prevents deletion of the method of payment and is used for Methods of payment that have special functionality associated with them (so is not really relevant on the maintenance screen). If it was to remain then renaming to Not Deletable? might be more helpful. (Bug 2531)
  • Analysis Types (90%)
    • Setup Shepherd missing (may be able to live without)
    • Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it)
  • Form Design (0%)
    • Feature bug 1113
  • Define HOSA & ICH Email Destinations (100%)

General Ledger Setup

  • Create Ledger (80%)
    • Need to add some additional accounts to the default COA (eg. ICH accounts). Will need to ask whether ICH should be asset or liability (bug#2532)
    • Bugs (2156-2159)
    • May need to be linked more closely to ledger settings screen
  • Delete Ledger (100%)
  • Accounts (60%)
    • Need accounts displayed in full list, not just hierarchical view (bug 2533)
    • Need print functionality
    • May need some additional restrictions (eg. summary and posting account types should match)
    • Should disallow foreign currency accounts for income and expense accounts (bug 2534)
    • Need Budget Control flag (should only be available if a_ledger.a_budget_control_flag_l = true) (bug 2535)
  • Cost Centres (70%)
    • May need ability to add/remove foreign cost centres (Ledger->Setup->Tables->Foreign Ledgers in old Petra)
    • Need to be able to set Equity Settings on the Cost Centre (bug 2536)
    • Need to be able to set Project Constraints (bug 2537)
    • Need ability to create Non-ICH funds and set clearing account (new functionality as of Petra 2.2.19) (bug 2538)
    • Need to lock down System Cost Centres (eg. 4300S) (bug 2539)
    • Need Print functionality
  • Enable/Disable Sub-systems (70%)
    • Screen works but can still get into deactivated modules (bug 2361)
  • Define Calendar (100%)
    • Decision made to allow only 12 or 13 periods calendars
  • General Parameters (90%)
    • "Allow use of suspense accounts?" is there but makes no difference (bug #2376)
    • The following parameters cannot yet be entered (even on ledger creation). It should be possible to set these on an existing ledger (not just on creation)
      • Specify standard report text on selected reports (need to check if this is used) (see feature bug 1163)

General Ledger

  • GL Batch Maintenance
    • Batch Search (90%)
      • bugs 2417, 2588
    • Transaction Search (0%)
      • There is a transaction filter but that only filters within a batch. A full transaction search facility across all batches is still required. (bug 2542)
    • Batch/Journal/Transaction grid (90%)
      • Year filter needs to cope with non-calendar years (bug 2417)
    • Create/Edit/Delete/Print Batch Header (80%)
      • No print option
    • Create/Edit/Delete/Print Journal Header (40%)
      • No print option
      • Journal description should default to batch description (bug 2543)
      • Need Allocation journals (bug 2544)
      • Need Re-allocation journals (bug 2544)
      • Need Revaluation journals?? (may not be necessary if main revaluation screen is flexible enough) (bug 2545)
      • bug #2419
    • Create/Edit/Delete/Print Transactions (70%)
      • No print option
      • Should not allow blank narrative (bug #2418)
      • Key Ministries not quite working (bug #2420)
      • Bug in analysis attributes (#2421)
      • Needs to check on Save that budget not exceeded (if account has budget control flag set). (this may be there already but not possible to test because no budget control flag on Account setup
    • Import Transactions (0%)
      • Can't import transactions into an existing journal (can only import a whole batch currently) (feature bug 1137)
    • Reverse batch (50%)
      • Substantial bugs (2422-2426)
    • Reverse journal (0%) (bug #2547)
    • Post Batch (70%)
      • Posting register (see feature bug 1139)
      • Bug 2427
    • Posting Register Reprint (0%) (feature bug 1139)
  • Recurring Batch Maintenance
    • Batch Search (??%)
      • need to test when working
    • Journal Search (0%)
      • Probably not necessary
    • Transaction Search (0%)
      • There is a transaction filter but that only filters within a batch. A full transaction search facility across all batches is still required.
    • Batch/Journal/Transaction grid (100%)
    • Create/Edit/Delete/Print Batch Header (??%)
      • bug 2638
      • can't create batch due to bug 2453 so can't test further
      • No print option
    • Create/Edit/Delete/Print Journal Header (80%)
      • No print option
      • Remove Transaction Type field? (bug #2452)
      • Need to test filtering when working
    • Create/Edit/Delete/Print Transactions (70%)
      • No print option
      • bugs with analysis attributes (2458,2459)
      • bugs with use of inactive account/cc (2461, 2462)
    • Submit Batch (70%)
      • bugs 2454, 2455
      • inactive cc/acc not allowed. In Petra a warning was given but the user could choose to continue. (see bug 2462)
  • Import/Export
    • Import batch (70%)
      • Daily exchange rate record should be created if a foreign currency journal is imported
      • Doesn't provide option to accept, for example, "100" as "0100" (Petra does this, presumably to help with problems caused by csv generation in Excel)
    • Export batch (100%)
  • Display Balances
    • Foreign Currency Accounts (0%) (see feature bug 1615)
    • Suspense Accounts (0%) (see feature bug 1616)
    • All accounts (0%) (see feature bug 1617)
  • Reports (ignore for now pending new reporting tool)
    • Balance Sheet (50%)
      • Needs option to select Cost Centre(s), including Cost Centre Breakdown option and option to toggle between showing inactive cost centres or not
      • Needs Auto-Email option
      • bugs
    • I&E (50%)
      • Needs Auto-Email option
      • Cost Centre Breakdown not working
      • Can't test "All Cost Centre" options because of dire performance
      • lots of bugs
    • Account Detail (70%)
      • Needs Auto-Email option
      • Needs "Display local CC's First" option
      • Various Bugs
      • Performance needs to improve
    • Trial balance (70%)
      • Needs "Display local CC's First" option
      • Needs major performance improvements
      • Need to clarify purpose of Sort by Department option
      • bugs
    • AFO Report (0%)
    • Analysis Attributes
      • Will test later once firm decision on Alwyn's multi-dimension reporting
    • Internal Transfer (70%)
      • Although this doesn't exist yet it is effectively just a very specific account detail report so once Account Detail report is finished this is trivial (and may not even be needed as a separate report?)
    • Expense Acct Detail (70%)
      • Ditto Internal Transfer
    • Extract Suspense (70%)
      • Ditto above
    • HOSA Reprint
    • Executive Summary (0%)
    • Surplus/Deficit
    • Posted Batch (0%)
      • I couldn't find this anywhere
  • Month-end (70%)
    • UI needs improvement (bug 2555)
    • Needs suspense account printing(?)
    • Needs automatic report printing(?)
    • bug 2404
  • Year-end (20%??)
    • Can't test properly because runs out of memory (bug#2409)
    • UI needs work (bugs 2403, 2410)
    • Remember to test data retention
  • Foreign Currency Revaluation (90%)
    • Doesn't allow selection of Cost Centre (posts automatically to standard CC - maybe that is ok but will need to check) (bug 2558)
    • Change reference to match Petra (bug #2487)
    • Needs hourglass (bug #2486)
  • International Currency Revaluation (if necessary - depending on whether intl balances are stored)
  • Resummarisation of balances (if necessary - depending on whether summarisations are stored)

Budgeting

  • Budget import (70%)
    • No validation of account/cost centre (bug 2568)
  • Budget maintenance (70%)
    • Needs printing
    • Need to show the actual budget period values in the grid (bug 2563)
    • bugs 1446, 2561, 2562
    • difficult to test fully until data conversion issue fixed (bug 2567)
  • Autogenerate Budgets for year (20%)
    • Can't get it to actually generate budgets (1473)
    • bugs (1470, 1472)
    • difficult to test fully until data conversion issue fixed (bug 2567)
  • Submit (consolidate) budget (90%)
    • Needs more extensive testing with a "real" database but looking good
    • need to test summarisation up hierarchy
  • Budget Export (90%) - not provided in Petra
    • Bugs 2559, 2560

Gift Processing

  • Setup
    • Admin Grants (90%)
      • Needs print
    • Motivation Group (90%)
      • bug 2578
    • Motivation Detail (50%)
      • Needs Print
      • No Motivation Short Code (for display on receipts) (bug 2581)
      • No local description (bug 2583)
      • No link to Key Ministries (bug 2584)
      • No "Populate Gift Description" (bug 2585)
      • No "Tax deductible" check-box (bug 2585)
      • No "Export to Caleb" check-box (bug 2585)
      • Currently cost centre list only includes local CC's. This might be ok except that Petra allows Foreign CC's so if installing OpenPetra for an existing site there might be a problem (eg. South Africa db has a motivation with cost centre 4100) (bug 2641)
  • Gift Batch Maintenance
    • Batch Search (90%)
      • bugs 2417, 2588, 2686
    • Transaction Search (0%)
      • Filter is there within a batch but need full gift search facility that works across batches (feature bug 2640)
    • Batch Header (View/Create/Edit/Delete/Print) (90%)
      • Needs print functionality
    • Gifts & Details(View/Create/Edit/Delete/Print) (50%)
      • bugs (2594, 2595, 2669, 2672, 2673)
      • Need to automatically pick up previous gift from selected donor (feature bug 2596)
      • Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY) (feature bug 2597)
      • Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup) (feature bug 2598)
      • Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup) (feature bug 2599)
      • Needs to default Tax Deductible flag based on Motivation (will first need to be added to motivation detail setup) (feature bug 2600)
      • Needs print functionality
      • Grid may still need some re-design to make distinction clearer between normal and split gifts. Really needs some user input.
      • Recipient class currently limited to FAMILY or UNIT. May need to include PERSON.
      • Recipient field doesn't seem to be getting picked up properly (bugs 1001, 2642)
      • Need to add label for donor information (in Petra displays bank account, receipting preference, anonymity) (feature bug 2601)
      • Correct setting of Cost Centre needs to be worked on (once CC link to Partner and Worker Field [see Specification for Worker Field ] properly implemented) (bug 2646)
      • Need "Find Donor by Bank Details" option (bug 867)
      • Need check for new donor with offer to update subscriptions (in Petra there was a menu option to switch this warning on or off) (feature bug 2658)
      • No options for going directly to Donor Subscriptions or Donor Finance Details (not certain if this is needed but could imagine it might be useful) (feature bug 2659)
      • No check for EX-OMER (feature bug 2665)
      • Need to default confidential flag based on anonymity of donor (feature bug 2670)
    • Import/Export Gifts (0%)
      • Can only import whole batches at present (feature bug 1123)
    • Field Change Adjustment(0%)
      • Not there yet (feature bug 1124)
    • Gift reversal (80%)
      • Bug 2647, 2663
    • Gift adjustment (80%)
      • Bugs 2661, 2662
      • see bugs for gift reversal
    • Gift detail reversal (80%)
      • See Gift Reversal bugs
    • Gift Batch reversal (80%)
      • See Gift Reversal bugs
    • Post Gift Batch (50%)
      • Fee processing bug (bug 2643)
      • Posting of reversals and adjustments not working (bug 2664)
      • Admin Grant flag (a_charge_flag_l) ignored (bug 2645)
      • No warning currently for gifts to EX-WORKERs. Some equivalent to that is probably needed (in Petra it is based on EX-OMER special type) (feature bug 2665)
      • Needs to check that any Key Ministries being given to are still active (feature bug 2667)
      • Need warning if confidential flag not ticked for any donors that have the anonymous donor flag set (feature bug 2671)
      • Need to get up-to-date recipient field, cost centre and account based on recipient/motivation (leaving cost centre untouched if a reversal) (feature bug 2660)
      • Posting a batch with zero batch total results in gl batch with 0 transactions (bug 2666)
  • Recurring Gift Batch Maintenance
    • Batch Search (90%)
      • bugs 2685, 2687
    • Transaction Search (0%)
      • Need to be able to search for gifts across all recurring batches (feature bug 2689)
    • Batch Header (View/Create/Edit/Delete/Print) (90%)
      • Need printing
    • Gifts & Details (View/Create/Edit/Delete/Print) (60%)
      • bugs 2691, 2693
      • Need printing
      • Need to add label for donor information (in Petra displays bank account, receipting preference, anonymity). Label is there but not functional (feature bug 2601)
      • Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY) (feature bug 2597)
      • Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup) (feature bug 2598)
      • Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup) (feature bug 2599)
      • Needs to default Tax Deductible flag based on Motivation (will first need to be added to motivation detail setup) (feature bug 2600)
      • Correct setting of Cost Centre needs to be worked on (once CC link to Partner and Worker Field [see Specification for Worker Field ] properly implemented) (bug 2646)
      • Recipient field doesn't seem to be getting picked up properly (bugs 1001, 2642)
      • Grid may still need some re-design to make distinction clearer between normal and split gifts. Really needs some user input.
      • Recipient class currently limited to FAMILY or UNIT. May need to include PERSON.
      • No options for going directly to Donor Subscriptions or Donor Finance Details (not certain if this is needed but could imagine it might be useful) (feature bug 2659)
      • No check for EX-OMER (feature bug 2665)
      • Need to default confidential flag based on anonymity of donor (feature bug 2670)
    • Import Recurring Gifts (0%)
      • Not there yet (feature bug 1130)
    • Submit Recurring Gift Batch (70%)
      • Bugs 2695, 2698, 2699
      • Donation Period functionality will need further testing once bugs fixed
      • Needs checks for EX-WORKERs and expired Key Ministries (feature bug 2665)
      • Needs to check that any Key Ministries being given to are still active (feature bug 2667)
      • Need to get up-to-date recipient field, cost centre and account based on recipient/motivation (feature bug 2660)
  • Import/Export
    • Import Gift Batch (70%)
      • Bugs 1025, 1075, 1077, 1078, 1080, 2707
      • Currently processing stops at the first validation error. It may be necessary to change it to process the whole file to present a list of errors. This is a change we made to Petra for iConnect so may not be an immediate priority but should be considered.
    • Export Gift Batch (80%)
      • bugs 1345, 2706
  • Receipting
    • Periodic Receipts (10%)
      • Can't get it to do anything so hard to test further (bug 2725)
      • Appears to only allows annual, not other frequencies (or perhaps it does in which case it should be renamed to Periodic Receipts) (feature bug 2731)
      • No option to print Deceased Donors first (feature bug 2732)
      • No option to restrict by Donor or by Extract (2733)
    • Receipt per Gift (on Gift Post) (50%)
      • need to be able to select receipt form to use (once form design is implemented in some way) (feature bug 2735)
      • needs further testing once form design implemented
      • needs connection to print dialog (when there is one)
    • Receipt Control
      • Receipt per gift (70%)
        • bugs 2736, 2737
        • needs connection to print dialog (when there is one)
        • need to be able to select receipt form to use (once form design is implemented in some way) (feature bug 2735)
        • needs further testing once form design implemented
      • Change receipt numbering (100%)
  • Gift History
    • Donor & Receipient history (80%)
      • Add links to donor and recipient statements (not essential but Petra does have them on File menu) (feature bug 2758)
      • No ability to view selected gift (feature bug 2757)
  • Reports
    • Recipient Gift Statement
    • Recipient Gift Totals (0%) - May not be needed?
    • Recipient Gift Email (0%)
    • Donor Gift Statement
    • Donor Gifts to Selected Fields
    • Donor Gift Summary to Selected Fields
    • Donor Gift Totals
    • Donor Gift Tax Claim Report (Selected Fields)
    • One year monthly gift report
    • Total giving for selected Recipients
    • Field Gift Totals
    • Field leader gift summary
    • Field leader gift summary (2)
    • Total gifts through field
  • Swiss Tax-Deductibile gift functionality (0%)
    • Feature bug 1741 + children
  • iConnect Interface Changes (0%)
    • Feature bugs 2676, 2677, 2679, 2682, 2683

Accounts Payable

  • Create and maintain Supplier (100%)
    • May need to remove Early Payment Discount if that is not going to be implemented (see below)
  • Create and maintain invoice / credit note (90%)
    • Missing Early Payment Discount (feature bug 2811)
    • "Use Tax Account/CC" missing. Button there but no functionality. Don't know whether this is actually used in Petra (feature bug 2812).
  • List of suppliers and outstanding invoices (80%)
    • Find facility needed for invoices. May also be worth introducing standard OpenPetra filter/find (feature bug 2815)
  • Post an invoice (90%)
    • Insists on status Approved before posting, even if AP default is to allow posting of unapproved invoices (bug 2817)
  • Approvals (0%)
    • Feature bug 2818
  • Early Payment Discount (0%)
    • Check if needed as implementation in Petra seems to be sub-optimal! (feature bug 2811)
  • Invoice Payment (incl. partial payments) (40%)
    • "Print Cheque" disabled (feature bug 2820)
    • No Early Payment Discount (feature bug 2811)
    • Missing Tools Menu (sequential cheque numbering, global reference, global bank account & single invoice per payment) (feature bug 2821)
    • No way to remove an invoice from the payment (ie. some sort of remove invoice button) (bug 2822)
    • Payment by Transfer is missing
    • Can't test multi-supplier payments due to bug in outstanding invoices tab (bug #1991)
    • Various bugs
  • Analysis Attributes (100%)
  • Maintain defaults (0%)
    • feature bug 2814
  • Reverse Payments
    • Can't test due to unhandled exception
  • Reverse invoices (80%)
    • Can't reverse open invoices (ie. cancel them). Needs to be some way of cancelling an unposted invoice whether using reverse option as in Petra or having a separate cancel button
    • A few bugs
  • Import/Export (0%)
    • Not present currently. Needs checking to see if actually needed (feature bug 2816)
  • Cheque/Remittance printing (20%)
    • No cheque printing
    • Remittance does get printed but no control over output as far as I can see
  • Reports
    • Account Detail (100%)
    • Aged supplier list (90%)
      • Bug 2078
    • Current Accounts Payable (80%)
      • Missing "print detailed codes" option. No idea whether that is actually needed.
      • bug 2044
    • Invoice list (0%)
    • Supplier Statements (0%)
    • Payment Report (to be produced on payment and available for reprint) (85%)
      • bug 2097

ICH

  • Stewardship
    • Stewardship calculation (60%)
      • Needs to cope with non-ICH funds (eg. India) (feature bug 2930)
      • bug 2131
    • Stewardship Reports (1%)
      • HOSA (initial implementation exists)
      • Fees report
      • Stewardship Report
        • Needs to cope with non-ICH funds (feature bug 2931)
      • Auto-Email HOSA & RGS to each field
      • Email Export to head-office (for branch processing)
  • ICH Ledger (0%)
    • Import Stewardship file
    • Automated Bulk Stewardship import
    • Reports
      • Fund Balance
      • ICH Statement
      • Stewardship Status Report
Retrieved from ‘https://wiki.openpetra.org/index.php?title=Finance_Progress&oldid=3960’