Inventory Valuation having quantities and values not in G/L

mujunijohnUG
Member Posts: 1
Greetings,
I have a client running Business Central Spring 2019. The system is set up to run a batch job that updates Item Cost Entries and one that posts inventory cost to G/L in the night and these two are working fine. The issue I am facing is that the Inventory Valuation has items that have quantities and values that are not there in the Item Ledger Entries. As a result, the Inventory Valuation is not reconciling with the General Ledger. Actually, when you also run Item Availability by Location, the quantities are not there for the specific items. If anyone has faced this problem before, kindly post your answers.
I have a client running Business Central Spring 2019. The system is set up to run a batch job that updates Item Cost Entries and one that posts inventory cost to G/L in the night and these two are working fine. The issue I am facing is that the Inventory Valuation has items that have quantities and values that are not there in the Item Ledger Entries. As a result, the Inventory Valuation is not reconciling with the General Ledger. Actually, when you also run Item Availability by Location, the quantities are not there for the specific items. If anyone has faced this problem before, kindly post your answers.
0
Answers
-
The value is managed in value entries not in item ledger entries. Also in value entries you have cost posted to G/L, expected cost posted to G/L that indicates if those are posted in general ledger (that was the second report do).
My best guess it's that you're avoiding some accounts in general ledger that they've entries or that the report haven't run for all the dates.0 -
[Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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