Microsoft Dynamics NAV (Archived)

ILE Replicate to store server

(0) Share

Report

Posted on by AbduTeeyech

428

Hi,

We are maintaining purchases and inventory in HO Server.

I need to replicate the ILE from HO to stores.

NAV is not generating any 'actions' as of now for ILE insert, and there is NO replication counter field in the ILE.

I thing there is a setup where I can chose to create action on ILE insert.

Is there any way?

Abdul.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report

Do you mean to say you want to transfer inventory from ho to store ?

Is it LS retail ?

Was this reply helpful? Yes No
Verified answer

Rashed 3,765 on at

Like (2)

Report

I've setup replicate for ILE. You need to setup the subjob replication type as normal instead of by Action. Filter it to only replicate Open entries and filter by distribution location = Location code.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (1)

Report

Abdul Rahman T H ,

totally Agreed with Ahmed Amini, you can make your solution through this

Was this reply helpful? Yes No
Preben Borg 80 on at

Like (0)

Report

It sounds interesting - what will happen to ILE's in the store when the entries are closed at HO? Or have I missed some of the intention behind this?

Was this reply helpful? Yes No
Verified answer

Preben Borg 80 on at

Like (1)

Report

You will have to create a new subjob (normal job) with replication counter on entry no. and may by as Ahmed Amini mentions filter on distribution location to prevent you from having all ILE's for all locations in all stores (huge amount of data) - but be aware of conflicting entry numbers if you have local posting in the stores.

Was this reply helpful? Yes No
AbduTeeyech 428 on at

Like (0)

Report

Thanks Amol, Amini, Maneesha, Preben.

So, I have 2 options here. either by 'Open' field or by 'Entry No.' filed as suggested by MR.Preben.

I think, Preben's suggestion would be more matching for me as we have huge amount of items, those still remains as 'open'.

Let me try creating a subjob by setting entry number as replication counter.

And, Any body know how to replicate using the 'Last Date Modified' field? how to put it as filter in subjob , say 3 days before ?

Thanks again,

Abdul.

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (1)

Report

You don't need to set replication counter. Set the replication to to update-add-delete.

This way the new set of item ledger will replicate to the store and replace them. Assuming they don't do statement posting at the store.

Was this reply helpful? Yes No
AbduTeeyech 428 on at

Like (0)

Report

Thank you all for the suggestions :)

I have gone as suggested by MR.Preben... Now ILE is replicating based on entry number as the replication counter, there by the data transfer rate is less.

Thanks again.. its done.

Was this reply helpful? Yes No