This article describes the CSV error while updating the GL Matching reference for previous transactions when we enabled the duplicate detection preference.
Category: Financials
All NetSuite finance related implementation/configuration/customization processes are posted in this category.
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
Saved search for Journals as Applying transaction of another journal
Saved search for Journals as Applying transaction of another journal