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
- 302 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Purchase Credit Memo Charge Makes Average Cost Weird
alphonse
Member Posts: 13
Hi,
So I have this kind of scenario. From vendor, we got price protection/rebate. If the price decrease, then we can get rebate based on our existing stock. Let say we purchase 10.000 KG, then we sold 7500 KG, so our stock is 2500 KG. Then the price drop 100 $ per KG, so we will get rebate = 2500 KG x 100 $ = 250.000 $
The item is average by item, by day.
I try this in Cronus, NAV 2018 CU 14
- Create New Item, costing method : average
- New Purchase Order, 10.000 KG, price 1100 per KG, post the receive and invoice
- New Sales Order, 7500 KG, price 1500 per KG, post the shipment and invoice
- Transfer Order the 2500 KG left from existing location to a new location, post ship and receive
- New Purchase Credit Memo, type = Charge, Amount = 250.000, and I charge it to the Posted Transfer Received. Post the Credit Memo
- Run the adjust cost
The cost per KG in the on hand stock is correct, its decreased from 1100$ to 1000$, but the Cost in the Sales entries is also decreased, from 1100$ to 1075$.
The Question is, why the cost in the Sales Entries is also decreased?
I've tried using revaluation journal, instead of Purchase Credit Memo, and it gives the same result.
Thanks
Regards,
Alphonsus Eka
So I have this kind of scenario. From vendor, we got price protection/rebate. If the price decrease, then we can get rebate based on our existing stock. Let say we purchase 10.000 KG, then we sold 7500 KG, so our stock is 2500 KG. Then the price drop 100 $ per KG, so we will get rebate = 2500 KG x 100 $ = 250.000 $
The item is average by item, by day.
I try this in Cronus, NAV 2018 CU 14
- Create New Item, costing method : average
- New Purchase Order, 10.000 KG, price 1100 per KG, post the receive and invoice
- New Sales Order, 7500 KG, price 1500 per KG, post the shipment and invoice
- Transfer Order the 2500 KG left from existing location to a new location, post ship and receive
- New Purchase Credit Memo, type = Charge, Amount = 250.000, and I charge it to the Posted Transfer Received. Post the Credit Memo
- Run the adjust cost
The cost per KG in the on hand stock is correct, its decreased from 1100$ to 1000$, but the Cost in the Sales entries is also decreased, from 1100$ to 1075$.
The Question is, why the cost in the Sales Entries is also decreased?
I've tried using revaluation journal, instead of Purchase Credit Memo, and it gives the same result.
Thanks
Regards,
Alphonsus Eka
0
Answers
http://www.dynamicsnavconsultant.com/why-your-inventory-valuation-does-not-match-the-inventory-account-on-the-general-ledger/