25 R1 - Auto Numbering is NOT working for Custom field in Custom screen

make sure this field has a  value in the preference screen. NBBLINSetupExt.usrNBBLNumberingID

The code itself looks ok. The issue may be somewhere else, e.g. data not being entered in the setup field or UI definition.

Do you also have a constructor for the graph where you are forcing the graph to call the view where your custom autonumber code resides? e.g.
 

INSetup inSetup = AutoSetupView.Current;

NBBLINSetupExt inSetupExt = inSetup.GetExtension<NBBLINSetupExt>();

Hi ​@nsmith51
Try adjusting your PXDBString attribute by adding the InputMask property as shown below:

[PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC")]

Additionally, make sure that the Numbering Sequence you entered in the NBBLINSetupExt.usrNBBLNumberingID field has the Manual Numbering checkbox unchecked:

Yes, configured properly at Inventory Preferences screen.

Any field in the screen when I enter the value and tab it and it is clearing automatically.

When I try to delete old records also getting below error.

 

​@nsmith51  the Primary Graph of your DAC is having “1” in the end.

[PXPrimaryGraph(typeof(NBBatchLabelMaint1))]

but you have this graph - NBBatchLabelMaint .

  public class NBBatchLabelMaint : PXGraph<NBBatchLabelMaint, NBBLCBatchLabel>
  {

      public SelectFrom<NBBLCBatchLabel>.View NBBLCHeaderView;

      public SelectFrom<NBBLCLabelItems>
          .Where<NBBLCLabelItems.batchNbr.IsEqual<NBBLCBatchLabel.batchNbr.FromCurrent>>
          .View NBBLCDetails;


      public PXSetup<INSetup> AutoSetupView;

}

​@palbores Sorry. That I have added by mistakenly. I don’t have that in my code.

Can anyone please give me the idea that why field value is clearing when I enter a value in header fields?

There is something wrong in this DAC - NBBLCLabelItems
 

 public SelectFrom<NBBLCLabelItems>
          .Where<NBBLCLabelItems.batchNbr.IsEqual<NBBLCBatchLabel.batchNbr.FromCurrent>>
          .View NBBLCDetails;

Here is the DAC for the NBBLCLabelItems.

    [Serializable]
    [PXCacheName("NBBLC Primary Listing Item")]
    // public class NBBLCPrimaryListingItem : PXBqlTable, IBqlTable
    public class NBBLCLabelItems : PXBqlTable, IBqlTable
    {
        #region LineNbr
        [PXDBIdentity(IsKey = true)]
        [PXUIField(DisplayName = "Line Nbr", Enabled = false)]
        public virtual int? LineNbr { get; set; }
        public abstract class lineNbr : BqlInt.Field<lineNbr> { }
        #endregion

        #region BatchNbr
        [PXDBString(15)]
        [PXDBDefault(typeof(NBBLCBatchLabel.batchNbr))]
        [PXParent(typeof(Select<NBBLCBatchLabel,
        Where<NBBLCBatchLabel.batchNbr, Equal<Current<NBBLCBatchLabel.batchNbr>>>>))]
        public virtual string BatchNbr { get; set; }
        public abstract class batchNbr : BqlString.Field<batchNbr> { }
        #endregion

        #region InventoryID
        [Inventory]
        [PXUIField(DisplayName = "Inventory ID")]
        public virtual int? InventoryID { get; set; }
        public abstract class inventoryID : BqlInt.Field<inventoryID> { }
        #endregion

        #region Description
        [PXDBString(256, IsUnicode = true)]
        [PXUIField(DisplayName = "Description", IsReadOnly = true)]
        [PXFormula(typeof(Selector<inventoryID, InventoryItem.descr>))]
        public virtual string Description { get; set; }
        public abstract class description : BqlString.Field<description> { }
        #endregion

        #region CreatedByID
        [PXDBCreatedByID()]
        public virtual Guid? CreatedByID { get; set; }
        public abstract class createdByID : BqlGuid.Field<createdByID> { }
        #endregion

        #region CreatedByScreenID
        [PXDBCreatedByScreenID()]
        public virtual string CreatedByScreenID { get; set; }
        public abstract class createdByScreenID : BqlString.Field<createdByScreenID> { }
        #endregion

        #region CreatedDateTime
        [PXDBCreatedDateTime()]
        public virtual DateTime? CreatedDateTime { get; set; }
        public abstract class createdDateTime : BqlDateTime.Field<createdDateTime> { }
        #endregion

        #region LastModifiedByID
        [PXDBLastModifiedByID()]
        public virtual Guid? LastModifiedByID { get; set; }
        public abstract class lastModifiedByID : BqlGuid.Field<lastModifiedByID> { }
        #endregion

        #region LastModifiedByScreenID
        [PXDBLastModifiedByScreenID()]
        public virtual string LastModifiedByScreenID { get; set; }
        public abstract class lastModifiedByScreenID : BqlString.Field<lastModifiedByScreenID> { }
        #endregion

        #region LastModifiedDateTime
        [PXDBLastModifiedDateTime()]
        public virtual DateTime? LastModifiedDateTime { get; set; }
        public abstract class lastModifiedDateTime : BqlDateTime.Field<lastModifiedDateTime> { }
        #endregion

        #region NoteID
        [PXNote()]
        public virtual Guid? NoteID { get; set; }
        public abstract class noteID : BqlGuid.Field<noteID> { }
        #endregion

        #region Tstamp
        [PXDBTimestamp()]
        [PXUIField(DisplayName = "Tstamp")]
        public virtual byte[] Tstamp { get; set; }
        public abstract class tstamp : BqlByteArray.Field<tstamp> { }
        #endregion
    }

For your NBBLCLabelItems.batchNbr field.

Change the PXParent

[PXParent(typeof(Select<NBBLCBatchLabel,Where<NBBLCBatchLabel.batchNbr, Equal<Current<batchNbr>>>>))

That did not help and value is still clearing from the header fields.

​@Naveen Boga  ​@darylbowman  Can you please review and provide your inputs.

It would be helpful if you could share the remaining related code snippets (including the using sections). With that, I can try to reproduce the issue and help find a solution:

• Master DAC

• DB table schemas (XML files)

• ASPX

The fields blanking is likely due to a key error, but there are other possibilities.

Firstly, have you restarted the application (from Apply Updates) since the changes? Selectors are very finicky.

Next, what is the key on your table?

If you remove the AutoNumber designation, how do the records behave?

Also, I don't think this is your issue, but BatchNbr in the detail DAC needs to designate IsUnicode = true

Hey ​@Naveen Boga  Thank you so much. I don’t know the root cause here but when I add the CacheAttached Event it solves the problem.

BIG THANKS TO YOU!!

Just curious. Did you try restarting before adding the CacheAttached? I haven’t figured out why sometimes selector attributes don’t ‘stick’, but it makes sense if it wasn’t ‘sticking’ that it being added dynamically in CacheAttached would possibly remedy the situation.