Is there a way to run a bank register that shows multiple banks in one report? Any way I try to run it, I only get one bank.

ARM question - anyone know how to “reset” the reclassification process? Reclassification process was run before the recognition process and we haven’t run the reclassification each period

Does anybody know why when I try to update account Realized Exchange rate diff with "subaccount of" field, its disabled?

Anyone know of functionality to automate accrual of PO expense lines upon receipt? I understand that the item record has a generate accrual checkbox but how can we automate accrual of receipted expenses

Does anyone know the GL impact of the following: Inventory is managed on a FIFO basis, inventory is received with landed costs, some inventory units are sold, item receipt is edited and landed costs are updated. Will the change in landed cost for the pieces that have been sold hit COGS, would the "original" journal entry be undated to reflect different amounts or would a second journal be posted?

Does anyone know why our manual accounts receivable account is not getting revalued even though we have the account set up with revaluation? Only journals booked to the account (no invoices created in Netsuite). This is a manual AR account from an earlier system hence why we are not creating invoices. Only payments with journals are booked on this account and when we run revaluation nothing gets revalued.

Hello. Got a question regarding the Bank Reconciliation Feature - it seems like when creating custom reconciliation rules, it is only possible to match to the Journal Memo header rather than journal line memo. Has anyone experienced this limitation?

Hi, we noticed today that the GBP to USD exchange rate used to calculate the net income of our UK entity for FY 2020 is 1.05 - which is very low (we would expect something closer to 1.30). We've compared all accounts in USD vs GBP, period by period, and everything looks fine (NetSuite translates each month at the period average rate, as expected) - however when we get to the total, all accounts look fine, except the net income exchange rate is way off and we cannot explain why. Any clues? Thanks!

HI all, I have a question about Statements, and maybe other down stream functions/operations as well. We are implementing a new order workflow into our System - specifically website orders from a new BigCommerce website. Depending on the setup for the customer, some will pay for their order online with a credit card, others will be invoiced from Netsuite. The Credit Card orders seem to flow fine, with the CyberSource transaction id coming across from site in the sales order. Once an order is fulfilled, a cash sale is created. When we run a statement, the cash sales do not show up, only invoices. Is this normal? I would expect to see all transactions would show up. Perhaps there is a setting that i'm not aware of. Any insight would be appreciated. My accounting background is light. thanks!

Hey all, we are setting up Allocation Schedules (using Oneworld and Multibooks) in Sandbox and want to move them to Production environment, but I cannot seem to bundle them, move to account or otherwise move them to Production in a meaningful and less manual way than recreating each schedule manually in Production. Anybody have experience with moving these kind of records between environments? Thanks in advance!

Hey all - we currently have wire fees, bank fees, and stripe fees after a customer pays where the payment comes in net of fee, and creates a difference on the invoice and we are creating credit memo records for this difference to close out the invoice. Is there a better way to do this? How are people ingesting fees is it somewhere on the payment record?

Hi everyone. Does anyone know much about why NetSuite does not zero out all the Income Statement accounts during the year end closing process. When we are reviewing the Trial Balance there is an "Initial Balance" that gets carried over from the previous year for Income Statement accounts and these should start at $0 each new year. Is there a setting that I have not enabled to do this? Thanks

__ludlow  [5:35 PM]_ ARM question - anyone know how to “reset” the reclassification process? Reclassification process was run before the recognition process and we haven’t run the reclassification each period Firstly if using schedules then change the time to occur after the Rev Rec journals have run. Usually to reset the deletion of the journals created by the reclassification process works.

When billing a PO, my vendor bill's item rate is not being set to the rate of the line on the PO; it looks like it is taking PO Amount / PO Qty to re-calculate the rate, even though I have the "Use Purchase Order Rate on Bills" accounting preference on. Can anyone confirm this is intended? I'm about to open a support case with NetSuite because I cannot find any supporting documentation for this. It's screwing up our VB Approval Matching Workflow.

is there a way to set it so that vendor bills that for vendors with EFT info on the record do NOT show up in the Transactions->Payables->Pay Bills listing, but only in the Payments->Payment Processing->Bill Payment Processing listing? Or does anyone have any best practices they can share for how they manage these? We've recently started paying some vendors via EFT, and it's not uniform because our AP clerk will just pay them via check before we can pay them via EFT and it's throwing our vendors off

Anyone here who's worked on customized reports with the FASB Financial Position layout from netsuite? I'm wondering why some of my accounts are there when I preview the layout but not on the actual report.

Hi, has anyone managed a way to include Vendor Credits in a Bill Payment remittance? It looks like they're applied to the Bill itself, not the Bill Payment - so not sure the best way to go about this. We need to submit a remittance to the vendor that includes all Bills and Bill Credits, not just Bills with the reduced payment amount.

The NetSuite EFT documentation shows a list of supported bank formats, but the one we need does not appear in our list [Payment File Format]. Do we add them manually?

any recommendations on plug in to Netsuite that can help automate our AP process?

Hello wondering if anyone has encountered this issue. I tried to import and manually enter budgets using the setup budgets feature in NetSuite. The import was successful and i think regardless cause even if I manually enter it. The data does not display in the the Budget Income Statement or Budget vs Actual report. I tried the the exact same data to a different account but this time it does show up in the reports. Is there something Im missing?

Any recommendations for a cash matching tool? We have looked at Nolan and Blackline.

Hello, any idea why on the Payment Event it's indicated in EURO and not in US Dollar ? My customer is in USD and the transaction is in USD. It doesn't seem to have an impact because it's only recording an external payment but it's weird.

How do you handle a customer with several VAT-codes (different countries)? I want to be able to get statistics of the top 5 customers but today we have separate customer cards for the same customer, only the VAT-code is different and this causes inaccurate representation of the top 5 sales.

Hi, looking for suggestions about hot to have retained earnings set to zero at the end of the year without having any effect at a consolidated level with multiple currencies and subsidiaries involved. Today I’ve been told that this is a known issues in NetSuite everyone is aware of but I don’t want to believe it. I’m sure someone found a way to close retained earnings at a consolidated level and not only at a Local level

Multibooks Topic Backfilling: We need to post/repost bookings on our secondary book for the past months and were wondering if anyone had found a simple approach to retrigger the secondary book postings for these past transactions without manually creating the secondary book postings. Any advice is appreciated!

Does anyone have experience with starting to accept Credit Card payment from customers who have an invoice generated in Netsuite? We looked at Stripe but seemed expensive just wondering anyone has used other payment processors/integrations for this.

how do you remove the totals/Numbers of inactive subsidiaries from Income Statement and balance sheets?

is there any way to enable taxes on purchases for a US subsidiary.

one of my customers wants to track taxes on purchase and vendor bills

is there a way to default all of the standard reports to drop decimal places?