I can get the amounts, but how do I show the discount item applied on the header on each line item?

I don't see the inventory number as a record type that can be selected in the workflow basic information, nor can I find the inventory number record for a CSV upload. Am I missing something, or can this only be done one record at a time through the UI?

@Shorin Rio Daa-Oracle I got your recommended fields to provide the data desired. Thank you!

@Shorin Rio Daa-Oracle the user wants one line per lot number on the search The recommended fields provide a single entry, separated by commas.

@Jervin Nicholas Teopengco-Oracle I appreciate your support!

Here is the configuration for the vendor lot number I am looking at. It leverages a custom field (vendor lot number) on the item line receipt record I have a second custom field on the inventory number record, and want to move it from the custom field on the item receipt to the item number record Both custom fields are…

That is the moble app. I am looking to modify the AM tablet entry screen to allow for population of a custom record.

In creating the custom field, where do I specify the formula?

Thanks for the assist

I appreciate the lead to the freemarker, and I'm trying to work through making this work. I don't write code, so it's a learning opportunity!

I can get the data I want into the results. One set of results I want to print in one header table, and not repeat the duplicate data. The second half of the results I want in a body table. Is that something I can do in an Advanced PDF print? The samples I have seen are producing lists, such as mailing labels. not a header…

I found my own answer. the item receipt form was missing the link the the assembly build helper.

Found my answer. The data does not appear once the work order is in process, and I was, without checking, using in process work orders to validate the data.

This is my source code.

I also tried mapping every line, not just the line with the transaction type = item, and with the overwrite sublists unchecked, it added lines, not updated lines.

the lineID is not a custom field. It is the line ID indicator on the item line record.the line ID is pulled from the saved search, with a filter transaction line type is item. I am using that search, shown below, as the source of the data. When the overwrite sublists is unchecked, I get 5 lines that match the data in the…

Here are the items on my transfer order and my template and mapping

Thank you Jervin! this did exactly what I wanted to see done.

selected in the field: displays as: I would like Requires Hangtags Requires Polybag Pack in Multiples of six (-201)

I got it to return results, silly error on my part, but can I get it to allow a return or space between the selected values?

Found the answer <#if !item.isclosed>

This is perfect! Thank you so much for your assistance!

<#if item.isclosed> will return the closed lines. How do I find the opposite, where it omits those lines.

I found the right place to be the </#if> but the original if statement doesn't work <#if item.closed?string != "true"> is returning all lines, not just those not marked as closed.

I put the statement <#if item.closed?string != "true"> at the start of the item listing table, and the <#/if> before the </#list> at the end of the table It validates, but all I get is the first line and not the full item list, regardless if closed on not closed. I lost the looping through the items. </tr></table> <#if…

@Red Velasco-Oracle I am not sure where I am putting the closing if. Could you show me an example?

@Clarisa De Torres-Oracle I did use the same method you did. The only part that my user does not like is that it filters out the GL Lines that do not have this custom segment associated with it, so he doesn't have the same format each time, which he gets with the 'show zero's' option of the report.

That did work!

I don't see my custom record type in the list to create the workflow. Is there an attribute on that record type to make it visible?

I have a custom field, similar to a lot number, that is alpha numeric that I wish to display as a bar code on a saved search. How can I do that?