I personally don't like using variants unless there is a strong case for them - as they bring a lot of complexity to all areas of AX.
That said, you may be able to solve this another way.
If you create one item price group, you should be able to tie a single trade agreement to all the items using the smallest unit of measure - for instance square inch, or square centimeter.
On your saleslines, you'll have also have a unit of measure - typically the selling unit of measure from the Item master. That would normally match up to the trade agreement unit of measure, thus allowing the price to be discovered.
You would also want to setup, on each item, an item specific UOM conversion between EA and square inch.
Your remaining issue, then, is to be able to enter a quantity of ea for a particular item - without affecting the selling unit of measure.
This can be handled by a simple mod to create an "edit method" on the salesline. You could call it "Qty in EA". It would simply display your normal sales qty converted into EA - and since it's an edit method, not a display method, you would actually be able to enter a value into it, have it convert that quantity into the sales UOM, and set the sales qty.
------------------------------
Tony Zeigler
Senior Consultant
Strategic Solutions NW
Beaverton OR
------------------------------
Original Message:
Sent: Feb 03, 2021 12:46 PM
From: Alexandra Cadet
Subject: Item price group
Hello Lynn,
I don't know variants very well so you should cross check and experiment. That being said, here are some thoughts.
One benefit of variants is that you can set the price on the item and it applies to all its variants. And you still have the option to set a price on a specific variant.
So you should be able to use an item to group all with the same price (same square footage) and use variants to indicate the different set of dimensions.
But it wouldn't work in the way you describe regarding unit conversion, I don't think so.
It looks like there is not standard functionality that would convert a price in meter into a price in cm automatically, for instance. Although this should be optional, I guess it could be smart in your case (and I'm sure in others) to have a price conversion tied to the unit conversion.
Another idea for Microsoft maybe?
------------------------------
Alexandra Cadet
Camfil
Original Message:
Sent: Jan 26, 2021 03:29 PM
From: Lynn Kinsman
Subject: Item price group
Our products are photographic papers that all have the same trade agreement price per square foot. The paper is sold under many SKU's for different cuts (8:10, 5X7, etc) and number of sheets per pack. I don't think the business has ever considered using variants to link these products together. Today they all appear as separate SKUs in the catalog. How do trade agreements work with variants of a product id? Can you set the trade agreement for the product id by the square foot and then sell the different packs of paper (variants) by the Each and have the trade agreement 1) be recognized as applicable and 2) do the calculations correctly to convert the UOM?
------------------------------
Lynn Kinsman
Senior Systems Analyst, AX 2012 and D365 F&O
Kodak Alaris Inc.
Rochester NY
Original Message:
Sent: Jul 20, 2020 01:44 AM
From: Zvika Rimalt
Subject: Item price group
What types of items you have that have the same price, always?
Is that essentially the same item but in different colors/sizes/pattern/style etc.?
I think in such situation some users resort to using a single product ID (and hence one trade agreement line), and creating product variants - in order to keep the different items separately in inventory.
Could that work in your case?
------------------------------
Zvika Rimalt
Functional Consultant
Vancouver BC
Original Message:
Sent: Jul 08, 2020 04:25 AM
From: Alexandra Cadet
Subject: Item price group
Hello,
I'm working on trade agreement and really miss something like a "item price group".
We can group items regarding line discount, but not regarding prices...
I would love too though, because we have many items with the same price, and it would be great not to have to set a trade agreement for each.
I feel like raising this as an "Idea" to Microsoft, but I'd like to be sure I'm not missing something major here...
Thank you by advance for your feedbacks!
Regards,
------------------------------
Alexandra Cadet
Camfil
------------------------------