Question

Changing companies no Branches to companies with Branches no balancing

  • 1 February 2022
  • 5 replies
  • 189 views

I have a customer who pulled a 180 on us and now wants to use Companies with Branches no balancing.  When i go to companies and change it i get the following error.

Error: An error occurred during processing of the field Sales Sub. value 4 Error: 'Department' of 'Sales Sub.' does not exist in the system.

 

Also when i go to change one from companies with branches back i get

Sequence contains no elements

 

Any help would be great.


5 replies

Userlevel 7
Badge +8

Hi @bradyr82 

First error  indicates that one of the segment value ( segment name ‘Department’ ) of Sub account segment key does not exist. You may have enabled ‘validate’ for the Subaccount segment key and hence it expects the value to be created. 

Second error is not giving much details. You may provide the Trace log (Tools >Trace) to check further. 

Regards,

Here is error for second half of the post

 

2/2/2022 3:14:09 PM Error:
Error: Another process has added the 'Organization' record. Your changes will be lost.

   at PX.Data.PXCache`1.PersistInserted(Object row, Boolean bypassInterceptor)
   at PX.Data.PXCache`1.Persist(PXDBOperation operation)
   at PX.Data.PXGraph.Persist(Type cacheType, PXDBOperation operation)
   at PX.Objects.CS.OrganizationMaint.Persist(Type cacheType, PXDBOperation operation)
   at PX.Data.PXGraph.Persist()
   at PX.Objects.CS.OrganizationMaint.Persist()
   at PX.Data.PXSave`1.d__2.MoveNext()
   at PX.Data.PXAction`1.d__38.MoveNext()
   at PX.Data.PXAction`1.d__38.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)

Here is trace for for top portion.

 

2/2/2022 3:21:39 PM Error:
Error: An error occurred during processing of the field Sales Sub. value 4 Error: 'Department' of 'Sales Sub.' does not exist in the system.

PX.Data.PXSetPropertyException: Error: 'Department' of '[CSalesSubID]' does not exist in the system.
   at PX.Data.PXDimensionSelectorAttribute.FieldVerifying(PXCache sender, PXFieldVerifyingEventArgs e)
   at PX.Data.PXCache.OnFieldVerifying(String name, Object row, Object& newValue, Boolean externalCall)
   at PX.Data.PXCache`1.FillWithValues(TNode item, TNode copy, TNode newitem)
   at PX.Data.PXCache`1.FillWithValues(TNode item, TNode copy, TNode newitem)
   at PX.Data.PXCache`1.Update(Object data, Boolean bypassinterceptor)
   at PX.Data.PXCache`1.Update(Object data)
   at PX.Objects.CS.OrganizationMaint.CopyLocationDataToBranch(PXGraph graph, Location destLocation, Contact destLocationContact)
   at PX.Objects.CS.OrganizationMaint.CreateSeparateBAccountForBranch(String acctCD, String acctName)
   at PX.Objects.CS.OrganizationMaint.MakeBranchSeparate(OrganizationBAccount orgBAccount)
   at PX.Objects.CS.OrganizationMaint.ProcessOrganizationTypeChanging(PXEntryStatus orgBAccountStatus, Organization origOrganization, Organization organization)
   at PX.Objects.CS.OrganizationMaint.Persist()
   at PX.Data.PXSave`1.d__2.MoveNext()
   at PX.Data.PXAction`1.d__38.MoveNext()
   at PX.Data.PXAction`1.d__38.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)

Userlevel 7
Badge

Hi @bradyr82  were you ever able to resolve your issue? Thank you!

Userlevel 3
Badge +1

We experienced a similar issue and curious about the resolution as well.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved