Inventory Ageing

Srivas

Hi All,

I have to bring inventory (stock) from one database (Nav4) to another(Nav2009) by ageing.
I am planning to use item journal (positive adjustment). What I am not sure of is "By Ageing"?
Earlier I was thinking to get unit cost and inventory figure from Item card and use those in item journal.

Can you please explain how I can achieve this?

Many Thanks

ara3n

why don't you just upgrade the inventory using the toolkit?

Srivas

Actually it isn't an upgrade. NAV2009 database already exists. I am trying to bring in the data of one company in to existing NAV 2009 database.
I am not sure if I can use the toolkit in this scenario. can you please let me know if it is ok to use and doesn't involve any object change? if it's not ok then could you please advise me on an alternative method.

Thanks a lot,

ara3n

Could you tell me why you need to bring it by aging?

Is this a one time process or ongoing integration?

Srivas

This is one time process. One of the client's location is moving from nav4 (this location is on nav4) to nav2009(existing database (with other locations)).

Client requires it by aging .

Thanks,

ara3n

I would use upgrade toolkit for just inventory.
Then renumber the "Entry No." for the transactions to new range and import them directly into item ledger, value entry, item application, dimension entry as new records.

lally

ara3n wrote:

I would use upgrade toolkit for just inventory.
Then renumber the "Entry No." for the transactions to new range and import them directly into item ledger, value entry, item application, dimension entry as new records.

Hi Rashed,

I also have the same requirement . Could you explain some more detail , because i did not understand the above statement?

Thanks and Regards.

ara3n

What is the aging requirement? Is it daily, monthly?

Srivas

its daily

gvolkov

Sum the records by day so that there is one record per day.

David_Singleton

This all depends on how many items and how many date layers you have.

ara3n

Loading it through the journal, will be way too many transactions for daily aging.

David_Singleton

ara3n wrote:

Loading it through the journal, will be way too many transactions for daily aging.

What are you basing this on? How do you know how many items and dates are involved?

Srivas

I was thinking to loop in item ledger entries and create item journals for each entry but as correctly pointed out that it will really take long time and may have to be done in batches.

Now I am looking to only pick the open item ledger entries and create a positive adjustment for these entries. This will reduce number of item journals.
Please let me know if I am planning it right

Thanks a lot!

ara3n

You can't do it by open only, because your aging won't there.

vijay_g

Exactly you can't do it by this way. if you would required even day wise aging atleast you must have to combine entries with every date layer.

Make sure you are not using any serial or lot no. tracking.

Srivas

what is the best way forward then. Do you think I should just pick the inventory and unit cost from item card and create the item journal.

Does it mean that there is no way to have the inventory by ageing? or you suggest not to go by aging and work with inventory balance from item card.

ara3n

One way you could do is this without using upgrade toolkit is this.

On First day run dump all the entries and unit cost on item journal
2. on second day and greater,
If there is a different in Quantity, Make a negative adjustment journal for the quantity difference.
If there is a cost difference . Make a negative adjustment for the whole quantity and a positive adjustment with new unit cost.

For every day you run the process, you need to keep track of previous day qty and unit cost to do the comparison above.

It's going to be a lot of entries, but at least you will get your aging correct.

ara3n

As far as using the toolkit. The detail explanation is this.


you upgrade the db.

Then you look at current company and see what the highest ILE. "Entry no." is.

Then you renumber the ILE in the upgraded db plus ILE "entry No." in current company.
Then use a dataport to load import directly into sub ledger tables.

You would have to do this for all the tables linked to ILE.

You could do the renumbering part of import as you are importing the ILE, just add some number.

Srivas

I think I would go with not using the toolkit as in this situation it doesn't look like I can use toolkit.
for dumping item ledger entries to Item Journal, as there would be lot of closed entries so for closed entries
I will pick the quantity from Item ledger entry but then after posting all these closed entries through item journal how would I do the application. All these entries will remain open. The application method is manual on most of the vendors/customers.

Item Journal line <<=== Item ledger entry
Entry Type == Entry Type
Document No. == document No.
quantity == quantity
location == location
Unit Cost == unit cost [from Item card]
Unit price == Unit price [from item card]

Thanks

ara3n

One issue that you will run into is this. Some Inbound entries will have different cost on one day and another a couple of days later if for example they get a freight charge. Or the user reevaluates the entry.

Also Application happens automatically when you post the journals, and you have to modify the application in nav.

I don't know how you are going to handle transfers.

vijay_g

ara3n wrote:

I don't know how you are going to handle transfers.

There should not be any problem with transfer except only open transfers that have been shipped but not received.

ara3n

Depends on costing method it matters.

Srivas

I managed to export item ledger entries and have loaded the item journal in NAV 2009 database.
As said, I didn't find many open transfers.

I noticed that except for entry type = sale, it is ok to just put unit amount (item journal) = Cost Amount (actual) of item ledger entry. For Sale, I need to put Unit cost (item journal) = cost per unit (from value entry).

One more glitch I am having that is it correct to copy cost amount or sales amount (actual) from item ledger entry to item journal. Or I should copy the amount from related value entry to unit amount field in item journal.

Thanks

ara3n

The fields in ILE are flowfields. If an ILE has more than one value entry with different posting date, then your aging will not be 100% correct but it will be close enough.