I happened to work it out - so I will share the situation and my solution in case someone else runs into this? One of our customers has sales directly imported in NS and put under a Waiting Approval status. It has happened that it has been missed in the approval process that a line item isn't in stock, which delays it…

https://community.oracle.com/netsuite/english/discussion/comment/16899597#Comment_16899597 That worked! Thank you!

Maybe it's that I'm trying to set the value of 'Use Case Current Record' through the workflow action 'Set Field Value'? instead of a script?

How's the rest of your workflow set-up? I'm getting a script error now. 😓

Workflow Field: On Entry:

https://community.oracle.com/netsuite/english/discussion/comment/16899570#Comment_16899570 It is not. The other examples provided in answers are going to another transaction type — And I'm not having an issue opening a transaction. I'm having an issue re-opening the one that was just saved.

https://community.oracle.com/netsuite/english/discussion/comment/16899536#Comment_16899536 I would think so too - but that's not an option

https://community.oracle.com/netsuite/english/discussion/comment/16874457#Comment_16874457 Hello! I am actually trying to do this and I'm still getting stuck. It looks like the previous person got it to work for them, but didn't exactly provide how. My workflow has a set field value for Workflow Field to Current Record the…

https://community.oracle.com/netsuite/english/discussion/comment/16897911#Comment_16897911 Found a custom field that already existed for tracking so used that to create the workflow.

I figured out why it wasn't getting out of Sandbox (or at least changed the approach and actually received the email.) I was testing Item Fulfillment marking it directly as Shipped. The email went through when I went through Picked/Packed/Shipped.

Hi Angelica! Thank you for the information 1. Paranoidly checked correct email several times (it is my own work email) 2. I am using the 'Custom' email form, I am not sure what would be required/missing from that? As far as I can tell, it is set-up no differently than others I have set-up (but for the fact it's coming from…

I have run into this too, I believe.

https://community.oracle.com/netsuite/english/discussion/comment/16874937#Comment_16874937 Hi Niks, I do - here it is Criteria Results

https://community.oracle.com/netsuite/english/discussion/comment/16872113#Comment_16872113 Thank you, I'm good.

https://community.oracle.com/netsuite/english/discussion/comment/16869140#Comment_16869140 Perfect, thank you!

Solved this after playing around for a while, one location is receiving transfer orders and the other is receiving purchase orders. I was able to split them out with the below: CASE WHEN {location} = 'Location A' THEN {item.locationquantityintransit} ELSE 0 END CASE WHEN {location} = 'Location B' THEN…

https://community.oracle.com/netsuite/english/discussion/comment/16867634#Comment_16867634 Thanks Niks, But it still is keeping the On Order amount totaled for both locations

https://community.oracle.com/netsuite/english/discussion/comment/16867308#Comment_16867308 Thank you Jon, I tried those and none of the number match. I'm not having an issue with {onhand} or {available} only {item.quantityonorder} - which is showing all items on order for both locations, when I only want one.

I am also curious about this. We seem to be using the same map to email address and if a customer uses a different email address, a new customer is created. Is there a way to review name and address (and a way to unify how an address is translated - so if the customer puts in Dr or Drive it can be brought in as only one…

https://community.oracle.com/netsuite/english/discussion/comment/16857851#Comment_16857851 There didn't seem to be anything that related to what I am asking, the closet might be WMS System Rules to stage receiving before putting something away, but there's no information on how that works… is that based on tracking status…

https://community.oracle.com/netsuite/english/discussion/comment/16857826#Comment_16857826 I know my company uses WMS - How does this pertain to tracking on Authorized Returns? Is there documentation somewhere that shows how WMS can be used to automate checking the status of tracking on UPS/FedEx sites and updating fields…

https://community.oracle.com/netsuite/english/discussion/comment/16857563#Comment_16857563 For the purposes of the company I work for, we were looking for a way to automate checking tracking on authorized returns and updating a custom field on the return so that our Warehouse knows when something /should/ be there to be…

https://community.oracle.com/netsuite/english/discussion/comment/15293700#Comment_15293700 Any success on this?

I was able to make a report work by using Invoices instead. Below is how I resolved this: Criteria: Type is Invoice Main Line is True Name = Customer System Notes: New Value = Paid In Full Amount is not 0.00 System Notes: Date is within this year Results

https://community.oracle.com/netsuite/english/discussion/comment/16857176#Comment_16857176 Hi Jeremy, Before I create a case, let me try to provide better detail (I will also likely need help opening a case) This is the result I am aiming for (the below amounts would be correct): Maybe going by Invoice instead of credits &…

https://community.oracle.com/netsuite/english/discussion/comment/16857003#Comment_16857003 Hi Jeremy, Apologies on the delay - I am only able to refer to this while I am at work and I was off on Friday. It appears to provide the correct totals when it is just these two summed columns, however - for the information I am…

https://community.oracle.com/netsuite/english/discussion/comment/16856804#Comment_16856804 Criteria: Name = Particular Customer Main Line is False Formula (Date) is within this year : CASE WHEN {systemnotes.field} = 'Document Status' THEN {systemnotes.date} ELSE NULL END Type = Payment, Credit Memo Amount is not 0.00…

https://community.oracle.com/netsuite/english/discussion/comment/16856788#Comment_16856788 Hi Jeremy, To answer the first part, yes - that is all the lines for that date that show up under the drill down. I scrapped that report, so I do not have the details for the screen shots available. As far as I can tell, because I am…

I was able to resolve this. Under Criteria I created a Numeric Formula: CASE WHEN {fulfillingtransaction.cogsamount} > 0 THEN 1 ELSE 0 END And is 1

https://community.oracle.com/netsuite/english/discussion/comment/16855358#Comment_16855358 Hi Angela, That is what is happening. Our customer service team is not always clicking it for RMAs and RMA related sales orders. The tax that was on the original order remains the same on the RMA or new SO even if the taxable amount…