Requirement: We need to send pending timesheet details to the corresponding project manager by end of the Day.We can use a scheduled script for the development and it will check the timesheet and send a list of pending timesheets to the corresponding project managers with necessary details such as Date,Timesheet details,Actual Hours,Employee name , timesheet… Continue reading Scheduled Email For PM’s using MR script
Tag: Map Reduce
Reschedule the Mass Reduce script to update Invoice Trandate
Problem : Need to reschedule the map reduce script to update the invoice trandate. The error should save in a csv file. Solution : /** * @NApiVersion 2.1 * @NScriptType MapReduceScript */ /******************************************************************************* * CLIENTNAME: Branded * Develop a script to help finance mass update the Invoice dates based on their Posting date mentioned in… Continue reading Reschedule the Mass Reduce script to update Invoice Trandate
Adrenalin-Netsuite Employee Integration : Solution
Requirement: Neutrinos needs to integrate the Master Data Employees from Adrenalin to Netsuite. Also would like to migrate existing employee records from Adrenalin to NetSuite. Prerequisites: Token based Authentication(TBA) is considered here as Authentication type. So, need to set TBA( refer http://jobinandjismi.in/setting-up-netsuite-token-based-authentication-tba/ ) We will provide the consumer key, consumer secret, token ID, token secret,… Continue reading Adrenalin-Netsuite Employee Integration : Solution
Margin Report – Transactions
Proposal Summary This proposal covers the scope of creating the Report for Margin to the Netsuite Production account of RSP Supply. We will be creating a custom page for margin reports and users can download the report after its creation on a scheduled basis. Requirement RSP Supply needs a report for Margin with the item… Continue reading Margin Report – Transactions
Proposal For Custom NetSuite P&L Reports
Proposal summary This proposal covers the scope of implementing custom solutions for the P&L reports for project and project clients, Project creation restriction, resource and service item assigning scripts. Requirement The client would like to have a detailed P&L report that consists of different transactions that constitute to the Cost and revenue side of project… Continue reading Proposal For Custom NetSuite P&L Reports
Switch Account
Created a suit let page were we can enter the source and target account.
The account in the transactions has to be switch from source to target.
If an error occurs the error file will be sent to that respective user.
Preserve the processor for high priority tasks
Issue: MapReduce and scheduled scripts are not initiating at the same time of invocation since it is in a queue to process. Solution: So we can Preserve the processor for the Execution of MapReduce and scheduled scripts of its priority are high. Limitation: We cannot preserve the processor for a specific script. It can be… Continue reading Preserve the processor for high priority tasks
Map Reduce Error Handling
Jira Code: TRS-579 The main use of map-reduce script to process bulk data and update NetSuite. We can trigger Map-reduce by submitting the task inside the script, but it will never return any data or error message once it completed.If any of the reduce(stage in map-reduce script) becomes fails we can create a text/CSV in… Continue reading Map Reduce Error Handling
Delete customers and remove the address
Delete customers and remove the address by using mass update and map reduce script.
Item Pricing Customization
Item pricing customization to copy custom price from one customer to other.