Loading postage for Endicia (USPS) Transactions

To load postage to an Endicia (USPS) Account:

 

1. Navigate to Setup > Accounting > Shipping.
2. In your USPS account, select Fund Account .
3. Enter amount and web password.
4. Click on Send USPS Funding Request.

Credit Memos are not showing on Sales Reports

Sales Reports will display transactions that posted to Income or Other Income type of accounts. If credit memos are not showing on Sales Reports, check the GL Impact of the transaction record.

If a credit memo hits the COGS account, it is an expected behavior that this will not be displayed on Sales Reports. Users may also check the account selected for the item record.

1.    Pull up the Credit Memo.

2.    Click the Item name.

3.    On the item record, go to Accounting tab.

4.    Verify if the account set on the Item is a non-Income or Other Income type of account.

Void a Customer Refund in a Closed Period

To accomplish this, a user needs to:

1. Log in as an Administrator
2. Go to Setup > Accounting > Manage Accounting Periods.
3. Click on the Period where the Payment record lies.
4. On the Edit Base Period page, check the Allow Non-G/L Changes box > click Save.
5. Open the Payment record > click Edit.
6. On the Apply tab > Invoices subtab, uncheck the box representing the Customer Refund > click Save.

To void the Customer Refund:
1. Make sure the Void Transactions Using Reversing Journals = Checked/True under Setup > Accounting > Accounting Preferences > Order Management tab > General Ledger portion/portlet. (You may turn this off once you void the customer refund.)
2. Edit the Customer Refund.
3. Click the Void button.

After the Customer Refund has been voided, make sure of the following:

1. Navigate back to Setup > Accounting > Manage Accounting Periods.
2. Click on the Period where the Payment record lies.
3. On the Edit Base Period page, uncheck the Allow Non-G/L Changes box > click Save.

Extract the Day, Month or Year from a Date or Date/Time Field

Users can use the following formulas to extract the day, month or year from a Date field or Date/Time field:

• To extract the day: EXTRACT(DAY FROM {datefield})
• To extract the month: EXTRACT(MONTH FROM {datefield})
• To extract the year: EXTRACT(YEAR FROM {datefield})

The formula extracts details from any date. Example: If today is 12/6/2013. The formula EXTRACT(DAY FROM {today}) will extract the day from the today's date and show "6" as result.

Identify whether Custom Detail Report will route to Custom or Standard Summary Report

There are instances when a user who is viewing a custom Detail Report that is linked to a custom Summary Report experienced being transported to the Standard Summary report.

To identify if the user will be directed to the original custom report, or to the standard report, take note of the link on the detailed report. If the link for the summary is View Summary, user will be directed to the standard summary report. But if the user sees Back to Summary, user will go to the custom summary report it originated.

The following scenarios will help identify if the user will be directed to the original custom report, or to a standard report:

1.     Custom Summary Report > hit view detail > Custom Detail Report > hit back to summary > Custom Summary Report.

2.     Custom Summary Report > hit view detail > Custom Detail Report > click customize > hit preview > Custom Detail Report > hit back to summary > Custom Summary Report

3.     Custom Summary Report > hit view detail > Custom Detail Report > click customize > hit save > Custom Detail Report > hit view summary > Standard Summary Report

4.     Reports > Saved Reports > Custom Detail Report > hit view summary > Standard Summary Report

Company Information's Shipping Address is being Pulled Up Instead of the Subsidiary's Shipping Address

The Ship To address in the purchase order form follows the address specified in the Location selected for the transaction. If no location is selected, it pulls up the address from the Company Information page.

Maximum Number of Characters allowed on a Free-Form Text type custom Transaction Body Field field

The maximum number of characters allowed on a Free-Form Text type custom Transaction Body Field, including spaces is 300 by default.

Maximum number of characters allowed on the Email field on a Case record

The maximum number of characters allowed on the Email field on a Case record, including spaces is 300.

Adaptive Insights: Enter Currency Exchange Rate

This article is intended for accounts integrated with Adaptive Insights, NetSuite's partner in delivering financial management solutions.

Here are the steps on how to enter Currency Exchange Rates in Adaptive Insights:

1. Navigate to Admin > System > Manage Currencies.

2. Click on Enter Currency Exchange Rates Link.

3. It will route the user to Enter Currency Exchange Rates Page and user can filter it to specific Currency (e.g., USD) and Rate Type (e.g., Avg) for easier access.

4. User can now enter Exchange Rate per Month.

5. Save.

Note: Months and Periods which are open for Currency Exchange Rate assignment are dependent on the Version.

For more information, refer to this link found in Adaptive Insights Help Page: http://help.adaptiveplanning.com/hosted/10.5.3/help/EnterCurrencyExchangeRates.html

 

Discrepancy between Bank Register Balance and Reconciliation Report Balance

Scenario:

•        Navigate to Lists > Accounting > Accounts > clickon Bank account to view Bank Register

•        Navigate to Reports > Banking/Budgeting >Reconciliation > choose the bank account

•        There is a discrepancybetween the Bank Register balanceand the Reconciliation Reportbalance

 

 

Solution:

•        BankRegister balances under Lists> Accounting > Accounts > Bankaccount provides the running balanceof the account.

•        The balance in this windowis the correct balance unlessthere were transactions that were not posted yet in the system but are showingin the Bank Statement. In whichcase, the user will need to encode those transactions into NetSuite.

 

•        In instances where there isa discrepancy between the Bank Register and the Bank Reconciliationas of a certain date, user will need first to get the total discrepancy amount between the two reports.

•        User will also need to:

1.   Navigate to Transactions> Bank > Reconcile Bank Statement

2.   Choose the bank account inthe Account field

3.   Click History

4.   Modify the date range inthe Reconciliation History Report to show all reconciliations

5.   Add the total of Difference

 

•        In most cases, the totaldiscrepancy will match the total amount of Difference in theReconciliation History Report.

•        User needs to correct thosereconciliations with discrepancies to match the Bank Register to the BankReconciliation Report.

Adaptive Insights > Enable CTA (Cumulative Translation Adjustment)

The CTA or Cumulative Translation Adjustment is a value used to adjust for the variances in exchange rates due to different exchange rate types being used in an account.

Here are the steps to enable CTA in Adaptive Planning.

1. Navigate to Admin > System > Manage Currencies > Settings panel.

2. Check Enable cumulative translation adjustment (CTA).

3. Click OK on the prompt saying that it will enable CTA.

 

Remove Transaction Timeline for a Specific Role

Below are the steps to remove the transaction timeline for a specific role:

--Navigate to Customization > Scripting > Script Deployments.
--Look for customdeploy_tt_bar_ue and click Edit (the related script is TT Widget UE).
--Under Audience tab, notice that All Roles box was checked.  Uncheck this box and choose the role/s that you want the transaction timeline to appear (example: Administrator, Accountant).
--Click Save.

Transaction timeline will only show to the role/s selected.

Show the Accounts affected by the Purchase Order

1. Navigate to Transactions > Purchases/Vendors > Enter Purchase Orders > List.

2. Click on Customize View.

3. Click More Options.

4. On the Criteria subtab:

a. Remove the Filter, Main Line is true.

b. Add the Filter, Type > select Purchase Order > click Set.

5. On the Results subtab, add the following fields:

a. Amount (Credit)

b. Amount (Debit)

Note: Add all the other fields that should appear on the List.

6. Click Preview.