Microsoft Dynamics GP

Forum Post: RE: A save operation on table 'MO_Order_MSTR' failed accessing sql data

Almas Mahfooz — Tue, 21 May 2013 07:03:00 GMT

good finding.

Forum Post: RE: How do I import cash receipts and apply to specific invoices in Integration manager?

StefanieC — Tue, 21 May 2013 06:30:00 GMT

By the way, I also tried the integration with a text file. Same results. :(

Forum Post: RE: GP 10 takes too much time while posting Sales Transaction.

Asif Fattah — Tue, 21 May 2013 05:01:00 GMT

Currently in our existing GP Server I have Total No. of Sales Transaction are 2000. In single batch I have one or two Transaction which I am going to Post but that 1 or 2 Transaction taking 20 to 30 minute. This delay only happen in Sales Transaction. When I am going to post other then Sales Transaction Its working fine. delay only occur during posting of Sales Transaction. So I think this problem relates to GP.

Blog Post: Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format

ChristinaGeyerPhillips — Tue, 21 May 2013 04:38:00 GMT

In May 2012, I wrote about an apparent bug in the Dynamics GP 2010 Payables EFT CCT+ file format that prevented my customer from using the CTX file format (CCD+ with the Detail Line Addenda option). At the time, the bug affected GP 2010 SP 2, as the CTX format option had been added with SP 2.

I received an inquiry today from a GP customer asking if the bug has been fixed. The customer is hoping to be able to use the CTX format to send detail remittance to their vendors electronically as part of their EFT transmission.

I have tested GP 2010 SP3, and it appears the bug is still present. The "Addenda Count" calculation only outputs a "0" instead of indicating the number of addenda lines.

6221231231231234567890 00000500151EFT 0000TEST EFT VENDOR

Just in case, I checked the SP3 and post-SP2 hotfix documentation, and see no mention of a fix to EFT.

I also just tested GP 2013 RTM (version 12.00.1295), and the CTX Addenda Count bug also exists in that version. Despite a few additions to the Generate EFT Files window, they apparently didn't get around to fixing the Addenda Count calculation.

So for now, the Dynamics GP Payables EFT CTX file format is still not compliant with the NACHA standard.

If you are looking to implement the CTX format, submit a support case with Microsoft. They should be able to confirm that it is a bug and not charge for the case, and you should theoretically be notified in case there is an update to the issue.

Steve Endow is a Dynamics GP Certified Trainer and Dynamics GP Certified IT Professional in Los Angeles. He is also the owner of Precipio Services, which provides Dynamics GP integrations, customizations, and automation solutions.

http://www.precipioservices.com

Forum Post: RE: MR 2012 RU5 Balance Sheet Detail Missing

Richard Wheeler — Tue, 21 May 2013 02:17:00 GMT

System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_IntegrationSourceID'. Cannot insert duplicate key in object 'dbo.ControlConfiguredIntegration'.

The statement has been terminated.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ConfiguredIntegrationsDataSetTableAdapters.ConfiguredIntegrationTableAdapter.Insert(String SourceName, String SourceDiscriminator, Nullable`1 GLEntityID, String GLEntityConnectionInformation)

at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.ConfiguredIntegration.<>c__DisplayClassd.<Insert>b__c()

at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 transact, Func`1 connect, Func`1 execute, Boolean retry)

at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 connect, Func`1 execute)

at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService.<>c__DisplayClass2c.<InsertConfiguredIntegration>b__2b()

at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.<>c__DisplayClass1f.<SecureExecute>b__1e()

at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

Component: Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService

User: SEASTREAK\GPAdmin

Forum Post: RE: Excel or smartlist report that will pull in the customer notes from customer card

KirkLivermont — Tue, 21 May 2013 00:56:00 GMT

You should be able to add this to either a smartlist or refreshable excel report by adding the Note Index field from the RM00101 Customer Master table.

Forum Post: RE: US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

Carolyn Ballard — Mon, 20 May 2013 23:25:00 GMT

Thank you very much for all the information.

I think I will try the set file and go from there. It is a very strange message.

I do appreciate you followingup. Do you think cashbook would be better than the bank rec from gl?

The US companies need to be able to reconcile from gl also, but if the cashbook works, I"m all for that.

Carolyn

Forum Post: RE: Is there any bank reconciliation product that pulls activity from GL?

Carolyn Ballard — Mon, 20 May 2013 23:21:00 GMT

Thank you, good to know

Carolyn

Forum Post: Sales Order Location

jmawebtech — Mon, 20 May 2013 23:06:00 GMT

Hi,

I have written some code to pull a list of Sales Orders:

wsDynamicsGP.GetSalesOrderList(new SalesOrderCriteria(), context);

wsDynamicsGP is the web service API:

http://msdn.microsoft.com/en-us/library/cc508537.aspx

I have MS Dynamics GP 2013. I cannot find any of these transactions under Sales > Sales Orders Transactions. Am I looking in the wrong place? Is there a way to look up transactions by customer?

Forum Post: RE: Error 404 Page Not Found after Upgrade to BP 5.0

Rob Bernhardt — Mon, 20 May 2013 21:42:00 GMT

Beat,

I haven't seen this exactly, so I can only guess. I'd start by checking the BusinessFramework.config file in the Inetpub\......\bin folder. See if the url's in there are correct.

Thanks

Rob

Forum Post: Set Functional Currency but there are no currencies listed

frdbadf — Mon, 20 May 2013 21:37:00 GMT

I am attempting to install Management Reporter 2012 on a test server with GP2010 to migrate FRx data and prepare for upgrade to GP2013. I have installed GP2010 and restored the company database.

When I attempt to configure an ERP Integration the configuration fails. in the deployment log it states that I must setup a functional currency.

When I go through the steps to set up a currency, Tools, Setup, System, Currency or Multicurrency, there are no default currencies to select from in the drop down.

I created Z-US$, US Dollars, ISO=USD and proceeded to assign it ot the company but the problem still exists, Management Reporter configuration still fails with I need to create functional currency.

Thanks

Forum Post: RE: Dynamics GP 2013 with Sharepoint 2013

Rob Bernhardt — Mon, 20 May 2013 21:33:00 GMT

Yes, SharePoint 2010 will be supported on Windows Server 2012 with the SP2 release, which should be available soon.

Thanks

Rob

Forum Post: RE: Switch off Dynamics GP integration with Lync

Rob Bernhardt — Mon, 20 May 2013 21:21:00 GMT

Ian,

There isn't a switch to turn it on or off. It simply lights up when the environment has Lync installed and Lync is open prior to Dynamics GP being launched.

Thanks

Rob

Forum Post: RE: Setting up ODBC for Great Plains

Ian Grieve — Mon, 20 May 2013 20:32:00 GMT

The sa account is not retained in the ODBC connection; it is just used to verify the connection details are correct.

Users should not have sysadmin access as this means they can do anything in SQL Server. They should also not have db_owner.

Follow the steps in my blog post that Sandip posted and you'll have the ODBC with correct settings. Create your users in Dynamics GP and they will have the correct permissions assigned in SQL

Forum Post: RE: Remove detail in GP?

Carl Holzhauer — Mon, 20 May 2013 19:51:00 GMT

Server performance is not an issue. We have two PCI-e SSD cards with 32GB of ram and 16 CPU's.

Our issue is that there is just too much stuff to look through. At Convergence, I attended a GP round table and the the largest database seemed to be around 5gb...ours is close to 50gb.

What we want to do is just limit the amount of "stuff" that the reports need to look through.

Forum Post: RE: Installing Tools in a Test Company

Carl Holzhauer — Mon, 20 May 2013 19:51:00 GMT

Sure, they won't care what company you're using.

Forum Post: Human Resources Accrual Schedule

George Lasseigne — Mon, 20 May 2013 19:36:00 GMT

I'm trying to setup an accrual schedule for our company. We get 0 days the first year of service, 10 days after 1 year, etc. Also our vacation expires at the end of calendar year. I've yet to find the magic formula to make this work. My best guess was to setup an accrual for year of service , accrue by Interval (365 days per interval, though not sure how leap year would work out), and number of hours to 40.

Could someone point me in the right direction on this?

Forum Post: RE: Human Resources Discipline Points

William W. — Mon, 20 May 2013 19:32:00 GMT

Not that I am aware. You would have to make sure that one of the Payroll UPR tables for the paycheck linked to the HR score table DIS_POINTS_LINE (HR2DIS05) and in my experience HR tables can easily link to Payroll tables but not the other way around.

Getting the Payroll tables to have a relationship with HR fields could take quite a bit of customizing work and in the end sounds like quite a bit of effort. Functionality wise I imagine these fields were designed in HR to be part of a quarterly/annual review with the employee and their manager, which is why getting it on a paycheck would be difficult.

Forum Post: RE: Active Directory to login to GP

Syed Arshad — Mon, 20 May 2013 19:21:00 GMT

we also use FastPath and it works

Blog Post: From the Microsoft Dynamics GP blogs: Maps in SSRS; Named Printers and Terminal Server; MDA; Business Analyzer; Business Portal 6.0 Upgrades

MSDynamicsWorld.com — Mon, 20 May 2013 19:18:00 GMT

Using Maps to Visualize Data in SQL Server Reporting Services Reports: Charles Allen writes about this subject at the Dynamics GP Insights blog.

"SQL Server Reporting Services 2008 R2 introduced many features in the area of graphical display of information," Allen says. "According to the Microsoft Developer Network, there were three new features introduced in SQL Server 2008 R2: maps; sparklines and data bars; and indicators. In this first article of a three-part series on data visualization, ...