Item Code Increase with dynamic prefixes?
Desmond
Hi,
I am hoping to find a way to increase our Item Code Number according to certain rules. Perhaps someone can help me or point me in a direction.
Our Item Codes follow this standard.
Sample Item Code = 118920000001
1 189 20 000001
a bcd ef ghijkl
a bcd ef ghijkl
- abcdef is the prefix
- ghijkl are the increasing suffix numbers for the specific prefix
This is how we want to generate our code.
Inventory Master Data
for value a:
a = 7 - if Item Group (OITM.ItmsGrpCod) = '102'
else
a = 1 - If the Country (CRD1.Country) of OITM.CardCode <> 'ZA'
else
a = 3
for value bcd:
bcd = OITM.CardCode (first 3 digits) - from Preferred Vendor
for value ef:
ef = OITG.ItmsTypCod (from Inventory Master Data Properties, if Property Code = only 1 digit, we need a 0 in front e.g 01,02,03 - 10, 11 etc.)
for value ghijkl:
ghijkl = 000001 (auto increase digits for all relevant prefixes)
So what we are hoping to do is -
- Open a New Item Master Data Record.
- Select the Item Group.
- Select the Preferred Vendor.
- Select an Item Property.
- Have a trigger.
Then the Item Code auto generate the prefix and the next available suffix numbers for that prefix.
Is this possible, any help or suggestions?
Thanks! :)
0
Please sign in to leave a comment.
Comments
0 comments