Hello quite new to acumatica, currently I am trying to add a field onto the Project Quotes screen however the field will not hold any data entered if I save and then leave the page and return to it. Anyone able to help?
Solved
Adding field to project quotes
Best answer by dcomerford
The PMQuote is a projection of the CRQuote table
You may have noticed when you add the field it added CRQuote and the CR.Standalone.Quote entries under the Data Access Class.
So you will need to change the attributes of your field on the PMQuote to something like (the BqlField is telling it basically where to store the data)
[PXDBInt(BqlField=typeof(CR.CRQuoteExt.usrXXXX))]
+15The PMQuote is a projection of the CRQuote table
You may have noticed when you add the field it added CRQuote and the CR.Standalone.Quote entries under the Data Access Class.
So you will need to change the attributes of your field on the PMQuote to something like (the BqlField is telling it basically where to store the data)
[PXDBInt(BqlField=typeof(CR.CRQuoteExt.usrXXXX))]
Dermot Comerford
I had a working set of strings in version 23r2, we upgraded to 24r2 and it no longer saves the data at all.
This looks like a similar issue but I have NO idea where to edit these attributes that you speak of.
Any chance to show a screenshot?
I tried doing this after reading the solution but no luck:
dcomerford wrote:
First thanks for replying to this ancient post!
I tried with a lowercase u with the same issue. This is a fresh blank install of acumatica in a VM.
The DB shows:
I put the text in there with sql to see if it would load any data into acumatica but it did not.
Still getting the error that the field does not exist in the type CRQuote.
I also tried CR.Standalone.CRQuote with the same result.
Pulling my hair out after this last upgrade, to add insult to injury the same custom fields works perfectly fine in the project after converting from quote. I can add/modify text and its saved with no issue.
+15
[PXDBString(BqlField=typeof(CR.CRQuoteExt.usrScope))], it should then publish
Dermot Comerford
1 person likes this
dcomerford wrote:
[PXDBString(BqlField=typeof(CR.CRQuoteExt.usrScope))], it should then publish
Ok I think I got it now.. This saved the data in the database:
I had to use PXDBField, instead of PXDBString and It would not work with CR.CRQuoteExt.usrScope
once I remove the CR. at the beginning it was happy.
Of course now that it worked once my entire test environment is broken and i cant open the quote screen at all now with: Index was out of range. I hope it's not related but progress nonetheless!
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.