autonumber on new screen not working

Hi ​@justen0351,

There are 3 screens to look into for this. The Numbering Sequences, the Segmented Values, and Segmented Keys. There, you will set if you want to AutoNumber, what the numbers range can be, what letters they can start with, etc. Please look there and let me know if you have any questions.

-RJ

​@rkenna i already had the number sequence but not the other two. i filled those out and tried again and i am still getting the error.Does the below look correct? i tried with and without the “Specific module” on the segmented keys.

Can you show the view declaration for the summary part of your screen?

Hello ​@justen0351 I suggest you

1.  check/confirm that  Number Sequence is created for that Branch (1010) is selected.

2. recreate number sequence, add into preference screen & clear cache & try again.

I hope it helps!

Auto-numbering and segmented keys are NOT one-and-the-same. You can use segmented keys without auto-numbering. You can use auto-numbering with segmented keys. You can use auto-numbering without segmented keys.

Justen’s field is not a [PXDimensionSelector], therefore, segmented keys are not part of the equation.

We discussed removing the auto-numbering attribute to see if you can save records without the auto-numbering complication. Have you tried that?

​@Abhishek Niikam I tried that and i am still getting the error.

​@darylbowman i did remove the autonumber. as soon as i type something in the field, i just get this popup and then it will remove whatever i put in there. i thought it might be the selector that causes that, so i removed it from the dac as well but it errors as soon as i type. would i need to change it in the customization project and in the aspx in order to test that?

Then, as I suspected, it’s not an issue with auto-numbering.

Try your selector like this:

[PXSelector(typeof(SearchFor<ProdPlan.planid>.
    In<
        SelectFrom<ProdPlan>.
        Where<ProdPlan.planType.IsEqual<ProdPlan.planType.FromCurrent>>>),
    typeof(ProdPlan.planType),
    typeof(ProdPlan.planid))]

Make sure ‘PlanType’

• commits changes
• has a default value of a valid value

​@darylbowman that didnt work with or without the numbering included. i got the same errors as before.

Could you post your updated PlanID and PlanType DAC fields again?

​@justen0351 silly question but you have that table (ProdPlan) in DB right? & confirm Planid is exist in DB. (for older error you shared on top)

​@darylbowman here is the dac. I did change it from the begining a little. i releaized i had put PlanID in the database but had Planid in the dac. i changed it there and that didnt fix it either. i also changed it in the code that you sent before running it.

namespace PTMProductionPlanningScreen
{
  [Serializable]
  [PXCacheName("ProdPlan")]
  public class ProdPlan : PXBqlTable, IBqlTable
  {
    #region PlanID
    [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCC")]
    [PXUIField(DisplayName = "Planid" , Visibility = PXUIVisibility.SelectorVisible)]
        //[PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]
        // [PXSelector(typeof(ProdPlan.planID), typeof(ProdPlan.planID))]
        [PXSelector(typeof(SearchFor<ProdPlan.planID>.
    In<
        SelectFrom<ProdPlan>.
        Where<ProdPlan.planType.IsEqual<ProdPlan.planType.FromCurrent>>>),
    typeof(ProdPlan.planType),
    typeof(ProdPlan.planID))
]
    [AutoNumber(typeof(AMPSetupExt.usrProdPlanNum),typeof(AccessInfo.businessDate))]
        public virtual string PlanID { get; set; }
    public abstract class planID : PX.Data.BQL.BqlString.Field<planID> { }
    #endregion

    #region PlanType
    [PXDBString(2, IsKey = true, IsUnicode = true, InputMask = "")]
    [PXUIField(DisplayName = "Plan Type")]
    [PXStringList(
           new string[] { "RO"} ,
            new string[] {"Regular Order"}
            )]
    public virtual string PlanType { get; set; }
    public abstract class planType : PX.Data.BQL.BqlString.Field<planType> { }
        #endregion

​@Abhishek Niikam it is in the database. I thought maybe it hadnt gone in because it wouldnt let me query it so i restarted and then it shows up in a query. i was still getting the error after that.

​@darylbowman That worked. Thank you very much!