Finance Progress

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 (50%)
  • 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%)
  • Import not working yet (bug#765)
  • 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%)
  • Import not working yet (bug#765)
  • 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%)
  • Needs Edit & Delete buttons
  • 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%)
  • Needs Edit & Delete buttons
  • 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%)
  • 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)
  • Associate Analysis Types with Cost Centre/Account combos (not current functionality but database supports it)

• Form Design (0%)

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

General Ledger Setup

• Create Ledger (60%)
  • 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

• Accounts (30%)
  • Need accounts displayed in full list, not just hierarchical view
  • Need print functionality
  • Need to be able to move accounts within hierarchy
  • Need Account Rename
  • Should disallow foreign currency accounts for income and expense accounts
  • 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%)
  • 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 delete functionality
  • Need Cost Centre Type field (Local/Foreign)
  • Need to be able to set Equity Settings on the Cost Centre
  • 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

• Enable/Disable Sub-systems (0%)

• Define Calendar (only needed as part of ledger creation)
  • Need to be able to specify start and end dates of each period (currently can only specify number of periods)
    • 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%)
  • 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
    • 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

• GL Batch Maintenance
  • Batch Search (0%)
  • Transaction Search (0%)
  • Batch/Journal/Transaction grid (60%)
    • Moving between rows is much too slow
    • Bugs (#803, #804, #807)
  • Create/Edit/Delete/Print Batch Header (60%)
    • No print option
    • Should not allow blank description
    • 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
    • Should not allow blank description
    • Journal description should default to batch description
    • Bugs relating to setting of exchange rate (#811-#814)
    • Need Allocation journals
    • Need Re-allocation journals
    • Need Revaluation journals
  • Create/Edit/Delete/Print Transactions (30%)
    • No print option
    • Should not allow blank narrative
    • Moving between fields is too slow (bug#822)
    • Bug#821
    • 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
    • No way to enter analysis attributes (there is a tab there but no way to add to it)
  • Import Transactions (50%)
    • Can't import transactions into an existing journal (can only import a whole batch currently)
    • 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)
    • Friendlier error messages when incorrect data in file might be nice
    • There is no validation of batch period on import (I can successfully import a batch for a closed period) (bug#839)
    • No validation on most fields
    • Ignores exchange rate (just stores 1 regardless). Exchange rate should be stored on journal record plus a daily exchange rate record should be created (if it is not 1)
  • Reverse batch (0%)
  • Reverse journal (0%)
  • Post Batch (still testing)
    • Test Batch and Post Batch need to check debit/credit total against hash total
    • Bugs (#808-#810)
  • Posting Register Reprint (0%)

Gift Processing

• Setup
  • Admin Grants
  • Motivation Group (90%)
    • Needs Delete button
  • Motivation Detail (30%)
    • Can't enter non-GIFT motivation details (bug 964)
    • No Motivation Short Code (for display on receipts)
    • No local description
    • No link to Key Ministries
    • No "Populate Gift Description"
    • No "Tax deductible" check-box
    • No "Export to Caleb" check-box
    • Admin fee lists could do with being a bit larger so descriptions can be read
    • 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)
• Gift Batch Maintenance
  • Batch Search (50%)
    • Can filter by year & period but might be better to filter by batch description and date range as in "old" Petra
  • Transaction Search (0%)
  • Batch Header (View/Create/Edit/Delete/Print) (70%)
    • Needs validation that date is in open period
    • Needs some sort of link to Daily Exchange Rates (currently exchange rate just entered manually)
    • Needs print functionality
    • Various bugs (893, 895-897, 934-936)
  • Gifts & Details(View/Create/Edit/Delete/Print)
    • Motivation should be set to appropriate default based on recipient (eg. GIFT/SUPPORT if recipient is a FAMILY)
    • Auto-populate comment from Motivation Detail description not there yet (will first need to be added to motivation detail setup)
    • Auto-population of recipient where motivation linked to a key ministry (will first need to be added to motivation detail setup)
    • Needs print functionality

• • Import Gifts
  • Field Change Adjustment
  • Gift adjustment
  • Gift reversal
  • Gift detail reversal
  • Gift Batch reversal
  • Post Gift Batch
    • Doesn't consider hash total (needs to fail if hash <> batch total)
    • Needs fee processing
• Recurring Gift Batch Maintenance
  • Batch Search
  • Transaction Search
  • Batch Header (View/Create/Edit/Delete/Print)
  • Gifts & Details (View/Create/Edit/Delete/Print)
  • Import Gifts
  • Submit Recurring Gift Batch
• Import/Export
  • Import Gift Batch
  • Export Gift Batch
• Receipting
  • Periodic Receipts
  • Receipt per Gift (on Gift Post)
  • Receipt Control
    • Receipt per gift
    • Change receipt numbering
• Gift History
  • Donor history
  • Receipient history
• Reports
  • Recipient Gift Statement
  • Recipient Gift Totals
  • Recipient Gift Email
  • 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