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.
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.
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"
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.
Edit Statement Date of a previous Reconciled Account Statement
The user inadvertently reconciled their account statement without changing the Statement End Date.
Update Memorized Transactions
User needs to update the details on a transaction that has been memorized.
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.
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."
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"
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.
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.
Journal Entries > Related Records tab > Payments subtab > view applied to and applying transaction to this transaction
Scenario
- 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
- Navigate toLists > Search > Saved Searches > New > Transaction
- Set the following values:
- Public =True
- Available as Sublist =True
- 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)
- In theResults tab > Columnssub tab
- SetSummary Type =Groupfor the following fields:
- Date
- Number
- Applied To Transaction
- Applying Transaction
- 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.
- Renamethe search
- Example: Journals Applied
- ClickSave
- Set the following values:
- Navigate toCustomization > Forms > Sublists > Transactiontab
- Set:
- Search =Journals Applied
- Label =Journals Applied
- Tab =Related Records
- Journal =True
- ClickSave
- Set:
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.
Creating an Expense Report with NetSuite for Mobile
You can create expense reports directly from your mobile device.
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.
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, .
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.
Select a Default Folder in File Cabinet for Uploaded Expense Images
Select a Default Folder in File Cabinet for Uploaded Expense Image.
Create an Automatic Email Notification to be Sent to the Creator of a Journal Entry once it is Approved
Scenario
Solution
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
- Send Email Alerts when Records are Created/Updated: Enter Checkmark
- Recipient From Results:
- Send on Update: Enter Checkmark
- Recipient Field: Enter Created By
8. Click Save & Run