Dynamics GP currency ID error

Microsoft Dynamics GP: What Does “Currency ID Is Not Selected for This Posting Account” Message Mean?

Have you encountered a message stating “The currency ID is not selected for this posting account” in the Microsoft Dynamics GP General Posting window? This message may appear to indicate that the General Ledger Account directly above the message is missing the currency association as shown below. In actuality, the message is simply stating that…

New Dynamics GP 2018 Features: One Payment Per

The list of new Dynamics GP 2018 features continues to grow — Payables Management introduces new ways to process payments giving users better options and an enhanced user experience. The “One Payment Per” field has been added to Dynamics GP 2018 providing users a new vendor payment option. The field drops down, enabling users to select One…

What are Analysis Cubes and why do you need them?

What are Analysis Cubes and why do you need them? Analysis Cubes for Excel is an ad hoc reporting tool that comes out of the box with Microsoft Dynamics GP. Unlike other reporting tools the cubes require minimal set up effort and can provide instantaneous value. Users can quickly and easily access system data through…

Company Financial Data Doesn’t Appear in Management Reporter 2012

A multi-company client recently encountered a situation where a newly created company produced no data in their consolidated financials. The resolution lies in the way the Account Segments were named in the Account Format Setup window. In this particular company, the GL Account segment name was abbreviated.     Note in the first image that…

Excel Cube Functions: Exclude a Single Member from a Set

I’ve talked previously about how one can use MDX to create sophisticated cube sets in Excel, but I was recently stumped by a questions from one of my clients. The question seemed simple enough (“How do I create a cube set that includes all of my customers except one that I identify?”) but the best…

Using Cube Functions in Excel to Create MTD

Cube Functions inside Excel are really powerful tools for cube reporting, especially when you realize that you can leverage MDX within the functions to make some very useful calculations. Today, I will describe how you can use the CUBESET function to calculate Month To Date values, even when there are no MTD defined measures. First, let’s…

Smartlist Builder, SQL View and a Linked Server

While building a custom Smartlist using a SQL view and Smartlist Builder on a “Linked Server” I ran into an Error.  Ever seen this one before?  I’m sure some of you out there have since it has been around for a while.   Since the ANSI_NULLS and ANSI_WARNINGS are hard coded as Off; consequently, the view created…