Update Unit Cost on Sales Order
knm
Member Posts: 170
I'm currently testing NAV2009SP1, and I have question on how Unit Cost gets updated in Sales Order entry window.
When I make an Item Application on the Sales Order entry window, the Unit Cost field on the Sales Line Table gets updated, using the Cost of the linked Item Ledger Entry.
But, when I make an Item Reservation on the Sales Order entry window, the Unit Cost field does not get updated as it did on the "Item Application" situation. (After Posting the Sales, since the cost of sales is wrong, I need to run Adjust Cost utility so that the accurate cost is recorded in the system)
Is there any reason why the Unit Cost doesn't get updated on Item Reservation, and is there a setup which would allow the system to do so?
Please let me know.
Thank you!
When I make an Item Application on the Sales Order entry window, the Unit Cost field on the Sales Line Table gets updated, using the Cost of the linked Item Ledger Entry.
But, when I make an Item Reservation on the Sales Order entry window, the Unit Cost field does not get updated as it did on the "Item Application" situation. (After Posting the Sales, since the cost of sales is wrong, I need to run Adjust Cost utility so that the accurate cost is recorded in the system)
Is there any reason why the Unit Cost doesn't get updated on Item Reservation, and is there a setup which would allow the system to do so?
Please let me know.
Thank you!
0
Comments
-
Item reservation has nothing to do with costing. The items are still going out according to the costing method specified on the item card.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 -
But isn't it true that when Item Reservation is made, and Sales is posted, the Item Application will be established according to the Item Reservation entries?
For example, let's say that I have following Item Ledger Entries for Item A (using FIFO costing method).
Rcpt No. Entry No. QTY Unit Cost
000900 100 10 $10.00
000901 101 10 $20.00
000902 102 10 $30.00
On the Sales, I will make an Item Reservation Entry for "Rcpt No." 000901, and then post.
On the Item Application entry window, I will see that the newly registered Outbound Item ledger entry will be applied against "Entry No." 101. (if I didn't make any reservation entry then it would have been "Entry no." 100)
And I also see that after running the adjust cost utility, the posted Cost of sales is $20.00 instead of $10.00.
With above observations, since how item reservation updates Item Ledger Entry window is almost the same as Applying Item Entry in the Sales Order entry window, I though it would be also the same for Sales Order entry window to update the Unit Cost after applying the Item Reservation.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 329 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