Incorrect qty per unit measure with posting entry
kiyac
Member Posts: 118
Hi expert,
I would like to know the correction procedure for incorrect qty per unit measure and inbound and outbound has been made, which cause incorrect inbound qty (in base) and unit cost.
Item A, base UOM = PCS
Incorrect 1 BOX = 15pcs
Correct 1 Box = 18 pcs
1. User create PO with 10 box (1 box = 15 pcs), $ per box = 100
2. User create purchase receipt 4 box, ie ILE create with qty (base) = 60 pcs, unit cost (expected) = (4box * $100)/60 pcs)=6.67
[Correct figure should be, ILE create with qty (base) = 72 pcs, unit cost (expected) = (4box * $100)/72 pcs)=5.56]
3. User correct back the item UOM setting
4. Transfer has been done (with 1 Box = 18 pcs)
5. Inventory adjustment (positive) has been done with a incorrect unit cost (1 Box = 18 pcs)
Question :
How can I fix the data?
I would like to know the correction procedure for incorrect qty per unit measure and inbound and outbound has been made, which cause incorrect inbound qty (in base) and unit cost.
Item A, base UOM = PCS
Incorrect 1 BOX = 15pcs
Correct 1 Box = 18 pcs
1. User create PO with 10 box (1 box = 15 pcs), $ per box = 100
2. User create purchase receipt 4 box, ie ILE create with qty (base) = 60 pcs, unit cost (expected) = (4box * $100)/60 pcs)=6.67
[Correct figure should be, ILE create with qty (base) = 72 pcs, unit cost (expected) = (4box * $100)/72 pcs)=5.56]
3. User correct back the item UOM setting
4. Transfer has been done (with 1 Box = 18 pcs)
5. Inventory adjustment (positive) has been done with a incorrect unit cost (1 Box = 18 pcs)
Question :
How can I fix the data?
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions