Home

Professional Services Tools Library

1. Type values Series values Windows Financial Sales Purchasing Inventory Payroll Project System Reports Financial Sales Purchasing Inventory Payroll System Files Financial Sales Purchasing Inventory Payroll Project System Company Windows selected from the Type drop down list Project selected from the Series drop down list and Professional Services Tools Library marked as an operation is required to get into the main Professional Services Tools Library window BA Security Task Setup File Edt Tools Help E Save Z Clear X Delete EH Copy Task ID PSTL A Category Other Task Name PSTL Task Description PSTL Product Technical Service Tools F Type Windows Series Project Mark All Unmark All v Professional Services Tools Library Print Operation Access CRE J o 10 Select Save to save the new security task Security role setup 1 Go to Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Security Roles Create a new Role ID In this example the name of PSTL is used Enter PSTL for the Role Name and Description In the Display drop down select the Category related to the security task you will associate to this Role ID In this example the category is Other PROFESSIONAL SERVICES TOOLS LIBRARY 11 CHAPTER 1 INSTALLING PROFESSIONAL SERVICES TOOLS LIBRARY 5 Click Mark All to select the Security T
2. a Fabrikam Inc File Edit Tools Help CAUTION Make a backup of all databases before Toolkit Options running any corrective procedures A G full backup made when a problem is first noticed will allow the system to be restored back to that point in time if the selected procedures do not correct the problem 2 Choose Next To re create Microsoft SOL Objects There are several options when selecting Recreate SQL Objects 1 You should have all users out of the system when re creating any objects using this tool 1 Select Recreate SOL Objects under the Toolkit Options heading and choose Next 14 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 2 US 2 Choose the series or table you wish to change BF System Diagnostics File Edit Tools Help Product Microsoft Dynamics GP Series Financial v Table TWO dbo GL00100 ING SYSTEM TOOLS a Fabrikam Inc Maintenance Options Recreate Dex Procs for Selected Table Recreate Dex Procs for Selected Series Rebuild Indexes for Selected Table Rebuild Indexes for Selected Series C Recreate Selected Table Recreate Tables for Selected Series Recreate data for selected table s Debug is on Query Timeout 0 Reident For Selected Table Procs Timeout 0 Reident For Selected Series Report Timeout 0 Perform Selected Maintenance Go 3 Choose the SQL object you wa
3. CHAPTER 8 USING MISCELLANEOUS TOOLS Module Tables copied Purchase Order Processing POP40100 POP40600 POP40400 POP40800 POP40900 POP00101 Advanced Financials AF40100 AF40107 AF40101 AF40108 AF40102 AF40109 AF40103 AF40110 AF40104 AF40200 AF40105 AF40201 AF40106 Extended Pricing 1V10400 SOP10108 1V10401 SOP10109 1V10402 SOP10110 1V10403 SOP10205 RM00500 SOP40709 Invoicing IVC40100 IVC40101 Human Resources BE020230 HRCOM022 RV010221 BE021030 HRDEP022 RV020221 BE031000 HRDIVO22 RV030221 HR70500 HRPBENO05 SK010230 HR2BEN11 HRPppc01 TAACO130 HR2BEN12 HRPROO22 TAST0130 HR2BEN13 HRSAX012 TAST0230 HR2BEN14 HRSAX022 TAST0330 HR2BEN21 HRSAX042 TAST0532 HR2DIVO2 HRTRA042 TATM0130 HR2TRAO1 HRTRPCO2 HR2TRAO3 HRTRPS01 Bill of Materials BM00101 BM00111 BM40100 PROFESSIONAL SERVICES TOOLS LIBRARY 67 CHAPTER 8 68 USING MISCELLANEOUS TOOLS Module Tables copied Manufacturing ADSK0700 BC010000 BM010115 BM010116 BM010200 BM010415 BM010416 BMPS0114 BMPF0114 BMUF0101 CO010000 COSS0401 CP010400 CP010530 CPUF0131 CT00001 CT00002 CT00003 CT00004 CT00005 CT00102 CT40401 DD010000 DD020000 DD030000 DW010013 DW010100 DWUF0130 EC020030 EC020230 EC030030 EC090000 ECPS0000 ECPU0000 ECUF0132 ICIV0323 ICJCO003 ICJCO004 ICJCO006 1CJC0007 ICJCO009 ICJC0125 IS050000 1S090000 ISSP0201 IVR10015 IVR10100 IVR40400 IVR40500 IVR50000 IVUF0130 JCP
4. C3 Payroll Payroll Transaction Entry CL Microsoft Dynamics GP O Technical Service Tools Select the ID for which you want to view the Certified Payroll Report Select Technical Service Tools from the Product drop down list Select Windows for the Type drop down list Expand the beside the Payroll folder Expand the beside Payroll Transaction Entry You should now see an option for Microsoft Dynamics GP or Technical Service Tools Select Technical Service Tools Click Save on the form 54 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 7 USING PAYROLL TOOLS 10 To create a shortcut right click in the Home menu and select Add gt gt Add Window Add SmartList Add Macro Add Web Page Delete Rename Folder Navigation Pane Options Add External Shortcut 11 Open Technical Service Tools gt gt Payroll and select the Certified Payroll Report Option Add Window Shortcut Interfund Management Microsoft Dynamics GP Purchase Order Enhancements Report Scheduler SmartList echnical Service Tools Financial 12 Choose Done and select Yes to save the changes PROFESSIONAL SERVICES TOOLS LIBRARY 55 CHAPTER 7 USING PAYROLL TOOLS To use Payroll Transaction Entry To use the Certified Payroll functionality simply enter a Job Number while entering Payroll transactions EM Payroll T
5. Enter the starting Site ID item Number Combiner Ele Edit Tools Help Cancel Starting Item Number ACCS CRD 12WH El Starting Item Description White Phone Cord 12 Combined into Item Number ACCS CRD 25BK El Combined into Item Description Phone Cord 25 Black Validate Import Convert FG ww Enter the Site ID to which the starting Site ID will be combined Choose Convert You will be prompted to back up your database Once you have a current backup of the database choose Continue The process is complete when a message appears Choose OK If Manufacturing is part of your solution you must run a full MRP Regeneration after the combine process has finished in order to complete the process for MRP tables Choose a report destination The report indicates what Site IDs were combined in the system PROFESSIONAL SERVICES TOOLS LIBRARY 39 CHAPTER 5 USING INVENTORY TOOLS Using Inventory Site Modifier This tool allows you to change the current Site Location Code to a new code without losing any data Refer to Using Validate and Import buttons on page 2 for information on the Validate and Import buttons which make it possible to import large amounts of data To change an inventory site 1 Enter the starting Site ID BA inventory Site Modifier File Edit Tools Help Cancel Starting Site ID NORTH KA Ending Site ID NORTHEAST Validate Import Convert J 2 Ent
6. My Computer Le Cae File name Changes tat Places Files of type All Files z Cancel 2 PROFESSIONAL SERVICES TOOLS LIBRARY INTRODUCTION A Report Destination window will appear Select the report destination to view a report verifying that information is valid If the report states that there is invalid data fix the spreadsheet and go through the validation process again Once the Validate report lists no invalid employee ID numbers the data is ready to be imported If you choose the Import button you will receive a message to choose Validate first The Validate button ensures that the tool will run properly In this example the Validate button will verify that each current employee ID number exists in your system before the conversion is performed After validating your data choose the Import button and choose the valid text spreadsheet When the data is done being imported you will receive a message stating that the Import function is finished Choose OK and close the modifier or combiner tool to receive another report destination window and view the report to see the changed data Compatibility information The following table lists the compatibility of modules in Microsoft Dynamics GP 2010 with the individual Professional Services Tools All of the tools are compatible with core modules Core modules include General Ledger Receivables Management Payables Management Sales Or
7. buttons a This tool requires that the user be logged in as sa To change a salesperson ID 1 Enter the Starting Salesperson ID 2 Enter the New Salesperson ID and choose Convert EX Salesperson Modifier File Edit Tools Help a Fabrikam Inc 4 12 2017 o Cancel Starting Salesperson ID ERIN J El New Salesperson ID ERIN M Validate Import 3 You will be prompted to backup your database Once you have a backup of the proper data choose Continue to begin the change process 4 A message signals the end of the Salesperson change process 5 Choose OK and close the Salesperson Modifier window to display a Report Destination window Select a report destination to view the Changed Salespersons report 30 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 4 USING SALES TOOLS Using Sales Order Processing Customer Item Lookup Use this tool to store customer specific ordering history as well as the last invoice date and the last price used and view that information from within Sales Order Processing Entry and the Sales Item Detail windows Customer item lookup setup 1 This tool modifies existing features within Microsoft Dynamics GP To activate the new functionality that this tool offers simply mark the second check box next to SOP Customer Item Lookup from the Professional Services Tools Library menu Close the window To build initial data from your existing history t
8. h A Microsoft Dynamics Microsoft Dynamics GP 2010 Professional Services Tools Library Copyright Limitation of liability Intellectual property Trademarks Warranty disclaimer License agreement Publication date Copyright 2010 Microsoft Corporation All rights reserved This document is provided as is Information and views expressed in this document including URL and other Internet Web site references may change without notice You bear the risk of using it Some examples depicted herein are provided for illustration only and are fictitious No real association or connection is intended or should be inferred This document does not provide you with any legal rights to any intellectual property in any Microsoft product You may copy and use this document for your internal reference purposes Microsoft Excel FRx SOL Server and Microsoft Dynamics are trademarks of the Microsoft group of companies FairCom and c tree Plus are trademarks of FairCom Corporation and are registered in the United States and other countries All other trademarks are property of their respective owners Microsoft Corporation disclaims any warranty regarding the sample code contained in this documentation including the warranties of merchantability and fitness for a particular purpose Use of this product is covered by a license agreement provided with the software product If you have any questions please call the Microsof
9. A message will appear when the employee ID change is finished 5 Choose OK and close the Employee Change window A Report Destination window will appear Choose a destination to view the Converted Employee IDs report PROFESSIONAL SERVICES TOOLS LIBRARY 53 CHAPTER 7 USING PAYROLL TOOLS Using the Certified Payroll Report Use the Certified Payroll Report with US Payroll to add a project number to employees hourly transactions and track them on a per project basis This tool will also capture information posted from the Timesheet Entry window in Project Accounting Timesheet Entry You can print these transactions on a weekly report and view employees departments job titles and pay codes by project Certified Payroll Report setup 1 This tool modifies existing features within Microsoft Dynamics GP To activate the new functionality that this tool offers simply mark the second check box next to Certified Payroll Report in the Professional Services Tools menu Close the window Open the Alternate Modified Forms and Reports window by choosing Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Alternate Modified Forms and Reports M Alternate Modified Forms and Reports File Edt Tools View Help fe Save Cla X Delete EE Copy ID DEFAULTUSER Description Default User Fe Product Technical Service Tools bd Type Windows v Altemate Modified Forms and Reports List
10. Customer PO Numbers should be checked For instance on a return you might not want to check for duplicate Customer PO Numbers because the customer could have multiple returns for a single Customer PO Number 5 Set the Required column for each SOP Type This will make the Customer PO Number field in Sales Transaction Entry a required field Like most required fields the user can delay entering this data but the Sales Document won t be saved until a value is entered 6 Set the Warning Type column for each SOP Type This specifies what the system should do if a duplicate PO number is found for a customer The following are the available actions Do Nothing Don t give any message or warning PROFESSIONAL SERVICES TOOLS LIBRARY 35 CHAPTER 4 USING SALES TOOLS Warn Only Presents the user with the message defined in the Message column for that SOP Type Only an OK button is displayed in the message because it is only a warning Warn and Ask Ifa duplicate is found the message defined in the Message column for that SOP Type will be displayed The user will be given a choice of Yes or No or Display If Yes is clicked the Customer PO Number is accepted If No is clicked then the user must re enter a different Customer PO Number If Display is clicked a window will open that shows the records that the PO Number was found on Warn and Reject Presents the user with the message defined in the Mes
11. Edit Tools Help bk Save Cancel Marked Customers will not have Customer PO Number in SOP Entry required Customer Number IV 4ARONFITOON Al ADAMPARKODOI ADVANCEDODOT ADVANCEDO002 ALTONMANODO AMERICANODO1 AMERICANOD02 F ASSOCIATOON F ASTORSUIO001 I F ATMOREROOO1I F BAKERSEMOODI F BERRYMEDOOOI BLUEYONDOO01I BOvLESCOO001 z Mark All Unmark All 2 Mark the customers for which the Customer PO Number is not required In the illustration above the customer AARONFIT0001 will never have the Customer PO Number field marked as required even though it was marked required in the Customer PO Validation Setup window PROFESSIONAL SERVICES TOOLS LIBRARY 37 38 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 5 Using Inventory Tools This chapter explains how to use the Inventory Series Professional Services Tools Information is divided into the following sections Using Inventory Site Combiner Using Inventory Site Modifier Using Item Description Modifier Using Item Number Combiner Using Item Number Modifier Using Item Reconciler Using Inventory Site Combiner This tool allows you to combine Site Location Codes without losing any data Refer to Using Validate and Import buttons on page 2 for information on the Validate and Import buttons which make it possible to import large amounts of data To combine an inventory site 1
12. Field Service SmartList Project Accounting Microsoft Dynamics CRM Item Description Modifier Core Modules Project Accounting Microsoft Dynamics CRM Inventory Site Modifier Core Modules Manufacturing Field Service Project Accounting Microsoft Dynamics CRM Inventory Site Combiner Core Modules Field Service Project Accounting Microsoft Dynamics CRM Salesperson Modifier Core Modules Collections Management Territory Modifier Core Modules Collections Management Microsoft Dynamics CRM Territory Combiner Core Modules Collections Management Microsoft Dynamics CRM Vendor Modifier Core Modules Analytical Accounting Manufacturing SmartList Project Accounting 4 PROFESSIONAL SERVICES TOOLS LIBRARY INTRODUCTION Tool name Compatible modules and features Vendor Combiner Core Modules Analytical Accounting Manufacturing SmartList Project Accounting Vendor Name Modifier Core Modules Project Accounting If you would like to purchase any of the tools included in the Professional Services Tools Library or if you have any questions please contact ProfessionalServices microsoft com There are several other tools and services delivered by Microsoft Some of the services bid on an hourly basis and miscellaneous tools are listed below Contact ProfessionalServices microsoft com for a more complete list of the tools and services available S
13. Payroll Report Once transactions have been posted with information about the Job Number users can access the Certified Payroll Report from whichever palette was chosen during setup Typically this would be the Payroll Transactions palette 1 Open the Certified Payroll Report window PA Certified Payroll Report File Edit Tools Help Z Clear BH Print Job Numbers C Al From J1 To J10 Ending Date of 7 Day Period 4 13 2007 IV Print Report Headings IV Print Signature Paragraph 2 Mark All jobs or enter a range of jobs 3 Choose the Ending Date of the 7 day period to be printed on the report All transactions for the week that ends on the date specified and meets the range of Job Numbers will print on the report 4 Mark Print Report Headings to manually enter the Contract and Contractor information 5 Mark Print Signature Paragraph to print a paragraph on your report stating your certification that the payroll is correct and complete and the wage rates are valid according to the Secretary of Labor 6 Choose Print to print the report The information that prints on the report is summarized for each employee within each job Each employee could have several line items for a single job if the employee used different pay codes job titles or departments during the week period Each employee could have different line items on more than one job report if the employee worked on more than one job during the wee
14. any company that you set up to use Professional Services Tools Library and will not need to be reentered for each company The initial installation creates many tables and stored procedures and may take several minutes to finish 8 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 1 INSTALLING PROFESSIONAL SERVICES TOOLS LIBRARY 10 Open Professional Services Tools Library from the Home menu File Edit Tools Help Debug sa y Inc Active Enable Active Enable Active Enable Version 11 0 0 System Tools Purchasing Tools Cont Inventory Tools M Database Disabler v V Minimum PO Receipt t v Inventory Site Combiner v Shortcuts Copy M POP Cost Defaulter r2 C Inventory Site Modifier Microsoft vi amp Toolkit vi C ltem Description Modifier Dyna micscp E Menu Inquiry Utility Sales Tools E f item Number Combiner v Update User Date r2 Customer Combiner v Item Number Modifier v Customer Modifier v f tem Heconcien v Customer Name Modifier Financial Tools v RM Master Triggers Misc Tools v C Acct Modifier Combiner v RM Transaction Unapply v Fixed Asset Modifier
15. be logged in as sa To change a vendor name 1 In the Starting Vendor Number field enter the name that you want to modify The existing Starting Vendor Name will automatically appear 2 Inthe Ending Vendor Name field enter the name you want to change to choose Convert to update records Refer to Using the Using Validate and Import buttons on page 2 for information on importing data EM Vendor Name Modifier File Edit Tools Help o Cancel a Fabrikam Inc 4 12 2017 Starting Vendor ID ALLENSONOON Starting Vendor Name Allenson Properties Ending Vendor Name Allenson Properties Inc Validate Import Convert Lo 3 You will be prompted to back up your database Choose Continue once you have a backup of the database A message will signal the end of the vendor name change 4 Choose OK and close the Vendor Name Modifier window A report destination window will appear Choose a destination for the report to view a Vendor Descriptions Modified report 50 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 6 USING PURCHASING TOOLS Using POP Cost Defaulter Use this tool to specify the default cost for a purchase order document To set up the POP Cost Defaulter select POP Cost Defaulter in the Professional Services Tools Library and click Next PM Pop Cost Defaulte File Edit Tools Default Cost on PO from amp amp Current Cost C Standard Cost
16. been paid but were entered posted while the vendor was not set up as a 1099 vendor those records will not be changed You need to execute this tool the next year prior to printing 1099 reports to be sure that work and open records that were paid in the new year get updated To update 1099 amounts 1 Set the vendor up as a 1099 vendor by selecting that option on the Vendor Card 2 Once the vendor is marked as a 1099 vendor open the 1099 Modifier tool from the Professional Services Tools Library menu EM 1099 Modifier File Edit Tools Help Q Cancel Print Report Only Process and Print Report Calendar Year 2010 Process Ie 3 Select whether you would like to Print Report Only or Process and Print Report The Print Report Only option shows you the Vendor Voucher Number and Amount that will be converted to a 1099 amount The Process and Print Report option makes the changes prints the report and prints an updated Summary records report for the 1099 amount 4 Select the calendar year to which you want to make the changes PROFESSIONAL SERVICES TOOLS LIBRARY 45 CHAPTER 6 USING PURCHASING TOOLS You will be prompted to back up your database Choose Continue once you have a backup of your database A message will signal when the 1099 Modifier has finished processing If you selected Process and Print Report you may get an additional report showing summary table changes that have been made to the 1099
17. ces SetMinimum Check Amount zm Batch ID ai Checkbook ID Batch Total 0 00 Currency ID 2 Select Vendor by Vendar ID x Al C From r To ES Select Document by Voucher Number Al C From F To F Due Date Cutoff None C Due Date Discount Date Buta 4 None C Discount Date Select Documents Functional Currency Only v One Check Per Vendor Automatically Apply Existing Unapplied T Take Non Qualifying Discounts IV Payments Credit Memos IV Retums Pay Only Minimum Functional Currency Only All Currencies Apply Date 4 12 2017 H Remittance Print Checks List Documents All Documents v v Print Previously Applied Documents Edit Check Batch Sort Documents by Date F Use Due Date Cutoff Edit Check Toi To change the Minimum Check amount choose Additional gt gt Set Minimum Check Amount The Minimum Select Check Amount window will appear EM Minimum Select Check Amount x Fie Edit Tools Help Minimum Check Amount 201 00 Enter the new minimum check amount in the Minimum Check Amount field You can turn the minimum check amount on or off by marking or unmarking the Use Minimum Amount check box The settings are per machine and stored in the Dex ini for use in the next check build process for example MinPMCheck 201 00 PROFESSIONAL SERVICES TOOLS LIBRARY 47 CHAPTER 6 USING PURCHASING TOOLS Using Select Checks Combiner Use this tool to consolidate checks to match the same vendor when users
18. not fall within a valid fiscal period a message will be displayed and the user will not be allowed to continue until the date is in a valid period If the Document Date falls within a period that is closed a message will be displayed that will allow the user to correct the date or continue on leaving the date This functionality is available in the following windows Payables Transaction Entry Receivables Transaction Entry Invoice Entry Payables Manual Payment Entry Sales Transaction Entry Inventory Transaction Entry Cash Receipts Entry Purchase Order Entry Receivings Transaction Entry Purchasing Invoice Entry To activate this tool simply mark the second check box next to Doc Date Verify in the Professional Services Tools Library window 62 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 8 USING MISCELLANEOUS TOOLS Using Decimal Place Tool When the Decimal Place tool is activated both Payables Management checks and Payroll checks will have the Check Amount in Words truncated to two decimals This tool would be used if the currencies in Microsoft Dynamics GP were changed to more than two decimals In this situation the checks will print with more than two decimals which can alter the amount of the check The Decimal Place tool will adjust the Check Amount in Words portion to two decimal places sl The Decimal Places Tool will change only the Check Amount in Words portion of the check To change the actual amount
19. only user who is logged into Microsoft Dynamics GP when the operation is performed e The operation can take a significant amount of time to complete so you should consider performing it during off peak hours To copy company setup 1 Select the source company and the destination company company Copy x File Edit Tools Help sa Fabrikam Inc 4 Process Cancel Source Company TWO A Destination Company TEST Select Data and or Report Options to copy data from Source to Destination Company 4 Data 4 Report Options Select which modules you wish to copy from Source to Destination Company For more information on the tables involved in the process please check the help file v All Modules 4 Payroll 4 Extended Pricing Company Payables Invoicing Financial Receivables Human Resources Inventory Fixed Assets Multicurrency Purchase rder Processing Bill of Materials Advanced Financials Project Accounting SIS Sisis SIS SSS v v Sales Order Processing 4 Manufacturing v v J 2 Indicate what information you want to copy to the destination company You can copy setup data report options or both You must mark at least one of the options 3 Select the modules for which you want information to be copied If you mark All Modules all of the modules listed will be marked Be aware of these guidelines e If Report Options is selected Company must be marked e When the Data
20. r subeant eoe eedem redet 53 Using the Certified Payroll Report 54 Chapter 8 Using Miscellaneous Tools 59 Using Fixed Asset Modifier eret inti die eee desiit 59 Using Minimum PO Receipt Number 60 Using Default Add Item POP SQP e ete be eter eee ln la a tla 61 Using DeDate Verifye ati ierant deren eda ab eden na 62 Using Decimal Place Tool noe nt se ne nt ce e ede et te dee eee Steed 63 Using Company Copy ie detect pide tire dri tte deben di tete Jal 64 ii PROFESSIONAL SERVICES TOOLS LIBRARY Introduction The Professional Services Tools Library is designed for use with Microsoft Dynamics GP This document contains descriptions and information about the functionality of each tool as well as how to implement the tools available in the Professional Services Tools Library Information is divided into the following sections Before you begin Using Validate and Import buttons Compatibility information Send us your documentation comments Before you begin This section includes information and precautions that will help you use Professional Services Tools Library more effectively Making backups Before running any tool make a backup of the databases that will be affected It is important to make a backup of your Microsoft SQL Server data Many of the tools will prompt users to back up their data before being allowed to execute the command selected Make a backup before continuing with t
21. ss 28 Using Receivables Management Transaction Unapply sese 29 Using Salesperson M difier rsrsrs teer e e reete rie tet Dr e ete A Using Sales Order Processing Customer Item Lookup Using Territory MOdifier ttes ennemie intestinal Using Territory Combin r transit aa n u pe erret re deest drei fag cete testet iatis 34 Using SOP PO Number Check che ope ope eire e epo te ate ie 35 Chapter 5 Using Inventory Tools 39 Using Inventory Site Combiner cte ree tete tpe ho anses 39 Using Inventory Site Modifiet 5 ceca e eene c oan ch e iva e nre 40 Using Item Description Modifier 54h mendo een Re Re tite 41 Using Item Number Combiner tn tete reperti ren etre ie ne nee 42 Using Item Number Modifier assis eene eti e e ie ia ii 43 Using Item Reconciler Chapter 6 Using Purchasing Tools 45 Using 1099 Modifiet cerent e naines i oiiaee E aet Bla a ta 45 Using Payables Management Master Record Triggers ss 46 PROFESSIONAL SERVICES TOOLS LIBRARY i CONTENTS Using Payables Management Minimum Check Using Select Checks Combinet eet teret te dee eene e Erde Using Vendor Combiner Using Vendor Modifier deo ede a Halal a tn pedes Using Vendor Name Modifier noni eri em eed tet ete ene 50 Using POP Cost Defaulter tace remet ie oe irre p e eere HN 51 Chapter 7 Using Payroll Tools 53 Using Employee Modifi
22. 0 GL40000 Inventory 1V00101 IV00113 1V40700 IV00102 IV00114 1V40701 IVO0103 IV00115 IV40702 IV00104 IV40100 IV40800 IV00105 IV40201 IV40900 IV00106 1V40202 IV41000 1V00107 IV40400 IV41001 IV00108 IV40401 IV41100 IV00109 IV40500 IV41101 IV00110 IV40600 IV41102 IV00111 PROFESSIONAL SERVICES TOOLS LIBRARY 65 CHAPTER 8 66 USING MISCELLANEOUS TOOLS Module Tables copied Fixed Assets FA00100 FA01401 FA41300 FA00200 FA19900 FA41400 FA00300 FA40200 FA41500 FA00400 FA40201 FA41600 FA00500 FA40202 FA42100 FA00600 FA40203 FA42200 FA00902 FA40300 FA42400 FA00904 FA41000 FA42500 FA01100 FA41100 FA49900 FA01400 FA41200 Multicurrency MC00201 MC00200 MC40000 MC40100 MC40201 MC40301 MC40500 MC60400 Payroll DD40700 UPR40901 UPR40100 UPR40902 UPR40101 UPR41100 UPR40104 UPR41200 UPR40200 UPR41201 UPR40201 UPR41400 UPR40300 UPR41401 UPR40301 UPR41500 UPR40500 UPR41700 UPR40501 UPR41800 UPR40600 UPR41801 UPR40700 UPR41900 UPR40800 UPR41901 UPR40801 UPR41902 UPR40900 UPR42000 Payables PM00100 PMO0101 PMO0200 PMO0203 PM00300 PM40100 PM40102 PM40103 Receivables RM00101 RM40201 RM00102 RM40401 RM00105 RM40501 RM00201 RM40601 RM00301 RM40102 RM00303 RM00106 RM00305 PA00002 RM40101 Sales Order Processing SOP00100 SOP40600 SOP00200 SOP00300 SOP40100 SOP10111 SOP40200 SOP40101 SOP40201 SOP60200 SOP40300 SOP60300 SOP40400 SOP00300 SOP40500 PROFESSIONAL SERVICES TOOLS LIBRARY
23. 000 new item numbers one at a time you can save time by importing a two column spreadsheet into modifier and combiner tools Preparing your spreadsheet data 1 Enter existing system data such as the Vendor ID numbers or Item numbers in the first column of data in the spreadsheet 2 Thesecond column of data should contain the new ID or number as you would enter it in the appropriate field of the respective tool If you are entering account numbers in your spreadsheet be sure to include dashes 3 Save your spreadsheet as a text file The spreadsheet must be saved as a text file in Microsoft Excel tab delimited file to ensure that information in Microsoft Dynamics GP is updated correctly Validating and importing your data A typical example of the Validate and Import function functionality would be during an Employee ID change BRA Employee Modifier File Edit Tools Help Cancel Starting Employee ID ACKE0001 New Employee ID ACKERS0001 Validate Import Convert 1 Choose the Validate button first Select the file and choose Open to start the validation process Please select the Employee file to import x Look in lt Local Disk C z CHERS Apps wmpub ages ta DevStudiolnstalls Documents Documents and Settings FPSE search Ginseng Desktop D Inetpub MS Cache Program Files My Documents SourceDepot T Projects SE temp
24. 4 This tool requires that the user be logged in as sa To combine vendor IDs 1 Enter the existing vendor ID that you want to combine and remove in the Starting Vendor ID field and the vendor ID to which you want to combine in the Combine into Vendor ID field Choose Convert BA Vendor Combiner File Edit Tools Help o x 4 12 2017 a Fabrikam Inc Cancel Starting Vendor ID ADVANCEDODU Al Starting Vendor Name Advanced Office Systems _ Combine into Vendor ID ALLENSONOOO1 Combine into Vendor Name Allenson Properties Inc Validate Import Convert ay LC 2 You will be prompted to make a backup of your database Once you have a backup of the database choose Continue A message signals the end of the vendor combine 48 PROFESSIONAL SERVICES TOOLS LIBRARY A CHAPTER 6 USING PURCHASING TOOLS 3 Choose OK and close the Vendor Combiner window A Report Destination window will appear Choose a destination to view the Combined Vendors report If you execute a Vendor Combine and both Vendor IDs are linked to Employee IDs you will receive an error and the records remain unchanged Even though you can combine Vendor records you can not combine Employee records Using Vendor Modifier r Use this tool to change an existing vendor ID to a new vendor ID You will not have to manually enter a new vendor ID and reenter all open invoices You can use the Vendor Modifier to update
25. A44013 PA01301 PA40203 PA60020 PA01303 PA40501 PA60030 PA01304 PA40601 PA60040 PA01402 PA40701 PA61020 PA01403 PA40801 PA61040 PA01405 PA40901 PA91301 PA01406 PA41001 PA91304 PA01407 PA41101 PA92301 PA01408 PA41201 PA92304 PA01409 PA41301 PDK00101 PA01410 PA41302 PDK00102 PA02000 PA41303 PDK00300 PA02010 PA41304 PDK00301 PA02101 PA41401 PDK00700 PA02301 Report options tables copied The following is a listing of the report options tables that are copied for each module in the Company Copy tool Module Tables copied Company SY70100 SY70200 SY70300 SY70400 SY70500 SY70501 SY70600 Financial GL70500 DTA00700 LK4000 LK40001 PROFESSIONAL SERVICES TOOLS LIBRARY 69 CHAPTER 8 70 USING MISCELLANEOUS TOOLS Module Tables copied Inventory 1V70500 Fixed Assets FA45000 FA45100 Payroll UPR70500 UPR70501 Payables PM70500 Receivables RM00700 RM40501 Human Resources HR70500 Project Accounting PA70101 PDK70101 PDK70300 PROFESSIONAL SERVICES TOOLS LIBRARY
26. In the POP Cost Defaulter window select what cost you would like to default from the item in the PO Entry window Typically the Last Invoice Cost is defaulted from Cards gt gt Inventory gt gt Vendors Once POP Cost Defaulter is activated either the Current or Standard Cost will be defaulted based on your selection To activate this tool simply mark the second check box next to POP Cost Defaulter in the Professional Services Tools Library window PROFESSIONAL SERVICES TOOLS LIBRARY 51 52 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 7 Using Payroll Tools This chapter explains how to use the Payroll Series Professional Services Tools Information is divided into the following sections e Using Employee Modifier Using the Certified Payroll Report Using Employee Modifier This tool allows the user to change an existing employee ID to a new employee ID without losing any work open or history records If you plan to import large amounts of data refer to Using Validate and Import buttons on page 2 to use the Validate and Import buttons To change an employee ID 1 Enter the Starting Employee ID PM Employee Modifier Ele Edit Tools Help o Cancel Starting Employee ID ACKE0001 Al New Employee ID ACKERS0001 Validate Import Convert a 2 Enter the new Employee ID 3 Choose Convert You will be prompted to back up your database Once a backup is made of the database Choose Continue 4
27. Information is divided into the following sections Using Customer Combiner Using Customer Modifier Using Customer Name Modifier Using Receivables Management Master Record Triggers Using Receivables Management Transaction Unapply Using Salesperson Modifier Using Sales Order Processing Customer Item Lookup Using Territory Modifier Using Territory Combiner Using SOP PO Number Check Using Customer Combiner Use this tool to combine a customer number into another customer number without losing any data The Customer Combiner removes old customer numbers from the system and recalculates the Summary records to include both customers summary information If you need to import large amounts of data refer to Using Validate and Import buttons on page 2 s r This tool requires that the user be logged in as sa To combine customer numbers 1 Enter the Starting Customer number and the customer number you want to combine it with Choose Convert Customer Combiner B x File Edit Tools Help sa Fabrikam Inc 4 12 2017 Cancel Starting Customer Number AARONFITOOO Starting Customer Name Aaron Fitz Electrical Combined Into Customer Number ADAMPARKODOT Combined Into Customer Name Adam Park Resort Validate Import Convert 2 You will be prompted to back up your data Once you possess a current backup continue with the Customer Combiner proce
28. LS LIBRARY 31 CHAPTER 4 USING SALES TOOLS A 4 The new Customer Item Lookup window is now available from the SOP Entry and the SOP Item Detail windows You can open the lookup window by pressing CTRL H or by choosing Additional gt gt Customer Item Lookup The window displays the historical purchasing information for this customer and the most recent price for each item purchased By highlighting a record you can zoom back to the SOP Document Inquiry window As Invoice documents are posted new entries are added to the table that stores the Customer Item historical data Customer Item Lookup jo x File Edit Tools Help 0 sa Fabrikam Inc 10016 Find by Item Number 2 8 31 2017 3 8 31 2017 139 50 2 8 31 2017 187 00 1 4 12 2017 89 95 3 412 2017 9 95 1 4 12 2017 3 B3813A 3 C2924A Each 3 EAATIA Each ACCS HDS 2EAR Each ACCS RST DXWH Each FAXX CAN 8800 If a customer purchases the same item in two different unit of measure codes both records will show in the Customer Item Lookup window However the unit of measure and price that will appear is based off of the item s default unit of measure If the unit of measure changes within a sales document a new price will become the default 32 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 4 USING SALES TOOLS Using Territory Modifier This tool allows changes in territory IDs to take place and the
29. NAL SERVICES TOOLS LIBRARY 15 CHAPTER 2 USING SYSTEM TOOLS Select a Command from the resulting Categories Commands list on the right hand side to display the command properties at the bottom of the Menu Inquiry window Checkmarks designate certain properties of the command e Ifthe Enabled box is checked the command is enabled e If the Checked box is checked the command or option has been selected and activated within Microsoft Dynamics e If the Visible box is checked the command or option is visible and accessible To open the corresponding window for the command click on the gears icon next to the Tag heading If the gear icon appears unlit or gray this option is unavailable for the command selected Using Update User Date Utility The Update User Date utility will automatically update the User Date in Microsoft Dynamics GP to the next date at midnight each day The application will run in the background as long as Microsoft Dynamics GP is open To activate this tool simply mark the second check box next to Update User Date in the Professional Services Tools Library window In order for the Update User Date utility to work properly you will need to have SuppressDateChangeDialog TRUE in the Dex ini file to suppress the date dialog that will be displayed if Microsoft Dynamics GP is left open over the midnight hour 16 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 3 Using Financial Tools This chapter explai
30. New Value 222 Convert 1 Repopulate Column List po When using the Range convert option combines cannot be done If any of the changes require a combine the change will not take place If combines are required for many accounts use the Import option This table is an example showing what would happen if segment 1 was changed from 111 to 222 Range of accounts selected New account structure 111 1111 11 222 1111 11 111 1111 12 222 1111 12 111 1111 13 222 1111 13 111 1111 14 222 1111 14 111 1111 15 222 1111 15 111 1111 16 222 1111 16 111 1111 17 222 1111 17 111 1111 18 222 1111 18 111 1111 19 222 1111 18 111 1111 20 222 1111 20 PROFESSIONAL SERVICES TOOLS LIBRARY 19 CHAPTER 3 USING FINANCIAL TOOLS 20 3 When the process is finished choose OK You will be asked if you want to combine any accounts 4 If you choose No you will receive a report describing which accounts were modified If you have accounts that you wish to combine choose Yes to make the tool combine those accounts 5 When the combine process is complete you will receive a prompt to reconcile your open and historical years 6 Choose a report destination The report will list all the account modifications and combinations that took place as well as all accounts that were modified and combined If you are running FRx 6 5 Service Pack 5 or hi
31. Origin Type Document Number Document mount Amount Remaining Applied A Doc Date Due Date Discount Amount Writeoff Amount Check Number Currency ID Y OPEN SLS RMADO3001 933 58 933 58 A OPEN SLS SLS13014 6 500 00 8 500 00 OPEN SLS SLS13015 5 470 19 5 445 19 M HIST SLS SL53002 1 569 57 0 00 vi OPEN SLS SLS3004 12 535 76 2 535 76 HIST SLS STDINV2028 641 47 0 00 v OPEN SLS STDINV2225 96 25 96 25 OPEN SLS STDINV2229 32 567 35 32 567 95 I4 4 b bi by Customer ID po 2 Choose the document numbers or dates for which you want to unapply the transactions Mark All to unapply all documents or enter a range of documents in the From and To fields 3 You will be prompted to verify that you want to unapply the documents Choose Unapply to continue You can also view the report only or cancel 4 Choose a report destination to view a report with information about the unapplied transactions PROFESSIONAL SERVICES TOOLS LIBRARY 29 CHAPTER 4 USING SALES TOOLS Using Salesperson Modifier Use the Salesperson Modifier tool to change current Salesperson IDs The result is a new Salesperson ID with no data lost or having to be reentered into the system If you plan on importing large amounts of data please refer to Using Validate and Import buttons on page 2 where there is information about the Validate and Import
32. P SOP Doc Date Verify Decimal Place Tool The Next button will be unavailable once the second check box is marked for certain tools that do not require further setup If additional products are installed all 3rd party tables should be tested for validation PROFESSIONAL SERVICES TOOLS LIBRARY 9 CHAPTER 1 INSTALLING PROFESSIONAL SERVICES TOOLS LIBRARY Entering new registration keys If you decide to purchase additional tools at a later date and receive a new registration key you can easily change the registration key 1 Choose the Registration button on the main window 2 Log in with the sa login and you can automatically re create all objects for the Professional Services Tools Library The registration key can be entered from any company that you set up to use Professional Services Tools Library and will not need to be reentered for each company Security setup i AN AN e You can add a Professional Services Tools Library task to an existing security task or create a new task Once a security task is created you can either add the task to an existing role ID or create a new role ID The instructions provided demonstrate how to create a new task new role ID and apply the new role ID to a user through User Security Setup Predefined security tasks and roles are not set up in Microsoft Dynamics GP for Professional Services Tools Library If you want to log in as a user other than sa you must set up se
33. ROFESSIONAL SERVICES TOOLS LIBRARY 27 CHAPTER 4 USING SALES TOOLS Using Receivables Management Master Record Triggers A Use this tool to create customer and customer address master records and replicate records to another database on the same server You can also choose to replicate these records to some or all of your companies If you are using Integration Manager to import account customer or vendor master records to the main company database and the integration fails for any reason any records imported to the main company database will be deleted rolled back However if you have enabled master record triggers the records will be replicated to company databases that you specify in the Replicate To DB field and will not be rolled back You must delete such replicated records manually To create and update customer and customer address master records 1 In the Master DB field choose the database where you will be creating or updating records M Master Triggers Setup Ele Edit Tools Help oK Master DB Replicate To DB Accounts Vendors Customers TWO TEST V E 2 Inthe Replicate To DB field choose the database to which the master records will be copied 3 Mark the Customers option You will not be able to select an option if you are not registered for that particular Master Trigger 4 Close Master Triggers Setup When you create or update a ma
34. S0040 LC010014 MFGEXTO 1 MFUF0101 MM010032 MMUF0130 MN010000 MNH10000 mops0100 MPPS0230 MP030000 MP040000 MPPU0130 MPSF1000 MPUF0130 MRP6060 OC010000 OC010100 OC010200 OC010300 OC010400 OCUF0010 PC010000 PFH10000 PRPF0113 OA100032 OA100132 OA100332 OA100232 OA110132 OA110232 OA120032 A140032 OA150032 OA160032 OADUF132 OAPS0032 RT010001 RT010400 RTH10100 RTPS0130 RTPU0130 RTUF0130 RTW20000 SC020030 C020130 SC020230 SC020330 SC020430 C020730 SCSU0010 SCUFO101 SFUF0130 SO030000 SP010016 SP010100 TARD1001 WC010015 WC010100 WC010200 WC010300 WC010400 WC010500 WC010600 WC010800 WC010714 WC010931 WCO01100 CTE0000 WCUF0130 WCTEHDOO WOUF0132 WPPS0114 WPPU0114 WRUF0130 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 8 USING MISCELLANEOUS TOOLS Module Tables copied Project Accounting GST00111 PA02401 PA41409 PA00401 PA02501 PA41501 PA00402 PA02601 PA41601 PA00501 PA02701 PA41701 PA00502 PA05200 PA41701A PA00503 PA12000 PA41801 PA00504 PA12001 PA41901 PA00511 PA12101 PA42001 PA00512 PA12102 PA42201 PA00601 PA12103 PA42401 PA00701 PA13201 PA42501 PA00801 PA23201 PA42601 PA00901 PA23400 PA42602 PA01001 PA23401 PA42701 PA0O1101 PA23500 PA42801 PAO1111 PA23501 PA42802 PA01121 PA23502 PA42901 PA01122 PA33701 PA42902 PA01141 PA33702 PA43001 PA01201 PA40020 PA43002 PA01202 PA40030 PA43101 PA01211 PA40102 PA43102 PA01221 PA40101 PA44011 PA01222 PA40201 PA44012 PA01241 PA40202 P
35. UI Required Warning Type Password Message E Quote r2 Both Do Nothing Order v Both M Warm and Ask M PO Number 1 already exists for this customer on Sales M x S 3 M Warm and Ask Invoice v Both v PO Number 1 already exists for this customer on Sales 3 Retum M Both I Do Nothing Back Order v Both M v v War and Ask PO Number 1 already exists for this customer on Sales 2 3 Fulfillment Order v Both M v Wam and Ask PO Number 1 already exists for this customer on Sales 2 3 For the Message the below symbols will be replaced by the actual values 1 PO Number 3 Document Number 2 Document Type 2 Set the Check DB column for each SOP Type When marked the SQL database will be examined documents of the specified type that have duplicate Customer PO numbers For instance it might not matter that a duplicate Customer PO Number was entered on a Quote document In that case you would not mark the Check DB column for Quote documents and the check would not be performed 3 Set the Which Tables column for each SOP Type This column specifies which types of tables should be searched Choose Work History or Both The default is Both 4 Set the Check on UI column for each SOP Type This field is to determine from the User Interface whether or not duplicate
36. ables choose Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt Sales gt gt Sales Order Processing to open the Sales Order Processing Setup window Choose Create Initial Data from the Additional menu This process could take some time depending on how much historical SOP Line Item data exists You will receive a message when processing is finished You must be logged in as sa do the initial data creation M Sales Order Processing Setup sa Fabrikam Inc Document Defaults sat Site ID WAREHOUSE QD ransactions in History Checkbook ID UPTOWN TRUST AL IV Calculate Kit Price Based on Component Cost Quote ID STDQTE IUE Y IV Display Quantity Distribution Warning Order ID STDORD KAL Search for New Rates During Transfer Process Fulfillment Order ID KAL IV Track Master Numbers Invoice ID STDINV AIT y Next Master Number 402 Back Order ID BKORD KAL Prices Not Required in Price List Retum ID RTN SR Giai Posting Accounts From Tone Item Customer Data Entry Defaults Maintain History Quantity Shortage Override Shortage z V Quote V Invoice Retum Document Date Previous Doc Date M Order IV Account Distributions quee Eep os Decimal Places for Norrinventoried Items Requested Ship Date ocument Date Queries 0 Carer B Sales Document Setup User Defined Numbers Options SU Cs PROFESSIONAL SERVICES TOO
37. age will signal the end of the Item Description Modifier 5 Choose OK and close the Item Description Modifier window A report destination window will appear 6 Choose a destination for the report to view an Item Descriptions Modified report PROFESSIONAL SERVICES TOOLS LIBRARY 41 CHAPTER 5 42 INVENTORY TOOLS Using Item Number Combiner Use the Item Number Combiner to combine existing item numbers The old item number is removed from the system after the combine process is finished All Work Open and History records are combined into the new item number Refer to Using Validate and Import buttons on page 2 for information on the Validate and Import buttons which make it possible to import large amounts of data If you are using Bill of Materials or Manufacturing with Bill Of Materials you can NOT combine parent objects only child objects will be able to be combined This tool requires that the user be logged in as sa To combine an item number 1 Choose the starting item number BA item Number Combiner File Edit Tools Help a Fabrikam Inc 4 12 2017 Q Cancel Starting Item Number ACCS CRD 12WH A Starting Item Description White Phone Cord 12 Combined into Item Number ACCS CRD 25BK El Combined into Item Description Phone Cord 25 Black Validate Import Convert Go 2 Choose the item number to which you want to combine in the Combined Into Item Number field 3 C
38. all work open and history records while ensuring data integrity at the same time If you plan to import large amounts of data refer to Using Validate and Import buttons on page 2 to learn how to use the Validate and Import buttons If a Vendor record is linked to an Employee through the Project Accounting Module the Employee Modifier code will automatically execute to keep the Vendor and the Employee synchronized throughout the system and prevent orphaned records in the database This tool requires that the user be logged in as sa To change a vendor ID 1 Enter the Starting Vendor ID and the New Vendor ID in the window and choose Convert BA Vendor Modifier File Edit Tools Help o Cancel Starting Vendor ID AMERICANODOT El New Vendor ID AMERICANODO2 Validate Import Convert D 2 You will be prompted to back up your database Choose Continue once you have a backup of the database A message will signal the end of the vendor change 3 Choose OK and close the Vendor Modifier window A report destination window will appear Choose a destination for the report to view a Changed Vendors report PROFESSIONAL SERVICES TOOLS LIBRARY 49 CHAPTER 6 USING PURCHASING TOOLS Using Vendor Name Modifier Use this tool to change the Vendor Name You can change an existing vendor name to anew vendor name without any loss of work open or historical records a This tool requires that the user
39. amount field The number under the Amount After heading is the amount that prints on your 1099 reports Close the 1099 Modifier window A report destination window will appear Choose a destination for the report to view a 1099 Modified Records report This report shows the specific vouchers that were changed to 1099 amounts Using Payables Management Master Record Triggers A This tool allows you to add a vendor and vendor address master record and replicate records to another database on the same server You can also choose to replicate these records to some or all of your companies If you are using Integration Manager to import account customer or vendor master records to the main company database and the integration fails for any reason any records imported to the main company database will be deleted rolled back However if you have enabled master record triggers the records will be replicated to company databases that you specify in the Replicate To DB field and will not be rolled back You must delete such replicated records manually To create and update vendor and vendor address records In the Master DB field choose the database where you will be creating or updating records Wi Master Triggers Setup File Edit Tools Help v OK Master DB _Replicate To DB Accounts Vendors Customers TWO BII TEST M F IL EE a C In the Rep
40. are appending to an existing checks batch This can be useful if users frequently build batches of Payables checks and select different document number ranges or date ranges To activate Select Checks Combiner 1 This tool modifies existing features within Microsoft Dynamics GP To activate the new functionality that this tool offers simply mark the second check box next to Select Checks Combiner from the Professional Services Tools Library menu Close the window 2 If a check exists for a vendor when checks are rebuilt new amounts will be added to the existing check instead of issuing multiple checks This only applies if the One Check Per field is set to Vendor in the Select Payables Checks window Using Vendor Combiner Use the Vendor Combiner tool to combine a current vendor ID with another existing vendor ID The original vendor ID is removed from the system after the combine process is finished Data integrity is ensured as no data is lost and work open and history records are combined into the new vendor Refer to Using Validate and Import buttons on page 2 for information on the Validate and Import buttons which make it possible to import data If one of the Vendor records is linked to an Employee through the Project Accounting Module the Employee Modifier code will automatically execute to keep the Vendor and the Employee synchronized throughout the system and prevent orphaned records in the database vl
41. as to be marked the first time running the tool after loading a new dictionary Account Modifier Combiner File Edit Tools Help o x a Fabrikam Inc 4 12 2017 Q Cancel Select By C Rangel Account C Import Account Number i Convert To Account Number s Convert 1 Repopulate Column List po PROFESSIONAL SERVICES TOOLS LIBRARY 17 CHAPTER 3 USING FINANCIAL TOOLS Account Modifier You can manipulate an account number with the Account Modifier by changing a single account number into a new account number or by changing an entire range of accounts All of the open and historical information can change without any loss of data To change an account number 1 Enter the old account number in the Account Number field 2 Enter the new account number in the Convert To Account Number field 3 After entering the account numbers choose Convert to make the change throughout the system MA Account Modifier Combiner File Edit Tools Help sa Fabrkam Inc 4 12 2017 o Cancel Select By C Rangel Account Import zl Account Number 000 1100 00 i Convert To Account Number 000 1101 00 A Convert 219 Repopulate Column List 4 When the process is finished choose OK You will be asked if there are any combines to perform 5 If you choose No you will receive a report describing which accounts were modified If you have accounts that you wi
42. ask ID A Security Role Setup File Edit Tools Help Of xj sa Fabrikam Inc 4 12 2017 E Save Cea X Delete 7 Copy 3 Role ID Role Name Role Description PSTL PSTL PSTL Display Other TaskID wj PSTL PSTL I4 4 bl 6 Choose Save to save the new Security Role Security user setup Go to Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Security Select the desired User from the lookup window that you want to grant access Select the appropriate Company from the Company drop down list 1 Roles 2 to the newly defined Security Role ID 3 4 Mark the check box for the Security Role ID created for the Professional Services Tools Library objects The example Role ID is PSTL W User Security Setup Ele Edt Tools Help QG Save Z Cem Ep cop i E User Company LESSONUSER1 E LESSONUSER1 Fabrikam Inc Roles 5 Role ID PM STAKEHOLDER POWERUSER v PSTL PURCHASING AGENT w PURCHASING MANAGER RT AGENT RT MANAGER Name Preventive Maintenance Stakeholder POWERUSER PSTL Purchasing Agent Purchasing Manager Returns Management Agent Batuma Mananamant Administrator E m Altemate Modified Forms and Reports ID DEFAULTUSER AFA Reports 5 Choose Save to save the new User Security Setup What to do next Refer to th
43. curity tasks and roles specific for each desired user s Regardless of how role based security is defined in Microsoft Dynamics GP there are multiple Professional Services Tools that require the user be logged in as sa Refer to Before you begin on page 1 for information on the specific tools In order for a tool to execute properly and run reports as designed all operations relating to the Reports and Files associated to the tools must be given access along with the Window Type Some of the options in creating a security task illustrated below can be changed depending on what type of security you need Security task setup 1 Goto Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Security Tasks 2 Createa new Task ID In this example the task name PSTL is used 3 Select Other as the Category 4 Enter PSTL for the task name and description 5 Select Technical Service Tools from the Product drop down list 6 Select Windows from the Type drop down list 7 Select Financials from the Series drop down list 8 Select Mark All to select all the operations listed 10 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 1 sl INSTALLING PROFESSIONAL SERVICES TOOLS LIBRARY 9 Repeat steps 6 through 8 until all Windows Reports and File operations have been marked for the Professional Services Tools Library for all of the combinations possible from the Series drop down list
44. d Choose OK to close the Customer Modifier window A Report Destination window will appear Select the destination for the Changed Customers Report and view the converted customer numbers 26 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 4 USING SALES TOOLS Using Customer Name Modifier Use this tool to change the Customer Name You can change an existing customer name to a new customer name without any loss of work open or historical records This tool requires that the user be logged in as sa To change a customer name 1 Enter the Starting Customer Number that you want to modify The existing Starting Customer Name will appear automatically Enter the Ending Customer Name or the name you want to change to Choose the Convert button to update records Refer to Using Validate and Import buttons on page 2 for information on importing data Ele Edt Tools Help Q Cancel Starting Customer Number ADVANCEDOOO1 aA Starting Customer Name Advanced Paper Co Ending Customer Name Advanced Paper Company Validate Import You will be prompted to back up your database Choose Continue once you have a backup of the database you are running the change on A message will signal the end of the Customer Name Modifier process Choose OK and close the Customer Name Modifier window A report destination window will appear Choose a destination for the report to view a Modified Customer Names report P
45. der Processing Purchase Order Processing Inventory Bank Reconciliation Inventory Payroll Bill of Materials and Multicurrency When using the Combine tools SmartList queries may need to be modified after the combine is completed Tool name Compatible modules and features Account Modifier Combiner Core Modules Analytical Accounting Control Account Management Excel Based Budgeting Field Service Fixed Assets Interfund Management Manufacturing Project Accounting Revenue Expense Deferrals SmartList Checkbook Modifier Core Modules Project Accounting Customer Modifier Core Modules Analytical Accounting Field Service Collections Management SmartList Project Accounting Microsoft Dynamics CRM PROFESSIONAL SERVICES TOOLS LIBRARY 3 INTRODUCTION Tool name Compatible modules and features Customer Combiner Core Modules Analytical Accounting SmartList Field Service Collections Management Project Accounting Microsoft Dynamics CRM Customer Name Modifier Core Modules Project Accounting Microsoft Dynamics CRM Employee Modifier US and Canadian Payroll Core Modules Human Resources Project Accounting Personal Data Keeper Item Number Modifier Core Modules Analytical Accounting Manufacturing Field Service SmartList Project Accounting Microsoft Dynamics CRM Item Number Combiner Core Modules Analytical Accounting Manufacturing
46. e additional chapters in this manual for details on using specific Professional Services Tools If you would like to purchase additional tools or have any questions please contact mbsprofessionalservices microsoft com 12 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 2 Using System Tools This chapter explains how to use the System Series Professional Services Tools Information is divided into the following sections Using Database Disabler Using Shortcuts Copy Using Toolkit Using Menu Inquiry Utility Using Update User Date Utility Using Database Disabler This tool allows the sa user to disable any company database Once the database is disabled the company option is removed from the Microsoft Dynamics GP log in window The company database can easily be reactivated This tool requires that the user be logged in as sa To disable a database 1 To disable a company mark the check box in the Disable column BA Database Disabler File Edt Tools Help Hs Company Name Disable Fabrikam Inc Mi Once Disable has been marked no users will be able to log in to that company The company option is removed from the Microsoft Dynamics GP log in window 2 To allow users to log back into Professional Services Tools as sa and unmark the check box in the Disable column for that company Using Shortcuts Copy Use this tool to copy the Shortcuts options from one user to anot
47. e order and receipt numbers 4 Ifyou do not want to use previous PO or receipt numbers select the check box to never default to a previous PO or receipt number The Minimum PO Number Default and Minimum Receipt Number Default fields will be disabled 5 Choose Save next PO Number field is not the same length as the Minimum PO Number entered Q This functionality will only work for document numbers that are the same length If the then the system will function as it did without the customization PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 8 USING MISCELLANEOUS TOOLS Using Default Add Item POP SOP When activated Default Add Item will automatically mark the Add Item selection in the Options menu for the following windows Sales Transaction Entry Purchase Order Entry Receivings Transaction Entry Purchasing Invoice Entry The Add Item selection can be marked or unmarked normally after Default Add Item is activated However it will default to marked instead of unmarked To activate this tool simply mark the second check box next to Default Add Item POP SOP in the Professional Services Tools Library window PROFESSIONAL SERVICES TOOLS LIBRARY 61 CHAPTER 8 USING MISCELLANEOUS TOOLS Using Doc Date Verify When Doc Date Verify is activated and a document date is entered a check will be performed to determine whether the document date is in a valid fiscal period or if the fiscal period is closed If the date does
48. end us your documentation comments 4 sl We welcome comments regarding the usefulness of the Microsoft Dynamics GP documentation If you have specific suggestions or find any errors in this manual send your comments by e mail to the following address bizdoc microsoft com To send comments about specific topics from within Help click the Documentation Feedback link which is located at the bottom of each Help topic By offering any suggestions to Microsoft you give Microsoft full permission to use them freely PROFESSIONAL SERVICES TOOLS LIBRARY 5 6 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 1 Installing Professional Services Tools Library This chapter explains how to install Professional Services Tools Library Information is divided into the following sections Installation Security setup What to do next Installation A Professional Services Tools Library can be installed directly from the Microsoft Dynamics GP installation media Download the most current version from PartnerSource or CustomerSource PartnerSource gt gt Downloads amp Updates gt gt Product Releases or CustomerSource gt gt Downloads amp Updates gt gt Service Packs Product Releases Installing Professional Services Tools Library 1 From the installation media start the Microsoft Dynamics GP installer Refer to the Microsoft Dynamics GP installation documentation pertaining to new installation or updating an
49. er the new Site ID name in the Ending Site ID field 3 Choose Convert 4 You will be prompted to back up your database Once you have a current backup of the database choose Continue 5 The process is complete a message indicating the Site Modifier is finished appears 6 A Report Destination window will appear after you select OK and close the Site Modifier window The report indicates what Site IDs were changed in the system 40 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 5 USING INVENTORY TOOLS Using Item Description Modifier Use this tool to change Item Descriptions You can change an existing item description to a new item description without any loss of work open or historical records Refer to Using Validate and Import buttons on page 2 for information on importing data To change an item description 1 Choose the item you wish to change in the Starting Item Number field Bi tem Description Modifier File Edt Tools Help Q Cancel a Fabrikam Inc 4 12 2017 Starting Item Number ACCS CRD 12WH kal Starting Item Description Phone Cord 12 White Ending ltem Description White Phone Cord 12 Validate Import Convert 2 The Starting Item Description field is populated automatically Enter a new description in the Ending Item Description field 3 Choose Convert 4 You will be prompted to back up your database Choose Continue once you have a backup of your database A mess
50. existing location Select Professional Services Tool Library from the Select Features window Microsoft Dynamics GP 2010 x Select Features Select the features you would like to install Available features for United States 4 A group of tools that can help you consolidate and change critical data quickly and accurately X 7 Extender X v Fixed Asset Management LX 7 Human Resources Manufacturing Multilingual Checks Payment Document Management Professional Services Tools Library x Project Accounting Revenue Expense Deferrals zl z Install Location C Program Files Microsoft Dynamics GP Browse cot Den _c After the installation is complete start Microsoft Dynamics GP and choose Yes to include new code To add the Professional Services Tools Library to the Home menu right click and choose Add gt gt Add window Home sa s Home To Do 0 E Reminders Add SmartList Add Macro Add Web Page Delete Add Extemal Shortcut Folder Navigation Pane Options Quick Links PROFESSIONAL SERVICES TOOLS LIBRARY 7 CHAPTER 1 INSTALLING PROFESSIONAL SERVICES TOOLS LIBRARY 5 6 In the Available Windows folder list expand the Technical Service Tools list then expand Project Select Professional Services Tools Library Add Window Shortcut Select a window to add to the shortcut bar Add Name Professional Services Tools Lib
51. gher you will need to run the Server based Indexing scripts after you complete the Account changer process The scripts can be found on the FRx CD under Bin gt gt FRx Reporter gt gt Scripts gt gt SQL Server 7 0 and 2000 gt gt Server Based Index Once the scripts have been completed you will need to Delete GL00105 run Check Links on Account Master and delete all G32 files Account Combiner Use the Account Combiner portion of this tool to combine like accounts into one single account You can combine account numbers in much the same way as you change accounts To combine similar accounts 1 Enter an existing account number in the Account Number field BA Account Modifier Combiner Of x File Edit Tools Help sa Fabrikam Inc 4 12 2017 Cancel Select By C Rangel Account C Import E Account Number 000 1100 00 Convert To Account Number 000 1101 00 El Convert Repopulate Column List 2 Enter the existing account number to which you want to combine in the Convert To Account Number field PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 3 USING FINANCIAL TOOLS 3 After entering the account numbers select the Convert button to make the change throughout the system Account Combiner works under the assumption that both accounts have the same posting type either Balance Sheet or Profit and Loss You cannot combine a Balance Sheet account in
52. he tool operation The tools that do not prompt users with a warning message either have another type of warning or assume that the user has taken steps to appropriately backup the data Additional users Most tools will require that you are the only user logged into the company If there are additional users logged into the company you will receive an error message listing the total number of users in the system Make sure all users are logged out and then reopen the tool If additional products are installed all 3rd party tables should be tested for validation Using the sa login Regardless of how role based Security is defined in Microsoft Dynamics GP there are certain tools that will require users to be logged in as sa These tools are Toolkit Database Disabler Customer Modifier Customer Combiner Customer Name Modifier Item Number Modifier Item Number Combiner Vendor Modifier Vendor Combiner Vendor Name Modifier Account Modifier Combiner Salesperson Modifier Territory Modifier Territory Combiner Company Copy PROFESSIONAL SERVICES TOOLS LIBRARY 1 INTRODUCTION Using Validate and Import buttons Validate and Import buttons are available on many of the tools that modify or combine data These buttons allow data to be imported without having to manually enter the information making the tools useful to change or combine many pieces of data For example if you are want to change 1000 current item numbers to 1
53. her user with the click of a button With the Shortcuts Copy tool you don t have to manually set the shortcuts up for each user on the system This is especially useful when macros are used with a window e g Purchase Order entry to always add item To copy a shortcut 1 Enter the User ID that you want to copy the Shortcuts from in the Copy From User ID field 2 Enter the User ID you want to copy the Shortcuts to in the Copy To User ID field PROFESSIONAL SERVICES TOOLS LIBRARY 13 CHAPTER 2 USING SYSTEM TOOLS 3 Choose copy BA Shortcuts Copy File Edit Tools Help Copy Cancel Copy From User ID DYNS aA Copy To User ID LESSONUSER1 El J 4 You will be prompted to make a backup of your database Choose Continue once you have made a backup 5 An alert message signals the end of the Shortcuts copy process IR No Report Destination window will appear after using this tool To verify the results simply check to see if the users specified to have the Shortcuts copied have the same Shortcuts button Using Toolkit Use Toolkit to rebuild the GL00105 table re create Dex Procs rebuild indexes re create tables and check identities of tables all within Microsoft Dynamics GP vila a This tool requires that the user be logged in as sa To rebuild the GLOO105 table 1 Toto rebuild the GL00105 table select Rebuild GL00105 in the Toolkit Options group o x 4 12 2017
54. hoose Convert 4 After you choose Convert you will be prompted to back up your data Once you have a backup of the company database choose Continue to start the combine process 5 Another message is displayed when the item number combine process is complete Choose OK to continue 6 Close the Item Number Combiner A Report Destination Window will appear Select a report destination to view the combined Item Numbers Report PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 5 USING INVENTORY TOOLS Using Item Number Modifier Item Number Modifier is like other modifier tools in that it allows the user to change a current inventory item number to a new number without losing any work open or history records See Using Validate and Import buttons on page 2 for information on the Validate and Import buttons 7 a This tool requires that the user be logged in as sa To change an item number 1 Enter the starting item number PA item Number Modifier Fie Edit Tools Help Q Cancel Starting Item Number BA100G kal New Item Number BASE100G _ valdate meot 2 Enter the new item number 3 Choose Convert 4 You will be prompted to make a backup of your database Once a backup is made choose Continue 5 You will receive an alert when the process is finished 6 Choose OK and close the Item Modifier window A Report Destination window will appear Select the report destination to view the Con
55. k period A summary total of the employee s total weekly hours for the Job and their total Job Gross Pay is printed for each employee on every job report The employee s total weekly gross and net pay along with their total FICA federal state and other withholding is given on the report as summary information Keep in mind that these summary figures may contain amounts that may have been allocated to other jobs during the week or may have come from a pay code that does not allow job number entry such as sick or vacation time The report also contains a summary for an entire job that describes the total job specific gross pay along with the total overall gross pay for all employees who worked on that job during the week Each separate Job will reset the report to start over with page 1 PROFESSIONAL SERVICES TOOLS LIBRARY 57 58 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 8 Using Miscellaneous Tools This chapter explains how to use Professional Services Tools that are not associated with a particular series Information is divided into the following sections Using Fixed Asset Modifier Using Minimum PO Receipt Number Using Default Add Item POP SOP Using Doc Date Verify Using Decimal Place Tool Using Company Copy Using Fixed Asset Modifier Use this tool to reclassify an asset code within the Fixed Assets module All tables throughout the system will reflect this change To reclassify an asset code 1 Ente
56. licate To DB field choose the database to which the master records will be copied Mark the Vendors option You will not be able to mark an option if you are not registered for that particular Master Trigger Close Master Triggers Setup When you create or update a master record in the database you entered in the Master DB field the record will be inserted or updated in the database you chose in the Replicate To DB field 46 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 6 USING PURCHASING TOOLS Using Payables Management Minimum Check Use the Payables Management Minimum Check tool to set a minimum amount for your Payables checks within the Select Checks process yx This process occurs after the Payment Vouchers have already been created This will cause a break in the payment vouchers sequence in the system but will not harm anything Payables Management Minimum Check setup 1 3 This tool modifies existing features within Microsoft Dynamics GP To activate the new functionality that this tool offers simply mark the second check box next to PM Minimum Check from the Professional Services Tools Library menu Close the window When opening the Select Payables Checks window the title bar of the window will display the current settings for the minimum check amount GA Minimum Check 201 00 m x Elle Edit Tools Options Additional Help sa Fabrikam Inc 4 7 dg BuidBach Z
57. ns how to use the Financial Series Professional Services Tools Information is divided into the following sections Using Account Modifier Combiner Using Checkbook Modifier Using Fiscal Period Modifier Using General Ledger Master Record Triggers Using Account Modifier Combiner vl You can change previous account numbers into new account numbers or combine existing accounts with the Account Modifier Combiner tool This tool can identify which one of these activities you are trying to perform This tool requires that the user be logged in as sa The difference between the modifier and combiner is that both accounts involved in the combiner portion of the utility currently exist in the system while the new account number in the modifier portion is introduced as a new number to the system Please remember to run the reconcile process for all your open and historical years after using the account modifier combiner to ensure that detail and summary records agree Using the Repopulate Column List function If you load a dictionary after the initial install of the Professional Services Tools Library you should re create an internal table using the Repopulate Column List function If you install a product after the initial installation of Professional Services Tools and do not mark the Repopulate Column List check box the new products may not be included when using this tool This Repopulate Column List function only h
58. nt to re create by selecting a function in the Maintenance Options group When re creating tables there is an additional check box Recreate data for selected table s If you mark this option the table will be re created and the data will be left intact If you leave the option unmarked the table will be re created and the data will be lost 4 Choose Perform Selected Maintenance to proceed viv depending on the table size Using Menu Inquiry Utility Keep in mind when re creating a table with data that it may take some time to re create The Menu Inquiry Utility allows you to see all of the commands on the menus whether they are hidden or not and helps identify where those commands come from which product and other properties of the commands To display menu commands 1 Choose a menu group from the Menu Groups field Bi Microsoft Dynamics GP Menu Inquiry Tools Help User Date E Edit E Tools E H Reports SmartList Reminders Task List E Maintenance sa Fabrikam Inc Categories Commands User and Company Process Monitor User Preferences jo x gl Command Properties Tag 313 y Product 0 Microsoft Dynamics GP Parent Form 1568 Command System Command ID 176 Command Type Form Display Name User and amp Company Tool Tip User and Company Form to Open Switch Company Security Form Switch Company Normal Image Checked Image v Enabled Checked v Visible PROFESSIO
59. o create and update General Ledger account master records 1 Inthe Master DB field choose the database where you will be creating or updating records Master Triggers Setup nl x File Edit Tools Help sa Test 4 13 2007 Sf OK Master DB Replicate To DB Accounts Vendors Customers Two TEST H O g J 2 Inthe Replicate To DB field choose the database to which the master records will be copied To use General Ledger Master Triggers the Replicate To database must have the same company account structure setup as the Master database This information can be found using query analyzer and doing a query on the SY00300 table against each database or in Microsoft Dynamics GP you can go to Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt Company gt gt Account Format The same number of Segments must be setup and each Segment must be the same length 3 Mark the Accounts option You will not be able to mark a check box if you are not registered for that particular Master Trigger Close Master Triggers Setup When you create or update a master record in the database you entered in the Master DB field the record will be inserted or updated in the database you chose in the Replicate To DB field 24 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 4 Using Sales Tools This chapter explains how to use the Sales Series Professional Services Tools
60. on the check to match the Check Amount in Words you must use Report Writer to modify the check report and change the currency fields to only print two decimal places Modifying the Check Amount in Words is not possible in Report Writer so this tool allows that portion of the change To activate this tool simply mark the second check box next to Decimal Place Tool in the Professional Services Tools Library window PROFESSIONAL SERVICES TOOLS LIBRARY 63 CHAPTER 8 USING MISCELLANEOUS TOOLS Using Company Copy This tool allows the setup and report option information from one company to be copied to another company within Microsoft Dynamics GP You can choose the modules for which information will be copied from the source company to the destination company sl t This tool requires that the user be logged in as sa Before using the Company Copy tool be aware of the following important issues e You should use this tool only after creating a SOL database backup of the destination company The copy operation is irreversible without a backup e When the copy process is run the setup tables and report options tables in the modules you selected will be deleted for the destination company If you have manually added setup or report option information for a module in the destination company and you do not want this information deleted do not use the Company Copy tool to copy data for that module e You should be the
61. or Report Options are selected Financial must be marked due to the account index dependency with other modules 64 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 8 USING MISCELLANEOUS TOOLS The following dependencies exist for the modules e If Manufacturing is marked Inventory must also be marked e If Extended Pricing is marked Inventory and Receivables must also be marked e f Project Accounting is marked Inventory Receivables and Payroll must also be marked e Jf Bill of Materials is marked Inventory must also be marked 4 Click Process to begin processing A processing status message will be displayed in the lower left corner of the Company Copy window The processing time required will depend on the amount of data in the modules selected When processing has finished a status message will indicate that processing is complete 5 Log into the destination company to validate the setup information and report option information that you copied Data tables copied The following is a listing of the data tables that are copied for each module in the Company Copy tool Module Tables copied Company SY00300 SY03100 SY40102 SY00600 SY03300 SY40103 SY00700 SY03900 TX00101 SY01100 SY04100 TX00102 SY01200 SY04200 TX00201 SY02200 SY40100 SY01201 SY02300 SY40101 PA00001 SY03000 Financial GL00100 GL40100 GL00102 GL40101 GL00103 GL40200 GL00104 CM00100 GL00105 CM40100 GL00200 CM40101 GL00201 SY0410
62. ou are changing An alert message will signal the end of the Checkbook Modifier 3 Choose OK and close the Checkbook Modifier window 4 A report destination window will appear Choose a destination for the report to view the Modified Checkbook IDs report 22 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 3 USING FINANCIAL TOOLS Using Fiscal Period Modifier Use the Fiscal Period Modifier to change fiscal year definitions and reset data in the open and history tables vias sa Fabrikam Inc 4 12 2017 a Fiscal Period Modifier Ele Edit Tools Help Step 1 Setup New Fiscal Periods Setup Periods Step 2 Open New Years that 2010 Open Year were Previously Closed Step 3 Process New Fiscal Periods EM J ay Before changing data in the company make a backup of the company database This tool does not support changing the month and or day on closed years as the tool does not recalculate the ending and beginning balances Only use the Fiscal Period Modifier to change the Year stamp back for years that are currently closed To change fiscal year definitions 1 Choose Setup Periods to create the new fiscal year definitions and remove previous fiscal year definitions When defining the new periods be sure to keep all transactions associated with the same year only change the name of the year The utility does not allow transactions for a year to be split between different years If you have a year
63. process mirrors that of how account numbers are changed The user is able to change an existing territory id to a new territory id without any loss of work open or historical records Just by clicking the convert button the records are updated If you want to import large amounts of data refer to Using Validate and Import buttons on page 2 where there is information on how to import data This tool requires that the user be logged in as sa To change a Territory ID 1 Choose the starting Territory ID 2 Enter the new Territory ID Territory Modifier File Edit Tools Help o Cancel Starting Territory ID TERRITORY 1 R New Territory ID REGION1 Validate Import Convert TJ 3 _ You will be prompted to back up your database Once you have a backup of the proper data choose Continue to begin the change process 4 The process is complete when you receive another message stating the Territory Modifier is finished 5 A Report Destination Window will appear Select a report destination to view the Modified Territories Report PROFESSIONAL SERVICES TOOLS LIBRARY 33 CHAPTER 4 USING SALES TOOLS Using Territory Combiner Use the Territory Combiner to combine an existing Territory ID with another existing Territory ID without any loss of work open or historical records sl x This tool requires that the user be logged in as sa To combine a Territory ID 1 Select the Territory ID
64. r the existing Asset ID Fixed Asset Modifier File Edit Tools Help Change Cancel EvistingAssetID Q ASSET New Asset ID ASSETID 2 Enter the new Asset ID value Choose Change The Fixed Assets Modifier tool will update the following tables with the new ID FA00100 FA00700 FA00701 FA00800 FA00801 FA01002 FA01100 FA01300 FA10200 PROFESSIONAL SERVICES TOOLS LIBRARY 59 CHAPTER 8 USING MISCELLANEOUS TOOLS 60 Using Minimum PO Receipt Number This tool adds the ability to prevent Purchase Order Processing from defaulting to the next PO Number or Receipt Number You can set the default to a number before the current PO number when a previously existing PO number is deleted You can also set the minimum PO Number default so defaults will never go below the set amount To set a Minimum PO or Receipt number 1 To activate the new functionality that this tool offers simply mark the second check box next to Minimum PO Receipt from the Professional Services Tools menu Close the window 2 Open Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt Purchasing gt gt Purchase Order Processing and then choose Additional gt gt Minimum PO Number jo x sa Fabrikam Inc 4 12 2017 File Edit Tools Help kl Save cancel Minimum PO Number Default PO1000 Minimum Receipt Number Default RCT1000 T Never Default to a Previous PO Rec Number 3 Enter the minimum purchas
65. ransaction Entry o xj File Edit Tools Help a Fabrikam Inc 7 JE New a BatchID TEST Transaction Defaults Data Entry Options Pay Period From 4 12 2010 Days Worked 0 00 Current Options To 4 12 2010 E Weeks Worked No pions Options Date From 4722010 E esition TEC Q Shift Q Date To 41272010 8 State wi Q Premium 0 00 Days Worked ee Q Total Rate 0 00 Weeks Worked SUTA State wl Q Job Number JOBNUMBER Workers Comp WIWCO 4 Previous Next gt Batch TEST 1 Employee 1 Transaction 7 The Job Number field is located in the expanded area of the Payroll Transaction Entry window This field is only active for transactions that are Hourly Overtime or Double Time payroll types and will be disabled for any other types of transactions There is no validation for the Job Number itself and the Job Number can be any string of 15 characters or less Once a batch is posted along with a check run the information about the transaction is stored to be printed later on the Certified Payroll Report The report includes the Employee ID Job Number Job Title Department Pay Code number of hours and the Pay Rate for this check This information will remain in the system for as long as the user keeps Check History for the employee 56 PROFESSIONAL SERVICES TOOLS LIBRARY r CHAPTER 7 USING PAYROLL TOOLS To print the Certified
66. rary Done Window Project Professional Services Tools Library Help Available Windows Interfund Management Microsoft Dynamics GP Purchase Order Enhancements Report Scheduler SmartList Technical Service Tools Financial Inventory Payroll Project Profess Purchasing Sales a Keyboard Shortcut None Choose Done and then choose Yes to save the changes 7 Professional Services Tools Library should now be available on your Home menu Microsoft Dynamics GP Y Home Transactions Inquiry Home ED Home Bj User Preferences E Shortcuts H Report Shortcuts Bi Startup DP Professional Services Toole Library fl User Classes You will need to repeat steps 1 7 for each company where you want to use the Professional Services Tools Library The first time that you use Professional Services Tools Library you will need to enter the registration key provided with your purchase You must log in as sa the first time to enter the registration code and to allow the Professional Services Tools Library to create stored procedures Several tools are available for no charge to customers with a current service plan To activate these tools choose Cancel from the registration window To activate the entire Professional Services Tools Library suite for the sample company Fabrikam Inc you can enter SMPE0102030405 for the registration key The registration key can be entered from
67. sage column for that SOP Type An OK button and a Display button are displayed with the message If OK is clicked the focus will return to the Customer PO Number and they user would have to enter a different number or leave it blank If Display is clicked a window will open that shows the records that the PO Number was found on Warn and Password Presents the user with the message defined in the Message column for that SOP Type but will give the user the option of entering the password entered in the Password column as an override Set the Message column for each SOP Type This field is a user defined message that is displayed after a duplicate PO Number is found The tokens 1 2 and 3 can be used in the message text and will be substituted with the actual PO Number Document Type the words Order Invoice etc and SOP Number Set the Password column for each SOP Type This field is per document type and is only used when the Warning Type column is set to Warn and Password Activate the utility To activate SOP PO Number Check simply mark the second check box next to SOP PO Number Check in the Professional Services Tools Library window To use SOP PO Number Check When in Sales Transaction Entry entering in a duplicate Customer PO Number will check for duplicates on the document types marked and apply the rules for the document type currently entered For any Warning Type other than Do Nothing a dialog
68. sh to combine choose Yes to make the tool combine those accounts When the combine process is complete you will receive a prompt to reconcile your open and historical years 6 Choose a report destination The report will list all the account modifications and combinations that took place as well as all accounts that were modified and combined If you are running FRx 6 5 Service Pack 5 or higher you will need to run the Server based Indexing scripts after you complete the Account changer process The scripts can be found on the FRx CD under Bin gt gt FRx Reporter gt gt Scripts gt gt SQL Server 7 0 and 2000 gt gt Server Based Index Once the scripts have been completed you will need to Delete GL00105 run Check Links on Account Master and delete all G32 files 18 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 3 To change a range of accounts 1 Select the range of accounts to be changed and identify what segment of the account structure will change from the Field Type drop down list USING FINANCIAL TOOLS 2 After the account segment has been identified enter a new segment value and choose Convert The accounts will change throughout the system Account Modifier Combiner File Edt Tools Help Fabrkam Inc Cancel Select By Rangel C Account Import Starting Account Number 000 1100 00 E Ending Account Number 000 3010 20 a Field Type Segment Current Value 111
69. sheet are now contained in a Microsoft SQL Server table called TACHANGE If you want to preview the changes that are about to occur on the system before combining accounts perform a select statement against the TACHANGE table Select from TACHANGE to view the valid mappings from your spreadsheet If you see an error in the TACHANGE table due to a mistake in the spreadsheet simply make the change to your spreadsheet and import the spreadsheet again The old mappings from the spreadsheet will be deleted and the new ones will be inserted into the TACHANGE table You must perform the select statement in Microsoft SQL Server before closing the Account Modifier Combiner window PROFESSIONAL SERVICES TOOLS LIBRARY 21 CHAPTER 3 USING FINANCIAL TOOLS Using Checkbook Modifier This tool allows changes in checkbook IDs to take place You can change an existing checkbook ID to a new checkbook ID without any loss of work open or historical records Refer to Using Validate and Import buttons on page 2 for information on importing data EM Checkbook Modifier File Edit Tools Help Cancel Starting Checkbook ID PETTY CASH AJ Ending Checkbook ID PETTY FUNDS Validate Import Convert J To change a checkbook ID 1 Enter the Starting Checkbook ID and Ending Checkbook ID in the window and choose Convert 2 You will be prompted to back up your database Choose Continue once you have a backup of the database y
70. ss 3 You will receive an alert that the Customer Combine has been completed when the process is finished 4 Choose the OK to close the Customer utility window and generate a Combined Customer Report 5 A Report Destination window will appear Select the report destination to view the Combined Customer Numbers report PROFESSIONAL SERVICES TOOLS LIBRARY 25 CHAPTER 4 USING SALES TOOLS Using Customer Modifier Use this tool to change customer numbers without manually entering new customer numbers and changing open invoices The process is similar to the procedure used to change account numbers This tool requires that the user be logged in as sa To change a customer number 1 2 Enter the existing customer number in the Starting Customer Number field Enter the new customer number in the New Customer Number field Select the Convert button For use of the Validate and Import buttons please refer to Using Validate and Import buttons on page 2 jo x a Fabrikam Inc 4 12 2017 PA Customer Modifier Ele Edit Tools Help Cancel Starting Customer Number New Customer Number Validate Import AARONFITODOT El AARONFITOOO2 You will be prompted to make a backup before continuing with the process Once you have a current backup of the database choose Continue An alert message stating that the process has completed will appear when the Customer Modifier is finishe
71. ster record in the database you entered in the Master DB field the record will be inserted or updated in the database you chose in the Replicate To DB field 28 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 4 USING SALES TOOLS Using Receivables Management Transaction Unapply s This tool enables you to unapply documents in the history table and automatically move the records back to the open table even if there are discounts and or write offs associated with the document You can reapply the records as needed Using this tool can be a good alternative to removing history and reentering data if records were applied incorrectly If a discount and or write offs exist a General Ledger journal transaction will be created using the original distributions of the document and the transaction will be in a batch in the General Ledger An edit list can be printed prior to posting into the General Ledger The Receivables Management Transaction Unapply tool does not allow users to unapply Multi currency documents that have discounts and or write offs associated with them To unapply Receivables Management transactions 1 Choose the Customer ID Bil Receivables Transaction Unapply File Edit Tools View Help sa Fabrikam Inc 4 12 2017 v OK e Redisplay d H Customer ID ADAMPARKODOT kal Name Adam Park Resort Documents by Document Number v Al From To Include V Work IV Open P Hity
72. t Dynamics GP Customer Assistance Department at 800 456 0025 in the U S or Canada or 1 701 281 6500 March 2010 Contents Introduction 1 B fore VOU Deis cette aeterni e dE ra tenta vene tane d eter es 1 Using Validate and Import buttons 2 Compatibility informati n siaa MR RM Rs 3 Send us your documentation comments 5 Chapter 1 Installing Professional Services Tools Library 7 Installations p aree eer n e p eret e che 7 Security Setup iter tret dt tile endet oet tre eret ee Di jaa tee iie een 10 What to do next eaa eere e d obe er eere ieu ege ede P ke aS ERA 12 Chapter 2 Using System Tools 13 Using Database Disablet epi ue eoe ties 13 Using Shortcuts Copy tietan pinnaa aaraa EE pde in dunt rs 13 Using ToolKit eene teet tereti cede edet teret n tede eine 14 Using Menu Inquiry Utility petere eec ene La sagas skat die iieri iie 15 Using Update User Date Utility eene nnne nnne 16 Chapter 3 Using Financial Tools 1 sss 17 Using Account Modifier Combiner ss 17 Using Checkbook Modifier Using Fiscal Period Modifier e e eterne a te ee Hep eere 23 Using General Ledger Master Record Triggers ss 24 Chapter 4 Using Sales Tools 25 Using Customer Combiner Using Customer Modifier semis tese erede enitn diet fente Using Customer Name Modifier Using Receivables Management Master Record Triggers
73. that was previously closed and is open under the new fiscal year definitions select a year from the drop down list and choose Open Year You will receive a message stating that the year selected has been changed to an open year Choose Process to align your history and open data and remove the old GL summary data Reconcile each history and open year from the Reconcile Financial Information window located under Utilities gt gt Financial gt gt Reconcile Start with the oldest history year and work towards the most current open year Review the GL data If the data is not as expected restore the company from the backup PROFESSIONAL SERVICES TOOLS LIBRARY 23 CHAPTER 3 USING FINANCIAL TOOLS Using General Ledger Master Record Triggers A N 7 This tool allows you to create General Ledger account master records and replicate records to another database on the same server You can also choose to replicate these records to some or all of your companies If you are using Integration Manager to import account customer or vendor master records to the main company database and the integration fails for any reason any records imported to the main company database will be deleted rolled back However if you have enabled master record triggers the records will be replicated to company databases that you specify in the Replicate To DB field and will not be rolled back You must delete such replicated records manually T
74. to a Profit and Loss account or combine a Profit and Loss account into a Balance Sheet account The Beginning Balance entries would be invalid if you cross match a Balance Sheet account with a Profit and Loss account 4 Choose a report destination The report will list all the account modifications and combinations that took place as well as all accounts that were modified and combined To combine or change multiple accounts from a spreadsheet 1 Enter existing account numbers in the first column of data in the spreadsheet as you would enter it in the Account Number field 2 The second column of data should contain the new account numbers as you would enter it in Convert To Account Number field Be sure to include dashes in the account numbers 3 Save your spreadsheet as a text file 4 Choose Import in the Select By field 5 Two new buttons Validate and Modify are now available Choose the Validate button first Select the text spreadsheet file and choose Open to start the validation process The Validate button will verify that each current account number exists in your system before the conversion is performed 6 Once the validation report contains no errors choose Modify and select your validated text spreadsheet to change or combine accounts Previewing changes in your system If you want to double check for errors before making final changes to your system all of the account mappings that were valid in your spread
75. v Checkbook Modifier v Salesperson Modifier v M Default Addltem POP SOP v Fiscal Period Modifier vi V C SOP Customer Item Lookup V M Doc Date Verity vi GL Master Triggers vi C Territory Modifier v v Decimal Place Tool V Teritory Combiner v Company Copy RUES v V SOP PO Number Check v 1099 Modifier v PM Master Triggers Payroll Tools v v PM Minimum Check v v Certified Payroll Report v M Select Checks Combiner v Employee Modifier M Vendor Combiner v Vendor Modifier r2 Vendor Name Modifier Please consult the ProfServicesT oolsLibrary pdf file for detailed instructions You have access to each Tool that has a check next to it v Database Disabler Mark the radio button next to the tool you wish to use and choose Next Some tools have a second check box that appears directly to the left of the radio button These tools modify functions within Microsoft Dynamics GP Mark the second check box to activate the tool and modify existing forms and menus within Microsoft Dynamics GP automatically To add the new functionality that the following tools offer simply mark the second check box and close the Professional Services Tools Library window PM Minimum Check Select Checks Combiner SOP Customer Item Lookup Certified Payroll Report Minimum PO Receipt Update User Date POP Cost Defaulter SOP PO Number Check Default Add Item PO
76. verted Item Number s report Using Item Reconciler Item Reconciler allows you to reconcile Inventory The Reconciler s function is the same as the reconcile functions built into Microsoft Dynamics GP with one exception only those items that need reconciling will be reconciled using Professional Services Tools Library This can increase performance if all items don t need to be reconciled To reconcile Inventory 1 Choose the module you want to reconcile Inventory EM item Reco 15 x File Edit He Reconcile JV IV Inventory Reconcile J 2 Choose Reconcile to reconcile the module s PROFESSIONAL SERVICES TOOLS LIBRARY 43 44 PROFESSIONAL SERVICES TOOLS LIBRARY Chapter 6 Using Purchasing Tools This chapter explains how to use the Purchasing Series Professional Services Tools Information is divided into the following sections Using 1099 Modifier Using Payables Management Master Record Triggers Using Payables Management Minimum Check Using Select Checks Combiner Using Vendor Combiner Using Vendor Modifier Using Vendor Name Modifier Using POP Cost Defaulter Using 1099 Modifier This tool allows you to update the 1099 amounts for vendors who are not set up as a 1099 vendor for the year or a portion of the year This tool will only modify records that are already paid and should be 1099 records for the year selected If you have any work or open records that haven t
77. will be displayed giving the custom message if a duplicate is found Depending on the option selected Warn and Ask Warn and Reject etc you will want to change the wording of the message to match more closely with the options presented 1 PO Number PO1 already exists for this customer on Sales Invoice IVC10068 Yes No Display For this document the setting was Warn and Ask Clicking Yes would allow reuse of the number while clicking No would restart the field Clicking Display will open a display window to display the documents that the PO Number was used on 36 PROFESSIONAL SERVICES TOOLS LIBRARY CHAPTER 4 USING SALES TOOLS PA Dupiicate Po numbers imix Fie Edit Tools Help sa Dextordinary Inc 9 18 2009 Status SOP Type SOP Number Document Date Work Invoice VC 0069 i 3 18 2008 AARONFITOQO PO1 Drilling back on the SOP Number will open the document in SOP Inquiry To set up customer exceptions While each SOP Document Type can be made required by using the Customer PO Validation Setup window some customers might be an exception to that rule To create Customer Exceptions use the Customer Exception window 1 Choose Microsoft Dynamics GP menu gt gt Tools gt gt Setup gt gt System gt gt Customer Exception to open this window This window displays all of the customers in the system and allows you to choose the exceptions i x File
78. you wish to convert using the lookup window in the Starting Territory ID field Territory Combiner Ele Edt Tools Help Q Cancel Starting Territory ID Starting Territory Description Combined Into Territory ID Combined Into Territory Description Validate Import TERRITORY 1 Q Illinois and Missouri TERRITORY 2 Q Indiana and Michigan 2 Select the ending Territory ID with the lookup window in the Combined Into Territory ID field 3 Choose the convert button to update records If you want to import large amounts of data refer to Using Validate and Import buttons on page 2 4 You willbe prompted to back up your database Once you have a backup of the proper data choose Continue to begin the combine process A message signals the end of the Territory Combine process 34 PROFESSIONAL SERVICES TOOLS LIBRARY sa Fabrikam Inc 4 12 2017 CHAPTER 4 USING SALES TOOLS Using SOP PO Number Check Use the SOP PO Number Check to verify the Customer PO Number field for duplicates as data is entered into the field on both the SOP Entry window and the SOP Customer Detail Entry window SOP PO Number Check setup 1 To set up the SOP PO Number Check mark the SOP PO Number Check check box in the Professional Services Tools Library window Click Next to open the Setup window File Edit Tools Help sa Dextordinary Inc 9 18 2009 SOP Type Check DB Which Tables Check on

Professional Services Tools Library

Contents

Download Pdf Manuals

Related Search

Related Contents