What's New in AX 2012 R2: Accounting

Over the next few posts we hope to share some of the changes coming to AX 2012 R2. We will cover accounting to sales and everywhere in between. It is our job to put the value in AX.

Take time to discover the new changes in-store for the accounting sections of AX 2012 R2 and stay ahead of the curve.


Accounts Payable:

1. Adjusts taxes on an invoice line.


2. Integrate a payment calendar to control due dates for payments.


3. Record charges on free text invoice lines.

Accounts Receivable, Budgeting and General Ledger:

1. Create and approve budget plans.
   
2. Configure a recurring schedule batch job to clear purchase accrual for product receipt source documents.
   
3. Expand default description support.
   
4. Fixed financial dimension values.
   
5. General ledger balances are updated when a process needs balances.
   
6. Inter-unit accounting
   
7. Language translations for the main account name and the financial dimension description.
   
8. Legal entities can have more than one consolidation account.
   
9. New framework for exchange rate import.
   
10. Shared main account lists.
    
11. Tax registration numbers defined at the party address record level.
    
12. Updates are available to General ledger reports.

If you have a question about Dynamics AX that you would like answered, please email us. Or visit the BWIR website for more information about the company.

Microsoft going after enterprises with Dynamics AX ERP

Dynamics AX is starting to land global deployments with large enterprises, including Revlon.

Microsoft hoped recent updates to its Dynamics AX 2012 ERP (enterprise-resource-planning) software would help it grab enterprise-level deals that would ordinarily be won by the likes of Oracle and SAP, and to some degree the strategy appears to be clicking.

Read Chris Kanaracus' Post

Partial sales order invoice processing.

Q: No Sales Consumption for some parts in SO invoice AX 2012 FIFO

A: First, ensure that the following setups are done:

Item model group:
1. Post Physical inventory to Ledger - Check mark
2. Post Financial Inventory to ledger - Check mark

Inventory model group action panel":
1. Incude Physical value - Check mark - Which will consider the Physical values (Received not invoiced / Report as finished not ended) for arriving the Avg cost price.

Whenever an outbound entry is getting posted , such as; Sales packing slip/Sales Invoice, Purchase return/Purchase debit note, Transfer shipment and Movement journal with Negative Qty posting, system will pick the cost price from On-hand Inventory cost price field. If that is zero then it will pick the cost price from the "Price" field on the manage inventory tab. If both are zero then the cost price of the outbound entry will be zero.

Finally, all the cost prices will be adjusted according to the Inventory model (FIFO or LIFO,etc.,) based on the actual entry used for the consumption, by running the inventory recalculation/inventory closing process.
 

Top Reasons To Buy Microsoft Dynamics AX

Top Reasons To Buy Microsoft Dynamics AX {brochure}.

BWIR tailor this to your unique needs. If you have any questions please email us.

View: Top Reasons To Buy Microsoft Dynamics AX

2013 BI Trends: Microsoft Dynamics Users Weigh Range of Options

Defined as a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information, business intelligence (BI) is gaining ground in an environment where applications continually generate large volumes of data that can't be effectively managed, assessed, and utilized via manual processes.

Microsoft Dynamics customers already have many third party BI applications at their fingertips, as well as the building blocks for a custom ...

Read Bridget McCrea's post

Check out the below article from the Microsoft PartnerSource:

Mobile Apps for Microsoft Dynamics AX

Do you have mobile scenarios for phones and tablets in conjunction with your Microsoft Dynamics AX deployments? This page provides an overview of the scenarios and Mobile apps that are currently available. For a future roadmap please see the Microsoft Dynamics AX Statement of Direction.

Windows Phone 7 / Windows Phone 8 apps:

Microsoft Dynamics AX

This application enables you to capture expenses, and is intended to be used in combination with Microsoft Dynamics AX 2012 Expense Management. The app supports capturing a photo of the receipt as well as entering expense details. Coming soon the app will support entering a timesheet as well.

The app communicates with Microsoft Dynamics AX through the Windows Azure Service bus, and Mobile applications connector (see below). Read more about the app here http://www.windowsphone.com/en-us/store/app/dynamics-ax/122b713d-a446-428a-b450-be041ec90340

Downloads:

1.       Download the app from the Windows Phone market place

2.       Download (and install) the Microsoft Dynamics AX Connector for Mobile Applications

Whitepaper:

Read how to install and configure the Microsoft Dynamics AX Connector for Mobile Applications in the whitepaper

Windows Phone 8 and Windows 8 Apps:

Coming soon.

Developer guidance for building mobile apps that work with Dynamics AX:

Coming soon.

Enable workflow approval via email (on any device):

Coming soon.

Are you developing mobile apps for Microsoft Dynamics AX? Take a look at this “guidance document” on best practices developing these apps.

URL:

https://mbs.microsoft.com/partnersource/newsevents/news/msdyn_mobileappsax.htm?printpage=false

If you have a question about Dynamics AX that you would like answered, please email us. Or visit the BWIR website for more information about the company.

Quantity on hand based on location

Q: In the Dynamics AX Application tables, InventItemLocation has wmsPickingLocation for each ItemId, and InventCountJour table has IventOnHand for each ItemId. How do you find out the amount of quantity on hand per location?

A: onHand quantity (information) should be available in the InventSum table, so go through the table and write your query. If you would like to filter the information based on a location, search for the field called “InventDim” which will tell you about the different dimensions.  Below is the code that should help you get the onHand:

static void findOnHand(Args _args)
{
InventDim inventDim;
InventDimParm inventDimParm;
Itemid itemid;
InventOnHand inventOnHand = new InventOnHand();
;

// take a sample item for testing
itemid = "Item1";

// take a combination of dimension , against which you want to find the stock
inventDim.InventLocationId = "STL";

//Set the flag for the selected dimensions as active.
inventDimParm.initFromInventDim(inventDim);

//initialize the inventonhand with item,dimension and dim paramter

inventOnHand.parmItemId(itemid);
inventOnHand.parmInventDim(inventDim);
inventOnHand.parmInventDimParm(inventDimParm);

// Retrieve the onhand info
info(strfmt("Available Physical: %1",
inventOnhand.availPhysical()));
info(strfmt("On order: %1",inventOnhand.onOrder()));

}

If you have a question about Dynamics AX that you would like answered, please email us. Or visit the BWIR website for more information about the company.

Check out the below article from the Microsoft PartnerSource:

Mobile Apps for Microsoft Dynamics AX

Do you have mobile scenarios for phones and tablets in conjunction with your Microsoft Dynamics AX deployments? This page provides an overview of the scenarios and Mobile apps that are currently available. For a future roadmap please see the Microsoft Dynamics AX Statement of Direction.

Windows Phone 7 / Windows Phone 8 apps:

Microsoft Dynamics AX

This application enables you to capture expenses, and is intended to be used in combination with Microsoft Dynamics AX 2012 Expense Management. The app supports capturing a photo of the receipt as well as entering expense details. Coming soon the app will support entering a timesheet as well.

The app communicates with Microsoft Dynamics AX through the Windows Azure Service bus, and Mobile applications connector (see below). Read more about the app here http://www.windowsphone.com/en-us/store/app/dynamics-ax/122b713d-a446-428a-b450-be041ec90340

Downloads:

1.       Download the app from the Windows Phone market place

2.       Download (and install) the Microsoft Dynamics AX Connector for Mobile Applications

Whitepaper:

Read how to install and configure the Microsoft Dynamics AX Connector for Mobile Applications in the whitepaper

Windows Phone 8 and Windows 8 Apps:

Coming soon.

Developer guidance for building mobile apps that work with Dynamics AX:

Coming soon.

Enable workflow approval via email (on any device):

Coming soon.

Are you developing mobile apps for Microsoft Dynamics AX? Take a look at this “guidance document” on best practices developing these apps.

URL:

https://mbs.microsoft.com/partnersource/newsevents/news/msdyn_mobileappsax.htm?printpage=false 

If you have a question about Dynamics AX that you would like answered, please email us. Or visit the BWIR website for more information about the company.