Wednesday, November 23, 2011
Tuesday, November 22, 2011
Microsoft Dynamics GP Manufacturing Flow Chart
Many times I have been asked for flow chart for Dynamics GP Manufacturing, so I thought of uploading the same to blog so it can be shared with everyone.
Sunday, November 20, 2011
Windows XP Run Commands and Shortcuts
Windows XP Home / Pro Run Commands and Short Cuts
How To - Click Start, Click Run and enter the command Click OK
Run commands
Calc - Calculator
Cfgwiz32 - ISDN Configuration Wizard
Charmap - Character Map
Chkdisk - Repair damaged files
Cleanmgr - Cleans up hard drives
Clipbrd - Windows Clipboard viewer
Cmd - Opens a new Command Window (cmd.exe)
Control - Displays Control Panel
Dcomcnfg - DCOM user security
Debug - Assembly language programming tool
Defrag - Defragmentation tool
Drwatson - Records programs crash & snapshots
Dxdiag - DirectX Diagnostic Utility
Explorer - Windows Explorer
Fontview - Graphical font viewer
Ftp - ftp.exe program
Hostname - Returns Computer's name
Ipconfig - Displays IP configuration for all network adapters
Jview - Microsoft Command-line Loader for Java classes
MMC - Microsoft Management Console
Msconfig - Configuration to edit startup files
Msinfo32 - Microsoft System Information Utility
Nbtstat - Displays stats and current connections using NetBios over TCP/IP
Netstat - Displays all active network connections
Nslookup - Returns your local DNS server
Odbcad32 - ODBC Data Source Administrator
Ping - Sends data to a specified host/IP
Regedit - registry Editor
Regsvr32 - register/de-register DLL/OCX/ActiveX
Regwiz - Reistration wizard
Sfc /scannow - Sytem File Checker
Sndrec32 - Sound Recorder
Sndvol32 - Volume control for soundcard
Sysedit - Edit system startup files (config.sys, autoexec.bat, win.ini, etc.)
Systeminfo - display various system information in text console
Taskmgr - Task manager
Telnet - Telnet program
Taskkill - kill processes using command line interface
Tskill - reduced version of Taskkill from Windows XP Home
Tracert - Traces and displays all paths required to reach an internet host
Winchat - simple chat program for Windows networks
Winipcfg - Displays IP configuration
Management Consoles
certmgr.msc - Certificate Manager
ciadv.msc - Indexing Service
compmgmt.msc - Computer management
devmgmt.msc - Device Manager
dfrg.msc - Defragment
diskmgmt.msc - Disk Management
fsmgmt.msc - Folder Sharing Management
eventvwr.msc - Event Viewer
gpedit.msc - Group Policy -XP Pro only
iis.msc - Internet Information Services
lusrmgr.msc - Local Users and Groups
mscorcfg.msc - Net configurations
ntmsmgr.msc - Removable Storage
perfmon.msc - Performance Manager
secpol.msc - Local Security Policy
services.msc - System Services
wmimgmt.msc - Windows Management
Shortcuts
access.cpl - Accessibility Options
hdwwiz.cpl - Add New Hardware Wizard
appwiz.cpl - dd/Remove Programs
timedate.cpl - Date and Time Properties
desk.cpl - Display Properties
inetcpl.cpl - Internet Properties
joy.cpl - Joystick Properties
main.cpl keboard - Keyboard Properties
main.cpl - Mouse Properties
ncpa.cpl - Network Connections
ncpl.cpl - Network Properties
telephon.cpl - Phone and Modem options
powercfg.cpl - Power Management
intl.cpl - Regional settings
mmsys.cpl sounds - Sound Properties
mmsys.cpl - Sounds and Audio Device Properties
sysdm.cpl - System Properties
nusrmgr.cpl - User settings
firewall.cpl - Firewall Settings (sp2)
wscui.cpl - Security Center (sp2)
Windows Environment Commands
%ALLUSERSPROFILE% - Open the All User's Profile
%HomeDrive% - Opens your home drive e.g. C:\
%UserProfile% - Opens you User's Profile
%temp% Opens - temporary file Folder
%systemroot% - Opens Windows folder
Wupdmgr - Takes you to Microsoft Windows Update
General keyboard shortcuts
CTRL+C(Copy)
CTRL+X (Cut)
CTRL+Z (Undo)
DELETE (Delete)
SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
CTRL while dragging an item (Copy the selected item)
CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
F2 key (Rename the selected item)
CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
CTRL+A (Select all)
F3 key (Search for a file or a folder)
ALT+ENTER (View the properties for the selected item)
ALT+F4 (Close the active item, or quit the active program)
ALT+ENTER (Display the properties of the selected object)
ALT+SPACEBAR (Open the shortcut menu for the active window)
CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
ALT+TAB (Switch between the open items)
ALT+ESC (Cycle through items in the order that they had been opened)
F6 key (Cycle through the screen elements in a window or on the desktop)
F4 key (Display the Address bar list in My Computer or Windows Explorer)
SHIFT+F10 (Display the shortcut menu for the selected item)
ALT+SPACEBAR (Display the System menu for the active window)
CTRL+ESC (Display the Start menu)
ALT+Underlined letter in a menu name (Display the corresponding menu)
Underlined letter in a command name on an open menu (Perform the corresponding command)
F10 key (Activate the menu bar in the active program)
RIGHT ARROW (Open the next menu to the right, or open a submenu)
LEFT ARROW (Open the next menu to the left, or close a submenu)
F5 key (Update the active window)
BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
ESC (Cancel the current task)
SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)
CTRL+SHIFT+ESC (Open Task Manager) Dialog box keyboard shortcuts
If you press SHIFT+F8 in extended selection list boxes, you enable extended selection mode. In this mode, you can use an arrow key to move a cursor without changing the selection. You can press CTRL+SPACEBAR or SHIFT+SPACEBAR to adjust the selection. To cancel extended selection mode, press SHIFT+F8 again. Extended selection mode cancels itself when you move the focus to another control.
CTRL+TAB (Move forward through the tabs)
CTRL+SHIFT+TAB (Move backward through the tabs)
TAB (Move forward through the options)
SHIFT+TAB (Move backward through the options)
ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
ENTER (Perform the command for the active option or button)
SPACEBAR (Select or clear the check box if the active option is a check box)
Arrow keys (Select a button if the active option is a group of option buttons)
F1 key (Display Help)
F4 key (Display the items in the active list)
BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)
Microsoft natural keyboard shortcuts
Windows Logo+BREAK (Display the System Properties dialog box)
Windows Logo+D (Display the desktop)
Windows Logo+M (Minimize all of the windows)
Windows Logo+SHIFT+M (Restore the minimized windows)
Windows Logo+E (Open My Computer)
Windows Logo+F (Search for a file or a folder)
CTRL+Windows Logo+F (Search for computers)
Windows Logo+F1 (Display Windows Help)
Windows Logo+ L (Lock the keyboard)
Windows Logo+R (Open the Run dialog box)
Windows Logo+U (Open Utility Manager)
Accessibility keyboard shortcuts
Right SHIFT for eight seconds (Switch FilterKeys either on or off)
Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
SHIFT five times (Switch the StickyKeys either on or off)
NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
Windows Logo +U (Open Utility Manager)
Windows Explorer keyboard shortcuts
END (Display the bottom of the active window)
HOME (Display the top of the active window)
NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
NUM LOCK+Minus sign (-) (Collapse the selected folder)
LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)
Shortcut keys for Character Map
After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts
RIGHT ARROW (Move to the right or to the beginning of the next line)
LEFT ARROW (Move to the left or to the end of the previous line)
UP ARROW (Move up one row)
DOWN ARROW (Move down one row)
PAGE UP (Move up one screen at a time)
PAGE DOWN (Move down one screen at a time)
HOME (Move to the beginning of the line)
END (Move to the end of the line)
CTRL+HOME (Move to the first character)
CTRL+END (Move to the last character)
SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)
Microsoft Management Console (MMC) main window keyboard shortcuts
• CTRL+O (Open a saved console)
CTRL+N (Open a new console)
CTRL+S (Save the open console)
CTRL+M (Add or remove a console item)
CTRL+W (Open a new window)
F5 key (Update the content of all console windows)
ALT+SPACEBAR (Display the MMC window menu)
ALT+F4 (Close the console) • ALT+A (Display the Action menu)
ALT+V (Display the View menu)
ALT+F (Display the File menu)
ALT+O (Display the Favorites menu)
MMC console window keyboard shortcuts
CTRL+P (Print the current page or active pane)
ALT+Minus sign (-) (Display the window menu for the active console window)
SHIFT+F10 (Display the Action shortcut menu for the selected item)
F1 key (Open the Help topic, if any, for the selected item)
F5 key (Update the content of all console windows)
CTRL+F10 (Maximize the active console window)
CTRL+F5 (Restore the active console window)
ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
F2 key (Rename the selected item)
CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)
Remote desktop connection navigation
CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
ALT+PAGE UP (Switch between programs from left to right)
ALT+PAGE DOWN (Switch between programs from right to left)
ALT+INSERT (Cycle through the programs in most recently used order)
ALT+HOME (Display the Start menu)
CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
ALT+DELETE (Display the Windows menu)
CTRL+ALT+Minus sign (-) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)
CTRL+ALT+Plus sign (+) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
Microsoft Internet Explorer navigation
CTRL+B (Open the Organize Favorites dialog box)
CTRL+E (Open the Search bar)
CTRL+F (Start the Find utility)
CTRL+H (Open the History bar)
CTRL+I (Open the Favorites bar)
CTRL+L (Open the Open dialog box)
CTRL+N (Start another instance of the browser with the same Web address)
CTRL+O (Open the Open dialog box, the same as CTRL+L)
CTRL+R (Update the current Web page)
CTRL+ CTRL+P (Open the Print dialog box)
W (Close the current window)
Note Some keyboard shortcuts may not work if StickyKeys is turned on in Accessibility Options, Some of the Terminal Services client shortcuts that are similar to the shortcuts in Remote Desktop Sharing are not available when you use Remote Assistance in Windows XP Home Edition.
Microsoft Office run commands
If the Microsoft Office is installed you can use following run commands to run its components:
winword – Microsoft Word
excel – Microsoft Excel
powerpnt – Microsoft PowerPoint
msaccess – Microsoft Access
outlook – Microsoft Outlook
ois – Microsoft Picture Manager
Monday, November 14, 2011
Things to do before POP
Before you set up Purchase Order Processing
You should complete setup procedures in Payables Management and Inventory
Control before you set up Purchase Order Processing. If you haven’t completed all
of the following tasks, be sure to do so before continuing.
• Set up Payables Management
• Create vendor cards
• Enter beginning inventory quantities
• Set up item records (be sure to assign price lists and vendor items)
• Set up item sites
• Set up inventory and purchasing accounts in the Posting Accounts Setup
window
To view the Posting Accounts Setup window, choose Microsoft Dynamics GP menu >>
Tools >> Setup >> Posting >> Posting Accounts and then select to view Inventory or
Purchasing accounts.
Be sure you’ve also completed the setup procedures for your company, currency,
checkbooks, and posting options. Tax schedules and tax details also should be set
up. For more information about completing these procedures, refer your System
Setup instructions (Help >> Contents >> select Setting Up the System).
If you’re using landed costs, be sure to set up landed cost records and groups before
you set up Purchase Order Processing. For details, see the Inventory Control
documentation.
If you’re using Multicurrency Management, be sure to set up currencies, exchange
rate tables, and rate types before you set up Purchase Order Processing. For details,
see the Multicurrency Management documentation.
You should complete setup procedures in Payables Management and Inventory
Control before you set up Purchase Order Processing. If you haven’t completed all
of the following tasks, be sure to do so before continuing.
• Set up Payables Management
• Create vendor cards
• Enter beginning inventory quantities
• Set up item records (be sure to assign price lists and vendor items)
• Set up item sites
• Set up inventory and purchasing accounts in the Posting Accounts Setup
window
To view the Posting Accounts Setup window, choose Microsoft Dynamics GP menu >>
Tools >> Setup >> Posting >> Posting Accounts and then select to view Inventory or
Purchasing accounts.
Be sure you’ve also completed the setup procedures for your company, currency,
checkbooks, and posting options. Tax schedules and tax details also should be set
up. For more information about completing these procedures, refer your System
Setup instructions (Help >> Contents >> select Setting Up the System).
If you’re using landed costs, be sure to set up landed cost records and groups before
you set up Purchase Order Processing. For details, see the Inventory Control
documentation.
If you’re using Multicurrency Management, be sure to set up currencies, exchange
rate tables, and rate types before you set up Purchase Order Processing. For details,
see the Multicurrency Management documentation.
Sunday, November 13, 2011
Network Connection (WiFi no internet access symbol)
1. Click Start / run / ncpa.cpl
Internet Protocol (TCP/IP)
Properties
208.67.222.222
208.67.220.220
2. Reset WINSOCK
CMD / run as admin
type "Netsh Winsock reset"
TCP/IP (V4): netsh int ipv4 reset reset.log
TCP/IP (V6): netsh int ipv6 reset reset.log
Internet Protocol (TCP/IP)
Properties
208.67.222.222
208.67.220.220
2. Reset WINSOCK
CMD / run as admin
type "Netsh Winsock reset"
TCP/IP (V4): netsh int ipv4 reset reset.log
TCP/IP (V6): netsh int ipv6 reset reset.log
Great Plains : Keyboard Shortcuts
This is probably thanks to the excellent keyboard support since the early versions. In fact, Richard Allen, who has worked with GP since the early 1990's - expects all windows applications to have those basic shortcuts, and is pretty critical when they don't! I've seen him work in GP using his short-cuts and its a joy to watch how efficient and quick you can be, using - just the keyboard. Probably the comparison is a little wild - but watching somebody like him navigate and work in the GP - is as good as watching Tiger Woods play golf.
So I've been maintaining my own baby list (based on the GP documentation) with some screen shots - and I'll put it out here for reference and add on to it over time.
Do you know any other short-cuts that you use often ?
Common Keyboard shortcuts
Move to next field : tab
Move to previous field : shift + tab
Move from scrolling window to next field : ctrl + tab
Move from scrolling window to previous field : shift + ctrl + tab
Default button on a window : enter
Close the current window : ctrl + w
Exit application :alt + x
Ctrl + L To open the look window
Some shortcuts for the home page
Navigation pane button ctrl + number of navigation pane button. For example, press ctrl + 2 to activate the second navigation pane button.
Address Bar Alt + d
For Date Fields - if you enter it just the day, it will automatically fill in the current month and year.
08 Becomes
08042007
Adding a Shortcut to Open Up a Specific Window
Say, you are end up adding a few customers everyday at various times. You can set up a shortcut, say CTRL + SHIFT + C to open up the Customer Maintenance Window.
Then there are the Window Specific Shortcuts
Customer Maintenance - Alt + A,A would open up customer accounts
I just searched help and found all the window specific short-cuts.
| Assembly Entry — Decrease Level | ctrl + d |
| Assembly Entry — Increase Level | ctrl + i |
| Edit Payables Checks — Create Temporary Vendor | ctrl + t |
| Edit Purchase Order Status— Display Vendor Item Detail | ctrl + d |
| Payables Manual Payment Entry — Create Temporary Vendor | ctrl + t |
| Payables Transaction Entry — Create Temporary Vendor | ctrl + t |
| Purchase Order Entry — Create Temporary Vendor | ctrl + t |
| Purchase Order Entry — Display Vendor Item Detail | ctrl + d |
| Purchase Order Entry — Open Item Detail | ctrl + e |
| Purchase Order Inquiry Zoom — Display Vendor Item Detail | ctrl + d |
| Purchase Order Inquiry Zoom — Open Item Detail | ctrl + e |
| Purchase Order Processing Item Inquiry — Display Vendor Item Detail | ctrl + d |
| Purchasing Invoice Entry — Display Vendor Item Detail | ctrl + d |
| Purchasing Invoice Entry — Open Item Detail | ctrl + e |
| Purchasing Invoice Entry — Open Match Shipments to Invoice | ctrl + m |
| Purchasing Invoice Inquiry Zoom— Display Vendor Item Detail | ctrl + d |
| Purchasing Item Detail Entry — Display Vendor Item Detail | ctrl + d |
| Purchasing Item Detail Inquiry Zoom — Display Vendor Item Detail | ctrl + d |
| Purchasing Item Receipts Zoom — Display Vendor Item Detail | ctrl + d |
| Purchasing Vendor Detail Entry — Create Temporary Vendor | ctrl + t |
| Receivings Item Detail Entry — Display Vendor Item Detail | ctrl + d |
| Receivings Transaction Entry — Create Temporary Vendor | ctrl + T |
| Receivings Transaction Entry — Display Vendor Item Detail | ctrl + d |
| Receivings Transaction Entry — Open Item Detail | ctrl + e |
| Receivings Transaction Inquiry Zoom — Open Item Detail | ctrl + e |
| Receivings Transaction Inquiry Zoom— Display Vendor Item Detail | ctrl + d |
| Sales Transaction Entry — Open Item Detail | ctrl + e |
| Sales Transaction Entry— Quick Print | ctrl + q |
| Select Purchase Order Items — Display Vendor Item Detail | ctrl + d |
| Vendor Account Maintenance — Open Additional Vendor Accounts | ctrl + e |
Microsoft GP 10 Security Definitions "basics"
Security Overview
Microsoft Dynamics GP provides several types of security:
System - System security controls access to system-wide setup information, such as setting up new user records, assigning user security, or printing reports that contain that information. System level security is controlled through the use of a password; only a few people should know the password.
Company - Company security controls access to companies on a per user basis. When you set up a new user record, it does not have access to any companies. Grant access using the User Access Setup window before the user can log in to Microsoft Dynamics GP.
Security Tasks - Security tasks are assigned to roles and grant access to windows, reports, files, and other resources within Microsoft Dynamics GP that users need to access to complete a specific task. Security tasks are new to Release 10.0.
Security Roles - Security roles contain the security tasks that a user needs to access to do their job. Roles are then assigned to individual users of Microsoft Dynamics GP. Security roles are new to Release 10.0.
Individual Users - Individual security is role-based in Microsoft Dynamics GP. Users must be assigned to a security role before they can access any forms, reports, or other data within Microsoft Dynamics GP. To begin assigning user security, identify the daily tasks that a user completes within Microsoft Dynamics GP. Then, select from the default security roles or create new security roles that only grant access to the tasks that the user needs. This process has changed with Release 10.0.
Module-Specific Tasks - Most Microsoft Dynamics GP modules have specific tasks that can be set up to require a password; each task can have a different password. If a password is required, all users attempting to complete that task must enter the password. See the setup documentation for each accounting module for information about these passwords.
Account - Account-level security enhances security and account views. Users can enter, edit, and view information from a reduced account set based on the access granted for accounts.
Field Level Security - Field level security restricts access to any field, window, or form in Microsoft Dynamics GP. It allows you to apply a password, or to make a window or form unavailable. It also allows you to hide, lock, or apply passwords to fields.
Operations
• A base level element of security for windows, for reports, for posting permissions, and for document access
Tasks
• A group of operations that are needed to complete a business task
• For example, the business task can be the Enter Vendors task and the Post Payables Transactions task
Roles
• A group of tasks that defines a particular job in a company
• DEFAULTUSER Role: automatically assigned to every role, grants access to basic areas that all GP Users need
• POWERUSER Role: automatically assigned to sa user, grants access to all areas and modules of GP
• Examples: Accounts Payable Specialist, Accounting Manager, Controller
Security Task & Security Roles:
Microsoft Dynamics GP 10.0 introduces new concepts when setting up security. The new security model takes a pessimistic view, meaning new users have no access in the application, where previously security access needed to be taken away from new users. Security tasks include access to resources to complete certain tasks in the application, such as entering vendors. Security roles grant access to a group of tasks associated with the role. Finally, security roles can be assigned to users within the application.
- Access to all windows, tables, reports and miscellaneous permissions are classed as Security Operations.
- A set of Security Operations required to perform a specific task are assigned to a Security Task.
- Multiple Security Tasks required to perform a specific role are assigned to a Security Role.
- Each User and Company combination can then have multiple Security Roles assigned to it.
Note: Operations may be assigned to multiple Security Tasks and Security Tasks may be assigned to multiple Security Roles.
In the situation when a system administrator knows which window (or report) they wish to grant access to a user, but does not know what Security Tasks or Security Roles are associated with the window, there is no simple method to obtain this information from within the application. It would be possible to scroll through each Security Task on the Security Task Setup window (Microsoft Dynamics GP >> Tools >> Setup >> System >> Security Tasks) and check if the window is selected, but this is time consuming. The Print Operation Access report which can be printed after selecting the window will show which users have access to the window, but not how that access was obtained based on the Security Roles and Security Tasks.
Security Task: to grant access to windows, reports, files, and other resources within Microsoft Dynamics GP that users need to access to complete specific tasks.
Security Roles: to create new security roles, modify previously created roles, or modify default security roles.
Security Table Information
Security Operations for a Security Task are stored in table “sySecurityAssignTaskOperations (SY10700)”.
Security Tasks are defined in table “sySecurityMSTRTask (SY09000)”.
Security Tasks for a Security Role are stored in table “sySecurityAssignTaskRole (SY10600)”.
Security Roles are defined in table “sySecurityMSTRRole (SY09100)”.
Security Roles for a User and Company combination are stored in table “sySecurityAssignUserRole (SY10500)”.
Field Level Security (Termed as Advanced Security in Dynamics GP V9.0) is an additional security layer (module) in Microsoft Dynamics GP that provides the ability to restrict access to any field, window or form. It does offer several options in terms of access restriction through Security Modes. Let us see what security modes the FLS possesses
| Password Before | Access is restricted for a field by password before field is accessed |
| Password After | Password must be entered for any changes to field to be saved |
| Access will be denied for a field combined with a warning | |
| User can’t use or modify the field | |
| Field will be displayed but will not be available | |
| Field won’t be displayed | |
| Window level security – Must enter password while opening the window | |
| Window level security – Only “sa’ password is permitted for displaying the window | |
| Form Level Security – Must enter password for accessing the form | |
| Disable Form | Form Level Security - Only “sa’ password is permitted for displaying the form |
Subscribe to:
Posts (Atom)