Different Values between Item ledger Entries and Value Entry

Martin_Förster
Member Posts: 55
Salute togehter,
one of my customers has got a strainght behavior in the Cost Adjustment and i really don't KNow what to do :-(
Maybe somebody can help me..
One Example is show in the attachment.
In this case the Customer sales 25 Pcs. (Shipping&Invoicing), If you look into the Value Entires, it seems that this transaction create an Invoice of 50 Pcs????
Under the first Line (Ledger Entry Item) is an second Entry which looks like an cancellation...
I will be very happy if somebody understand my problem.
regards
Martin
PS: Sorry my english is a bit rusty :-)
one of my customers has got a strainght behavior in the Cost Adjustment and i really don't KNow what to do :-(
Maybe somebody can help me..
One Example is show in the attachment.
In this case the Customer sales 25 Pcs. (Shipping&Invoicing), If you look into the Value Entires, it seems that this transaction create an Invoice of 50 Pcs????
Under the first Line (Ledger Entry Item) is an second Entry which looks like an cancellation...
I will be very happy if somebody understand my problem.
regards
Martin
PS: Sorry my english is a bit rusty :-)
0
Comments
-
what version of NAV are you on 4 or 5?0
-
Version 3.70A :-(0
-
It looks like somebody changed the UOM on the sales line through code or this is a modification.
I suggest to fix the data and move on. I suggest to also write a report to see if there are others, if they are then it's a coding mistake, add some code to cu 22 to catch it and prevent future entries from occurring.0 -
I had a similar issue once due to an upgrade. The inventory value was totally screwed up due to an non-upgradeable item costing addon used in 2.x. A two-year old phys. inventory was then used as the new starting point , and all item ledger entries were reposted using item journals. This worked well to fix the inventory value, but there were some orders that had been shipped but not yet invoiced. When these were invoiced lated, the invoiced qty. was twice the qty in the item ledger entries.PS: Sorry my english is a bit rusty :-)Kai Kowalewski0
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