discrepancy in posting in G/L entries
success_seeker
Member Posts: 3
hey guys,
I am using NAV 5.0 SP1,
I am facing a problem in the G/L account entries when i post a sales order or a purchase order i get some discrepancy in the ledger entries.
in the amount field sometimes i get : 0.01, -0.02,.... so on so forth
it's affecting my overall balance.
Plz i need advice
I am using NAV 5.0 SP1,
I am facing a problem in the G/L account entries when i post a sales order or a purchase order i get some discrepancy in the ledger entries.
in the amount field sometimes i get : 0.01, -0.02,.... so on so forth
it's affecting my overall balance.
Plz i need advice
Mak,
Lebanon
Lebanon
0
Comments
-
Your query is not too clear but u can check this
Looking at these figures it seems these are entries generated by rounding.
Rounding means : For example ur invoice amount is 99.96 and u don't want to carry cents in your invoice then u can have them posted in rounding accounts. In this case your expense a/c will get posted by 99.96, Party will get credit of 100 and rounding account will have .04.
To check this is happening or not go to ur vendor or customer posting groups and see invoice rounding a/c and see if any entries are posted to that account. If that account has all these entries then this means u are using this functionality. or check any of ur posted documents an extra line with G/L account would have been created by system automatically with the rounding amount.Kapil Khanna0 -
listen,
when we perform a sales order or a purchase order along with automatic cost posting checked (in the inventory setup) then we double check the chart of account (total sales account) we found out some lines with amount 0.01 or -0.01 or 0.02 .....
so when we have millions of transactions a day the final balance will differ clearly for the current and tangible transactions.....
thanks in advance guys...Mak,
Lebanon0
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
- 333 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