CGB Questions

[Tammy-Lu Vandevender]

Hi All,

We have encountered some issues with the baseline CGB that did not exist in our pre-release (or we overrode it) and we would like to understand how these situations would be managed in KFS and how others handle these situations.

 

1. Awards with multiple accounts and Milestone or Predetermined Billing Schedule billing frequency:  KFS has an edit to only allow one active account for awards that have either Milestone (MILE) or Predetermined Billing Schedule (PBDS) billing frequency.  We think this is because there is no way to allocate the lump sum amount to multiple accounts.  We have cases where there are different accounts for different tasks, or years or with different IDC rates but all are part of one award.  In order to work around the validation in our pre-release code, we bypassed the validation and we inactivated accounts that were not being billed prior to generating the CG Invoice.  Then we would reactivate them.  This is not an ideal solution and we aren't sure if the validation serves another purpose.  Alternatively, we would manually bill the sponsor and not use CGB.  

 

2. Awards with different billing frequencies:  We have situations where an award may start as a PDBS and then change to Cost Reimburseable (e.g., an award with an advance and then cost reimburseable after the advance is expended).  KFS has an edit that does not allow changing of the billing frequency if there are active milestones or PDBS.  However, once a milestone (or PDBS) is billed, the Active Ind is locked from editing and it is not set to Inactive.  We think CGB should automatically inactivate the MILE/PDBS once it is billed.  KFS sets the Billed to Yes.  This seems to be a bug.  The Active Ind did not exist in our pre-release code.

A separate issue for this type of situation is that the lump sum amount would need to be allocated to the different cost categories on the first cost reimburseable bill to reflect the amount already billed. CGB doesn’t add the lump-sum amounts to prior billed balance by category like Cost Reimbursable, so the entire ITD expenditures show as the current & cumulative billing, and AR/Revenue, adjustments to C&G Project Account & Customer AR would be done manually (perhaps a default could be set, i.e. “Other Expenditures” code & current expenditures on the first Cost Reimburseable would be adjusted manually for presentation purposes, but cumulative & AR/Revenue would be correct).

 

We would appreciate any feedback you can provide.

 

thanks,

tammy

--

Tammy Vandevender | Director | University of Hawaii System  |  Financial Management Office - Fiscal Services Office
1406 Lower Campus Road, Room 43 | Honolulu, HI  96822
phone: 808-956-0383 |  ta...@hawaii.edu

[Janet Strait]

Hi Tammy-

 

#1, for milestone and predetermined billing, we aren’t able to proceed with CGB base code as designed.  Regardless of invoice method we could have more than one project account.  For those interested, I can share  functional needs based on our discussion related to this topic.

 

#2, we were just discussing this issue Friday and would be interested in hearing how others are addressing.  This does come up fairly regularly.

 

Thank you,

Janet

--
You received this message because you are subscribed to the Google Groups "Kuali Financials Functional User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to kfs.user.fun...@kuali.org.