ICH Stewardship calculation: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
Line 10: Line 10:


* check that there are still open periods (a_ledger.a_provisional_year_end_flag_l)
* check that there are still open periods (a_ledger.a_provisional_year_end_flag_l)
* Generate Admin Fee batch gl2150.p
* Generate Admin Fee batch gl2150.p (read also: [[How Admin fees are calculated]]
* create a GL batch with name "ICH Stewardship"
* create a GL batch with name "ICH Stewardship"
* for all foreign cost centres, find all gl transactions that have been posted but not been part of an ICH calculation
* for all foreign cost centres, find all gl transactions that have been posted but not been part of an ICH calculation

Revision as of 13:14, 12 October 2011

Intro

The stewardship calculation helps each office to calculate how much money they owe to other fields, and how much money they should be receiving from other fields.

Functionality involved

Generate and post the ICH stewardship batch

  • UI: gl2150-1.w to select the period for which the stewardship should be run.
  • Progress code: gl2160.p (called from accounts.w)


  • check that there are still open periods (a_ledger.a_provisional_year_end_flag_l)
  • Generate Admin Fee batch gl2150.p (read also: How Admin fees are calculated
  • create a GL batch with name "ICH Stewardship"
  • for all foreign cost centres, find all gl transactions that have been posted but not been part of an ICH calculation
    • process income
    • process expense
    • process direct transfers
    • mark the gl transactions as processed
    • mark all gift details as processed (a_gift_detail.a_ich_number_i)
    • Balance the cost centre by entering an opposite transaction to ICH settlement
  • Update the balance of the ICH account (like a bank account).
  • Post the ICH Stewardship batch
  • print report if needed (not done for the moment)

after the calculation

UI

  • The user selects the output options.
  • Progress code: gi3000o.w

Print Admin Fee calculation

  • Progress code: gl2150p.p

DROP: Recalculate the balances of the ledger

This might not be necessary in OpenPetra anymore. For the moment we should assume all balances are correct all the time.

  • Progress code: gs5530.p


Calculate the report

  • Progress code: gl2161p.p (for the moment ignore gl2160p.p, since it is slower, and only needed for previous years)

Generate the HOSA file

Home office statement of accounts, is sent to all offices that this office has financial dealings with.

  • Progress code: gl2120-1.i, gl2120p.p, gi3200.p etc

Generate and Email the report

  • Generate ICH Stewardship FILE and send it via email to the ICH office
  • ignore for the moment, needs to be done later
  • Progress code: gi3100.p

DROP: Recipient gift statements

  • send a report of received gifts to the recipients.
  • not needed anymore, should be uploaded the Intranet solution
  • Progress code: gr1121p.p

Special treatment for branch processing

  • this is for departments within the current field.
  • for the moment we should ignore this.
  • Progress code: gi3400.p