TIMSS 6: Revenue Distribution with Fixed Amount & Remainder

Our membership dues are calculated on a dues schedule and can be from $400 to $50,000. We wanted to have the first $400 go to one revenue account and the remainder go to a second account.

When setting up the revenue distribution you will setup 2 pairs by priority.

• For the $400 revenue pair, the % should be 0, the priority should be 1, and the amount 400.
• For the next revenue pair, the % should be 100, the priority 2, and the amount all 9's.

Applies to: TIMSS6

TIMSS 6: Online Report Parameter Pick List

So you've written a Crystal report and attached it to a screen, and one of it's parameters needs to be one a few specific values. You can use the List SQL at the bottom of the screen to allow users to select certain values.

You can put a query here to pull values to show in a list. Something from types and codes:

select code from app_code where subsystem='CUS' and type='GENDER'

or if your parameters don't exists anywhere you could use the following query:

select 'NORMAL' union select 'CFLT'

to get a listing of just NORMAL and CFLT.

When the report is run, there will be binoculars next to the field that the user can click on and select a value from the list. You should note that this List SQL is available for each parameter, so which ever row you have highlighted in the parameter table above the List SQL box will be the parameter that you are creating the list for.

Applies to: TIMSS6

TIMSS 6: Hot Key your Buttons

If you've added a button to a screen, you can make it so a hot key will click your button. In the customizer, all you need to do is name the button with an ampersand before the letter that you want to be the hot key.

So if you added a Google button to a screen and you want Alt-G to launch the click event, you'd put an "&" before the G in the Text property of the control.


Then the button will be labeled Google and Alt-G will start the click event. Make sure that there are no other hot keys for that letter.

Applies to: TIMSS6

Prepayment Liability Account

I was going though old emails on the listserv today and came across this from Tom B. regarding the Prepayment Liability Account. It's helpful information.

The name actually has been used in TIMSS for over 20 years and originally came from an accounting professor at the University of Chicago who consulted on the first design of the old RAMS accounting system and has been used ever since. (I even heard today that iMIS uses the same term but I can't verify that personally.)

The idea and accounting behind it is that when money comes into the organization and is applied to an order that has not been invoiced yet, you cannot consider that to be any kind of revenue because you haven't fulfilled any commitment on your part, i.e. shipped a product. When there is an active order for membership or subscription, the typical thing is to call these amounts Deferred Revenue. For inventoried products, these prepayment amounts are obviously liabilities to the organization until the product is shipped. If you don't ship, you owe the customer the money back. Once shipping takes place, the amount is transferred to a revenue account. Thus begat the term "Prepayment Liability" since this was an amount applied to a specific order prior to shipping and was applied to a GL account that appears on the liability section of the balance sheet. So, a PPL is a liability account. It is a form of deferred revenue but a special one that separates money received that isn’t yours yet because you haven’t invoiced versus money you know you will earn if you only follow through with scheduled deliveries of subscriptions or memberships.

Applies to: TIMSS5 & TIMSS6