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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Average Onhand Invento...
Microsoft Dynamics AX (Archived)

Average Onhand Inventory by Item

(0) ShareShare
ReportReport
Posted on by Jennifer Krivensky 225

Is anyone aware of a field in AX that shows the average onhand inventory by item?  We are trying to figure out how much inventory of an item we average to help plan our warehouse space.  ie:  Item-A we had 2 onhand yesterday and 1 onhand today so the average of the two days would be 1.5 cases.

*This post is locked for comments

I have the same question (0)
  • salome Profile Picture
    salome 240 on at

    There is nothing in AX2009 that I know of that does this.  It would be a modification to my knowledge, or a report.   The InventTrans table contains all of the inventory transactions and is most likely the table to report off of.  (InventSum as well)

     Jeremy

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi,

    This is an issue that is also highly frustrating to us as you can see in various posts. For an ERP for this amount of money some basic and vital information is simply missing. We for instance purchased accidently about 200 shoes of about 100 euro each too much because the system was telling us every day we needed to replenish our stock.so we did. I am just a one person company so beating the hell out of Microsoft would not have any effect since I will not be able to stand the resistance of a large company of that size. We currently need to walk over daily over about 1.000 planned purchase orders which basically makes the system of the Master planning of no use. So we not create one by one PO's from the sales orders we cannot pick. A work around I would never accept if I had the money to stand against my partner or MS.

    Complaining and asking for Steve Ballmer did also not help me much. Nor suggesting a rating system for partners or at least having them proved by MS that some vital issues are told during sales, during implementation and after. The only thing I can offer is to team up and at the end decided together to have such of these basic missing functionality to be made.

    There is one option which helps us a bit: Go to the item table and then on Inquiries --> Statistics . This shows per quarter a bit. We decided to add 'master planning' for replenishment...but I think for the money an Excel (or Google Docs is better). A lot of functionality has bugs, is undocumented or not logical. Coding in AX is a hell to learn if you are used to modern languages as X++ and the partner network is not helping you at all.

    Based on the questions you raise I would advice you to look if you can revert your purchase and look for a small size vendor which has more overall knowledge on how basic processes run in a small to medium size business.

    I personally posted about > 200 bugs and I keep on seeing bugs in the AX software which we implemented in July 2009. We even accepted that some financial misrecordings are still present. Contracting a partner again would be too expensive on a rate of > 145 euro / hr. Asking help for dedicated MS team came after a lot of complains...but also disappeared as soon as they where unable to reproduce the bug...or I could not reproduce....as I also developed software and currently even code in Ax myself I know some bugs in Ax are that complex that some deeper digging is required.

    I am most likely the most frustrated and active single AX customer who adapted a bit to AX and has accepted that my business is not running that smooth as presented at first by MS and others. With a turn over is about 500.000 euro most of our time and money is wasted in the unexpected TCO that AX brings in either hardware, office software, development software, lacking functionality or simply expensive AX consultants beating the hell out of us.

    J.

  • Community Member Profile Picture
    Community Member on at

    Hi bBayt,

    This is a very interesting post / thoughts on AX.  I would not be surprised if you were contacted by a MS rep to discuss further.  Over the past few years I have worked internally for a few different companies as the only programmer at the company.  The system is very complex and to try to solve the riddle of modification requests is sometimes overwhelming.  Especially when you feel that if you do not know how to code something at first, you are not doing your job.  I completely agree with you that consultants are way too expensive.  I have laughed (to myself) when I see that some companies have been charged for 5 hours of work from a consultant where all the consultant did was write two to three lines of code.  I could have done that myself in about ten minutes.  All of this and the company does not know the extent of the work behind the modification because they do not know x++ or morphX themselves, so all the consultant has to do is pick an hour amount out of a hat and charge the hell out of a company.

    I guess however this is the nature of the beast but I do not necessarily agree with it.  

    I have found over the years that with hard dedicated work, you don't need a consultant anyway.  Having communities such as this one is a great tool at your disposal.  All the complex code changes can be solved with hard work and dedication.  Everything that I have struggled thru to code I eventually got done with some good research and hard work.  One decent thing about AX is the documentation.  There are a ton of references online.  I wish you well because I know exactly how you feel.

    Anyways, about MRP.  Though complex it does work well when you set it up correctly.  Using safety stock, min invent on hand and basic item coverage fields should properly give MRP enough to tell you when to order stock.

    Can you expand a little bit on the problem?  The community might be able to help.

    Kind regards.

  • user5555 Profile Picture
    user5555 7,437 on at

    Dear Bobby,

    I have created this post: https://community.dynamics.com/forums/t/36359.aspx. I coded an import file for importing another 8.000 items + variants from a file, but that MRP will become more and more our bottleneck since we manually need to step over every line to see and check what is required. 

    J.

  • user5555 Profile Picture
    user5555 7,437 on at

    @Bobby,

    You state :"The system is very complex and to try to solve the riddle of modification requests is sometimes overwhelming. ".

    The system is not very complex. It is missing vital elements which makes that you cannot drive your business from start. In a basic financial system you have a P/L, a balance report, a report telling you what has been sold and what the kpi's are. You can easily set up barcode scanners etc. Such essential information is simply missing and takes first tons of investment to get them out. I expected such things to be present in an ERP and did not investigate if those things where present.

    I expected a system which medium to large companies choose because it paves standard business processes but with the flexibility to finetune where small local vendors do not have that. For my business processes I needed the dimension setup which other software vendors do not supply and the flexibility to adapt and finetune small parts of my business in the end. I hardly had time to finetune since vital elements are simply not there.

    The impact is like a heart surgery on a recently borned baby: will it survive since it has to fight against a situation which should have been present from start. My baby will not recover and I cannot pay the enormous costs for the good health of my business. 

    J. 

  • Community Member Profile Picture
    Community Member on at

    " In a basic financial system you have a P/L, a balance report, a report telling you what has been sold and what the kpi's are. You can easily set up barcode scanners etc."

    AX does have all of that.  Barcode integration is also not too difficult, does take a little bit of work though.  I think you are overwhelmed with managing your business and the software on your own.  Perhaps look into hiring someone else that has some AX skills (internally, not consultants...)?

  • user5555 Profile Picture
    user5555 7,437 on at

    @Bobby,

    You are correct: "AX is indead one of the things which is overwhelming my business". I cannot afford to spend more and more on software. It is resource consuming and does put me in the driving seat.

    J.

  • Community Member Profile Picture
    Community Member on at

    Bbayt,

    I meant you are overwhelmed because you are handling this all on your own!   I would advise you hire some help, does not have to be a consultant.

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi,

    I did, but I cannot afford to contract more and more.

    J.

  • Jennifer Krivensky Profile Picture
    Jennifer Krivensky 225 on at

    J.

    I understand.  We are a larger company and we do have plenty of help, and every other company we have spoken to who have AX have spent more than triple their budget.  Just try to take deep breaths.  We are finally getting somewhere after almost a year.  Our consulting group didn't even tell us until about 2 months ago that there is an AX User Group!  If you haven't joined already, I suggest you do.  This post has nothing to do with the previous questions, I just wanted you to know that you are not the only person frustrated with this system.

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
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans