Survey

Please note that there is no new survey this month.

Latest version information

No change - V7.618 is now on the web to upgrade users who are currently on version 7.611 or later.  This version can be downloaded from our downloads page. 

Note:

You must be using version 7.611 or later to use this upgrade.  If you are using versions prior to version 7.611 you should contact national support or your local supporting consultant to arrange an update to the latest version.

AM-Win Support Solutions

How to use stock multipliers by group

This function is used to set prices (such as the retail and trade price) of parts as a function of the Cost price.

Open the Stock menu in AM-WIN and choose Multipliers by Group. The Price Group Multiplier window will appear.

To Insert a Price Group, left click the Insert button and search and choose from the list of groups which will appear, and left click the Select button.


Then choose to set up the Multiplier either by Cost Ex, Cost Inc or List either by clicking on the options across the top, or by using the drop down menus under the Set Multiplier On Column.

If you have no groups in the list, you will have to insert a new group using the Others, Maintenance, Group and All Group menu options. Then insert a Price Group item type from here.

Once a group has been selected from the Select Group list, the highlighted group will appear in the Multiplier window. Then choose to set up the Multiplier either by Cost Ex, Cost Inc or List either by clicking on the options across the top, or by using the drop down menus under the Set Multiplier On Column.

You may now either type in how much you want to multiply the Cost price by, for each of the different prices OR you may use the arrows next to each Times field to choose how much the cost price is multiplied by.

Then Left click the Save button and when this is done, this group will be added to the list on the left hand side.

Then to select this Multiplier Price Group, click on the Select Button down the bottom of the screen and an update cost multiplier will be run in the stock master file to change the pricing as per the setting. Click on Process Button to confirm the change to the pricing.

Select Button – This button allows you to select a group of stock to be re-priced according to the multiplier settings. Select the stock group and then click the select button. If you then click on the process button the system will update all of the existing stock items according to the multiplier settings.

You may change these settings by highlighting the group you want to change, then making the changes, and then pressing the Save button.

To delete the group from Multipliers, highlight the group and click the Delete button.

NOTE: If you delete a group from Multipliers, the group will still exist in AM-WIN.  However, you will now have to manually type in the retail, trade etc prices. When you delete a group, this will only affect any new stock and doesn’t change the old stock. The stock in this group whose prices used Multipliers previously, will remain the same.

When you insert a group, all the previous stock and prices which weren’t affected by multipliers, will remain the same. Only new stock in this group will be affected by the multiplier prices from this point on.

Once the multiplier has been set, prices will be automatically inserted. So, in Stock Master files, once you have selected a Group (in the group field under the Bin field), and entered in a cost price, all the Selling Prices fields will be automatically be filled in. These prices may be changed, without changing the multiplier values, simply by typing another price into the field.

How to use price change by group

Price change by Group enables you to change prices in a group as a function of another price. This feature allows you to change stock which is presently in your records (unlike the Multipliers section where the changes only affect any new stock).

Go to the Stock menu in AM-WIN and choose Price Change by Multipliers. The Price Increase by Multipliers window appears.

Left click on the button next to the Stock Group field to select which group prices you wish to change. If you want to change ALL group prices, then leave this field blank.

If you have no groups in the list, you will have to insert a new group using the Others, Maintenance, Group and All Group menu options. Then insert a Stock item type from here.

Then Browse the Select Stock Group File and Select the group you want, and left click the Select button.

Left click on the down arrow next to the Calculate Prices on field. This will bring up a menu.

Choose one of the options from the menu, depending on which option you want the stock prices to be a function for. For example, if you want the retail, trade etc prices, to all be three times the List (recommended) price, then choose List price.

Use the up and down arrows next to each Multiplied By field to choose how much you want to multiply the price you chose in the previous Step for that particular price.

Once all fields have been filled in, left click the Process button to save these changes, or press Enter. This will save changes and clear the fields for you to choose another group’s prices to change.

You can select multiple groups to be re-priced by selecting groups one after the other. If you accidentally select the wrong group you can deselect it by clicking on the Deselect button at the bottom of the screen.

Left click the Clear button to clear the fields, without saving any changes.
Left click the Close button to close the window.

Windows, Word and Excel Tips

Windows

Mouse Browsing

Open up your browser, follow a few links, and then hold the Shift key and spin the wheel

You'll go forward or back a page depending on which way you spun the wheel! How cool is that?

Google Images Search Options

Are you looking for just the right photo or piece of clip art for your Power Point presentation, brochure or document

Google Image has announced more improved features.

For those who don't know about Google Image here's a quick overview.

Google not only searches for content [among many other things] but searches for images as well.

Here's how. Open your Google Search and run a search for "tired man"

Google will return search results.

Ignore the Google search results because you are not looking for content related results. Instead turn your attention to the top left hand side of the results page and you will see the word "images" in blue. Click the images link and you will now see all of the image search results for your search "tired man".

Google will return search results for all images relating to "tired man" that it can find. These results will include all types of images including photos relating to your search words.

Let's say that you're not interested in photos for your project - what you do want is a nice funny piece of clip art

You will now be presented with a variety of options catagorised into size, colour and type. The colour will show you images who's colour is predominantly that selected and the size options are self explanatory. We will concentrate on the "type" here.

Select Type - Clipart at this time

You will now see only a selection of clip art images that match your search criteria. [See image below]. 

Have a look at the results to see if there's something suitable for your project. Good luck and don't forget to honour the image owner's copyright.

MS Word

Shrink to fit

Have an MS Word document that is just a bit too long? A few lines stuck on that last page? Wish you could "shrink" the document a bit and lose that last page?

You could try a different font size. Or adjusting the content up and down to find the exact change that will remove the need for the unwanted last page.

Save yourself time and get Word to do it for you.

The Word feature we're looking for is "Shrink to Fit" and it's found in the Print Preview.

Readers using older versions of Word can either go to the File menu, Print Preview choice or use the Print Preview button located on the Standard toolbar.

Those of you using Word 2007 you'll find Print Preview in the Office Button in the list of options offered by the Print choice.

Once in the Print Preview, you're looking for the Shrink to Fit button.

In older versions of Word it looks like this:

People with Word 2007 will see the following

Click shrink to fit

Instantly, Word shrinks your document's font size to reduce the number of pages by one.

(At times, you may receive an error message telling me that Word couldn't make the change. If you saved the document as is and then tried again, it would complete the shrink).

Right click hyperlinks

When you're trying to move, copy or otherwise manipulate text in MS Word do you find yourself frustrated with all the steps involved?

Many people choose to highlight the text then cut or copy the text move the cursor to the new location and paste.

That's a lot of work for something that can be done with one smooth move of the mouse.

We'll still need to select (highlight) the text that we need to work with.

With the text still selected click and hold the right mouse button.

Now drag the mouse pointer to the new location.

Release the mouse button.

A list of choices like this will pop open, you just need to choose one.

Move Here and Copy Here are self-explanatory.

Link Here will copy the text to the new location but it will be linked to the original text. Basically what this gives you is the ability to edit the original text and have those updates automatically take effect in the linked text. One update = many changes.

And there's another choice that may be useful. Create Hyperlink Here". This option would copy the text to the new location and then set it as a hyperlink. Not a bad idea for long documents with a table of contents or just as a way to allow people using the document electronically to navigate to specific locations.

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

Sort all the data in a table

Need to sort all the data in a table? Here's the fastest and easiest way to do it. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel allows you to sort list data both quickly and easily. You can sort your data by row using the contents of any column you want. In database terminology, this column (or field) is called the sort key. In Excel it is referred to as the Sort By column.

To sort an entire list quickly, start by selecting a cell within the column you want used as the Sort By column. Then, click on the Sort Ascending tool or Sort Descending tool, depending on what you want to do. (In versions of Excel prior to Excel 2007 these tools are on the toolbar. In Excel 2007 they are in the Sort & Filter group on the Data tab of the ribbon.) For instance, if you want to sort an inventory list by its Quantity field, all you need to do is select a cell in the Quantity column, and then click on Sort Ascending.

You should know that if your worksheet contains hidden rows, they are not affected when you sort by rows. If you have hidden columns, they are not affected when you sort by columns. After the sort, they will remain in the same position as before the sort.

3D Cells

The formatting capabilities provided by Excel are quite diverse. This tip examines how you can use those capabilities to make the contents of a particular cell "pop" off the page. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

If you want the formatting of a cell to "stand out" from the surrounding cells? It's rather easy to do, once you understand how to create the illusion of three dimensions. Follow these steps:

1.Select the cell that you want to format.
2.Right-click on the selected cell and choose Format Cells. Excel displays the Format Cells dialog box.
3.Make sure the Fill tab (Excel 2007) or the Patterns tab (previous versions) is selected.

4.From the colors available, pick the lightest gray color you can see. This forms the background for the cell.
5.Display the Border tab.

6.In the Style list of the Line area, click on the second-widest solid line.
7.Make sure the Color drop-down is set to either Automatic or Black. (In most cases, these two settings result in a black color, which is what you want.)
8.In the Border area, click the buttons for both the right border and the bottom border. (You could also click on the actual border locations in the preview area, if desired.)
9.Using the Color drop-down, choose White. It will look like all the line styles disappeared, but don't worry—they are still there, and the second-thickest line style should still be selected.
10.Click the buttons for both the left border and the top border. (Again, you could also click on the border locations in the preview area.) You shouldn't see anything in the preview area, since white-on-white doesn't show up well. However, the buttons for the left and top borders should show as selected.
11.Click OK.
The cell you selected in step 1 should now look as if it is "raised" off the worksheet around it. You can accentuate the effect even more if you apply a background color to the cells that surround the one that you want to look raised.

Show Date Last Saved

When printing out a worksheet, you may want Excel to include, in the footer, the date the data was last saved. There is no easy way to include that information without using a macro. Here's how you can get the output you need. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

If you are familiar with Word, you know that it includes a rich set of fields that are used to place dynamic information in a document. One of the things that can be placed in a document is the date that a file was last saved. It would be nice if such a capability were built into Excel, but such is not the case. Excel has no "fields," and it has no way to put dynamic information of this type into headers or footers.

There is a way around this limitation, but the solution requires the use of a macro. The reason is because you are accessing system information—information outside of Excel itself—and that information can only be retrieved using a programming language such as VBA. One approach is to add some code that runs whenever a workbook is saved. The code would update the desired header or footer with the current date.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
Dim sht As Worksheet

For Each sht In Sheets
sht.PageSetup.CenterFooter = _
"Last Saved: " & Format(Date, "mmmm d, yyyy")
Next
End Sub

This macro, which should be stored in the ThisWorkbook object for the workbook you want to affect, steps through each worksheet in the workbook and changes the center portion of the footer. If today is September 12, 2009, then after running, the center footers will all be set to "Last Saved: September 12, 2009". Notice that the name of the macro (Workbook_BeforeSave) indicates that the macro will be run just before the workbook is actually saved.

There is another approach you can use. This one involves requesting from Windows the actual date and time a file was saved.

Private Sub Workbook_Open()
Dim sTemp As String
Dim sht As Worksheet

sTemp = FileDateTime(ActiveWorkbook.FullName)
sTemp = "Last Saved: " & sTemp
For Each sht In Sheets
sht.PageSetup.RightFooter = sTemp
Next sht
End Sub

This macro is designed to run whenever a workbook is first opened—it is saved as the Workbook_Open procedure of the ThisWorkbook object. The workhorse of the macro is the line that calls the FileDateTime function. This function can be used to determine the date and time any file was saved. It requires a full path name of a file, which is supplied by the FullName property of the ActiveWorkbook object. This date and time is then, in this case, placed in the right footer of all the worksheets in the workbook.

Note:

Feel free to copy and paste these Macro codes. You need to remember that there is web page formatting code embedded in the macro shown above. To remove the embedded code cut the macro from this page and paste it into Notepad.  Notepad does not allow text formatting and will remove the web code. Now paste the macro from Notepad to Excel.

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.

Whoops

Can't view the video - right click here to save it

Jokes

"That was incredible!" she said.

A very rich man met a beautiful lady and he decided he wanted to marry her right away. She said, "But we don't know anything about each other."

He said,"That's all right, we'll learn about each other as we go along." So she consented, and they were married, and went on a honeymoon to a very nice resort.

So one morning they were lying by the pool, when he got up off of his towel, climbed up to the 10-metre board and did a two and a half tuck gainer, this followed by a three rotations in jack knife position, where he straightened out and cut the water like a knife. After a few more demonstrations, he came back and lay down on the towel.

"That was incredible!" she said.

"I used to be an Olympic diving champion. You see, I told you we'd learn more about ourselves as we went along."
So she got up, jumped in the pool, and started doing laps. After about thirty laps she climbed back out and lay down on her towel hardly out of breath.

"That was incredible!" he said. "Were you an Olympic endurance swimmer?"

"No," she said, "I was a call girl in Venice and I worked both sides of the canal."

Everything is golden

One night, a man comes home a wee bit drunk and his wife questions his whereabouts...

Wife: "Where were you??"
 
Man: "I was at this new bar called the Golden Bar. Everything is golden"

Wife: "Sure you were. There's no such place!"

Man: "There is! They have huge golden doors, a golden floors, and even golden urinals!"

Wife: "Oh, I BELIEVE you 100%"

So, the next day the wife looks through the phone book for this golden bar. She's surprised when she finds a Golden Bar located across town. She decides to call up and check this out for herself...

Wife: "Is this the Golden Bar?" Bartender: "Yes it is.." Wife: "Do you have huge golden doors?" Bartender: "Yes we do..."

Wife: "Do you have golden floors??" Bartender: "We have them, too..."

Wife: "What about golden urinals?"

Bartender (speaking away from phone): "Hey Max, I think we have a lead on that drunk who peed in your saxophone.

I want it with all the options

Several men are in the locker room of a golf club.

A cell phone on a bench close by begins to ring with a deafening and highly irritating Rap Tune. Someone screams, "Turn that thing off before I throw it in the shower room!"

The man nearest to the phone reaches over. He engages the hands-free speaker-function and begins to talk. Everyone else in the room stops to listen.

MAN: "Hello?"

WOMAN: "Honey, it's me. Are you at the club?"

MAN: "Yes, I am."

WOMAN: "I am at the mall now and found this beautiful leather coat. It's only $1,000. Is it OK if I buy it?"

MAN: "Sure, go ahead if you like it that much."

WOMAN: "I also stopped by the Mercedes dealership and saw the new models for next year. I saw one I really liked."

MAN: "How much?"

WOMAN: "$60,000"

MAN: "OK, but for that price I want it with all the options."

WOMAN: "Great! Oh, and one more thing... The house we wanted last year is back on the market. They've come down $10,000 and now they are asking $950,000. What do you think, should we make them an offer?"

MAN: "Absolutely. Go ahead and give them an offer, but just offer $940,000 so they will know we are serious buyers."

WOMAN: "OK, Honey! Now you're talking! I can't wait to see you later! Look for me upstairs and don't be long! I love you so much!"

MAN: "Bye, I love you, too."

The man hangs up. The other men in the locker room are looking at him in astonishment.

Then the man smiles and asks: "Anyone know who owns this phone.?"

Until next month

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