Wednesday, May 10, 2017

Monthly Inventory Close in Microsoft Dynamics AX 2012


Ax 2012 

Monthly Inventory Close in Microsoft Dynamics AX 2012

If you've ever asked yourself this question you are not alone.  Although Dynamics AX offers some great tools in helping you close out inventory every month many people do not even know they are there. Inventory closing is necessary for your business to calculate the correct costs prices of inventory, so it is critical to make sure we run inventory close correctly to ensure accurate results.  In this post we are going to go through the steps associated with completing a successful inventory close.  
Steps to perform a monthly inventory close:
1.      Navigate to Inventory and Warehouse management > Periodic > Closing and Adjustment
2.      In upper right hand corner click on ‘Close Procedure’ button.  And perform steps 3-5.
3.      Click ‘1. Check open quantities’:
·        In ‘Expected closing date’ field, choose the last day of the month you will be closing inventory for, and click ‘OK’.  

·        This will print a report of all of the open quantities that will not be fully settled by the inventory close on the specified date. These are items that were physically updated but not financially updated items before the inventory close date. 
·        Before running inventory close distribute this list to the appropriate people to financially update anything that can be – end any open production orders or invoice and shipped or received sales or purchase orders.
  
4.      Click ‘2. Check Cost Prices’:
·        In ‘Expected closing date’ field, choose the last day of the month you will be closing inventory for. 
·        Choose a deviation percentage – this is what you choose to be acceptable for the deviation from the item’s cost price on any given transaction.
·        Choose a specific item group to look at if you want to look at this report one group at a time. 
·        Click OK
 
·        The report printed will give a list with dates of transactions that deviate from the cost price.
·        Once the report is printed look at transactions for all items on the report – this will help you identify any costs entered in error

5.      Click Adjustment to adjust any cost prices for items that were incorrectly entered into the system.  You can filter by item number, transaction date, voucher number, batch number, etc.
 
 
 
Once the screen populates with transactions you are able to adjust the transaction cost amount.  Enter the amount you want to increase or decrease the transaction amount by in the edit now field.  Click post, and make sure to change the posting date to the date of the original transaction.
 
Now we are ready to close inventory!

6.      Click ‘3. Close’, in ‘Close inventory up to’ field enter the last day of the month you will be closing inventory for, and click ‘OK’ to close inventory for the month.

4 comments:

  1. I really appreciate the information shared above. It’s of great help. MaxMunus provides Remote Support For Corporate and for Individuals. If anyone is facing any issue in his project of #REDPRAIRIE #WMS we can support them remotely , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Industry best Consultant on #REDPRAIRIE #WMS. We provide end to end Remote Support on Projects. MaxMunus is successfully doing remote support for countries like India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain, and UAE etc.
    Avishek Priyadarshi
    MaxMunus
    E-mail: avishek@maxmunus.com
    Skype id: avishek_2.
    Ph:(0) 8553177744 / 080 - 41103383
    http://www.maxmunus.com

    ReplyDelete
  2. I was looking at some of your posts on this website and I conceive this web site is really instructive! Keep putting up.. فعالسازی لایسنس

    ReplyDelete
  3. You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it! mvp

    ReplyDelete
  4. The information you have posted is very useful. The sites you have referred was good. Thanks for sharing...
    buy perfectmoney with credit card

    ReplyDelete