Microsoft Dynamics Guru

Running Fixed Assets Depreciation causes Microsoft Dynamics GP to "hang"

2011-12-24T21:43:00.000-08:00

I just completed a full upgrade of Microsoft Dynamics GP from version 9 to version 2010 R2 for a client and they were going through their first month-end closing in the upgraded system. 3 weeks ago, after the upgrade, they reported experiencing an issue running Fixed Assets depreciation from two laptop computers, where apparently, when running depreciation the system would hang. The only option to recover would be to terminate the Dynamics.exe process from Task Manager. Nonetheless, we did not pay much attention to this at the time since the process was completed successfully from another machine, just in time to close the month of August - more on this later.

More on :http://dynamicsgpblogster.blogspot.com/2011/09/running-fixed-assets-depreciation.html

Move SOP trs from one batch to other

2011-12-22T02:23:00.000-08:00

-- Created by Mariano Gomez, MVP
-- Maximum Global Business, LLC
declare @bachnumb char(15), @strpostdate char(20), @interid char(5)
declare @postdate datetime
declare @numtrx int, @batchamount numeric(19,5)
declare @noteindex numeric(19,5)
declare @l_result integer, @error_state integer

set @bachnumb = 'XCPTNS' + convert(char(4), year(getdate())) + '_' + convert(char(4), month(getdate())) + '_' + convert(char(4), day(getdate()))

-- drop timestamp
set @strpostdate = convert(char(20), getdate(), 101)
set @postdate = convert(datetime, @strpostdate)

-- move the left behind order transactions to
-- the new exception batch
update sop10100 set bachnumb = @bachnumb where bachnumb = 'SHIPTODAY' and soptype = 2

-- adjust the 'Ship Today' batch amounts for the
-- documents that did get transferred
select @numtrx = IsNull(count(sopnumbe), 0), @batchamount = IsNull(sum(docamnt), 0) from sop10100 where bachnumb = 'SHIPTODAY'
update SY00500 set NUMOFTRX = @numtrx, BCHTOTAL = @batchamount where bachnumb = 'SHIPTODAY'

-- get next note index to assign to the new batch
SELECT @interid = DB_NAME()
EXEC @l_result = DYNAMICS..smGetNextNoteIndex @interid, @@SPID, @noteindex output, @error_state output

-- get the number of transactions and amounts for the new batch
select @numtrx = IsNull(count(sopnumbe), 0), @batchamount = IsNull(sum(docamnt), 0) from sop10100 where bachnumb = @bachnumb

-- create the new batch in batch headers based on the
-- majority of fields in the old batch

INSERT INTO SY00500
( GLPOSTDT
, BCHSOURC
, BACHNUMB
, SERIES
, MKDTOPST
, NUMOFTRX
, RECPSTGS
, DELBACH
, MSCBDINC
, BACHFREQ
, RCLPSTDT
, NOFPSTGS
, BCHCOMNT
, BRKDNALL
, CHKSPRTD
, RVRSBACH
, USERID
, CHEKBKID
, BCHTOTAL
, BCHEMSG1
, BCHEMSG2
, BACHDATE
, BCHSTRG1
, BCHSTRG2
, POSTTOGL
, MODIFDT
, CREATDDT
, NOTEINDX
, CURNCYID
, BCHSTTUS
, CNTRLTRX
, CNTRLTOT
, PETRXCNT
, APPROVL
, APPRVLDT
, APRVLUSERID
, ORIGIN
, ERRSTATE
, GLBCHVAL
, Computer_Check_Doc_Date
, Sort_Checks_By
, SEPRMTNC
, REPRNTED
, CHKFRMTS
, TRXSORCE
, PmtMethod
, EFTFileFormat
, Workflow_Approval_Status
, Workflow_Priority
, TIME1)
SELECT
glpostdt
,bchsourc
,@bachnumb
,series
,mkdtopst
,@numtrx
,recpstgs
,delbach
,mscbdinc
,bachfreq
,rclpstdt
,0
,bchcomnt
,brkdnall
,chksprtd
,rvrsbach
,userid
,chekbkid
,@batchamount
,BCHEMSG1
,BCHEMSG2
,BACHDATE
,BCHSTRG1
,BCHSTRG2
,POSTTOGL
,MODIFDT
,CREATDDT
,@noteindex
,CURNCYID
,0
,0
,0.00000
,PETRXCNT
,APPROVL
,APPRVLDT
,APRVLUSERID
,ORIGIN
,0
,GLBCHVAL
,Computer_Check_Doc_Date
,Sort_Checks_By
,SEPRMTNC
,REPRNTED
,CHKFRMTS
,TRXSORCE
,PmtMethod
,EFTFileFormat
,Workflow_Approval_Status
,Workflow_Priority
,TIME1
FROM SY00500
WHERE bachnumb = 'SHIPTODAY'

source - http://dynamicsgpblogster.blogspot.com/2008/04/moving-sop-transactions-from-one-batch.html

auto generate customer id script

2011-12-22T02:21:00.002-08:00

SELECT
-- evaluates the 9 first characters of the customer name and removes any blanks
-- other characters can be removed) in between those first 9 characters for a
-- total of 8, adds an extra zero if needed to complete 9 characters
CASE LEN(UPPER(REPLACE(SUBSTRING(CUSTNAME, 1, 9), ' ', '')))
WHEN 8 THEN UPPER(REPLACE(SUBSTRING(CUSTNAME, 1, 9), ' ', '')) + '0'
ELSE UPPER(REPLACE(SUBSTRING(CUSTNAME, 1, 9), ' ', '')) END +

-- accounts for the rest of the string, uses the rank function to do the numbering,
-- partitioning by customer name. Just in case there is more than one customer
-- with the same starting 9 characters, rank() will number them sequentially
SUBSTRING('000', 1, 3 - LEN(CONVERT(CHAR(3), RANK() OVER(PARTITION BY REPLACE
(SUBSTRING(CUSTNAME, 1, 9), ' ', '') ORDER BY CUSTNAME))))
+ CONVERT(CHAR(3), RANK() OVER(PARTITION BY REPLACE(SUBSTRING(CUSTNAME, 1,
9), ' ', '') ORDER BY CUSTNAME))
FROM RM00101
ORDER BY CUSTNAME

source- http://dynamicsgpblogster.blogspot.com/2010/02/sql-autogenarating-customer-ids.html

Microsoft Dynamics GP displaying overlapping text on home page

2011-12-22T02:21:00.001-08:00

http://dynamicsgpblogster.blogspot.com/2011/12/microsoft-dynamics-gp-displaying.html

Settings of dex.ini file

2008-08-27T01:36:00.000-07:00

Friends,

Here is a file which shows some ini file settings.
Please get file here

Some Implementation Tools Available

2008-08-27T01:25:00.000-07:00

Friends,

Now the Rapid Implementation Tools are available for download here.

The Rapid Implementation/Configuration tools is designed to quickly setup the applicaiton and the Rapid Migration Tools is designed to quickly convert Data from Quickbooks Accounting software.

Terminal Relogin problem for copy/paste narrations

2008-08-27T01:21:00.000-07:00

Friends, RDPCLIP is the process that allows users to copy/paste between their remote & local desktops.

Initially if you login and you may not able to copy/paste. You launched GP 10.0 & was unable to copy/paste. Now stop and restart RDPCLIP: and you could copy & paste again!!!

Using Dynamics GP Named Printers on a Terminal Server

2008-08-27T01:15:00.000-07:00

Friends, Please take a look at Dave Musgrave's latest post where he explains the ins and outs of using Named Printers on a terminal server. Dave even links to a GP paper he wrote with step by step instructions. Thanks David.

Microsoft Dynamics GP (Great Plains) Integration

2008-08-26T04:20:00.000-07:00

Integration or duplication? If your systems are not integrated then your staff will repeat work twice by re-keying information into different systems. Not only does this dramatically increase your costs, it also means you will have different and outdated information across your systems.
The only way to streamline your systems, reduce duplication and ensure consistency of information throughout your systems is to have automatic online integration between your different systems.
One of Microsoft Dynamics GP many outstanding features is its world leading integration facility. Microsoft Dynamics GP provides outstanding tools and ease of use in safely integrating and linking your systems together. It provides a range of integration tools for online and batch integration.
The integration methods available are:
BizTalk
Integration Manager
eConnect
Integration Assistant for Excel
Database level integration
Data Warehousing
Crystal Enterprise and Business Objects
Database Level Integration e.g. MS SQL and MS Access
One of the key concerns of integration and software tailoring is to adapt systems to your business needs without introducing problems with compatibility and future upgrades and support. Microsoft's integration tools prevent this problem from occurring. Different systems exchange information with each other using a clearly defined set of rules. It is then easy to upgrade each system (Microsoft Dynamics GP, CRM system, Operating System, etc.) without the upgrade causing any adverse affect or compatibility problems with linked systems.
For more detailed information about Microsoft's integration methods, please contact Communicat.

Microsoft Dynamics GP (Great Plains) Features

2008-08-26T04:16:00.002-07:00

Microsoft Dynamics GP provides an outstanding range, depth and breadth of functionality. The list below details just some of the available software modules:

Accounts Receivable
Accounts Payable
Activity Based Costing also known as Activity Based Management
Analytical Accounting
Audit trail at an outstanding level of detail and simplicity that is ideal to streamline your audit processes.
Bank Reconciliation
Bank Statement Download
Barcoding
Bill of materials
Budgeting
Business Activity Statement information automatically generated
Business Intelligence and Reporting
Cashbook
Cash Flow Management
Collections Management (debt collection tracking and procedure tracking)
Consolidation
Contact Management and Tracking
Creditors
Debtors
Distribution
e-Business / e-Commerce / e-Expense / eOrder / eSell
Electronic Funds Transfer (EFT) - Payments and Receipts
Export Costing
Financial Reporting and Analysis including XBRL reporting for compliance with International Accounting Standards (IAS) and International Financial Reporting Standards (IFRS)
Fixed Asset Management and Asset Register
Forecaster
General Ledger
Goods receiving and quality tracking
Human Resources
Import Costing
Integration with all your systems using a range of online and batch processes to suit your needs
Intercompany and multi-company journals processing automatically processed (sometimes called "Quad Accounting".
Interfund - this is important for non-profit organisations, mining and exploration companies which need to manage grants. Refer to the fact sheet database for further information on Interfund
Inventory
Invoicing
Job Costing
Key Performance Indicators / Executive Summary
Landed Costing
Lead tracking
Multi-Company, Multi-Entity
Multi-Currency
Multi-Dimension Analysis
Multi-Language
Payments
Periodic and Recurrent billing
Point of Sale
Procurement
Professional Services Time Costing
Project Accounting
Purchase Ordering
Receipts
Return for Maintenance Authority (RMA) tracking
Security for user groups configurable to menu level and through to a field level
Serial Number Tracking, Batch Tracking and Roll Tracking
Sharepoint
Shipment Tracking
Special Pricing, Advanced Pricing and Matrix Pricing
Stock Control
Receivable Management
Replenishment
Sales Analysis and Reporting
Sales Kitting
Sales Order Processing
Sales Quotations
Time and Expense Billing
Web / Intranet Portal
Webparts

Introduction to Dynamics GP

2008-08-26T04:10:00.000-07:00

Microsoft Dynamics GP (Microsoft Business Solutions - Great Plains)

Microsoft Dynamics GP (formerly Microsoft Business Solutions - Great Plains) combines powerful features, compatibility and reliability with incredible ease of use at an affordable price. Microsoft Dynamics GP has proven it's market and technical leadership. It incorporates the latest Microsoft technologies including .NET and MS SQL. Microsoft Dynamics GP operates as both a Windows software application and as a Web Portal.
Users operate their system from either a Windows PC or a zero-overhead Internet browser such as Internet Explorer. This means your business can embrace the e-Enterprise methodology with applications for self-service, business intelligence, and e-Commerce. This allows you to reduce your overheads and provide simpler systems to your users at a lower cost, as well as all of the other advantages of using Microsoft Accounting Software.
Please note that Microsoft Dynamics GP has a wide range of modules and versions have been available under a variety of names including Microsoft Dynamics GP Professional and Microsoft Dynamics GP Standard. We refer to all of these versions as simply Microsoft Dynamics GP.

How can Microsoft Dynamics GP (Great Plains) help you?

Microsoft Dynamics GP will help you efficiently manage the following activities:
Accounting and finances
Distribution and supply chain processes
Manufacturing forecasts
Order tracking, fulfilment and expediting
Project accounting and budgeting
HR and payroll processes including providing employees with self-service access to personal data through the web portal
Automate and streamline the management of field service operations
Analyse and report on the business performance of your company
Integrate browser-based e-commerce solutions to connect with clients and suppliers
Provide employees browser-based access to vital business information and processes

Welcome Friends

2008-08-26T04:04:00.001-07:00

Welcome Friends,

Although there are lots of groups for MS Dynamics, but this blog is specially developed in order to exchange valuable informations between Microsoft Dynamics Consultants, users.

Hope We make this blog more and more informative.

thanks friends,