Author: Linu Paul
Create a search to show the results based on sales rep’s supervisor is current user
Script var customrecord_jj_commission_report_phrin6SearchObj = search.create({ type: “customrecord_jj_commission_report_phrin6”, filters: [ [“custrecord_jj_approval_status_id”,”anyof”,”3″], “AND”, [“isinactive”,”is”,”F”], “AND”, [“custrecord_jj_sales_rep_name.supervisor”,”anyof”,”@CURRENT@”] ], columns: [ search.createColumn({name: “custrecord_jj_commission_year”, label: “Year”}), search.createColumn({name: “custrecord146”, label: “Month”}), … Continue reading Create a search to show the results based on sales rep’s supervisor is current user
How can we convert a search based on ‘Label’
First added the library /Libraries/JJ CM NS Utility’ let searchConfig = { PAGE_INDEX: false, PAGE_SIZE: 1000 }; let salesorderSearchObj… Continue reading How can we convert a search based on ‘Label’
Navigation for the FAM records
FAM Asset creation: Fixed assets – lists – assets – new FAM Asset Proposal creation: fixed assets – transactions – Manage Asset Proposal; Go to more options in the top right corner. Go to Asset Proposal List FAM Asset Depreciation Method creation: Fixed assets – setup – depreciation methods FAM Asset type creation: fixed assets… Continue reading Navigation for the FAM records
How to delete a FAM Asset record
In the FAM Asset record, under ‘General’ tab, there is a list field named ‘Depreciation Active’. Make the list field as false and delete it
Validation script for CSV import
/** * @NApiVersion 2.1 * @NScriptType UserEventScript */ /************************************************************************************************************************* * * Grand Appliance-US-NS * * GRAUN-12 | Validation script for avoiding Duplication of Custom records ********************************************************************************************************************* * * Author: Jobin & Jismi * * Date Created : 26-July-2024 * Created By: Linu Paul, Jobin and Jismi IT Services * * Description : The validation on… Continue reading Validation script for CSV import
Validation script for avoiding duplicate entries into custom records
/** * @NApiVersion 2.1 * @NScriptType ClientScript * @NModuleScope SameAccount */ /************************************************************************************************************************* * Grand Appliance-US-NS * GRAUN-12 | Validation script for avoiding Duplication of Custom records ********************************************************************************************************************* * * Author: Jobin & Jismi * * Date Created : 14-March-2024 * Created By: Linu Paul, Jobin and Jismi IT Services * * Description : The… Continue reading Validation script for avoiding duplicate entries into custom records
EFT Template Sample
<#– function definitions –> <#function getReferenceNote payment> <#assign paidTransactions = transHash[payment.internalid]> <#assign referenceNote = “”> <#assign paidTransactionsCount = paidTransactions?size> <#if (paidTransactionsCount >= 1)> <#list paidTransactions as transaction> <#if transaction.tranid?has_content> <#if referenceNote?has_content> <#assign referenceNote = referenceNote + “, ” + transaction.tranid> <#else> <#assign referenceNote = transaction.tranid> </#if> </#if> </#list> </#if> <#return referenceNote> </#function> <#function convertSEPACharSet text>… Continue reading EFT Template Sample
If the script runs every Monday, how can we determine the dates for the upcoming Thursday and Wednesday?
let today = new Date(’06/24/2024′); // Monday let dayOfWeek = today.getUTCDay(); // 0 (Sunday) to 6 (Saturday) // Calculate the coming Thursday let daysUntilThursday =… Continue reading If the script runs every Monday, how can we determine the dates for the upcoming Thursday and Wednesday?
Inventory Worksheet
To import new quantities we can use Adjust inventory worksheet import . I have updated the inventory quantity by importing the inventory worksheet. Navigation Transactions > Inventory > Adjust Inventory Worksheet > Import By using the Inventory Worksheet, the entire quantity is replaced with the new quantity. By using a single CSV file, we can… Continue reading Inventory Worksheet