using alternate unit of measure?

FRiC
Member Posts: 4
Sorry for the newbie post... One of my users somehow changed an item's base unit of measure from "box" to "pack". The base uom was originally box = 1, now it's box = 4, and pack = 1. :oops:
Unfortunately, the item originally had 30 boxes in bin contents, and the 30 boxes are now stuck. New entries will only record as packs, and I can't seem to do anything to the 30 boxes.
Currently it's showing 30 boxes and 0 packs, so doing a negative adjustment results in this: "Quantity must be greater than 0 in Bin Content Location Code='XXX',Bin Code='YYY',Item No.='ZZZ',Variant Code='',Unit of Measure Code='PACK'."
I searched and the problem seems to be similar to this, but there's no solution in that post.
I'm using NAV 5.0 SP1 on SQL 2008 R2. Thanks!
Unfortunately, the item originally had 30 boxes in bin contents, and the 30 boxes are now stuck. New entries will only record as packs, and I can't seem to do anything to the 30 boxes.
Currently it's showing 30 boxes and 0 packs, so doing a negative adjustment results in this: "Quantity must be greater than 0 in Bin Content Location Code='XXX',Bin Code='YYY',Item No.='ZZZ',Variant Code='',Unit of Measure Code='PACK'."
I searched and the problem seems to be similar to this, but there's no solution in that post.
I'm using NAV 5.0 SP1 on SQL 2008 R2. Thanks!
0
Comments
-
The quickest way I've found to fix screw ups like this is to create a new item correctly.
Transfer the merchant to the new item number. Block the old. And move on.
If you need to keep the number the same you can rename the bad item
Abc to abc-x. And recreate abc again.
That's just my opinion and the easiest way to get rid of the headache.0 -
Thanks, that's what I'm doing right now but I'm just wondering if there's a better way since blocking the old item also means I lose the history.0
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