Elizabeth Vance Bronze Medal

Found my answer, I need to overwrite the sublist.

The UI allows an update without an error.

The original search gave me the actual material cost and actual overhead costs. Can I get those same buckets based on BOM quantity? I also get an error of field not found for {createdfrom.item.standardcost} The search is not letting me get to that third level of created from → item → item attributes.

can I see the standard in the same search? I want to compare actual to standard.

Thanks, let me give that a try.

I found my answer.

Found my answer. I need to touch a field on the header of the transaction for the update to occur.

Found an option.

Would a keep dense_rank() function be able to identify that there is a fulfilling transaction against the order, regardless if it applies to that line? I'm not sure how that function works.

How can I set a filter or equation to identify the fact that at least one delivery exists on a sales order while still excluding from the search lines that are fully shipped.

@Tigran Shahnazaryan I appreciate your response, and have tried that solution. However, we have cash sales that are created at the time the order is generated, and so any noninventory line moves to billed, so the criteria you suggest are the same for an item not shipped on the fulfillment and one that has no fulfillment…

I found my answer. The subrecord detail was missing.

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