Amount (LCY)/Balance in Vendor/Cust. table + ledger entries

merana
Member Posts: 41
Hello everyone,
We are using Navision 3.60 and I noticed some strange differences in table Vendor/Customer between Balance and Balance (LCY) and Amount/Amount(LCY) in Cust./Vendor ledger entries.
They are both reffered to the samae detailed ledger entries, BUT:
In VEndor/Custmer there is table filter for field balance(LCY):
Vendor No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Currency Code=FIELD(Currency Filter)
and in ven./Cust. ledger entries for field amount(LCY) there is table filter:
Vendor Ledger Entry No.=FIELD(Entry No.),Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'),Posting Date=FIELD(Date Filter) - Filter exits on ENtry type!!! and it excludes some types like "Correction of remaining amount", and that's why on vendor/Customer card there is difference between what i shown in the card and what you see on the list.
Also detailed Trial Balance report will show different amounts from card if certain types of entries occurs
How you solved this? Is this bug, or make any sense???? What abou different version of Navision?
Please answer.
We are using Navision 3.60 and I noticed some strange differences in table Vendor/Customer between Balance and Balance (LCY) and Amount/Amount(LCY) in Cust./Vendor ledger entries.
They are both reffered to the samae detailed ledger entries, BUT:
In VEndor/Custmer there is table filter for field balance(LCY):
Vendor No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Currency Code=FIELD(Currency Filter)
and in ven./Cust. ledger entries for field amount(LCY) there is table filter:
Vendor Ledger Entry No.=FIELD(Entry No.),Entry Type=FILTER(Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'),Posting Date=FIELD(Date Filter) - Filter exits on ENtry type!!! and it excludes some types like "Correction of remaining amount", and that's why on vendor/Customer card there is difference between what i shown in the card and what you see on the list.
Also detailed Trial Balance report will show different amounts from card if certain types of entries occurs
How you solved this? Is this bug, or make any sense???? What abou different version of Navision?
Please answer.
0
Comments
-
What is your last hotfix???
I found this error for example for HF 24:Errors fixed
A1) Incorrect Flow field Definition for the Balance Due fields in the Customer Table
Error
Because of an incorrect flow field definition you could get an incorrect value in Balance Due and Balance Due (LCY) fields.
This has been corrected.
Table 4 Currency
Table 18 Customer
Table 23 Vendor
Table 98 General Ledger Setup
Service System reference: GB-647-749-EEJL
A2) Incorrect Total (LCY) Amount in the Vendor - Detail Trial Balance Report
Error
If the Vendor - Detail Trial Balance report was printed and adjustments of opening balances were included the Total (LCY) of all vendors was incorrect.
This has been corrected.
Report 104 Customer - Detail Trial Bal.
Report 304 Vendor - Detail Trial Balance
Service System reference: DE-417-463-KJK8
As you can see, there were some problems in 3.60 with some calculated fields...0 -
We used croation localized version.
These object are NAVW13.60,L3.05.
In the meantime besides differences between Amount in Ledger Entry tables and Balance in vendor/customer table, there are differences for Debit/Credit Amount in ledger entry table which create calcsums from detailed entry different from "Application". So finally it migh happened that Debit/Credit Amount is different from Amount in ledger Entry tables.
I don't know what's the purpose of this because it might happened that when you watch card you see one balance, and if you watch entries you can see different.
It seems the best to avoid using Amount/Amount (LCY) from ledger entry tables - best way is to go directly on detailed. entry table.0 -
Please, try to look for some object which have version like NAVW13.60.xx - the XX number is number of your last hotfix used (search for biggest number)...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