Other Developer Topics

We are using the manufacturing edition. Reference is drawn to Transfer documents, Pick List and/or Shipment Confirmation. These documents are printed to confirm physical transfer of goods. The frequency of such transactions is quite high even on a daily basis. So, is it possible to connect a biometric device to replace a printed document in such a way that the person receiving the goods uses a biometric fingerprint signature instead of using a printed document (to confirm the transfer/receipt/handover)? These documents have to be filed and are rarely referred to again. The same can still be achieved by simply registering the transfer through an unique biometric signature attached to a particular document/record. This will save a lot of paper and print costs as well.Comments/suggestions and/or solutions are welcome!Manish

Hi,Anyone know why all DACs not showing in left side of this screen? I have tried to restart application but still its not showing. Can you help us on this? 

Hi Team,We are encountering an issue with the financial period. When we call the GetFinPeriodByDate method, the system returns an error indicating that the financial period for the specified date is not defined in the system. It suggests generating the financial period, even though the financial year is already open in our local environment.Could you please review this and suggest a solution    

Use Case: Tracking Adjusted Sales Order Line Items for External System SyncWe have a situation where customers need to view their sales orders on our website. Unfortunately, direct access to the API isn't feasible due to high traffic, so we need to sync the data. The challenge is that sales orders (SOs) are frequently adjusted — items are added or removed up until shipping. When items are "removed" from the SO, I need to reconcile these deletions in an external system.Goal: Capture deleted line items on Sales Orders to track and reconcile them with our external system. Initially, I considered using push notifications, but they can sometimes be unreliable (e.g., missed messages). Instead, I'm looking for a way to export all Sales Order Line items to an external table (Azure SQL Server) on a nightly or weekly basis. I’d then run a reconciliation job to manage the deletes.Current Approach & ChallengesI attempted an export scenario that includes NoteID, InventoryID, Branch Name, Create

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>