Requirement Set up a test account to establish a dynamic connectivity to the excel using a suitelet script. Excel should pick up data from a saved search. Solution Use a suitelet script External url with the saved search Id and a secret key to use in excel sheet.
Tag: suitelet
Proposal For Payment Details Report
Proposal summary JCurve Solutions would like to create a new report to retrieve data for data from the AP Bill document. This report will show Current status of the document within the selected period based on the payment date. And print reports in Excel format. Requirement New report ‘รายงานแสดงรายละเอียดการจ่าย’ to retrieve data for data from… Continue reading Proposal For Payment Details Report
PROPOSAL FOR INVENTORY AGING REPORT
Proposal summary JCurve Solutions would like to create new a report to retrieve data from Purchase orders and Item receipts with getting details from inventory item Lot/ Serial item that are still available on date recall report. In case an item in one purchase order has an item receipt more than one time, it will… Continue reading PROPOSAL FOR INVENTORY AGING REPORT
Proposal For รายงานขอคืน WHT report
Proposal summary JCurve Solutions would like to create a new report to retrieve data from Journal vouchers with journal voucher date in the selected date range. And print reports in PDF format. Requirement New report ‘รายงานขอคืน WHT’ to retrieve data from Journal voucher and select Journal voucher type = Bank charge with journal voucher date… Continue reading Proposal For รายงานขอคืน WHT report
Proposal For Inventory Adjustment Report
Proposal summary JCurve Solutions would like to create new a report to retrieve data for data from the Inventory adjustment document. The details for PO No, Supplier, Reference Bill can track only the case of issue out. And print reports in Excel format. Requirement New report ‘Inventory adjustment report’ to retrieve data for data from… Continue reading Proposal For Inventory Adjustment Report
PROPOSAL FOR รายงานการยื่นแบบ ภงด. 54 และ ภพ. 36
Proposal summary JCurve Solutions would like to create a new report to retrieve data for data from the AP Bill document Reference to Payment with status Paid which is related to PP36 and PND54. This report will show the current status of the document when recalling the report. And print reports in Excel format. Requirement… Continue reading PROPOSAL FOR รายงานการยื่นแบบ ภงด. 54 และ ภพ. 36
Suitelet Page To Display Search Details In A Table Format
Suitelet Page To Display Search Details In A Table Format
Proposal For Preload & Preapprove Report
Proposal summary JCurve Solutions would like to create a new report to retrieve data for data from Sale order, Requisition, and project master data. This report will show the current status of the document when recalling the report. And print reports in Excel format. Requirement New report ‘Preload & Preapprove’ to retrieve data for data… Continue reading Proposal For Preload & Preapprove Report
Suitelet that summarizes the length of time open
Suitelet returns the KLIPFOLIO – UK CASE whose search results summarize length of open cases