anyone know the formula to have a line item field ...
# generalo
Ogabeg
04/22/2019, 7:26 PManyone know the formula to have a line item field autopopulate numerically
so...if we have 1 line item the filed would say 1 and then we add another line item the field would say 2 and then add a thrid line item the field would say 3 and so on?
w
Wolf
04/22/2019, 7:28 PMCustom field with formula {linenumber}, I think
Wolf
04/22/2019, 7:28 PMSee SuiteAnswer 81851
g
Gregory Jones
04/22/2019, 7:39 PMYou can pull in Line Sequnce number in a saved search, which will reflect the order in which the items appear
Gregory Jones
04/22/2019, 7:41 PMBenefit is that it is a dynamic number. If you add / delete items then it will update.
o
Ogabeg
04/22/2019, 8:13 PMthe issue im having is making it dynamix
Ogabeg
04/22/2019, 8:13 PMdynamic*
Ogabeg
04/22/2019, 8:18 PM@Gregory Jones would it be a specific formula to make it dynamic
g
Gregory Jones
04/22/2019, 8:37 PMNo. You should be able to select the field in results of a transaction saved search
o
Ogabeg
04/22/2019, 8:38 PMquestion is: how does the field autoupdate when deleteing a line item...currently it make me retype the line number
g
Gregory Jones
04/22/2019, 8:46 PMI don't have it on our transaction form.
o
Ogabeg
04/22/2019, 8:46 PMso yours only pulls up in saved xearches
Ogabeg
04/22/2019, 8:46 PMsearches*
g
Gregory Jones
04/22/2019, 8:51 PMCorrect. Curious what are you looking to ultimately accomplish with this?
o
Ogabeg
04/22/2019, 8:52 PMcalculate how many line items per sales order
g
Gregory Jones
04/22/2019, 8:55 PMDo you need to see it on the transaction form, or in a saved search?
o
Ogabeg
04/22/2019, 8:55 PMboth if possible
g
Gregory Jones
04/22/2019, 8:56 PMAnswer ID: 36017 in suiteanswers gives guidance on how to create a summary saved search which will give you a count of line items on a sales order.
Gregory Jones
04/22/2019, 8:56 PMAs for seeing it on the actual form, i'm not quite sure on that front.
o
Ogabeg
04/22/2019, 8:59 PMill check that out, thanks for lal your help Greg
Ogabeg
04/22/2019, 8:59 PMall*
g
Gregory Jones
04/22/2019, 9:01 PMSure thing. This additional article should solve for having a field on the sales order form that displays the count of line items on it. Answer ID: 63428
Gregory Jones
04/22/2019, 9:06 PMI'm going to see if i can get it to work.
Gregory Jones
04/22/2019, 9:20 PMYup. It works with a few slight tweaks: 1 - when you create the transaction body field to reference the saved search you create at the start, select "sales" under "applies to". forget about the picking ticket portion of that 2nd part. 2 - you can forget about the last part of adding it to the picking ticket (unless you need that)
o
Ogabeg
04/22/2019, 9:37 PMnice! thanks
👍🏻 1
4 Views