Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Sales Invoice Line/ Sales Credit Mem/ Customer Ledger Entrie
nikeman77
Member Posts: 517
Hi guys,
I would like to compare the sales results by Sales Invoice Line for WY2010 and 2011
with Sales Credit Memo Line WY2010 and 2011 to get better sales results.
To triple confirm I uses Customer Ledger entries filtered by WY 2010 and 2011, Document Type: Invoice/ Sales.
Field to compared Sales Invoice Line >> Line Amount divide by Currency Factor to retrieve values in LCY
Field to compared Sales Credit Memo Line >> Line Amount divide by Currency Factor to retrieve values in LCY
Field to compared Customer Ledger entries>> Sales (LCY)
The value doesnt tally when I use Sales Invoice Line minus Sales Credit Memo Line for WY 2010 as compared
to Customer Ledger Entries.Invoice document - Customer Ledger Entries.Credit Memo document for WY 2010
Any thing I misses to cause the inaccuracy?
I would like to compare the sales results by Sales Invoice Line for WY2010 and 2011
with Sales Credit Memo Line WY2010 and 2011 to get better sales results.
To triple confirm I uses Customer Ledger entries filtered by WY 2010 and 2011, Document Type: Invoice/ Sales.
Field to compared Sales Invoice Line >> Line Amount divide by Currency Factor to retrieve values in LCY
Field to compared Sales Credit Memo Line >> Line Amount divide by Currency Factor to retrieve values in LCY
Field to compared Customer Ledger entries>> Sales (LCY)
The value doesnt tally when I use Sales Invoice Line minus Sales Credit Memo Line for WY 2010 as compared
to Customer Ledger Entries.Invoice document - Customer Ledger Entries.Credit Memo document for WY 2010
Any thing I misses to cause the inaccuracy?
0