Dynamics GP Land: Finding Duplicate GL Entries

Christina Phillips demonstrates Finding Duplicate GL Entries. David Musgrave has tackled this too.

Mohammad R. Daoud: How to Track unused Journal Numbers

Mohammad R. Daoud shows How to Track unused Journal Numbers

Feature of the Day: Encumber General Journal Transactions - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Microsoft is showing off a new Feature of the Day: Encumber General Journal Transactions

Weekly Dynamic: Prevent Posting

This has come up a couple of times recently so I thought I would cover it here.

The scenario is a company wants users to have the ability to enter journal entries but only allow certain users to post to the GL. One answer is to prevent transaction and series posting and require batch approval with a password. This works but requiring an approval requires approval for ALL GL posting including posting from subledgers.

Another way is to control posting through security. Security to posting is controlled via the "Series Posting Permission" type in Security Tasks. By default GL Posting is included in the TRX_FIN_003* and ADMIN_COMPANY_11* tasks. Yeah, you didn't see the ADMIN_COMPANY_11* task coming did you? It also includes batch recovery so more users may have this than you think.

This why I recommend that you don't rely on the default tasks and roles. You really need to know what in there.

[HT to David Musgrave when I brain farted with this. I missed the ADMIN_COMPANY_11* role]

Dynamics Confessor Blogspot: When things go Wrong - Error registering table GL_Account_MSTR

From Leslie Vail, When things go Wrong - Error registering table GL_Account_MSTR

Feature of the Day: Journal Entry History Inquiry - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

This new GP 2013 feature will warm some hearts: Feature of the Day: Journal Entry History Inquiry

"Post To" versus "Post Through" in Dynamics GP - Etelligent Solutions

Sheldon revisits "Post To" versus "Post Through" in Dynamics GP

Feature of the Day: Saved Batch Approval - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Coming in GP 2013:  Saved Batch Approval .

Batch Approver and Approval Date will now be saved in the GL20000 and GL30000 tables.

Using Microsoft Dynamics GP Source Documents to identify GL entries

Belinda looks at Using Microsoft Dynamics GP Source Documents to identify GL entries. This is a great option to avoid the dreaded 13th period just for adjustments. Use a different source document.

About Dynamics, Development and Life: Importing/Exporting a Dynamics GP Transaction to Excel

Jivtesh reviews a couple of tools for Importing/Exporting a Dynamics GP Transaction to Excel

Weekly Review: Options for Controlling GL Posting

There are a couple of different options for controlling posting to the GL in Dynamics GP. One option is to add a password for posting GL batches in Tools->Setup>Posting. On the plus side, this lets anyone create a GL transactions but only those with the password can post. The downside is that transactions that would otherwise post through from a subledger, won’t.

Another option that is often over-looked is to control who can post to the GL with security. This will still let anyone create GL entry but only those with proper posting permission can actually post a batch or transaction.

Weekly Review: Copy Distribution Reference

In GL distributions, users often want to copy a distribution reference to all of the lines. Well, there is no magic technique to make that happen but there is away to make it easier.

• Start by expanding the GL lines to show the Distribution Reference
• Enter the reference in the first line
• Copy the first line’s reference
• Press the down arrow to move to the distribution field on the next line
• Paste the reference
• Press the down arrow again and repeat until the reference has been copied to all of the lines.

Mohammad R. Daoud: Dynamics GP Journal Entry: Paste From Excel–Free Add-in

Ask and you shall receive. My post encouraging you to vote for the ability to Copy and Paste from Excel to the GP GL found its way to Ian Grieve of azurecurve and the Dynamics Community site. Mohammad Daoud found it there.

Then he and his team decided to build the functionality. Mohammad gives us a look at Dynamics GP Journal Entry: Paste From Excel–Free Add-in.

I got a copy over the weekend to play with and it rocked. Mohammad tweaked a few things for me but this is dead simple to use. Simply copy four columns from Excel and paste into GP using the Additional menu or CTRL+F.

In very limited testing:

• Pasting respects negatives just like GP does. So a negative Debit in the Excel sheet gets pasted as a Credit and vice versa. This means that if all you have is one amount column with negatives and positives everything still works. You still need 4 columns but Credit and Dist. Ref. could be blank.
• Pasting respects the "Allow Account Entry" setting and won't let you do a JE to an account with "Allow Account Entry" off. Pasting fails for the restricted line and any remaining lines are not pasted..
• The format is simply Account, Debit, Credit, Distribution Reference. The video shows headers of Credit then Debit. The headers are irrelevant. The transactions are copied and pasted without headers. The data goes in using the order on the GP window.
• Install is scary easy. Copy two files into the Add Ins folder.
• Scale seems to be fine. Speed is closer to Integration Manager. 1,000 lines took about 40 seconds. Your mileage may vary but that's roughly 25 lines per second or 1,500 lines per minute. Not SQL import speed but no too shabby and there's essentially no setup..
• Closing the window and agreeing to delete the transaction seems to kill a long running paste.
• What this utility does is let you paste into the grid (detail area). You still have full control over the header for batch, date, reversing, reference, etc. Batch approval still applies, etc.
• No intercompany yet that I can see (I didn't really test this) but this is a first pass. I'm not sure it's even a first release.
• You can do partial pasting (you don't have to grab a complete range), Paste an unbalanced JE (the trx won't post of course) and paste more than one time into a single transaction. (Paste a range, copy a new range, paste that at the end of the same JE).
• Pasting also respects blank rows. You can copy beyond the end of a JE and include blank rows. The blanks don't come in to the JE.
• The range you copy can include blank rows in the middle. Pasting works, although there was an odd visual problem. The last rows didn't seem to be correct but when I scrolled up and down they fixed themselves. It's as if the data was correct but the interface didn't refresh. This is so minor that I'm only mentioning it because it made me double check my test.

This tool is absolutely worth testing. Send Mohammad an email and ask for a copy.

Weekly Dynamic: Break Down Allocation Account

When we’re working with allocation accounts users often want to the results of the allocation before posting and on posting reports. This is easy to do. Simply check the “Break Down Allocation” box on the Batch window.

Weekly Dynamic: Negative Debit (or Credit)

When entering account transaction data in Dynamics GP, the system tries to be helpful and puts the cursor in the debit or credit column based on the debit/credit setting in account setup. This is great until you want to debit an account with a default credit balance and vice versa.
You can obviously tab or shift-tab to get to the right field or you can move to the appropriate field with your mouse. Or…
You can stay where you are and enter the item as a negative.
If you enter a negative debit Dynamics GP automatically enters it as a credit. Negative credits become debits.
Every so often this saves my sanity.

Dynamics GP Land: Quick Journal Oddity

Christina Phillips has found a Quick Journal Oddity

Streamlined General Ledger Processing in Dynamics GP

Sheldon from Etelligent Solutions shows off some ideas for You are here: Streamlined General Ledger Processing in Dynamics GP

Mohammad R. Daoud: GL Summary Reconcile

Mohammad Daoud has GL code to perform a GL Summary Reconcile

Weekly Dynamic: Transaction vs. Batch Posting Revisited

I’ve covered Transaction Posting vs. Batch Posting in Dynamics GP before but I wanted to revisit one more element this week.

If you post at the transaction level for subledgers Dynamics GP will ALWAYS override your Post Through preferences and only post TO the GL. In other words if you post a transaction in the AP Subledger, you will always have to post it again in the GL. The transaction will NOT post through regardless of what your Post To/Post Through settings are.

Clearing Recurring Amounts in GP 2010 | onza blog

Amanda Wong likes the new Clearing Recurring Amounts in feature in GP 2010