Mikko De La Fuente-Oracle

Apologies for late response, @User_SZ0C3. That is the standard process on how to deal with discount as per the SuiteAnswers Article. You may want to double check your process when using SOAP for Customer Payments. -Mikko

in How to calculate the invoice discount correctly after Invoice payment via WS? Comment by Mikko De La Fuente-Oracle Nov 17, 2022 12:01PM

Hi @ssilveri777 , do you still need assistance on this concern? -Mikko

in How to use BUILTIN.PERIOD in SuiteQL? Comment by Mikko De La Fuente-Oracle Nov 17, 2022 11:55AM

If the desired value does not appear on tables available, you then have to modify the query to achieve the desired value. For instance, running total from the beginning of time as you have mentioned. -Mikko

in How do I get a GL Balance for an asset account in JDBC Netsuite2.com? Comment by Mikko De La Fuente-Oracle Nov 17, 2022 11:54AM

You have to include the tax fields in the payload when working with REST API. Does trying this payload works on your end? -Mikko

in Why Tax Transaction Type not set on transactions loaded via REST API? Comment by Mikko De La Fuente-Oracle Nov 17, 2022 11:51AM

Have you coordinated with the bank about the public/private keys? You may check the previous comments for the related articles on the topic. -Mikko

in How to upload SSH Key for SFTP Connector SuiteApp? Comment by Mikko De La Fuente-Oracle Nov 17, 2022 11:42AM

You can check again the role of the user for web service to not be using 2FA since the current custom role falls to user that requires 2FA. Then, if you are starting with the TBA integration record, you should be considering the Authorization Flow instead of issuetoken endpoint. You can still achieve your goal through REST…

in Why the User Can't Connect through REST Web Service? Comment by Mikko De La Fuente-Oracle Nov 17, 2022 11:39AM

Hi Chris @HertsChris , Thank you for posting again in the community! Our gurus/members will look into your concern and update for any findings. To everyone, feel free to share your thoughts! -Mikko

in How can I Print Statement in Customer Centre Comment by Mikko De La Fuente-Oracle Nov 14, 2022 4:50PM

Hi @FazeprooF , Thank you for posting in the community! Please allow some time for the gurus/members to look into your concern and get back with more information. To everyone, feel free to share your thoughts! -Mikko

in How to resolve incorrect Wave Template Results? Comment by Mikko De La Fuente-Oracle Nov 14, 2022 4:49PM

Hi @John Robertson Sr. , you can check this SuiteAnswers article then search "ADM1019SES" or you can simply click this link. Please do let us know if you still cannot access it. Thank you for sharing, @Lea Celosa Columna ! -Mikko

in Admins - Best "Hack" or Tip Comment by Mikko De La Fuente-Oracle Nov 14, 2022 3:41PM

For the builtin.period, you have to make use of it in the select statement. For example: SELECT BUILTIN.PERIOD('LM', 'END', 'NOT_LAST', '<') FROM revenuePlanPlannedRevenue You may also check this external article for your reference. -Mikko

in How to use BUILTIN.PERIOD in SuiteQL? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 11:16PM

Do you still need further assistance on this, @Vernita ? -Mikko

in Suitescript to lookup item sublist Comment by Mikko De La Fuente-Oracle Nov 11, 2022 10:46PM

Did we answer your concern, @User_FHYZH ? If yes, we encourage you to click the "Yes" button on the "Did this answer this question?" -Mikko

in How to upload SSH Key for SFTP Connector SuiteApp? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 10:45PM

Hi @User_7D2KD , do you still need assistance on this concern? -Mikko

in How to add or delete user In Farapp Connector Account ?. Comment by Mikko De La Fuente-Oracle Nov 11, 2022 10:37PM

Hi Jenny, Since you have enabled taxdetailsoverride, you have to manually set the tax fields in the payload when submitting the request. See reference for the available tax fields in REST Web Service. -Mikko

in Why Tax Transaction Type not set on transactions loaded via REST API? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 10:34PM

Hi @ssilveri777 , Apologies for delayed response. You may use the tables(transaction,transactionline,transactionaccountingline) in NetSuite2.com to get similar data from ACCOUNT_PERIOD_ACTIVITY. To get the desired data, you have to manipulate the query based from your requirements. Let us know if this helps. -Mikko

in How do I get a GL Balance for an asset account in JDBC Netsuite2.com? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 10:23PM

Would you be able to provide the UE script that contains the HTML script? Also, have you used a single class "collapsible" for the 2 fields you are trying to customize? Additionally, we do not advise to directly use DOM for customizing the record. We only advise to use native SuiteScript APIs for customization. See article…

in How to Truncate a Text Box - Custom Transaction Body Field? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 10:13PM

Después de la verificación, los campos HTML en línea solo aparecen en el modo de vista del formulario y siempre están ocultos en el modo de edición.

in Campo personalizado de línea de transacción - NO SE MUESTRA en la sublista Comment by Mikko De La Fuente-Oracle Nov 11, 2022 9:55PM

Hay un artículo relacionado con eso: SuiteAnswers 87998 - Exportar como archivo CSV los resultados de búsqueda guardados a un archivador a través de un script programado usando SuiteScript 2.0.

in Script programado para actualizar CSV en el archivador Comment by Mikko De La Fuente-Oracle Nov 11, 2022 9:51PM

Apologies for the delayed response. Upon further checking, the permissions in the web services role has permissions that requires 2FA. See articles for all the permissions requiring 2FA. Also, since you are creating new integration, it is advisable to make use of the Authorization Flow instead of the issuetoken endpoint.…

in Why the User Can't Connect through REST Web Service? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 4:07PM

Hi @User_DM8HY , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. To everyone, feel free to share your thoughts! -Mikko

in Is Avatax the only option for SuiteCommerce In-Store (SCIS)? Comment by Mikko De La Fuente-Oracle Nov 11, 2022 3:28PM

Hi @User_IGIY3 , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. To everyone, feel free to share your thoughts! -Mikko

in Is Cash 360 - Cash Forecast customizable to include Journal Entries? Comment by Mikko De La Fuente-Oracle Nov 9, 2022 3:21PM

Hi Richard @Richard Appleford OB , Thank you for posting in the community! Our gurus/members will look into your concern and get back for any updates. To everyone, feel free to share your insights! -Mikko

in Why can't we create an Opportunity from a Lead? Comment by Mikko De La Fuente-Oracle Nov 9, 2022 2:38PM

Could you clarify what environment are you using? (Production/Sandbox/Test Account) Also, how did you generate the signature? Would it be possible to share the integration record? Please exclude confidential information. -Mikko

in Why the User Can't Connect through REST Web Service? Comment by Mikko De La Fuente-Oracle Nov 8, 2022 9:43PM

May we ask what application are you using? Have you tried testing this on POSTMAN? See article on how to test with POSTMAN. -Mikko

in Sandbox account error "SOAPFault: (soapenv:Server.userException) Invalid login attempt" Comment by Mikko De La Fuente-Oracle Nov 8, 2022 5:38PM

For Basic Support Type of an account, that is correct. However, if the account you are handling is using different support type, then you can submit a case. Upon further checking on this, it seems deleted entity records could be the reason you are receiving such error. See article for reference. -Mikko

in Why am I receiving multiple script errors on EFT Payment bank fees? Comment by Mikko De La Fuente-Oracle Nov 8, 2022 5:24PM

Hi @User_7D2KD , would you be able to submit a case to support team? They would be happy to assist you with your concern about the users in your farapp account. -Mikko

in How to add or delete user In Farapp Connector Account ?. Comment by Mikko De La Fuente-Oracle Nov 8, 2022 4:52PM

Hi @Strategit_Shunta4 , it seems your concern falls on the enhancement # 400424 - Client Script> Add parameter to identify if sublist data was copied using Make Copy or Copy Previous button. You may submit a case to support team or visit SuiteIdeas to add a vote. -Mikko

in How to prohibit the "Make Copy" on the PO line? Comment by Mikko De La Fuente-Oracle Nov 8, 2022 4:34PM

Hi @User_5IZEI , would you be able to provide a sample screenshot for the expected vs an actual results? Also, you mentioned, only one expands and not the two fields, have you tried doing it individually and separately for testing? Additionally, have you looked in the ids of the fields affected? -Mikko

in How to Truncate a Text Box - Custom Transaction Body Field? Comment by Mikko De La Fuente-Oracle Nov 8, 2022 4:29PM

Hi @PaulFleetwood , Thank you for posting again in the community! Please allow some time for the gurus/members to look into your concern and update you for any findings. To everyone, feel free to share your thoughts! -Mikko

in Is there an option to change the default naming of Transaction PDF Email Attachments? Comment by Mikko De La Fuente-Oracle Nov 8, 2022 3:20PM

Hi Oliver @OliverK , Thank you for posting again in the community! Please allow some time for the gurus/members to check on this and get back with more information. To everyone, feel free to share your thoughts. -Mikko

in Why is a certain Custom List/Record Item Field not available on Transaction Search? Comment by Mikko De La Fuente-Oracle Nov 8, 2022 3:19PM

Mikko De La Fuente-Oracle · SuiteCloud Support · Gold Crown

Comments