Post inventory Cost

moichinoi
Member Posts: 41
Hi ,
I going to start a client with Nav.
In the past, my client have done his inventory cost ledger in his old system with the equivalent of normal General Journal.
I have imported all his ledger entries , inluding items entries, in the new nav application.
I would like to use the Navision function : Post inventory Cost
My problem is that Nav Will calculate with all the history of item ledger imported, and propose to post inventory cost based on all the entries, BUT, my client already have posted manually the inventory cost for the past periode.
Is there a good practice to ensure that this functionnality will propose at once the good ledger without include all already post manually ?
Thx a lot.
I going to start a client with Nav.
In the past, my client have done his inventory cost ledger in his old system with the equivalent of normal General Journal.
I have imported all his ledger entries , inluding items entries, in the new nav application.
I would like to use the Navision function : Post inventory Cost
My problem is that Nav Will calculate with all the history of item ledger imported, and propose to post inventory cost based on all the entries, BUT, my client already have posted manually the inventory cost for the past periode.
Is there a good practice to ensure that this functionnality will propose at once the good ledger without include all already post manually ?
Thx a lot.
0
Answers
-
I think if i have understood your client has, for example, in juni 500 u 10.000 $ and a mean cost of 20$. I think that u only have to add that value on Nav if u are worried about accounting rules.
U have to think that they are a mean and the result of 250 u for 20.000 and 250 u for 5.000 adding to the new entries is the same.
Example:
500 unds 20$ mean in juni
200 unds 10$ purchased in october
Inventory cost: 71,42
100 unds 23$
200 unds 16$
200 unds 22,5$
In october 200u 10$ purchased
Inventory cost 71,42Giving thanks is always wellcome0 -
Can you elaborate on "import all his ledger entries"?
Did you import directly into the ledger table?
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
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