Creating Replication counter field

fahd
Member Posts: 226
Dear Experts,
We are using NAV 5 SP1 along with LS Retail 5. We have issue updating Prices stores
The jobs are being pulled from stores using scheduler server.
I have tried by action method and even tried normal method by keeping the filter as "Starting date" ="W" and "T" which works on today's date. Which i beleive updates the price in stores if it is updated in today's date.
But records are most of the times skipped and does not update and even some of them are updated properly.
Basically both these methods does not seem to be stable.
I wanted to have Replication counter field in Sales Price table so whenever new record is added in the table the replication counter should be updated and same is updated in stores.
I believe some coding needs to be done in this regards.
Please advise.
We are using NAV 5 SP1 along with LS Retail 5. We have issue updating Prices stores
The jobs are being pulled from stores using scheduler server.
I have tried by action method and even tried normal method by keeping the filter as "Starting date" ="W" and "T" which works on today's date. Which i beleive updates the price in stores if it is updated in today's date.
But records are most of the times skipped and does not update and even some of them are updated properly.
Basically both these methods does not seem to be stable.
I wanted to have Replication counter field in Sales Price table so whenever new record is added in the table the replication counter should be updated and same is updated in stores.
I believe some coding needs to be done in this regards.
Please advise.
0
Answers
-
Your code is very general so answer will be general at all.
- If you loop records, you should never modify value included in current key
- You have to log changes during develop to find gaps0 -
Hi Lubost,
Thanks for your reply.
However, I just have basic knowledge of coding.
Could you please elaborate it a bit further..
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions