Elizabeth Vance Bronze Medal

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?

How is this change done? Modify the Display Field If the field is using a List/Record (Transaction) type, update the Display Type to show Transaction Number (tranid). I don't see an option for display type selection other than normal, inline, disabled or hidden. I

I get an error that the shared connections URL, http://server:port/workspace/SmartViewProviders The provider running at http://server:port/workspace/SmartViewProviders his not a shared service provider. How do I modify the URL to link to the NSAW workbook?

Are there instructions on how to configure the smart view connection?

the user wants the results of the workbook table from NSAW to feed into Excel without having to do the open and download each time. Can the NSAW workbook table be selected as a data source in excel?

I found the answer to this one.

I get the same error when I use this mapping:

I have only the internal ID mapped. The second internal ID is for the item number

I have a saved summary saved search that sums quantity from sales orders entered by week by our material hierarchy. The planner wants the listing of items, and then a subtotal for the material hierarchy level [MH] Class

Error Internal ID Date Created Document Number Date Location To Location Line ID Item Display Name Internal ID Expected Receipt Date Quantity Transaction type specified is incorrect. 24179591 1/21/2025 TO15011 1/22/2025 Tennessee Manufacturing BRN-B2C 1 30-132 : 30-132-12G Silencer Smooth Roast, Ground, 12 oz 15981 1051…

Does this create an overarching transaction that can than be used to feed our transportation management system?

I want the percentage of received still on hand.

I follow those instructions, and my transfer orders do not display to select.

The planning system is Logility, with a custom interface to Netsuite. Our third party warehouses can only receive once against a shipment, so the planner is suggesting one line transfer orders, since she cannot predict exactly which items will come off the production line and when the truck for the transfer order would be…