Other Developer Topics

Hi,i wonder if there is a documentation for the API the ReportDesigner uses to query, download and upload reports to an instance?We would like to create a tool to sync a local directory of reports with an instance. Instead of doing them one by one with ReportDesigner.RegardsPascal

I am using Acumatica 24R1 and using 'default' endpoint version '23.200.001' entity 'Customer' using Bearer token authentication using jQuery ajax method, getting error 'request has been blocked by CORS policy', Same I have tried with postman and MVC C# application it is workingwith the following payloadgrant_type:passwrd scope:api username:xx Password:XX Client_ID:xxxxxxx client_secret:xxxxxandURL:{{AcumaticaInstance}}/identity/connect/token Type:POSTget the Bearer token in response and pass the token in below GET request to get the dataURL:{{AcumaticaInstance}}/entity/default/23.200.001/Customer Type:GETWhen I tried this process with postman or MVC application using C#, above both API calling is workingWhen I tried this process whiling using jQuery ajax method getting error 'request been blocked by CORS policy'

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 trying to find a simpler soluti

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 not done any customization to it. Any help will be appreciated. Regards,Joshua

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/ 2024 Virtual DevCon Sessions Schedule - (U.S. Pacific Time) Oct 01 Tuesday10:00 - 10:15 amVlad Sushkin - Welcome 10:15 - 10:30 amAli Jani - Kickoff 10:30 - 11:30 amTBA - Developer

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))However when run by an automated schedule, the predicate becomes this: [POReceiptLine].[BranchID] IS NULLThe tenant in question has two branches and POReceiptLines are being set with the relevant BranchID and not NULL.Setting the BranchID in the A

 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 error indicating that there are duplicates. It looks like the Update method fails to recognize that a record having the same key values already exists in cache and create a new record instead of using it.I checked for key declarations in MyDac and ev

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">        </px:PXGridColumn>          </Columns>      </px:PXGridLevel>    </Levels>   

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