Dynamics GP - Purchasing Tables

• POP10100 - PO Hdr
• POP10110 - PO Line
• Source_Document_Number - reqlogic number

Dynamics GP - Inventory - Assembly Bill of Materials Tables

• BM00101 - BOM Header
• BM00111 - BOM Detail
• BM10200 - Work Assembly Trx Hdr
• BM10300 - Work Assembly Trx Dtl
• BM30200 - Posted Assembly Trx Hdr
• BM30300 - Posted Assembly Trx Dtl

SSRS Training Topics

• Basic
• Setup
• How to install SSRS
• How to Manage SSRS
• 
  
• Security
• Data Sources
• SQL Views
• Reports
• Advanced
• Advanced SQL Views
• Stored Procedures
• Reporting Tricks
• Exercises
• Build a Sales Report
• Group and filter by Customer, Item
• Show Sales, Vat, Profit

Implementation Methodology

• Definition - What are we doing? Is this realistic?
• Project Planning
• Business Objectives
• Feasibility
• Time
• Resources
• Budget
• Analysis - What do you REALLY want? in Detail
• Business Requirements (Fit gap) - How are we meeting each requirement?
• Workarounds
• Screen Layouts - Do any screens need to be modified?
• Report Layouts - Do any reports need to be modified?
• System Architecture Requirements - What will we need to run this?
• Future Business Processes - What processes will change?
• Transition Strategy - What has to start changing from now
• Reconciliation plan - Internal audit before and after go live
• Data Migration Map/Template Workshops - What data is going into the new system?
• Install Software
• Install sample data
• Create Live and Test environments
• Configure Backups
• Enable Logging
• Enable Archiving
• Design - This is how we're gonna do it, it's going to cost more
• Rapid Process Test
• Run through all future processes in Test system
• Confirm Forms and Reports changes in Test system
• Finalize Customizations - Signoff
• Define all scope changes required to meet Final Requirements
• Module Configurations - Signoff
• FDD
• Develop - Build it. Test it. Test it. Test it some more.
• Build Customizations
• Test Customizations
• Configure System
• Test Import Data
• Historical Data
• Current Data
• Confirm GL, AR, AP, INV MUST reconcile
• Pilot Test Entire Integrated System
• Test Scripts
• Test Security
• Test Reconcile
• Mock Go-Live
• Go Live Readiness Review and Discussion
• Post mortem on all issues during mock go-live
• Agree on a realistic Go-Live date
• Deploy- This is how you use it
• End User Training
• User Manuals
• Change Management
• Final Data Migration
• Current Data
• Confirm GL, AR, AP, INV MUST reconcile
• Take Final Backups of all Customizations
• Operate - Start using it
• Go-Live
• Support - Use it better
• Support
• Resolve Red Flag Issues Immediately
• Refine Configurations
• Refine Modifications
• Additional Modifications

SSRS Data Source Connection String

Data Source= SRV-GPS;Initial Catalog=TWO;Integrated Security=False


SRV-GPS = SQL Server name\instance
TWO = Database name

eOne Smartconnect - Scheduled maps stop running for no reason

This is an issue that they are currently working on 

1.  Scheduling the SmartConnect scheduling service to restart once a day.  This will solve any sort of "out of memory" issues, or issues where the scheduler shows it's running, but it won't pick up any maps.  I wrote a blog article on how to use a batch file to restart the scheduling service using the Windows task scheduler, you can find it here: http://www.eonesolutions.com/blog-post/restart-smartconnect-scheduling-service-using-batch-file/

Create a batch file with these lines
---------------------------------------------------
taskkill /F /IM eOne.SmartConnect.WindowsService.exe
timeout 30
sc start eOne.SmartConnect.WindowsService.exe

----------------------------------------------------

2.  Creating a SQL job to delete any users that have been stuck in maps longer than 15 minutes.  So if you have a map that is repeating say every 10 minutes for the entire day, and a user gets stuck in it for longer than 15 minutes, then you know the map is stuck.  So then you create a SQL job that deletes any activity records older than 15 minutes, and then have the job run every 15 minutes.  

delete MapActivity where CheckType='Service' and DateTime <=dateadd(minute,-15,getdate())

This can be created in a sql stored procedure in the master db and be called from anywhere

A sql job can also be created to restart the smartconnect service

-- To allow advanced options to be changed. EXEC sp_configure 'show advanced options', 1; GO -- To update the currently configured value for advanced options. RECONFIGURE; GO -- To enable the feature. EXEC sp_configure 'xp_cmdshell', 1; GO -- To update the currently configured value for this feature. RECONFIGURE; GO
xp_cmdshell 'NET STOP eOne.SmartConnect.WindowsService.exe'

xp_cmdshell 'NET START eOne.SmartConnect.WindowsService.exe'

3. The schedule may be set badly causing it to not repeat correctly.
Avoid the following situations.

• Do not schedule multiple maps to begin at the same time
• Set all daily repeating schedules as follows
• start time is 12am
• duration is 1440 = 24hrs
• If you need to run multiple maps, make one map as master, let it run all other maps so they don't bump into each other

A - b
A - C
A - D


don't daisy chain maps

Data Director - Conversion Overflows Error

Change the option in the DD server under App Config>Decimal Fix to "BIG"
Send Config
Restart DD service