Hello @Jervin Nicholas Teopengco-Oracle Thank you for your example, it works! Even on beforeSubmit/create, I was able to get the value of discountrate field with the % sign. Thanks.

Thank you for all your support @Francesca Nicole Mendoza-Oracle The problem turned out to be a script altering the duedate field! Sorry for the late response.

Hello, Updating the "Electronic Invoicing" (436209) bundle fixed the issue. Thanks!

Hello @Francesca Nicole Mendoza-Oracle, here is the payload: { "location": 32, "custbody_type_of_document": 1, "custbody_client_inv_style": 1, "item": { "items": [ { "item": 855, "line": 1, "description": "Description", "amount": 55, "rate": 55, "quantity": 1, "department": 31, "custcol_taxcode": "68" } ] }, "currency": 1,…

Hello Veronica, I found the way to show only applied promocodes to the transaction using "Applied Promotion Status" = "Is Applied". Thanks for you help!

Hello Veronica, thank you for your point, but I want to "see" used coupon code by transaction and by line. Hope there is such method.

Hello Veronica, Criteria: Columns: Thanks!

I was able to transform Customer to Vendor and Vendor to Customer using your method. Thank you very much !

Apologies for all the confusion, it turns out we're able to solve our problem by renaming the URLs in a NetSuite field instead of renaming the files themselves, which is much easier to do. We do not need to continue figuring out how to rename all our item image files. Thank you and sorry again for the confusion!

Hello Nicole, the "Map/Reduce script" is selected on the User Event Script's Context filtering.

Hello @Nicole Mendoza-Oracle User Map Reduce is selected on the Execution Context, only Web Application & Web Store are not checked which are not applicable here.

I'm trying with Mass Update Script but without success: /** /** @NApiVersion 2.1 * @NScriptType MassUpdateScript */ define(['N/record', 'N/log'], (record, log) => { /** * Defines the Mass Update trigger point. * @param {Object} params * @param {string} params.type - Record type of the record being processed * @param…

Hello @Jack Daryl Espiel-Oracle Our use case is that we have a large number of entities that should be present at the same time, such as customers and vendors. Initially, they are created as customers, and then they become Vendors and we want to convert the Customer to a Vendor.

UPDATE: I found way to print locationaveragecost & lastpurchaseprice by location but now I want to have these by accounting book. When I compare the information from the Inventory Evaluation Report by accounting book it should return the same results in the query while now it only returns the Primary book information.…

Thank you for your answer! Is there another way to put only specific items on sale? For example some screen / Suitelet that can update the prices in bulk. Thanks!

Hello Gurus, I experimented more with the SuiteQL, so this simple query on the Transaction: SELECT Item.ID AS itemId, Item.isFulfillable AS isFulfillable FROM Transaction INNER JOIN TransactionLine ON ( TransactionLine.Transaction = Transaction.ID ) INNER JOIN Item ON (Item.ID = TransactionLine.Item) WHERE (Transaction.ID…

Hello Leonard, thank you for looking at this. We're on SuiteCommerce 2021.1 V2. Thanks !

Leonard, you are awesome ! It works! Thanks !

Thank you for your reply Mikko! My general question is: Is SuiteQL still BETA feature? Can I use it in production? Thanks!

Thanks @Jeff Pineda-Oracle I was able to configure it !

Hello Jeff, We are using "Standard" checkout steps. Here is our SuiteCommerce Version: Regarding the SuteAnswer 61634: I found the files for the "Custom Checkout" SSP application from step 1A, Navigate to File Cabinet and find the Custom Checkout (2.05.0) SSP Application. the only difference here was our module version is…

Q:Can you specify which SCA version you are currently using? A:We are using SuiteCommerce 2020.1 (Bundle Version 2020.1.12) Q:Additionally, what type of checkout page are you using, one-page or three-page? A:I'm not sure what are we using. Can you point me on how to check what is the type of the checkout page? Thank you !

Hello Jeff, I'm using "gulp local --to". I also deleted all my tokens and after recreating them the issue still persist. I will file the Support ticket for this. Thank you.

Hello @Jeff Pineda-Oracle , let me know when you have any updates on this. Thanks!

Thank you Erick, it's working ! SuiteQL is wonderful! I can see the accounts on each line of Transaction ID = 41892 SELECT TransactionAccountingLine.Account FROM Transaction INNER JOIN TransactionAccountingLine ON ( TransactionAccountingLine.Transaction = Transaction.ID ) WHERE ( Transaction.ID = 41892)

Thanks ! Now it makes sense !

Hello Erick, I'm fine, thanks! The results we are seeing in SuiteScript are raw and unrounded values. You can use the JavaScript toPrecision() method to round values similar to what we can see in the UI. I never had to round or precise the numbers coming from the Saved Search when the field type is Formula (Currency). The…

I see my display name correctly now.

I found the problem I need to use N/https instead of N/http module, now everything is working.

Hello Mikko, I changed my profile display name, but it's still didn't show up. I tried different browser and I have still same issue. Here is more information: urlObj.resolveScript is resulting to "/app/site/hosting/scriptlet.nl?script=551&deploy=1&compid=TSTDRVXXXXXXX&custparam_sid=5" which is correct http.get got…