convert scientific numbers to show their full amount; this method also allows you to retain the appearance of text in case you have a mixed list of text and numbers in scientific notation format. There are a number of ways to do this and what you should use depends on your dataset. Convert Using a… Continue reading Convert Scientific Notation to Numbers in Excel
Month: July 2022
Split the discount into Wallet Refund, Donation and Cart Discount Item in Sales Order
Split the discount into Wallet Refund, Donation and Cart Discount Item in Sales Order
Possibility of Stay visible search bar for Second Source Rx-USA-NS/SCA
Requirement Search Bar – Is it possible to have the search bar stay visible, rather than have the customer need to click the magnifying glass? If so, we would like to make this change. Solution and Comments As per the requirement, we’ll make the search visible every time. And it’ll not be needed to click… Continue reading Possibility of Stay visible search bar for Second Source Rx-USA-NS/SCA
Invalid left-hand side in assignment: SuiteCommerce Advanced Elbrus
For resolving this open package.json and make sure that the following dependencies are added “dependencies”: {………“xmlbuilder”: “11.0.0”,“xml2js”: “0.4.5”,“yargs”: “1.3.1”,“credentials-inquirer”: “file:./ns_npm_repository/credentials-inquirer”,“suitetalk”: “file:./ns_npm_repository/suitetalk4node”,“preconditions”: “file:./ns_npm_repository/preconditions”}, Delete the node_modules and LocalDistribution folders and run npm install again
Create MultiBook Accounting Transaction Saved Search With No Secondary Book GL Entries
Create a Multi-Book Accounting Transaction Saved Search that shows records that have no Secondary Book G/L entries. Navigate to Lists > Search > Saved Searches > NewClick Multi-Book Accounting TransactionSearch Title : Enter Title Example : Transactions without Secondary Book G/L EntriesClick CriteriaUnder Standard subtab, add the following fields: Select Accounting Book Accounting Book : Select any of Multi-Select Field : Click Secondary Book Select Account Account : Select any of Multi-Select Field : Click –… Continue reading Create MultiBook Accounting Transaction Saved Search With No Secondary Book GL Entries
How to upload a video in Magento block?
Form Customization for Cash Sales using Workflow
Scenario: Create a new customer in NetSuite with the name “Walking Customer KM” for the Cash sale form and populate the customer name in the form for cash sale for the role “KM Role“.Change the value for the field location from “Corniche” to “Km-Yallatoys_MOQ“ Solution First, create a new customer in Netsuite. Go to List>… Continue reading Form Customization for Cash Sales using Workflow
Permissions set up for GL Matching
GL Matching dashboard and GL Matching List of accounts permission set up.
Apply Currency Filter for Custom Field
Requirement – Created a custom transaction line field for Landed Cost templates. This field should only show the Landed Cost templates of the items with the same currency as the PO currency Solution – The filter can be applied to the custom field setup itself. Under the Sourcing and Filtering subtab, select currency in the… Continue reading Apply Currency Filter for Custom Field
Customer Item Pricing Hierarchy in Saved Searches
The customer search for the unit price of items shows the item prices based on the Netsuite system logic on a certain priority. This is the same logic as the default item price in the sales orders. The Hierarchy being followed is: The Item unit price will be based on the Price Level set on… Continue reading Customer Item Pricing Hierarchy in Saved Searches