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

Notifications

Announcements

No record found.

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
    Mea_ Profile Picture
    60,284 on at

    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.

  • Suggested answer
    Junaid Idrees Profile Picture
    on at

    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
    Brad Docimo Profile Picture
    485 on at

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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans