Scenario This article shows the GL Impact of Drop Ship Items on Transactions Solution 1. On Cash Sale/Invoice: Debit: Cash or Accounts Receivable Credit: Sales 2. On Vendor Bill: Debit: Cost of Goods Sold Credit: Accounts Payable Note: There is no effect on the Inventory Asset Account. Furthermore, Item Receipt/Fulfillment has no GL… Continue reading GL Impact of Drop Shipped Items
Month: April 2024
Deleting a Portlet from a Dashboard
There are three ways to remove portlets: Click Remove in the portlet menu. Click the portlet icon in the Currently Used tab of the Personalize Dashboard palette. As you move your pointer over the portlet icons, the corresponding portlet on your page is outlined. Click Personalize Dashboard in the Settings portlet or the Personalize link in the top right corner of the page.… Continue reading Deleting a Portlet from a Dashboard
Adding a Portlet to a Dashboard
Click Personalize Dashboard in the Settings portlet or the Personalize link in the top right corner of the page. The Personalize Dashboard palette opens at the top of the page. When you click the Currently Used tab, you can see portlets that already appear on your dashboard. If you hover over a portlet in the Currently Used tab, that portlet is highlighted on your dashboard.… Continue reading Adding a Portlet to a Dashboard
Resolve Error: “Please choose item to add” when Updating Cash Sale and Invoice via CSV Import
User is encountering an error message: Please choose item to add when performing Cash Sale and Invoice CSV Import Update if the transaction lines being updated include a non-item transaction line such as Tax Line, Shipping Line and Cost of Sales Line. Solution Open CSV file Remove Tax Line, Shipping Line, and Cost of Sales… Continue reading Resolve Error: “Please choose item to add” when Updating Cash Sale and Invoice via CSV Import
How to Remove Primary contact name from Bill to Address in the PDF print
To achieve this, follow these steps: Navigate to Setup > Company > General Preferences. Unmark or uncheck the preference labeled “Add Primary Contact to Bill To Address”. Click “Save” to apply the changes.
Localization Context Filtering in SuiteCloud Development Framework (SDF)
SuiteCloud Development Framework (SDF) offers robust support for localization context filtering in SuiteScript 2.0 user event and client scripts. Localization context refers to the country or countries associated with a specific record. By leveraging localization context filtering, developers can precisely control where their scripts execute, based on the localization context of records. Setting Up Localization… Continue reading Localization Context Filtering in SuiteCloud Development Framework (SDF)
Configuring Map/Reduce Interruptions Handling
Map/reduce scripts are susceptible to interruptions, whether from application server disruptions or uncaught errors. To manage these interruptions effectively, the system provides two configuration options: retryCount and exitOnError. Let’s delve into each option to understand how they can fine-tune your script’s response to interruptions. retryCount The retryCount option impacts the map and reduces stages exclusively.… Continue reading Configuring Map/Reduce Interruptions Handling
Simplifying Deposit Application Creation
Upon editing and saving an invoice, NetSuite automatically checks if there’s a linked custom deposit for the associated sales order. If such a deposit exists, the system proceeds to mark the invoice as paid in full by generating a deposit application custom record. Here’s how the process unfolds: Edit and Save Invoice: Users simply load… Continue reading Simplifying Deposit Application Creation
Calculating Total Credit Amount in GL Impact
In financial management systems, accurately tracking credit amounts within general ledger impacts is essential for maintaining financial transparency and integrity. The following code snippet facilitates the calculation of the total credit amount for specific revenue accounts within the GL impact: var totalCreditAmount = 0; // Initializing total credit amount // Iterating through standard lines in… Continue reading Calculating Total Credit Amount in GL Impact
Identifying Items with Missing Expiration Dates in Lot Numbered Inventory – Using NetSuite Script
Description: Utilizing SuiteScript within NetSuite, we’ve developed a script to locate inventory items lacking expiration dates. Here’s the breakdown: Script: let itemSearchObj = search.create({ type: “item”, filters: [ [“inventorynumber.expirationdate”,”isempty”,””], “AND”, [“islotitem”,”is”,”T”], “AND”, [“isinactive”,”is”,”F”], ], columns:… Continue reading Identifying Items with Missing Expiration Dates in Lot Numbered Inventory – Using NetSuite Script