Tuesday, December 21, 2010

Dynamics GP2010 R2 to Feature New BI Capabilities & Build on Customer Success

The Microsoft Dynamics GP2010 R2 update expands key areas of investment for Microsoft Dynamics GP2010, including the following:


  • Enhancing insight into role-specific information through an improved user interface and personalized dashboards, quickly delivering information that's relevant to the actions people are taking or the information they are viewing.

  • Making it easier to complete tasks with improved approval workflow and electronic signature capabilities, helping people save time while managing compliance and helping to reduce fraud.

  • Extending connections through Fact Boxes and Action Shortcuts, which are now connected with Microsoft Lync 2010 instant messaging windows, bringing information about the people who are chatting and their companies to the user's fingertips.
Scheduled release is the first half of 2011.

Friday, December 10, 2010

Helpful Year-End Closing Information

Vital Notes
  • Close General Ledger Closing Last
  • User your Checklists (Paper or System)
  • Perform and VALIDATE your backups
  • Fiscal Year vs Calendar Year difference
  • Date Sensitive (except "amount since last close")
  • No updated available for version 8.0 (last year for v9.0 - only up to Jan 11th, 2011)
  • YEAR-END Update - There were W-2, W-3, and AP 1099 changes for 2010 - Nov 2010
  • 2011 Payroll Tax Changes will be ready Dec 16th
Links for Year-end Closing
(CustomerSource -> Support -> Knowledgebase -> Article #)

Thursday, December 9, 2010

Year End Close WERKS

Thank you to all who attended our "Year-End Close" WERKS today! We hope the information was valuable, insightful, and you are able to apply what you learned to your current work environment.

In today's WERKS - Do you need a refresher course in year end closing? Attend this webinar for hints, reminders, and tips to make this year's closing process the smoothest yet. Did you know you can control the transactions that post to your cash and AP accounts? Do you know where to adjust your 1099 information? Have you added Fixed Assets into the mix recently? Do you know where to find the latest tax updates? Do you know how to move Analytical Accounting transactions to history?

CLICK HERE to request a copy of today's WERKS powerpoint.

Thursday, December 2, 2010

Add Vendor Address Info to Check Remittance in Payables Mgmt

Applies To: Microsoft Dynamics GP 10.0 & Microsoft Dynamics GP2010 (EFT for Payables & Payables Mgmt)

To add the primary vendor address information from the PM Vendor Master file (PM00200) to the EFT Check Remittance report, follow the below steps:

NOTE: The below steps will print the primary address that is shown on the Vendor Mainenance Card in Microsoft Dynamics GP on the EFT Check Remittance Report, regardless of what vendor address ID is on the invoice itself, if various address IDs are used for the vendor. See addt'l info section for more info on pulling in the address information associated with each specific report.

Open Report Writer:

  1. In Microsoft Dynamics GP, open Report Writer. To do this, click on Microsoft Dynamics GP -> Tools -> Customize -> Report Writer.
  2. Leave the product as Microsoft Dynamics GP and click OK.
Create the table Relationship:
  1. Click on Tables and select Tables again.
  2. Find the PM_Payment_Work_TRX table. Click to select it and click Open.
  3. Click Relationships.
  4. Click New.
  5. In the Table Relationship Definition window, click on the ellipsis button next to the Secondary table.
  6. Find the PM Vendor Master File and click OK.
  7. For the Secondary Table Key, click the drop-down list and select PM_Vendor_MSTR_Key1.
  8. On the left side, select Vendor ID to match the Vendor ID's up between the tables. Click OK.
  9. Close the Table Relationshis window, and click OK on the Table Definition window to close it. Close the Tables window.
Drag the new fields on to the report layout:
  1. Now click on Reports in the top menubar.
  2. Select the Payables EFT Remittance report and click Insert to move it over to the right side of the window.
  3. Click to highlight the report in the Modified Reports list and click Open.
  4. The Report Definition window will open.
  5. Click on the Tables button to open the Report Table Relationships window.
  6. Highlight 01.PM Payment WORK Shadow table and click New.
  7. The PM Vendor Master File should be listed and highlighted, so just click OK.
  8. In the Toolbox window, use the table drop-down list to select the PM Vendor Master File.
  9. Drag the address fields (Address 1, City, State, Zipcode) to the H1 section of the report layout, say under Vendor ID. You may need to adjust this section of the report layout to be bigger.
  10. When finished, close all the windows in Report Writer, and click Save to save your changes when prompted.
Grant access to the modified report:
  1. Click on File, and Microsoft Dynamics GP to get back to GP.
  2. Grant access to the modified report as follows:
  • In GP, click on Microsoft Dynamics GP -> Tools -> Setup -> System -> Alternate/Modified Forms and Reports
  • Enter the ID for the user (such as Defaultuser)
  • Product: Microsoft Dynamics GP
  • Type: Reports
  • Click the + to expand the Purchasing series
  • Click the + to expand the Payables EFT Remittance
  • Mark to grant access to the Microsoft Dynamics GP (Modified) version of the report.
  • Click Save.

Additional Information: In order to get the vendor address information for different Address IDs associated with each specific invoice to print on the Check Remittance Report, you would have to create an addt'l Tables Relationship from the steps outlined above. If the customer has different address IDs used on various invoices, you would have to link PM_Payment_Work_TRX table to the PM Transaction OPEN File (PM20000) first. This file will have the address ID in the VADCDTRO column. Then you must link this address field to the PM Address MSTR (PM00300) tables to the specific address (ADRSCODE field). If you wanted Microsoft to customize this report for you, it would be considered a consulting expense. Please contact your Collins Computing managing consultant.