TerminateJobCostLedgerTypesCache

Trial Balance Calculate Balances

Minor Business Rule

Object Name: B0900090

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function is used to terminate the cache that is used in the Trial Balance Calculate Balances
BSFN.

Setup Notes and Prerequisites
This function should be called when all processes are completed.  At the end of a BSFN, in End
Section of a UBE or on the Cancel Button of an interactive application.  The user should pass a "Y" in the
cTerminateLedgerTypesCacheFlag parameter.

Special Logic
Please refer to the Data Structure Attachments for detailed instructions on parameter requirements
and functionality.

Technical Specification

Main BSFN:
If cTerminateLedgerTypesCacheFlag = "Y"
   Terminate the "Ledger Types" Cache

Data Structure

D0900090A - Terminate Job Cost Ledger Types Cache

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cTerminateLedgerTypesCacheFlag	EV01	char	OPT	INPUT
Special Input Expected Pass a "Y" to allow for the "Ledger Types" cache to be terminated. This BSFN should be called when the process has completed calculating all balances, i.e. End Section of a UBE, the Cancel Button of an Interactive Application, or at the end of a BSFN. Special Output Returned ^

Related Functions

None

Related Tables

F0025 Ledger Type Master File
F0901 Account Master
F0902 Account Balances
F0911 Account Ledger

TrialBalanceCalculateBalances

Trial Balance Calculate Balances

Major Business Rule

Object Name: B0900090

Parent DLL: CFIN

Location: Client/Server

Language: C

B0900090  Trial Balance Calculate Balances:

Functional Description

Purpose
This function is used to calculate an account's balance.

Setup Notes and Prerequisites
This function was originally designed to be used in the Trial Balance by Business Unit application,
but has been enhanced to handle any type of account balance calculation.  This function replaces
B0900008 - Return Account Balance.

Special Logic
This function can act either of two ways:
1. Can calculate the account balance for one specific account (Most common use).
To accomplish this pass a "9" in the cRequestedLevelOfDetail parameter.
2. Can calculate the account balance for one specific account AND all other accounts that are
underneath this account in Level of Detail. (Used in LOD Trial Balances).
To accomplish this pass the requested roll up LOD in the cRequestedLevelOfDetail parameter, and the
Account's actual LOD in the cAccountLevelOfDetail.

In addition, this function will calculate balances for all ledger types that have the FBL flag set to
"1" in the F0025 table.  This field represents Revisable Budget Job Cost Ledger Types.  To accomplish
this, pass a "Y" in the cUseAllJCBudgetLedgersFlag parameter.  You will also need to call the
Terminate Job Costs Ledger Types Cahce afterwards to delete the cache.

Please refer to the Data Structure Attachments for detailed instructions on parameter requirements
and functionality.

Technical Specification

Main BSFN:
Determine Rollup Method
Set F0902 Table Info
If Using Date Effectivity
   Set F0911 Table Info
If cRequestedLevelOfDetail = "9"
   / *If cPostingEditCode != "N" */
   /* Needed to disable the above ER because the account balances need to be displayed for
non-posting accounts as                well.  Please see SAR #3152931. */
      Call Account Balance Calculate
Else
   Fetch record from F0901 based on cAccountID
   /* If cPostingEditCode != "N" */ /* This line needs to be disabled because the account balances
need to be
      displayed for non-posting accounts as well. Please see SAR #3152931. */
      Call Account Balance Calculate
   Fetch next record from F0901
   While Fetches from F0901 are valid AND Fetched LOD > cAccountLevelOfDetail
      If Previous PEC = BLANK AND Previous LOD != cAccountLevelOfDetail
         Stop Processing
     /* If Fetched PEC != "N"*/ /* This line needs to be disabled because the account balances need
to be
        displayed for non-posting accounts as well.  Please see SAR #3152931. */
         Call Account Balance Calculate
      Fetch next record from F0901

Account Balance Calculate:
This logic is run for each Ledger Type individually.  All date information is relative to which
Ledger Type is being processed. i.e. szLedgerType2 uses jdThruDate2, mnFiscalYear2, etc...

If szLedgerType != BLANK
   If cDateEffectivityFlag = "Y" AND jdThruDate != jdPeriodEndDate
      Set flag to NOT process the F0902 for Period Balances
      Calculate "Middle Of The Month"
      Calculate "Number Of Days Difference" between jdPeriodBeginDate
                                                          and jdThruDate
      If "Number Of Days Difference" < "Middle Of The Month"
         Set flag to process first half of period
         Subtract 1 from mnPeriodNumber
         Set F0911 key to jdPeriodBeginDate
      Else
         Set flag to process last half of period
         Set F0911 key to jdThruDate
      Call F0911 Balance Calculate
      If cIncludeUnpostedFlag = "Y"
         Set F0911 key to Posted Code of BLANK
         Call F0911 Balance Calculate
   Else
      Set flag to process the F0902 for Period Balances
      Call F0902 Balance Calculate
   Accumulate Calculated Balances to Return Data Structure
If cUseAllJCBudgetLedgersFlag = "Y"
   Read F0025 records into "Ledger Types" cache

Note: Process the following logic for ALL Ledger Types found in the F0025 table.

   If cDateEffectivityFlag = "Y" AND jdThruDate != jdPeriodEndDate
      Set flag to NOT process the F0902 for Period Balances
      Calculate "Middle Of The Month"
      Calculate "Number Of Days Difference" between jdPeriodBeginDate
                                                          and jdThruDate
      If "Number Of Days Difference" < "Middle Of The Month"
         Set flag to process first half of period
         Subtract 1 from mnPeriodNumber
         Set F0911 key to jdPeriodBeginDate
      Else
         Set flag to process last half of period
         Set F0911 key to jdThruDate
      Call F0911 Balance Calculate
      If cIncludeUnpostedFlag = "Y"
         Set F0911 key to Posted Code of BLANK
         Call F0911 Balance Calculate
   Else
      Set flag to process the F0902 for Period Balances
      Call F0902 Balance Calculate
   Accumulate Calculated Balances to Return Data Structure
Calculate Variances

F0902 Balance Calculate:
While F0902 Fetches are valid
   Fetch record from F0902
   If Fetch is valid
      ANxx is the requested period bucket of the F0902
      If Flag to Process the F0902 = "Y" OR
         Flag to Process First Half of Period  = "N"
         Add ANxx to Accumulated Period Balance
      Add ANxx and all other's prior within the Fiscal Year to Accumulated
                                                                 YTD Balance
      Add APYC to Accumulated Balance Forward Amount
      Add APYN to Accumulated Prior Year Net Posting Amount
      Add BORG to Accumulated Budget Original Amount
      Add BREQ to Accumulated Budget Requested Amount
      Add BAPR to Accumulated Budget Approved Amount
      If cAddBalanceForwardToYTDAmount = "Y"
         Add APYC to the Accumulated YTD Balance

F0911 Balance Calculate:
If Flag to Process First Half of Period  = "Y"
   Fetch record from F0911
   While Fetched Date <= jdThruDate
      If Fetched Date <= jdThruDate AND Fetched Date >= jdPeriodBeginDate
         Add AA to Accumulated Period Balance
         Add AA to Accumulated YTD Balance
      Fetch record from F0911
Else
   Fetch record from F0911
   While Fetched Date >= jdThruDate
      If Fetched Date >= jdThruDate AND Fetched Date <= jdPeriodEndDate
         Subtract AA to Accumulated Period Balance
         Subtract AA to Accumulated YTD Balance
      Fetch record from F0911