Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Change standard profit calculation in Navision 4.0 SP1
fiona_twomey
Member Posts: 20
Hi there,
I have been asked to change this calculation in a customer implementation to user Last Direct Cost to calculate the profit instead of Unit Cost.
Appart from change the calculation on the Item table is there anywhere else I should change it.
On this site there are 2 other areas I need to change it, i.e. Sales Prices screen as we have changed this to show profit and profit % and also codeunit Purch.-Post as we have changed this to update Last Direct Cost when goods are received. In Sales Prices screen I would need to ensure I change the profit calculation and in codeunit I would need to update profit when Last Direct Cost has been changed.
What I'm wondering, without going through all objects manually, is there anyway to ensure that profit is always re-calculated when Last Direct Cost or Unit Price is changed?? Or is it even necessary for me to investigate this?
Thanks,
Fiona
I have been asked to change this calculation in a customer implementation to user Last Direct Cost to calculate the profit instead of Unit Cost.
Appart from change the calculation on the Item table is there anywhere else I should change it.
On this site there are 2 other areas I need to change it, i.e. Sales Prices screen as we have changed this to show profit and profit % and also codeunit Purch.-Post as we have changed this to update Last Direct Cost when goods are received. In Sales Prices screen I would need to ensure I change the profit calculation and in codeunit I would need to update profit when Last Direct Cost has been changed.
What I'm wondering, without going through all objects manually, is there anyway to ensure that profit is always re-calculated when Last Direct Cost or Unit Price is changed?? Or is it even necessary for me to investigate this?
Thanks,
Fiona
0
Comments
If you open a posted sales invoice and F9 you get a calculation.
Should this change over time?
Generally, the profit is got from the posted entries by you stating in a report or form what you want, the last cost is a moving target so no report can be suggested as accurate.
In terms of what the user may see in a sales entry screen for working out the minimum margin allowed, it is a reasonable thing to have the most recent cost used, but what if there is a PO with a new and as yet unposted higher or lower cost?
To find every place where the calculation may be could be time consuming but you could try exporting all objects to .txt and with something like Textpad, do a search to find all the code that may be relevent.