Can we take a deeper dive into this? When viewing the sales order line items, what is the field name to use on the saved search for the line item's location? Maybe I am using the wrong field? I am sending a screen shot of two different fields, one pulled from the Item Fields as a join, and the other is pulled from the Item…

The Amount line item is blank on all the orders for all lines called SUBTOTAL. Please see attached. The lines that contain an inventory item update just fine, it's these miscellaneous items that do not: SUBTOTAL - no quantity, Item Rate is blank, Amount field is populated C300 (discount item) - no quantity, Item Rate…

I have included a sample of what is happening. FYI: Yesterday I spent hours manually re-setting the ship from location on the main line within each of the sales orders so all line items would reflect the correct ship from location. Just so you know, when a user manually changes the ship from location a pop-up window asks…

That worked!! THANK YOU!!!!!!!!!! This will save me HOURS of manual cancellations!

Now I get a new error:

It already is.

The fields used in the saved search results are: Internal ID Item (Field name ItemID as shown below) Line ID Amount (which is not relevant for the mass update, we use it to track how much money is being lost in cancelled orders) Closed On the import selection, I have mapped the following:

but I still get this error.

Hello, and thank you for the response. The item record is set up for our holding company, but the "Include Children" checkbox is marked.

I tried this method to close several orders but received an error "Invalid item reference key DBMW0720BBB for subsidiary 3." My data appears below: What would cause this error?