Cannot insert the value NULL into column 'PERIODID'

(0) Share

Report

Posted on by Jack Smith

195

I'm uploading journals into GP 2010 using SmartConnect and I am getting the following error message:

"... Cannot insert the value NULL into column 'PERIODID', table 'KHC_T.dbo.GL10000', column does not allow nulls, INSERT fails. The statement has been terminated...."

Can anyone help??

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Kevin Johnson Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Jack,

Be sure that the transaction date that you're passing in has a fiscal period setup for it in Fiscal Periods Setup (Tools > Setup > Company > Fiscal Periods). This error will occur if you try to pass a transaction date that does not fall into an existing fiscal period.

Was this reply helpful? Yes No