| Templates | Virus Info | White Pages | Yellow Pages | Web Search |  

Survey

Please note that there is no new survey this month.

Feed back and submissions

Want to submit and article or a joke - the e-mail address is webmaster@am-win.com.au We appreciate your feedback and submissions so send them in and those published will win a link to your website.

AM-Win Support Solutions

Remember - All of the AM-Win support solutions published in the newsletter are added to our knowledgebase library. To access the library simply login to our website.

Bank reconciliation - Backpost old unpresented entries into the previous financial year records

Open your bank reconciliation screen and choose Bank/Maintenance and the Bank accounts screen will open.

Select the bank account that you wish to change (eg: ANZ CBA) so it is highlighted in blue as above.

Click on the Change Button.You will then be able to click in the start date and change the start date to whatever financial year you need (eg; 1/7/2006).

Then Click on OK and Exit.

Open the menu of Bank/Bank Reconciliation and the Bank reconciliation screen will open.

Select the bank account you need (eg ANZ CBA), then select the "from" date as being 1st July in whatever financial year you set the Start date in the Bank Maintenance screen and the until date to 30 June in whatever financial year you set the Start date in the Bank Maintenance screen.

Then set the presented date to 1 July in whatever financial year you set the Start date in the Bank Maintenance screen and then click and drag ONLY THE RELEVANT ENTRIES THAT RELATE TO THAT FINANCIAL YEAR across to the presented side.

Then we need to go into the Bank/Maintenance menu just one more time to change the Start date on the bank account back to the current financial year; ie 1/7/08. Click on Ok and Exit. You should then only have in the bank reconciliation screen entries for this financial year and any currently un-presented transactions for this and previous years.

The balances should now all be correct!

How to update your Payroll Tax Table Coefficients for 2008/9

The Australian Tax Office has issued new tax scales that are effective as of 1 July 2008.

This document shows you how to update your tax scales in the AM﷓WIN wage system and provides the appropriate entries in the wage entry fields.

To update your tax scales with the new Payroll Tax Table Coefficients 2008/9, open your Ledger menu/Employee/Wage System/Wage Entry.

The following screen appears.

Click on the "sho tax" button as shown below.

The Tax Structure Scale window appears.

Edit the tax tables so that your figures are the same as in the above image.

Don't forget to save your changes

Then click on the close button and you're done!

Windows Tips

Remember - All of the Windows, MSWord and Excel  tips published in the newsletter are added to our knowledgebase library. To access the library simply login to our website.

Windows

UPS Scam e-mail contains a virus and a Trojan

This month we are going to look at a very clever scam designed to trick you into installing a virus on to your computer. The virus when installed will then send out the scam e-mail to users in your address book and cause problems to your operating system.

The trojans and viruses are contained in a zip or archived file which is not yet being detected by many of the major virus detection programs

The scam is known as the UPS virus. It arrives in purporting to be from UPS regarding a package that can’t be delivered due to an incorrect recipients address. The e-mail is a new variant of a trojan trying to get your attention and to infect your computer.

The messages contains the text:

Unfortunately we were not able to deliver postal package you sent on July the 1st in time because the recipients address is not correct.
Please print out the invoice copy attached and collect the package at our office
Your UPS

The messages includes an attachment ups_invoice.zip which extracts the ups_invoice.exe file. This file contains a trojan known as W32/Agent.HFN by F-Prot.

Windows will probably warn you about opening the attachment - this is a good time to heed the warning and decide not to proceed.

Let's look at what happens when you open the the attached zip file

Those in the know will recognise the problem immediately but the vast majority will not realise what is going to happen if they proceed.

The file inside the zip attachment is an "Application" file which is the type of program that installs or runs something on your computer. If we opened a zip file from a sender we would expect to find a PDF, image [jpg] or document file but never an application [exe] file.

Clicking on this file will run the application which in turn will install the trojan and virus on to your computer.

Note: If you have installed this virus [and don't feel bad if you have - it's a cunning and very cleverly designed scam] please call your computer consultant to remove the trojan and virus to have it removed. Obviously the designers don't include an uninstall program with their application.

MS Word

A common task in formatting is to indent paragraphs. Word provides several different ways you can make the desired indents.

You can pick the method that you find easiest, or you can use them all — it’s up to you! (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

If you want to quickly indent a paragraph from the left margin, you can do so by any of these means:

Click on the Increase indent button on the Formatting toolbar. This moves the left margin to the position of the next tab stop.

Press Ctrl+M. Each time you press it, the left margin is moved to the position of the next tab stop.

Use the mouse to drag the indent markers on the Ruler. Release the mouse button where you want the paragraph indented.

Use the Paragraph dialog box by choosing Paragraph from the Format menu and then making sure the Indents and Spacing tab is selected. You can then precisely set the indent in the Left field.

This final method of setting the indent is the most precise, and is also a great way to precisely indent a paragraph from the right margin. If you want to do this, simply enter the desired indent in the Right field.

You can double-indent a paragraph by entering values in both the Left and Right fields.

Excel

Tying a Hyperlink to a Specific Cell

Make a hyperlink to a cell in your workbook, edit the structure of that workbook a bit, and you may find that the hyperlink no longer targets the original cell you intended. Here’s how to make sure that the link always stays associated with the desired cell, regardless of the editing you do. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

You've created a hyperlink between two worksheets by using copy and paste hyperlink command (the hyperlink targets a specific cell).

You now insert some rows on the target worksheet that caused the target cell to move down a bit. Even though the target cell moves down, the hyperlink continues to reference the old cell location. How do you make sure that the hyperlink always targets the cell he intended when creating the link

In Excel, hyperlink addresses are essentially text that references a cell.  Formulas in Excel link to cell references which adjust when changes in the worksheet structure are made (inserting and deleting rows and columns, etc.). Hyperlink addresses, being text instead of cell references, will not adjust with such changes.

The solution is to create a named range that refers to the target cell you want used in the hyperlink. (You do this by choosing Insert | Name | Define or, in Excel 2007, display the Formulas tab of the ribbon and then click on Define Name in the Defined Names group.)

When you create your hyperlink, you can then reference this named range in the Insert Hyperlink dialog box.

At the left of the dialog box, click Place In This Document.

You'll then see a list of named ranges in your workbook and you can choose which one you want to be associated with this hyperlink.

In this way, you allow Excel to take care of translating between the name and the address for that name, which means that the hyperlink will always point to the cell you want it to point to.

Whoops

Jokes

Haul me off to jail

A Cop pulled a car over for speeding.
 
When the Cop asked the driver why he was traveling 95mph, the driver answered that he was a juggler on his way to do a show for a birthday party and didn't want to be late.

The Cop told the driver he was fascinated by juggling, and if the driver would do a little juggling for him that he wouldn't give him a ticket.

The driver told the Cop that he had sent all of his equipment on ahead and didn't have anything to juggle.

The Cop told him that he had some flares in the trunk of his patrol car, and asked if he could juggle them.

The juggler stated that he could, so the Cop got three flares, lit them and handed them to the juggler.

While the man was doing his juggling act, a car pulled in behind the patrol car.

A drunk got out, watched the performance briefly, went over to the patrol car, opened the rear door and got in.

The Cop observed him doing this, and went over to the patrol car, opened the door and asked the drunk what he thought he was doing.

The drunk replied, "You might as well haul me off to jail, cause there's NO way I’ll pass that test."

Paddy's Hands

The following yarn has been sent to us by our regular contributor Carolyn Vidler at Seaside Automotive in South Australia.  Sorry Carolyn we had to change it a bit so we could publish it but the story's still the same. Carolyn wins a link to the Seaside Automotive website - Click here to visit.

Paddy was working at the fish plant in Cork when he accidentally cut off his hands.

He went to the emergency room in Cork 's hospital.

The doctor looked at Paddy and said, 'Lets be avin' da hands and I'll see what oi can do'.

Paddy said, 'Oi haven't got da hands.'

'Whadda ya mean you haven't got da hands? Paddy it's 2008! We got microsurgery and all kinds of incredible techniques. I could have put dem back on and made you like new!

Why didn't ya bring da hands?!?'

And Paddy said, ' How was I 'spose to pick dem up?'

A woman was having a passionate affair with an inspector from a pest-control company. One afternoon they were carrying on in the bedroom together when her husband arrived home unexpectedly.

"Quick," said the woman to the lover, "into the closet!" and she pushed him in the closet, stark naked.

The husband, however, became suspicious and after a search of the bedroom discovered the man in the closet.

"Who are you?" he asked him.

"I'm an inspector from Bugs-B-Gone," said the exterminator.

"What are you doing in there?" the husband asked.

"I'm investigating a complaint about an infestation of moths," the man replied.

"And where are your clothes?" asked the husband.

The man looked down at himself and said, "Those little b@%**ds!"

Until next month