I am trying to add Item Internal ID field in the i...
# suitebuilders
Suitestallion
09/13/2021, 3:07 PMI am trying to add Item Internal ID field in the item number field but I don't see the items in the source list, can someone point me in the right direction
a
AI1
09/15/2021, 2:01 AMYour trying to add the internal is of the item to its own item name field?
s
Suitestallion
09/15/2021, 2:09 AMYes, I am trying to create a new lot number element
a
AI1
09/15/2021, 2:14 AMSounds like a good use of a workflow. I don’t know that you can source a record with data from itself (although I can’t remember ever trying to do that..lol)
A simple after record submit trigger on a workflow could CONCAT the item number + internal id for you on create
s
Suitestallion
09/15/2021, 2:16 AMBut technically this is on a different record (lot number record) of the item.
Suitestallion
09/15/2021, 2:18 AMNot sure if you are familiar with new auto lot numbering suiteapp, that allows to generate lot numbers but the problem is we need to populate initial sequence number on the item record, so there is a chance that number might be duplicated so I want to add internal Id of the item which will be unique no matter what other things might be same
a
AI1
09/15/2021, 3:36 AMOh sorry I missed the part where you were talking about lot numbering. I thought it was just regular item records. Sorry
s
Suitestallion
09/15/2021, 5:05 PMit's okay no issue, any suggestion though?
a
AI1
09/16/2021, 12:39 AMIs the lot number a custom record or it’s own record type joined to the item record?
Like the MFG routing record?
s
Suitestallion
09/16/2021, 12:41 AMIt seems like it’s custom record you can search for inventory number
a
AI1
09/16/2021, 10:21 PMCan you run a workflow on it? Like select the custom record in the list of record on the workflow?
s
Suitestallion
09/16/2021, 11:37 PMI might be able to, but I want that element in the lot number
Suitestallion
09/16/2021, 11:38 PMcurrently with out of box these are the elements that are available
a
AI1
09/18/2021, 12:49 AMHmm sorry I’m not very familiar with this suite app. I’m not sure what I’m looking at here. I don’t see a reference to an item record anywhere in that list
s
Suitestallion
09/18/2021, 12:52 AMWe need to create a formula using these elements and then select that on the item record, but using any of these combinations would still have a chance of duplication except internal id in the element, but internal id doesn’t work, gives me an error that I cannot use that option
Suitestallion
09/18/2021, 12:54 AMThe reason it can duplicate is because we need to give initial sequence number on each item, it’s not like transaction where you set it once and it keep going to next number
2 Views