Vernita Bronze Trophy

Hi @Camille Cagalingan-Oracle Thank you for the detailed response. This is what I am getting once following the above steps (images are for a demo account and not real data): I cannot see the tab for the period close for a subsidiary even though it has been enabled per the above screencap In the subsidiary settings…

Hi Joy Yes, both the subsidiary and vendor are populated. Edit: I finally got it working! I'm actually not sure where I went wrong. I redid the transactions from scratch and I managed to pair the intercompany purchase order with the sales order. The item appeared in the drop down when I did it again. One of the other…

Hi Joy Thanks so much for your detailed response. I no longer get the "You may not use duplicate accounts on an item" error once the intercompany revenue and expense fields are showing. The issue now is that I cannot see the item when creating a purchase order for the subsidiary CD. I have added two separate income and…

Hi Emilia I was wanting to connect to Openair via another means to the official connector. In this case, the cost of this is prohibitive so I was wanting to know whether it is possible to connect via third party tool?

Hi @Tadas Gasiunas Thanks Tadas for the suggestion. I have found that doesn't work consistently though (I have tried that with different dates). For example, 18th Feb invoice date gives me 20th April due date. (I haven't got it opened in front of me, though I remember taking Feb as an example and using invoice dates from…

Hi @Shamaine Chan-Oracle I have ticked this on one vendor record to test this though it doesn't impact the options available under the CSV import for relationships>vendors. I was looking at similar fields such as address and currency which both appear under the sublist import options for vendor records. However, as pointed…

Hi Michelle I did not click on copy data to sandbox before selecting refresh.. The sandbox account reference was not on the page before I selected the refresh option so I thought it might be a new sandbox account. I can't remember whether the copy data was available as a button. What do I need to do to refresh it now? If I…

Hi Jeff I accessed the site via: https://netsuite.custhelp.com/app/home_oa This was linked on the dashboard of a customer account Hi Sharmaine: I have only started using this account today so I don't know whether it worked before Thanks

@Grant B Thank you! That worked. Hi @Herdi Rana-Oracle . I tried Grant's solution and it works for what I am after. For question 2. though (filtering sublists on a entity tab) I still need a bit of help please. Thanks

Hi Micah Thanks. I was after something more in line with Netsuite's native working calendar, which shows an employee's available hours, without having to create extra entries myself. The placeholder time entries was a workaround I was thinking of to achieve that though I don't want to create entries via a csv import or…

Hi Micah That would create one entry for one employee from what I understand. How do you do this en-masse so there is an entry for each period the employee is set to work? i.e. creating an entry for all the hours they were available to work?

 @Micah Timbol-Oracle Hi. Any updates? My access to Netsuite finishes pretty soon so I was wanting to see if this can be done before then thanks

Could you please provide the screenshot of your script deployment showing the available options under Applies To field? Please navigate the field to show all options starting with "Pr". This is what I get when I try to deploy it:

Please file a case to support team since this is a possible defect. You should have Project Task record as one of the options for deployment. Please also mention the checks that we've done so far. Thanks! Erick Dela Rosa-Oracle Ask A Guru Thanks for all your help. I tried it again in another demo account though came across…

Could you please send the screenshot of your Script record showing the Deployments tab? I selected project since there was no project task option.

Yes, this was already enabled The following is what I get when I try to view the details behind the task record: { * "type": "projectTask", * "id": "271", * -"fields": {* "_csrf":…

Is the Project Management feature enabled in your account? This is necessary to work with project tasks. It's located in Setup > Company > Enable Features > Company subtab > Projects > Project Management. Yes, this was already enabled

Thanks. I have fixed the beforeLoad issue and now I am able to save script. When I deploy it though, I can no longer click into a project record since I get the following error: I have amended the script so it is now: /** * @NAPiversion 2.0 * @NScriptType UserEventScript * @NModuleScope SameAccount */ define ([], function…

You should use the same function name that you're trying to return. Your function name is beforeload while your return is beforeLoad. See the difference? To correct this, you may opt to change the function name to beforeLoad. Furthermore, the code works fine even without specifying N/record in define line. Let us know if…

Thank you for your help Erick. I am getting an error when I try to upload the script: This is the script I am using: /** * @NAPiversion 2.0 * @NScriptType UserEventScript * @NModuleScope SameAccount */ define ([], function () { function beforeload(context) { var serviceItemField=context.newRecord.getSublistField({…

Hello @"New_44789", You'll have to deploy a user event script with beforeLoad. Here's the user event script to make the service item field from the assignee sublist mandatory. The script utilizes the N/record module to get the service item field from the assignee sublist and change it to mandatory. Hope this helps. @"Erick…

Hi Jack Daryl Espiel-Oracle The above post is really useful. I know that this workflow can only be set to work with item sublists. If a field is set to mandatory at the sublist level though, is there a way to enforce that when the sublist is used as part of a form? For example: A project assignee sublist has a field called…

Hi @"New_44789", Thank you for the feedback! To answer your question regarding your given scenario, currently, since SuiteFlow generally supports only the Transaction Item Sublist for all Actions, you may have to use SuiteScript to get your desired result. Also, the Service Item field on the Project Assignee Sublist…

Hi Michelle Any updates on this?

Hi Michelle This permission was already there. I think it was related to the employee's subsidiary being different to the customer's subsidiary. (I will have to have another look...I changed a few things last week though can't remember what it was) It seems to be working now. Thanks

Hi Michelle Thanks for looking into this.

Hi I never got a chance to test Michelle's linked solution. The issue of spam seemed to exist for only a handful of customers. As a result, it was decided that there invoices would be sent separately and not via Netsuite.

Thanks Micah. I tested it again right now and the issue seems to be there in Chrome though not in Firefox.

Thank you Mikko. Right now, I have tested this with another account which has 3 rows of data and found the same issue It seems like the 'pivot' option is no longer working

Hi Micah Apologies for the delay in response and thanks for looking at this. I am trying to replicate this right now. To clarify, in the decode function, are the returned values (11,38,2,37.5,6,37,etc) the work calendar hours by week? e.g. 2 hours available to work for the first week 38 hours for the second week 2 hours…