Dynamics AX 2009 Brief Points to Inventory Recalculations and Closings:

Posted Friday, July 17th, 2009

The following are some brief / informational points related to a month-end inventory close:

  • Adjustments required to inventory and the general ledger can occur without completing a month-end inventory close.  An inventory recalculation can be run to make adjustments.  This process however does not settle the inventory transactions.
  • Inventory close does settle issues to items, bill of materials and service item types.
  • Inventory dimensions can control the settlement process within a specific dimension, i.e. an item issued in an inventory dimension cannot be settled against another inventory dimension.  To control within a specific dimension, the financial inventory parameter must be selected on the dimension.  This control does apply to the Marking functionality.
  • Following inventory close, transactions can no longer be posted to the closed periods.  If required, the close would have to be cancelled, transactions posted, and the period closed again.  Any adjustments made, following the close, would also require cancellation.
  • Manual adjustments can be made to transactions with a receipt status of “purchased” or to on hand quantities.  Both adjustments allow for the cost of a transaction to be adjusted based on the purchase price or to the value of the current on hand quantity.  A recalculation is required for the adjustment(s) to affect an inventory value.
  • Manual adjustments to on hand inventory should be done immediately following an inventory close.
  • Review steps in preparing for a month-end close:
  • Run the Open quantity report to view a list of inventory transactions that will remain open after the close.  Use this report to clean up transactions which should have been posted or cancelled.
  • Run the Check cost prices report to view the differences between the item’s cost price and the receipt price.  Adjustments should be made where required, prior to the close.  Note when running this report a maximum deviation percentage can be set to determine the differences to review.  This report can be re-run, following adjustments, until all required changes have been recorded.
  • When satisfied with adjustments, run the Close procedure to complete the month-end inventory close.

Tags: ,

Posted in Dynamics AX, Production, Trade and Logistics

Not yet using Dynamics AX? I.B.I.S., Inc. gives you the Dynamics AX options you want, and the business results you need.
Learn more about our Dynamics AX solutions

Leave a Reply

*
*