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

10

Can som eone please confirm whcih of th etwo I need ot use?

quantity?

or

Current quantity?

Thanks

Joseph

11

Current Quantity is quantity before reconciliation and the Quantity (qty field) is the one you would be entering the data in.

1 Like
12

Thank you for clearing up this mystery:) Much appreciated!!!