Credit memo is doing wrong
hansika
Member Posts: 373
CREATED A NEW ITEM .
I purchase that item .
Date = 31/01/09
Qty = 100
Rate = 1000 Here i just received only , I did not create Invoice
I have one ledger entry only
so Invenotry stock = 100 In item card
I sold that item
Date = 05/02/09( DD/MM/YY)
Qty = 100
Rate = 2000 I created SHIP & INVOICE
So INventory = 0 In item card
Now i received INvoice On 06/02/09.
I created the Invoice acutal Direct unit cost = 15 /- ( but i entered the as 10 )
So based on this Line amount is wrong,
Excise amount is wrong
Vat amount is wrong.
By mistake i post that one so all tables effectd Like G/L table, Customer ledger, Excise entry, Detail tax entry.
So now i realized that posted wrong amount .
Now i want reverse that one .
So in many forums Experts told if u posted the wrong amount use Credit memo to reverse that transactions.
So now i created that credit memo and posted that one.
So all tables reversed .
Here system reversed that Item ledger entry also
so In inventory field = - 100 In item card after i post the credit memo.
So it is totally wrong . I think system should not reverse that inventory transaction.
Now what is the solution to correct that credit memo.
I purchase that item .
Date = 31/01/09
Qty = 100
Rate = 1000 Here i just received only , I did not create Invoice
I have one ledger entry only
so Invenotry stock = 100 In item card
I sold that item
Date = 05/02/09( DD/MM/YY)
Qty = 100
Rate = 2000 I created SHIP & INVOICE
So INventory = 0 In item card
Now i received INvoice On 06/02/09.
I created the Invoice acutal Direct unit cost = 15 /- ( but i entered the as 10 )
So based on this Line amount is wrong,
Excise amount is wrong
Vat amount is wrong.
By mistake i post that one so all tables effectd Like G/L table, Customer ledger, Excise entry, Detail tax entry.
So now i realized that posted wrong amount .
Now i want reverse that one .
So in many forums Experts told if u posted the wrong amount use Credit memo to reverse that transactions.
So now i created that credit memo and posted that one.
So all tables reversed .
Here system reversed that Item ledger entry also
so In inventory field = - 100 In item card after i post the credit memo.
So it is totally wrong . I think system should not reverse that inventory transaction.
Now what is the solution to correct that credit memo.
hansika
0
Comments
-
Create a new purchase invoice and post it using the correct data.0
-
Well you have only done half the job.

Post the correct purchase invoice and see what the inventory does then!The art of teaching is clarity and the art of learning is to listen0 -
Hi,
Or if you want to post a credit memo with having an impact on the stock turn off the P&P setup "Return Shipment on Credit"0 -
I wonder this will have an impact as ILE will be created. The only difference it makes is that it will not create a separate document for shipment.SD-JR wrote:Hi,
Or if you want to post a credit memo with having an impact on the stock turn off the P&P setup "Return Shipment on Credit"CA Sandeep Singla
http://ssdynamics.co.in0 -
hansika wrote:So it is totally wrong . I think system should not reverse that inventory transaction.
Now what is the solution to correct that credit memo.
You might require to block the posting (you need to customize) but it is not a standard requirement so not provided in the database.
Why will a accountant reverse a wrongly posted purchase invoice and not post the correct invoice???? The steps needs to be completed before you start looking at the results in the item ledger.CA Sandeep Singla
http://ssdynamics.co.in0 -
0
-
Intersting that the system is doing nothing wrong and the business process needs reviewing or for another reason?
The art of teaching is clarity and the art of learning is to listen0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 324 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