I’m working on an Import Scenario that will update a sales order’s user-defined attribute.The simplified process will go as followed:Identify the order by Type and Number Open or Re-Open the order (QT requires the Re-Open) Set the attribute Return the order it starting stateSteps 3 and 4 need to be conditional and I haven’t found any documentation on how to do that. For instance, step 3 would need something like: IIf(=[Document.OrderType] = ‘QT’, <Action: Open Order> (OpenOrder), <Action: Re-Open Order> (ReopenOrder)As a work-a-round I am thinking about using Target Restrictions to limit the data to a single condition, i.e., QT and Completed or QT and Canceled. That way I can set the Mapping fields and change them each time to match the current conditon. I’m really trying to avoid this since it will be fairly manual.
Hi Everyone, I’m trying to figure out how to use an Import Scenario to modify the Sales Order Detail section. To be more specific, when we issue a warranty with a receipt line I would like to add a not to the issue lines saying, “Please include a return label”. Since this note will appear on the pick list our warehouse team will see it and can take action.Another way I thought of and would would be happy to resolve this is to use the import scenario to add a ‘return label’ non-stock line item. We could set this to $0.00 and as long as it is an ‘issue’ it should appear on the pick list. Below is what I have so far. The problem is I get this error when it tries to run, “The last error was IN Error: Unit conversion is missing.” Looking forward to see what everyone has to say.
I have a GI, Shipment Details, that is driven off SOShipment, SOShipLine, and SOOrder to shows each line of a shipment and its corresponding order. It is currently serving its primary function, but I would to get more out of it by reporting the number of distinct/unique shipments there are.Is there a way to do a distinct/unique count in the GI results grid? I know this can be done easily through a pivot table, but my goal is to have this information right at the bottom of the GI results grid by using the Total Aggregate Function. Having it hear saves that extra click and load time that pivot tables inevitability have.Another way of phrasing this is, does anyone have an equations that will count a shipment number once?My first idea was to divide 1 by the number of lines on a shipment. When added back up each shipment would equal 1 and all of them would give me the shipments count.
I’m testing the hierarchy system of Item Classes and have a question on what I can report/filter with them. Particularly, when I filter on a parent item class I would like to see all of its child entities. For example, if my hierarchy is:1.1.11.1.21.2.11.2.21.3.11.3.2I would like to filter on 1.x.x and see everything or I could filter on 1.2.x and only see the 1.2.1 and 1.2.2 or filter on 1.3.2 to just see those items. Is that possible?Another example of what I’m looking for is how the Inventory by Item Class (IN408000) screen gives the options of ‘Related to Only the Current Item Class’ or ‘Related to the Current and Child Item Classes’.I do understand that I could filter on ‘Contains’ as opposed to ‘Equals’, but that is on more thing to explain to people.-Adam
The Process Orders screen can be used to ‘create shipments’ but not ‘create receipts’. So I put together a business event and import scenario to trigger the <Action: Create Receipt> (CreateShimentReceipt) but am running into issues with the dialog box. Any ideas on how to populate a multi field dialog box?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.