Yes this is exactly what I was looking for thank you very much @Naveen B And inside of the GetLastSalesPrice method, is there a way to do a direct SQL call or am I forced to do a PXSelect type command?
Thanks @Gabriel Michaud For future reference, where would that class for the constant go inside of my customization project?Code - Create Code File - New Graph or Code File?
UPDATE: It is now working.. The first attribute of that UsrProjectCodeID should have been PXDBString instead of PXString. Thanks again for all the help, saved me a ton of time. @ddunn @Naveen B
@Naveen B By mentioning the BAccount DAC extension, you reminded me of something.. I can now get the selector control to populate by overriding the DAC class like this:using PX.Data.BQL.Fluent;using PX.Data.EP;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CR.MassProcess;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.TX;using PX.Objects;using PX.SM;using PX.TM;using System.Collections.Generic;using System.Diagnostics;using System;namespace M5_Blaze_ProjectCodes{ public class BAccountExt : PXCacheExtension<PX.Objects.CR.BAccount> { #region UsrProjectCodeID [PXString(20)] [PXSelector(typeof(Search<ProjectCode.projectCodeID>), typeof(ProjectCode.projectCodeID), typeof(ProjectCode.description))] [PXDefault] [PXUIField(DisplayName="Project Code")] public virtual string UsrProjectCodeID{ get; set; } public abstract class usrProjectCodeID :
OK @ddunn @Naveen B here is all the info on my project..M504000 is a new screen that is used to maintain the project codes (new SQL table) that I want to fill this selector/combobox control which will be added to the AP303000 screen. The graph for M504000 is ProjectCodesMaint while the DAC class is ProjectCodeHere is the graph and DAC class for the two code classes:using System;using PX.Data;namespace M5_Blaze_ProjectCodes{ [PXCacheName("Project Codes")] public class ProjectCode : IBqlTable { #region ProjectCodeID [PXDBString(20, IsKey = true, IsFixed = true, IsUnicode = true, InputMask = ">aaaaaa")] [PXDefault] [PXUIField(DisplayName = "Code")] public virtual string ProjectCodeID { get; set; } public abstract class projectCodeID : PX.Data.BQL.BqlString.Field<projectCodeID> { } #endregion #region Description [PXDBString(60, IsFixed = true, IsUnicode = true, InputMask = "")] [PXDefault] [PXUIField(DisplayName = "Description")] public virtu
Yes they are named the same. The error seems to be coming from the Data Access Class’ extension.
Yes the ProjectCode class is a public class under the Code section of my customization project that I created like this:
@ddunn Yes I have configured the PXSelector attribute inside of my custom field but I am receiving an error when I try to publish This is my PXSelector line:[PXSelector(typeof(Search<ProjectCode.projectCodeID>))] Error message:CS0246: The type or namespace name 'ProjectCode' could not be found (are you missing a using directive or an assembly reference?)
@ddunn Any type of multi-value control will do as long as I can fill the values from my custom SQL table
@Naveen BWow.. Simply removing the extra code in my graph solved all of the issues. I am thankful that it was such an easy solution and for your help. Thank you!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.