Reopen Closed Purchase Orders

Navigate to Transactions > Purchases > Enter Purchase Orders > List Edit: Click Edit beside the Purchase Order user wants to open Click Items Closed: Remove Checkmark on each item line you want to reopenNote: If you do not see the Closed column immediately, scroll to the right. If still not found, use the Standard… Continue reading Reopen Closed Purchase Orders

Journal Entry Status = Pending Approval, Click Save But Posting Period is incorrect (changed)

A new Journal Entry was created with the initial status of Pending Approval. The Posting Period was manually selected. When saved, the Posting Period has been changed and not what was expected. Here’s an example: Before Saving:Transaction Date = 9/30/2019Posting Period = Oct 2019Status = Pending Approval After Saving:Posting Period = Nov 2019 This is a standard/expected behavior. For conditionally posting transactions (pending… Continue reading Journal Entry Status = Pending Approval, Click Save But Posting Period is incorrect (changed)

CSV Files for Import

Statement files in CSV format must adhere to the provided CSV template and constraints. To ensure successful import, the column headings must be in the first row in the specified order as follows: Date (MM/DD/YYYY), Payor/Payee Name, Transaction ID, Transaction Type, Amount, Memo, NS Internal Customer ID, NS Customer Name, Invoice Number(s). Date (MM/DD/YYYY) –… Continue reading CSV Files for Import

Run Currency Revaluation Error Resolution

Run Currency Revaluation > Error: Record could not be saved because the period close task for Month End Currency Revaluation has been completed for period Period XX” To resolve this, the user may follow the steps below: 1. Using an Administrator Role, navigate to Setup > Accounting > Manage Accounting Period  2. Click on the Checklist (magnifying glass icon) for the Period XX (as… Continue reading Run Currency Revaluation Error Resolution

How to Change Posting Period on an Invoice

1.  If the Period to which the Invoice should be posted is already Closed, it has to be re-opened first via Setup > Accounting > Manage Accounting Periods 2. Edit the Invoice 3. Set the correct Posting Period and Save it or 1. If the Period to which the Invoice should be posted is still Open 2. Edit the Invoice 3. Set the correct Posting Period and Save it

Journal Entry Approval

A journal entry is posted in a period to which the journal entry approver has access. Until a journal entry is approved, NetSuite displays the posting period based on the transaction date. If this period is locked or closed, the posting period is determined by the accounting preference Default Posting Period When Transaction Date in Closed Periods.… Continue reading Journal Entry Approval

Some Period/s not Showing in Financial Reports When Column is Set to Accounting Period

If you do not have transactions/activity in the said period/month then the said period will not show in the Balance Sheet.  On the other hand, the column for that period will show if you entered a transaction against that period, then eventually deleted it or edited an existing transaction with the same period and edited… Continue reading Some Period/s not Showing in Financial Reports When Column is Set to Accounting Period

Setting Up Your Business Activity Statement

The Business Activity Statement (BAS) is the form you submit to the Australian Taxation Office (ATO) to report your tax liability or to claim a refund. This form is available only in NetSuite Australia edition accounts, and in OneWorld accounts with an Australian subsidiary. We can determine how entries on our business activity statements are… Continue reading Setting Up Your Business Activity Statement

Including Accounts in GL Matching

Go to Reports > Financial > Chart of Accounts. Click Edit next to the Account name that you want to include in GL Matching. Check the Include in GL Matching box on the right side of the page. Click Save.