Cost Posting to GL Issue

Rocky4u
Member Posts: 3
Hi,
Need help in finding the root cause of issue
Version : NAV 2009 R2
Problem Statement :
When User Posted Negative Inventory Adjustment in September last year the Cost of Adjustment was not completely posted to GL. Rather remaining Cost was posted in subsequent months until April 2015 By Adjust Cost- Item Entries Report. We have Inventory Setup as
Automatic Cost Posting : True
Expected Cost Posting to G/L : True
Automatic Cost Adjustment : Never (we run Adjust Cost- Item Entries Report daily )
Costing Method we use is Average.
Finance team needs the answer why the entire amount got posted to G/L at the time the Negative Adjustment was made and Even if Adjust Cost- Item Entries Report posted the remaining value why dint it post entire amount in its next run after the entry and why it kept posting these values in subsequent months.
Any help would be appreciated.
Thanks.
Need help in finding the root cause of issue
Version : NAV 2009 R2
Problem Statement :
When User Posted Negative Inventory Adjustment in September last year the Cost of Adjustment was not completely posted to GL. Rather remaining Cost was posted in subsequent months until April 2015 By Adjust Cost- Item Entries Report. We have Inventory Setup as
Automatic Cost Posting : True
Expected Cost Posting to G/L : True
Automatic Cost Adjustment : Never (we run Adjust Cost- Item Entries Report daily )
Costing Method we use is Average.
Finance team needs the answer why the entire amount got posted to G/L at the time the Negative Adjustment was made and Even if Adjust Cost- Item Entries Report posted the remaining value why dint it post entire amount in its next run after the entry and why it kept posting these values in subsequent months.
Any help would be appreciated.
Thanks.
0
Comments
-
Hi,
Did you do adjustments resulting into negative inventory? This would result in cost adjustements after you replenish your inventory, applying the received quantity to the outgoing entry
Please check your Item Application Entries. In which periodes have applications been created, and what was the posting date of those applicatons.
Further complications arise from closed periods, both inventory periods and general accounting periods and the posting allowed setting. and finally the averaging periode might add to the complexity.0 -
We never closed Inventory period.Hence Item adjust cost report was adjusting Values of entries in past.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