Develop Customizations

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 PXGraphThis 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 shoul

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?

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")                {                  

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 U

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!

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 th

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.

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

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"> <Temp

In the mobile app | Attribute Code | Text field typeHow 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. 

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.

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.val

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.

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:HistoryWe 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 should

Hi,While I was debugging the code in VS, I am getting dll.il not found.Am I missing any thing to add as reference in project or in Acumatica Instance.Can someone help me on getting this done.Thanks,

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<Mat

Hi,I always got PXData.PXLockViolationException a.k.a “another process has added…..”We are having a upgrade procedure right now.in my 2019 R1 Project same code, it works, but when on 2021R1, it returns me this error.Is there a new way to add lines programmatically in 2021 R1?I always do.var item = Details.insert();item.description = someDescription.Details.Update(item);but when I do Actions.PressSave() it triggers the error.been going here for weeks. I tried all solutions I can think about. Thanks, Ed

Hi,I’m using ScreenInfo to store all the screen details to custom table.Able to get ViewNames and fields but unable to get Table name for the respective views.Is there a way to fetch table name using ViewName or any other way to get all the screen details(Tables,ViewNames and fields)?. 

Similar to this topic:I have a working processing UI that I want to use to create individual PDFs (from a report) and save to disk.  At the end of the process I want to show the same report (all together) in preview with the same records used to create the individual PDFs.  I have a working report but am struggling with how to get the joined tables in my PXReportResultSet since my delegate only gets the main table passed in as List.I’m sure I could BQL query these somehow or run a full BQL query again by passing in the filter (based on the referenced technique) but not sure if there is a better way to just grab these from the results already retrieved for the UI. Here is my code: public APStaleDateLettersProcess() { DetailsView.SetSelected<APQuickCheck.selected>(); DetailsView.SetProcessDelegate(Process); } public PXCancel<APStaleDatedCheckFilter> Cancel; public PXFilter<APStaleDatedCheckFilter> Filter; p

My aim is to edit an entity which is selected by a Filter.The Filter DAC contains only unbound fields and does not have a DB table. It is marked with [PXHidden]In the graph there is the Filter, a View for the entity and the Save action: public PXFilter<FilterDAC> Filter;public SelectFrom<EntityDAC>.Where<EntityDAC.name.IsEqual<FilterDAC.name.FromCurrent>>>.View FilteredEntities;public PXSave<FilterDAC>; In the ASPX file I set Filter as PrimaryView of the DataSource and also as DataMember of the 1st form. A 2nd form with DataMember FilteredEntities to edit the entity.The Filter works fine and I can edit the entity. The error occurs if I press the save button. PXGraph.ExecuteUpdate with viewName = ‘FilteredEntities” throwsError: The table with the name 'FilterDAC' does not exist in the database.That’s true, but shouldn’t this be ignored if the DAC has atribute PXHidden? [PXHidden] public class FilterDAC : IBqlTable { [PXString(IsUnicode = t

Hi Experts,I have a data view called ‘ReportCredential’ in my PXGraph. I set ‘ReportCredential’ as a primary view for a PXFormView. Also I have a funtion called ‘reportCredential’. When the form is loading, I find the function will be called several times. Since I will call external web services in this function, I need this function to be called only once. Is there any other event handlers for the screen loading? The following is my code. Thanks,

Hello,I trying to add filter on subledgerID in report designer but always im getting an empty list (there is data in DB)     Thanks for your feedback.

Hello!We created a extension pack for the screen EP305000 - Employee Timecards for the register “details”We renamed time to “Start” and added “Pause” and “End” as UsrFields which work fine so far.They are defined as dateandtime fields so that u can select a time from a list like 00:00 - 00:30…We would now like to add - inside of the grid right next to the “End” field - another field called “Summary” that calculates the actual Work time (UsrEnd - Start - UsrPause) for each added row.How would that be possible?I searched for it on Google but couldnt find a way. Yet i am a Rookie and don't know much about c# and coding til now. So any help would be appreciated that might lead to a solutionGreetings

Eg: I am trying to create a “Customer” related field in “Invoices” screen. Dear Friends,I am trying to create a custom “Related” field and it doesn’t work for some reason, so need your input. I created a new Customization Project, and in the Data Access section for Invoice, I created a new field: Lets say the Field name is “Shipping Customer”. I added the following as part of field attributes:[CustomerActive(Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName),Filterable=true, TabOrder=2)][PXUIField(DisplayName="ShippingCustomer")]Once the field is created, I added it to the Invoice Screen, and it appears fine (woohoo!).  But when I save the Invoice, the field value is not getting saved into the DB. Any clues why? Thanks for your help!

Hello,       I met an issue, I don’t know how serious it is. Because the system behavior looks OK.  But It is indeed strange. Luckily, I got this issue on a test environment, but I still need help.      I did some test on shipment workflow days ago. And it seems like something is broken.  When I try to create a NEW shipment, the status is disappear, so the new shipment can not be saved.       In Order to solve the above issue, I unpublished the issue customization projects and import a backup right 1 and republish. The status issue has solved.      But Unfortunately, the “default workflow” is disappeared                 How can I add the default workflow back?