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.
Answer
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.
+19Hi
Once you restarted the server (IIS) that issue was gone and again did not see that issue.
+19Here the reference I posted long back this question.
+19Hi
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?
I was using PXTimeTagAttribute in the DAC NoteID field [PXTimeTagAttribute(typeof(TSProdOrder.noteID))]
when i comment this its resolved the issue.
Thanks.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.