Dexterity Basics training February 11–15, 2013 in Orlando

Looking for Dexterity training? Come to Orlando!

I will be teaching the Dexterity Basics class at Integrated Business Group (IBG). The training will take place in Orlando, Florida from February 11th to February 15th, and will provide the basic foundations any Dexterity programmer must have.

This is an opportunity for all of you VSTools programmers to learn how to build your user interface in Dexterity instead of WinForms so that your application will run with the new GP 2013 Web Client. Your existing code will hook right up to the Dexterity events,  you may even like the Dexterity forms designer even better than VS Tools!

For more information, contact the training coordinator, Roxanna Alvarez at ralvarez@ibgnet.com or at her direct line +1 (407) 965-9299.

Hope to see you  in Orlando!

**ERROR: Batch level errors were encountered.

 

If you have ever received the above error on a posting journal or edit list, check to make sure the fiscal period for the batch you are trying to post is open. The posting journal/edit list should have another clue about what was causing the error at the top of the report.

The image below shows the error and the hint.

Until next post!

Leslie

When things go Wrong - I need to delete a printed SOP document

Dynamics GP presumes that any document that you print becomes a critical document in the business cycle and typically, does not let you delete it. But sometimes, you must delete it.

What to do?

The SOP module keeps track of the number of times you have printed a document. If you print it once, and printing to screen counts as printing, you cannot delete it. Therefore, you need to set the system back to believe it has never been printed in order to delete it.

Of course, this is not a supported solution, so use it at your own risk. The first step is to back up your System (DYNAMICS) and company databases. The name of your company database is displayed on the Company Setup window.

USE YourCompanyDatabase
GO

UPDATE SOP10100
SET TIMESPRT = 0
WHERE SOPNUMBE = 'your_SOP_Doc_Number'

When things go Wrong - Error registering table GL_Account_MSTR

Here's what happened.

 

You've just installed the workstation, you launch it and are greeted with this:

What to do?

You'll be delighted to know that this is an easy fix. The problem comes up when folks copy the Dynamics.set file to one worksation from another before they synchronize the existing Dynamics.dic to the systems account framework.

All you need to do is change the dex.ini file so that the following entry exists:

Synchronize=TRUE

Most likely, yours says FALSE

You need to make sure you only have one of these entries in your Dex.ini file. If you have more than one, the first one rules.

After you change the Dex.ini setting (in the Data folder of your application folder), you'll need to launch Dynamics Utilities in order to complete the synchronization process.

Once the synchronization process is complete, the error should go away, and Dynamics GP should launch.

Don't ya' love all of the 'should's' in that dialog?

Live the Dream!

Leslie

Thanks to David Musgrave's keen eye I changed this post to the correct setting. I had it backward originally. Unforgivable for the dex.ini queen.

When things go wrong - Batches cannot be posted

Here's the scene. You're trying to post a batch of GL entries and you get the following error:

"Batches cannot be posted while the year-end close is in progress"

But, of course, the year-end closing process is not happening. What to do?

You need to change the system's mind about that closing process by running the following scripts:

First, and always, back up your system and company databases, and then:

USE DYNAMICS
GO
DELETE SY00800
DELETE SY00801

USE TEMPDB
GO
DELETE DEX_SESSION
DELETE DEX_LOCK

UPDATE:
Here's a post from David Musgrave that allows you to clear up the batch error with everyone still logged into the system:

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/12/03/releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx


Hope this clears it up for you.

Live the Dream!

Leslie