Skip to main content
Answer

The entry form cannot be automated. NumberingID is null

  • April 28, 2025
  • 5 replies
  • 67 views

Forum|alt.badge.img+1

Hello-

I’ve created a custom screen where auto numbering is used. When I access the screen I get the following message. 

 

The DAC for the AutoNumber field is below.

[Serializable]
[PXCacheName("PinnATWDW1")]
public class PinnATWDW1 : IBqlTable
{
#region RefNbr
[PXDBString(15, IsKey = true)]
[PXUIField(DisplayName = "Ref Nbr")]
[PXSelector(typeof(PinnATWDW1.refNbr), typeof(PinnATWDW1.refNbr), typeof(PinnATWDW1.hMRCWarehouse), typeof(PinnATWDW1.period))]
[PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]
[AutoNumber(typeof(PinnATWDSetup.w1NumberingSequence), typeof(PinnATWDW1.createdDateTime))]

public virtual string RefNbr { get; set; }
public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { }
#endregion

...other fields...

It has a child table, the DAC for the key fields are below. 

[Serializable]
[PXCacheName("PinnATWDW1Line")]
public class PinnATWDW1Line : IBqlTable
{
#region RefNbr
[PXDBString(15, IsKey = true)]
[PXUIField(DisplayName = "Ref Nbr")]
[PXDBDefault(typeof(PinnATWDW1.refNbr))]
[PXParent(typeof(SelectFrom<PinnATWDW1>.Where<PinnATWDW1.refNbr.IsEqual<PinnATWDW1Line.refNbr.FromCurrent>>))]

public virtual string RefNbr { get; set; }
public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { }
#endregion

#region ProductType
[PXDBString(20, IsKey = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Product Type")]
public virtual string ProductType { get; set; }
public abstract class productType : PX.Data.BQL.BqlString.Field<productType> { }
#endregion

...other fields...

 

I have a custom preferences screen there I have set the number sequence code. 

 

And a Numbering Sequence has been created.

 

This was working last week so I’m really confused. I’m not sure what the error message is trying to tell me and I don’t know how to fix this. Has anyone seen this before?

Best answer by stephenward03

I’ve found a solution to the problem. It was simply that the field holding the numbering sequence was set up incorrectly. I accidentally set it to nchar and it should have been nvarchar. I wasn’t able to link the error returned by the system to a problem with the database datatypes.

5 replies

Forum|alt.badge.img+5
  • Jr Varsity I
  • April 28, 2025

Hi ​@stephenward03,

Have you added the setup view of your Setup DAC PXSetup<SetupDAC> Setup in graph?
Hope, it helps!

 


Forum|alt.badge.img+1
  • Author
  • Varsity III
  • April 29, 2025

Yes, I have used PXSetUp to provide access to the sequencing data. This isnt the cause of the error


Forum|alt.badge.img+8
  • Captain II
  • April 29, 2025

@stephenward03 

 

Have you added a graph constructor to the graph?

Something like this:

public CalibrationEntry()
{
ISOSetup setup = Setup.Current;
}

 


Forum|alt.badge.img+1
  • Author
  • Varsity III
  • Answer
  • April 29, 2025

I’ve found a solution to the problem. It was simply that the field holding the numbering sequence was set up incorrectly. I accidentally set it to nchar and it should have been nvarchar. I wasn’t able to link the error returned by the system to a problem with the database datatypes.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • April 30, 2025

Thank you for sharing your solution with the community ​@stephenward03!