July 2022 – Page 10 – knowledgebase JJ

Create a Saved Search that will Show Number of Expense Reports filed by Employee

1) Navigate to Lists > Search > Saved Searches > New 2) Choose Transaction as Search Type 3) Under the Criteria tab > Standard subtab, add the following filterDate = is (choose date range, ex. last fiscal year)Type = is Expense ReportMain Line = is true (Yes) 4) Under the Criteria tab > Summary subtab,… Continue reading Create a Saved Search that will Show Number of Expense Reports filed by Employee

Create Multiple Links in a Custom Field

Solution Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New Label: Enter Label Type: Select Inline HTML Click Applies To Purchase: Enter Checkmark Click Validation & Defaulting Formula: Remove Checkmark Default Value: Add <br/> tag after each line of hyperlinkExample:<a href=”https://www.netsuite.com”>NetSuite</a> <br/> <a href=”https://www.oracle.com”>Oracle</a> Click Save

Solve Error: System limit for number of file watchers reached , while fetching the theme.

Solution: In the terminal run the code echo fs.inotify.max_user_watches=524288 | sudo tee -a /etc/sysctl.conf && sudo sysctl -p This fixes the error and allows the theme fetch.

Add Image in Matrix table

We can add the images in the matrix table dynamically For that, first of all, we need to save all the images of the matrix items in a particular format. Then we can create an extension to generate and add the URL of the images based on the condition used to save those images here… Continue reading Add Image in Matrix table

Balance sheet Customization Error: “This layout contains invalid reference row(s) marked with icon. Redefine the referenced row and/or report for each invalid row before saving”.

Delete Paired Intercompany Transactions

For Intercompany Purchase Orders/Sales Orders containing Assembly items: On the Global search, key in the Intercompany Sales Order you wish to delete. On the view mode, right-click on the Purchase Order # shown on the Paired Intercompany Transaction and Open in a New Tab. Return to the tab of the Intercompany Sales Order and click Edit.… Continue reading Delete Paired Intercompany Transactions

Extract Month and Year from Date field

The formulas for extracting Months and Year from a date field in saved searches TO_CHAR({datecreated},’MONTH’) – displays month name (Character) as result. Ex: Aprilinstead of ‘Month’ we can specify the format in which the month should be displayed.MON – Jan, Feb, etcMM – a numeric month from 1 to 12 TO_CHAR({datecreated},’YYYY’) – displays year in… Continue reading Extract Month and Year from Date field

Email failure message

Failure message is:This is an automatically generated Delivery Status NotificationThe following addresses had permanent fatal errors(reason: 4.3.2 Persistent Transient Failure: System not accepting network message) Suggestions As per the Simple Mail Transfer Protocol (SMTP), the email error message “reason: 4.3.2 Persistent Transient Failure: System not accepting network messages” is because of the following reasons, 4.XXX… Continue reading Email failure message

Proposal For Order form Sort by Sub category

Proposal Summary This proposal covers the scope of sorting the items by sub category in the Order form of Point Australia website. Requirement The website order form is now sorting the items with parent category only. The items need to be sorted based on the subcategory as well. For example, Point Accessories: Category=Hair, Sub-category=Elastics. Current Working … Continue reading Proposal For Order form Sort by Sub category