Develop Customizations

Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions

2,702 Topics
10,972 Replies

2702 Topics

lgalleno57Freshman I

asked in Develop Customizations

Optimize Insert performance on grid

Hi,I need to insert 300+ (or more, depending on the # of batches selected) rows of records on grid but the time it consumes is way too long, it takes 10 mins to insert 298 rows, but as I tweaked the code, I was able to lessen it to 8 minutes.AddProperty Action - This is where I add records to the grid.public PXAction<REMeterReading> AddProperty; [PXUIField(DisplayName = REMessages.AddProperty)] [PXButton()] public IEnumerable addProperty(PXAdapter adapter) { ClearDetails(); if (Filter.AskExt() == WebDialogResult.OK) { string[] floors = Filter.Current.Floors.Split(',').Select(_ => _.Trim()).ToArray(); REMeterReading document = MeterReading.Current; List<REProperty> properties = GetMeterReadingProperties(propertyClassID: document.PropertyClassID, rateID: document.RateID,

2 years ago

allyFreshman II

asked in Develop Customizations

DAC Table, On-Premise SQL to Acumatica, Generic Inquiry has Number Fields Multiplied by 24 or 40

The weird thing is that I was typing “SQL to Acumatica Number Fields Multiplied by 24 or 40” into Google and it autocompleted right after I started typing “multiplied” but then there were no fruitful results.So, we’re on-premise SQL hosted Acumatica 2021 R1 and I’m attempting to make a Pivot Table run faster by doing the query, main filtering, and calculations on SQL in a View that I have on a Customization as a DAC Table (generated from database) and a Database Script. Everything runs great except for the actual numbers. They are fine when I look at the View in SQL Server Management Studio and there are the same number of rows for the SQL View and the Generic Inquiry on the View in Acumatica, but all of the values of the decimal and integer columns are coming into Acumatica as Number columns multiplied by 24 or 40. Admittedly, this is my first DAC and Customization Project but I’ve checked three different DAC tutorials (the one in the official customization manual and two others by th

2 years ago

ericklasimin61Jr Varsity III

asked in Develop Customizations

Displaying field from another screen

I have created one custom field each in Sales Orders screen and in Add SO Line dialog box in Invoices screen to display the value of Tariff Code in Stock Items screen. I managed to display them using the code below:public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>{ #region UsrTariffCode [PXDBString(30)] [PXUIField(DisplayName = "Tariff Code", Enabled = false)] [PXFormula(typeof(Selector<SOLine.inventoryID,InventoryItem.hSTariffCode>))] public virtual string UsrTariffCode { get; set; } public abstract class usrTariffCode : PX.Data.BQL.BqlString.Field<usrTariffCode> { } #endregion} public class SOLineForDirectInvoiceExt : PXCacheExtension<PX.Objects.SO.DAC.Projections.SOLineForDirectInvoice>{ #region UsrTariffCode [PXDBString(50, BqlField = typeof(SOLineExt.usrTariffCode))] [PXUIField(DisplayName = "Tariff Code", Enabled = false)] public virtual string UsrTariffCode { get; set; } public abstract class usrTariff

2 years ago

jchavezFreshman II

asked in Develop Customizations

Is it possible to load external files/libraries into Acumatica?

I'm working on a new Acumatica screen for our company that will require some javascript code to retrieve and display a map object (from ESRI).This code requires an external .js file that can be programmatically loaded. Everything works fine if I use a blank HTML page to test this.The problem I have is that when I try using the same code from inside the Acumatica screen, it doesn't load this required external file, and therefore the code does not work properly.I attempted to load the full .js file along with my code, but it returned the following error:error CS8095: Length of String constant exceeds current memory limit. Try splitting the string into multiple constants.I haven't tried splitting this file into multiple strings (as the error message suggests), because I want to make sure there isn't a cleaner and more professional, direct/right way to do this.Is it possible to manually import this external .js file into our Acumatica instance, so I can point to it instead? (in case it mak

2 years ago

eney

asked in Develop Customizations

Making Customization Changes to Another User

If I get requests from users at my company to make customization changes to their homepage (i.e. add tiles) what roles would I need to be assigned and how would I go about making the changes to their account?

2 years ago

woodyg84Jr Varsity III

asked in Develop Customizations

autocomplete does not work when custom attribute with less than 10 items in dropdown (type combo)

We have custom attributes created. if the attribute contains more than 10 times, the autocomplete works correct, just not for the attribute with 10 items or less after upgraded the system to 21R1. For example, we have language attribute with 3 valueitems, E, F, S, when type those letter into the box, item won’t be auto selected like before.

2 years ago

eddiedacoVarsity I

asked in Develop Customizations

Problem with orderby clause (BQL)

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!

2 years ago

eddiedacoVarsity I

asked in Develop Customizations

Problem filtering Sql view in Grid

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()

2 years ago

ssamboju12Freshman II

asked in Develop Customizations

How to Override Vendoractive attribute to join vendorclass table

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.

2 years ago

idrusm52Jr Varsity III

posted in Develop Customizations

Pop up Notes as Internal Notes for Sales Order and Purchase Order

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

2 years ago

ryanmoon32Freshman I

asked in Develop Customizations

Sales order customization project

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

2 years ago

DjangoCaptain II

asked in Develop Customizations

How can I wait for a file to be created?

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

2 years ago

jchavezFreshman II

asked in Develop Customizations

Adding External Functionality Into Customer Portal Screen

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

2 years ago

woodyg84Jr Varsity III

asked in Develop Customizations

need example for calling LinkEntityToEmail action

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.

2 years ago

RoderickFreshman I

asked in Develop Customizations

Negative Stock

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

2 years ago

jwestermann17Jr Varsity III

asked in Develop Customizations

Local themes

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

2 years ago

stephenward03Varsity I

asked in Develop Customizations

How to get primary key field value from RowInserted event

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

2 years ago

charlbester34Freshman I

asked in Develop Customizations

Blanket PO No in code: CS0120 issue

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().

2 years ago

Driver

asked in Develop Customizations

Does anyone have dark theme files like AlCapone?

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,

2 years ago

rosenjonSemi-Pro III

posted in Develop Customizations

Acumatica Developer Chat at irc.freenode.net #acumatica

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

2 years ago

SadokHaniniFreshman II

asked in Develop Customizations

Press Save automatically when updating a field

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.

2 years ago

nadiyahnatyuk58Jr Varsity II

asked in Develop Customizations

Upgrade to 2020R2 - error publishing customizations: "Duplicate original index Template 2"

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”?

2 years ago

TharidhiPSemi-Pro I

asked in Develop Customizations

Field Value Disappears After Saving but Shows Values When Clicked

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

2 years ago

yanuaralfianus37Jr Varsity II

asked in Develop Customizations

How to get old value in one field ?

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 ?

2 years ago

ryanmoon32Freshman I

asked in Develop Customizations

Query last sold info for sales order line

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!

2 years ago

Page 97 / 109

Develop Customizations

Badge winners

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded