How to tell which itesm most need Adjust Cost
SteveKnott
Member Posts: 50
What is the best way to determine which items needs adjust cost.
I am wanting to run it in batches... least important in the week at night.. and most important on the weekend.. to deal with backlog.
Thinking "Completely Invoiced" on ILE -
"Cost is Adjusted" and "Completely invoiced" on "Inventory Adjmt_ Entry (Order)"\
But I have other items that have very low figures on the above that have long Adjust Cost Riuns... what else can I use to determine which items have the most work
Manufacturing + warehousing ...
Thanks
I am wanting to run it in batches... least important in the week at night.. and most important on the weekend.. to deal with backlog.
Thinking "Completely Invoiced" on ILE -
"Cost is Adjusted" and "Completely invoiced" on "Inventory Adjmt_ Entry (Order)"\
But I have other items that have very low figures on the above that have long Adjust Cost Riuns... what else can I use to determine which items have the most work
Manufacturing + warehousing ...
Thanks
0
Best Answer
-
Hello,
If I were to write something of this nature assuming average cost was involved. I would check something along the following lines:
When the Applied Cost to Adjust is flagged true on an Item Ledger determine, how far back the posting date is and the number of entries forward for that item. The further back and more entries will increase the number of loops or levels the average cost adjustment point must process.
Hopefully this helps you as no-one likes debugging the performance of this routine.
Cheers,
Life runs on code;5
Answers
-
Hello,
If I were to write something of this nature assuming average cost was involved. I would check something along the following lines:
When the Applied Cost to Adjust is flagged true on an Item Ledger determine, how far back the posting date is and the number of entries forward for that item. The further back and more entries will increase the number of loops or levels the average cost adjustment point must process.
Hopefully this helps you as no-one likes debugging the performance of this routine.
Cheers,
Life runs on code;5 -
Thanks... good suggestion.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 329 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
