Ad Hoc Testing is a software testing technique where the tester performs testing in an unstructured and informal manner without following any predefined test plan or test case. The term “ad hoc” means “for a specific purpose” or “improvised,” and therefore, ad hoc testing is also known as improvisational testing or exploratory testing. Ad hoc… Continue reading Ad Hoc Testing
Month: March 2023
What are Media Queries in SCA
In the context of SuiteCommerce Advanced (SCA), media queries are used to create responsive web designs that adapt to different screen sizes and devices. Media queries allow developers to specify different styles for different devices or screen sizes by applying CSS styles only when certain conditions are met. Media queries in SCA are typically written… Continue reading What are Media Queries in SCA
SuiteQL to generate a Customer saved search in Power BI via ODBC connector
The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a Customer saved search in Power BI via ODBC connector
Netsuite – Repairdesk Integration – Proposal
Requirement: Need to implement integration between NetSuite and Repair desk to automatically create purchase order in Repair desk for the sales order in NetSuite. Solution: We will develop 3 Restlet scripts to provide the Repair Desk team with the custom API endpoints for customer authentication, PO creation and inventory creation in Repair Desk. Customer Authentication: … Continue reading Netsuite – Repairdesk Integration – Proposal
Call Suitelet by url
var url = ‘/app/site/hosting/scriptlet.nl?script=customscript_jj_po_rejection&deploy=customdeploy_jj_po_rejection’; The URL ‘/app/site/hosting/scriptlet.nl?script=customscript_jj_po_rejection&deploy=customdeploy_jj_po_rejection’ assumes that your Suitelet script has an ID of customscript_jj_po_rejection and a deployment ID of customdeploy_jj_po_rejection. You’ll need to replace these values with the actual IDs of your Suitelet script and deployment. You can find these IDs in the script deployment record or in the URL of the… Continue reading Call Suitelet by url
PART 4.2 – Financial Statement Creation
You need both the Financial Statements permission and the Report Customization permission to access the Financial Report Builder. You can access the Financial Report Builder in any of the following ways: Run a financial statement, and on its results page, click Customize. Go to Reports > New Financial Report, and select a financial statement type… Continue reading PART 4.2 – Financial Statement Creation
PART 4.1 – The outline layout of Financial Statement Reports
Income Statement Report The standard Income Statement includes the following rows: Ordinary Income/Expense (header row) Income (financial section) Cost of Sales (financial section) Gross Profit (formula row) Expense (financial section) Net Ordinary Income (summary row) Other Income and Expenses (header row) Other Income (financial section) Other Expenses (financial section) Net Other Income (summary row) Net… Continue reading PART 4.1 – The outline layout of Financial Statement Reports
PART 4 – The Core 3 Financial Statements Compared
Balance Sheet Income Statement Statement of Cash Flow Purpose Net Worth Profitability Liquidity & Solvency Reporting Period As of Point in Time For the Period Ended For the Period Ended Elements – Assets– Liabilities– Equity – Revenue– Gains– Expenses– Losses– Net Income – Beginning Cash Balance– Sources of Cash– Uses of Cash– Ending Cash… Continue reading PART 4 – The Core 3 Financial Statements Compared
PART 3.5 – Cost of Goods Sold (COGS) GL Impact
COGS are not expense accounts, but they function like an expense. These are the costs directly associated with the sale of goods or services. This includes the cost of the product for resale, raw materials, packaging, etc. General selling expenses, such as salaries, rent, utilities, and advertising expenses, are not considered part of the cost… Continue reading PART 3.5 – Cost of Goods Sold (COGS) GL Impact
PART 3.4 – Bank Transaction GL Impact
Bank deposits are when the payment received from the customer is deposited into a bank account. This will increase the bank’s funds and decrease the undeposited fund accounts. Writing checks occurs when businesses issue checks as payment for items they purchase or any type of payables. The GL impact will show a decrease in the amount of… Continue reading PART 3.4 – Bank Transaction GL Impact