we already have an excel document namely produceSales and we need to update it with new values.Without searching each item we can done it through python programming Code: import openpyxl wb=openpyxl.load_workbook(‘produceSales.xlsx’) print(‘—-workbook opened—‘) produce_update={‘Garlic’: 3.07,’Celery’: 1.19,’Lemon’: 1.27} sheet=wb[‘Sheet’] for rows in range(2,sheet.max_row+1): product=sheet.cell(row=rows,column=1).value if product in produce_update: sheet.cell(row=rows,column=2).value=produce_update[product] wb.save(‘updatedProduceSales.xlsx’) print(“Update completed”)
Month: December 2023
Encrypt a pdf using python
Code to encrypt a pdf using python: import PyPDF2 pdfFile = open(‘meetingminutes.pdf’, ‘rb’) pdfReader = PyPDF2.PdfFileReader(pdfFile) pdfWriter = PyPDF2.PdfFileWriter() for pageNum in range(pdfReader.numPages): pdfWriter.addPage(pdfReader.getPage(pageNum)) pdfWriter.encrypt(‘swordfish’) resultPdf = open(‘encryptedminutes.pdf’, ‘wb’) pdfWriter.write(resultPdf) resultPdf.close()
Resolving NetSuite Password Reset Challenges in Multi-Account Environments
For NetSuite users with access to both sandbox and production environments, forgetting a password can sometimes lead to challenges during the password reset process. This article provides guidance on overcoming the error message while other user is trying to change the password of a user has multiple account access, “Only the user can change this… Continue reading Resolving NetSuite Password Reset Challenges in Multi-Account Environments
Customer Saved Search for the number of Customers created last month per Sales Rep who has a Sales Order/s the current month
Go to Reports > Saved Searches > All Saved Searches > New 2) Click the Customer link 3) Enter your desired Saved Search title 4) Results tab > Columns sub tab > set the following Field and corresponding Summary Type: — Sales Rep | Group — Formula (Text) | Count Formula : Case When TO_CHAR({datecreated}, ‘MM YYYY’) = TO_CHAR(ADD_MONTHS({today}, -1), ‘MM YYYY’) then {internalid} end Custom Label : Customers created… Continue reading Customer Saved Search for the number of Customers created last month per Sales Rep who has a Sales Order/s the current month
How to Change Your NetSuite Password?
Changing your NetSuite password is a simple process that ensures the security of your account. Follow these step-by-step instructions to update your password effortlessly. Steps to Change NetSuite Password: Login to NetSuite: Access your NetSuite account using your email ID ‘test.user@test.in’ and the current password. Navigate to Employee Record: Click on ‘Edit’ in the employee… Continue reading How to Change Your NetSuite Password?
GGBN- GL Account Mapping User Interface Proposal
Proposal Summary This proposal outlines the development of a streamlined process of managing financial data in NetSuite through a user-friendly interface. The focus is on handling CSV file imports for Custom Record GRW017 LE GL Account Plan Line and GRW017 LE FY TrialBal Version. The solution includes creating new custom records, linking them appropriately, mapping… Continue reading GGBN- GL Account Mapping User Interface Proposal
GGBN – Loan Repayment Proposal
Proposal Summary This proposal is to develop a comprehensive loan repayment solution that aligns with the Growire Group’s specific requirements. The objective is twofold: replicate the intricate loan repayment calculations currently executed in an Excel sheet and create an intuitive user interface form with advanced functionalities. The proposed system will be designed to meet the… Continue reading GGBN – Loan Repayment Proposal
GGBN – Vehicle – Invoking API Button Proposal
Proposal Summary This proposal outlines the development of a streamlined functionality within NetSuite to fetch and populate relevant information for GRW018 Vehicle custom records. The proposed solution involves integrating a button into the record creation/edit view, triggering a popup page for Growire Groups to input API parameters. These parameters will be used in an API… Continue reading GGBN – Vehicle – Invoking API Button Proposal
Split SGST and CGST tax details in two lines in Tax Invoice PDF.
Split tax details in the format ‘GST:SGST & CGST x%’ in two lines in the tax invoice PDF. PDF should be look like: Code for splitting the SGST and CGST in two lines: <#if record.item?has_content><!– check if record has tax amount/rate first –><#assign tax_amt = false><#assign tax_rate = false><#list record.item as item><#if (item.tax1amt?length != 0)… Continue reading Split SGST and CGST tax details in two lines in Tax Invoice PDF.
Introduction into Machining – Gear cutting
1. Overview Gears were made by hand from ancient times until the 18th century when mechanization became widespread in Europe with the introduction of clocks and other machines. During the Industrial Revolution, machines dedicated to making gears were developed in quick succession. In gear making, steel cylinders are first cut into circular plates, which are… Continue reading Introduction into Machining – Gear cutting