Mark Polino's Blog, page 316

Dynamics GP Land: Limitations of the Dynamics GP eConnect Transaction Requester

Steve Endow explores the Limitations of the Dynamics GP eConnect Transaction Requester over at Dynamics GP Land.

Dynamics GP Land: Dynamics GP Reminders Make GP Load Very Slowly

Steve Endow troubleshoots when Dynamics GP Reminders Make GP Load Very Slowly

Dynamics GP Partner Town Hall Meeting with Microsoft's Jeff Edwards - Oct 19, 2011 - GPUG Events & News

Partners and ISV's check out the Dynamics GP Partner Town Hall Meeting with Microsoft's Jeff Edwards - Oct 19, 2011

Dynamics GP Land: Hidden Gem- Check Distribution Report

Christina Phillips found a Hidden Gem- Check Distribution Report.

Dynamics GP Land: Adding Employer Tax Fields To Payroll Check Register

Up at Dynamics GP Land Christina Phillips digs into Adding Employer Tax Fields To Payroll Check Register.

Locked Payables Transaction: You cannot display this record while another user is editing it | azurecurve

Ian Grieve looks at Locked Payables Transaction: You cannot display this record while another user is editing it and delivers some SQL code to help.

Weekly Dynamic: Transaction Aborted…in table 'dbo.deleted'

We complain a lot when an error message does a poor job of leading us to the answer. I thought that I would highlight a case where the error message was right on. We had a client get the error message:

[Microsoft][SQL Native Client][SQL Server]Transaction aborted when accessing versioned row in table 'dbo.deleted' in database XXX. Requested versioned row was now found. Your tempdb is probably out of space. Please refer to BOL on how to configure temp.

Sure enough, tempdb had run out of space. For the acronym challenged, BOL is "Books on Line" the help manual for SQL Server. Restarting the service cleared out tempdb and allowed processing to continue.

Interestingly, we got this error in a number of different places, some folks got it when logging in, others got it while working with GL transactions. When I went to review the issue, I got two messages:

GPS Error: 85 and SQL Server Error 1101.

The GPS Error 85 can be cause by a number of things but looking up the SQL Server Error 1101 kept bringing me back to tempdb being out of space. GP was trying to tell us something, we just had to listen.

MVP Renewed

The good folks at Microsoft have seen fit to renew my MVP status for another year. All I can say is thank you to everyone who has visited the site, attended a 50 Tips presentation, followed me on Twitter or took a chance on the book.

It looks like Sivakumar got renewed as well, congratulations!

Where the GL Distribution Account Info is Stored for a Payroll Posting in Microsoft Dynamics GP » Summit Group Software Blog

The Summit Group finds Where the GL Distribution Account Info is Stored for a Payroll Posting in Microsoft Dynamics GP

Account Level Security and Creating New GL Accounts | | Interesting Findings & Knowledge Sharing

Sivakumar looks at Account Level Security and Creating New GL Accounts. What could go wrong?