Connect Learn Share Welcome Microsoft Dynamics GP User
- Slides: 135
Connect Learn Share Welcome! Microsoft Dynamics GP User Group (GPUG®) Colorado Regional Chapter Meeting [November 19, 2013] Regional Chapters
Housekeeping Lunch should arrive around 11: 30 AM Casual event, feel free to contribute We are all volunteers, enjoy and step up Make sure to sign in so we have attendance Door prizes Regional Chapters
Agenda 11: 00 Welcome & GPUG Information 11: 30 Member Showcase –Republic Financial 12: 00 Year End Close - Njevity 1: 00 1099 Best Practices - Mc. Gladrey 1: 30 Mekorma – GP Macros Regional Chapters
Welcome & Introductions Name Company Role in Company Regional Chapters
About GPUG Founded in 2007 M icr os of t rtn er s The largest, independent group for users of Microsoft Dynamics® GP Users Pa Officially recognized by Microsoft Over 4, 300 company members (25, 000+ individual members) Regional Chapters
Activities Events Online Activities Webinars Peer Networking Academy Regional Chapters
Connect Learn Share Meet like-minded GPUG members and access your network anytime, anywhere. Keep up on what’s happening in GPUG and in the world of Dynamics GP. Share your Dynamics GP experiences and gain insight from the GPUG community. Regional Chapters
GPUG Membership Premium Member Small Business 1 -9 GP Licenses $400 USD/year Mid-Market 10 -49 GP Licenses Enterprise 50+ GP Licenses USD/year $700 $950 § Unlimited Workshops, Webinars & Roundtables Upgrade Today: email membership@ gpug. com § Free Regional Chapters § Special Interest Groups § Microsoft Conduits § CPE Credits § Discounted GPUG Summit Registrations § Discounted GPUG Academy Courses § And so much more! http: //www. gpug. com/join-gpug/user-membership/ Regional Chapters
Member Showcase Featuring: Republic Financial Corporation Regional Chapters
Member Showcase § § § § Who We Are and What We Do What Modules We Use Number of Users How Long What ISV's and How We Use Them Favorite Module and Why Tips & Tricks / Way to Improve Processes (what surprised you that you didn’t know) § Where Do They Go for Answers § Questions? Regional Chapters
Republic Financial Corporation § Private Investment Firm – Special Assets – Commercial Aviation – Portfolio Companies § Headquartered in Greenwood Village with a remote office in Dublin, Ireland § 65 employees § Over 40 years in business Regional Chapters
Republic Financial Corporation § New to Dynamics GP § Running Dynamics GP 2010 SP 3 § Implementation Project – – – Kickoff October 2012 Migration from Oracle Financials (11 years) 4 - 5 month project GO LIVE January 1, 2013 Partner - Njevity Regional Chapters
Republic Financial Corporation § § § Hosted on-premise Multiple Company Databases (6) Multi-entities (350) Multi-currency GP Products – – – Financial Series – GL, AP, AR Smartlist Builder Extender Management Report Integration Manager Regional Chapters
Republic Financial Corporation § ISV Products – – – Mekorma MICR – check printing Binary Stream – multi-entity management Encore – bank reconciliation Encore – electronic reconciliation Bassets – fixed assets (units of production depreciation) – Rockton – Smartfill – Ariett Xpense Reporting Regional Chapters
Republic Financial Corporation § Critical Success Factors – Data Migration of Oracle Data – Restructure the Chart of Accounts – Replace Excel Consolidation Reports with System Generated Reports using Management Reporter – Implementation of Bassets Fixed Assets for Units of Production Depreciation – Implementation of Binary Stream Multi-Entity Management – Setup New Company in Dynamics 2 Go (Cloud) and then migrate back to Hosted GP Regional Chapters
Republic Financial Corporation § Data Conversions – – – Account strings Total vendors Open AP transactions GL transactions Checkbooks and EFT setup 61 Assets into Bassets 8, 640 379 346 3, 285 238 Regional Chapters
Republic Financial Corporation § Configurations – – – Smartlists SQL Views Window modifications Extender Items Management Reporter Reports 14 13 11 9 55 Regional Chapters
Republic Financial Corporation § Lessons Learned – Start with what the end reports must be when setting up the new system – Convert at the end of the reporting year(if possible) – Take into account audit requirements – Allow adequate time for testing of the converted data and end reports Regional Chapters
Year-End Close: Tips & Tricks Authored by Bob Mc. Adam GPUG All Star; Dynamic Communities Regional Chapters
AGENDA § Goals – Review the common year-end process – Provide help with specific issues § Review Year-end Checklist – Overview & Comments – Step through applicable windows in GP Regional Chapters
YEAR-END CHECKLIST § Finalize any/all applicable transactions § Reconcile submodules to G/L § Print necessary reports & file § Make a backup when finished backup § Begin closing process Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Did you make your backup yet? ? ? !!!! Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
CLOSING SUBLEDGERS PROPERLY § SOP & POP modules – No specific Y/E close process in either module – SOP: Double-check for any applicable invoices/returns and post – POP: Double-check for any applicable receivers/invoice matches and post – POP: Received/Not Invoiced report ties out your ‘Accrued Purchases’ liability account • Reports>Purchasing>Analysis>Rec’d/Not Invoiced Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Time for another backup… Regional Chapters
CLOSING SUBLEDGERS PROPERLY § Inventory Control (IC) – Wrap-up year-end physical count & related variance/adjustment transaction postings – Run the IC year-end closing process • Routines>Inventory>Year-end Close – Notes: • Inventory Batches – “Post to G/L” checkbox • Discussion of ‘Master Posting’ window • Reports>Inventory>Activity>Stock Status Report Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Time for another backup… Regional Chapters
CLOSING SUBLEDGERS PROPERLY § Receivables Management (RM) – Complete monthly processes, including posting all non-recurring RM batches, aging reports, etc. – Review ‘Unapplied Documents’ report • Reports>Sales>Analysis>Unapplied Documents – Run the RM year-end closing process • Routines>Sales>Year-end Close • Save new year transactions to batches for now – Discussion of ‘Customer Summary’ window Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Time for another backup… Regional Chapters
CLOSING SUBLEDGERS PROPERLY § Payables Management (PM) – Complete monthly processes, like RM module – Run 1099 s for tagged Vendors (if needed) • Routines>Purchasing>Print 1099 • Edit 1099 s: Cards>Purchasing>Summary>Period – Run the PM year-end closing process • Routines>Purchasing>Year-end Close • Two closes required if not on calendar year – One for 1099 s; one for year-end process Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Time for another backup… Regional Chapters
CLOSING SUBLEDGERS PROPERLY § Fixed Assets Management (FAM) – Close out Payables module before beginning – Double-check that all transactions – additions, retirements, etc. – are posted – Double-check that final depreciation routine and related G/L interface process are complete – Run the FAM year-end closing process • Routines (Financial Tile)>Fixed Assets>Year-end Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Time for another backup… Regional Chapters
CLOSING SUBLEDGERS PROPERLY § United States Payroll (UPR) – Year-end processing ALWAYS done @ 12/31 • Confirm status of any new updates from Microsoft – Process final payroll & period/qtr procedures – Build the Year-end Wage file/table (UPR 10101) • Routines>Payroll>Year-end Closing • Holds all info needed to produce W-2 s & 1099 -Rs – Review & Edit W-2 s & 1099 -Rs (if needed) • Routines>Payroll>Edit W-2 s • Routines>Payroll>Edit 1099 -Rs Regional Chapters
CLOSING SUBLEDGERS PROPERLY § United States Payroll (continued)… – Print W-2 s & 1099 -Rs • Routines>Payroll>Print W-2 s • Routines>Payroll>Print 1099 -Rs – Apply new Dynamics GP Tax Tables • Available via ‘Customer. Source’ download • Maintenance>US Payroll Updates>Check for Updates • Typically, new tax tables installed after payroll close – New calendar year payroll can now be processed Regional Chapters
MODULE CLOSING ORDER § SOP & POP § Inventory § Receivables § Payables § Fixed Assets § Payroll § General Ledger Regional Chapters
Time for another backup… Regional Chapters
FINALIZING THE Y/E CLOSE § General Ledger (GL) – ALWAYS the final module to be closed!!! • Doesn’t need to be closed immediately like others – Finalize adjustments; post ‘Single Use’ batches – Print Detailed T/B & MR/FRx financials (optional) – SKIP the ‘Period Consolidation’ process • Routines>Financial>Period Consolidation Regional Chapters
FINALIZING THE Y/E CLOSE § General Ledger (continued)… – Double-check ‘Posting to History’ setting • Setup>Financial>General Ledger • Allows posting to most-recent closed fiscal year only • Also check ‘Maintain History’ & R/E acct. while here – Run the G/L year-end closing process • Routines>Financial>Year-end Closing – Click ‘Close Year’ button only once ! • Edit R/E account and/or next JE number (not common) • Issue w/ financials if delayed past 1 st new acctg period Regional Chapters
FINALIZING THE Y/E CLOSE § Ancillary items (iii) – Before closing G/L, create a simple ‘Accounts’ Smart. List and review “Posting Type” settings • KB# 864913 provides ‘surgical’ fix steps – Close the TEST database first if you prefer – Fiscal Periods Setup Maintenance • Setup (Administration Tile)>Company>Fiscal Periods • Be sure all 2010 module boxes are closed • Create a new calendar for 2011 module postings Regional Chapters
IF CLOSING IN GP 2013… Regional Chapters
IF CLOSING IN GP 2013… Regional Chapters
IF CLOSING IN GP 2013… Regional Chapters
QUESTIONS? Regional Chapters
1099 Reporting Best Practices Authored by Mike Mc. Dowell, Mekorma & Zubin Gidwani, Dynamic Budgets Regional Chapters
Agenda § Understanding how GP records 1099 amounts § Researching and validating 1099 data § How to edit 1099 data § TIN Matching § 3 approaches to managing 1099 s Printing / Filing § Q & A Regional Chapters
Understanding how GP records 1099 amounts • 1099 amounts are stored in the vendor summary records • AP determines transaction by transaction where amounts record • Prior to GP 2010 need PSTL to update 1099 amounts • GP 2010 - Update 1099 Information & amounts - all or nothing • GP 2013 – edit 1099 transactions by transaction Regional Chapters
Understanding how GP records 1099 Amounts Vendor Cards From the Vendor Card, select the Options tab to view the Tax Type and 1099 Box Regional Chapters
Understanding how GP records 1099 Amounts Routing 1099 amounts at Transaction Entry Regional Chapters
Understanding how GP records 1099 Amounts 1099 Details As the payment transactions post, the system updates the YTD 1099 Summary amount on the vendor record To view & Edit 1099 detail information: Cards -> Purchasing -> 1099 Detail To view 1099 detail: Inquiry -> Purchasing -> Vendor 1099 Details Regional Chapters
Understanding how GP records 1099 Amounts Why would a 1099 Summary be wrong? § The Vendor Summary buckets update with appended amounts from each transaction as the transaction posts. § You can change a vendor’s “ 1099 Type” at will, as many times as you wish. § Prior posted transactions do not change automatically, only new posted payment transactions will accumulate in the new bucket. Regional Chapters
Researching and validating 1099 data § Recipients (start with Smart. Lists) – Addresses – Formal Name per IRS records – Tax ID § Box Types § 1099 vs. non-1099 qualified payments to 1099 -vendors Regional Chapters
Researching and validating 1099 data Compare Transaction Summaries to 1099 Amounts If you don’t “Trust” your 1099 summaries, you can review transaction summaries with the following SQL Query Disclaimer: SQL Scripts can damage or destroy data. Use these scripts with caution on a test system first. Backup your database before using. Use the following script is at your own risk. We take no responsibility for any harm or data loss caused by these scripts nor do we warranty the validity of the results. The script is provided to assist your 1099 research activities, and must be independently validated against core system reports should you attempt to use these for final data extraction. Regional Chapters
Researching and validating 1099 data Sample SQL Query for 1099 amounts based upon Payables Transactions Available on Share My Code (http//dyndir. com) SELECT TOP (100) PERCENT CAST(DB_NAME() AS char(5)) AS Company. DB, dbo. PM 30200. VENDORID, SUM(dbo. PM 30200. DOCAMNT) AS Sum. Of. DOCAMNT, dbo. PM 00200. VNDCHKNM, dbo. PM 00200. ADDRESS 1, dbo. PM 00200. ADDRESS 2, dbo. PM 00200. CITY, dbo. PM 00200. STATE, dbo. PM 00200. ZIPCODE, dbo. PM 00200. PHNUMBR 1, dbo. PM 00200. TXIDNMBR, dbo. PM 00200. VENDSTTS, dbo. PM 00200. TEN 99 TYPE, SUM(dbo. CM 20200. TRXAMNT) AS Sumof. Trx. Amt, dbo. CM 20200. CHEKBKID, dbo. PM 00200. USERDEF 1 FROM dbo. CM 20200 INNER JOIN dbo. PM 30200 ON dbo. CM 20200. CMTrx. Num = dbo. PM 30200. DOCNUMBR AND dbo. CM 20200. CHEKBKID = dbo. PM 30200. CHEKBKID INNER JOIN dbo. PM 00200 ON dbo. PM 30200. VENDORID = dbo. PM 00200. VENDORID WHERE (dbo. PM 30200. DOCDATE > CONVERT(DATETIME, '2009 -12 -31 00: 00', 102)) AND (dbo. PM 30200. DOCDATE < CONVERT(DATETIME, '2011 -01 -01 00: 00', 102)) AND (dbo. PM 30200. VOIDED = 0) AND (dbo. CM 20200. VOIDED = 0) GROUP BY dbo. PM 30200. VENDORID, dbo. PM 00200. VNDCHKNM, dbo. PM 00200. ADDRESS 1, dbo. PM 00200. ADDRESS 2, dbo. PM 00200. CITY, dbo. PM 00200. STATE, dbo. PM 00200. ZIPCODE, dbo. PM 00200. PHNUMBR 1, dbo. PM 00200. TXIDNMBR, dbo. PM 00200. VENDSTTS, dbo. PM 00200. TEN 99 TYPE, dbo. CM 20200. CHEKBKID, dbo. PM 00200. USERDEF 1 HAVING (dbo. PM 00200. TEN 99 TYPE > 1) AND (SUM(dbo. PM 30200. DOCAMNT) >= 600) ORDER BY dbo. PM 30200. VENDORID (TEN 99 Type>1 will exclude “not 1099” vendors) Regional Chapters
How to edit 1099 s Editing 1099 Data in GP 2010 or later Tools -> Utilities -> Purchasing -> Update 1099 information Regional Chapters
How to edit 1099 s Enhanced Edit 1099 functionality in GP 2013 § GP 2010 edit 1099 status was an all or nothing action. You would reclassify the vendor and their transactions for the year or date range. § Now in GP 2013, you are able to review and edit individual transaction details, amounts, 1099 box, or 1099 type. Regional Chapters
How to edit 1099 s Enhanced Edit 1099 functionality in GP 2013 Regional Chapters
Best Practices: Tin Matching As Part of your Vendor Maintenance: § Perform Tin Matching as part of the New vendor creation process § “Offer” to withhold payment until correct information is submitted and validated § Near final bulk TIN match in December – Double Check record validity – Validate EIN vs. SSN number format – Review for appropriate box types (rent, medical) – Reminder: Box 14 Gross Proceeds paid to an attorney is for legal settlements only. Legal Services are recorded under Box 7 non-employee compensation Regional Chapters
Best Practices: Tin Matching Why Tin Match § Requirement for Payer To Secure a TIN Initial solicitation - for all payees, you must make the initial solicitation when the payee opens an account or when the transaction occurs using Form W-9 to request the taxpayer identification number. § The IRS CP 2100 or CP 2100 A Notice CP 2100 and CP 2100 A notices are notices that inform a payer that he or she may be responsible for backup withholding. This may be due to missing or potentially incorrect taxpayer identification numbers identified during the processing of Form 1099 information returns. It is accompanied by a listing of missing, incorrect, and/or not currently issued payee TIN. Large volume filers (250 or more erroneous documents) receive the CP 2100 notice, while all other filers receive the CP 2100 A notice. § Payers face potential fines of $100 per each 1099 filing with a missing or invalid TIN § "B" Notice If the IRS sends you a "B" notice indicating an incorrect payee TIN, you are required to backup withhold 28% from a payee no later than 30 days after receipt. Backup withholding until the payee furnishes a TIN and certifies that it is correct. Regional Chapters
Best Practices: Tin Matching IRS Tin Matching § Various 3 rd parties will submit on your behalf (~$135 for up to 100, 000 records) § Free through IRS e-services – Program Summary http: //www. irs. gov/Government-Entities/Indian-Tribal-Governments/Taxpayer-Identification. Number-(TIN)-On-Line-Matching – TIN Matching tutorial https: //la 2. www 4. irs. gov/People. Books/CRMPROD/Training/3 pdev/3 ptin/tinbulk 1. htm § Required IRS e-services Personal Registration Information – – – Legal name (verified with IRS & SSA records) Social Security Number (verified with SSA records) Date of birth (verified with SSA records) Telephone number , E-mail address Adjusted Gross Income (AGI) from either your current year or prior year filed tax return (verified from IRS records) Home mailing address (verified from IRS records). If you have moved since you last transacted with the IRS, please update your information when registering. Regional Chapters
Best Practices: Tin Matching IRS TIN Matching The TIN Matching e-services allow “authorized payers” the opportunity to match 1099 payee information against IRS records prior to filing information returns. An authorized payer is one who has filed information returns with the IRS in at least one of the two past tax years. § Interactive TIN Matching will accept up to 25 payee TIN/Name combinations onscreen § Bulk TIN Matching will allow up to 100, 000 payee TIN/Name combinations to be matched via a text file submission. Both programs will: § Match the payee with W-9 name and TIN with IRS records; § Decrease backup withholding and penalty notices; § Reduce the error rate in TIN validation. The TIN Matching system is accessible 24 hours a day, 7 days a week. Regional Chapters
Best Practices: Tin Matching TIN Matching Results Tin 1 Name 1 Tin 2 Name 2 Tin 3 Name 3 Tin 4 Name 4 Regional Chapters
3 Methods for 1099 Reporting 1. Native Dynamics GP Printing & manual filing 2. Greenshades –GP integrated software with service bureau offering 3. 1099 Pro – stand-alone software with service bureau offering Regional Chapters
1 st Method for 1099 Reporting – Native GP Native Dynamics GP 1099 Process § Allows you to print 1099 s for recipients § Federal Summary Report (1096) – In GP 2010, it does not generate the Federal summary report (1096), it has to be manually created – In GP 2013, it does generate the Federal summary report (1096) § Must manage filing or e-filing process on your own Regional Chapters
1 st Method for 1099 Reporting – Native GP Printing 1099 To Print: Tools-> Routines -> Purchasing -> Print 1099 Enter your Company information to be printed You can print all Vendors or enter a range Print option for printing an alignment only form Regional Chapters
1 st Method for 1099 Reporting – Native GP Adjusting the 1099 Form If the form alignment does not match your forms you will need to print to screen and edit in report writer. From the screen shot of the alignment form Click ‘Modify’ Once changes are made File->GP will return you to GP Regional Chapters
1 st Method for 1099 Reporting – Native GP Look for changes in forms with GP software updates For the 2013 year end, an update was made to the 1099 form so all customers must apply the year end update. Such changes are typical each year, so be sure to refer to Year End updates to ensure your program is up to date: Sample Links: Year End Update website: https: //mbs. microsoft. com/customersource/downloads/taxupdates/ Only GP 2010 and GP 2013 are supported with Year End Updates currently so customers on GP 10 or previous must upgrade to at least GP 2010 to be eligible for the update. Regional Chapters
2 nd Method for 1099 Reporting – Greenshades Year End Forms Printing § Prints recipient copies of Federal W-2 and Federal 1099 s directly to Blank Paper § Perforated Paper and Envelopes available § Print all forms, single form, or range of forms – www. downloadmyform. com § Search information on forms to print § Secure administrator controls over all functionality § Single source management of forms distribution, corrections and changes § Full reporting functionality including: – Employee requested changes – Print history – Electronic filing confirmations – Totals by company, state, dept or many more Regional Chapters
2 nd Method for 1099 Reporting – Greenshades Administrator Control Screen Regional Chapters
2 nd Method for 1099 Reporting – Greenshades Forms Editing • Edit Form Information in Visual Forms Viewer • Error Checking and Auto-Summing Fields Regional Chapters
2 nd Method for 1099 Reporting – Greenshades Recipient Distribution § Offer electronic reprints available directly from a recipients home/office computer § Print, Edit, and Re-issue easily § Perforated Paper and Envelopes available § Mail Service – Printing, stuffing, and mailing – Includes postage for as low as $1. 05 per form Regional Chapters
2 nd Method for 1099 Reporting – Greenshades Employee Access Screen Regional Chapters
3 rd Method for 1099 Reporting – 1099 Pro Software § Stand alone software for 1099 printing and e-filing services § www. 1099 pro. com Regional Chapters
Dynamics GP enhancement requests https: //connect. microsoft. com/ • Submit your feedback directly via the connect URL (left) or from the Communities Portal, Resources > Product Suggestions 1. Add Federal Summary Report to support 941 filings 2. Explore e. Filing possibility 3. Other? Regional Chapters
QUESTIONS ? Regional Chapters
Agenda • • Multi-Batch Print & Post Mekorma MICR Basic EFT/DD Support Secure Approval Workflow
Multi-Batch Print & Post • ALL batches from ALL companies from ONE window • Optional control using Secure Approval Workflow • Email EFT Remittances to Vendors • Post EFTs automatically after printing/emailing • Save up to 75% of time processing PM payment batches
Mekorma MICR Basic
Mekorma MICR Basic
Mekorma MICR Basic
Mekorma MICR Basic
Mekorma MICR Basic Avoid mis-numbered checks Easy and cheap to order stock Increased security No worries about getting the right stock into the printer • Easily add or change logos • Quick to make changes when needed • •
Mekorma MICR Basic • Automatic PDF copies • Suppress specific Benefits & Deductions • YTD Accrued Vacation • Print SOP information on Refund checks • Wide array of available fields for stubs – Notes fields – POP / Project Series • Check Image Archive • Audit Log • Custom integration available
Automatic Signatures by User ID Any number of potential approvers – Restricted to specific checkbooks – Maximum approval amount by User – 1 or 2 approvals required per check • Based on payment amount • Based on Vendor Class – Encrypted Signatures
Secure Approval Workflow Approvers 1 Approver 2 Approvers No approval needed Approval needed REJECTED Payments go into MICR Reject Batch Payment Sorted Batch is ready REQUEST APPROVAL APPROVED Released for Printing REQUESTER NOTIFIED
Workflow Scenarios & Demo Scenario 1 • 2 potential approvers • Only 1 approval always • Use approver’s signature • Email notice Scenario 2 • 2 potential approvers • 1 approval always • 2 nd approval over $5, 000 • Always use President’s signature • Text notice
Workflow Scenarios & Demo Scenario 3 • 2 potential approvers • Only 1 approval always • Use approver’s signature • Email notice • Vendor Class Security— Vendors in the ACCTG vendor class never have signatures printed on their checks.
EFT/DD Support • • EFT Security Email Remittances
Thank You ora@mekorma. com support@mekorma. com
Know Macros? Ora Goldman, CEO Craig Klapman, President Mekorma
Agenda ü What is a Macro? ü Macro Examples ü Creating a Macro ü Macro Gotchas and Maintenance ü Dexterity Assisted Macros #GPUGsummit
What is a Macro? A macro records steps you normally do manually for repetitive use. #GPUGsummit
Macro Examples Inquiry Reporting Posting #GPUGsummit Testing Transactions
Your Examples ü How have you used macros? #GPUGsummit
Inquiry ü Vendor/Customer Account Inquiry #GPUGsummit
Inquiry Steps without macro: Navigate Inquiry>Purchasing> Vendor Inquiry: 3 clicks Change sort to date: 2 clicks Open advanced lookup: 2 clicks Change lookup to ‘contains’ vendor name: 6 clicks Total: 13 clicks #GPUGsummit
Reporting ü Manual Journal Entry Review #GPUGsummit
Reporting Steps: Financial>Smartlist Favorites> Account Transactions: 3 clicks Add source doc column: 5 clicks Search: 1 click Limit by GJ and date range 11 clicks Total: 20 clicks #GPUGsummit
Reporting ü Consolidated Trial Balance #GPUGsummit
Reporting Steps: Run report 1 company: 6 clicks Switch companies 5 clicks Run report: 6 clicks Total: 6 + 11 x add’l companies Total for 10 companies: 105 clicks #GPUGsummit
Reporting ü Specific Account Detail Analysis #GPUGsummit
Reporting Steps: Run 3 report options 1 company: 10 clicks Switch companies 5 clicks Run reports: 10 clicks Total: 10 + 15 x add’l companies Total for 10 companies: 145 clicks #GPUGsummit
Reporting ü Sales Scorecard #GPUGsummit
Reporting Steps: Choose window from menus: 4 clicks Click process: 1 click Choose to show report to screen: 2 clicks Choose to skip other report: 1 click Total: 8 clicks #GPUGsummit
Posting üDaily Bank Deposit #GPUGsummit
Posting Steps: Navigate Transactions> Financial>Bank Deposits: 3 clicks Select checkbook: 3 clicks Print/save: 2 clicks Post/print posting journal: 2 clicks Total: 8 clicks #GPUGsummit
Posting ü Post SOP Invoice Batch #GPUGsummit
Posting Steps: Navigate Sales Batch Entry 3 clicks Select batch: 3 clicks or 11 keystrokes Allocate/Fulfill: 6 clicks Post: 1 click (plus 2 for each posting report) Total : 13+ clicks per batch #GPUGsummit
Testing ü Testing Payables Transactions #GPUGsummit
Creating a Macro ü Vendor Inquiry Steps without macro: Navigate Inquiry>Purchasing> Vendor Inquiry: Change sort to date: Open advanced lookup: Change lookup to ‘contains’ vendor name: #GPUGsummit
Macro Gotchas and Maintenance ü Commenting #GPUGsummit
Macro Gotchas and Maintenance ü Report Dialogs/ ü Posting Reports #GPUGsummit
Editing Demo #GPUGsummit
Macro Gotchas and Maintenance ü Fiscal Periods #GPUGsummit
Macro Gotchas and Maintenance ü Security Settings #GPUGsummit
Macro Gotchas and Maintenance ü Selecting from lists vs. Hardcoding for Choosing Data Types of lists (examples): üLook up windows üList view üTree view üPossibly Drop down lists #GPUGsummit
Suggested Naming Convention For report options !01 Macro-<. . > #GPUGsummit
#GPUGsummit
Macro Gotchas and Maintenance ü Relative Dates #GPUGsummit
Macro Gotchas and Maintenance ü Ways to get user input üPausing Macros üRunning Sequential Macros #GPUGsummit
Macro Gotchas and Maintenance ü Starting Dynamics with a macro ü Creating a login macro http: //support. microsoft. com/kb/856496 #GPUGsummit
Macro Gotchas and Maintenance ü Starting a Macro From Wrong Screen ü Clicking the mouse in GP while macro is running ü Referring to File on Hard Drive ü Using a shortcut instead of navigation ü GP 2013 web client macros not fully supported #GPUGsummit
Dexterity Assisted Macros ü Ability to Add Loops/Data Substitutions ü Check & Avoid Macro Gotchas ü Leverage Dynamics Business Rules ü Complement Custom Development by Wrapping it up #GPUGsummit
Resources—Just a Few Unattributed Basic and clear macro information Automating Processes with Macros (http: //allcomputers. us/windows_server/microsoft-dynamics-gp 2010 ---automating-dynamics-gp---automating-processes-withmacros. aspx/) Tod Heath: Good Uses of Macros (http: //blog. ignify. com/2010/02/06/dynamics-gp-macros-littlehelper-big-on-results/) #GPUGsummit
Resources—Just a Few Amy Walsch: Macros in Dynamics GP How to use Macros with word and Excel (http: //dynamicscare. com/blog/macros-in-dynamics-gp/) Tod Heath: Good Uses of Macros (http: //blog. ignify. com/2010/02/06/dynamics-gp-macros-littlehelper-big-on-results/) #GPUGsummit
Resources—Just a Few Mark Polino Book: Microsoft Dynamics 2013 Cookbook (http: //www. amazon. com/Microsoft-Dynamics-GP-2013 Cookbook/dp/1849689385) (http: //mpolino. com/gp/tag/macros/) Leslie Vail: Posting Multiple Batches Gotchas (http: //dynamicsconfessions. blogspot. com/2013/02/postingmultiple-batches-with-macro. html) #GPUGsummit
Resources—Just a Few Mariano Gomez: How to schedule Dynamics GP to automatically log in and run an Integration Manager integration (http: //dynamicsgpblogster. blogspot. com/2009/01/how-toschedule-dynamics-gp-to. html) #GPUGsummit
Questions? Ora Goldman, CEO Craig Klapman, President Mekorma Ora@Mekorma. comcraig@mekorma. com Support@Mekorma. com CPE Point Code: G 174 #GPUGsummit
- Microsoft dynamics ax edi
- Axug 2018
- Sharing
- Learn and share in english 1
- Learn and share in english 2
- Learn and share in english 1
- Kinesthetic learning
- Dynamics crm power bi
- Sitecore dynamics gp connect
- Nopcommerce dynamics ax connector
- Crm user group
- User adoption reports for dynamics crm
- Single user and multiple user operating system
- Types of operating systems
- Veeam cloud connect to microsoft azure
- Isv cloud embed
- Wholesale sat nav
- Rockton smartfill
- Sugarcrm riva crm
- Student relationship management
- Dynamics 365 for talent onboard
- Metapack microsoft dynamics nav integration
- Microsoft dynamics nav discount approval solution
- Docmail microsoft dynamics ax integration
- Microsoft dynamics mrp2
- Axapta van-sales
- Microsoft dynamics 365 procurement
- Microsoft dynamics 365 public sector
- Bluestar plm by pdm technology
- Email marketing microsoft
- Microsoft dynamics gp compliance automation
- Office automation microsoft dynamics gp
- Microsoft dynamics nav 2009 installation guide
- Microsoft dynamics wi
- Sure step microsoft
- Microsoft dynamics gp roadmap
- Apps4pro migration manager
- Creditsafe revenue
- Gp employee portal
- Microsoft dynamics academic alliance
- Microsoft dynamics for high tech
- Microsoft dynamics 365 real estate
- Microsoft dynamics sl
- Microsoft dynamics crm 4
- Wise men three clever are we
- Microsoft official academic course microsoft word 2016
- Microsoft official academic course microsoft excel 2016
- Windows startwarren theverge
- Microsoft excel merupakan progran aplikasi..
- Microsoft official academic course microsoft word 2016
- Think pair share example
- Intrinsic value per share formula
- Think pair share kagan
- Organic oil recovery
- Think pair share activity
- Thevideo pair
- Dividend per share example
- Wipro 10000 investment in 1980
- Kagan rally coach instructions
- Think pair share poster
- Wipro share price in 1980
- Paid up share capital
- Safety share ideas
- Book value per ordinary share
- Markedsutfordrer
- Share research experience and knowledge
- Think pair share cooperative learning
- Relative market share formula
- Market size sample
- Share
- Capital reduction and reconstruction
- Share appreciation rights
- Five forces ikea
- Do humans share dna with bananas
- Hng nashik
- Harley davidson market share
- Hydraulic pumps market size
- Enron gas bank
- Bonus fraction eps
- Kingdom of protist
- Divide and share
- Total share capital
- Loosely organized groups who share interests and activities
- Bartlett company balance sheet
- Types of ratio analysis
- Earnings per share ratio analysis
- Dilutive securities and earnings per share
- What is debenture
- Cite one real life example in your school
- Share buy back journal entry
- File sharing best practices
- Ucc39002
- Creditor days
- Love share invite
- Mobile x share
- What are think-pair-share debates?
- Pixi maths aiming for grade 5
- Proportional share scheduling
- Glunovo share
- Charles and keith building
- Descon oxychem
- Geishakid xxx
- "share purchase agreement vs asset purchase"
- Entity relationship diagram multivalued attribute
- Cash flow per share
- Nnnn share price
- Metal resistance to share during chip formation is known as
- Alfresco hezkuntza share page
- Carly and james share some money in the ratio 5:3
- Twitter shorten url
- Chrono share
- Share approach
- Share approach
- Jovian planets share all of the following traits except
- Share and discuss
- Words that sound alike because they share
- Share a single centralized memory
- Mix pair share kagan
- Fair share problems
- Elks care elks share
- Syent share price
- Simone tata age
- Wells fargo share price today
- Be prepared to share the hope
- Share approach model
- 7 golden rules to share information
- Aluminum chloride charge
- Think pair share advantages and disadvantages
- Will and olly share £80 in the ratio 3 2
- Office share
- Type of share
- Alice and olivia share some sweets in the ratio 7 3
- Simplify the following ratios
- Secure online photo sharing
- Darlene redmond