Tag: Data migration

How to add values to a custom list using csv import

When adding many values to a custom list, a CSV import can be more efficient than manually adding each value. To import custom lists, follow these steps: Go to Setup > Import/Export > Import CSV Records. Select Customization as the import type and Custom List as the record type. In the Import Options, choose ‘Update’… Continue reading How to add values to a custom list using csv import

Vendor Credits and Credit Notes not showing in AP and AR Aging Reports in Zoho Books

In standard Accounts Payable (AP) and Accounts Receivable (AR) Aging reports within Zoho Books, vendor credits and credit notes are not displayed by default. However, you can modify the report settings to include these details. Follow the steps below to ensure comprehensive reporting. Start by logging into Zoho Books account. Go to the “Reports” section… Continue reading Vendor Credits and Credit Notes not showing in AP and AR Aging Reports in Zoho Books

Identify Bills Applied to Vendor Credits in Zoho Books

In Zoho Books, it is not possible to determine which bills will be applied to the vendor credit through reports directly. To obtain such details, individual vendor credits need to be examined to identify which bills are applied. After logging into the Zoho Books account, the “Reports” section should be clicked. Then, the “Vendor credit… Continue reading Identify Bills Applied to Vendor Credits in Zoho Books

Error on CSV Import of Transactions: “Invalid entity reference key xx for subsidiary yy.”

Scenario User is trying to import a data through CSV but gets an error message stating: “Invalid entity reference key xx for subsidiary yy.” Solution The numbers (xx and yy) found in the error are the Internal IDs of the Entity record (Customer, Vendor, Employee, Other Name) and Subsidiary respectively that are found in NetSuite account 1.… Continue reading Error on CSV Import of Transactions: “Invalid entity reference key xx for subsidiary yy.”

QuickBooks Search Functionality

Accessing the Search Function Initiate the Search: To begin, navigate to QuickBooks and locate the Search icon positioned at the top right corner of the interface. Click on the icon to open the Search window. Enter Your Query: In the Search window, you’ll find a designated Search box. Input the specific item, transaction, or activity… Continue reading QuickBooks Search Functionality

Bill Payment and Applied Transaction Report in QuickBooks

In understanding which transactions are linked to payment records, QuickBooks offers a convenient way to fetch bill payments and their associated transactions.  Log In and Navigate to Reports: First things first, log in to QuickBooks account. Once you’re in, head over to the Reports section. This is where you’ll find all sorts of useful financial… Continue reading Bill Payment and Applied Transaction Report in QuickBooks

Payments and Applied Transactions in QuickBooks

In QuickBooks, extracting payment and applied transaction details provides insight into which transactions are associated with specific payment records. To access this information, users can follow a series of steps within their QuickBooks account. Firstly, log in to the QuickBooks account and navigate to the “Reports” section. Within this section, locate and select the “Invoices… Continue reading Payments and Applied Transactions in QuickBooks

QuickBooks Reports for Migration

We might need reports from the customer’s legacy system, to get the transaction details for data migration into NetSuite. Here are some ways to fetch transaction details, if the client is using QuickBooks. First, the QuickBooks account must be logged into, and then the “Reports” section should be accessed. By searching for “Journal” in this… Continue reading QuickBooks Reports for Migration

Exporting Open transactions from QuickBooks

For the purpose of migrating the open transactions in QuickBooks, follow the steps: Export the A/R Ageing Detail and A/P Ageing Detail report to identify the transactions to be exported as open transactions. We can customize the reporting by adding the additional columns We can refer the Journal report for identify the accounts to be… Continue reading Exporting Open transactions from QuickBooks