Other Developer Topics

I’m trying to convert the Generic Inquiry - Customer Summary to a MySQL statement. It seems GI only display MS SQL syntax even though I’m using MySQL as the tenant DB. I have everything pretty much working but I’m seeing more customer rows using a MySQL statement than what GI is returning with Preview. Any suggestions would be appreciated. Customer Summary - MySQL ScriptBasicCustomer Summary MySQL ScriptBasic OutputGI - Customer Summary Output - Spreadsheet (PDF)

In this Coffee & Code session, we’ll dive into OAuth and APIs, with a focus on creating and managing custom endpoints, and use of different parameters for integration. We’ll walk through the fundamentals of OAuth authentication and authorization, explore how APIs can securely expose data, and discuss best practices for designing custom endpoints that extend platform functionality. A live demo will showcase how developers can implement OAuth flows and build custom endpoints that integrate seamlessly with external applications. We will also discuss the upcoming changes related to the API integration and how it affects the ISV solutions.Speakers: Natesan Sivaramakrishnan Technical Account Manager

I am getting this error on trying to approve time cards though mobile app. It works if I try to approve from the desktop site.

I tried to change the database connection that was pointing to my Orange Pi Zero portable Linux server to my AWS MySQL Linux DB. It wanted to create the DB rather than just connecting to it. Is this normal or is there another method beyond the Acumatica ERP Configuration utility?

Dear Sense,I have a 7GB SnapShot file from Acumatica Cloud. I want to migrate it to my local laptop, but I don’t have access to the Acumatica database because it’s hosted in the cloud. Can you help me migrate my data to my local laptop?Please Help

Hi community,We are in the process of upgrading our customer's environment from 2024 R1 to 2025 R1. when we published our existing customization package on the 2025 R1 environment, we encountered the following validation error:[2025-09-02 11:27:41.384] Building directory '\WebSiteValidationDomain\App_RuntimeCode\'. [2025-09-02 11:27:42.797] \App_RuntimeCode\SOInvoiceEntry.cs(7): error CS0234: The type or namespace name 'Concurrency' does not exist in the namespace 'PX' (are you missing an assembly reference?) [2025-09-02 11:27:42.797] \App_RuntimeCode\SOShipmentEntry.cs(40): error CS0234: The type or namespace name 'Concurrency' does not exist in the namespace 'PX' (are you missing an assembly reference?) [2025-09-02 11:27:42.797] Compiler time, in seconds: 17.8884243 [2025-09-02 11:27:42.891] Validation failed.In the 25 R1 release notes, we noticed that the PX.Concurrency namespace was renamed/modified.PX.Concurrency was renamed → PX.A

Does anyone know why the workspace gets re arranged everytime we publish a new package in customization.Like this order which get change after each time we publish something new. Is there a way to prevent that or set it for once? 

Hello,I am using Acumatica Endpoints and try to using Case endpoint to get Related case detail but I am getting error, please check the attached screen shot, please help me  Regards,Abhishek

Has anyone ever ran into this issue?When using an email template to send out notifications to customers and the receiver’s preview window for the email does not read the body of the email, but instead lists, “Constants loaded at”? I read that it could be the email provider’s formatting is reading open characters first instead of the characters it is supposed to catch first, however I didn’t seem to find a solution. Any thoughts?

For those new to ASP.NET, (like me) this is a good explanation of the process and hopefully demystifies the delays. Here is the step-by-step process:1. The compilation of C# code into a DLLAn ASP.NET project's C# code, including the "code-behind" files (e.g., MyPage.aspx.cs), is compiled into a Dynamic-Link Library (.dll

Acumatica allows displaying the endpoint schema with a REST call. This is an example of the Customer endpoint schema.localhost/acumaticadb/entity/Default/24.200.001/Customer/$adHocSchemaI put the output on my server as it too large to display in a post.https://johnspikowski.com/acumatica/customer_schema.txtThe Web Services Endpoint screen is another asset for endpoint definitions.http://localhost/acumaticadb/Main?CompanyID=Demo&ScreenId=SM2070PL 

Hello, Has anyone encountered this issue before?I recently un-installed and re-installed the Acumatica app on 2 Zebra devices due to personnel changes. Ever since then, the devices are not allowing the picker to scan/manually enter the pick list number (which happens to be our shipment number). As seen in the attached example, the picker would normally enter pick, pack and ship, then scan (or manually enter) the barcode/shipment number at the top of the page.When the 2 devices scan this barcode/enter the shipment number, the device errors out and says “SHP007767 is not valid.”When I try the exact same steps on another device, then it works as it should, and the picker is able to scan the barcode. We currently have a workaround where these 2 devices select “Next List” and follow the prompts to pick and pack. It is very odd to me that this issue is only occurring on these 2 devices where the app was recently re-installed. Any hel

ScriptBasic was created as an embedded scripting engine. The console interpreter and web server are examples of using the ScriptBasic API. C# is able to call C functions. The host language can get /set variables and call functions.The script I wrote to get tenant names is good example how you could use ScriptBasic for missing functionality.ScriptBasic is open source with a MIT Common license. It is commercially used primarily by industrial controllers as its scripting engine.ScriptBasic runs on Windows (32/64 bit) and Linux.using System;using System.Runtime.InteropServices;class Program{ // Import the Add function from the C DLL [DllImport("Example.dll", CallingConvention = CallingConvention.Cdecl)] public static extern int Add(int a, int b); static void Main() { int result = Add(5, 3); Console.WriteLine($"R

I have read that Acumatica is working on running on Linux with .NET Core. Will Apache / Nginx be the web server used? Would PHP be a better solution than .NET Core?Can Acumatica run on Apache on Windows?

Do Acumatica programmers call themselves web developers? I see Acumatica programmers as Windows C# .NET programmers. The web platform is magically created under the covers by creating HTML files of templates. Most Acumatica developers didn’t realize Bootstrap is the presentation layer. I bet most don’t even know what a rendered Acumatica web page even looks like. 

I'm following the Modern UI course for Acumatica and working with a SmartFix_T290 instance (version 25R1). I have followed the instructions provided in the course PDF, including: Creating the RS201000.ts and RS201000.html files in the following path:..\SmartFix_T290\FrontendSources\screen\src\screens\RS\RS201000 code is copied from Acumatica help git repository Running the npm run build-dev command inside the ..\FrontendSources\screen folder (this completed successfully without any errors) After publishing the customization and updating the site map, I’m able to switch to the Modern UI version of the RS201000 screen without any issues. However, when the screen loads, it only displays a blank white space — no UI elements, grids, or fields appear, as shown below.There are no v

Can we add a wiki page with an image where we can define % of screen it have to occupy ??  [image:Graphic\Links.png|700px|Links|noclick]With such we are defining pixels and this size might not be scalable on all screens. On some small screens it looks very big.

I was testing the Login endpoint in ScriptBasic with cURL and I’m seeing duplicate Set-Cookie: headers returned. Can someone in the development group check to see if they are sending dups? C:\Acumatica>sbc login.sbHTTP/1.1 204 No ContentCache-Control: privateSet-Cookie: ASP.NET_SessionId=fzij23u0gpn1ytgyppfvk5re; path=/; HttpOnly; SameSite=LaxSet-Cookie: UserBranch=16; path=/Set-Cookie: Locale=Culture=en-US&TimeZone=GMTM0800A; expires=Fri, 01-Aug-2025 03:44:56 GMT; path=/Set-Cookie: CompanyID=Demo; expires=Fri, 01-Aug-2025 03:44:56 GMT; path=/Set-Cookie: .ASPXAUTH=3E6A8CF7C56FAF5905F956EE5ABB7B17872218E74715D89CB07F22DB2F7FFC7D3DE46736133B9E1A9BFC40CD97D90287B59FCA47ABBEBA08EA1AEABE8B087BB07B41920C18FA22437784124D3FEF3092B636BFB4343575ED04610B1553C710A56C20661E011FCF4F9B31F3D0ECC9D4AFE14B125D1CDFF22CD34BEB30E019593E81EC0885; path=/; HttpOnlySet-Cookie: ASP.NET_SessionId=fzij23u0gpn

We are a division of a user of Acumatica .  It’s hoped that our division will start using Acumatica  sometime next year.Our parent company is primarily a plumbing/HVAC/electrical installation and repair company.  Manufacturing was a sideline with non-repeating work, small quantities, and flexible due dates.  We are a tier one manufacturer and we were bought (in part) to expand the parent company into large quantity, repeating work .We have been using another ERP program for decades (with occasional upgrades, of course).  We’ve created inhouse solutions that fit our process better or add features that aren’t available yet; all built on the ERP data to expand capabilities.I had little to do with the roll out to our parent company – except for providing some tricks for data extraction and compilation.  I am new to Acumatica . Questions and plans (sorry for the length and I don’t know what I don’t know) :Would two instances be needed?  Our present

Hello, I have created a new attribute for customers which will show their shipping account number (no carrier plug ins are used). I would like to add this to the shipping tab (or create an attribute tab) in Sales Orders. Is this possible?  

I need to fill data in View 1 times when page is open. Not to reload it multiple time

Hi Everyone,I joined the Acumatica forum as a resource for my external Acumatica application extensions using REST and the ScriptBasic application web server. Any good links to REST interfacing would be appreciated. John Excuse typo in the title., 🙄

I’m trying to work through course T290 using 24.211.0024 (2025R1) and have got stuck with the step where I compile screen RS201000 using the command:npm run build-dev -- --env screenIds=RS201000This fails with the error:Task never defined: screenIds=RS201000 Has anyone seen this before and knows how to resolve it? Other npm commands work OK. I needed to execute  Set-ExecutionPolicy RemoteSigned  before npm would run at all. And edit gulp-tools to resolve the message Error: spawn EINVAL by changing line 108 from const cmd = spawn(command, args, { cwd, }); to const cmd = spawn(command, args, { cwd, shell: true });Also “npm run build-dev” works without the extra parameters.

I have open screen using PXRedirectHelper.TryRedirect(graph, PXRedirectHelper.WindowMode.Popup); Now i will need to close this screen.

Hi everyone,We are using Acumatica SaaS and don’t have direct access to the production database.We get a .bak file from the portal to restore a copy locally.We can restore that .bak to our local SQL Server — that works fine.  But we want to keep our local DB up to date without restoring the whole .bak each time.Is there a best practice to replicate only new or updated data or  only way is ODATA/API?Please GuideThanks