Inventory Closing in AX2009

 

Steps that are performed by the Inventory Close routine
When you run the Close routine, Microsoft Dynamics AX performs the following steps:
1. Check whether any Recalculations were run after the date that you choose for your Close. Microsoft Dynamics AX will cancel any of those later Recalculations before the Close can start.
2. Put all the items that are to be processed into a queue. These items are stored in the InventCostList table.
Note While a Close or Recalculation is processing, you can click Calculation/Calculation List from the Close & adjustment form to view the data in the InventCostList table. This shows which items are still to be processed by the Close or Recalculation process.
3. Process each item from that queue sequentially. Microsoft Dynamics AX performs the following for each item:
a. Settle individual receipts and issues against one another for the item according to the Inventory Model Group such as FIFO, Weighted Average. • Make any required cost adjustments to the issue that was settled based on the cost of the receipt(s) against which the issue was settled.
• Update the inventory transactions to show the settlement and cost adjustment data.
• Write the settlement data into the Inventory Settlement table. The data will include records that show explicitly which Receipt(s) were settled to each Issue in addition to any cost adjustment that is made to the Issue that is settled.
b. As soon as all possible transactions are processed for that item, Microsoft Dynamics AX looks for any transactions that are fully settled, and then update those transactions to "Closed." For more information, see the "What fields show that an inventory transaction is closed" section.
4. As soon as all the items are processed, the settlement records that were created are read and sorted by General Ledger Account. Then, Microsoft Dynamics AX summarizes all the cost adjustments that were made, and a General Ledger Journal is created and posted.
5. If you select the Run recalculation after closing check box in the Close dialog box, a Recalculation will be run for all items up to today's date.
Steps that are performed by the Inventory Recalculation routine
The Inventory Recalculation routine does a similar job to the Inventory Close routine. However, there are a few differences. When you run the Recalculation routine, Microsoft Dynamics AX performs the following steps:1. Check whether any Recalculations were run after the date that you choose to run your Recalculation up to. Microsoft Dynamics AX will cancel any of those later Recalculations found before your Recalculation routine can start.
Notes
• In the Select dialog box, you can select item(s) for which you want to run the Recalculation, unlike the Close routine that always processes all items.
• While a Recalculation or Close is processing, you can click Calculation/Calculation List from the Close & adjustment form to view the data in the InventCostList table. This shows which items are still to be processed by that Close or Recalculation.
2. Put all the items that are to be processed into a queue, and then store the queue in the InventCostList table.
3. Process each item from that queue sequentially. Microsoft Dynamics AX performs the following for each item: • Make a "virtual" settlement between individual receipts and issues for the item according to the Inventory Model Group such as FIFO, Weighted Average. This is a "virtual" settlement because it is occurs in the Recalculation’s calculations. However, the detailed settlement data that shows the explicit matching of each issue to the various receipts is not stored in the InventSettlement table. The only data that is stored is the cost adjustment that is made to the issue.• Make any required cost adjustments to the issue that was settled based on the cost of the receipt(s) against which the issue was settled.
• Write a single settlement record for any cost adjustment that is made for that Issue into the Inventory Settlement table.
4. As soon as all the items are processed, the cost adjustment settlement records that were created are read, sorted by General Ledger Account, and summarized and posted in a General Ledger Journal.
What fields show that an inventory transaction is closed
To show that an inventory transaction is "closed", Microsoft Dynamics AX performs the following:1. When the Inventory Close routine has fully settled the Quantity and Financial Cost of a specific inventory transaction, Microsoft Dynamics AX updates the individual inventory transaction to show that the transaction is "closed."
2. For a transaction to be closed, it must meet the following criteria:• The "Quantity" must match the "Quantity Settled."
• The sum of "Cost Amount Posted" plus "Cost Amount Adjustment" must match the "Cost Amount Settled."
3. When those conditions are met, then the Close program will do the following:• Set the field "Value Open" from "Yes" to "No."
• Store the date of the close in the field "Date Closed."
This means that the individual inventory transaction is "closed."

Microsoft Dynamics Sure Step 2010 now available!

 

We are pleased to announce the availability of Sure Step 2010 to our Microsoft Dynamics partner community today!  In the spirit of providing continual enhancements in collaboration capabilities, increased partner productivity and improved customer satisfaction, this major upgrade includes the following features that align with Microsoft Dynamics product strategies and roadmap:

· Industry and Cross-Product Content - Positioning and deploying Microsoft Dynamics solutions in a given Industry or its related segments.  Industry Pilots for AX Process Manufacturing and CRM Public Sector including the launch of an Industry Playbook for solution selling.  Also available will be guidance on xRM platform due-diligence and deployment.

• Agile Project Type – The addition of this project type which will be especially suitable for implementations where the Microsoft Dynamics solution is positioned as a platform rather than as a commercial-off-the-shelf (COTS) system.
• Organizational Change Management Discipline – New guidance on managing organizational change, to address this common challenge in any ERP or CRM deployment.
• ISV Guidance – New content that applies to ISV solution positioning and deployment and engagement with the VARs and SIs during sales and implementation. Also, introducing Certified for Microsoft Dynamics alignment recommendations.

· Enhancements to the Diagnostic Phase including a link between Sure Step and Unleash Your Potential, an Industry Playbook to assist the Sales Roles focused on selling Microsoft Dynamics solutions catered to a specific industry/vertical, a consolidated set of Decision Accelerator Offerings, estimation tools and an enhanced ROI calculator.

· Enhancements to the Optimization Offerings including further alignment and integration to Support and Services from Microsoft and additional proactive and post go-live offerings.

· Enhanced SharePoint integration provides improved collaboration and project tracking capabilities for Sales, Implementation and Optimization engagements.

· This, in addition, to new, updated templates to support the latest Microsoft Dynamics releases!

Continue investing in Sure Step and get to know and love Sure Step 2010! Visit Sure Step on PartnerSource for updated training and readiness resources to help you get started and continue your adoption of Sure Step

Demand Planner Discontinuation Notice for Microsoft Dynamics AX, Microsoft Dynamics GP and Microsoft Dynamics NAV

The Demand Planner module available for Microsoft Dynamics AX, Microsoft Dynamics GP and Microsoft Dynamics NAV will no longer be offered by Microsoft and all associated SKUs will be removed from the respective Microsoft Dynamics  price lists effective April 1, 2010.

This December 1, 2009 announcement provides partners with the 120-days notice required pursuant to the Solution Provider Agreement (SPA).

  If your customers are concerned about Microsoft’s discontinuation of Demand Planner for Microsoft Dynamics AX, Microsoft Dynamics GP or Microsoft Dynamics NAV and are considering no longer using their existing implementation of Demand Planner offered by Microsoft, we encourage you to assist them by working with independent software vendors who may provide similar forecast management capabilities for Microsoft Dynamics applications.

5 recent SAP Failures

SIEMENS Teamcenter Express Integration to Microsoft Dynamics AX

OneStop Reporting Tool for MS Dynamics AX

At Long Last, Microsoft Unveils Its Verticals Strategy for Dynamics AX

For several years, Microsoft has been promising Dynamics users and partners vertical solutions--special functionality geared toward particular industries.

Now, it is delivering on the promise, beginning with Dynamics AX customers.

Microsoft announced today four acquisitions of intellectual property designed to provide industry solutions across the verticals of pharmaceuticals, food, retail, manufacturing, and professional services:

• A process manufacturing solution acquired from Fullscope Inc., which provides tight integration of business processes across discrete manufacturing and process manufacturing
• A professional service solution acquired from Computer Generated Solutions Inc., which delivers a single system to manage projects and resources, execute financial transactions and customer billing, and match resources with client assignments
• Retail solutions from LS Retail EHF and To-Increase Denmark A/S, a wholly owned subsidiary of Columbus IT Partner A/S, that enable Microsoft to provide an end-to-end retail solution including store management with point-of-sale, merchandising and ERP capabilities

In an interview, Crispin Read, Microsoft’s general manager for ERP, said “about 70% of our customers are in these five industries.” He noted that not included in the verticals being addressed now are financial services and health care. “We feel we have a better chance with focus than by being all over the waterfront.”

Process manufacturing and professional services solutions for Microsoft Dynamics AX are available immediately on the Microsoft Dynamics price list, and the retail solution will be available at a later date. The next industry vertical likely to be addressed will be the public sector, according to Read, though he declined to provide a timetable.

He noted that customers will benefit financially from the acquisitions. “This will lower the costs for customers by reducing the amount of customization they need to do.”

Crispin said that Microsoft’s market research showed that companies in the upper mid market, which mostly include those with operations in multiple countries, “all want vertical solutions.”

According to Crispin, Microsoft will focus in its vertical approach on “common functional requirements [that] exist across industries and can be packaged.” Partners will be able to focus on other more specialized functionality to serve companies that need additional customization, and will reduce their time to market and lower their investments.

Kees Hertogh, director of product management for Dynamics AX, identified customer benefits as including a “predictable roadmap” and “more rapid innovation.”

“We speed up our packaged best practices. Customers can really focus on competitive differentiators to compete more effectively.”

The vertical capabilities being acquired are from Fullscope Inc, To-Increase Computer Generate Solutions Inc, and LS Retail EHF