Finance | Project Operations, Human Resources, ...

AX2012: Clean up significantly inaccurate warehouse inventory

(0) Share

Report

Posted on by Brad Docimo

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

All responses (3)

Answers (0)

Suggested answer

Brad Docimo 485 on at

Like (1)

Report

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 on at

Like (0)

Report

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_ 60,278 on at

Like (0)

Report

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.