Other Developer Topics

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

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 and then the file is dow

Hi,I have to convert my translation of acumatica from English to Spanish(Mexico).I have a translation string file which has (1500 approx.) strings.Then I have import the excel sheet in the acumatica through translation dictionaries string.It get imported and converted.( after this I have save and log out from the acumatica)I have select the language Spanish at login page and again login in the acumatica.When I checked if all strings are converted or not, some of the strings where not converted which was mentioned in the excel sheet. When I try to convert this string in another language the same strings got converted in that language. Is this is problem regarding steps which was performed for translation stings (miss some steps)  or the format of excel sheet is not proper or if we import the large string files acumatica skips some of the strings or any other problem is there.I have checked in my code which has proper attributes , also Dac fields where properly given.As in Spanish some s

Attributes on DAC Field Properties Aggregator Attributes Aggregated Attributes ​Best Practices Use Cases and ExamplesHi Community,In this post I want to share with you an article on the attributes aggregation in Acumatica. Attributes on DAC Field Properties  In Acumatica, we use attributes to store common business and platform logic that does not depend on any particular screen or DAC. This post describes only Acumatica attributes derived from the PXEventSubscriberAttribute attribute. It is based on Acumatica ERP 2023 R1 although most approaches described in it could be applied to other versions of Acumatica ERP.You can view Acumatica attributes as features which you can add to DAC field properties. For example, attributes can add one of the following features:Specify data type for the field's interaction with the database and runtime using data type attributes like PXStringAttribute or PXDBStringAttribute Configure UI representation of the field with PXUIFieldAttribute Provide defa

I am doing a unit test of a customization for the accounts receivable module but I get the following error, I have already done the exercises of the pdf T280_Testing_Business_Logic_2023R2, can you help me? 

Does anyone have a solution for this? Very frequently, it will hang here and never finish.