Microsoft Dynamics Blog

In this webinar, Will Steele spends time highlighting what’s new for Business Intelligence and Reporting with the new release of Microsoft Dynamics® AX 2012 R2.

Title: Business Intelligence in Microsoft Dynamics® AX 2012 R2

Speaker: William Steele, I.B.I.S. Associate Consultant

It’s amazing how many great little features are hidden within what sometimes feels like the labyrinth that is Dynamics AX 2012. A customer was looking for just some quick data on month to date, year to date and last years sales for a particular customer. I navigated to the customer master (Sales and Marketing or A/R > Common > Customers > All Customers) found the customer record and on the Invoice Tab on the ribbon is a button called Period Statistics.

Read the rest of this entry »

In this Live Meeting, you will learn how ePay Advantage works seamlessly with Microsoft Dynamics® GP to streamline A/R, improve collections, automate recurring based billings and overcome PCI barriers. Also learn how eSOP™ Advantage can improve productivity with web-based Sales Order Entry for Microsoft Dynamics GP, providing a quick way of taking orders over the Internet eliminating the physical and time boundaries for entering sale orders.

Title: Online Bill Pay + Recurring Invoicing/Payment + Web-Based Order Entry for Microsoft Dynamics® GP 

Speaker: Nikki Nguyen, Nodus Technologies Inc., Product Manager

If you are using the production module within Dynamics AX, then you are probably wanting to get a better handle on your costs. You can easily configure Dynamics AX to calculate costs of BOM’s, and if you want to get a little more industrious then you can also create cost sheets broken out by your particular cost categories, incorporate routing costs, and even add surcharges and other indirect costs.

In this example we will walk through an example that shows how to set up your costing controls within Dynamics AX. You will learn how to:

• Set up Costing Versions
• Manually assign a Product Cost
• Create Calculation Groups
• Use Costing Versions to perform a mass cost calculation
• Perform a basic Cost Rollup
• Create Cost Groups
• Build a Costing Sheet
• Define Route Shared Categories
• Define Route Cost Categories
• Add Surcharges and Fixed Overhead Costs Read the rest of this entry »

Reconciling inventory at month-end can be a daunting task as it is, even more so in an unfamiliar system with no way to know where discrepancies come from.  AX 2012 makes the process easier with the use of canned reports that are geared for reconciliations and identifying missing transaction, and as long as you know what you’re looking at, this can make life much easier.  Two major components are part of this process: 1) Report on Inventory value and 2) Investigate misstatements.  Once that has been completed, you can make appropriate adjustments to close the books. 

Read the rest of this entry »

One of the most common requests I get for documentation is around editing price/discount agreements journals in AX 2012.  The process is a little different in 2012 than it was creating trade agreements in AX 2009.  There has been a change to go to journals in order to put some more controls in place.  Please continue reading for step by step instructions with screenshots.

Read the rest of this entry »

Hi there my fabulous readers!  I haven’t had many questions in the past couple of weeks so I’m going to expand my last entry and cover an additional CustomerSource training feature.

Last time we explored how to access free E-Learning. This week, we’ll take a look at how to find and download free training materials in CustomerSource. The training materials can be used in conjunction with the E-Learning courses or can be used independently. Read the rest of this entry »

If you want to personalize your products a little, or if you are more of a configure to order operation where every product that you ship out the door is tailored to your customers specifications and needs then you will probably want to take advantage of the Product Configurator that is built into Dynamics AX. This feature allows you to create a product with a number of different attributes, and rules that will allow Dynamics AX to build a custom BOM every time the product is ordered, and also tell you if the product is even possible to make.

In this walkthrough we will show how to:

• Create A Constraint Based Product Master
• Create a Product Configuration Model
• Add Configuration Attributes
• Group Related Attributes
• Add Conditional Display Options
• Add Constraints to your Configuration Model
• Configure a BOMS Based On Attributes
• Use Table Based Attribute Values
• Use Attributes To Simplify Rules Read the rest of this entry »

Blanket orders help an organization operate more efficiently while reducing transactional overhead costs.  Blanket Orders effectively lock in an agreed upon price and reduce the time spent on order entry.  By creating large blanket orders and releasing quantities of the order on a periodic basis, organizations can operate with reduced trasactional costs.  Without the use of Blanket Orders, users would have to create individual orders for services and/or products that will be repeat orders of an agreed upon price. Dynamics AX functionality and framework have changed greatly from 2009 to 2012, including, but not limited to the abilities within orders. Read the rest of this entry »

Once Data migration has been completed in an implementation, it is a good idea to recommend to clients that they regularly run Data Consistency Checks on the system. Data Consistency Checks (DCCs) are checks run in the Microsoft Dynamics AX system to ensure that data is consistent across different relations. DCCs run through tables and transactions and cross-references data. Once completed, an infolog will appear with possible corruptions of data. These can be run out of business hours and checked regularly. Read the rest of this entry »

Another great aspect of I.B.I.S. Inc’s Advanced Distribution Software is Quick Order Entry. Some great tools have been added to speed up Customer Service Reps when taking orders from customers. One of these great features is the advanced item look up which now searches on more fields than just the item number without having to take your fingers off the keyboard. When adding a new line just type the “*” key to bring up the advanced item look up and you can easily find the item the customer wants to buy.

Read the rest of this entry »

The demonstration virtual machines that you can download from the PartnerSource site have a blank company that you can use to create your own data within. The good news about it is that it’s clean, so you can create your own personal demonstration data without having to look at TV’s and stereos all of the time. The bad news is that the company is clean, so you have to configure all of the data yourself. That’s not a big problem though, the configuration is not that hard, and having your own data makes the Dynamics AX look so much better.

In this walkthrough we will show how you can start the process by configuring the US01 legal entity so that you can start using it. We will show how to:

• Configure the US01 legal entity
• Create a new business unit for the organization
• Configure the business account structures
• Configure the company ledger
• Set the default accounts for the automatic transactions
• Create a bank account for the organization Read the rest of this entry »

Well hello again my wonderful readers!

Ms. IBIS has been enjoying this lovely spring weather.  Do April showers really bring May flowers?  We shall see!

This week’s question comes from reader DS from Atlanta who writes: Read the rest of this entry »

The Print Management feature within Dynamics AX does a lot more than just allow you to print reports. It also allows you to e-mail reports, automatically print and distribute forms, and also have custom form versions by customer & vendor.

In this walkthrough we will show some of the different options available to you and also how to configure them within Dynamics AX. You will learn how to:

1. Send a Form via Email
2. Automatically Email A Form
3. Set Email defaults by Customer
4. Use the Batch Server to Automatically Generate Forms
5. Creating Alternate Form Versions Read the rest of this entry »

I’m posting this across AX, CRM and GP forums since, if you are doing BI/Data Warehouse ETL work against any of these products, you may run into this problem.

I recently restructured a SSIS package to allow several Data Flow tasks to run simultaneously.  To support this, I contained discrete operations involving independent table groups into Sequence Containers.  The first time I ran the package, I received a OLD DB Error 0×80004005 on the Data Write component in the Control Flow.  Interestingly, this only seemed to happen if I truncated the table before I did the write operation. Read the rest of this entry »