Archive for category General Tip

Working With “Groups”

I am not taking about group trips, but groups within ClientBase.  Last week an agent sent me an email asking why a client she knew was part of a particular group was not showing up in a report.

The secret is to remember that GROUPS in ClientBase are available in PROFILES, RES CARDS and INVENTORY (and more, but those are the biggies). And they are mutually exclusive.

The easiest way to remember is to think specifically for that particular task.

  • If you are working a group trip and you want to make sure all of the RES CARDS are together, you want to create a group for the RES CARD.
  • If you are working with a group from Church, you want to make sure all the PROFILES are together in that group.
  • If you want to know all of your suppliers who sell River Cruises, create a PROFILE group for that group of vendors.

Remember, the same group can also apply for profiles, res cards,  and inventory. For instance, if you have a Church group that is looking to go on a cruise in December.  Create a group and call it “Church Cruise” and assign it to profiles, res cards, and inventory.

To create a group,  GLOBAL DEFAULTS–>GROUP LISTS–> ADD

GROUP

Then name the group and select the areas you want to use to track. (Testing, Client, Invoice, Payment,Res Card, and Inventory)

Group1

Click OK and the group will appear in the drop down list of the appropriate areas.

Why groups? Right now I am working on a dozen families that are going to be at Beaches the same week. It is a group (but not technically per the vendor). I have all of the clients, res cards, and invoices tagged. That way when I want to see a list of people going, I can query the profile manager by the group.  If I want to see the individual reservations, I can query the res cards by that group.

I STRONGLY suggest creating your groups this way and NOT typing them in the field manually. It is too easy to make a typo and any typo will throw off the computer. You can create a group on the fly as well. Just click the blue underline and go from there.

And here is a tip.  When the group is no longer “active” you can delete the group from the list (it will not show in the drop down) but it will leave the group in the proper records. Caution: you need to know the exact name of the group down the road. Another alternative is to re-name the groups that are inactive beginning with “zz” that way they show up at the bottom of the drop down list.

Did this site help you out? You can always buy us a beer!

Tags:

No Comments

Date Formulas: A GREAT Shortcut

Many times you want to use a date in the future or in the past to develop a query.  Let’s say you wanted to see how many inquiries you received during the past 30 days. Rather than figuring out the exact date, use a formula.

Instead of dates, you work with numbers separated by commas. The first number represents the days, the second the months and the third the years. Named days can also be used as well as the + and – signs to indicate future and past dates.

And in addition to this, did you know that when you enter a date the long way, there are some shortcuts?  Enter any number between 1 and 31 (or 30, 29, or 28 depending on the month) and ClientBase will assume you mean this month and year and will fill it in for you. Looking for a date later this year? Just type in 1015 (no slashes needed) and ClientBase will know you mean October 15, 2009.

These can be used in any date field:

If You Want This

Enter This

1st day of this month:

=1,0,0

Last day of this month:

=31,0,0

1st day of this year:

=1,1,0

Last day of this year:

=31,12,0

Seven days from now:

=+7,0,0

Last Monday (will show today if today is Monday)

=Mon

A week from last Monday

=Mon-1

Next Monday

=Mon+1

Three months from now

=0,+3,0

Six months ago:

=0,-6,0

One year from now

=0,0,+1

Did this site help you out? You can always buy us a beer!

No Comments

Are You Paperless?

ClientBase has really helped you to streamline your work process. Do any of you recall the days of index cards and reservation folers or client worksheets? Are any of you still using them? SHAME ON YOU!

I read an interesting article the other day (I will look for a link) that said the advent of computers actually INCREASED our consumption of paper–for a period. Remember the old pin-fed printouts? But out consumption today is actually less than it was pre-computer.  Pretty cool, huh?

So, are you using ClientBase to help eliminate your paper clutter? Are yo using attachments? It couldn’t be any easier.

  • Sign up for a e-fax service so all of your faxes are coming in as a PDF file.
  • Install a PDF print driver (standard in Vista and available in XP for free)

Now you have the ability to store all of your faxes and “print” all of your emails and convert them to a PDF file. So what? How do you organize that?

Again, simple!  Say you get a fax (PDF) from Trafalgar Tours for the client doing the Turkish Tour this summer. Save the file on your hard drive. Then switch into ClientBase, pull up the appropriate res card (or profile if it is not a res card specific document) and click on the ATTACHMENTS tab and then click ADD. Surf your way to the proper file and attach it.

ClientBase has just added a map to the document so you can retrieve it when you need it and where you need it.

Think of all the documents that come in during the course of a transaction. Several quotes, a final quote, a vendor receipt for the deposit, vendor receipt for final payment, fuel surcharge increase, countless emails. Wouldn’t it be nice to have them all in one place where the only things you see are the things that are appropriate to the specific reservation?

If you are interested in the habits of an almost paperless office, Barb Oliver from All Together Now Travel (and avid ClientBase user) will have a column on Travel Research Online on March 20th.

Did this site help you out? You can always buy us a beer!

Tags:

No Comments