Back

Error in SmartConnect Cannot insert the value NULL into column ‘PERIODID’

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When running a GL transaction map, receiving an error that says “Cannot insert the value NULL into column ‘PERIODID’, table ‘TWO.dbo.GL10000’; column does not allow nulls. INSERT fails. The statement has been terminated.”


This means that the fiscal period for the date the transaction falls in has not been created. Create a new fiscal period that encompasses the transaction date, and the record will import.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.