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
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Multiple Item Cost Setup
itspeter
Member Posts: 105
I have an Item, called Peanut Butter, some of the customers buy from us, request to have their own brand, and packaging size (10kg/15kg/20kg). How do I create this Peanut Butter?
If I create this as 1 item in item card, and there is only 1 item cost in the Item Journal, how can I reflect the cost based on each Brand and Packaging size?
If I create an unique Item based on Brand and Packaging size, it could easily end up n Brand X n Packaging Size X Product Spec. How do I reduce it? :-s
If I create this as 1 item in item card, and there is only 1 item cost in the Item Journal, how can I reflect the cost based on each Brand and Packaging size?
If I create an unique Item based on Brand and Packaging size, it could easily end up n Brand X n Packaging Size X Product Spec. How do I reduce it? :-s
Regards,
Peter Ng
Peter Ng
0
Comments
Btw, Next time it's maybe a good idea to post you Navision version.
If it was hard to write, it should be hard to understand."
item.then one item + a variants --> each Brand and Packaging size,system could set up vary cost to "one item + a variants "
So, I think you problem has just been solved.... maybe
If it was hard to write, it should be hard to understand."
I'm using Nav4.0. Our Navision vendor was telling us there is no way it can be done, mean 1 item with multiple cost, based on Brand and Packing.
Can I know, or be more specific, how do I achieve this in Navision 4.0? Since, my vendor couldn't guide us in this. :?
Peter Ng
Plus I not really trying to give you the absolute correct answer. I’m just trying to point you the right direction. So, it could very well be you dealer is not trying to rip you off but really tries to give you the best possible support.
Please try to test the way we pointed you.
Create an item. Create multiple variants. Create multiple unit of measure codes. Then setup the Purchase Prices and Sales Prices table an just purchase and sell some items. If it’s does what you want it to be, discuss this with your dealer. Let them confirm your solution.
Please pay them for this confirmation. If people like them, like me, don’t get paid mibuso wouldn’t exist.
If it was hard to write, it should be hard to understand."
I'm looking for Cost for each Brand+Spec+PackingSize, not the selling price.
Which mean 1 item have multiple Cost based on different Brand+Spec+PackingSize.
Brand is because the Packing Material Cost might be different.
Spec is because Product grade is different.
Packing Size is 500g, 1kg, and so on.
Peter Ng
If it was hard to write, it should be hard to understand."
I need multiple Unit Cost for each Item combination. 8-[
Peter Ng
If it was hard to write, it should be hard to understand."
It would help if you could be more specific about why you need the cost.
You can use the Stock-keeping Units (SKU) if you want to maintain SKUs as per Location/Variant or both and have cost information per SKU.
and set the "Average Cost Calc. Type" in "Inventory Setup" to "Item&Location&Variant" if the item costing method is "Average".
Thanks for the reply
Certain customer order high quality ingredient, it should not be the same cost as lower quality ingredient. Certain customer order glass bottle, and some order in tin and refill pack with their own brand or ours, also the packaging material's quality. Packing size ranging from 150ml to 10kg.
They want to calculate the unit cost on each combination, and to come out with reasonable selling price, to serve as a guideline for the salesperson to sell each combination of the product. Also, to calculate P&L for each item.
Each combinations has turn out to be different products. My vendor has customized the Order to allow salesperson to choose the brand, packaging size, and packing design. But, they miss out the cost. #-o
We were given 2 choices: -
1.) Create each combination as 1 item.
Brand X Product Spec X Packaging Size = N items
2.) Massive customization $$$$$$$
Peter Ng
Without SKUs you will get a totally useless average mix of the cost of all possible variants and, consequently, an all wrong inventory valuation.
Thanks for the reply. I raised the Variant, and SKU to my vendor, their response is I'm actually creating more work for the user
Variant = Brand X Product Spec X Packing Size
SKU: -
Product X Location X Variant
I think we will end up defining unique item code. :-k
Peter Ng
You can make SKU per Location, Variant or both.
So, if you use the standard function Make SKU on Item card, see the options.
Reading the answers from your partner, I must say that they do not even know standard functionality within Navision.
I just hope you didn't pay them for this kind of answers :roll:
It's true that you need testing these things out.
You might need some adjustment to the code in order the make variants automatically once you defined UOM and brands, so that the system create the variants itself...
Good luck (with your partner...)
Many thanks for your feedback, I thought everybody gave up on my problem.
To setup SKU Variant location, is it you mean leaving the value blank during SKU form?
I tried it, it able to setup, but when I key in the inventory in the item journal, if I don't choose location, it goes well, but once I select the location, it will standardize into 1 unit cost.
My vendor commented still will be the same Variant Location X Items. :?
You mentioned How can I do that?
Thank you.
Peter Ng
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I have tested without setting location.
Conditions: -
1.) Item Costing method = Standard
2.) Item Standard Cost = 10.00
3.) No Manufacturing module, pending due to customization.
Steps
1.) Create variants in item card
2.) Create SKU for Item with combination of each variant, without location.
i.) Variants -> PEAC1, Peanut Class 1 = Cost 15.00
3.) In item journal, make positive adjustment.
i.) Select variant PEAC1, the cost price will show 15.00.
ii.) If I choose a location, the cost price will auto change to 10.00.
Questions
1.) Expected should be cost price should not change according to location, since SKU did not set for it. What went wrong? :-k
1.) Is the standard item costing causing problem? My finance department wanted to use Standard Costing for item.
2.) If I don't choose location, will the system be able to capture stock quantity based on location? :-s
Peter Ng
STANDARD is totally wrong for goods like these, use FIFO or AVERAGE.
STANDARD could be used for lubricants needed in a production process with a relatively fixed, estimated or calculated cost.
Note :
You can only change the costing method when the inventory is 0.
I have done several test on Costing Standard, Average, and FIFO.
Conditions: -
1.) Item Costing method = Standard / Average / FIFO
2.) Item Unit Cost = 10.00
3.) No Manufacturing module, pending due to customization.
Steps
1.) Create variants in item card
2.) Create SKU for Item with combination of each variant, without location.
i.) Variants -> DELIPN1, DELI Brand Peanut Class 1 = Cost 15.00
3.) In item journal, make positive adjustment.
i.) Select variant DELIPN1, the cost price will show 15.00.
ii.) If I choose a location, the cost price STILL auto change to 10.00.
- It is still happening. :?
iii.) If I exclude the location, I cannot drill down the Inventory in SKU.
For average costing, all the positive adjustment on different variants is average up into 1 cost. I don't want that. I want it to be different. Because the variants consist of different brand, and product specification.
Most of you guys mention it is possible, and I believe. But, I cannot reproduce it to get the result. ](*,)
For this customisation, my vendor quote me 80+ man days.
Peter Ng
Create the SKUs, then set the Costing method to FIFO, put in the right cost in the field "Unit cost" (forget the field "Standard cost", that's for costing method STANDARD).
If is necessary to put in the unit cost separately for every location ( check this in the Object designer for table 5700 or redesign the Stockkeeping unit list form)
NOTE : AVERAGE will give you an average of the variants purchase prices incl. item charges for the cost of sales, whereas FIFO will link the cost to the actual purchase(s) which have a remaining quantity. Both methods can be used ( if AVERAGE is used see my earlier posting about the setup setting)