Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Sales Amt. (Actual) not updated in Item Analysis View Entry
Nagi
Member Posts: 151
Hello NAV experts,
We have a customer that uses the sales analysis report (Sales & Marketing \ Analysis & Reporting \ Analysis Reports) and compares the result of this view with general ledger entries. The customer noticed that there were discrepancies between the sales analysis report and the general ledger entries. At first I thought the reason was simply because the sales analysis report uses item analysis view entries as a basis and it's likely that these entries can have a different date compared with the corresponding ledger entries (this happens if you don't ship and invoice on the same date). This explains some of the discrepancies, but when digging further we noticed that a lot of the entries in item analysis view wasn't updated with "Sales Amount (Actual)". My question is this; Does anybody know why this field isn't updated correctly? I have tested this and if I ship an order the item analysis view entries will have "Sales Amount (Expected)" equal to amount on sales order, but when I later invoice the sales order then the field "Sales Amount (Expected)" is updated correctly. Still, the customer manages to end up with entries that are not updated correctly. I would appreciate any help on this issue.
We have a customer that uses the sales analysis report (Sales & Marketing \ Analysis & Reporting \ Analysis Reports) and compares the result of this view with general ledger entries. The customer noticed that there were discrepancies between the sales analysis report and the general ledger entries. At first I thought the reason was simply because the sales analysis report uses item analysis view entries as a basis and it's likely that these entries can have a different date compared with the corresponding ledger entries (this happens if you don't ship and invoice on the same date). This explains some of the discrepancies, but when digging further we noticed that a lot of the entries in item analysis view wasn't updated with "Sales Amount (Actual)". My question is this; Does anybody know why this field isn't updated correctly? I have tested this and if I ship an order the item analysis view entries will have "Sales Amount (Expected)" equal to amount on sales order, but when I later invoice the sales order then the field "Sales Amount (Expected)" is updated correctly. Still, the customer manages to end up with entries that are not updated correctly. I would appreciate any help on this issue.
0