TimArcher.com A blog about technology...and more.

Recently, in an MBA class I was taking (Human Resources Management), I came across the 6 rules Jack Welch lives by.

For those who have no idea who Jack Welch is, he was Chairman and CEO of General Electric between 1981 and 2001. He practiced some unique leadership strategies during his tenure at GE, and increased its market capitalization by over $400 billion

I felt that the 6 rules are worth sharing with the the world and am publishing them below through this blog. By the way, I just finished the program and earned the degree! Yippee for me!

The six rules are:

1. Face reality as it is, not as it was or as you wish it to be.

Today I had a slight crisis…I had to reinstall QuickBooks 2006 on a new computer and restore the backup file that QuickBooks creates with the “.qbb” extension.

Everything worked great, and it was literally as simple as popping in the QuickBooks CD, installing the software, launching the program, and then following the steps from the “File->Restore menu”.

However, once I went into the Loan Manager to make a loan payment, I discovered none of the loans that I setup were there. I learned the hard way that the Loan Manager data is not backed up with your QuickBooks backup file. I really did not want to re-key in my loans, figure out what payment number I was on, determine principal and interest components, etc…Needless to say I was a little sad and looked for a way to get my Loan Manager data back.

At the University for which I work, we had a need to integrate our Sungard HE Banner ERP system with Barnes and Noble (our outsourced bookstore) to process book vouchers, and with our credit card processing API (Intellipay). Both of these applications required us to post charges and payments directly to the student’s account.

With our Barnes and Noble integration, the process works as such:

1. We send Barnes and Noble a file of how much money the student has in book vouchers, which is equal to the credit amount the student has in their AR file (the TSAAREV screen). Barnes and Noble loads this information into their system.
   

Are you a Sungard HE customer using the Banner ERP Software?
Have you ever wanted to know how to easily select a student's account balance?

Well, all of a student's charges and payments are held in the tbraccd table. Banner defines the tbraccd table as the "Account Charge/Payment Detail Table". Furthermore, each entry in the tbraccd table has a specific detail code defined in the tbraccd_detail_code column. This column relates to the tbbdetc table, which Banner defines as the "Detail Charge/Payment Code Definition Table".

Essentially, the tbraccd table stores the type of transaction, and the transaction amount. The tbbdetc table tells us whether that transaction type is a charge or a payment.