FAQ: NetSuite: The Transaction Date is Not Within the Date Range of Your Accounting Period

Christina Dobryzynski
Christina Dobryzynski Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 268 Expensify Team
edited July 2021 in Integrations and API

If you receive the common ExpensiError NS0079 The transaction date you specified is not within the date range of your accounting period error, follow the instructions below to resolve it.

This error occurs when the Posting Period settings in NetSuite are not configured to allow a transaction date outside the posting period. Without this setting enabled, you won't be able to export a report to the next open period.

Solution:

In NetSuite, navigate to Setup > Accounting > Accounting Preferences. Under the General Ledger section make sure the field Allow Transaction Date Outside of the Posting Period is set to Warn.

You can then select if you want your reports to export to the First Open Period or the Current Period.


Also, you'll want to ensure the Export to Next Open Period feature is enabled within the Expensify configuration. Navigate to Settings > Policies > Group > [Policy Name] > Connections > Configure and open up the Advanced tab. From here, confirm the setting is enabled:


Tagged: