| Understanding the Standard Receipt | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
How to customize the Retail Point of Sale standard receipt within GP Report Writer: What are Legends?
|
7/28/09
Using Dynamics GP Report Writer with the POS Standard Receipt
Can I configure POS to disallow a user to sell an item below the quantity available?
Dex.ini switch
Yes, you can--but only for users that have not been granted POS Manager Access. There's a Dex.ini switch available for this. Go to your Dex.ini file (typically located at the root of your Dynamics GP folder) and add the following line:
CompassPreventOverSell=TRUE.
Adding this line will prevent a non-manager user from tabbing past the quantity field on line items where the quantity sold is greater than the quantity available.
How to establish multiple dex.ini environments in Citrix or Terminal Services environment for GP.
| Create Multiple dex.ini for users logging into a Citrix or Terminal Services environment. |
| 1. On the Terminal Services or Citrix server create multiple dex.ini an place them in separate folders on the hard drive. 2. For each user's profile create a dynamics.exe shortcut with a target that points to their specific dex.ini. The target line in the shortcut should look something like this. C:\GP10\Dynamics.exe Dynamics.set C:\windows\dex.ini 3. When a user logs in under their profile they will use their specific shortcut to login to Dynamics GP. |
Are there any Retail Point of Sale features controlled by Dex.ini settings?
Question: Are there any Retail Point of Sale features controlled by Dex.ini settings?
Answer: Yes. The following is a list of Dex.ini switches that affect POS.
EditSalesperson=TRUE (makes the salesperson ID field editable in the Line Details window).
POSManualPromotions=TRUE (does not search for and apply promos automatically. Clerk must manually enter promotion ID).
CompassUseCustomerLookup=TRUE (the Great Plains customer lookup will open rather than the default POS mailist lookup window (new in version 8)).
CompassPreventOverSell=TRUE (Adding this line will prevent a non-POS-manager user from tabbing past the quantity field on line items where the quantity sold is greater than the quantity available).
NoPrintDialogs=TRUE (this will prohibit the print dialog from opening each time a receipt or report is submitted for printing. Stopping the print dialog expedites transaction processing, but once set, doesn't give the user a choice of where to print.)
7/27/09
Create Table Query and More Hidden Access SQL Queries
When I first tried to create tables automatically in Access a couple of years ago, I fell back on my SQL background and went hunting for the Create Table command. But I didn't find it in the help and resorted to using more manual methods. When I was asked this question late last year, I had another look and found that all the SQL table management commands were actually supported. These commands are as follows
Create Table
Create Index
Alter Table
Constraint
Drop table
To find this elusive help, Open Access and under help select Contents and Index. Type CREATE in uppercase in the find box. An example of a create table command is as follows
CREATE TABLE AAA (ProductName Text, ProductDate Date);
To demonstrate how to run these in Access I have set up a form called FX_CreateTable in the demonstration database. This code shows how to build a table using the usual techniques that I employ for other SQL building software. As these table changing SQL statements are action statements, you can use the RunSql command.
sqlStr = "CREATE TABLE " & Me!tableName & _
" (" & Me!fieldName1 & " " & Me!FieldType1 & ", " _
& Me!fieldName2 & " " & Me!FieldType2 & ");"
DoCmd.RunSQL sqlStr
To add a new column to an existing table, I would make and run the following SQL statement
Alter TABLE AAA ADD COLUMN ProductQuantity Single;
Note that these table related commands will only work on jet databases but the syntax is pretty similar to the kind of commands that you would deploy in a SQL server/Oracle type environment.
Want to find more data types that you can use, try Access Find Help and type in "Comparison of Data Types". This will help you find things such as autocounters etc.
Now Here is what the Access 97 help tells you because this is impossible to find in the Access 2000+ help
Create Table Statement
Creates a new table.
Note The Microsoft Jet database engine doesn't support the use of CREATE TABLE, or any of the DDL statements, with non-Microsoft Jet database engine databases. Use the DAO Create methods instead.
Syntax
CREATE TABLE table (field1 type [(size)] [NOT NULL] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])
The CREATE TABLE statement has these parts:
Part Description
table The name of the table to be created.
field1, field2 The name of field or fields to be created in the new table. You must create at least one field.
type The data type of field in the new table.
size The field size in characters (Text and Binary fields only).
index1, index2 A CONSTRAINT clause defining a single-field index. See the CONSTRAINT clause topic for more information on how to create this index.
multifieldindex A CONSTRAINT clause defining a multiple-field index. See the CONSTRAINT clause topic for more information on how to create this index.
Remarks
Use the CREATE TABLE statement to define a new table and its fields and field constraints. If NOT NULL is specified for a field, then new records are required to have valid data in that field.
A CONSTRAINT clause establishes various restrictions on a field, and can be used to establish the primary key. You can also use the CREATE INDEX statement to create a primary key or additional indexes on existing tables.
You can use NOT NULL on a single field, or within a named CONSTRAINT clause that applies to either a single field or to a multiple-field named CONSTRAINT. However, you can apply the NOT NULL restriction only once to a field, or a run-time error occurs.
Alter Table Statement
Modifies the design of a table after it has been created with the CREATE TABLE statement.
Note The Microsoft Jet database engine doesn't support the use of ALTER TABLE, or any of the data definition language (DDL) statements, with non-Microsoft Jet databases. Use the DAO Create methods instead.
Syntax
ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL] [CONSTRAINT index] CONSTRAINT multifieldindex} DROP {COLUMN field I CONSTRAINT indexname} }
The ALTER TABLE statement has these parts:
Part Description
table The name of the table to be altered.
field The name of the field to be added to or deleted from table.
type The data type of field. Try ( BINARY, Boolean, Byte, Long, Currency, Date, Double, Long, LONGBINARY, LONGTEXT, SINGLE, Integer, TEXT, LONGTEXT)
size The field size in characters (Text and Binary fields only).
index The index for field. See the CONSTRAINT clause topic for more information on how to construct this index.
multifieldindex The definition of a multiple-field index to be added to table. See the CONSTRAINT clause topic for more information on how to construct this clause.
indexname The name of the multiple-field index to be removed.
Remarks
Using the ALTER TABLE statement, you can alter an existing table in several ways. You can:
· Use ADD COLUMN to add a new field to the table. You specify the field name, data type, and (for Text and Binary fields) an optional size. For example, the following statement adds a 25-character Text field called Notes to the Employees table:
ALTER TABLE Employees ADD COLUMN Notes TEXT(25)
You can also define an index on that field. For more information on single-field indexes, see the CONSTRAINT clause topic.
If you specify NOT NULL for a field, then new records are required to have valid data in that field.
· Use ADD CONSTRAINT to add a multiple-field index. For more information on multiple-field indexes, see the CONSTRAINT clause topic.
· Use DROP COLUMN to delete a field. You specify only the name of the field.
· Use DROP CONSTRAINT to delete a multiple-field index. You specify only the index name following the CONSTRAINT reserved word.
Notes
· You can't add or delete more than one field or index at a time.
· You can use the CREATE INDEX statement to add a single- or multiple-field index to a table, and you can use ALTER TABLE or the DROP statement to delete an index created with ALTER TABLE or CREATE INDEX.
· You can use NOT NULL on a single field, or within a named CONSTRAINT clause that applies to either a single field or to a multiple-field named CONSTRAINT. However, you can apply the NOT NULL restriction only once to a field, or a run-time error occurs.
Create Index statement
Creates a new index on an existing table.
Note For non-Microsoft Jet databases, the Microsoft Jet database engine doesn't support the use of CREATE INDEX (except to create a pseudo index on an ODBC linked table) or any of the data definition language (DDL) statements. Use the DAO Create methods instead. For more information, see the Remarks section.
Syntax
CREATE [ UNIQUE ] INDEX index ON table (field [ASCDESC][, field [ASCDESC], ...]) [WITH { PRIMARY DISALLOW NULL IGNORE NULL }]
The CREATE INDEX statement has these parts:
Part Description
index The name of the index to be created.
table The name of the existing table that will contain the index.
field The name of the field or fields to be indexed. To create a single-field index, list the field name in parentheses following the table name. To create a multiple-field index, list the name of each field to be included in the index. To create descending indexes, use the DESC reserved word; otherwise, indexes are assumed to be ascending.
Remarks
To prohibit duplicate values in the indexed field or fields of different records, use the UNIQUE reserved word.
In the optional WITH clause, you can enforce data validation rules. You can:
· Prohibit Null entries in the indexed field or fields of new records by using the DISALLOW NULL option.
· Prevent records with Null values in the indexed field or fields from being included in the index by using the IGNORE NULL option.
· Designate the indexed field or fields as the primary key by using the PRIMARY reserved word. This implies that the key is unique, so you can omit the UNIQUE reserved word.
You can use CREATE INDEX to create a pseudo index on a linked table in an ODBC data source, such as SQL Server, that does not already have an index. You don't need permission or access to the remote server to create a pseudo index, and the remote database is unaware of and unaffected by the pseudo index. You use the same syntax for both linked and native tables. This can be especially useful to create an index on a table that would ordinarily be read-only due to lack of an index.
You can also use the ALTER TABLE statement to add a single- or multiple-field index to a table, and you can use the ALTER TABLE statement or the DROP statement to remove an index created with ALTER TABLE or CREATE INDEX.
Note Don't use the PRIMARY reserved word when you create a new index on a table that already has a primary key; if you do, an error occurs.
Constraint Clause
A constraint is similar to an index, although it can also be used to establish a relationship with another table.
You use the CONSTRAINT clause in ALTER TABLE and CREATE TABLE statements to create or delete constraints. There are two types of CONSTRAINT clauses: one for creating a constraint on a single field and one for creating a constraint on more than one field.
Note The Microsoft Jet database engine doesn't support the use of CONSTRAINT, or any of the data definition language (DDL) statements, with non-Microsoft Jet databases. Use the DAO Create methods instead.
Syntax
Single-field constraint:
CONSTRAINT name {PRIMARY KEY UNIQUE NOT NULL REFERENCES foreigntable [(foreignfield1, foreignfield2)]}
Multiple-field constraint:
CONSTRAINT name {PRIMARY KEY (primary1[, primary2 [, ...]]) UNIQUE (unique1[, unique2 [, ...]]) NOT NULL (notnull1[, notnull2 [, ...]]) FOREIGN KEY (ref1[, ref2 [, ...]]) REFERENCES foreigntable [(foreignfield1 [, foreignfield2 [, ...]])]}
The CONSTRAINT clause has these parts:
Part Description
name The name of the constraint to be created.
primary1, primary2 The name of the field or fields to be designated the primary key.
unique1, unique2 The name of the field or fields to be designated as a unique key.
notnull1, notnull2 The name of the field or fields that are restricted to non-Null values.
ref1, ref2 The name of a foreign key field or fields that refer to fields in another table.
foreigntable The name of the foreign table containing the field or fields specified by foreignfield.
foreignfield1, foreignfield2 The name of the field or fields in foreigntable specified by ref1, ref2. You can omit this clause if the referenced field is the primary key of foreigntable.
Remarks
You use the syntax for a single-field constraint in the field-definition clause of an ALTER TABLE or CREATE TABLE statement immediately following the specification of the field's data type.
You use the syntax for a multiple-field constraint whenever you use the reserved word CONSTRAINT outside a field-definition clause in an ALTER TABLE or CREATE TABLE statement.
Using CONSTRAINT, you can designate a field as one of the following types of constraints:
· You can use the UNIQUE reserved word to designate a field as a unique key. This means that no two records in the table can have the same value in this field. You can constrain any field or list of fields as unique. If a multiple-field constraint is designated as a unique key, the combined values of all fields in the index must be unique, even if two or more records have the same value in just one of the fields.
· You can use the PRIMARY KEY reserved words to designate one field or set of fields in a table as a primary key. All values in the primary key must be unique and not Null, and there can be only one primary key for a table.
Note Don't set a PRIMARY KEY constraint on a table that already has a primary key; if you do, an error occurs.
· You can use the FOREIGN KEY reserved words to designate a field as a foreign key. If the foreign table's primary key consists of more than one field, you must use a multiple-field constraint definition, listing all of the referencing fields, the name of the foreign table, and the names of the referenced fields in the foreign table in the same order that the referencing fields are listed. If the referenced field or fields are the foreign table's primary key, you don't have to specify the referenced fields — by default, the database engine behaves as if the foreign table's primary key is the referenced fields.
DROP Statement
Deletes an existing table from a database or deletes an existing index from a table.
Note The Microsoft Jet database engine doesn't support the use of DROP, or any of the DDL statements, with non-Microsoft Jet databases. Use the DAO Delete method instead.
Syntax
DROP {TABLE table INDEX index ON table}
The DROP statement has these parts:
Part Description
table The name of the table to be deleted or the table from which an index is to be deleted.
index The name of the index to be deleted from table.
Remarks
You must close the table before you can delete it or remove an index from it.
You can also use ALTER TABLE to delete an index from a table.
You can use CREATE TABLE to create a table and CREATE INDEX or ALTER TABLE to create an index. To modify a table, use ALTER TABLE.
7/26/09
10 Things We Overpay For
Bottled water. Yes, it's important to drink water every day. But picking up the bottled variety with your lunch is an expensive way to stay hydrated. Rather than spend $2 a day for water, buy a pitcher and a filter for about $20 and drink as much as you want for pennies a glass.
A caffeine fix. Can't get through the day without at least one cuppa Joe? Stopping at Starbucks or Dunkin' Donuts can set you back as much as $1.65 per cup. Splurge on a pound of gourmet coffee for $8 to $13 and you can make 40 cups for about 20 cents to 33 cents each.
Favorite tunes. Do you rush out to buy the latest CD by your favorite group even though there are only one or two songs you really like? Instead of paying up to $18 for the CD, download those cuts you want from iTunes for 99 cents each, or from Amazon for as little as 79 cents.
A night at the movies. An evening for two at your local theater costs an average of about $20, including the popcorn -- and closer to $30 in major cities. And that doesn't even count the babysitter. For just $5 a month, you can watch two movies from Netflix or pay $9 for unlimited viewing. If you're willing to wait a little longer for new releases, borrow them free from your local library. (See Cut the Cable Cord for other inexpensive entertainment options.)
Fresh flowers. A bouquet of spring blooms brightens up a room and your mood. But purchasing it from a florist at $25 and up can quickly put a dent in your budget. Check out your local grocery store, which offers a selection of seasonal bouquets for $5 to $10.
Fruits and veggies. Sure, precut vegetables and salad mixes that are washed and bagged save a little time. But you'll pay for the convenience. Broccoli florets and sliced peppers cost $6 per pound, compared with one-third to one-half the price for the uncut versions. Lettuce varieties that are pre-washed and bagged sell for $5.98 a pound. But it takes just minutes to wash and spin dry enough arugula for your evening salad, and you'll pay one-third as much. Buying whole strawberries rather than sliced ones that are prepackaged cuts the price by 75%.
Credit-card fees. Every month, millions of credit-card customers pay their bills late, and they're assessed as much as $39 each time. Set up an automatic debit and you'll never incur another late fee.
ATM fees. Each time you use an out-of-network ATM you pay an average of $3.43. Do that once a week and you'll rack up almost $180 in ATM fees every year. Avoid those charges by selecting a bank with a large ATM network or an online account that reimburses your ATM fees -- such as the eOne no-fee account from Salem Five Direct bank. Another alternative: Get cash back at the grocery store.
Fax and mail services. Instead of paying FedEx $1.49 to fax one page, sign up to send free faxes from a provider such as faxZero or K7.net. Save on shipping with the U.S. Postal Service's priority mail service. You'll pay just $4.95 to mail an envelope or small box anywhere in the U.S., and your parcel is likely to arrive within two days. Larger packages cost $10.35. That saves at least 50% compared with UPS's two-day service, the cost of which varies by weight and distance.
http://content.kiplinger.com/features/archives/2009/03/10-things-we-overpay-for.html
20 Ways to Waste Your Money
How to waste your money
1. Buy new instead of used. Talk about a spending leak -- or, rather, a gush. Cars lose most of their value in the first few years, meaning thousands of dollars down the drain. However, recent used models -- those that are less than five years old -- can be a real value because you get a car that's still in fine working order for a fraction of the new-car price. And you'll pay less in collision insurance and taxes, too.
Cars aren't the only things worth buying used. Consider the savings on pre-owned books, toys, exercise equipment and furniture. (Of course, there are some things you're better off buying new, including mattresses, laptops, linens, shoes and safety equipment, such as car seats and bike helmets.)
2. Carry a credit-card balance. If you have a $1,000 balance on a card charging 18%, you blow $180 every year on interest. That's money you could certainly put to better use elsewhere. Get in the habit of paying off your balance in full each month.
3. Buy on impulse. When you buy before you think, you don't give yourself time to shop around for the best price. Resist the urge to make an impulse purchase by giving yourself a cool-off period. Go home and sleep on the decision. If you still want to make the purchase a day or so later, do your comparison shopping, check your budget and go for it. Oftentimes, though, I bet you'll decide you don't need the item after all.
4. Pay to use an ATM. A buck or two here and there may not seem like a big deal. But if you're frequenting ATMs outside your bank's network, the surcharges can add up quickly. Put that money back in your pocket by using ATMs in a surcharge-free network such as Allpoint or Money Pass.
5. Dine out frequently. A habit of spending $10, $20, $30 per person for dinner can be a huge drain on your wallet. Throw in a $6 sandwich for lunch and a $4 latte in the morning, and you've got quite a leak. Learn to cook, pack your lunch and brew your coffee at home and you could save a couple hundred bucks each month.
6. Let your money wallow. If you are stashing your savings in your checking account or a traditional bank account, you are wasting money. You could put it in a high-interest online savings account and get paid to save. You can even get an interest-bearing checking account through such reputable companies as Everbank, Charles Schwab, E*Trade and ING Direct.
7. Pay an upfront fee for a mutual fund. Selecting no-load funds can save you more than 5% in sales charges. Of course, no matter how well a fund has done in the past, you can't be sure how it will perform in the future. But if you pay a load, you'll begin the performance derby in the hole to the tune of the load. See the Kiplinger 25 for our favorite no-load funds.
8. Pay too much in taxes on investments. Are you investing in a tax-sheltered 401(k) or Roth IRA? If you're not maxing out those accounts before you invest in a taxable account, you're spending too much.
9. Buy brand-name instead of generic. From groceries to clothing to prescription drugs, you could save money by choosing the off-brand over the fancy label. And in many cases, you won't sacrifice much in quality. Clever advertising and fancy packaging don't make brand-name products better than lesser-known brands (see Similar Products, Different Prices).
10. Waste electricity. Of the total energy used to run home electronics, 40% is consumed when the appliances are turned off. Appliances with a clock or that operate by remote are typical culprits. The obvious way to pull the plug on your energy vampires is to do just that -- pull the plug. Or buy a device to do it for you, such as a Smart Power Strip ($31 to $44 at www.smarthomeusa.com, which will stop drawing electricity when the gadgets are turned off and pay for itself within a few months.
11. Pay banking fees. Overdraw your checking account and you'll pay $20 to $30 a pop, so it pays to keep tabs on your balance. Plus, are you still paying for a checking account? Free deals abound -- but make sure they're really free. For instance, will the bank charge a fee if your balance drops below a certain level or if you download your info into a personal-finance software program? That's not free.
12. Buy things you don't use. This sounds like a no-brainer to avoid, but how many times have you seen something on sale and thought you couldn't pass it up? Even if something is 50% off, you're spending too much if you don't use it. href=Couponing, for instance, can be a great way to save on your grocery bills. But if you buy things you wouldn't have purchased in the first place simply for the sake of using the coupon, you're wasting your money. The same goes for buying in bulk. A bargain is no bargain if it sits unused on your shelf or gets thrown away.
13. Own an extra car. Okay, so a car is a necessity for most people. But face it -- cars are a huge drain, from their loan payments to insurance fees to gas and maintenance costs. Own more than one car and you'll double or triple those expenses. Ask yourself if that second or third car is really necessary. Are you holding on to an old car for sentimental reasons? Can you or your spouse carpool, take public transportation or bike to work?
14. Ignore your local dollar store. Shopping at the dollar store can be hit-and-miss, but it's not all kitsch or junk. If you know what to buy, you can find some real bargains. For instance, my local dollar store charges 50 cents for greeting cards versus the $3-plus at a drug store or gift shop. (I have a big extended family so I figure this saves me more than $100 per year.) You can also score a deal on cleaning supplies, small kitchen tools, shampoos and soaps, holiday decorations, gift wrap and balloon bouquets.
15. Keep unhealthy habits. Smoking is not only bad for your health, it burns up your cash. A pack-a-day habit at $6 a pack costs $180 a month and $2,190 a year. A junk-food or tanning-bed habit can be costly as well. Not to mention the money you'll waste on medical bills down the road.
16. Be complacent about insurance. Your bill arrives and you pay it without a second thought. When was the last time you shopped around to determine whether you're getting the best deal? Rates vary widely from insurer to insurer and year to year. Reshopping your auto, home or renters insurance might save you hundreds of dollars.
It also pays to evaluate your insurance needs. For instance, upping your out-of-pocket deductible from $250 to $1,000 can save you 15% or more on your car insurance. Consider using the same insurer for your home and auto insurance -- you could snag up to 15% off for a multiple-line policy. And make sure you're not paying for insurance you don't need. For instance, you need life insurance only if someone is financially dependent upon you (such as a child).
17. Give Uncle Sam an interest-free loan. If you get a tax refund each April, you let the government take too much money in taxes from your paycheck all year long. Get that money back in your pocket -- and put it to work for you -- by adjusting your tax withholding. With a little discipline, you can use that extra cash each month to get started saving or pay down debt (or make ends meet to avoid going into debt in the first place). You can file a new Form W-4 with your employer at any time.
18. Pay for something you can get for free. Dust off your library card and check out books, music and movies for free (or dirt-cheap). Don't pay to receive your credit report when you're allowed to get it at no charge by law. Take advantage of kids-eat-free promotions. And dial 1-800-FREE-411 for free directory assistance.
19. Don't use a flexible-spending account. Your employer may allow you to set aside pretax dollars to pay for medical costs not covered by insurance. You can use the money for expenses such as therapy, contact lenses, insurance co-payments and over-the-counter drugs. You may be able to do the same for child-care costs.
20. Pay for unnecessary services. How many cable channels can a person watch? Do you really need all those extra features for your cell phone? Are you getting your money's worth out of that gym membership? Are you taking full advantage of your subscriptions (such as Netflix, TiVo or magazines)? Take a look at what you're paying for and what your family is actually using. Trim accordingly.
7/23/09
Terminal Services Shortcut Keys
Useful Client Shortcut Keys
| Key combination | Function | Similar local keys |
|---|---|---|
| CTRL+ALT+END | Opens the Windows Security dialog box | CTRL+ALT+DELETE |
| CTRL+ALT+BREAK | Toggles the Terminal Services client display from window to full screen | |
| ALT+INSERT | Cycles through running programs on the remote computer | ALT+TAB |
| ALT+HOME | Displays the remote computer's Start menu | |
| ALT+DELETE | Displays the remote window's Control menu | ALT+SPACE BAR |
You can take screenshots with these shortcuts:
| Key combination | Function | Similar local keys |
|---|---|---|
| CTRL+ALT+NUMBER PAD MINUS | Places an image of active window onto the TS clipboard | ALT+PRINT SCREEN |
| CTRL+ALT+NUMBER PAD PLUS | Places an image of the entire Terminal Services client on the Terminal Services clipboard |
7/21/09
Use VBA to change printer
Set Application.Printer = Nothing
OTHER PRINTER
Set Application.Printer =Application.Printers.Item("PRINTER NAME HERE")
7/19/09
The Fundamentals of Firearm Safety
I. The Fundamentals of Firearm Safety
The three basic general rules of safe gun handling.
- Always point the muzzle in a safe direction; never point a firearm at anyone or anything you don't want to shoot.
- Keep your finger off the trigger and outside the trigger guard until you are ready to shoot.
- Keep the action open and the gun unloaded until you are ready to use it.
II. Additional specific rules of safe gun handling
Safety Rules Related to the Shooter and His Behavior.
- Treat every firearm as if it were loaded.
- Never pass a firearm to another person, or accept a firearm from another person, until the cylinder or action is open and you've personally checked that the weapon is completely unloaded.
- Before handling any firearm, understand its operation.
- Never rely on any mechanical device for safety.
- Think before shooting: once you pull the trigger you can't take back the shot you've just fired!
- Never joke around or engage in horseplay while handling or using firearms.
- Be alert at all times; never shoot if you're tired, cold or impaired in any way. Don't mix alcohol or drugs with shooting.
- Don't sleep with a loaded firearm in your bedroom if you sleepwalk, have nightmares, sleep restlessly or have other sleep problems.
- Safeguard your sight, hearing and health. Always wear eye and ear protection. Endeavor to limit your exposure to heavy metal particulates and gases, and minimize your contact with aromatic organic solvents (such as those commonly used in gun cleaning products).
- If you see unsafe behavior any time when firearms are being handled or used, speak up and take action to correct the unsafe behavior at once.
- Receive competent instruction from a qualified person before beginning to shoot. If questions arise later, after you've been shooting for a period of time, get answers to those questions from a competent authority.
Safety Rules Related to Your Target.
- Positively identify your target and the threat it poses before firing at it.
- What's behind your target? Always make sure that a stray shot, or a bullet which penetrates its intended target through and through, will be safely stopped.
- Never shoot at a hard surface, or at water -- your shot may glance off, ricochet and injure someone.
- Never shoot at glass bottles, living trees, or inappropriate targets which would create a hazard for other persons or damage the environment.
- Never shoot a rifle or handgun directly upwards, or at a high angle of elevation. Even a rimfire .22 bullet fired at an angle into the air can have enough energy a mile and a half away to accidentally kill someone!
- Never shoot across a highway or other roadway.
- Never vandalize a road sign (or other public or private property) by using it as a target.
- Never poach a game animal out of season, or shoot any game animal you don't intend to eat.
Safety Rules Related to Your Firearm.
- Make sure your firearm is in good mechanical condition before firing it. Periodically have your firearm checked for signs of erosion, cracking, or wear by the factory, by a qualified armorer, or by a factory certified gunsmith.
- Never try to fire a gun which may have a plugged or partially obstructed barrel.
- Insure that any modifications made to a firearm are made by a qualified individual, and that those modifications don't interfere with your firearm's safety features.
- Be sure all accessories, such as holsters and grips, are compatible with the firearm and won't interfere with its safe operation.
- Remember: a backup firearm carried about your person may be highly valuable to you in the event your primary firearm is ever rendered inoperable or is taken from you by an assailant.
- It is your responsibility to insure that your firearm is always either about your person and under your personal control, or positively secured from access by children or other unauthorized parties. Prevent tragedy: lock down your firearms when they aren't in use.
- When storing a firearm for a long period of time, consider storing the slide, bolt, or other critical components of the firearm separately under separate lock and key.
- Never carry a single action revolver with a round under the hammer unless that revolver is a modern transfer-bar type, equipped with an inertial firing pin.
- Never carry a pistol with a round in the chamber unless the pistol has an automatic firing-pin block and/or an inertial firing pin.
- Generally avoid carrying or storing an external hammer-type firearm with its hammer cocked. Exercise extreme care in decocking any external hammer firearm: it is very easy to experience an accidental discharge while doing so if your thumb slips off the hammer.
- Generally avoid unloading a firearm by working the cartridges through the action one-at-a-time; drop the magazine and then eject the round which may be left in the chamber, instead, if possible.
- Never use a scope mounted on a firearm as a general purpose spotting scope: while observing an area you may end up accidentally aiming your firearm at fellow hunters, or other non-targets.
- Avoid trying to catch a live round (while unloading a semiautomatic pistol) by cupping your hand around the ejection port while retracting the slide; doing so may result in an accidental discharge.
Safety Rules Related to Ammunition.
- Be sure your gun and ammunition are compatible. Shooting incorrect ammunition in a firearm may cause it to be damaged or even make it blow up.
- Relying on ammunition which doesn't feed reliably in your particular firearm may make your firearm malfunction at a critical juncture: get experience with a particular lot of ammunition in your firearm before relying on it for defensive purposes.
- Use only ammunition recommended for your firearm by its manufacturer. Never fire ammunition which exceeds industry standard pressure specifications. Over-pressure ammunition will reduce the service life of your handgun, and puts you and those around you at risk of a catastrophic firearm failure.
- Use reloaded ammunition judiciously. Be aware that many firearms manufacturers specifically forbid the use of reloaded ammunition in their products, and will void their product's warranty if you elect to use reloaded ammunition in contravention of their instructions.
Also remember that a cartridge which has: the wrong powder, no powder charge, or too large a powder charge; an inverted primer, mis-seated primer, the wrong type of primer or an inert primer; a mis-seated, inverted, or mis-sized bullet; a collapsed, weakened, improperly sized or mis-crimped case; incorrect overall length or any of a host of other defects may seriously jeopardize your safety, the safety of those around you, and/or the reliability of your firearm in a defensive situation.
Many shooters prepare and safely use reloaded ammunition each day, and it can be an economical way to stretch your ammunition budget, but the safety of that reloaded ammunition directly depends on the care, components, equipment, and practices used in preparing it.
- Carry only one caliber of ammunition when shooting. Accidentally grabbing the wrong ammunition while shooting can result in a shooter or third party being injured, or damage or destruction of a firearm.
- Insure you carry sufficient spare ammunition for your defensive firearm, and make sure you carry it in a readily employable fashion (such as in spare magazines or in speedloaders).
- Store ammunition that isn't being used under lock and key, inaccessible to unauthorized parties and children.
- Dispose of unwanted ammunition safely.
Safety Rules Related to Your Firearm's Holster and Ammo Carrier.
- Always use a holster which is designed for, and which fits, your handgun.
- Make sure your holster covers the trigger guard of your handgun.
- Purchase a holster which allows you to obtain a secure grip on your handgun while it is still holstered.
- Be sure the thumb break, safety strap, or other firearm retention device on your holster is functional and consistently employed. A good holster should retain your firearm during normal carry and routine physical activity, but no holster can insure that a firearm will be secure against determined attempts at disarmament, or keep a firearm secure during all possible physical activities.
- Avoid clip-on holsters and magazine pouches. These carriers may fail to stay clipped to the belt and end up being drawn along with the firearm or the magazine they still hold, thereby interfering with use of the firearm or with timely reloading.
- Avoid paddle-style holsters, cross draw holsters, and similar holsters which provide poor weapon retention.
- Avoid ankle holsters, shoulder holsters and other types of holsters which can introduce unnecessary delays in accessing a defensive firearm.
- Avoid carrying a defensive firearm in a purse, pocketbook, daypack or briefcase. A firearm carried in that fashion is:
- Typically hard to rapidly access due to the presence of slow-to-open zippers, multiple latches, etc.,
- Often hard to find and draw amidst all the other items routinely carried, since few purses or briefcases include a dedicated handgun-carrying compartment,
- Prone to being unavailable when needed, since briefcases, purses and other carriers are routinely set down or put away in a desk drawer where they may or may not be readily accessible and under your physical control,
- Unusually vulnerable to being stolen, since purses, pocketbooks, daypacks and briefcases are prime targets for purse snatchers, pick pockets, muggers and thieves,
- Prone to misfunction in an emergency since materials carried along with your handgun in a purse or brief case may gum up the firearm's mechanism and potentially interfere with its proper operation, and
- Likely to allow your handgun to accidentally become visible to shop clerks, bank tellers or other parties while you are searching for your checkbook or locating a credit card, and that inadvertent exposure may potentially result in a tense situation or even a tragic over-reaction on the part of an individual noticing the firearm and/or summoning law enforcement officers to the scene.
- Never carry a handgun tucked into your belt or waistband without a holster (i.e., so-called ``mexican carry''). A handgun carried in this fashion may be unintentionally dislodged, fall onto a hard surface and accidentally discharge or be damaged. Inside the waistband-type holsters will allow you to obtain the concealment of this type of carry while simultaneously providing vastly improved firearm retention.
- Always employ a proper magazine holder or speed loader carrier to carry your spare ammunition. Select a design that secures and protects your speedloaders or magazines while still making them readily available for use. Avoid ammunition loops and ammo dump boxes.
- Never put a partially empty magazine or speedloader back into a magazine carrier or speedloader pouch: only full magazines or full speedloaders belong in a carrier. Partially empty magazines or speed loaders should go into your pocket; empty magazines or speedloaders should be allowed to fall where they're used during an emergency.
Miscellaneous Safety Rules.
- At a range, obey the commands of the range officers, or any individual calling `cease fire,' at once. Read, know and follow any rules peculiar to a particular range which you may be using.
- Be careful of hot gases and metal shavings ejected at the forcing cone of a revolver.
- Keep your fingers and other parts of your body away from the muzzle, the rear of the slide, and the ejection area of a semiautomatic pistol.
- In the event of a misfire, keep the firearm pointed in a safe direction, remove your finger from the trigger, wait ten seconds, then eject the cartridge and dispose of it properly.
- If you hear an unusual sound upon squeezing the trigger or feel an unusual recoil, stop shooting and investigate. You may have experienced a ``squib'' load (or under-powered cartridge), and it may have caused a bore obstruction. Keep the firearm pointed in a safe direction, remove your finger from the trigger, wait ten seconds, then unload the firearm and safely examine the barrel, checking carefully for any possible obstructions before reloading and resuming shooting.
- Never ---
- Climb a tree with a loaded firearm,
- Cross a fence with a loaded firearm,
- Jump a ditch or ford a stream with a loaded firearm,
- Scale or descend a steep incline or hill with a loaded firearm,
- Climb a tree, or climb into a hunting stand with a loaded firearm,
- Prop or lean a loaded firearm against a tree or other surface which may allow it to slide, or
- Transport a cased loaded firearm.
- Always carry your firearms in a way which will allow you to control where the muzzle is pointing, should you stumble or fall.
- A ballistic vest may substantially improve your chances of surviving an armed encounter on the street.
- Always wear a thousand square inches or more of blaze orange while in the field during hunting season.
- Blackpowder (and replica blackpowder) firearms require additional safety precautions not discussed here. Obtain qualified instruction in the safe operation of blackpowder firearms before attempting to load or fire any such firearm.
- Circumstances may require additional safety rules unique to a particular situation.
III. Safe Gun Storage.
When you are not using your firearm, you should insure that it is store safely. Affirmative measures designed to prevent unauthorized access to a defensive firearm by minors, or firearm theft, include:- Use of a simplex-type locking box for securing firearms which need to be kept loaded yet available for ready-access defensive use, and
- Use of trigger locks or padlocks to secure firearms which don't need to be kept immediately available for defensive use.
- Gun security devices which rely solely on physical strength to secure firearms from unauthorized use are generally undesirable since ingenious children can potentially employ leverage or tools to overcome those devices.
- "Hiding" a firearm won't secure it from discovery and possible misuse by curious children or intruders.
- Metal gun cabinets or gun safes can be used to safeguard firearms from unauthorized access or theft in many circumstances and metal gun cabinets or gun safes are generally preferable to open racks or glass-front cabinets.
- Firearms should be stored unloaded and separate from ammunition when the firearm isn't needed for ready-access defensive use.
- You may want to store critical components of a firearm (such as the gun's bolt or slide) separately from the rest of the firearm when the gun won't be used in the immediate future.
- Consider engraving your firearms with your social security number, driver's license number, or concealed firearms license number to deter theft and facilitate return of stolen firearms which may happen to be recovered.
- Explore "gun-proofing" your child by proper training, and by controlled and closely supervised access to firearms to reduce your child's natural unsatisfied curiosity about firearms.
http://darkwing.uoregon.edu/~joe/firearms-safety.html
7/18/09
"End of Month + Net Days" payment terms due date calculation
Folks across the pond use payment terms and due dates that are not traditionally close the ones we are familiar with on this side of the hemisphere. "End of Month + Net Days" (EOM+ND) is a typical case.
In EOM+ND payment terms, an invoice becomes due a number of net days after the last day of the month for the invoice date. For example, if an invoice date is July 16 and we are on a payment term of EOM plus 45 net days, the invoice will not be due until September 14 -- or 45 days from July 31.
Of course, you cannot manage this type of payment term request in GP, not out-of-the-box anyways, which most of the time will require a customization to deal with the issue.
In this article, I will examine setting up two SQL Server triggers: one on the PM Transaction Open File (dbo.PM20000) and another on the RM Open File (dbo.RM20101) tables. The triggers will use the Net Days field in the Payment Terms Master (dbo.SY03300) table to calculate the net days after the end of month to assign the invoice due date.
So here are the triggers:
trigger pmEOMPlusNet
-- Created by Mariano Gomez, MVP
-- No warranties expressed or implied
CREATE TRIGGER pmEOMPlusNet ON dbo.PM20000 AFTER INSERT
AS
BEGIN TRANSACTION;
BEGIN TRY
UPDATE A SET A.DUEDATE =
DATEADD(dd, B.DUEDTDS, DATEADD(dd, -1, DATEADD(mm, DATEDIFF(mm, 0, I.DOCDATE) + 1, 0)))
FROM PM20000 A
INNER JOIN INSERTED I ON (A.VCHRNMBR = I.VCHRNMBR) AND (A.DOCTYPE = I.DOCTYPE)
LEFT OUTER JOIN SY03300 B ON (I.PYMTRMID = B.PYMTRMID)
WHERE (I.DOCTYPE = 1) AND (I.PYMTRMID LIKE 'EOMPLUSND%')
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber
, ERROR_SEVERITY() AS ErrorSeverity
, ERROR_STATE() AS ErrorState
, ERROR_PROCEDURE() AS ErrorProcedure
, ERROR_LINE() AS ErrorLine
, ERROR_MESSAGE() AS ErrorMessage;
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;
IF @@TRANCOUNT > 0
COMMIT TRANSACTION;
GO
trigger rmEOMPlusNet
-- Created by Mariano Gomez, MVP
-- No warranties expressed or implied
CREATE TRIGGER rmEOMPlusNet ON dbo.RM20101 AFTER INSERT
AS
BEGIN TRANSACTION;
BEGIN TRY
UPDATE A SET A.DUEDATE =
DATEADD(dd, B.DUEDTDS, DATEADD(dd, -1, DATEADD(mm, DATEDIFF(mm, 0, I.DOCDATE) + 1, 0)))
FROM RM20101 A
INNER JOIN INSERTED I ON (A.CUSTNMBR = I.CUSTNMBR) AND (A.DOCNUMBR = I.DOCNUMBR)
AND (A.RMDTYPAL = I.RMDTYPAL)
LEFT OUTER JOIN SY03300 B ON (I.PYMTRMID = B.PYMTRMID)
WHERE (I.RMDTYPAL= 1) AND (I.PYMTRMID LIKE 'EOMPLUSND%')
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber
, ERROR_SEVERITY() AS ErrorSeverity
, ERROR_STATE() AS ErrorState
, ERROR_PROCEDURE() AS ErrorProcedure
, ERROR_LINE() AS ErrorLine
, ERROR_MESSAGE() AS ErrorMessage;
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;
IF @@TRANCOUNT > 0
COMMIT TRANSACTION;
GO
Setting up the payment term in Dynamics GP
Open the Payment Terms Setup window (MSDGP > Tools > Setup > Company > Payment Terms) and configure the payment term as shown below:
NOTE: You can still setup discount and discount types for the payment term, but these will be calculated based on the document date. If you need these to apply based on EOM as well, you will need to change the above triggers to reflect the discount calculation based on EOM as well.
Finally, once setup, these payment terms can be used from SOP and POP. Just keep in mind that the due dates will not be calculated while the transactions are stored in a batch, but rather when posted.
Clean Install Windows XP
Clean Install Windows XP
I’ve made no secret of my feelings about doing upgrade installations of Windows XP. My personal experience has shown that very seldom, if ever, do you realize the full potential of a new operating system when it’s installed as an upgrade. The most meticulous of users can’t guard against all the stray files, drivers, and registry entries that creep into a system through normal use. I see no sense in starting out at a disadvantage. All the little problems that existed before the upgrade are likely to make the transition right along with the new operating system. So, that said, what’s involved in doing a clean install of Windows XP?
The Preparation
A clean install in Windows XP is a very straightforward process. Just as there are certain things that need to be done to ensure a successful upgrade, the same care is needed with a clean install. First, check the requirements for Windows XP. A box that just squeaks by on the minimum requirements is not going to make you happy with XP. Truthfully, it’s a recipe for disaster. XP has many nice features, but they do require a box which has the oomph to power them adequately. Check the requirements for the appropriate version using the links below.
Windows XP Home Edition System Requirements
Windows XP Professional Edition System Requirements
If the computer is up to snuff, the next step is to check the rest of the hardware against the Windows XP Hardware Compatibility List to see if it’s supported. It’s possible, even likely, that one or more of your items won’t be on the list. That doesn’t mean you have to replace them or that they won’t work with XP, but it does mean you should visit the manufacturer site to check for XP drivers. In some cases the Windows 2000 drivers will work just fine. The point is, make sure you have the drivers downloaded and saved where they will be available during the XP installation. Drivers for RAID and SCSI devices fall into this same category. Make sure they are available at the beginning of the installation process.
Microsoft has made available on their website some excellent documentation regarding upgrading to Windows XP. I strongly suggest it be read before a final decision is made. A number of other articles are linked from the one below, including a download location for the Microsoft Windows Upgrade Advisor. Even though it's a 35MB download, running it will alert you to any hardware and software problems that may be encountered in your XP installation.
Description of the Windows XP Upgrade Advisor (Q307726)
If you aren’t familiar with the differences between FAT32 and NTFS file systems, now is the time to rectify that situation. This will be the most important decision you have to make during the installation process so a bit of knowledge can be very valuable. See the article linked below.
Description of the FAT32 File System in Windows XP (Q310525)
Make sure that the installation CD’s for every program you use are available as well as the media that qualifies you to be doing a Windows XP installation. Once you wipe the drive there is no magical set of keystrokes that will get your programs and data back, which brings me to the final point for this section. Back up your data, test and verify the backup, and be sure the backup device you used will be available under Windows XP. With the previous tasks completed, it’s onward to the actual installation.
The Installation
There are two methods available for installing Windows XP, both requiring the first step of booting your machine. You’re in luck if the box is capable of booting from the CD-ROM drive since the Windows XP CD’s are bootable. No, XP isn’t available on floppies, and even if it was you’d need a two week vacation to do the installation. If the computer doesn’t support booting from the CD, you’ll need a set of Setup Startup Disks, but here is a final caution before you go this route. Most computers that will be happy running XP have the capability to boot from the CD. It’s probably a red flag if you need the startup disks, so take one more look at the minimum and recommended requirements for running Windows XP. If it’s still a go, download the file that will create the disk sets for either the Home Edition or the Professional Edition. Make the disk set, boot the computer and insert the XP CD to begin the installation.
For boxes that support booting from the CD, the following steps will get you through the clean install of Windows XP.
Fire up the computer and insert the XP CD.
Watch the monitor for the message that the CD has been auto-detected, followed by the “Press any key to boot CD” message. Don’t fall for the old joke about looking for the “Any” key and just hit the spacebar or any other key that’s convenient within the five second time span the message will be displayed.
When I first put together this guide to a clean install of XP I didn't think there would be a big problem with ACPI BIOS detection. I was wrong, so I've inserted this section relating to Advanced Configuration and Power Interface (ACPI) detection in the hope of saving users a lot of grief over XP not shutting down properly. The identical information is also included on the page about Shutdown Problems.
|
Files will start to load from the CD to begin the installation. Eventually you’ll be asked if you want to install Windows XP. No need to type an essay here on why you’ve made the decision to do the installation. Just hit Enter.
Next is the End User License Agreement or EULA which must be accepted to continue installation. Press F8 to accept, F3 to bail out now. You can read the EULA if you want, but it adds two days to the installation time.
The next screen displays the available partitions where XP can be installed. Select the one you want and tap that Enter key again to move on to the screen where you select a file system.
It’s time for that important decision. FAT32 versus NTFS. The preferred choice is NTFS. It allows security features and stability that aren’t possible with FAT32. Apply the knowledge you gained during the preparation phase at this point. Make your choice of formatting options and press the F key to start the process. Once the format process completes the installation will continue.
If you are installing from a full version Windows XP CD the installation continues without intervention. If you’re using an upgrade version CD this is where Microsoft confirms your eligibility by requesting the media that allows you to use the upgrade version. Insert your media in the drive, let the verification complete and reinsert the XP CD when prompted.
Setup continues and eventually the computer will reboot. Watch the onscreen prompts but do not press a key when the “Press any key to boot CD” message appears.
Installation will continue, prompting you from time to time to supply some additional setup information. Feed the prompts with appropriate responses and eventually another reboot will occur, this time bringing you back into Windows XP, depositing you at the Windows Activation screen.
You can either activate your copy of XP now or delay the activation for up to 30 days and suffer the periodic activation reminders. I suggest you activate now and register at the same time. It’s really painless. In any case, activation is required at some point or after 30 days you’ll be denied access to the desktop. Registration is entirely optional.
The last step is to enter a username and watch the XP desktop appear, ready for use.
Congratulations. You’ve just completed a clean install of Windows XP. Look around, explore, play with the settings and start installing applications and transferring your data backup. You’re not in Kansas anymore. This is Windows XP.
How to change GP 10.0 Homepage??
Guys,
I found an interesting post at the Newsgroup on how to remove the GP 10.0 home page, definitely the short answer will be it cannot be removed, but if this request is a must, we must workaround it, therefore I wrote this article to modify the home page file and replace its content with single logo that represents the company logo, below sample shows the home page after the modification:
Now to have your home page looks like the above you will need to follow steps below:
1. Locate "C:\Program Files\Microsoft Dynamics\GP\Background\HomePage.xsl" and copy it to have a backup of the file.
2. Open the file using Notepad or any available editor.
3. Remove all the code inside the file and place code below instead with changing the image in the code to your company logo.
version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:output method="html" indent="yes" />
<xsl:template match="Page">
<br>br>
<br>br>
<br>br>
<center><img src="D:\My Documents\GPLogo.jpg" alt="Company Logo" title="Logo" />center>
xsl:template> </xsl:stylesheet>
Refresh your GP home page and enjoy!
7/16/09
Row Numbering in Access Report
Set it's control source to =1
Set it's Running Sum property to
Over All.
http://www.eggheadcafe.com/forumarchives/Accessreports/Jun2005/post23236226.asp
Weekly Review: Extreme Makeover JE Edition
Each week I'd like to cover a feature in GP. Some of them are new, others just underutilized. Ideally, I'd like to do this more than weekly but hey, I have a job.
Extreme Makeover, JE Edition
In version 8.0 Microsoft introduced Journal Entry corrections and copies. This is feature I'd been asking for for some time. I even came close to writing my own version several times. You now have the ability to undo a journal entry, easily, and with a complete audit trail.
In Transactions->Financial->General, select Correct. You now have an option to back out a Journal Entry or Back out a JE and create a correcting entry.
You will also need the JE number (you can look it up) and year of the entry you want to correct.
What happens behind the scenes when you backout an entry is that GP creates a duplicate, opposite JE with a new JE number to offset the one you want to correct. If all you need to do is undo an entry, simply post your correction and you're done.
If you also select a correcting entry, the first entry created is the backout entry. When you post or save the backout entry, a second entry is created. This second entry is your original entry as a new, unposted JE that you can make changes to.
Both the backout and the correction are normal JE's that can be save to a batch, changed, posted, made reversing, etc.
Some obvious uses:
- That batch of month end accruals was accidentally posted in next month. Simply pull up the JE, do a correction to back it out of next month, and change the date on the correcting entry to the correct month. Post it all an you are in business.
- The 150 line JE keyed incorrectly by an intern. Hopefully this was reviewed before posting, but if not, use this tool to backout the incorrect entry and make the intern fix the correcting entry (or re-key it, depending on how mad you are ;).
A related feature is to Copy a JE. Same process, just click copy instead of correct. This is great when you need to create a JE just like the one you did last month!
By default, Correction only works for transactions that originated in the General Ledger. However, the administrator can change this behavior.
Tools>Setup>Financial>General Ledger now has new check boxes to control this functionality. Check "Voiding/Correcting of Subsidiary Transactions" and "Back Out of Inter-company Transactions" to allow for corrections of transactions originating in a sub-ledger.
This a great feature, a critical feature, that the competition has had for a while. Now we've got it and I love it. But you have to be on v8.0 or better. This was one of the compelling features that pushed us to upgrade to 8.0. Detailed specifics can be found in GP Help. Happy Fixing!
http://msdynamicsgp.blogspot.com/2009/07/weekly-review-extreme-makeover-je.html