Other Developer Topics

for acumatica development, i am using a macbook (m3) running Windows 11 (ARM) VM.  on the windows VM, i’ve installed Acumatica and Visual Studio 2022 (ARM 64-bit).   i am able to build DLL’s with custom code and run Acumatica on the VM.  However, i am unable to install Acuminator.  when i download the 3.1.3 from the vstudio marketplace and attempt to install it, i get the message, “This extension is not installable on any current installed products.”are there any plans to provide an ARM-compatible version of the Acuminator, or does anyone have any workarounds for this issue?thanks   jim 

MS SQL Server seems to be the popular choice for PCS (Private Cloud Subscription) instances, why?Why would we not consider MySQL? Is it because most training and other documentation from Acumatica uses MS SQL Server? Has anyone experienced both and seen if there are performance differences?

When I am running a local instance of my Acumatica site I am unable to view my ‘Trace’ log. When clicking Tools → Trace… I get the following blank screen :   I have the ‘ProfilerMonitorThreads’ key set to True in my web.config file which was previously needed for allowing access to the Trace page but now I am unable to access that page at all.

We’ve been using Twilio for a couple of years now as our SMS gateway provider, but ever since the Feds passed their  A2P 10DLC registration act, they have become insufferable. Technically, none of our Clients even really need to comply with the registration, because they are all low volume, and don’t do marketing via SMS. But Twilio demands we set up a “Campaign” anyway. Recently, I was trying to gather up screenshots to create documentation for our Clients to use when they go to Twilio to set up their own accounts and the obtuse and pedantic things they are requiring of me are just unbelievable. I’ve thought about just putting a cellphone in our office and run an app to turn it into an SMS gateway, and provide it as a service for our clients… But, I’m trying to get out of the middle, and that will open me up to support calls on things I would rather not deal with.I know I can use AWS, but they have always seemed to be difficult to deal with as well. I’m

I am using PXResult in foreach and it gives single row was requested error occured   

While creating sales order and adding line items in so line i am encountering this error. Below is the screenshot of the error. I am not able to find out the actual cause of the error. Please help.Details : Name: Aggregate Validation: PX.Objects.SO.SOOrder+orderQty. Below is screenshot.We already upgraded within R2, both 206 and 209 but still issue remains there. Please help how to debug this issue as in my code there’s no exception throwing. Let me know if there’s any specific settings or locations to look out for.

 Hi Community,The error i am getting, is when my service order record has records under the details tab. When i go to the Financial Tab and try to change the billing customer field i get the following error:  Error: Unhandled exception has occurred, your changes have been rolled back: Error: An error occurred during processing of the field BillCustomerID: Unable to cast object of type 'PX.Objects.FS.FSSODet' to type 'PX.Objects.FS.FSSODetEmployee'.. This version of acumatica is 2024R1 and is one of acumatica screens where i have

Hi Everyone,Was wondering if anyone is aware if the Acumatica-LotSerialNbrAttribute package has plans to support the IN307000 Kit Assembly screen? 

The Acumatica Developer Conference is an annual conference that provides our technical community with the in-depth knowledge & tools required to build great customizations, integrations and even applications, fully utilizing Acumatica’s cloud xRP platform.This year’s event will be held over three (3) days with about four (4) hours of presentations each day. We are organizing the event into three different days, catering to different knowledge areas: Beginners, Intermediates, and Advanced. Our speakers are finalized by our CTO, Mike Shchelkonogov, along with other Acumatica and Technical Community speakers. The agenda and speakers are still a work in progress, and we will provide updates as soon as they are finalized.Learn more and register HERE: https://www.acumatica.com/developer-conference/devcon-2024/

How can I ovveride this buttons on Transfer screen?  

Hi All,Build 23.212.0024This question has resulted from debugging work we’ve done related to another question here:We ran an SQL profiler to attempt to debug the above issue where a processing screen is acting differently depending on whether it is run manually by a user or run using an automated schedule.It revolves around an issue we’re finding when the query that builds the list of rows for the processing screen, Acumatica is appending different predicates to the where clause of the SQL depending on whether the it is run by a user or by an automated schedule.Specifically the BranchID fieldWhen run by a user, the SQL generated includes the following predicate:( [POReceiptLine].[BranchID] IS NULL  OR ( [POReceiptLine].[BranchID] IN ( 23, 24))

 How to get this Acumatica URl in code Currently i use System.Web.HttpContext.Current.Request.Url.AbsoluteUri.ToString() But some time it is null. So it not solve my purpose to get URL. Also some time PX.Data.Update.PXInstanceHelper.HostName is null

I'm faced to a behavior in caches that I don't understand.I created a custom DAC, say MyDAC.In a graph, I create an instance of this DAC like this :PXCache myCache = myGraph.Caches[typeOf(MyDAC)];MyDAC myDacInstance = myCache.Insert(); So far, so good : at this moment, myCache contains one record in its inserted collection (I can check it via debug mode in Visual Studio).Then I modify the properties of the "myDacInstance" object :myDacInstance.xxx = 10;Finally, I update the cache with the following instruction : myCache.Update(myDacInstance); And then the magic happens: instead of having a single record in myCache, I have two ! Each of course has exactly the same characteristics (even for key properties), so on saving, the system throws an e

I have a process screen which applies prepayments to bills automatically based on matching invoice numbers. That much works great. I want to inject a step where the system checks for prepayments that remain open after their associated bill has already been closed out. I have the code that does this, and it works. What I can’t get to work is a user input prompt that says: “Unused prepayments have been found: Do you want to cancel or process bills anyways”For the process to run efficiently, I don’t want the dialog to be raised per record, so I am avoiding events.I’ve gotten the dialogs to work outside of events, but they seem to not cooperate with any form of long operation, including SetProcessDelegate(), which kind of undermines the whole thing. Does anyone know of a way around this? 

We have LastModifiedDateTime in the database tables in the future. On the application level it’s correct.Application Time  Database field time Database collation is SQL_Latin1_General_CP1_CI_AS. Our location -  US, Central Time

Is there a QR control code for RELEASE in the Acumatica mobile app?

Why Sometimes this query return null and some time it will return result?     var result = PXSelectReadonly2<PX.Objects.GL.Branch,        InnerJoin<PX.Objects.GL.DAC.Organization, On<PX.Objects.GL.DAC.Organization.organizationID, Equal<PX.Objects.GL.Branch.organizationID>>,        InnerJoin<PX.Objects.CR.BAccount, On<PX.Objects.CR.BAccount.bAccountID, Equal<PX.Objects.GL.DAC.Organization.bAccountID>>,        InnerJoin<PX.Objects.CR.Contact, On<PX.Objects.CR.Contact.contactID, Equal<PX.Objects.CR.BAccount.defContactID>>>>>,        Where<PX.Objects.GL.Branch.branchID, Equal<Required<PX.Objects.GL.Branch.branchID>>>>.Select(graph, graph.Accessinfo.BranchID);

I have created a screen for uploading bulk images using an Excel Import.I have an action button  “Attach Image”. Using this I can able to attach images in the Grid Row files section. Once the image is attached user wants to see the image in the Grid so we assigned to the PXGridColumn. I want to align and fit image sizes in a Grid column.This is the .aspx code:-<px:PXGrid ID="grid" runat="server" DataSourceID="ds" Width="100%" Height="150px" SkinID="Primary" AllowAutoHide="false">    <Levels>      <px:PXGridLevel DataMember="BrandImages">          <Columns>        <px:PXGridColumn DataField="BrandName" Width="220" ></px:PXGridColumn>        <px:PXGridColumn DataField="ImageData" Width="280" ></px:PXGridColumn>        <px:PXGridColumn Width="700px" DataField="ImagePath" DisplayMode="Value" Type="Icon" LinkCommand="gridControl">

Hi Drimit send me an image ask me to use special field on generic inquiry as my caption on generic inquiry is not getting translated. Please anyone can help how to use or enable this special field on caption in result grid as I am not able to understand the above steps mentioned in image. I have looked in entry point and in whole generic inquiry, I didn’t find such option.?Please help me here.Thanks.​​​​​​

Is there any solution/possibility of files/documents uploaded into Acumatica (e.g. attaching PDF of an invoice to an invoice entry in Acumatica) can also be viewed in an external read/write file sharing and storage environment?

I am trying to execute code to check if a customer qualifies for our reward program.  It needs to run when the order is removed from hold but after the SOOrder.OrderNbr is assigned.  Right now the value is <NEW> when I write the reward record to my custom table. public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter);[PXOverride()]public IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate BaseMethod){    BaseMethod(adapter);    SOOrder row = Base.Document.Current;    if (row != null)    {        Rewards(row);    }   return adapter.Get();}Thank-you

Hi everyone,We’re delighted to announce this Community Mentoring session with @Naveen Boga!Webhooks and AcumaticaNaveen will give a session on the use of webhooks with AcumaticaCommunity Mentoring sessions are approximately 30 minutes and limited to small groups (10-12) of members with one of our power users who is an expert on a topic. If this session is one you feel will help you in your development journey with Acumatica, please let us know in the comments below. We’ll be selecting from those who respond to attend on September 27th at 9am PT(12pm ET). The session will be recorded and recording posted to the Community Resource Library.Naveen Boga, Technical Lead, Kensium

How does a Push Notification know when it has sent out an event for a given record so that it doesn’t do it again?I thought I remember reading that Push Notifications and Business Events make use of some sort of temporary table to know how not to send duplicate events for the same record. But searches seem to show up nothing.

I have a custom page that will allow a user to select several records from a grid and then click a ‘Generate Document’ button that will use a stored proc & several API calls in order to retrieve details from the selected records and generates a document using these details.Each record has the ‘Selected’ property which handles the checkbox selection and lets the ‘Generate Document’ button know which records to pull the details from (using the Reference Number on each selected record).I am using the ‘PXRedirectToFileException’ to download the file after the final API call returns the byte[] array that represents the generated document (and creating a new ‘FileInfo’ object using this byte[] array and a previously declared document name).I don’t run into any errors when executing my code and interacting with the page but when I try to click ‘Generate Document’ there is a slight loading period and then nothing happens UNTIL I click another checkbox on any record