What happens with Landed Cost when you perform a Returns Transaction in GP2010?
This question popped up on the Microsoft Dynamics Community today so I thought I’d share the answer here. The new functionality in GP2010 that edits the original PO for a purchase return (or creates a new one if the original is closed) is awesome. Not sure why it took this long to add that functionality but it is what it is. However, there is no facility in the Returns Transaction to reverse the Landed Cost on the original receipt, so GP writes the value of the Landed Cost to Purchase Price Variance . Not the ideal way to handle it but at least it doesn’t leave that cost sitting in inventory, if the return is an inventory item. *click image to enlarge P.S
February 5, 2012 · 
Frank Hamelly MCP-GP MCT MVP · 
No Comments
Tags: budget, financial, General Ledger, generator, learning, manufacturing, po returns, security, sql server 2008, united-states, utilities · Posted in: Blogs I Follow Total Views: 2
GL Trial Balance in FRx
For those of us on GP2010, Reporting Services reports provides a nice GL Trial Balance that is easy to export to Excel. For the rest of us, we still have to print the Report Writer version to a text file, open it in Excel, then start the cleanup and reformatting. There is an easier way using FRx. Victoria Yudin has a great article on doing just this here – http://victoriayudin.com/2009/07/17/dynamics-gp-trial-balance-in-excel-using-frx/ . *click image to enlarge Now, to take this one more step, if you need more of the transaction detail in your FRx GLTB, look at the additional Column Types available, such as TDESC, TJDESC, TDOC, TBAT, etc. You can build a really sweet GLTB using FRx that easily exports to Excel. That will make you and your auditors happy.
February 3, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: accounting, budget, development, dynamics, facebook, frx, General Ledger, GL Trial Balance, houston, Inventory · Posted in: Blogs I Follow Total Views: 10
Word Templates rendering report in Internet Explorer
I have been working on a Word Templates case for the past 2 weeks and just got to the bottom of the problem, hence I felt the need to pause and blog about it. Background A client of mine reported a couple weeks aback that they had created a template version of their purchase order and each time the purchasing staff attempted to print a purchase order, the output would automatically generate in Internet Explorer instead of Microsoft Word. As the title of this article suggests, the client is using Word Templates to generate a nice looking PO for their vendors.
January 31, 2012 · Mariano Gomez · No Comments
Tags: Dexterity, fixed-assets, General Ledger, infrastructure, management, project-accounting, Report Writer, united-states, word templates · Posted in: Blogs I Follow Total Views: 13
Alternate Allocation Account Method in Dynamics GP
Do you use allocation accounts, like variable or fixed allocation accounts in Dynamics GP? These accounts are set up in the following windows: Fixed Allocation Maintenance window Cards | Financial | Fixed Allocation Variable Allocation Maintenance Cards | Financial | Variable Allocation Allocation accounts are unlike typical posting accounts (Cards | Financial | Account) in several ways: When you post to them, they immediately allocate to the specified distribution accounts according to either fixed percentages or variable breakdown account balances. Because they do not store activity or history, you cannot report on them—you can only report on the resulting distribution accounts.
January 31, 2012 · Christina Phillips · No Comments
Tags: dynamics, General Ledger, windows · Posted in: Blogs I Follow Total Views: 9
Crystal Report: Sub Report did not show up on client machine
I been in a situation where I had to create a report with sub-report in crystal and the report worked perfectly on my machine. while implementing the report on the client machines I noticed that the sub-report is always empty on all machines and even on the server. I tried everything with no luck, I even recreated the report with no luck as well, after deep investigations in the issue I have noticed that both Main Report and Sub-Report are using commands and both has the same identical name “command”, changing the command name in the sub-report to “command_1” resolved my issue!!! Hope that this does not happen to you and helps reducing research time! Regards, — Mohammad R
January 29, 2012 · · No Comments
Tags: database, downloads, General Ledger, great plains, Inventory, knowledge, middle-east, security, sql server · Posted in: Blogs I Follow Total Views: 11
Setting up Integration Manager to import Multidimensional Analysis (MDA) information
Support has had a few inquiries recently on how to set up Integration Manager to integrate Multidimensional Analysis (MDA) information. Here are a couple options to integrate MDA information with Sales Order Processing whereas the first option contains an article that can be used as a guide for integrating MDA information with other modules too. Option 1: Here is an article you can use as a guide for Sales Order Processing on how to integrate MDA information if you have MDA information in the source file. This article is specific to General Ledger and MDA; however, the concepts and data needed for the distributions in the source file will be the same. KB 850347 Steps To Create General Ledger-Multi-Dimensional Analysis Transaction Integration https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-US;850347 .
January 24, 2012 · Angela Melhus · No Comments
Tags: Dexterity, dynamics, Dynamics GP, dynamics gp gl, General Ledger, great plains, Inventory, mda, sales, Sales Order Processing, security, windows · Posted in: Blogs I Follow Total Views: 15
Microsoft Dynamics Convergence 2012 sessions now published
Ok, they have been published for a few days now.
January 24, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, General Ledger, microsoft, microsoft office, Multicurrency, security, Smartlist Builder, support debugging tool, virtual, windows · Posted in: Blogs I Follow Total Views: 21
Why does the JE description say “Receivings Transaction Entry”?
This question came up in a forum recently – not in this exact form – but essentially the question was “where can you change the description of a transaction from a Dynamics GP Receivings Shipment or Shipment/Invoice”? The short answer is, it’s very well hidden but it is there, and most users don’t see it and generally it stays at the default value which is “Receivings Transaction Entry”. That means if you print transaction descriptions on a Accounts Payable cheque or EFT remittance, that’s what you see
January 23, 2012 · jen@kuntzconsulting.ca · No Comments
Tags: aaron-berquist, account-numbers, accounting, David Musgrave, dynamics, General Ledger, microsoft, news, Smartlist Builder, transaction · Posted in: Blogs I Follow Total Views: 21
SQL Script for AP-GL Reconciliation
Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general [...]
January 17, 2012 · veeyeskay · 2 Comments
Tags: ap to gl, ap to gl reconcile, General Ledger, payables, Payables Reconciliation, reconcile, Reconciliation · Posted in: Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 369
Management Reporter: Server Error in Application "MANAGEMENT REPORTER"
Just recently, I fielded a question on an issue that was happening with a Management Reporter installation. The partner reported getting the following error (shown in the picture) when attempting to open the Management Reporter URL address: Server Error in Application “MANAGEMENT REPORTER” .
January 17, 2012 · Mariano Gomez · No Comments
Tags: Analytical Accounting, construction, desktop, dynamics, extender, General Ledger, microsoft, Multicurrency, sql server, virtual · Posted in: Blogs I Follow Total Views: 29