Question

Error: Value cannot be found in the system.

  • 19 April 2023
  • 6 replies
  • 263 views
V
Rank
Userlevel 3
Badge

Getting the below error when trying to set value for a custom field. I can see the ContractID is in the cache.

All these steps are happening within a transaction scope , so values are yet to be saved to the DB , but are available in the cache.

Stack Trace : 

Error: [UsrMAKLContractID] 'XXXXXX' cannot be found in the system.

 at PX.Data.PXSelectorAttribute.throwNoItem(String[] restricted, Boolean external, Object value)
   at PX.Data.PXSelectorAttribute.Verify(PXCache sender, PXFieldVerifyingEventArgs e, Object& item)
   at PX.Data.PXSelectorAttribute.FieldVerifying(PXCache sender, PXFieldVerifyingEventArgs e)
   at PX.Data.PXCache.OnFieldVerifying(String name, Object row, Object& newValue, Boolean externalCall)
   at PX.Data.PXCache`1.SetValueExt(Object data, String fieldName, Object value)
   at PX.Objects.CR.MAKLQuoteMaintExt.ConvertNewSaleQuote(CRQuote quote) 
   at PX.Objects.CR.MAKLQuoteMaintExt.<>c__DisplayClass127_0.<ConvertToContract>b__0()
   at PX.Data.PXLongOperation.<>c__DisplayClass18_0.<StartOperation>b__0()

6 replies

V
Rank
Userlevel 3
Badge

same steps worked for us in the previous version 2019 R1, currently we have the upgraded version 2022R1.

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi, @vibindas  Are you creating the on-the-fly and trying to assign it to a custom field?

Naveen B
V
Rank
Userlevel 3
Badge

Hi @Naveen Boga , that is correct.

V
Rank
Userlevel 3
Badge

any thoughts on why the same works on 2019 , but not on 2022R1 version?

Chris Hackett
Rank
Userlevel 7
Badge

Hi @vibindas were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
V
Rank
Userlevel 3
Badge

@Chris Hackett , sorry no luck. Only option I see is to set the values outside the transaction scope, save to db and then try to fetch the values. But personally feel it’s not a good approach.

Reply


Terms & ConditionsCookie settings
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 — 2024  Acumatica, Inc. All rights reserved