Skip to main content

Develop Customizations

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

  • 3,121 Topics
  • 12,860 Replies
3121 Topics
Michaelh
Semi-Pro III
MichaelhSemi-Pro III
asked in Develop Customizations
Check for data types

How do I check for a data type in the generic inquiry screen? Like iif( ISNUMBER([FIELD]), True Path, False Path) I have an Inventory Item Attribute that USUALLY holds an integer value. I wish to do math on this value when it is an integer, but when it is a text string it crashes the report. If I could do some kind of error checking like in Excel, I can force this to work by using IIF to ignore non-integer values.

5676
C
Semi-Pro I
KrunalDoshi
Freshman II
KrunalDoshiFreshman II
asked in Develop Customizations
Getting default DAC and Primary View

Hi, I am trying to get the default DAC and its primary view from the Type. Any suggestions? I have Type defined as below and I have field as below values

3384
KrunalDoshi
Freshman II
E
Varsity I
eddiedacoVarsity I
asked in Develop Customizations
How to render/visualize pdf file in acumatica´s graph

Hello Goodnight.I have pdf files hosted in the cloud. I need to be able to visualize them in some section of acumatica. I developed a code to display it on a web page and it works without problems (HTML5 pages, javascript), but when adding the same code in acumatica the code does not mark an error but nothing appears. The code to visualize a pdf in a div is <!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>My PDF Viewer</title> </head><body> <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfobject/2.2.5/pdfobject.js"></script> <div id="example1" style="width: 700px; height: 500px;"></div> <script> document.addEventListener("DOMContentLoaded", function(event) { PDFObject.embed(`url_pdf`, "#example1"); }); </script> </body> </html> this code works perfect. i put the same code in acumatica (the div “example1” is inside a splittercontent) but n

2551
E
Varsity I
mbrown30
Jr Varsity III
mbrown30Jr Varsity III
asked in Develop Customizations
Adding Project ID selector to Item Classes screen

Hi I am trying to add the project ID selector to the Item Classes screen. I have added a custom field and created a control and have tried to use the ProjectBaseAttribute to allow me to select a project and save it against the class. [ProjectBaseAttribute(DisplayName="Project ID")] When I validate I receive the following error: \App_RuntimeCode\PX_Objects_IN_INItemClass_extensions.cs(23): error CS0246: The type or namespace name 'ProjectBaseAttributeAttribute' could not be found (are you missing a using directive or an assembly reference?)\App_RuntimeCode\PX_Objects_IN_INItemClass_extensions.cs(23): error CS0246: The type or namespace name 'ProjectBaseAttribute' could not be found (are you missing a using directive or an assembly reference?)\App_RuntimeCode\PX_Objects_IN_INItemClass_extensions.cs(23): error CS0246: The type or namespace name 'DisplayName' could not be found (are you missing a using directive or an assembly reference?)\App_RuntimeCode\PX_Objects_IN_INItemClass_extension

3313
Naveen Boga
Captain II
G
Pro I
Giri KPro I
asked in Develop Customizations
Multi Level Approval in Custom screen.

Hi,I am customizing Approval Map concept for New Customized screen.I am getting solution for one-step approval, But not Multi-level Approval. To get Multi-Level Approval, Do I need to give any extra conditions/Additional code other than Single step approval logic??Thanks.

860
G
Pro I
R
Freshman I
ryohaniFreshman I
asked in Develop Customizations
Multiple customizations adding the same filed

I have a scenario where I have multiple customizations adding different custom fields. In any time unknown number or combination of customizations can be published. Issue is I need to add a common field to a screen that should be available regardless what customizations are published. <AddItem> <PXCheckBox TypeFullName="PX.Web.UI.PXCheckBox"> <Prop Key="Virtual:ApplyStylesheetSkin" /> <Prop Key="ID" Value="CstPXCheckBox1" /> <Prop Key="DataField" Value="Usrtest" /> <Prop Key="CommitChanges" Value="True" /> </PXCheckBox></AddItem> <DAC type="PX.Objects.CR.BAccount"> <Field FieldName="Usrtest" TypeName="bool" MapDbTable="BAccount" TextAttributes="#CDATA" StorageName="AddColumn"> <CDATA name="TextAttributes"><![CDATA[[PXDBBool] [PXUIField(DisplayName="test")] ]]></CDATA> </Field></DAC> // and db record I have set levels for each of my customizations, but when publishing it gives below error. \App_RuntimeCode\PX_Objects_CR_BAccount_extensions.cs(29): error CS0579: Duplicate 'PXDBBool' attr

1502
R
Freshman I
E
Varsity I
eddiedacoVarsity I
asked in Develop Customizations
Checkbox FieldUpdated event does not work correctly

I have 4 checkboxes and if I select any the others must be deselected. I'm using each one's FieldUpdate property, but it only works with Internal Budget with Vendor # 1, # 2, # 3 and # 4 not working. I show an example of how I am using the Field Updated event. InternalBudget FieldUpdated Vendor_1 FieldUpdated Enable commit changes property for each field but only works with InternalBudget. Anyone who can help me please?

4092
E
Varsity I
E
Varsity I
eddiedacoVarsity I
asked in Develop Customizations
How to prevent duplicate data in PXGRID

Hello Goodnight. I new in acumatica. I have the following requirement: the phase codes field cannot be repeated.My validation already works but the data must be saved in the DB previously. The problem is when the user enters N number of rows (without saving before) that is when my validation does not work. This is how I currently do the validation (Row_Updated event). It works, but the data has to be saved in the DB before. Can you help me please. I think it should take data from the grid (cache) but I don't know how to do it.

9986
E
Varsity I
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Develop Customizations
When publishing my graph extension (delegate), I get an error that the method does not exist in the graph

I know that in 15 minutes after posting this, I will find my stupid mistake. Until then, I get the following error when publishing my project: Method System.Collections.Generic.List`1[PX.Objects.AP.APRegister] ReleaseInvoice(PX.Objects.GL.JournalEntry, PX.Objects.AP.APRegister ByRef, PX.Data.PXResult`4[PX.Objects.AP.APInvoice,PX.Objects.CM.CurrencyInfo,PX.Objects.CS.Terms,PX.Objects.AP.Vendor], Boolean, System.Collections.Generic.List`1[PX.Objects.IN.INRegister] ByRef, ReleaseInvoiceDelegate) in graph extension is marked as [PXOverride], but the original method with such name has not been found in PXGraph This is the delegate I am using to override the ReleaseInvoice method. It looks to me like it is within the APDocumentRelease Graph. Any ideas why it is not publishing? This code compiles with no reference errors at all. The signature of my delegate looks spotless. :-) namespace PX.Objects.AP{ // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be

7102
Hughes Beausejour
Acumatica Employee
mdu20
Freshman I
mdu20Freshman I
asked in Develop Customizations
Business Event Conditions based on Time and not date

Hi Community, I’m trying to create a business even which relies on the time (using hours) but I only can see this based on days. The condition must trigger once it has been 4 hours after a case reported time. Is this possible?

1190
mdu20
Freshman I
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Develop Customizations
Getting a UDF set to a value in the Batch table from the APRegister table not saving

I am posting a Bill from the Bills and Adjustments. There is a UDF UsrExtProjectID being saved in the APRegister table. When the JE gets posted for that bill, I want to set the UDF with the same name in the Batch table for the corresponding JE created from the bill. I am overriding the PostBatchProc method in the PostGraph graph. public class PostGraph_Extension : PXGraphExtension<PostGraph> { public delegate void PostBatchProcDelegate(Batch b); [PXOverride] public virtual void PostBatchProc(Batch b, PostBatchProcDelegate baseMethod) { baseMethod(b); Here is the section of the code doing the work: if (continueProcessingPID) { //get the Batch for the current transaction Batch batch = SelectFrom<Batch>.Where<Batch.batchNbr.IsEqual<@P.AsString>> .View.Select(Base, b.BatchNbr); if (batch.Module == "AP") { //get the Batch for the current transaction APRegister apRegister = SelectFrom<APRegister>.Where<APRegister.batchNbr.IsEqual<@P.AsString>> .View.Select(Base, b.BatchNbr); APRegisterExt it

522
Joe Schmucker
Captain II
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Develop Customizations
Using a UDF as a selector that stores the ID of a record from another table

I created a UDF for the Journal Transactions screen. It is a selector that pulls from a custom table. The ID of the value from the custom table is supposed to be stored in the UDF. When you create a new JE, the lookup works great! After selecting: So far so good. The problem is that when the RowSelected fires, the value is cleared from the field. There is one record in the custom table with an ID of 1. If I edit the Batch table and put a 1 in the UDF, and then go to that JE, the screen shows a “1”. It should show “TEST1 - Test 1” which would be what would show if you actually selected something. When creating a new JE, I selected the TEST1 from the selector. When I go to add a line item to the grid, the RowSelected handler fires. I put a little code in the handler to see if there is a value in that field: In the RowSelected event for the batch, the itemExt.UsrProjectID is null. The only thing I have to work from is the Acumatica Training code and there isn’t an example of adding a UDF

3343
Joe Schmucker
Captain II
J
Varsity II
jknaufVarsity II
asked in Develop Customizations
Mobile Popup Dialog

Hello everyone, So I’ve developed a customization that utilized popup dialogs using the View.Ask() method. It works great on a web browser, however when it’s triggered on mobile it displays the pop up as an error. Does anyone know how to properly display pop up dialogs on mobile? Thanks!

4062
J
Varsity II
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Develop Customizations
Can't get Setup form to be triggered when there is no current record

I have a setup table (ICSetup) which obviously should have only one record. When the table is empty and a graph tries to get the setup record, it is supposed to throw an exception to the screen and give the user the option to redirect to the setup form. This is not working for me. I debugged the code and the constructor call is creating the exception, but nothing is coming back to the screen. It just hangs. Here is the DAC: You can see that I have setup the PXPrimaryGraph to ICSetupMaint. That screen opens with no issue. In the InterTenantMaint graph, I have a PXSelect as follows: public PXSetup<ICSetup> Setup; The constructor for the graph is: public InterTenantMaint() { try { ICSetup setup = Setup.Current; } catch (Exception e) { string joe = e.Message; } } When you open the InterTenantMaint screen, it just hangs. In order to debug, I added a try-catch to see what the error is. When the try executes the e.Message value is as I would expect. If you open the ICSetupMaint screen, it loo

2865
Joe Schmucker
Captain II
R
Captain II
ray20Captain II
asked in Develop Customizations
How to monitor the total qty sales of 1 specific item

Hello, I have a need to do something (subscriber) when the sales qty of 1 item reaches a predefined amount.I find the table INItemSalesHis contains the information. But the trigger does not work out in business event, like below Is there any other way I can fulfill my need.

650
R
Captain II
T
Pro I
TharidhiPPro I
asked in Develop Customizations
Possibility to create fields in summary area of Sales Order Form that determine how fields appear in line level

I have a question on whether on the Sales Order Form, if there is a possibility when entering a value in a custom field in the summary area, when we enter a value to that, it triggers appearance of some selected columns in the table (line level).

1223
Naveen Boga
Captain II
R
Semi-Pro III
rjean09Semi-Pro III
asked in Develop Customizations
Screen Editor: Cannot create an object of type 'System.Int32' from its string representation '' for the 'ColumnSpan' property.

Only happens when I try to preview. I can publish and run the screen fine. ASPx looks OK and there is no ColumnSpan property being set anywhere that I can see. <%@ Page Language="C#" MasterPageFile="~/MasterPages/FormDetail.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="AP504520.aspx.cs" Inherits="Page_AP504520" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormDetail.master" %> <asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="APCustomizations.APStaleDateLettersProcess" PrimaryView="Filter" > <CallbackCommands> </CallbackCommands> </px:PXDataSource></asp:Content><asp:Content ID="cont2" ContentPlaceHolderID="phF" Runat="Server"> <px:PXFormView ID="form" runat="server" DataSourceID="ds" DataMember="Filter" Width="100%" Height="100px" AllowAutoHide="false"> <Template> <px:PXLayoutRule ID="PXLayoutRule1" runat="server" StartRow="True"></px:PXLayoutRule> <px

2695
M
Jr Varsity II
L
Freshman I
LisaKlonczFreshman I
asked in Develop Customizations
Mobile App | Attribute Text Fields | View entered data

In the mobile app | Attribute Code | Text field type How can a user see all the information that is entered in a text attribute code? It cuts off the information entered in the field. We can’t figure out how the user can see the entire text that was entered. Currently tested in attribute codes entered in Cases.

611
C
Acumatica Moderator
J
Freshman II
jgrammer42Freshman II
asked in Develop Customizations
Unable to add ListFolder to Mobile App - even according to documented example

I am trying to add a ListFolder to the Main menu of the Mobile app. All I am doing is trying to follow the directions in the attached 2019-R1-Mobile-Framework-Dev-Guide as published by Acumatica. It does not work. What is very odd, is that I can add all of the HubFolder’s I want. That works perfectly. But I can NOT add a ListFolder. Does anyone know why that would happen? There are no errors. It just does not work.Here are the published example directions from Acumatica. Example: Adding a Screen to a FolderAdding a screen to a folder consists of two actions:• Adding a new screen to the mobile site map, as described in To Add a Screen to the Mobile SiteMap• Adding the new screen shortcut to the main menu.In this example, you will add a shortcut of the Controller screen to the Dashboards folder of the mainmenu. Copy the code below to the Commands area of the Update: MENU page in the CustomizationProject Editor.update sitemap {add folder "Folder_0" {displayName = "Dashboards"icon = "syste

721
C
Acumatica Moderator
M
Jr Varsity II
mohamed1walhaJr Varsity II
asked in Develop Customizations
Create XSD Files

Hello, Is it possible in Acumatica to have a button that allows me to invoke a function that retrieves all the data from a screen and formats it as an XSD file? This button will be generalized on all screens containing the "Editions" action.The XSD files will be saved in a new destination. Best regards.

250
M
Jr Varsity II
A
Jr Varsity II
arturoromo51Jr Varsity II
asked in Develop Customizations
Error en Selector cambia Descripción por Valor en la Tabla

Good morning, we are developing a capture in "Form View", I include the image, In the "Marca" column we must select an element by name and take its key to place it in the corresponding table.It presents us with 2 problems, the first is that it does not convert long names to its key, it gives us an error that the field is longer than what is defined in the table and it assigns a different key to it; the second problem is that the fields that have an "&" in the name, it removes the ampersan and puts the text in place of the key.I am attaching the DAC code. #region Marca public abstract class marca : PX.Data.IBqlField { } [PXDBString(20, IsUnicode = true, IsKey = true)] [PXDefault()] [PXSelector(typeof(Search<CSAttributeDetail.valueID, Where<CSAttributeDetail.attributeID, Equal<attributeLaboratorio>, And<CSAttributeDetail.disabled, NotEqual<True>>>>), typeof(CSAttributeDetail.valueID), typeof(CSAttributeDetail.description), typeof(CSAttributeDetail.disabled), SubstituteKey = typeof(CSAttr

495
Naveen Boga
Captain II
J
Freshman II
jchavezFreshman II
asked in Develop Customizations
Custom Logo on collapsed menu

Hi, We are currently able to change the default Acumatica logo by setting it in the Branches screen on the Visual Appearance tab, but when the left side menu is collapsed, the small Acumatica “a” logo is displayed. Is it possible to set another custom image as the logo when this menu is collapsed? Thanks in advance

1211
L
Semi-Pro II
A
Jr Varsity II
arturoromo51Jr Varsity II
asked in Develop Customizations
Cómo ejecutar una instrucción desde una variable

Tengo la necesidad de generar varios campos de filtro en un “Form View” y de estos elegirlos todos o solo aquellos que se requieran, la integración de los queries para filtros no me permiten hacer esto (o tal vez no se como), por lo que se me ocurre integrar en una variable la instrucción del Select para el filtro con base en los campos que requiera (desde uno hasta todos). La variable para el Select la puedo integrar pero requiero que algo la ejecute para que se aplique el filtro con base solo en los campos en los que se seleccionó información, Agradeceré si me pueden ayudar a resolver este problema.

11413
Naveen Boga
Captain II
J
Jr Varsity III
jwestermann17Jr Varsity III
posted in Develop Customizations
New Customization feature screen (Do able?)

Good Morning, Good Evening, Good Afternoon.. today i would like to find out if something might be useful or not. We are using the German equivalent to Acumatica called Lexbizz. It uses the same Infrastructure, just looks a bit cleaner and might be a bit improved at some points.So far so good. Let me Start at the beginning: History We already have a lot of Customers using Customizations to fit their needs. Some Customizations are bigger and more complex, others are quite small.But still - over time the number of customization projects increases and therefore ourneed to create a workable base for our project leads to work with them. What would we like to do? We would like to create certain new Screens. I created a small mockup in Paint to show what my ideas are. Please keep in mind that these will be in German. I will try to translate the most important things. 1. Create a addon for the System-Management Screen. We would like to implement a new sitemap entry going to our new screen.It sh

1722
J
Jr Varsity III
K
Freshman II
KellyMarchewaFreshman II
asked in Develop Customizations
Difficulty Modifying/Inserting Records in Persist()

I am new to Acumatica development. I am currently working on creating a Screen (and corresponding Graph) that interacts with PR objects. One of my first tasks is to insert a new PR Employee based on the data of an existing EPEmployee. I have overridden the `Persist()` method and based my logic largely on the `InsertForImport()` method in `PX.Objects.PR.PREmployeePayrollSettingsMaint` .Relevant parts of my graph follows: using System;using PX.Data;using PX.Data.BQL.Fluent;using PX.Objects.PR;using PX.Objects.GL;using PX.Objects.EP; namespace PRImport{ public class PRImportNew : PXGraph<PRImportNew> { public PXSave<PREmployee> Save; public PXCancel<PREmployee> Cancel; public PXInsert<PREmployee> Insert; public SelectFrom<PREmployee>. InnerJoin<Branch>. On<PREmployee.parentBAccountID.IsEqual<Branch.bAccountID>>. Where<MatchWithBranch<Branch.branchID>. And<MatchWithPayGroup<PREmployee.payGroupID>>>.View PayrollEmployee; public PXFilter<CreateEditPREmployeeFilter> CreateEditPREmployeeFilter

9890
K
Freshman II

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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