Skip to main content
Solved

Customer ID format error.

  • November 5, 2024
  • 5 replies
  • 19 views

asommer
Jr Varsity III
Forum|alt.badge.img

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!

Best answer by asommer

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!

View original
Did this topic help you find an answer to your question?

5 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • November 5, 2024

Hello,

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

Laura


asommer
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 21 replies
  • November 5, 2024

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!


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • November 5, 2024

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

 


asommer
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 21 replies
  • November 5, 2024

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`1[] 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, Boolean[] descendings, Object[] searches, Object[] 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!


asommer
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 21 replies
  • Answer
  • November 12, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings