I’m creating a production Order through the processing screen where it doesn’t have a SyncTimeTag table used. when i create any transaction manually from the screen its saves a record with the note id in SyncTimeTag table. So, while creating a production order an error throws like Cannot insert the value NULL into column 'NoteID', table 'DB.dbo.SyncTimeTag'; column does not allow nulls. INSERT fails.The statement has been terminated.
Solved
Cannot insert the value NULL into column 'NoteID', table dbo.SyncTimeTag'
Best answer by harikanthm60
I was using PXTimeTagAttribute in the DAC NoteID field [PXTimeTagAttribute(typeof(TSProdOrder.noteID))]
when i comment this its resolved the issue.
Thanks.
Hi
If you are working with any customization package(s), can try by unpublishing all packages, then publishing all the packages again and check.
Translate
+20Hi
Once you restarted the server (IIS) that issue was gone and again did not see that issue.
Translate
+20Here the reference I posted long back this question.
Translate
Translate
+20Hi
I recommend you to raise a support ticket with Acumatica after below verification is compelted.
- Have you unpublished your customization and also observing the same issue?
Translate
Translate
I was using PXTimeTagAttribute in the DAC NoteID field [PXTimeTagAttribute(typeof(TSProdOrder.noteID))]
when i comment this its resolved the issue.
Thanks.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.