How to handle value entries for Old Item Ledger Entries.

DRB

Hi,

We have upgraded navision financial 2.01 into navision attain 3.60.
there two major problems

1.Since there was no Value Entry Table in the 2.01 version,so when we try to post any sales entry or nagetive adjustment system looks for value entry against Item Ledger Entry against which sales or nagetive entry is being post.

2. Since avarage cost of Item is based on Value Entries in Navision
attain 3.60 and there is no value entries for the Items how can this
problem be resolved.

We tried to create value Entries against all the old Item Ledger Entries so that system could allow to post sales and nagetive adjustment entries and this also resolve our average cost for the Item in Item Card..but

when we run Post Cost to G/L batch job system posts cost in various relavant G/L account which is a problem for us because this makes huge differences in G/L account balance.

Please suggest.

kine

You need to set correct "Cost posted to G/L" to prevent repeated posting into G/L. But please, discuss it with some finance consultant for NAV, I am developer and I do not have enough knowledge about that....

DRB

Thanks kine

David_Singleton

DRB wrote:

Hi,

We have upgraded navision financial 2.01 into navision attain 3.60.
there two major problems

1.Since there was no Value Entry Table in the 2.01 version,so when we try to post any sales entry or nagetive adjustment system looks for value entry against Item Ledger Entry against which sales or nagetive entry is being post.

2. Since avarage cost of Item is based on Value Entries in Navision
attain 3.60 and there is no value entries for the Items how can this
problem be resolved.

We tried to create value Entries against all the old Item Ledger Entries so that system could allow to post sales and nagetive adjustment entries and this also resolve our average cost for the Item in Item Card..but

when we run Post Cost to G/L batch job system posts cost in various relavant G/L account which is a problem for us because this makes huge differences in G/L account balance.

Please suggest.

How did you convert this? Did you use the upgrade toolkit? If so its should have created the Value entries for you, there is no need for you to create them.

DRB

Thanks David,
In fact one of my colleague is working on this project and (unfortunately) he has not used the tool kit for upgradation.

David_Singleton

DRB wrote:

Thanks David,
In fact one of my colleague is working on this project and (unfortunately) he has not used the tool kit for upgradation.

You really should not be manually upgrading like that. The only time you would do that is if the system was so heavily (or badly) modified that you decided it would be easier to start new.

If that is the case, then he should not have brought over the Item Ledger entries, instead he should have used them to populate and Item Journal and then post the Journal.

I can give you a 99.9% guarantee that this is going to continue to cause you problems for many years to come. If its not too late, I would stop now and start again from scratch. In the long run it will be cheaper.