Sales Profitability

jacky10
Member Posts: 30
hi
consider this scenario...
A Sales Order is raised for an Item X.. It is new, so the average cost is obviously zero.
based on that requirement, the purchase department raises a PO and SRV is made but not invoiced due to the delay in getting the invoice from suppliers..
now by mistake if that sales order is executed (i.e Shippd and Invoiced) my sales profitability shows 100% because the cost at that time of SO creation was zero..
now how to solve this issue?... wud appreciate ur guidance....
consider this scenario...
A Sales Order is raised for an Item X.. It is new, so the average cost is obviously zero.
based on that requirement, the purchase department raises a PO and SRV is made but not invoiced due to the delay in getting the invoice from suppliers..
now by mistake if that sales order is executed (i.e Shippd and Invoiced) my sales profitability shows 100% because the cost at that time of SO creation was zero..
now how to solve this issue?... wud appreciate ur guidance....
0
Comments
-
Use expected cost posting and put in a cost around the cost you will post. It is not really an issue as the costs flow through, but you need to control your process.The art of teaching is clarity and the art of learning is to listen0
-
When the purchase receipt is posted, you'll get the expected cost when you drill down to the item ledger and value entry.
This is of course after you run the Adjust Cost - Item Entries process.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
agreed... but the Sales Order is Booked before the SRV or Purchase Invoice is made.. so the cost in SO is zero...0
-
Because you have set the system to do this, if you had not had a zero cost on the item it would have taken the cost specified as expected.The art of teaching is clarity and the art of learning is to listen0
-
You will always get this problem when using the costing method GIGO :shock: . You need to change to a different costing methodDavid Singleton0
-
jacky10 wrote:agreed... but the Sales Order is Booked before the SRV or Purchase Invoice is made.. so the cost in SO is zero...
The problem has been discussed on this forums before. There has been a lot of responses to your question. Try seaching.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
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