Inventory adjustments?

1

Hello,

I am trying to find away to adjust my inventory after doing an inventory count. My warehouse and erpnext counts are off.

How can I enter the current counts in to ERPNext?

2

hi @smokinjo

You can do stock reconciliation

https://docs.erpnext.com/docs/v13/user/manual/en/stock/stock-reconciliation

3

Hello,

Thanks for the reference.

The ideal one for me would be the one where we can download the CSV file, and enter out values.

But, before you can download a file, you need to type in every item that you want to see on the list.

Pointing out the obvious here would be to say that if I will take the time to type in each and every item and then download it, I can just as quick;y add in the new value for the current quantity at the same time as typing in the item itself.

Where is there a way that I could just:

Download ALL the products in a CSV file
Update the new quantities
Erase the unchanged items
Upload the file

How can I get a file with ALL items?

Thanks

Joseph

4

Doesn’t this help ??

https://docs.erpnext.com/docs/v13/user/manual/en/stock/stock-reconciliation#32-get-stock-balance-and-valuation-as-of-specific-date-and-time

5

Hi,

In addition to @centaur’s answer, also try this process.

Please check below image:

23
231109×594 57.3 KB

Please download csv file then you can change some value or qty after that update and save it.

Thank You!

6

Hello NCP and centaur

Thanks for the ideas. The idea of “fetch items form warehouse” is pretty much what am looking for.

If I understand it correctly, after fetching the items form the warehouse, I just download the list. Right?

I then adjust what ever numbers I need to adjust. Save it. The upload it on that same page and save it. Right?

Assuming nothing goes wrong, then my inventory will be updated. Right?

Thanks

7

Hi @smokinjo,

Right and go ahead with this process.

Thank You!

8

Hello @NCP. I am only now getting to solve my inventory issues:)

I was working on this today. Most columns were empty in my c ase, but 7 columns were filled:

item code
item name
warehouse
quantity
current quantity
valuation_rate
current valuation_rate

The only ones that seem to concern me are:
quantity
current quantity

Which one to I modify?

A part form the changes, do I leave everything else exactly that way it is? Should I erase the cells that are not changed? What do I keep, what can I erase?

Thanks

Joseph

9

Hello,
@NCP
I want to follo wuppn the queytsion form a few months ago.

In the downloaded inventory file, I need to update the column called “quantity”.

But, which one?

There are two of them?

Can some one guide me to find the correct way of doing this?

Thanks

Joseph