web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Inventory Opening Balances

(0) ShareShare
ReportReport
Posted on by

Hi,

during the implementation of AX 2012 , the person in-charge of the implementation uploaded the inventory opening balance as of 01/03/2017 on the live and its been posted. since he suppose to upload the closing as of 31st December 2016 as he didn't get the last year closing in order to tally the IN-OUT transactions and book the cost probably. 

i suggested to start the following :- 

  • the procurement Department shall create all the purchase orders for January and February since they are the missing months
  • i requested the stores to start update the Item receipts and issuance in order to book the cost probably for those two months

my questions :

  • for those items which are received and issued within the first two months the quantity will be Zero as well as the uploaded balance is zero 

so no action shall be taken. is that right?

  • on level of item, in case the result of IN-OUT (Receiving and issuance) remaining quantity is less or more than the uploaded balances

what the process in order to correct the Qty a as the cost of the inventory calculation is weighted average. 

please advice

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Do you already have inventory transactions on those items that were uploaded as of March 1st?

    Do you really need the inventory transactions for the first two months or only the GL postings?

    Best regards

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    • Do you already have inventory transactions on those items that were uploaded as of March 1st?

    Yes i have a lot of transactions posted since Match 1st. 

    • Do you really need the inventory transactions for the first two months or only the GL postings?

    Yes i need all The inventory transactions (Receipts and issuance) in order to recognize the billing and payment 

    apply in respect of receipts and in order for proper booking for cost issuance to each project. 

    and already the stores started of those entries in order to reach to reconciliation between Inventory uploaded as of March 1st 

    and the ending balance due to entry of the first two months transactions. 

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Ahmed El Hamrawy,

    Bringing in the previous transactions for the first two months incl. the billing and payment, etc. involves a lot of work and requires you to consider a lot of things. I do not know about how many transactions we talk but I assume a lot. Are you on your own here or do you have a team around you who can help because you might need some people to get those transactions in?

    I have a question about the way how you want to bring those transactions in because touching inventory always has an influence on the availability of goods, current SO and POs, MasterPlanning, etc. Do you and your team already have a plan how to deal with those issues? Will people be allowed to continue working while you are doing the corrections or do they have to stop for a while?

    Guess you need to develop a very detailed 'battle plan' to get this corrected.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    already dedicated team is there and start the work already regarding the backlog entries either from store or from finance. 

    as i mentioned reconciliation been explained and to be done once we finish the entry on each line item

    considering the update is been done and the transactions bee posted correctly (Item receipts, item issuance , Billing even payment ) , i want to know the next steps (system process, Entries )which i shall do it for  those items which have a difference either plus or minus than the uploaded balances. 

    please advice. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans