• Home
  • /
  • Jcurve Support Articles
Basic Accounting

Generating Asset Reports

The fixed asset reporting tool uses the Advanced PDF format. This enables you to print the report or to view and download it in CSV (for Depreciation Schedule Report), PDF, or XML format. To generate the fixed asset reports, you must enable theAdvanced PDF/HTML Templatesfeature from Setup > Company > Enable Features > SuiteCloud.

Read More

Import Expense Reports with Multiple Files > CSV Response Error: This record already exists

Customer added a Custom field in their Expense Report form named 'Reference Number' with function that is the same as Document Number but is assigned by the User and not by the System. This Reference Number field is located at the main line of the form.

Read More

Resolve Error: "Invalid payrollitem reference key xx for employee xx" on Track Time CSV import

A user imports Time Entry using CSV import and encountered the error: "Invalid payrollitem reference key xx for employee xx"

Read More

Resolve error:"You have entered an Invalid Field Value xxx for the following field: debit" on Journal Entry CSV Import

CSV import of Journal Entry throws the error in the CSV Response file.

Read More

Edit Statement Date of a previous Reconciled Account Statement

The user inadvertently reconciled their account statement without changing the Statement End Date.

Read More

Update Memorized Transactions

User needs to update the details on a transaction that has been memorized.

Read More

Custom Role > Asset Proposal > Be able to edit or change the Asset Type

ScenarioA non-Administrator role needs to edit the Asset Type on the Asset Proposal page.

Read More

Resolve Error: INVALID_KEY_OR_REF: Invalid custrecord_propcaretaker reference key XXX in Asset Creation

Customer is creating assets from asset proposal and encountered an Error: "INVALID_KEY_OR_REF: Invalid custrecord_propcaretaker reference key XXX."

Read More

Resolve Error: Update Transaction Failure: No Valid, Open, Tax Period for Date - Null When Approving Journal Entry with Reversal

User is unable to approve journal entry with reversal date next period due to notice: "Update Transaction Failure: No valid, open, tax period for date - null"

Read More

Update Memorized Transaction to Print or Email Invoices

User needs to update emailing options in invoices. Customer's record was updated but memorized transaction is not.

Read More

Create Journal Entry to record Cash Receipt of Overpayment Transaction

There are times when we pay the Vendor more than the amount that was billed for our purchases. Each time, we have the option to either claim it as a credit to our accounts or simply received the cash refund. Since we received money as a refund from the Overpayment we made, we need to record it correctly in our accounting books.

Read More

Journal Entries > Related Records tab > Payments subtab > view applied to and applying transaction to this transaction

Scenario

To be able to view all transactions where the Journal Entry was applied. For example:
  • Journal Entry#1 (JE1) has Accounts Receivable debited while Journal Entry#2 (JE2) has the same Accounts Receivable account credited for the same amount
  • These journals were applied to each other via Customer Payment
  • Related Records tab > Paymentssub tab of:
    • JE1showsJE2as the payment applied to it
    • JE2shows no value
  • User needs to viewJE1in theJE2transaction form >Related Records tab > Paymentssub tab

Solution

The expected behavior is currently filed as an Enhancement (273486)
Alternate solution:
  1. Navigate toLists > Search > Saved Searches > New > Transaction
    1. Set the following values:
      • Public =True
      • Available as Sublist =True
    2. In theCriteriatab:
      • SetUse Expressions =True
      • Add the following filters in theStandardsub tab:
      • Type =Journal
      • (Applied To Transactions : Internal ID (Number) =is not empty or
      • Applying Transactions : Internal ID (Number)=is not empty)
    3. In theResults tab > Columnssub tab
      • SetSummary Type =Groupfor the following fields:
      • Date
      • Number
      • Applied To Transaction
      • Applying Transaction
    4. On theAvailableFilterssubtab, add at least one available filter to the search, and ensure that the first filter listed is aList/Record type. Otherwise, the saved search is not available to assign as a sublist.
    5. Renamethe search
      • Example: Journals Applied
    6. ClickSave
  2. Navigate toCustomization > Forms > Sublists > Transactiontab
    1. Set:
      • Search =Journals Applied
      • Label =Journals Applied
      • Tab =Related Records
      • Journal =True
      • ClickSave

Read More

Resolve Error: "No Match" on Expense Report when entering Job/Project on Expense Report

Customer is encountering a "No Match" error on Expense Reports when entering a Job or Project name under Transactions > Employees > Enter Expense Report > Expenses.

Read More

Creating an Expense Report with NetSuite for Mobile

You can create expense reports directly from your mobile device.

Read More

Logging an Expense with NetSuite for Mobile

Expenses are the basic elements from which you create expense reports. They can include an image of the physical receipt and accompanying description of what the expense relates to. You can attach up to four attachments to an expense enabling you to organize multiple items under a single category.

Read More

Special Characters Are Not Displayed Correctly in the CSV Error File for Failed Bank Data Import

You are using a non-English language as your preferred language in the NetSuite user interface, or your bank statement file contains special characters. Example, .

Read More

Bank Statement CSV File Upload Failure Reason: Unexpected Error

A Microsoft Excel CLEAN function can help to efficiently check and remove all the nonprintable characters from string in the Memo column.

Read More

Select a Default Folder in File Cabinet for Uploaded Expense Images

Select a Default Folder in File Cabinet for Uploaded Expense Image.

Read More

Create an Automatic Email Notification to be Sent to the Creator of a Journal Entry once it is Approved

Scenario

User with an Administrator role wants to generate an automatic email notification to be sent out to the creator of a journal entry once it has been approved.

Solution

The automatic email notification can be generated by creating a Transaction Saved Search through the following steps:

1. Go to Reports > Saved Searches > All Saved Searches > New
2.Choose Transaction
3. On Criteria tab, click Standard
4. Set the following filters:
  • Type : is Journal
  • System Notes : Type : is Change
  • System Notes : New Value : starts with Approved for Posting
6. Click Email tab
  • Send Email Alerts when Records are Created/Updated: Enter Checkmark
  • Recipient From Results:
    • Send on Update: Enter Checkmark
    • Recipient Field: Enter Created By
7. Search Title: Enter Title
8. Click Save & Run

Read More
Read More Articles