Sales Report

Navi_Learner
Member Posts: 356
I created a Customer Sales Report, but when I retrieve the report, one of the item whose quantity are negative(-200), but the contribution margin are positive(+200). I create the report based on three tables, Customer, Value Entry, Cus. Ledger Entry. Here is part of my code. Can any expert find the bugs? Thanks!
Value Entry - OnPreDataItem()
CurrReport.CREATETOTALS("Invoiced Quantity","Sales Amount (Actual)",Profit,"Discount Amount");
SETFILTER("Invoiced Quantity",'<>0');
Value Entry - OnAfterGetRecord()
Profit := "Sales Amount (Actual)" + "Cost Amount (Actual)";
"Discount Amount" := -"Discount Amount";
Res. Ledger Entry - OnAfterGetRecord()
TotalSales := TotalSales + -"Res. Ledger Entry"."Total Price";
ResourceProfit := (-"Res. Ledger Entry"."Total Price") - (-"Res. Ledger Entry"."Total Cost");
ContribMargin := ContribMargin + (-"Res. Ledger Entry"."Total Price") - (-"Res. Ledger Entry"."Total Cost");
Customer, Footer (8) - OnPreSection()
"CalcProf%"(("Value Entry"."Sales Amount (Actual)" + -"Res. Ledger Entry"."Total Price"),(Profit + ResourceProfit));
Value Entry - OnPreDataItem()
CurrReport.CREATETOTALS("Invoiced Quantity","Sales Amount (Actual)",Profit,"Discount Amount");
SETFILTER("Invoiced Quantity",'<>0');
Value Entry - OnAfterGetRecord()
Profit := "Sales Amount (Actual)" + "Cost Amount (Actual)";
"Discount Amount" := -"Discount Amount";
Res. Ledger Entry - OnAfterGetRecord()
TotalSales := TotalSales + -"Res. Ledger Entry"."Total Price";
ResourceProfit := (-"Res. Ledger Entry"."Total Price") - (-"Res. Ledger Entry"."Total Cost");
ContribMargin := ContribMargin + (-"Res. Ledger Entry"."Total Price") - (-"Res. Ledger Entry"."Total Cost");
Customer, Footer (8) - OnPreSection()
"CalcProf%"(("Value Entry"."Sales Amount (Actual)" + -"Res. Ledger Entry"."Total Price"),(Profit + ResourceProfit));
0
Comments
-
for that item find the filter the records, and manually add them up and see if you get the same result. If yes, then the report works correctly. If not, then you have a bug in report.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