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…

I am looking to compare the on hand quantity, which is a calculated field based on the grouping as a portion of the received quantity. It is based on the inventory detail table as I want to capture bin transactions. Here are the criteria Current On Hand is case when {binnumber} is null then 0 else {itemcount} end Received…

When I use a CSV upload to update a transfer order, it recognizes and adds lines. However, when I include and match on the Line ID and item number (via internal ID), I get a response that the transaction type specified is incorrect. What is incorrect on my saved import?

Unfortunately, some of the other data on the search (such as last date on work order issue) is not available from the report. That is why I am using the search.

I have a summary search based on the inventory detail looking at transactions by item and lot number. The summary search grouops by item and inventory number. I calculate the current on hand as sum of case when {binnumber} is null then 0 else {itemcount} end. I calculate the received quantity as the sum of case when…

This got me closer than anything else I've tried. Thanks for the assist.

The filters are: The results are I got this formula to work to find the last Purchase order case when DECODE((DENSE_RANK() OVER (PARTITION BY {name} ORDER BY {transaction.internalid} DESC)),1,1) = 1 then {transaction.number} end that will get the last purchase order transaction, with two lines per item, one with the vendor…

I am sorry, but I don't see the option of building a search on Bundle Installation Script. It does not show up on the list of search types, and when I build a search on Scripts, it does not have the fields of managed or update available

I did find this method of seeing the bundles with upgrades, but I was looking to see if I a search could be written to filter the results, rather than page through the list.

The planning rule group shows transfers, can it show purchases with the destination Can I replicate the vendor is the source for warehouse BRV?

Let me clarify a bit more I can create Loc A transfers from Loc B. Can I specify that Loc B purchases from Vendor C?

Can I, by bin, restrict to a single item?

In part. It is a combination of these WMS Fields. I want them to recognize this setting on only a subset of our bins.

@Tigran Shahnazaryan Thank you very much!

I would like to select from the addresses stored on the vendor record as the vendor's ship from address. My preference is to add the record from the vendor addresses. I would prefer not to use a custom field.

Perfect! Thank you

I am not sure about other roles.