Scenario User tries to access any transaction records list as per samples below but this error shows: “The result field Formula (Currency) cannot be grouped. Please edit search and omit this field or use a different summary function”. Examples: Navigate to Transactions > Sales> Enter Salesorder > List Navigate to Transactions > Sales> Create Invoice > List Solution Navigate to the Transaction Records List where error is encountered, i.e. Transactions > Sales> Create… Continue reading Error: The Result Field Formula (Currency) Cannot be Grouped. Please Edit Search and Omit this Field or Use a Different Summary Function” When Navigating to Any Transaction Records List
Author: SreeVidhya Sanoj
Limiting the number of characters of description in PDF template
We can limit the number of characters in the decription , item name etc in the PDF template code.
Aggregate line item based on tax rate in Advanced PDF template
Item line code for aggregating the items based on tax rate and adding the rate, gross amount, tax amount and quantity
DateV interface – CSV file from the journal entry
Exporting journal entry item line details as CSV files UserEvent Script Client Script Suitelet
Non Mandatory Fields if location is “Online Sales” in SO, invoice, IF
Whenever the field location has the value “online sale” we will be triggering user event scriptto set the mentioned fields as non-mandatory.
Proposal of Email template for Sales order
Proposal summary This proposal covers the scope of the email message creation for sales order using the custom button “Email CS”. Requirement UteMaster NZ Ltd would like to prepare email templates for sales orders. A custom button need to add in the sales order “Email CS” .When this button is clicked, a new email will… Continue reading Proposal of Email template for Sales order
Proposal For Sales order, Invoice and Estimate Print
Proposal summary This proposal covers the scope of the PDF template customization for sales order, invoice and Estimate Requirement Eagle point solutions would like to prepare a PDF for sales order, Estimate and Invoice and they would like “banded rows” when they print out a sales order and estimate. At the bottom of the “Estimate”… Continue reading Proposal For Sales order, Invoice and Estimate Print
Disable the amount field for EUR and USD sublist in Item record
We can implement the customisation using User event script. In the item record , amount field for USD and EUR set to disable by default when the item page loaded for individual items and assemblies. User Event Script
Proposal of invoice and Credit Memo PDF
Proposal summary This proposal covers the scope of the PDF template customization for Invoice and credit memo. Requirement Macrofin would like to prepare a PDF for Invoice and Credit memo. Our Solution The requirement can be achieved by creating a PDF template for Invoice and Credit Memo. We will copy the exact layout of the… Continue reading Proposal of invoice and Credit Memo PDF
Group the items using “Invoice Group in PDF
There is a field in Invoice item line “Invoice Group”,based on this field we have to group the item lines in invoice. If there is value in “Invoice Group” , this value should be given as description in PDF. Also sum the amount in the other lines if the value in invoice grouping is same.… Continue reading Group the items using “Invoice Group in PDF