Survey

Please note that there is no new survey this month.

Latest version information

This message is a repeat of a general e-mail broadcast sent to all clients on Monday, 12 October 2009. This notification applies to AM-Win users who have a Software Upgrade Agreement [SUA] and are currently using version 7.610 or later

V7.631 upgrade is available for download on our website Click here to open the download page and select V7.6 upgrade at the bottom right.

Any user who is using a version 7.609 or earlier please contact your supporting Consultant to discuss your upgrade. Do not upgrade prior to contacting your Consultant.

Details of changes in this new version can be obtained after installation within Am-win under help, About this version.

Tunehouse in Marrickville Wins Prestigious Award

Congratulations to one of our special AM-WIN customers, Tunehouse in Marrickville, who has recently been awarded “Best Dyno Cell / Workshop" from The High Performance Imports Magazine. Well done Guys! What a great achievement!

Tunehouse might not be the biggest, but its Sydney’s best certified HKS Pro Dealer, which is something that’s not easy to come by! Their premises are just kept pristine and clean and are state of the art!

Visit The Tunehouse website at http://www.tunehouse.com.au/index.html . Like everything else that Tunehouse does it's very professional. While you're there read the testimonials [ http://www.tunehouse.com.au/testimonials.html ] and you'll get a good idea of the level of professionalism and customer care offered by Jim's team.

Jim Ghelis, Managing Director, does indeed run a very tight ship with the best dyno cell ever seen. Jim takes a lot of pride in his work and his customer service is his number one priority! Jim and all of the friendly staff at Tunehouse have a loyal dedication to their work which is reflected in the presentation of their workshop and interaction and rapport with their customers!

This award is definitely well deserved and it shows awesome recognition to the most hardworking people in the Dyno Industry! From everyone at AM-WIN and Am-Win Dealer ASIMS, we wish to convey our warmest congratulations to Jim and his dedicated staff for a wonderful effort in achieving recognition through this most prestigious award!

AM-Win Support Solutions

How to do Batch Journals

You may be in a situation where you are required to repetitively process a journal entry on a regular basis whether it be weekly, monthly or at a random interval. To save having to recreate this repetitive journal each time, the system now allows you to generate a standard batch journal. This journal provides all of the functionality of a normal journal entry.

To access Batch Journals, go to Ledger > Batch-Journals. This will open up the Batch Journals window.

Click on the Insert Button and you will be asked to insert the number reference you wish this batch journal to be named. (Eg, 1, 2, 3 etc). You will also be asked to insert a description. (E.G. Account Keeping Fees). Then click on the OK button to save.

Then click on the Insert Button at the bottom of the screen once you highlight the journal you want to set up from the top half of the screen and then set up details of the actual journal entry processes.

The following screen will appear.

Then insert for Batch Journal 1, the ledgers required to complete this journal process. Eg, for Account Keeping Fees, you would enter Ledger 1020, enter a description of say “Bank Fees” and enter in the relevant amount. Then choose a type, eg Credit. Then click on the OK button.

Then do the same for the other side of this journal (ie Debit). eg Choose your Bank Fee Ledger to debit the amount into.

As you can see, there is now an entry from the 1020 ledger into the Bank Fee Ledger (in this case it is 9600). This completes both sides of the journal entry

You can enter as many Batch Journal entries as you wish using the method above.

Once you are happy with the Batch Journal entries, click on the Close Button to exit this screen.

You can then use these Batch journals by importing these procedures into your normal Journal entry screen. Simply click on the Import Button, select your Batch journal from the list by highlighting the one you need and clicking on Select Button. Then when the batch journal is dropped into your Journal Entry screen, simply make the relevant changes and add the amounts you need and then Process!

Standing Journals

The Standing Journal option is used where you have any automatic monthly deductions from your Bank Account. Here you can set the Date and the Amount to be automatically deducted each month, so at all times you are able to know your correct Bank balance in AM-WIN, since the Bank's computer will perform the same task.

How to make a Standing Journal Entry

In the AM-WIN window, Go to Ledger > Standing Journals. The Standing Journals window appears.

Select Insert to add a new standing journal. You will enter Insert Mode.

Then enter the Journal Code This is a name or a code for the Deduction we are setting up. For example, if the Automatic Deductions are made to a bank, name it NAB, CBA etc, or if it is to a finance company, enter Esanda etc. Something meaningful so when you go through your bank reconciliation you know what the payment was for.

Then click the dropdown menu on the right of the Journal Code field and select whether the automatic deductions attract GST, are GST Free, is an Acquisition or N/A.

Enter in a Description for the Payment. Eg Bank Fees, Loan Deduction etc

Then choose a ledger where the payment will be deducted by using the From Ledger Account. Click the From Ledger A/C button. The Select St. Journals Ledger window appears and from here select the ledger you wish to use.

NOTE: If the ledger you want to use is not listed. You will need to go to the General ledger masks to insert the ledger you need. Go to Tools>General Ledger Masks. Click on the St. Journal option on the left hand side of the screen. Then add the ledger on the right hand side of the screen using the little square button and then choosing the ledger we need. Once you have entered in the ledgers you need, then Save and Close from the screen.

Insert the ledger account for the other side – I.E to the ledger you wish to allocate the payment. Click on the To Ledger Account button and choose your Ledger Account as above.

Amount - Enter the Amount that is automatically deducted for that particular Payment.

Process Each - Click on the dropdown menu to select Weekly, Fortnightly, or Monthly. Depending on which option you have selected, an automatic deduction will be made each time.

Day of the Month to Process - If monthly payments are made, enter the day of the month that deductions are to be processed.

Commencement Date - Enter the commencement date of the automatic deductions. You may click on the Commencement Date button open up the calendar to select the appropriate date.

Next Due Date - Enter the next due date when deductions are to be made. You may click on the Next Due Date button to open up the calendar to select the appropriate date.

Termination Date - Enter the Date the Automatic Deduction Payment terminates. You may click on the Termination Date button to open up the calendar to select the appropriate date. When the computer reaches the date entered in this field, Automatic deductions will the stop.

Select Save to save the standing journal entry.

To delete a standing journal, enter the journal code or click on the journal to be deleted and select Delete.

The standing journals will process every time you do a Month End.

Windows, Word and Excel Tips

Windows

Windows Logo

Delete an Address from the Outlook Auto-Complete List

How to Delete an Address from the Outlook Auto-Complete List

Outlook remembers every address you have typed in a To:, Cc: or Bcc: field. This is good: when you start keying in a name or address, Outlook automatically suggest the contact in its entirety.

Unfortunately, Outlook remembers the mistyped and old as well as the correct and current — and suggest it indiscriminately. Fortunately, getting rid of entries you no longer want to appear in the auto-complete list is easy.
Delete an Address from the Outlook Auto-Complete List

To remove a name or email address from Outlook's auto-complete list:

* Create a new email message in Outlook.
* Start typing the name or address you want to remove.
* Use the down arrow key to highlight the desired (undesired) entry.
* Press Del.

MS Word

Word logo

Manipulating Fonts

When working in MS Word, we all know about the usual toolbar / ribbon buttons and lists that allow us quick access to things like font type, size, bold, italics, underline, color, etc.

But, did you know that there are even more aspects of your fonts that can be manipulated?

There are things like character spacing and text effects to be explored, along with options like strikethrough text, superscripts, shadow, embossed text, engraved text and so on.

And... all of these things are available without create WordArt. These formatting options are for your everyday, run-of-the-mill text.

So, the question becomes: "Where are all these things? After all, I certainly don't see them on the Formatting toolbar or the Home tab of the Ribbon."

You're right. You don't see all the options on that toolbar or tab, you just see the most frequently used items.

So, for more options, you've got to go to the Font window.

One way to access the "extras" is to use the Format menu, Font choice (older versions of Word) or Home tab, Dialog Box Launcher button in the bottom right corner of the Font section (Word 2007).

A faster way would be to do a quick Ctrl + D (this one works for all versions of Word).

Here's what you'll get when you go to the Font dialog box:

The character spacing tab

The Text effects tab

As you can see there's a lot more to your average text then you may have thought - and all of it's available with a quick click or key combination!

Adding Columns to Your Page Layout

As you format your layout in Word, you may find it better to lay out your text in columns. This is usually done if you are developing a newsletter or a magazine layout. The number of columns you use is up to you—Word allows you to divide your page into as many as 100 columns (depending on your version of Word), although this may look a bit strange. To add columns, follow these steps if you are using Word 2007. Instructions for earlier versions of word appear later in the article.

Position the insertion point at the beginning of the material you want to appear in columns.
Choose the page layout tab from the ribbon
In the Page Setup group, click the Columns drop-down list.
Pick the number of columns you want to use for the selected text.

When you do step 3 you can select the most common numbers of columns (1, 2, or 3). If you want more columns then these, click the More Columns option in step 4 and you will see the Columns dialog box where you can set up to 45 columns.

There is an interesting side note here. If you use the up and down arrows in the Number of Columns field of the Columns dialog box to set columns, you can only choose a range between 1 and 13 columns when you are using portrait-oriented letter-size paper. If you change to landscape-oriented paper, then you can use the control to go between 1 and 18 columns. It appears that Word sets the upper limit of the control so that no individual column on the paper will be less than a half-inch wide. If you change the printable area of your page (adjust the paper size, orientation, and margins), then Word adjusts the upper limit of the Number of Columns control.

Don't let this fool you, however. You can still set up to 45 columns—sort of. You just have to type the number into the Number of Columns control. If you try to type a number that is larger than 45, Word generates an error message that says you can only set between 1 and 45 columns. So, you can try to type a larger number into the control, but when you do and then start working with a different control in the dialog box, Word adjusts the number of columns back down to the calculated maximum discussed previously. (Word just won't let you set a column width narrower than half an inch, and this limits the number of columns you can get on the page.)

If you are using an older version of Word, you can set the number of columns in your layout by following these steps instead:

Position the insertion point at the beginning of the material you want to appear in columns.
Select the Columns option from the Format menu. Word displays the Columns dialog box.
Click on one of the presets at the top of the dialog box, or specify the number of columns wanted in the Number of Columns field.
If you don't want your entire document to have columns, in the Apply To drop-down list select This Point Forward. This causes Word to apply columns beginning where the insertion point is located.
Click on the Line Between check box (if you want a vertical line between the columns).
Click on OK.

What if you have a document and you want to format part of it in columns? As an example, let's assume you have a 5-page document, and you want to format the center part of page 2 as three columns. You want rest of the document to remain a single column. To overcome this formatting challenge there are only two changes you need to make to the above steps. First, in step 1, you need to select the text that will appear in the columns. Second, in step 4, you need to use the Apply To drop-down list to choose Selected Text.

Note:

Please note that we do not provide support for our Word and Excel tips as they are provided by a third party. If you need further information why not try using Google - Cut and paste the heading of our tip into Google's search box. You'll be amazed at the information available.

Microsoft Excel Tips

Excel Logo

Excel: Different behaviours between a cut/paste and a copy/paste

Excel: Different behaviours between a cut/paste and a copy/paste

It sounds obvious but there is a difference in the way each of them treats formulas with relative cell references?

Relative cell references are formula references to other cells based on their location as compared to the cell with the formula. In opposition, they would be absolute cell references, which refer to a specific cell, no matter where the formula is copied or moved.

If you copy/paste a formula containing a relative cell reference, you will find that the cell references are adjusted. That is, the new formula will call for cells located in the same positions, as compared to the cell containing the formula.

For example, let's suppose you have the following situation where cell D1 contains a formula for the sum of cells A1 to A3.

With a copy/paste, you will see that as the formula is copied one column to the right, the cell references are also changed to read one column to the right. (Instead of calling on cells A1 to A3, the new formula calls for cells B1 to B3).

,
The original formula called for data three columns to the left and so does the newly copied formula.

In contrast, if you choose to cut/paste the formula, you will find that the cell references are NOT changed.

The formula still refers to the exact same cells as it did in its old location.

Moving and Copying Cells - Paste Special

At the very heart of editing is the ability to move and copy cells in a worksheet. Understanding the differences between these operations, as well as how to perform them, is important for any Excel user. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Moving and copying cells is a very common procedure when you are developing or editing your worksheets. Excel refers to moving by a different term, however. It is called cutting, which implies that you cut the information from one place and put it in another. Copying differs from cutting in that copying does not disturb the original cells; cutting clears them.

Whether you are cutting or copying, these operations involve the use of the Clipboard, a temporary storage area that is built into Windows. To cut or copy information, you must first select the cells you want to affect. Then do one of the following:

To cut cells, just press Ctrl+X; this shortcut will work in all versions of Excel. If you don't want to use the shortcut, then you could right-click the selection and choose Cut from the Context menu. If you are using Excel 2007 you can display the Home tab of the ribbon and click Cut in the Clipboard group. In older versions of Excel you can choose Cut from the Edit menu or click on the Cut tool on the toolbar.

To copy the cells, just press Ctrl+C or Ctrl+Insert.; these shortcuts should work in all versions of Excel. You can also right-click the selection and choose Copy from the Context menu. In Excel 2007 you can also display the Home tab of the ribbon and click Copy in the Clipboard group. In older versions of Excel you can choose Copy from the Edit menu or click on the Copy tool on the toolbar.

Once you have done one of these, you can use the Paste or Paste Special commands to place your information elsewhere. Pasting functions the same as in other Windows programs; it places the contents of the Clipboard at the current cursor location. In the case of Excel, the information is placed in your worksheet beginning with the currently selected cell. You can paste the Clipboard contents by choosing Paste from the Edit menu, pressing Ctrl+V, right-clicking a cell and choosing Paste from the Context menu, clicking the Paste tool on the Home tab of the ribbon (Excel 2007), choosing Paste from the Edit menu (older versions of Excel), or clicking the Paste tool on the toolbar (older versions of Excel).

Paste Special

Within Excel there is another pasting option available. This option, called Paste Special, is rather unique. It allows you to specify how Excel should paste the information in the Clipboard. When you choose it, you will see the Paste Special dialog box. The settings in the dialog box control which portion of the information in the Clipboard you want pasted, as well as what operations you want taken on the information being pasted.

To display the dialog box in Excel 2007, display the Home tab of the ribbon, click the down-arrow under the Paste tool, then choose Paste Special. In older versions of Excel choose Paste Special from the Edit menu.

Note:

Whoops

Jokes

Clown

Guess What!

When the store manager returned from lunch, he noticed his clerk's hand was bandaged, but before he could ask about the bandage, the clerk had some very good news for him.

"Guess what, sir?" the clerk said. "I finally sold that terrible, ugly suit we've had so long!"

"Do you mean that repulsive pink and blue double-breasted thing?" the manager asked.

"That's the one!"

That's great!" the manager cried, "I thought we'd never get rid of that monstrosity! That had to be the ugliest suit we've ever had! But tell me... why is your hand bandaged?"

"Oh," the clerk replied, "after I sold the guy that suit, his guide dog bit me."

It's a bit on the nose

An old couple were sitting in Church and the wife noticed that people were staring at her.

She leaned across to her husband and whispered, "I've just let go a silent one and it's a bit on the nose. What do you think I should do?"

He said, "I think you should get fresh batteries for your hearing aid."

Good bye, Mum - A tearjerker

A young man shopping in a supermarket noticed a little old lady following him around. If he stopped, she stopped. Furthermore she kept staring at him.

She finally overtook him at the checkout, and she turned to him and said, "I hope I haven't made you feel ill at ease; it's just that you look so much like my late son."

He answered, "That's okay."

"I know it's silly, but if you'd call out 'Good bye, Mum' as I leave the store, it would make me feel so happy."

She then went through the checkout, and as she was on her way out of the store, the man called out, "Goodbye, Mum."

The little old lady waved and smiled back at him.

Pleased that he had brought a little sunshine into someone's day, he went to pay for his groceries.

"That comes to $121.85," said the clerk.

"How come so much? I only bought 5 items."

The clerk replied, "Yeah, but your Mother said you'd be paying for her things, too."

Until next month

Office, Excel and Windows logos are the property of Microsoft and are used for reference points only.