Develop Customizations

Hi everyone.I create a method that get the last value of a table. But the order by desc is not working. I put the code and explain in detail In this example. I get a value (and it should be the last, but its the first ever) The “order by” clause its not working.  public int getLastPhaseCode() { PXResult<CEPhaseCodes> res = SelectFrom<CEPhaseCodes>.OrderBy<CEPhaseCodes.phaseCode.Desc>.View. Select(this).FirstOrDefault(); CEPhaseCodes p = (CEPhaseCodes)res; return (p != null) ? Convert.ToInt32(p.PhaseCode) : 0; }Aditional.CEPhaseCodes is my DAC/Table Can you help me please!  

Hello Good Night. I have a problem filtering a Sql view.  I have a grid and i want to asign the vendor name in the corresponding column when i select a new vendor. I use de FieldUpdated Event. Then event works but when i want to filter by V_CEVendors (My Sql view) , the condition not work. I did a test with the table BAccount and apply the same filter and it worked. For which I do not understand the reason that with the sql view my filter is not working First scenario: FieldUpdated with mi SQL View V_CEVendors (not working)In the IdTest column I am sending the value of the selected VendorId, but when I enter the filter the “itemovista” does not return anything. I have checked the fields of my view and they are all correct. public SelectFrom<V_CEVendors>.View viewV_CEVendors; protected void _(Events.FieldUpdated<CEEstimateEstimate, CEEstimateEstimate.idTest> e) { var row = (CEEstimateEstimate)e.Row; V_CEVendors itemovista = viewV_CEVendors.Select()

Hello, I have to override VendorActive attribute selector from Bills and adjustment screen to restrict certain vendors to be displayed in selector who are assigned with certain vendor classes with “require tax zone” field as false. I have tried to override the attribute but I’m unable to join vendor class table to restrict vendors based on required tax zone = false.Can anyone guide me to restrict the vendor active attribute with certain condition from vendor class table.Thanks in advance.  

Please advise on how to custom the Pop up Notes become “Internal Notes” for SO and PO Screen.  Thanks,Idrus

I have added a field (Profit Center) to the Sales Order header and detail tables. After requiring the field on the header, that field is then used as the default for the corresponding field when the user is adding detail lines to the sales order. This functionality is correctly working for all scenarios EXCEPT for the very first record when the header is unsaved.. Once the header is saved, then upon creating a detail record the field is correctly defaulted. Both fields have the same underlying data and work as intended on their own as selector controls.  Here is what is weird.. When entering a new header and before saving once you add a record in the Document Details grid, the first record does NOT default correctly. If you delete that record and then use the Add Row button, the new record now defaults correctly.  Here is the code for the SO.SOOrder DAC extension:[PXDBString(20)][PXSelector(typeof(Search<ReasonCode.reasonCodeID, Where<ReasonCode.usage, Equal<ReasonCodeUsages.s

My code is taking the file that the Batch Payments.Export action has created and set it up for file synchronization.The challenge is that my code isn’t waiting for the file to be generated.  If I click the button again I am able to find the file and update it.Is there a different way that I should wait for the Base.export.Press(adapter) process to finish before continuing on with the rest of the code?  [PXOverride] public virtual IEnumerable Export(PXAdapter adapter) { Base.export.Press(adapter); PXLongOperation.WaitCompletion(Base.UID); UploadFileMaintenance fm = PXGraph.CreateInstance<UploadFileMaintenance>(); var batchCache = Base.Caches[typeof(CABatch)]; var fileNotes = PXNoteAttribute.GetFileNotes(batchCache, batchCache.Current); UploadFile theFile = (UploadFile)PXSelect<UploadFile, Where<UploadFile.fileID, Equal<Required<UploadFile.fileID>>>>.Select(new PXGraph(), fileNote); if (theFile == null

I need to integrate an external service for dynamic map viewing (Esri) into one of the screens in our Acumatica customer portal.I’m trying to achieve this by adding a JavaScript control in a new Customization Project screen that will include a script to request, load the map and display it on this screen.My JavaScript code works as it should if I test it on a blank html page, but it gives me errors if I add it to the JavaScript control in the Customization Project screen and try to preview the changes.This code requires external libraries that are correctly linked and loaded when I use a blank html page to test it, and I suspect this is what’s causing problems when I try it inside the Acumatica screen.The code breaks when calling a specific function named “require”:require(["esri/views/MapView", "esri/WebMap", "esri/identity/IdentityManager"], function(MapView,WebMap,esriId) { /* code not running in Acumatica */ });I believe when Acumatica compiles my JavaScript code, it ends up making

Need to attach an email to a case,  has passed Case noteID as refNoteID, but relatedEntity returns Null. Email is showing in Activity windows in case, but relatedEntity only shown after clicking on “add email” or other activity tasks. So I’d try to use LinkEntityToEmail to manually do the linking, but not sure how to pass parameters.

Hi I’m getting an error when over supplying lot\serial numbers. Is there a way to override this validation ?There’s a settings that allows negative quantities on inventory items. Is there a similar settings for lot\serial numbers ? Shouldn’t these two go hand in hand ?  Thanks Roderick

Good Afternoon.I noticed the option to create your own Themes with Acumatica, which seems quite Interesting in multiple Use-Cases. But as usual, some colors aren’t for everyone.Therefore i am wondering, if it would be possible to implement a “local” Theme.By Local Theme i’d like to refer to the option to set a default theme in the website preferences,but enabling the User to set his prefered theme in his User Profile, that only he will be able to see.Another Option would be to set a theme and enable the user to pick a accent Color and something like“White Mode” or “Dark Mode” or something inbetween.Would that work with Acumatica or is that something that would break it?And if it would - Will it work like with every other “local Dark Mode” Solutionor are there special “needs” for Acumatica?Greetings 

Hello, I’m new to Acumatica customisation so I’m looking for some pointers.I want to write some data to a custom table when a new record is inserted into the SOShipLine table.My custom table is similar to the SOShipLineSplit table with 3 primary keys of ShipmentNbr, LineNbr and PickNbr.I want to enter data into my table when a new row is created in SOShipLine so I’m using the RowInserted event - SOShipLine_RowInserted(PXCache sender, PXRowInsertedEventArgs e).I’ve found that in the RowInserted event I cannot get access to the field values for ShipmentNbr and LineNbr, I guess this is because the data hasn’t been submitted to the database yet. But without these values I cannot set the values for ShipmentNbr and LineNbr in may custom table either. I’ve tried quite a few idea to get the key values from the new record but I’m starting to think that perhaps I’m taking the wrong approach to this problem. Perhaps I’m using the wrong event, or maybe I should be looking to set up parent/child re

Good day.I am trying to set a custom field in my header to true if my purchase order detail line contains a blanket PO Nr.I have created the custom field, and am currently trying to change the field in the row updated event.I am currently getting a An object reference is required for the non-static field, method, or property 'POLine.PONbr'An object reference is required for the non-static field, method, or property 'POLine.PONbr' error.Any help would be greatly appreciated.Please see my code attached here #region UsrContainsBlanketPONo [PXDBBool] [PXUIField(DisplayName = "Contains Blanket No")] public virtual bool? UsrContainsBlanketPONo { get; set; } public abstract class usrContainsBlanketPONo : PX.Data.BQL.BqlBool.Field<usrContainsBlanketPONo> { } #endregion protected void POLine_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e) { var row = (POLine)e.Row; foreach (POLine line in Base.Transactions.Select().

I am trying to setup a  dark theme, it seems it would not be quick task, If any could share a dark theme like AlCapone, it will be much appreciated.Many thanks,  

Hi Acumatica Developers-I am pretty new to this community, and I have always found it helpful to be able to live chat about issues when they arise. I think Acumatica deserves its own IRC channel for this purpose, so I created #acuamtica on irc.freenode.net. If you’re not familiar with IRC, you can see some getting started info here:https://freenode.net/kb/answer/chatI’ll be hanging out there are a lot for the time being, so stop by if you want to schmooze. I am not an expert in Acumatica (yet), but I can discuss programming and will be working my way through the tutorials on here and learning the Acumatica Framework as I go, so we can discuss if you are in the same boat. Thanks, Jonathan

Hello Guys, I wanna simulate the press action on save when updating a field i m using this code: protected void Choixfournisseurline_Selected_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e){ var row = (Choixfournisseurline)e.Row; PXCache cache2 = this.Caches[typeof(Choixfournisseurline)]; cache2.Persist(row , PXDBOperation.Update); this.Save.Press(); this.Save.SetPressed(true); cache.Graph.Actions.PressSave(); //cache2.Graph.Actions.PressSave();}but it’s not working!  Thanks.

Have massive customizations on IN202000 screen. After upgrade from 2019R1.214 to 2020R2.210 can’t publish customization project on this screen.Here is the error message:Any idea where to look at? What is “original index Template 2”?

A custom field is created in the Sales Order line level which pulls attribute values from Attributes form (eg- dropdown attribute created and custom field shows those dropdown values) but once line is saved the value is not shown on the UI but only when you click on it.I have also put MatrixMode = true in the grid but issue still remains.Before SavingAfter Saving 

Hi, i have some problem to get value from old value data, anyone have an idea ? example, new SO have qty = 65 after save user edited value qty in SO become 50. i want to get value qty SO =  65.or, how to implement query limit = 1 in acumatica ?

I am trying to add some more info to the Availability status at the bottom of Sales Order - Details grid. Specifically, I am trying to pull the last sold cost for the sales order header’s customer and the sales order detail/line inventory ID field. Is there an imbedded way/function to load this price or will this require the PXSelect methodology? Thanks!

Hi Experts,I’m working on the certification for 2021R2, and I got some validation errors from Acumatica(like “The error has been found in the SQL scripts. The project-specific database tables and columns must be mapped to DACs.Sql | Table1”).I have fixed these errors, but I want to validate locally before I submit it. I know I can validate the project by the following steps. But I got the following message “No errors or warnings have been found during validation.Validation has completed successfully”.Does any one have some idea about validating the customization projects locally? Thanks,Frank

Sales Orders used to have a REPORTS drop down menu where I could add in reports etc. I seem to be missing that now with the upgrade to 2021 R1. How do I re-add the reports drop down button?

I’m working on importing leads using a webhook. I can get all the lead data to insert into acumatica but we have a requirement to set the Source Campaign of the lead depending on which one of our websites the lead comes from.  I’ve added an attribute on the Marketing Campaigns called LEADWEBSIT.  I want to use the website address to search for the correct Marketing Campaign based on the value in the LEADWEBSIT attribute.  For example the website the lead comes from could be https://ourmainsite.com/contact-us/ or it could be https://ourmainsite.com/demo-survey/The LEADWEBSIT value would just be ourmainsite.  We want to find the Marketing Campaign where the attribute value in LEADWEBSIT is in the address the lead came in from.I know how to do a search like this: var campaignGraph = PXGraph.CreateInstance<CampaignMaint>(); CRCampaign campaign = campaignGraph.Campaign.Search<CRCampaign.campaignID>("1");But I’m not sure how to search on an attribute and how to search using

I created custom Inquiry form which provides Project Summary information and the Inquiry form working fine as I get desire result when I run directly but when I add new widget and try to select that screen from  Inquiry screen drop down the created custom inquiry form is not available. Is there any way I can create widget from custom created inquiry form?   

I’m trying follow instruction of S100SysAdmin2017R2 Lesson 5: Publishing Customizations, Step 5.1: Importing a Customization Project . I download the “Manufacturing.20.111.0017.49.zip” and “ManufacturingWiki.20.1.zip” according to the instructions. when i tried to Publish the Manufacturing.20.111.0017.49.zip i got following validation issue is Validating Binary FilesJAMS.dll Method signature was changed: System.Nullable`1<System.Guid> PX.Objects.IN.InventoryItem::get_ProductManagerID() declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullJAMS.dll Method signature was changed: System.Nullable`1<System.Guid> PX.Objects.IN.INItemSite::get_ProductManagerID() declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullJAMS.dll Method signature was changed: System.Void PX.Objects.CR.PMTimeActivity::set_OwnerID(System.Nullable`1<System.Guid>) declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullFixed binding: t

Issue is on upgrade.Previously you could add a number of Automation Steps of Notification type. This allowed a number of Notification Actions to be defined. Now that the Automation Steps are no longer supported I’ve added a Notification Action in the Customization for the screen and this worked fine. But when I went to add some more then the option to choose Notification as an existing is no longer available. Any ideas on how to work around this?