Hunter MacLean Red Ribbon

@Mikko De La Fuente-Oracle I don't know how I missed that. Sometimes it just takes 2 brains! Thank you for the help!

I updated the code with: var expDate = nProdDate.setMonth(nProdDate.getMonth() + shelfLife); log.audit(format.parse({ value: new Date(expDate), type: format.Type.DATETIMETZ })); and received the following:

Cancel. Immediately after this I found that my IF statement needed brackets. Just needed to talk myself through it!

Hi Kristoffer, I just had an idea for this using the Set Field Value action on Sublist Action Group. If we can get the Shelf Life from the Item record and store it on the Transaction Line Field, then we should be able to use that value to calculate the Expiration Date and set it on another Transaction Line Field. I'm still…

Hi Kristoffer, Your walkthrough works. I didn't see that the Sublist Action Groups had different actions and I was probably using the standard action for that state. Thanks! Quick followup question. We ultimately need to use a field on the Item record in our calculation that will be displayed in a popup. So I'm not sure if…

Hi All, Not sure if the process has changed or it's something limited by my setup, but I was trying to source an Integer field on the Item record to a Transaction Line Field and got nothing. We need to get this value. So far so good. Sourcing and Filtering... But during Item Receipt for that Item record, nothing shows. Did…

Hi Mikko, Let me get back to you later this week. It's quite busy with budget proposals due.

Hi @Mikko De La Fuente-Oracle We have another example: Purchase Order #AP-1531PO Here are the Sent Email details. How do we see the details regarding the workflow that generated it?

Hi Mikko! So we do have ALLOW DEFAULT EMAIL ON PURCHASE ORDERS USING SUITEFLOW APPROVAL ROUTING Allow. The only workflow that ran on that PO (AP-1519PO) is: Purchase-on-Demand Approval - HK/CN For the Approved stage, I can see only 2 Send Email actions with subject: Your Purchase Request {tranid} has been approved Just…

Hi Mikko, Do you know a way to search for this? I tried Workflow and Workflow Instance, but couldn't find anywhere that I can specify the Workflow Action for Send Email. Thanks, Hunter

Hi Mikko, I checked script 170 and couldn't find the subject anywhere in the email. I also downloaded our SuiteScripts folder and perform a search across all docs and couldn't find the subject anywhere. Hopefully my approach is correct as I assume the "Purchase Order #... is Ready For Billing" should be specified…

According to the header details, it looks like the email was sent Thu, 11 Aug 2022 07:27:28 +0000 (UTC) I checked all the other scripts and these were my findings: 515 - I could not find a script with this Internal ID. 712 - No reference to email Subject. 713 - No reference to email Subject. 714 - No reference to email…

I checked Script ID 1500 but no reference to the subject of the email that should include "Purchase Order #... is Ready for Billing". I will continue to check the other scripts and update here.

I accidentally click this as the "Answer" even though we are still investigating the issue. I'm also attaching a file which contains the email header information in case my previous details contain sensitive information that shouldn't be posted. File has been removed.

Hi Elychelle, Thank you for the reply. Based on SA #14695 I was able to get, what I believe are, the Email Header Details (attached below). I was not able to find a Trigger Action however so I am wondering what information we can get from this in order to determine the origin of the email. --- BEGIN HEADER DETAILS ---…

Thanks, that is helpful. I can see some of the details via that search: Attachment has been removed. The goal is to identify the trigger or origin of the email. For example, did the sender trigger it unknowingly? Was it via a workflow/script or a saved search? Do you know how we can find this out? Because ultimately we…

Hi @Emilia Ironov-Oracle , One question raised from my team is whether it's possible with any of the workarounds, to report only On Hand data. The numbers look good, but we really need to be able to look at Aging for inventory that is currently On Hand. Let me know if you have any ideas here. Thanks!

Thanks for the tip @Dominica Sevilla-Oracle . It was the Tax ID was causing the issue. After blanking them out I was able to perform the merge. Thanks!

Hi @Shamaine Chan-Oracle , I tried this in my sandbox account as attached, but still not able to find the vendor. I also checked the Manage Vendor Duplicates list and didn't find it listed there.

Hi, They do match. Sales Order -> Accounting (subtab) -> Currency: Korean Won Vendor -> Accounting (subtab) -> Primary Currency: Korean Won Edit: Sorry, This was for the customer. I did go to the intercompany vendor record and check their currency. It was US Dollar, so I changed it to Korean Won. After trying a new sales…

Thanks! Let me know if there are any item or other specific details you need.

Here are links to those articles: #92794: https://netsuite.custhelp.com/app/answers/detail/a_id/92794/kw/92794 #96939: https://netsuite.custhelp.com/app/answers/detail/a_id/96939/kw/96939 #19584: https://netsuite.custhelp.com/app/answers/detail/a_id/19584/kw/19584 #65289:…

Thanks @Ivy Lopez-Oracle That did the trick. I was able to add the Item and Quantity details after that so now everything looks good.

I could only find these in SuiteAnswers: https://netsuite.custhelp.com/app/answers/detail/a_id/75940 https://netsuite.custhelp.com/app/answers/detail/a_id/73370

Ah. @Mikko De La Fuente-Oracle, you're right. Previously it was a Client Script and we were generating the value dynamically, hence why Store Value was unchecked. We had to switch to Scheduled Script due to the search limitations. Easy fix, thank you! -Hunter

Hey, sorry, I posted this a bit too soon as my colleague was able to perform the intercompany process correctly and it works now. So your original solution was enough to get it working. Thanks for your help Ivy! Hunter

Hi Ivy, Still could not check the Create PO box. Let me know if I have it setup correct: Accounting preference setup. Item setup with preferred vendor and a purchase price. I am using an Intercompany Customer on the Sales Order and selected the same item as above, but still it's greyed out. Any thoughts? Thanks, Hunter

Brilliant! That did it! Thank you so much for the quick support. Kind Regards, Hunter

Hi Michelle, Below are the screenshots of the permissions you asked for: For the Inventory Detail process, we follow it as such: Initiate the Receiving process for the Outsource Manufacturing PO Upon loading the Item Receipt, NetSuite notifies with the message that this is an outsource manufacturing order and requires…

Hi Everyone, We discovered the cause of the issue, there is no error on NetSuite's part. The value of the product dropped on March 1st from an Item Receipt of 100 units at US$35 (approx KRW40k). When we looked at the stock ledger between Feb 1st and Feb 28, versus Feb 1st to March 1st, we could see this difference in the…