Date conversions/considerations using SQL formula
Month: March 2023
Restrict edit of sublist fields in Client script:
You can use the validateLine event in your client script to prevent users from adding lines when certain conditions are met. The function you use simply needs to return a Boolean value: true if the line addition can continue, false if it should not. Similarly, there is a validateDelete event you can use to prevent… Continue reading Restrict edit of sublist fields in Client script:
Proposal For Check the adding the possibility for Reviews in the Product items
This proposal will include the possibility of adding product reviews to the N&P website with the design. Requirement The client would like to require SCA Review functionality to be reimplemented and restructured to fit the design of the current N&P website. Deliverables We can update the development files for this implementation in the Suite Commerce… Continue reading Proposal For Check the adding the possibility for Reviews in the Product items
Quote Approval workflow for a specific User
ScenarioThe client wants to set up a process in NetSuite that requires approval from a specific user (Approver) before any quotes are created by a specific user (Creator). The submit for Approval button is displayed for the Creator ( In all roles the creator is able to use the Submit for Approval button) and this… Continue reading Quote Approval workflow for a specific User
FAM custom record permission levels for a custom role
The custom record permissions related to Fixed Asset Management for the custom roles with full access to FAM transactions and processes are: BG Process Instance Full BG Process Log Full BG Queue Instance View BG Summary Records Full FAM Alternate Depreciation Full FAM Alternate Methods Full FAM Asset Full FAM Asset Proposal Full FAM Asset… Continue reading FAM custom record permission levels for a custom role
Change color of bullet color of a list in HTML
By default,Color of bullet in unordered list is black and we can’t change the color of bullet using list style properties. By setting some css properties ,it is possible to change color of list item. Following example demonstrate how to set color for bullet of a list item. First we change ” list-style” property to… Continue reading Change color of bullet color of a list in HTML
Test case documentation : -Script/automation to set the “Integration status” of SPS Sales orders.
Requirement For a sales order to be delivered to Stord for fulfilment, the partner “SPS commerce”Integrations status” field must be set to “Ready.”The script should automatically set the Integration status as “Ready” IF -Created by Partner = “SPS Commerce” -Integration status” = null -All the items in the order have committed quantity = ordered quantity… Continue reading Test case documentation : -Script/automation to set the “Integration status” of SPS Sales orders.
Quantity-Based Item Pricing
To enable quantity pricing: Go to Setup > Company > Enable Features. On the Transactions subtab, check the Quantity Pricing box. Click Save. After you enable the feature, you should set your accounting preferences for quantity pricing. To set quantity pricing preferences: Go to Setup > Accounting > Preferences > Accounting Preferences. Click the Items/Transactions subtab. In the Maximum # of Quantity-based Price Levels field, enter… Continue reading Quantity-Based Item Pricing
PROPOSAL FOR MODIFYING TASTING NOTES ON THE ITEM DETAIL PAGE
Proposal Summary This proposal covers the modifying tasting notes on the item detail page and sort option based on the tasting date or score. Requirement N&P have requested that Tasting Notes appear on the Item Details page will displayed in expandable box, and a new ‘Top Tasting Note’ checkbox will be added to the Tasting… Continue reading PROPOSAL FOR MODIFYING TASTING NOTES ON THE ITEM DETAIL PAGE
Sync Item images between Shopify and NetSuite
The NetSuite Item to Shopify Product Add/Update and NetSuite Matrix Item to Shopify Product Add/Update integration flows have been enhanced to accommodate adding or updating product images along with other product details. A new field mapping has been added in both the flows to support this feature . Note: Images are not exported by default. Clearing an… Continue reading Sync Item images between Shopify and NetSuite