IF you are using Average Cost and IF your Average Cost Calc. Type is Item & Location & Variant, when you upgrade to 5.0. The cost calculation type will be set to ITEM.
At this point, DO NOT RUN ADJUST COST!!! It will calculate your average by ITEM irregardless if you changed the Average Cost Calc. Type to item & location.
This is a problem in the Avg. Cost Adjmt. Entry Point table. I'm currently figuring out a solution for this and will keep you guys posted.
Ok.. I've figured the proper solution for situations like this.
This will only apply if the following is true for your client:
1. They're upgrading from 3.x or 4.x to 5.0
2. They're using average cost
3. They have the Avg. Cost Calc type to Item&Variant&Locatoin
I've written something that will reset the Avg. Cost Adjmt. Entry Point and the Accounting Period (yes, accounting period) table.
I'll put up the code on the download section if anyone is interested.
Answers
thanks! I will do this translation in a few days, i'll keep an eye on it!
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Hi, did you notice this problem when you did the upgrade?
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
IF you are using Average Cost and IF your Average Cost Calc. Type is Item & Location & Variant, when you upgrade to 5.0. The cost calculation type will be set to ITEM.
At this point, DO NOT RUN ADJUST COST!!! It will calculate your average by ITEM irregardless if you changed the Average Cost Calc. Type to item & location.
This is a problem in the Avg. Cost Adjmt. Entry Point table. I'm currently figuring out a solution for this and will keep you guys posted.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
This will only apply if the following is true for your client:
1. They're upgrading from 3.x or 4.x to 5.0
2. They're using average cost
3. They have the Avg. Cost Calc type to Item&Variant&Locatoin
I've written something that will reset the Avg. Cost Adjmt. Entry Point and the Accounting Period (yes, accounting period) table.
I'll put up the code on the download section if anyone is interested.
Hmm... Maybe I should report this to Microsoft?
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Cheer,
teckpoh
PartnerSource ID required.
Rgds,
Jon.
Jon.