Author: Surya Vineeth

Field not available in CSV update mapping

Custom field is not available in the CSV import mapping step.The field type is not disabled.Open the custom field, click on the access subtab, add the role through which the csv import is supposed to be performed. Set the access level, and level for search/Reporting to edit.Now the field will be visible in the CSV… Continue reading Field not available in CSV update mapping

Change date of Reversal journal to adjustment period

Requirement is to change the dates for Reversal Journal Entries.Dates of Reversal Journal Entries are dependent on their Parent Journal Entry containing the Reversal Date.The Reversal Date field indicates the Transaction Date of the Reversal Journal Entries. When creating automatic Reversing Entries from existing Journal Entries, it does not have the option to post on Adjusting Period.If succeeding months have… Continue reading Change date of Reversal journal to adjustment period

Schedule workflow for historic transaction update

Create the workflow for the particular record.Create the saved search for the same type of record that includes the document numbers to be updated using the workflow.The workflow will be triggered only for the saved search results.Schedule a time for the update.Release the workflow.For immediate testing we can use the “Execute now button” or else… Continue reading Schedule workflow for historic transaction update

FAM Depreciation error:MAP_ERROR: The following field(s) are inactive: Class

When running Asset Depreciation , encountered the error – MAP_ERROR: The following field(s) are inactive: Class  To resolve this, you must first identify the asset to which the BG Summary record in question is related to by creating a saved search with the below fields: Type BG Summary Records in the Global Search, Click Page: BG Summary Records, Look for the Internal ID of the… Continue reading FAM Depreciation error:MAP_ERROR: The following field(s) are inactive: Class

Error in the Payment File Administration on clicking “Email Payment Notification” button

The above error occurs on clicking the “Email Payment Notification” button in the Payment file administration page. Here the error is due to insufficient permission.Identify the error and from which script the error is being encountered. For this Navigate to Customization > Scripting > Script Execution Log.Check the error and from which script the error is being encounteredIn the corresponding… Continue reading Error in the Payment File Administration on clicking “Email Payment Notification” button

Journal Posting Period sets to a Non-Adjustment Period

A user enters a Journal Entry with the fields: Posting Period = (any adjusting period),Approval Status = Pending Approval. When the entry is saved, the Posting Period changes to the non-adjusting period covering the transaction date or the next open period. For example, it was set to Adjust 2020 but it reverts to Dec 2020. Adjustment periods are used today to allow administrators and controllers to post… Continue reading Journal Posting Period sets to a Non-Adjustment Period

Apply Employee Advance

To process employee advances using NetSuite Standard Functions, follow the below steps: 1. Write a check for an employee advance.   Navigate to Transactions > Bank > Write Checks Enter all the necessary fields to save the CheckNote: The Account to be used under Expenses & Items > Expenses tab > Account column should be the account set as default under DEFAULT ADVANCE TO APPLY ACCOUNT FOR EXPENSE REPORTS in… Continue reading Apply Employee Advance

Send email not working in workflow on the entry trigger type

Send email action is not triggered on the entry trigger point of a workflow state.So in order to work the send email action, it requires an after-submit trigger.If possible add the button action in the previous state, so that on the button click an after-submit trigger occurs, and in the next state, the send email… Continue reading Send email not working in workflow on the entry trigger type