Fixed!! - Relation between Project Purchase Order Posting and Category Cost Accounts?

Hello my friends!

Sorry, it's been a while since I posted, as I have been away from AX and have been working on  Sharepoint, Reporting and BI. I have a few interesting posts on that coming soon.

Back to AX, I'm doing functional setup for AX Projects as our company is implementing Project Accounting module. I'm not so brilliant from a functional side and I have been stuck on this below issue...

Issue

We are planning to use Projects Module in Dynamics AX and we have setup Projects, sub-projects, category groups, categories and so forth..

We are going to use Investment type project for our purpose. For that we would be using Project Items and these would be set as Service Items in Inventory module and PO would be raised against them. So, technically these are project purchase orders which relates to a project and category and now when we invoice these PO's the transactions should be reflected against the item and project.

At the PO level ,everything looks fine and we can see the financial transactions generated for the posting accounts setup at inventory level. But when it comes to the associated project with the PO, we are not able to see the financial transactions generated for the category accounts. For e.g. we have a Category group called "Inventory" and we have Posting accounts setup at Cost, WIP-Cost Value and Cost-Item value, so when we post a PO we expect these costs accounts reflect the financial transactions,

I'm not sure how the relation between Project Accounting and PO Posting works. Are we missing any setups here? Hope I made my problem clear. Let me know if you need further information. Any help in the right direction appreciated.

Solution
Thanks a ton John!!!! Below is the solution to my issue.


Dilip,

I've noticed that this will occur if Post Financial Inventory is turned off on the Inventory Model Group of the item. If you have it turned on, it should go into the Purchase, Receipt account, out of the Inventory Issue account and hit the appropriate account determined by the selected Project Category. If not, it will just hit the Purchase, Consumption account. Hopefully this will help.

Hey John,

Mate, if you are reading this and you out here somewhere in Melbourne, lets catch up ..I owe you a beer mate you have made my life so easier :)..

Thanks to the power of social media and blogging, I got the answer within an hour I posted this issue on my blog. Just can't believe it!

Troubleshooting Error: No License code available for language EN-US. Please use a licensed language

Hi there, I was setting up an AX Instance from an existing  database backup and I hit this below error.

Error: No License code available for language EN-US. Please use a licensed language

Event Viewer Error: The Microsoft Dynamics AX Application Object Server is running on an operating system that is not supported. The supported operating system is Microsoft Windows Server 2003 with Service Pack 1.

Solution:

The language for the startup user needs to be setup as per the installation

update dbo.USERINFO set LANGUAGE = 'EN-AU', HELPLANGUAGE = 'EN-AU' where ID = 'Admin'

Microsoft Dynamics AX Resources

Hi All,

A quick post - As I was tweeting today, I found this very useful website/blog known as Microsoft Dynamics AX Resources page

Some cool links to be bookmarked

 - Resource Page for Upgrading to Dynamics AX 2012
 - Resource Page for SSAS/SSRS Integration in Dynamics AX

Webcast Review Microsoft Dynamics AX 2012 Licensing

Microsoft Dynamics Webcast: Review Microsoft Dynamics AX 2012 Licensing (Level 100)

EventID:1032501461

Starts:Thursday, February 16, 2012 10:00 AM

Time zone: (GMT-08:00) Pacific Time (US & Canada)

Duration: 1 hour(s)

Language(s): English.

Product(s): Microsoft Dynamics Existing Customer Portal.

Audience(s): Non-Tech Influencing BDM.

As companies move from previous versions of Microsoft Dynamics AX to Microsoft Dynamics AX 2012, they adopt new licensing models. As part of any upgrade, it is important for users to understand their licensing options and the best approach to maximize their Microsoft Dynamics AX investment. In this session, learn about the new, easier to understand licensing model for Microsoft Dynamics AX 2012.

Presenter: Todd Bergeson, Product Marketing Manager, Microsoft Corporation

Register here for the webcast

Webcast Integrating Microsoft Dynamics AX 2012 with SAP for Expense Management

TechNet Webcast: Integrating Microsoft Dynamics AX 2012 with SAP for Expense Management (Level 300)

EventID:1032499676

Starts:Tuesday, February 21, 2012 9:30 AM

Time zone: (GMT-08:00) Pacific Time (US & Canada)

Duration: 1 hour(s)

Language(s): English.

Product(s): Microsoft Dynamics AX.

Audience(s): IT Decision Maker and IT Generalist.

Learn how Microsoft standardized on one solution, globally, for employee expense management. In this webcast, we describe how integrating Microsoft Dynamics AX 2012 with SAP for expense management achieved greater policy enforcement, improved flexibility to react to changing business conditions, and reduced long term maintenance costs while enabling future business capabilities.

Presented By:

Ade Ajayi, Microsoft IT Senior Solution Manager, Microsoft Corporation

Shiran Sathananthan, Microsoft IT Principle Program Manager Lead, Microsoft Corporation


Register here for the webcast