According to standard NetSuite process, the P&L accounts in the adjustment period will not be considered when executing the intercompany elimination of the base period. #553390 Intercompany Transaction posted on Adjustment Period > Run the Eliminate Intercompany Transactions task in a Non-adjustment Period > Transaction Not Eliminated. This enhancement offers the solution of Creating manual… Continue reading Elimination of P&L account in Adjustment Period
Month: November 2024
VLOOKUP function explained with example
The VLOOKUP function is used to search for a value in the first column of a range and return a value in the same row from another column. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Parameters: lookup_value: The value you want to search for. table_array: The range of cells containing the data. col_index_num: The column number in… Continue reading VLOOKUP function explained with example
Show multiple rows of the same sales order when viewing the sales order list from the Customer Center
Scenario Show multiple rows of the same sales order when viewing the sales order list from the Customer Center. Solution Login as an Administrator Navigate to Setup > Users/Roles > Manage Roles Custom Customer Center role: Click View Click Searches Click Standard Transaction: List View: Take note of the selected saved search Navigate to Lists > Search > Saved Searches Saved Search noted from step 6: Click Edit Click Criteria Filter: Select Main… Continue reading Show multiple rows of the same sales order when viewing the sales order list from the Customer Center
Unable to Enter Sales Order in the Customer Center
Scenario By default, the Customer Center has Permissions > Transactions > Sales Order = Edit. This lets users Create or Edit an existing Sales Order that they have created. In instances that the Standard Customer Center role or a Custom Customer Center role is unable to Enter a Sales Order, user can test the steps… Continue reading Unable to Enter Sales Order in the Customer Center
Steps for Configuring GST Under Reverse Charge:
1. Identify Scenarios for Reverse Charge Reverse charge applies to specific goods/services as per GST law, including: Unregistered vendors supplying services or goods. Import of services or goods notified under reverse charge. 2. Configure Tax Codes and Rates 3. Set Up Tax Types 4. Define Tax Rate Rules Navigate to: Setup > India Localization >… Continue reading Steps for Configuring GST Under Reverse Charge:
What is EAV Model in Magento 2?
EAV, for those who don’t know, stands for Entity Attribute Value, which a data model used in Magento 2. Entity: it’s responsible for storing data. Attribute: It’s a separate property of an entity like name, gender, email address, etc. Value: It’s basically the value of an entity and attribute. Together, the EAV structure helps to get flexibility for… Continue reading What is EAV Model in Magento 2?
How do I connect to a remote server using SSH in Linux?
To connect to a remote server using SSH in Linux, follow these steps: Open your terminal. Run the SSH command: ssh username@server_ip_or_hostname Replace username with your server’s username and server_ip_or_hostname with the IP address or hostname of the server. For example: ssh root@192.168.1.100 If prompted, enter the password for the specified user.
The requested resource was not found error while trying to use a NetSuite Link externally
If we use url.resolveRecord(options) to generate a record URL and attempt to access it externally, such as from an email, we may encounter an error like: 404 Not Found The requested resource was not found. This occurs because the generated URL does not include the domain. To avoid this, we should create the record URL using the… Continue reading The requested resource was not found error while trying to use a NetSuite Link externally
Saved Search that shows Work Orders and Component Items
Scenario User needs to create a saved search that would show the Work Orders and Components (Member Items) that were used in each. Solution This can be done by doing a simple Transaction Saved Search. Here are the details: Criteria tab: Type = Work Order Main Line = False COGS Line = False Tax Line = False… Continue reading Saved Search that shows Work Orders and Component Items
TIPS AND TRICKS
Searching All Data in Your Account Press Alt + G to move your cursor directly into the Global Search field. Entering Data Most subtabs have a letter underlined, hold Alt and type that letter to jump to that subtab. In the Header section of the transaction, press Enter to save the transaction. In the Transaction Line section, press Enter to save the line… Continue reading TIPS AND TRICKS