Thanks for providing the requested additional information @OliverOO. We will do some testing on this and will get back to you with an update. -Jack

That is an interesting question, @W. Strong. Since files are linked to records in NetSuite with their Internal ID values and moving them to a different folder does not change those values, it does not break the file-record linkage. Hopefully, this clarifies things. -Jack

Greetings @asha.jena, Thank you for posting a new inquiry here in NetSuite Support Community. We will look into this and will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

Thanks for confirming @User_JN952. May we also ask if there is any difference in the naming convention between your Customer and Vendor records? That could be a reason why the script does not work as expected. -Jack

Greetings @W. Strong, Upon checking, moving files in the File Cabinet to a different folder can be done with SuiteScript. Here is a scripting approach you can implement to accomplish your goal: Use the N/search module to search for the files to move. Load each file to a File object with the file.load() method of the N/file…

Greetings @User_E15G4, You can pull the Internal ID of the selected Billing Address on the Purchase Order and display it in a Custom Field using the {billingaddress} field reference as a formula. See the sample screenshots below: Hope this helps. If you find this reply to your question useful, others might be as well. By…

@kees.netsuiteadmin, As per SuiteAnswers Article 73931, here is the list of Shipping Fields that can be referenced in Advanced Sales Order PDF/HTML Templates as well as Custom Field Formulas upon testing: Hope this helps. -Jack

Hi @User_JN952, Do you still need further assistance with this inquiry? If so, we would appreciate you providing the additional information we were requesting in the previous post. -Jack

Greetings @User_CE1IU, Upon checking, the Closed checkbox is always shown in the Expenses sublist of Purchase Orders. However, it is not available in CSV Imports yet. Also, Workflows cannot be used to close Purchase Orders in bulk in your particular case since it does not support the Expenses sublist of Purchase Orders…

Greetings @kees.netsuiteadmin, You can capture the Shipping Address Zip Code in a Custom Field Formula by using the {shipzip}field reference. Hope this helps. If you find this reply to your question useful, others might be as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to…

Since the Created From field on Item Fulfillment will never be empty, you only need to check if the field is assigned with a Sales Order record. See the code snippet below: ... var createdFromRecType=search.lookupFields({ type: search.Type.TRANSACTION, id: SalesOrderId, columns: 'type' }).type[0].value;…

Thanks for the update @User_BHLPU. Testing your code, you need to do the following adjustments to resolve all the errors: 1. Replace the indicated parts below in your code with the revised code: Your Code: ... function pageInit(context) { var ifRec = context.newRecord; var SalesOrderId = ifRec.getValue('createdfrom'); ...…

@User_V5KBL, see our responses below to your follow-up questions: Your response is clear except for the section - " or when setting the fields to the same values already assigned to them. " Please clarify. The screenshots below show an example of what I meant: In your case, the fields described in the provided Workflow Log…

No worries @Nickoletta Gounaris. As shown in the screenshots you provided, you already have checked the Custom Form setup. Moving on, the concern here appears to be account specific and is difficult to reproduce in our test accounts. Troubleshooting may require looking into your account directly. With that said, we…

You're welcome @User_HWW8S 😀 To import Custom Records, refer to the following SuiteAnswers Article: 9966: Custom Records Import By the way, we would greatly appreciate you clicking the "Yes" button for “Did this answer the question?” on the replies here that helped you which will also help us and the other community…

Hi @User_V5KBL, Upon checking, overriding field values of existing records on Entry Trigger under Before Record Load timing would not be possible as per the Set Field Value Action Guidelines stated in SuiteAnswers Article 11527. See the screen clipping below from the article: The stated limitation has been also…

Greetings @OliverOO, To assist you better, we would like to request screenshots of your existing Workflow setup and the concerned fields on the records involved. Please redact/mask any sensitive information. Also, feel free to add more details that may help us in our testing. -Jack

Hi @User_DATN1, Since we have not received new updates from you, we would now close the related SuiteIdea that you filed and assume that your concerns here have been resolved. Please expect an email from us related to the closure of the SuiteIdea. Thank you! -Jack

Greetings @User_BHLPU, To properly map the lines in the Item Fulfillment to the corresponding lines in the Sales Order, use the hidden 'orderline' field in the IF Sublist as reference to the appropriate SO Line. Note that the value of orderline is 1-based so you may need to subtract 1 from it to become 0-based which can be…

Greetings @User_V5KBL, Thank you for posting a new inquiry here in NetSuite Support Community. We will look into this and will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

Just to confirm, have you followed the same instructions in our post linked below leading to the mass update process? If so, are the updated records now have the ID names according to your naming convention, but the search is still not returning the ID of the last vendor created? -Jack

Hi @User_HWW8S, See our responses below to the additional concerns you encountered: I cannot duplicate your first method since I cannot add the new field in the custom view. As per your latest screenshot, it seems you are in the Edit Mode of the Sales Order. The Customize View button is only available in View Mode. 1. I…

Hi @User_JN952, Have you already run a Mass Update on your existing Vendors before implementing the solution? Also, make sure that the last Vendor Record created has already been set with the naming convention as the search will look into that record. -Jack

Thanks as well for confirming @User_HWW8S. To clarify, you only need to create a single List/Record Field for the purpose of adding a Child Custom Record Sublist to the Sales Order and to establish a parent-child relationship between those 2 records. Therefore, you are free to choose data types for the other Custom Record…

Hi @User_M4JOC, As we suggested, the fields that come with the Required Deposit Workflow feature should be able to address your requirement. But if you are curious about the scenario I brought up, it can be achieved by creating 2 Custom Transaction Line Fields. The first field is the input field of Percent type with the…

Hi @User_HWW8S, Apologies for not getting back to you sooner, as I was out of the office. Anyway, are you asking about adding columns to the Custom Child Record sublist or are you pertaining to adding Transaction Line Fields to the Items sublist on Sales Orders as suggested in the screenshot you shared? -Jack

Greetings @Martha Hakes, We noticed that you have an open support case for this concern. So, we would let the assigned representative on that case investigate since they can troubleshoot this concern better through a Screen-sharing session with you and they also have access to the Internal QA Environment of your account.…

Hi @Nickoletta Gounaris, Were you able to check our latest response above? -Jack

Hi @Sivasubramaniam, Do you still need assistance with this inquiry? If so, we would appreciate you providing the additional information we were requesting in the previous post. -Jack

Thanks as well for the update @User_HWW8S. Now, what do you see under the Parent Records subtab of the ABC Custom Record? Refer to the sample screenshot below: Transaction should be displayed there if you followed the steps correctly. -Jack