data port change quantity and cost per item proplem

Business Central/NAV Developers Forum
1

I have item has wrong in quantity and cost and unit of measure so that i create new item with same name then block old

then add new entries after correction .I decided to make data port export all entries to specified item to text file then change it and import again from tables item ,value entry,item ledger entry which fields will change in this.

before changes

quantity invoiced quantity remaining quantity unit measure

2.5 2.5 2.5 ton

value entry

cost per unit 635

i need after changes 2500 2500 2500 kg

cost per unit 0.635

My question after changes which fields i will change

are this only and when i change change purchase entry only

please help me if possible

thanks

2

As per your post I understand that you are doing positive & Negative Adjustment.

3

can you give me one solution if data port.

as you told me before i create new item then block old item then in new item how i will added consumped entries are i added as negative adjustment then purchase as positive adjustment with correction how i will added this my problem

please help me mr amol

4

are this will solve the problem by adding correction to item

5

Are negative and positive adjustment with correct values to new item will solve the problem

6

If you are changing quantity & cost then you use negative & positive adjustment If you are revaluing the item cost then use revaluation journal.