Skip to main content

When trying to create a new customer I keep getting this error message:

“Customer ID is formatted incorrectly”

 

Here is a screenshot:

Creating this same customer works in our development environment which has the same version as our live environment.  Is there some configuration setting I’m missing somehow?

Thanks!

Hello,

Please compare Segmented Keys for Customer ID between Test and Live environments:

Laura


Thanks so much for your reply.  The Segmented Keys screen is the same for both environments:

Is there something specific on that screen, or another, that I should change?

Thanks again!


Hello,

What additional information can you show us from Tools → Trace?

Are you unable to enter ANY new customer ID Value?  For example, does a shorter key work, does alpha only, or numeric only work?

With Override OFF, the Customer key is using configurations from its Parent - Business Account.  Can you also compare to your development environment and  show us BizAcct Segmented Key configurations?

Thanks.

Laura

 


Here is the Segmented Keys screen from our dev environment: 

Here is a trace log:

Error: Inserting 'Customer' record raised at least one error. Please review the errors.

 at PX.Data.PXUIFieldAttribute.CommandPreparing(PXCache sender, PXCommandPreparingEventArgs e)
 at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.<To>b__0(PXCache cache, TArgs args)
 at PX.Data.PXCache.OnCommandPreparing(String name, Object row, Object value, PXDBOperation operation, Type table, FieldDescription& description)
 at PX.Data.PXTableAttribute.PrepareParametersForInsert(PXCache sender, Object row, Type ] tables, ISqlDialect dialect, Boolean audit, List`1i] pars)
 at PX.Data.PXTableAttribute.PersistInserted(PXCache sender, Object row)
 at PX.Data.PXCache`1.PersistInserted(Object row, Boolean bypassInterceptor)
 at PX.Data.PXCache`1.Persist(PXDBOperation operation)
 at PX.Data.PXGraph.Persister.Persist(Type cacheType, PXDBOperation operation)
 at PX.Data.PXGraph.PerformPersist(IPersistPerformer persister)
 at PX.Data.PXGraph.TransactionalPersist()
 at PX.Data.PXGraph.RetryTransaction(Action persistBody, Int32 maxRetries)
 at PX.Data.PXGraph.Persist()
 at PX.Objects.AR.CustomerMaint.Persist()
 at PX.Objects.CR.Extensions.BusinessAccountContactDetailsExt`4.Persist(Action del)
 at PX.Objects.CR.Extensions.DefLocationExt`6.Persist(Action del)
 at PX.Objects.AR.CustomerMaint.PaymentDetailsExt.Persist(Action del)
 at PX.Objects.CR.Extensions.CRPrimaryContactGraphExt`5.Persist(Action del)
 at PX.Objects.FS.SM_CustomerMaint.Persist(Action baseMethod)
 at PX.Data.PXSave`1.<HandlerInternal>g__Persist|3_2()
 at PX.Data.PXSave`1.<HandlerInternal>d__3.MoveNext()
 at PX.Data.PXAction`1.<Press>d__39.MoveNext()
 at PX.Data.PXAction`1.<Press>d__39.MoveNext()
 at PX.Web.UI.PXBaseDataSource.tryExecutePendingCommand(String viewName, String(] sortcolumns, Booleang] descendings, Objecta] searches, Objectb] parameters, PXFilterRow ] filters, DataSourceSelectArguments arguments, Boolean& closeWindowRequired, Int32& adapterStartRow, Int32& adapterTotalRows)
 at PX.Web.UI.PXBaseDataSource.ExecuteSelect(String viewName, DataSourceSelectArguments arguments, PXDSSelectArguments pxarguments)

 

Thanks again for your replies!


I put in a ticket with Acuamtica support and they pointed out that there was a customization dealing with the Customers screen and I didn’t have that customization in my dev environment.  I was able to replicate the error once I published it in dev and was then able to fix the issue.

Thanks again all for your replies, I appreciate it!


Reply