Scenario Client created JEs and they made wrong exchange rate in the transaction. i.e., if the base currencies and transaction currencies are different, the exchange rate will not be 1 But they wrongly added one as the exchange rate. So, they want to know which all are the wrongly posted JEs. Eg. USD to USD… Continue reading Saved search to show all the Journals which have the transaction currencies and base currencies are different but the exchange rate wrongly added as one.
Category: Financials
All NetSuite finance related implementation/configuration/customization processes are posted in this category.
Update GL Matching error – “Transaction cannot be saved because the reference number already exists for this vendor”
This article describes the CSV error while updating the GL Matching reference for previous transactions when we enabled the duplicate detection preference.
CSV Import Error: “Invalid Subsidiary Reference key” for Journals.
Scenario During the CSV import of Journal Entry an above error is received. Solution Use the correct format for CSV file by exporting list of Subsidiaries: Check the subsidiaries mentioned in the file is correct with the NetSuite record.Navigate to Setup > Company > Subsidiaries.Subsidiary is spelled the way it is spelled in the record.… Continue reading CSV Import Error: “Invalid Subsidiary Reference key” for Journals.
Restrict Employees from seeing other user’s Expense Reports for Approval
Restrict the employees from seeing other employees expense report for Approval and they need to view only their subordinates Expense reports or the same department’s Expense Report.
Delete Paired Intercompany Transactions
For Intercompany Purchase Orders/Sales Orders containing Assembly items: 1. On the Global search, key in the Intercompany Sales Order you wish to delete. 2. On the view mode, right-click on the Purchase Order # shown on the Paired Intercompany Transaction and Open in a New Tab. 3. Return to the tab of the Intercompany Sales… Continue reading Delete Paired Intercompany Transactions
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”.
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”.
Error: “Target subsidiary not specified. – Target subsidiary has no base currency setting” while running Bulk Bank Transfer
Error: “Target subsidiary not specified. – Target subsidiary has no base currency setting” while running Bulk Bank Transfer
Paid In Full Bills Were Opened After Updating The Transaction Lines Classifications Only
Paid In Full Bills Were Opened After Updating The Transaction Lines Classifications Only
Load financials and open transactions from QuickBooks to NetSuite
Introduction Companies implementing NetSuite need to load historical financial statements and open transactions to start using their new accounting system. This step is known as the financial data migration process. Completing this step will allow you to utilize NetSuite’s reporting functionality and begin processing transactions immediately after your implementation go-live date. This article will discuss… Continue reading Load financials and open transactions from QuickBooks to NetSuite
Item Fulfilment link in Bill Credit
Item Fulfilment created from Supplier Return Authorization need to be displayed in the associated Bill Credit as links. The only link between the Supplier Return Authorization, Packing Slip, and Bill Credit is the SRA number. As we could not link the Packing Slip directly with Bill Credit, created a saved search which lists the Packing… Continue reading Item Fulfilment link in Bill Credit