Sunday, January 4, 2009

Year end closing Retained Earnings validation

What's this? Two posts in a single day after weeks of silence? Hopefully this will be helpful for someone out there.

This is for those of you who do 'divisional' closings to Retained Earnings. That's where each 'division' has separate balance sheet and income statement accounts. This is a popular technique when clients want to keep several companies in the same database, yet close out each company to its own retained earnings account.

First of all, you can only (out-of-the-box) differentiate according to a single segment of the chart of accounts. So you can't close by the combination of segment 1 AND segment 2. Also, you need to have created an account for each segment whether or not you need it.

Before executing the close, GP searches through the chart of accounts to make sure you do indeed have a separate retained earnings account for each separate 'division'. The surprise to me was how the software determines whether you're good to go. Instead of looking at the account indexes or separate segment definitions, it looks at the Account Number String field in the Account Index table.

I discovered this last year when one of my clients tried to close and couldn't. Earlier in the year we had removed an unused segment from the chart of accounts (more on that later). The Account Number String field still had a trailing dash "-" left over from the deleted segment. So account number 100-4560-090 read in the field as 100-4560-090- . Once we removed the trailing dash from the field, everything closed beautifully. Go figure.

Another related item. The Account Number String field is used by Integration Manager too. When importing account numbers, you have to use the account separator or the integration will fail. Remember when you could just import the string of characters with no account separator? Not anymore. This was changed a couple of versions ago, so everybody who had strings of characters as the source has probably changed the integration by now.

Gee, and here I thought they created that field so we would no longer have to concatenate segments in reporting.

Enjoy those forms 1099 and W-2!

Leslie

Dex.ini Switches - Part 2

I'm finally getting back to posting. Here's the second installment of the .ini switches. My favorites were posted with part 1, but I'm always on the lookout for more. I've got some for VBA and IM as well.

ADC Processor=TRUE
You will see this line in the Dex.ini file if you are using Manufacturing and have the checkbox marked in ADC Preferences. (dah!)

AdvLookups=FALSE
New Users created will NOT be granted access to the Alternate lookup windows in the SmartList dictionary and will instead be assigned the old ‘green bar’ lookup windows. Very useful if you want to use Dex and try to do a lookup.

AllowBCPTest=FALSE
Prevents utilities from running the BCP test.

AllowWrongDex=TRUE
Will allow Dynamics GP to launch with mis-matched versions of dexterity. DANGER, this is not such a good idea.

ApplicationName=name
Changes the name the runtime engine displays when it is launched. Without this setting the name “Dexterity Runtime” is displayed. With versions 9 and higher this doesn't display very long so it's hard to spot. Hardly worth the effort anymore. It used to be quite fun.

AutoDisplayUpdate=TRUE
Automatically redisplays the process monitor queue.

AutoInstallChunks=TRUE
Causes Dynamics to automatically include the *.cnk file not prompting the user for 'Add New Code' during launch.

BTInterface=NoLoad
This applied to the old Btrieve file handler (PSQL 2000) as to whether the interface would load when Dynamics was launched. Version 7.5 was the last version where PSQL could be used.

Buildphantom=TRUE
Allows creation of a Manufacturing Order for a Finished Good Phantom Item. Sounds spooky.

BuildSQLMessages=TRUE
This one will copy the Dexterity messages to a SQL table on next login and then it will set it back to FALSE. Once in a SQL table the messages can be used in stored procedures. The table is DYNAMICS.dbo.MESSAGES.

DebugFonts=TRUE
This setting causes Dexterity to generate a trace file named "debuglog.txt". This file lists the fonts that were considered and why particular fonts were chosen or rejected. This applies to Report Writer reports.

DebugRW=XXX
Where XXX equals the sum of the values you want to trace from below.

Value = Description
1 = QueryOK Specifies if the report will use a single query or not
2 = Sanscript Logs the run report statement as the Report Writer sees it
4 = RW Query Logs all API calls from RW to the Data Manager
8 = RW Setup If used with RW Run, logs all data returned by Data Manager
16 = RW Steps Logs internal RW steps in processing the report
32 = RW Run Logs all RW runtime calls to the Data Manager
64 = DM SQL Logs internal Data Manager structures and SQL Generation
256 = RW Frames Logs the beginning of each report frame
512 = Tab Delimited Logs output as tab delimited output

Output will appear in a log filed named DebugRW.txt next to the application dictionary.

Example: If you want to log if a report is using a query and the SanScript and SQL code used, then add the following line to your Dex.ini file:
DebugRW=67 (which is 1 + 2 + 64)

To help in trouble shooting problems related to the generation of reports, before printing a report you may choose to mark the Multi-Login Report option on the Report Definition window. This will force the system to perform individual table operations instead of creating a query. If you have the SQLLogSQLStmt = TRUE setting included in your DEX.INI. The individual select statements are then included in your DEXSQL.LOG file and can be analyzed to uncover any potential problems.

DebugUnknownFile=TRUE
Returns a Btrieve or Ctree error code to help track problems with table errors back in the day of Btrieve and Ctree. (version 7.5 and previous)

DexHelpPath=pathname
Path to the Dexterity help files. Consider using this if you want to 'share' help files. This defaults to the application folder on the local client.

Dictionary Version=xx.xx.xxxx
The current version of the Dynamics.dic file. Changing this value will not change the dictionary, but this value is updated when a service pack is installed.

DisplayTableErrors=TRUE, ALL or OPEN
To display an ID for an unknown table error when the Dexterity Database Management Subsystem encounters one. The ID that's displayed can be used to determine the cause of the error.
TRUE – Displays only unknown errors.
ALL – Displays all table errors except the two most common: “duplicate” and “not found”.
OPEN - Displays all table errors for an open operation.

That's all for now. Please let me know if there are any errors in any of the switches so I can be sure to correct the post.

Thanks for "listening"!

Leslie

Saturday, December 20, 2008

Dex.ini Switches - Part 1

Over the years I've collected a number of dex.ini switches. I love these things. I'd been beating my head against the wall for 2 or 3 hours and somone comes by and says 'Oh, that's just an ini switch.' An .ini switch can control all sorts of things. From where to look for the help file to turning off that nagging reminder about the sample company date. Some of my favorite switches are below. Since, I can't figure out how to attach a text file to this blog, I'll make this a multi-part post and eventually cover all of them in my list.

ShowAdvancedMacroMenu=TRUE
When you get that message that says your macro failed on line 65,423 you can use this to open your macro and jump right to the line of failure for analysis. Being a frequent user of the 'Mail Merge' macro, this tool is used frequently to find out what went wrong. Another cool thing about this is that it lets you start a macro in the middle, also there's no separate .cnk to install. A simple .ini switch does the trick!

DISALLOWSNLOTAOF=TRUE
Prevents users from being able to "create" new lot numbers or serial numbers while transferring an item from one site to another. Version 10 now has a setup option that disallows this, but the box is not automatically checked. GP is good about not changing the old functionality (really, I mean this) so be sure to check your setup screens after each update or SP for new settings.

EmpLookup=2
Causes the Employee Lookup to default to Last Name

EmpLookup=3
Causes the Employee Lookup to default to First Name

EmpLookup=4
Causes the Employee Lookup to default to Social Security Number

ExplorerFormatCurrency=FALSE
Exports currency values to Excel from SmartLists as numbers instead of text.

ExportOneLineBody=TRUE
All fields and text entered in the body of the report will export to a single line when the report is printed to a file. Allows you to enter many fields vertically instead of having to enter them horizontally in the report layout. This was what we had to do back in the pre-SQL days. If you don't exactly have your arms around the SmartList Export Solutions, it's still a nifty way to 'export' Excel formulas. Be sure to change your Excel formula options to R1C1 reference style and you won't need to keep track of any Excel templates. My clients enjoy just being able to run a Report Writer report to get all of the formulas they need. That, and I already had it written so it was easier.

FormDictionaryPath=pathname
ReportDictionaryPath=pathname

These are new for version 10 and welcomed with open arms! These lines tell dexterity where the forms/reports should default to when installing a new .cnk file. Switch it to a shared location for a shared forms/reports.dic and any new dictionary applications that are installed will default to that location instead of the client installation folder.

MinPMCheck=50.00
Used in conjunction with PSTL free tool this sets the minimum payables check amount. This is used in conjunction with the 'Select Checks' feature. No check for under the amount specified will be created. In this example the minimum check would be $50.00

OldRelationshipWindow=TRUE
Just kidding, this one doesn't work anymore. For the oldies among us, remember when Report Writer would let you create invalid relationships? Like you could build a relationship between a string field and an integer field. Hey, sometimes you needed to! This switch allowed the old Relationship Definition window to work again. This switch was used prior to version 8.

OLEPath=pathname
Thanks to Matthew, I have a new solution to this one. Apparently you CAN use the UNC path so long as you have the folders pre-created for each company. Read explanation below:

You only need one line in the dex.ini to accommodate multiple GP companies. If you have three companies in GP (CMP1-CMP3) the line in the dex.ini would still be, for example,

OLEPath=\\ServerName\GPShare\OLE\

For this path to work with the three companies, you would need to manually add the company directories under the OLE directory on the share. For example, the folders would look like this:

GPShare\OLE\CMP1\OLENotes
GPShare\OLE\CMP2\OLENotes
GPShare\OLE\CMP3\OLENotes

If you're using a local drive or a mapped drive instead of UNC for the OLEPath, this directory structure is automatically created for you by GP.

If you don't have the folder structure set up first, UNC will not work. IP addresses won't work either.

REVALUEINDETAIL=TRUE
Inventory cost adjustments will flow into the general ledger in detail instead of the default behavior which is to create a single summarized journal entry.

SAMPLEDATEMMDDYYYY=00000000
To prevent the 'Sample Company' dialog box from being displayed and to use the current system date instead of April 12th, 2017

SAMPLEDATEMMDDYYYY=MMDDYYYY
To prevent the 'Sample Company' dialog box from being displayed and to use a user-specified date

SAMPLEDATEMSG=FALSE
To prevent the 'Sample Company' dialog box from being displayed, while leaving the user date at April 12, 2017.

StdInternationalInfo=TRUE
The date format will not be pulled from the International settings and will instead use the default format of mm/dd/yy.

SuppressChangeDateDialog=True
To keep an IM integration from failing if the integration is running when the computer’s clock hits midnight. The computer date doesn’t change either – so be sure to watch this if running overnight integrations.

SuppressSound=TRUE
Stop Dexterity and Dynamics from generating any sounds. This is popular if you don't want the whole office to hear the computer 'beeping' when you make mistakes. It was also popular back in the 'Welcome to Dynamics' .wav file days.

For those who want more, watch this blog, contributions and corrections ARE WELCOMED AND ENCOURAGED!

That's all for now,
Leslie

First Post - Dynamics Confessor Blogspot

Well, I have finally found a blog to call home. I'm a Microsoft Dynamics GP consultant out in the field day after day trying to put hope into my client's eyes (or at least keep tomatoes out of mine). My fellow confessors and friends said it would be fun to blog. I was also told that I was the only remainng MBS-GP MVP not to have a blog. Well it's here - I'm officially a blogger. So does anyone have any topics or ideas they would like covered in blogs to come? I'll try to handle the basic stuff and leave the heavy lifting to Mariano and David!

Leslie