Scenario User need to generate Employee saved search to display an Employee Report with Last Login Date. Solution Navigate to Setup > Users/Roles > View Login Audit Trail Click Create Saved Search Search Title: Enter Title Example: Employee Last Login Date Search Click Results Field: Note: For every required field use the drop-down menu to select and once adjusted click Add if needed.… Continue reading Create Employee Report with Last Login Date
Author: Antony Roy
The amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search different from the amount in the Balance fields on the Vendor Record
Scenario User wanted to know why is the Amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search is different from the amount in the Balance fields on the Vendor Record, Solution The Balance column on the Vendor Saved Search extracts information from the Vendor Record > Subsidiaries tab > Balance (Base) field of the Primary Subsidiary. The Balance (Foreign Currency) column extracts information from the Vendor Record > Financial tab… Continue reading The amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search different from the amount in the Balance fields on the Vendor Record
Map Reduce script showing error:-THE_ACCOUNT_USED_BY_THE_TRANSACTION_IS_NOT_AVAILABLE_ON_THIS_SUBSIDIARY
SCENARIO: A map reduced script is being executed for a custom transaction and getting following error: “Advance Funding ID: 998065, Error: The account used by the transaction is not available on this subsidiary” {“type”:”error.SuiteScriptError”,”name”:”THE_ACCOUNT_USED_BY_THE_TRANSACTION_IS_NOT_AVAILABLE_ON_THIS_SUBSIDIARY”,”message”:”The account used by the transaction is not available on this subsidiary.”,”id”:””,”stack”:[“Errorn at suitescript/resources/javascript/record/recordImpl.js:156:24n at Object.submitFields (suitescript/resources/javascript/record/recordImpl.js:154:30)n at Object.reduce (/SuiteScripts/Jobin and Jismi… Continue reading Map Reduce script showing error:-THE_ACCOUNT_USED_BY_THE_TRANSACTION_IS_NOT_AVAILABLE_ON_THIS_SUBSIDIARY
Transaction Column not Auto populating value for a Role
SCENARIO: The value in Journal line column “class” is currently made auto populated from the Project record in relation with a custom segment called “project Code” via a script. But for a particular Role Accountant role this functionality is not working. While checking the Role permission it has been provided with Custom segment permission. Reason:… Continue reading Transaction Column not Auto populating value for a Role
Transaction Detail report for Employee
SCENARIO: The Client requires to see all the transaction that is related to employees. SOLUTION: Go to Report> Financial> transaction detail> customise In edit column: Select following options: Transaction: Entity (Line): Name (Grouped) make it Grouped with type Transaction: Transaction Number under Filter: Entity (Line)Entity (Line): Name (Grouped) and type starts with: EMP Under more… Continue reading Transaction Detail report for Employee
Resolve Currency Field on Mainline of Saved Expense Report Cannot be Edited
SCENARIO: Client want to edit the currency of the expense report once it is saved. SOLUTION: When the Foreign Currency Expense Report feature was introduced in 2019.1, part of its limitation is that the Currency and Rate fields will not be editable for existing Expense Reports.
Employee Report with Last Login Date
SCENARIO: Client requires to get an Employee Report with Last Login Date. SOLUTION: Navigate to Setup > Users/Roles > View Login Audit Trail Click Create Saved Search Search Title: Enter Title Example: Employee Last Login Date Search Click Results Field: Note: For every required field use the drop-down menu to select and once adjusted click Add if needed. Select Date Summary Type: Select Maximum Select User Summary Type: Select Group Select Role Summary… Continue reading Employee Report with Last Login Date
Update Supervisor or Expense Approver of Employee Results to Notice: “Unable to set up approval queues for the expense report with id = XX. Please set expense approval chain related fields correctly.”
SCENARIO: Updating the Employee record to add or update the Supervisor field returns a notice saying: “Unable to set up approval queues for the expense report with id = XX. Please set expense approval chain related fields correctly.”. The notice shows that there is an Expense Report that is stuck in the Pending Approval queue that needs to be approved first before the… Continue reading Update Supervisor or Expense Approver of Employee Results to Notice: “Unable to set up approval queues for the expense report with id = XX. Please set expense approval chain related fields correctly.”
Default Corporate credit card account for Employees
SCENARIO: The client wants assign default credit account to the employees SOLLUTION Navigate to Lists > Employees > Employees. Select an employee and click the Edit link. Click Customize link > Customize Form You will then be routed to the Custom Entry Form page. Under Fields tab > Human Resources subtab > mark the Show checkbox for Default Account for Corporate Card Expenses. Click Save. Navigate to Lists > Employees > Employees. Select an employee and click the Edit link. Under Human Resources subtab > Expense… Continue reading Default Corporate credit card account for Employees
Supplementary tax calculation not working for expense Report
SCENARIO When the client provides tax code in expense report which is non deductible tax the tax amount is not being transferred to the non deductible account. SOLUTION To Configure the Supplementary Tax Calculation Plug-in: Go to Customization > Plug-ins > Plug-in Implementations. On the Plug-In Implementations page, click the View link next to Supplementary Tax Calculation, and… Continue reading Supplementary tax calculation not working for expense Report