Imported Stock Entry doesn't include column in csv

ERPNext Stock/Inventory
, , ,
1

Howdy!

I am working out the process for importing our opening stock of our batched materials. So far I have imported the Items and the Batch Numbers attached to those items, and I am attempting to import a Stock Entry transaction via the Data Import tool.

For the template I downloaded, I included the Valuation Rate and Batch No columns for the Stock Entry Detail DocType so that I could put all needed information on the import. The csv file has the valuation rates under the proper column heading, but when imported the resulting Stock Entry and child Stock Entry Details do not have the rates attached to the items. In fact, the Valuation Rate attribute isn’t modifiable when I go to edit an Entry Detail.

Should I be using Basic Rate (as per Stock UOM) instead of Valuation Rate, or is there something else that I am missing? I’m using ERPNext version v7.2.14

2

Just enter value in the Basic Rate field. Same value will be updated in the Valuation Rate field as well.

3

@cmfce: you should probably use basic rate indeed.

Valuation rate is the average value of an item in your stock in warehouse(s) over time. when/if you use FIFO in stock management / accounting, you may purchase the same items under different basic rates (purchase prices) thus Valuation rate averages it.

You may want to review Different between incoming rate & valuation rate for more context on that.

4

@umair, @gvyshnya: Thank you both very much! That solved the problem I was having. Everything got imported just fine.

2 Likes
6

If you have used ERPNext, and liked it, then please help us spread the word by submitting your reviews on the following sites.

http://www.capterra.com/enterprise-resource-planning-software/spotlight/132657/ERPNext/Web%20Notes%20Technologies

http://alternativeto.net/software/erpnext/

https://www.getapp.com/operations-management-software/a/iwebnotes/

We as a community can achieve lot more than as individuals.