The client would like to filter all the item fulfillment that are in shipped status(created through UI or through bulk processing etc)created in the account. We can use the saved search formula as below
Author: Litha Mukunthan
Saved search formula to filter item program name in the item fulfillment contains “Brands and People”
In the summary filter add the formula [“max(formulanumeric: CASE WHEN {item.custitemtmg_program_name} != ‘Brands & People’ THEN 1 ELSE 0 END)”, “equalto”, “0”]
Saved Search formula to filter the Item fulfillment with inventory items only
In the summary filter add the formula [“max(formulanumeric: CASE WHEN {item.type}!=’Inventory Item’ THEN 1 ELSE 0 END)”, “equalto”, “0”],
Search filter to Fetch the Item fulfillment which are created after 5 PM Yesterday to 5 PM Today
[“formulanumeric: CASE WHEN {datecreated} BETWEEN TO_DATE(TO_CHAR({today},’YYYY-MM-DD’) || ‘ 17:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) – 1 AND TO_DATE(TO_CHAR({today},’YYYY-MM-DD’) || ‘ 17:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) THEN 1 ELSE 0 END”, “equalto”, “1”]]]
Script to remove the Drawings/File attachments from the item record in a copy context
Jira Code: GTILC-397
Saved Search Function to check whether items exist with similar drawings name in file cabinet
Automate drawings Attachment
The client would like to attach the drawings of the item stored in the file cabinet to the corresponding item record Jira Code: GTILC-397
Order Delay Count Update
The client would like to remove the order delay count from the item record. This requirement can be updated by removing the script deployment of the order delay from the account. This particular request can be fulfilled by making a modification in the system. Specifically, the change involves the removal of the script that was… Continue reading Order Delay Count Update
Proposal For TDS On AR
The client would like to apply TDS on AR transactions. Proposal summary This proposal outlines a comprehensive solution for integrating TDS seamlessly into NetSuite environment, ensuring accurate tax deduction, compliance, and efficient financial management. The proposed solution involves leveraging NetSuite’s functionalities along with customization to automate TDS calculation, deduction, and reporting for Account Receivables. Requirement … Continue reading Proposal For TDS On AR
Proposal For Vendor Payment Approval Process
Proposal summary The proposal outlines a vendor payment approval process to efficiently manage and oversee the payment and liabilities owed to vendors, suppliers, and service providers. The process involves various steps and roles to ensure transparency, accuracy, and adherence to company policies and financial controls. Requirement eVersum has expressed their desire to establish a payment… Continue reading Proposal For Vendor Payment Approval Process