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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

AX2012: Clean up significantly inaccurate warehouse inventory

(0) ShareShare
ReportReport
Posted on by 485

I am assisting a customer with a warehouse that has significant on-hand discrepancies (>60%).

In addition to changing their business processes so this doesn't happen again, they need to do a 100% physical inventory and get back to accurate data in order for them to reset.

The mobile scanning solution they are implementing will allow them to go out and count everything in the warehouse easily, without a pre-created count journal.

The question is, is there any harm to zeroing out the entire warehouse on-hand inventory first and just counting back in what is actually there?  This is a food and beverage company, so it is extremely important that batch attributes, traceability, quality history, etc. are not lost.

And.. if zeroing it out isn't a problem, is a count journal the right way to do that, or movement journal, or inventory adjustment?

Thanks,

- Brad

I have the same question (0)
  • Suggested answer
    Brad Docimo Profile Picture
    485 on at
    RE: AX2012: Clean up significantly inaccurate warehouse inventory

    Thanks for the input.  My customer still wants to move ahead with zeroing everything out first.  So, we'll see how it goes.

  • Suggested answer
    Junaid Idrees Profile Picture
    on at
    RE: AX2012: Clean up significantly inaccurate warehouse inventory

    Hi Brad,

    I agree with ievgen, by using counting journal you will be able to post actual physical count in "Counted field" and based on that you can make the adjustment and reconcile your differences easily instead of zeroing out.

    If the on-hand discrepancy is > 60% as you said so what about the running cost of those items? Did you verified the cost element as well?

  • Suggested answer
    Mea_ Profile Picture
    60,284 on at
    RE: AX2012: Clean up significantly inaccurate warehouse inventory

    Counting journal is a right way to go and there is no point to zero it out because counting journal with adjust it either way.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans