Thursday, July 19, 2012

The microsoft_dynamics_gp.vba project references some objects that cannot be found.

This occurs because a field that was added to vba has been removed from your customized form or report.


To manually remove the vba reference to that field




1. Export your Form/Report with VBA to a .package file (Tools>>Customize>>Customization Maintenance).
2. Open the .package file with notepad and find the references to the field you need to remove.
3. Remove any references to your field. Most importantly, remove the WindowField reference. This is how VBA knows about the field. It will look like this:

WindowField "Transfer Button"
{
ArrayIndex "0"
DisplayName "Transfer"
Local "false"
ProgrammerName "Transfer Button"
}


or

ReportField "String1"
{
AccumulatorType "0"
ArrayIndex "0"
BandLevel "0"
BandType "0"
FieldName "String 1"
TableName ""
}


4. Save your .package file and import the modified version.(Tools>>Customize>>Customization Maintenance).


Original post
http://mbsguru.blogspot.com/2009/06/removing-reference-to-field-or-object.html

Dynamics GP - Upgrade from GP10 sp5 to GP2010(R2) SP3


  1. Review the upgrade documentation, and download the latest installs here- https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/mdgp2010_release_download.htm?printpage=false
  2. The latest version including sp3 resolves prior issues with version detection
  3. Specific Service Pack info can be found here- https://mbs.microsoft.com/customersource/downloads/servicepacks/MDGP2010_PatchReleases
  4. Backup all companies
  5. Export any customized triggers
  6. Backup the GP client folder
  7. Backup your dictionaries
  8. Export all customized forms and reports as a package
  9. Print any reports necessary
  10. Set all databases to 100 compatibility
  11. Run the GP2010 install
  12. Run GP2010 Utilities
  13. Upgrade all companies
  14. Import all customized forms and reports using the package
    1. If this does not work, use blank 2010 dictionary and import reports directly from backup of dictionary through report writer import
  15. If errors occur, check the program files\gp\data folder for the duinstall.log or dexsql.log if you're using the debugger tool

Monday, July 16, 2012

Network Restructure Model


  1. Take inventory of current resources using Windows InTune
  2. Setup Domain 1 as Production environment
  3. Allocate resources to production
  4. Setup Domain 2 as Dev environment
  5. Allocate resources to Dev

Dynamics GP - Training Topics & Sessions


Extended Pricing is Avilable in Core GP from GP2013 onwards.
Prior to GP 2013, It was only available as an a la carte module, or with GP Professional and GP Advanced Management

Core
  1. Administration
    1. Customersource
      1. User Access
      2. Licensing & Registration
      3. E-Learning
      4. Knowledge Base
    2. GP Server & SQL Overview
      1. SQL Management Studio
      2. sa Account
      3. ODBC
      4. GP Module selection
      5. GP Utilities
      6. Create a Company
      7. Dynamics & Company Databases
      8. Backup and Restore
      9. Create a test company
    3. GP Client Install
      1. ODBC
      2. Module selection
      3. Office Integration
    4. Customizations
    5. Dynamics.set  and Dictionaries
    6. Checklists
    7. Users & Security
      1. Create Users
      2. Customized Forms / Reports
      3. Setup forms access
      4. Setup report access
    8. User Activity & Tracking
      1. User Activity
    9. Named Printers
    10. Monthly Maintenance
      1. Check Links
      2. Reconcile
      3. Recompile & Update
    11. Year End Procedures
    12. Troubleshooting Common Issues
      1. Power failures
      2. Record / User Locking
      3. Batch Recovery
      4. Dictionary Errors
  2. Foundation
    1. Basic Elements
      1. Lookup windows
      2. Browse Buttons
      3. Zoom
      4. Navigation bar
      5. Shortcut Bar
      6. Home Page
      7. User Preferences
    2. Window / Record Notes
    3. Attachments
    4. Smartlist
      1. Creation / Modification
      2. Export to Excel
    5. Use Inquiries and Reports
    6. Business Alerts
    7. Process Server Options
  3. General Ledger
    1. General Journals
    2. Reversing Journals
    3. Voiding Transactions
    4. Posting Setup / Processes
    5. COA
    6. Fiscal Periods
    7. Month End Soft Close
    8. Copy / Paste GL
      1. Description
      2. Account
      3. Debit
      4. Credit
    9. Allocation Accounts
    10. View Transactions
    11. View Posting 
  4. Purchasing

  5. Accounts Payable
    1. Invoice
    2. Build Check Batch
    3. Cheque Payment
    4. Apply Payments
    5. AP Trial Balance
  6. Inventory
    1. Costing Methods
    2. Units of Measure
    3. Item Classes
    4. Item Types
    5. Item Master
    6. Lots and Serials
    7. Standard Pricing
    8. Extended Pricing
    9. Bill of Materials
    10. Locations
    11. Transactions
      1. Adjustments
      2. Stock Counts
      3. All transactions that affect inventory
    12. Report
      1. Stock Inquiry
      2. Historical Inventory Trial Balance
  7. Sales Order Processing
    1. Document Types and Document Flow
      1. Quotes > Orders > Backorders> Invoices
      2. Number Series
      3. Security Options and Password overrides
      4. Document Fulfilment Options
      5. Customer Hold
      6. Document Holds
    2.  Sales Line Items
      1. Units of Measure
      2. Line Item Pricing
      3. Serials/Lots
      4. Line Item Quantity Override options
      5. Credit Limit Checks
    3. Discounts and Markdowns
    4. Cash Receipts
    5. Posting & Printing
    6. SOP Smartlists
  8. Accounts Receivable
    1. Invoice
    2. Cash Receipt
    3. Apply Payments
    4. AR Trial Balance
    5. Customer Statement

Optional
  1. FRx
  2. Bank Reconciliation
  3. Fixed Assets
  4. Human Resources
  5. Manufacturing
  6. Field Service
  7. Management Reporter
  8. Integration Manager

Wednesday, July 4, 2012

Sharepoint - SSRS Report Builder - To use Report Builder, you must install .Net Framework 3.5 on this computer.

When you try to launch the report builder from sharepoint to edit your SSRS report, you get the following error

"To use Report Builder, you must install .Net Framework 3.5 on this computer."
"Install .Net 3.5"

Clicking on the link does not work
When you check the machine, it says .net 3.5 is correctly installed


The problem is internet explorer 9.

Enable Menu Bar if you do not see "File, Edit, View..."

  • Click on the gray area on the top of the browser window
  • Tick Menu Bar

Go to

  • Tools>Compatibility View Settings>
  • Enter the sharepoint site name (the computer name is enough) >Click Add
Report builder will launch correctly now.