Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Automating Adjust Cost (Web Service)
kript
Member Posts: 3
Hi All,
maybe someone can shed some light on the problem I'm having at the moment.
I need to automate the adjust cost using a scheduling table. The schedule table will have the items that needs to be adjusted on a specific day.
Slow moving items will be adjusted during the week and the fast moving items will be adjusted over the weekend when there is little or no processing taking place.
Now, I can execute the process through the web service being called through a SQL job without a problem.
The problem though is that when an specific item adjust cost fails for whatever reason, an error field on the schedule table needs to be updated with the relevant error message returned from NAV. On the next run this item will be excluded until the error has been fixed.
If the adjust cost completed without any errors, I update a "success" field, excluding the item from the next run as well.
I have tried breaking the adjust cost, so that I can get the error message returned without any luck. I cannot go on the assumption that the adjust cost will be 100% correct every time.
While trying to break the adjust cost, by manually deleting location values, global dimension values from the Value Entry table, the adjust cost runs through and marks the Cost is Adjusted for the specific item in the Avg. Cost Adjmt. Entry Point table as true. With this happening, the adjust cost for the item will not run again for these entries.
I might be going about this the wrong way and would appreciate some help or guidance on this issue.
Current NAV being used is : NAV 2009 on Windows 2003 with SQL 2008.
Many thanks
Morne
maybe someone can shed some light on the problem I'm having at the moment.
I need to automate the adjust cost using a scheduling table. The schedule table will have the items that needs to be adjusted on a specific day.
Slow moving items will be adjusted during the week and the fast moving items will be adjusted over the weekend when there is little or no processing taking place.
Now, I can execute the process through the web service being called through a SQL job without a problem.
The problem though is that when an specific item adjust cost fails for whatever reason, an error field on the schedule table needs to be updated with the relevant error message returned from NAV. On the next run this item will be excluded until the error has been fixed.
If the adjust cost completed without any errors, I update a "success" field, excluding the item from the next run as well.
I have tried breaking the adjust cost, so that I can get the error message returned without any luck. I cannot go on the assumption that the adjust cost will be 100% correct every time.
While trying to break the adjust cost, by manually deleting location values, global dimension values from the Value Entry table, the adjust cost runs through and marks the Cost is Adjusted for the specific item in the Avg. Cost Adjmt. Entry Point table as true. With this happening, the adjust cost for the item will not run again for these entries.
I might be going about this the wrong way and would appreciate some help or guidance on this issue.
Current NAV being used is : NAV 2009 on Windows 2003 with SQL 2008.
Many thanks
Morne
0