Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Opening Balance / AP+AR Aging / Exchange Rate
Hi,
We are about to go live. We are currently working through migrating from our old system (Xero) to Netsuite and thought we had a good idea of the processes involved. Our solutions provider here is very good, but we've come up against a problem that we can't get an answer to. Here we go...
We have a load of open bills and invoices, all in a number of currencies. Each as it's own exchange rate at the date the invoice/bill was created. Nothing strange there.
We have uploaded all of these as per the Best Practices document provided by our local solutions partner. ie: we have imported via CSV import each invoice and bill, applying the historical exchange rate on each one correctly. Here are our issues: