Develop Customizations

I added an unbound custom field to the Orders grid on the Process Shipments screen.I want to set a value in the custom field by overriding the Orders view.  I used the post from Sergey on how to do this (https://asiablog.acumatica.com/2016/06/using-pxview-in-dataview-delegate.html).In debug I am seeing that the result set has records.  When the foreach fires, I get an exception. This is the block of code I am taken to when the error occurs.  This may not really be an error, but I thought I’d show it in case it does matter. This error on the screen:In the graph, this is the actual line for the Orders view:public PXFilteredProcessing<SOShipment, SOShipmentFilter> Orders;I tried putting SOShipmentFilter in the foreach but that causes a cast error too.  Sergey’s example shows the foreach containing all the DACS in the original View so I tried that too. foreach (PXResult<SOShipment, SOShipmentFilter> row in result) Since the result set only shows SOShipment records, it looks lik

Hello Everyone,We have a requirement like add a new custom field in the Incoming Documents screen i.e. Purchase Order Nbr and when we upload the file and click on the Recognize action we need to read the Purchase Order field value from uploaded document and show it in the custom field.Can anyone help me on this to achieve this requirement?  

Hi, I am looking for a solution where I have a Boolean value on the user, the value will state if all the warehoused should be available for the user when selecting the warehouse for the current branch.if the bool is true then we I want to only show the current rows branch's warehouses and not all the warehouses in the system. but if the bool is false I don't want the where clause to be part of the PXRestrictor.  I cant control a PXRestrictor with a bool and this is the problem i don't always want to apply the where clause to the look up field.  Current Code  #region SiteID    [PXMergeAttributes(Method = MergeMethod.Append)]  [PXRestrictor(typeof(Where<INSite.branchID, Equal<Current<SOLine.branchID>>>), "", typeof(INSite.siteID))]  public int? SiteID { get; set; }  #endregion I have a bool on the same DAC usrWarehouseLock and if this is true then apply the current PXRestrictor and is false ignore and just continue with the normal functionality.  Any help will be amazi

I am trying to make the Description field on the Journal Transactions screen required, but only if the entry is being created on the Journal Transactions screen.  I don’t want to stop sub ledgers from posting entries if no description is provided.  For example, if someone creates a payables invoice without a description, I don’t want to cause the transaction to not post to the GL if the payables transaction does not have a description.I added the red asterisk to the field.  Obviously, that doesn’t make the field required, but just shows that it is required.Here is the event I am firing to try to make this happen:    public class JournalEntry_Extension : PXGraphExtension<JournalEntry>     {        protected void _RowUpdating(Events.RowUpdating<Batch> e)        {            var row = (Batch)e.Row;            if (row == null) return;            if (row.Module == “GL”)            {                if (row.Description == null)                {                    //throw new PXSet

I am upgrading a customer to 2022 R2.There is a customization (not written by me) that I am bringing forward as part of that.This customization extends a graph called: EPEventEnqWhich seems to be in the using PX.Objects.EP namespace.It referenced a screen ID: EP404100 which looks like this:The issue is none of this seems to be available in 2022 R2. Does anyone know where this got moved to? Or did it just get removed?  

I’ve added some custom fields to the Company editing screen inside Configuration that I need to access in a graph extension and a custom service class.  The fields were created as a DAC extension on Organization.  These fields are used to store company specific URLs to third party APIs.The thing I’d like help with is coming up with a way to get to the current organization without hard coding the OrganizationCD into my FBQL query.  This is what is working for me currently: var organization =    SelectFrom<Organization>        .Where<Organization.organizationCD.IsEqual<@P.AsString>>        .View    .Select(Base, "MY_ORGANIZATION_CD")    .RowCast<Organization>()    .FirstOrDefault(); Is there a better way to do this without using MY_ORGANIZATION_CD as a string? Originally, I was hoping I could use the CompanyID from PXInstanceHelper.CurrentCompany but IntelliSense suggests it isn’t possible to query for records using the CompanyID column.  Ideally, I’d like somethi

Hello,I am trying to implement a scalar custom field within the Kit Assembly page. The target functionality of this field is to select a boolean value from a custom table. I have implemented this field on various other pages but copying over that code to this page has not worked out for me.The following code is an example field I implemented on the Purchase Order page. This field is functioning as intended.[PXBool][PXUIField(DisplayName = "Is Cool", Enabled = false)][PXDBScalar(typeof(Search<MyTable.isCool, Where<MyTable.docNbr, Equal<POOrder.orderNbr>, And<MyTable.docType, Equal<MyConstants.PurchDocType>>>>))]public virtual bool? IsCool{ get; set; }public abstract class isCool: Data.BQL.BqlBool.Field<isCool> { }I used the Purchase Order example field as a template for the Kit Assembly page, making sure to update the WHERE filters, however the field does not seem to select data from my custom table and never contains a true value.[PXBool][PXUIField(D

I cannot create a custom screen in 24R1 Preview or 24R1 Beta.  I was attempting to test my application in 2024R1. After HOURS of trying to figure out why, I performed the following steps:Install clean instance of 24R1 Beta (24R1B-24-093-0169)Create customization project "Test"Open Test in project editorCreate new screen IC.11.11.10Publish the project TestOpen Project EditorClick on the screen ID IC11.11.10Click Preview ChangesHere is the error: I tried this in 24R1 Preview with the same results.If I do the exact same process in any version of 23R2, I do not get this error.I will attach the project to this case if you want to try to publish it yourself to see if you can duplicate this error.I submitted a support request yesterday, but in case anyone has figured this out, let me know!  I will post another comment when support gets back to me if no one else can figure this one out.

I have created a custom GI as shown below screenshot. The entry screen is invoices and memos.How can I achieve this in mobile application. How can I link it to redirect to Invoices and memos(AR301000) screen for record editing or viewing in acumatica mobile app?kindly assistThanks

Hello Acumatica Community,I have prepared a Guide video to assist new users setup their environment for Acumatica TestSDK development.Acumatica TestSDK Starter Guide WalkthroughThe video will take you through the same steps in the readme.md attached to the git project but in visual form:Download and install Acumatica Configure your environment Config the test project for your solution Generate Wrappers Run the tests *If you are a brand new Acumatica developer you must do the following pre-config to successfully install Acumatica ERP on a dev machine before starting the above guide - see page 19 of this pdf AcumaticaERP_InstallationGuide.pdf

I have added invoices and memos screen on acumatica mobile app, then added PAY action button.However when I press pay, nothing happens.What could be the issue? Kindly assist.See below details;Pay button screenshot   Code; add recordAction "PayInvoice" { syncLongOperation = True } 

Tried to publish a customization package and received an error and window force closed now I am unable to sign into Acumatica. I receive the following error. PLEASE HELP! Invalid column name '[AUWorkflow].[CreatedByID]' Invalid column name '[AUWorkflow].[CreatedDateTime]' Invalid column name '[AUWorkflow].[LastModifiedByID]' Invalid column name '[AUWorkflow].[LastModifiedDateTime]'

Hello, Community. It took me some time to figure this out, but here is the solution: using PX.Objects.GL.FinPeriods.TableDefinition;…public abstract class consumptionDateFilter : PX.Data.BQL.BqlString.Field<consumptionDateFilter> { }[OpenPeriod][PXDefault(typeof(Search<FinPeriod.finPeriodID,                    Where<FinPeriod.startDate, LessEqual<AccessInfo.businessDate.FromCurrent>,                    And<FinPeriod.endDate, Greater<AccessInfo.businessDate.FromCurrent>>>>),                    PersistingCheck = PXPersistingCheck.NullOrBlank)] [PXUIField(DisplayName = "Períod ID")] public virtual string ConsumptionDateFilter { get; set; }

my acumatica build: 22.215.0056this is the original method to override:public virtual void RefreshRates(RefreshFilter filter, List<RefreshRate> list)this is the graph extended:    public class RefreshCurrencyRatesExt : PXGraphExtension<RefreshCurrencyRates>    {        public delegate void RefreshRatesDelegate(RefreshFilter filter, List<RefreshRate> list);        [PXOverride]        public void RefreshRates(RefreshFilter filter, List<RefreshRate> list, RefreshRatesDelegate baseMethod)        {            baseMethod(filter, list);            throw new Exception("");        }    }here the error message:Parameter count does not match passed in argument value count.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.ArgumentException: Parameter count does not match passed in argument value count. a

Hello Acumatica Community,I would like to ask if it's possible, through coding or a similar method, to download all non-standard reports and automatically push the files to GitHub (e.g., via API) for data backup or version control purposes once a month. I'm not overly optimistic, but it would be quite handy to not do this manually anymore but in a automated manner. Greetings      

Dear Team,Suppose there is the following situation:User01 enters the Cases screen > When clicking on the selector of the Class ID field > only see the Classes that User01 is authorized to see (For example, only see Case Class ID as "OTHER") How to assign user rights according to data type? Best Regards,NNT 

digital scales acumatica does not detect rs232, What kind of connection do digital scales actually use or mengunakan ?,And what kind of device do you use?please enlighten me

Hi, I am creating a new processing screen and have created the DataView below to grab the data I need for the processing grid. public PXProcessingJoin<ARInvoice, InnerJoin<Customer, On<ARInvoice.customerID, Equal<Customer.bAccountID>>>, Where<ARInvoice.customerID, IsNotNull>, OrderBy<Asc<ARInvoice.customerID>>> Invoices; At the moment it is returning multiple rows for the same customer, as it is returning each invoice, but I would like the query to group on ARInvoice.CustomerID so that I can see which customers have overdue invoices.The reason for this is I want the processing screen to send email reminders for overdue invoices, and I only want one email sent per customer, rather than an email per invoice.Is there a way I can include this clause into the above query? Let me know if you need any other information. Kind regards,Andrew

I am trying to filter the Project ID drop down. Basically I only want to see the projects that are part of the current branch.I am after any pointers to make this happen. Where do I make the change in the Customization Project. Is it on the Screen (where) or the Data Access?Is this a good place to start:I need to know how to reference the current branch and how to filter the projects so it is only the ones for that branch. many thanks everyone.

Hello everyone, asking for assistanceI need to customize behavior of the Shipment screen in status Confirmed (Acumatica 2022R2):I need to disable action correctShipmentAction I need to enable field SOShipment.shipVia​​​​By default entire screen is disabled in status Confirmed, except ShipmentNbr fieldHere’s my code:            void EnableSomeFields(FieldState.IContainerFillerFields states)            {                states.AddField<SOShipment.shipVia>();            }              context.UpdateScreenConfigurationFor(config => config                    .WithActions(actions => {                        actions.Update(                        action => action.correctShipmentAction, (ActionDefinition.ConfiguratorAction actionConfiguration) =>                                        actionConfiguration.IsDisabledWhen(conditions.ShipmentIsInConfirmedStatus));                    })                    .UpdateDefaultFlow(flow => {                        return flow.WithFlowSt

​From custom code, I’m creating a service order and filling in a few fields at the header as well as a few fields of a line item record.  I thenthrow new PXRedirectRequiredException(graph, null) { Mode = PXBaseRedirectException.WindowMode.NewWindow };But when the screen opens, the “Settings” tabitem is displayed.  I would like the “Details” tabitem to display instead, so the user can fill in the remaining information for the line item without having to click on the “DETAILS” tabitem first.​Screen opens with “Settings” tab displayedI want the “Details” tab to display instead 

Good morning,We would possibly like to add some intermediate steps/transitions to those "out of the box" of the workflow of the Appointment FS300200 form(For the moment I was using attributes, but we are starting to reach the end of what the attribute can do ).Having never played with workflows, I listened to several tutorials and did some reading. Before to jump I have somes questions :Do you have any pros and cons for editing workflows? Should I avoid getting into workflows? Do you have any Do’s and Don’t’s do for workflows customization? Considering that I am adding intermediate steps, am I correct in thinking that this will not have an impact on "closely related" workflows such as the "Service Order"? Something that escapes me, can we assign a workflow for a service order type? If yes, how?THANKS! 😎

Hello,I see that when creating a webhook Push Notification, we can add a header name and value, but I do not see a way to provide multiple headers and values. I am also struggling to find any documentation that mentions this. Does anyone know if this is possible or if multiple headers are not supported?Thank you,Jason

We do customizations in Purchase order screen that is published in system. We want that too publish in Mobile app. How to do that? Can anyone help me to solve this issue?

I create setup screen. I don’t see next navigation link to screen I want to see “ Next step navigation link to setup page”.