How to calculate Sales from 'Item Ledger Entry' table

donit
Member Posts: 24
Hello,
Could somebody clarify how to calculate Sales starting from the 'Item Ledger Table' to e.g. provide proper Sales Amounts and Qty per Customer and Item for a period.
I could see that criteria could be as 'Entry Type' = 'Sale'. Would it be enough or I'd need to add e.g. the 'Source Type' = 'Customer'. How about the 'Document Type' as 'Sales Shipment', 'Sales Invoice', 'Sales Return', etc. - if it should be added too or a one criteria as 'Entry Type' = 'Sale' with SUM('Sales Amount (Actual)') could be enough and it would include everything needed as 'Sales Credit Memos', etc., to calculate Sales.
The Columns to link to other tables seems as should not be a problem as to Item it would be 'Item No.', 'Source No.' - Customer, 'Document No.' - 'Sales Invoice No.'
I would go with 'Sales Invoice Header' and '... Line' and 'Sales Cr. Memo Header' and '... Line' to get Sales but requirements are to go through 'Item Ledger Entries'.
Thanks
Could somebody clarify how to calculate Sales starting from the 'Item Ledger Table' to e.g. provide proper Sales Amounts and Qty per Customer and Item for a period.
I could see that criteria could be as 'Entry Type' = 'Sale'. Would it be enough or I'd need to add e.g. the 'Source Type' = 'Customer'. How about the 'Document Type' as 'Sales Shipment', 'Sales Invoice', 'Sales Return', etc. - if it should be added too or a one criteria as 'Entry Type' = 'Sale' with SUM('Sales Amount (Actual)') could be enough and it would include everything needed as 'Sales Credit Memos', etc., to calculate Sales.
The Columns to link to other tables seems as should not be a problem as to Item it would be 'Item No.', 'Source No.' - Customer, 'Document No.' - 'Sales Invoice No.'
I would go with 'Sales Invoice Header' and '... Line' and 'Sales Cr. Memo Header' and '... Line' to get Sales but requirements are to go through 'Item Ledger Entries'.
Thanks
0
Best Answer
-
yes, it is enough - 'Entry Type' = 'Sale'
5
Answers
-
I did take a look at FlowFields and it seems as the 'Entry Type' = 'Sale' criteria could be enough for Sales calculation. Otherwise, please advise.0
-
yes, it is enough - 'Entry Type' = 'Sale'
5 -
Thank you, ChuChu, for confirming it.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