Cost of Goods Returned

slmaluwa
Member Posts: 366
Hello
A small confusion arose today with regard to the cost of items returned from buyers and would like to share it with you all for opinion.
Company Policy: Average Costing
Average Cost Calc Type: Item & Location & Variant
Say, a customer who bought the items at a particular price returns the goods at later date (after 6 months). Now, the current price is much higher than the old price. We use credit memo to enter the information and manually alter the unit price to have the OLD price. All ok.
Now, the finance guys say that they want these items to be valued at the price it is returned. Since many of these items (now in bad shape) goes into re-production as a raw material. All these items are received and stored in a separate LOCATION.
How Navision treats cost of these items? If it is taking the general average cost, is there a way to make it consider the returned prices for costing?
TIA
A small confusion arose today with regard to the cost of items returned from buyers and would like to share it with you all for opinion.
Company Policy: Average Costing
Average Cost Calc Type: Item & Location & Variant
Say, a customer who bought the items at a particular price returns the goods at later date (after 6 months). Now, the current price is much higher than the old price. We use credit memo to enter the information and manually alter the unit price to have the OLD price. All ok.
Now, the finance guys say that they want these items to be valued at the price it is returned. Since many of these items (now in bad shape) goes into re-production as a raw material. All these items are received and stored in a separate LOCATION.
How Navision treats cost of these items? If it is taking the general average cost, is there a way to make it consider the returned prices for costing?
TIA
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
0
Comments
-
To set the returned cost to be the same as the shipped cost, ensure the Exact Cost Reversing is checked on on the S&R setup.
On the sales lines for the credit memos, ensure that the Applies-from Entry No. is set to the proper costing tier.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 -
hi Alex
This is something different.
I think my post was not clear. The client want to have price they are entering in credit memo to be considered for the cost of the items too.
is it a proper accounting way????"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."0 -
Whether or not it's proper accounting, it's up to the company's accountant to decide. But typically, this is not normal.
In any case, by setting the Unit Cost (LCY) field to be the same as Unit Price, it will achieve the cost of the return goods to be the same as the unit price being credited to the customer.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