Author: Jeen Mariya Jose

To split cells in Excel, follow these steps: Click and drag from the first cell to the last cell in the column that you want to split. Go to the “Data” tab located at the top of the Excel Ribbon. In the Data Tools section, click the “Text to Columns” button. In the Convert Text… Continue reading How to Split Data Into Multiple Columns in Excel

Here are the steps for the import process: Create a CSV file with the following columns: Columns: Internal ID – Internal ID of the items to be updated. (Name of the checkbox) Save the file as CSV (Comma Delimited) (*.csv) Navigate to Setup > Import/Export > Import CSV Records In the Import Assistant: Scan &… Continue reading CSV Import to Mark/Unmark Checkbox on Item record

To create a saved search for missing timesheets of an employee based on the Weekly timesheet, the first step is to consider the Work Calendar Hours for each week. Next, set the criteria as follows: Under the Criteria subtab, choose the Formula (Numeric) filter. The formula should be: CASE WHEN {submittedhours}<{workcalendarhours} THEN 1 ELSE 0… Continue reading How to get missing timesheets of an Employee from the Weekly timesheet in a month

Firstly, we need to establish the relationship between Bank Deposits and Deposit Applications. In the context of a Saved search, the Bank deposit fields are the 3rd joint fields of the Deposit Application. This means that the Bank Deposit is created from the Customer Deposit, and the applying transaction for the Customer Deposit is the… Continue reading How to fetch Bank Deposit Date and Bank Deposit Number to a Deposit Application saved search

Navigate to your home dashboard Select “Publish Dashboard” from the Settings Portlet If this option isn’t available, make sure your role has permission to publish dashboards. Check permissions at Setup > Users/Roles > Manage Roles. Edit your role. In the Permissions > Setup tab, add the “Publish Dashboards” permission. Fill out the name and ID… Continue reading How to publish the dashboard according to specific roles

To add items to a matrix: Go to Lists > Accounting > Items. Click Edit next to the parent item to which you want to add items. Click the Matrix tab and then review the lists of available values for each matrix option. Select option values that you want to be available as subitems of… Continue reading How to add matrix subitems to a parent matrix item

On the Results subtab, click Columns. For adding Discount Item: Select Formula(Text) from the list. In the Summary Type field, select Group CASE WHEN {item.class}=’Specify the discount name here‘ THEN {item} ELSE ” END For adding Discount Applied Item: Select Formula(Text) from the list. In the Summary Type field, select Group CASE WHEN nvl({discountamount},0)!=0 THEN {item} WHEN(NVL({grossamount},0)-NVL({netamount},0))>0 THEN {item} ELSE ” END For adding Discount Amount: Select Formula(Currency) from the… Continue reading How to add a discount item, discount applied item, and discount amount into the saved search

Multilogin is a tool that allows users to manage multiple Amazon Seller Central accounts simultaneously from one browser. With Multilogin, users can schedule data range reports for their Seller Central accounts to automatically run at specific times. To schedule a data range report(DRR) using Multilogin, you will need to follow these general steps: Log in… Continue reading Scheduling Amazon DRR reports using MultiLogin

Human Capital Management (HCM) helps companies acquire, develop, manage, and optimize their workforces. It helps create an environment that maximizes workforce potential by implementing a set of processes and policies around hiring, managing, and employee development. Workforce Analytics- It is about measuring the behaviors of employees, leaders, and candidates and using resulting insights to make… Continue reading Human Capital Management