Cost reversing mechanism for Sales Credit Memo

navuser1
Member Posts: 1,334
Hi,
I'm working in NAV 2013 R2 IN Database. I have a query on Inventory costing. The actual scenario is mentioned below.
On 31-10-15, I have purchased(with invoiced) an ITEM (ITM001) with some value.The Item has "FIFO" costing method in Item Master.This inbound transaction has created Inventory accounting in the General Ledger. After that a Sales Invoice has been posted in the system on 31-10-15. This outbound transaction is applied on that Purchase transaction and it creates the necessary Inventory accounting in G/L table accordingly.
After few days later (on 22-01-16), user has raised a Sales Credit Memo to reverse the previous Sales transaction with proper accounting in the G/L. But it does not have any impact on Inventory accounting. The other accounting has happened nicely in the System (G/L Table) instead of actual cost reversing.
Few days back (on 26-02-16), user has post a Sales Order on that Item. But I've astonished to that this SO is applied on the Credit Memo.
Please find the screenshot for more.
My query is that why the Sales Credit memo transaction is not able to create the Inventory accounting in the system when the Automatic Cost Posting is ticked in the Inventory Setup Master and Adjust Cost batches have been executed in the system ?
Kindly reply.
I'm working in NAV 2013 R2 IN Database. I have a query on Inventory costing. The actual scenario is mentioned below.
On 31-10-15, I have purchased(with invoiced) an ITEM (ITM001) with some value.The Item has "FIFO" costing method in Item Master.This inbound transaction has created Inventory accounting in the General Ledger. After that a Sales Invoice has been posted in the system on 31-10-15. This outbound transaction is applied on that Purchase transaction and it creates the necessary Inventory accounting in G/L table accordingly.
After few days later (on 22-01-16), user has raised a Sales Credit Memo to reverse the previous Sales transaction with proper accounting in the G/L. But it does not have any impact on Inventory accounting. The other accounting has happened nicely in the System (G/L Table) instead of actual cost reversing.
Few days back (on 26-02-16), user has post a Sales Order on that Item. But I've astonished to that this SO is applied on the Credit Memo.

Please find the screenshot for more.
My query is that why the Sales Credit memo transaction is not able to create the Inventory accounting in the system when the Automatic Cost Posting is ticked in the Inventory Setup Master and Adjust Cost batches have been executed in the system ?
Kindly reply.
Now or Never
0
Answers
-
This type of question requires an expert team for the answer. We at MindQuad are one of the best and biggest team of NAV in Western India. MindQuad Solutions, is a Microsoft SPA Partner and have experience in providing support and ene-to-end implementation in various industry verticals.
Would request you to please post this question to our team member on pushpa.dasari@mindquad.inMindQuad Solutions Private Limited
www.mindquad.net0
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