Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Dimensions with Physical Inventory
Mauddib
Member Posts: 269
We use Dimensions on our system 3.70.B We have Dimensions set as mandatory.
This has implications when you do Physical Inventory Journals which are causing me trouble. When you do a Physical Inventory Journal --> Calculate inventory... all the items come up with the Dimension Code NOT filled in, which takes ages to do manually.
If however when doing the 'calculate inventory' you turn on the "By Dimensions" option it fills in the dimensions. But it does it badly as some of our raw materials are used in items with different Dimensions. Example follows:
We use Dextrose with Dimension DEXT in making gum balls with Dimension HLLW. If we start with 20unit of this and use 2 of it in making the gum ball...... then we do Calulate inventory... What you expect would be:
R7250000 Dextrose DEXT 18
What you get is:
R7250000 Dextrose DEXT 20
R7250000 Dextrose HLLW -2
So to enter the count of R7250006 of, say, 17 I have to set the first line to 17 and the next line to 0.
When you take into account that we make 30 different Gum balls PER DAY, you can see this is also a pain in the neck.
Any workarounds out there?
GaMBe
This has implications when you do Physical Inventory Journals which are causing me trouble. When you do a Physical Inventory Journal --> Calculate inventory... all the items come up with the Dimension Code NOT filled in, which takes ages to do manually.
If however when doing the 'calculate inventory' you turn on the "By Dimensions" option it fills in the dimensions. But it does it badly as some of our raw materials are used in items with different Dimensions. Example follows:
We use Dextrose with Dimension DEXT in making gum balls with Dimension HLLW. If we start with 20unit of this and use 2 of it in making the gum ball...... then we do Calulate inventory... What you expect would be:
R7250000 Dextrose DEXT 18
What you get is:
R7250000 Dextrose DEXT 20
R7250000 Dextrose HLLW -2
So to enter the count of R7250006 of, say, 17 I have to set the first line to 17 and the next line to 0.
When you take into account that we make 30 different Gum balls PER DAY, you can see this is also a pain in the neck.
Any workarounds out there?
GaMBe
0
Comments
That being said it is still reasonable to do a physical count and expect that the item's default dimensions get applied to the item journal lines that are created. In the InsertItemJnlLine function in report 790 (Calculate Inventory) the item number on the item journal line is validated which will attach the item's default dimensions to the item journal line. Unfortunately, a little bit later in that function those dimensions are deleted and replaced by only those dimensions that are specified on the option tab of the report request form. It's a pretty easy matter to change this logic to keep the default dimensions.
I also understand that applications will be an issue if you need to report by dimension ... it may not make sense, however if I calculate inventory and then fill in the Dimensions, it posts fine.
I am going to update the code in the inventory count to include those dimensions but only when NOT using the "By Dimensions" option (this option fills in the Dims if selected on the report) on the report and I will keep you posted as to the findings. I know that one issue will be like for my customer they did not originally use dimensions on items and so the ILE will not have any dimensions, and now they want to and so if they had started using dimensions from the start they could use the "By Dimensions" and then this would not be an issue.
Like I said previously, I will keep you posted on the findings :-k
One thing to understand is when you run the physical inventory count, you either do it by dimension or not. If you don’t run it by dimension, it is set to NOT record the dimensions in the Item Journal Line.
A physical count looks at ledger entries already in the system and then populates the journal. If the ledger entries contain dimensions on them, and you run the calculate inventory by dimension, then it will populate the dimensions, however if the Item ledger does not have any dimensions attached then when running by dimension, it will populate blank.
Making the change as I suggested in my previous post to populate the dimensions from the Item when running the Inventory Count without the "By Dimension" option may not be the best solution as we are bypassing what is already stored on the Item Ledger to cater for what is on the Item. So for example if the Item ledger has dimension 1 on it, but the Item card is set to 2, the physical count will set the dimension to 2 and post a positive or negative adjustment with 2 on it and cause an imbalance by dimension especially when it comes to applications.
What may be a better option is to start using the default dimensions on the Item Card or set dimension rules on stock items to populate the purchases, sales and other movements and then there will come a time when old stock with no dimensions is cleared out and new stock has dimensions and we can then run the count by dimension.
Hopefully this helps!