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!
Page 1 / 1
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!