Just a quick question for the group.... working in AX2009. I am looking for a field which will give me ability to specify the "product release" in a manner like "A.B.C"... not sure if number sequences would be able to help?
a) Is there any standard field in AX that could resolve my problem?
b) If there is none, do you think that creating a String field would be suffice and not cause problems down the road?
*This post is locked for comments
Sure, my pleasure - glad that I could be of help!
Have a nice day / evening!
Thanks very much! Thank you really!
Hi
No, you can't, not if you want to differentiate the postings!
Suppose you put that str field on the inventTable, you take item X and initialize its product release with "A.1". Then you receive some stock on hand, sell some stock and change the product release to A.2. Then there would be nothing to indicate that the previous postings were done with A.1.
I'd recommend looking into the item dimension "configuration". Then, you'd set up the possible configurations of your item (item X has configurations A.1 and A.2 and ...). With each transaction, you then specify which configuration is concerned (next to the itemId).
AX tracks the configId in the invent transaction table and also shows the stock on hand for each separate configuration (product release).
(You'll have to choose a different item dimension group so that the configuration field is editable for these items).
It's quite possible that you don't have to do any (coding) modifications to AX at all, just setup.
This is a "developer oriented" explanation - of course there are other things to consider from a functional / consulting perspective. I'd recommend that you discuss with the consultant or key user ... They certainly have to be involved and should know about this feature and be able to put it into the proper project context.
(Of course, feel free to ask here, too ... just want to tell you that this is not the developer's decision alone).
Kind regards,
Annette
Do you have different "product releases" for the same item at the same time? - Yes
Do you want to track inventory postings with this product release? - Yes
Can't I get away with creating a new str field?
Annette,
Yup I am talking InventTable form.
Hi Khosla,
well ... it depends what logic you want to associate to the field.
First of all: I assume you're talking about the invent table - is that correct?
If yes ... Do you have different "product releases" for the same item at the same time? Do you want to track inventory postings with this product release? All this would point towards using the item dimension "Configuration". But this comes with a price - f.ex. your warehouse workers will have to get used to not only looking at the item ID, but at the release number, as well.
But let us hear, first, whether we're really talking about the invent table or not :-)
Kind regards,
Annette
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
