If a user need to create a transaction search to list out the sales orders which do not have any back ordered quantity in the line items, use the formula given below. case when {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) > 0 then 1 else 0 endEnter 0
Month: March 2023
Search formula to find the latest date among the three dates
Scenario: If we need to find the latest date/the recent date among the three dates in a saved search, use the following formula in the search criteria. Formula(Date): CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_second_expiry_date},{custrecord_project_first_expiry_date})) THEN (CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_third_expiry_date},{custrecord_project_first_expiry_date})) THEN {custrecord_project_first_expiry_date} ELSE {custrecord_project_third_expiry_date} END) ELSE (CASE WHEN ({custrecord_project_second_expiry_date}>= NVL({custrecord_project_third_expiry_date},{custrecord_project_second_expiry_date})) THEN {custrecord_project_second_expiry_date} ELSE {custrecord_project_third_expiry_date}END )END
An error occurred during custom object validation
The given image shows that when we are ‘Add Dependency References to Manifest’, while we are trying to deploy objects to a new account, there may cause an error like ‘The object reference [scripid=scriptid] is missing in the project and also not included in the dependencies list’. This is because the ‘scriptid’ used in the… Continue reading An error occurred during custom object validation
Total Tax rates from invoices using saved search (Line total)
The Total tax rates from invoices or sales orders can be calculated using the formula: Total tax rate: ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘State’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘County’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 1’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype}… Continue reading Total Tax rates from invoices using saved search (Line total)
Incremental Model
Incremental Model is a process of software development where requirements divided into multiple standalone modules of the software development cycle. In this model, each module goes through the requirements, design, implementation and testing phases. Every subsequent release of the module adds function to the previous release. The process continues until the complete system achieved. The… Continue reading Incremental Model
Test sigma and Testing Whiz
Testsigma is a cloud-based test automation platform that allows software testing teams to create, execute and manage automated tests for web, mobile, and desktop applications. It offers a codeless testing approach where users can create test cases using natural language, making it easy for non-technical team members to create and run automated tests. Testsigma uses… Continue reading Test sigma and Testing Whiz
Laravel Artisan Cache Commands
1. Configuration Cache Caching configuration helps with combining all of the configuration options for your application into a single file which will be loaded quickly by the framework. Clearing Configuration Cache However, if you notice changes to the configuration values in .env file is not reflecting on your application, you may want to consider clearing the configuration… Continue reading Laravel Artisan Cache Commands
Editing the Amounts and Accounting Periods in an Amortization Schedule dynamically.
Editing the Amounts and Accounting Periods in an Amortization Schedule dynamically.
Proposal For BlueScope Integration With NetSuite
PROPOSAL SUMMARY This proposal outlines the scope of purchase order integration from NetSuite to BlueScope and the limitations and drawbacks of this integration. REQUIREMENT BlueScope team needs to integrate NetSuite with BlueScope for creating purchase orders based on the data provided from the NetSuite on a scheduled basis. DELIVERABLES We will be sending the purchase… Continue reading Proposal For BlueScope Integration With NetSuite
Proposal For Listing Transactions based on Serial Number of Inventory
Proposal Summary This proposal describes listing of transaction details related to the serial number of inventories. Requirement Nuvara would like to list and display all the transactions associated with the Serial number of inventories. Deliverables A custom page will be provided for user that would list the transactions based on the serial number of inventories.… Continue reading Proposal For Listing Transactions based on Serial Number of Inventory