SCENARIO The client requires to avoid the currency revaulation form the trail balance inorder to reduce the total value in the trial Balance Debit and credit columns for the purpose of Auditing. SOLUTION Navigation: Report>Financila>Trial Balance>Customize Provide a name for the Trial balance Under Filter Subtab Under Add Fields, Trial balance:Transaction type: long name Select… Continue reading Trial Balance Report- Excluding currency revaluation
Author: Antony Roy
Trial balance Report with Transaction Journals,Memo,Line Memo,Entity
SCENARIO The Client require to get a traial balance that shows Memo, Line Memo and entity name in of Journal transactions only. SOLUTION We have to customise a Trial Balance Report. Navigation: Report>Financila>Trial Balance>Customize Provide a name for the Trial balance Under Edit Column Subtab From Add Fields Select following columns: Trial Balance: Date Trial… Continue reading Trial balance Report with Transaction Journals,Memo,Line Memo,Entity
Unlock Bank Statement-Fast Four Reconciliation
SCENARIO: The Client Requires to unlock the Processing Bank statement done through fast four reconcilaition. SOLUTION Defaultly the unlock bank statement permission is only provided for the user with Administrator Role. To provide it for a custom role kinldy do as the following steps: Unlock statements permission With the unlock statement option users can unlock… Continue reading Unlock Bank Statement-Fast Four Reconciliation
Employee name not populating in Sales Rep field
SCENARIO While Client is trying to enter opportunity they are not able to get name of certain employees in the Sales Rep field. SOLUTION Identify the Names of employees Open the employee record Click on edit button Under Human Resource subtab Click on Issalresrep Save the record
Trial Balance with Opening Balance and Transaction of Certain period only
SCENARIO The client requires to get a Trial Balance report for a specific period range and its opening balance for the auditing purpose. SOLUTION We have to customise the Tril balance report in NetSuite Navigation Go to: Report>Finanacial>Trial Balance>Customise The Report builder Opens Click on the Filter subtab Under choose filter, against Trial Balance Period:… Continue reading Trial Balance with Opening Balance and Transaction of Certain period only
Unable to Edit processing Bank Statement.
Scenario. The client wants to delete the Bank reconciliation done through fast four reconciliation facility but the status of bank statement is shown as Processing and there are no options for edit or delete button. Solution First we will have to unlock the bank statement. To unlock bank statement: The navigation to unlock the bank… Continue reading Unable to Edit processing Bank Statement.
Report for Active Chart of Accounts with Balance Zero Since a particular Date
Scenario The Client has requested to provide the details of Active Chart of accounts whose balance is 0 with year Jan1,2022. They requires to get report were the COA is not used in any transaction. Solution Create two searchs: Active Chart of account search with internal ID in result. In criteria provide inactive ‘FALSE’ In… Continue reading Report for Active Chart of Accounts with Balance Zero Since a particular Date
Provide Access to File Cabinet Folder for Certain employees.
Scenario The client requires to Store some confidential data and it should be only accessed by few employee of the organisation. Solution We have to create a folder and restrict it by a group as the Folder can only restriced by fllowing and not employee: Class Department Location Subsidiary Group Here as the employee can… Continue reading Provide Access to File Cabinet Folder for Certain employees.
Delete A Memorised Journal.
Scenario The client requires to delete a memorised transaction( Journal). Solution Go to Transaction Search In criteria provide following details: Type: choose the type of transaction Memorised: Selelct the transaction is Memorised In result provide the following details Amount Memorised transaction Internal Id. Run the report and based on the amount select the Transaction and… Continue reading Delete A Memorised Journal.
Workflow for Rejection Reason in Approval were there is single state for rejection.
Scenario The Client requires to get and option to provide a a note on why a particular transaction that came to approval was Rejected Solution In this case we have to create a field in the respective transaction record named as “Rejection Reason”. Then we will have to make following amendment in the workflow as… Continue reading Workflow for Rejection Reason in Approval were there is single state for rejection.