Other Developer Topics

I’m experimenting with getting Acumatica running under Ubuntu Linux using Mono on my portable Linux server. I have ASP.NET working with Apache and the few test .aspx and .cs programs working. I’m currently working my way through the web.config file translating Windows paths to Linux paths. I noticed that Node.js-win is installed under WIndows. My understanding this is used for the Modern UI which isn’t a focus for me right now. Is there any additional Node.js packages used by Acumatica beside the base install that Acumatica checks for even if I don’t have the Modern UI enabled?I’m hoping the Acumatica developer team that may be lurking here on the forum can respond to my above questions.My NpmCache doesn’t show any files for the tenant I’m converting nor can NPM be found or used from PowerShell. My assumption at this point installing Node.js v22.19.0 is all that is needed.   

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 

Please provide feedback on the Modern UI if you have issues with it so that Acumatica can focus on improvements to it.  Acumatica AI will pick up your feedback for them to focus on improving it prior to the 26R2 release when the classic UI goes away.

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?

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=fzij23u0gpn1ytgyppfvk5re; path=/; HttpOnly; SameSite=LaxSet-Cookie: UserBranch=16; path=/Set-Cookie: Locale=Cu

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)

Hi everyone,We’re delighted to announce this Community Mentoring session with @Yuriy Zaletskyy !10 things I wish I knew, when I started Acumatica development Convention over configuration Debugging of Acumatica source code tricks, which weren’t shared yet at Acumatica dev cons Debugging of Acumatica web API requests details And more! Community Mentoring sessions are approximately 30 minutes and limited to small groups (6-10) 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 April 19, 2023 at 12:00PM ET.Yuriy Zaletskyy, Founder, CTO, AcuPower LTDCheck out Yuriy’s Blog HERE

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

Hello all!We’re exploring ways to improve the demo experience inside Acumatica, especially demonstrations across different industry verticals (Manufacturing, Construction, etc.) easier.Here’s what we would love to hear from you:How does your team currently demo Acumatica? (Self-hosted, SaaS demo environment, sandbox, etc.) Which roles do you demo most often? (Sales, Pre-Sales, Consultants, Customers, Prospects) What seems to work really well when your team demos Acumatica today? What are the biggest pain points when demoing Acumatica? What would make demos easier, faster, or more compelling for your team?Your feedback will help us make demoing Acumatica easier, more consistent, and more impactful for everyone involved. You can also reach out to me directly with your feedback either on Community or sending me an email (Vlad.Sushkin@acumatica.com).Thanks! 

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 have a custom process screen that loads fine from a projection view created on the customer, location, InventoryItem and ARSalesPrice tables.  The data loads fine, but soon as I click on the select for one of the Lines, the whole row blanks out the data it was displaying just fine.  Wondering if anyone has any ideas on how to even approach this one. The error message says Operand type clash: datetime2 is incompatible with intIt is a SQL Error: Stack trace here:  t PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCop

so, basically I have 2 different pages, both with a (vip checkbox) data field. one page is a customerClass and the second page is a customer page. the customer page is kind of an instance of the customerclass so when a record for customer is created, certain fields are already populated with information from the customer class. the vip checkbox is a custom field that i created and i want to know how i can link them so when the checkbox on customerclass is ticked, the customer records created take that value and tick its own vip checkbox. im new to acumatica so please explain in detail if you canthis is customer class,see the vip box on the right? if i tick that, when i generate a customer record, its vip box should already be tickedthis is the customer page. when i create a new record, the vip box should already be ticked if the customerclass vip box is ticked

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.

Hello, I want to send email to specific customers when their Invoice is released.For this,1. I have changed the Email setting for customers in the Mailing and Printing tab. 2. Created a new email notification template which is linked with the SO64300 report. 3. Created a new GI which joins the ARInvoice and Customers table to store the required information. 4. Created a new business event of type Record Change which is triggered whenever a new record is inserted in the GI.  After several trial and error, the system is still not working. In conlusion, the business event is not firing. What could be the possible reasons for the business event not firing?

Hi!I am getting started with 2023R1 and its early offering of Modern UI development under Aurelia and TypeScript.After a fresh install of the Site, I open the FrontendSources folder in VSCode and then from its Terminal tabI execute the following 3 commands: npm install --save-devnpm run getmodulesnpm run build The first 2 commands appear to run just fine.The 3rd command shows error:  TS2307: Cannot find module 'client-controls' or its corresponding type declarations.I am fairly new to VSCode so I may be overlooking something, but how do I overcome this build error?Files such as SO301000.ts show ‘client-controls’ with red squiggly error indication.  

Hi Acumatica,I tried to test the Acumatica AI Functionality in my Local Server.But I don’t see any features yet.Is there a way to test or check the AI Functionality in Acumatica aside from the Local Server?Thank you! 

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? 

I can see that AR301000 has an action called releaseFromHold.  However, Sales Invoices don’t have a processing screen like Sales Orders do so there isn’t a processing screen to add this action into like this Add Remove Hold Action question.How might I take several thousand invoices off hold?

 Hey Acumatica Community,I'm looking for a way to customize the app theme so that only the color of the left menu is black, and the text and logos are white, but I'm not sure how to do it. Could anyone help me with this?  Please see the attached picture where I've highlighted the left bar in green. I want to change this section to black with white text. However, I'm unsure how to modify just this section without altering the background colors of other sections.Greetings

I have been running Acumatica 22r1 and 23r1 instances on my Windows 11 Pro work computer for months.  Tonight, I tried to publish my 23.110.0025 project, and I suddenly started getting errors with the path being too long.  It appears that on the 16th (2 days ago) Microsoft pushed out a Windows Configuration Update which I suspect is the culprit.Error:[2023-09-19 02:12:09.674] Patching the file C:\Projects\SSCS_23_110_0025\Customization\SSCS_23_110_0025\SSCS_23_110_0025Validation\SSCS_23_110_0025Website\CstPublished\Pages_SS\SSCS1000.aspx.cs[2023-09-19 02:12:17.038] System.Exception: An error occurred while copying files to the temp directory ---> System.IO.PathTooLongException: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, Object dirSecurityObj, Boolean checkHost) at System.IO

Hi,How can I make an OData call to a Generic Inquiry with multiple values for a filter?  For example, OrderID is 1001, 1003, or 1004.I know OData v3 does not support the “IN” filter clause.  But can I user parameters or OData v4 to retrieve multiple records based on an array of filter values?Thanks!

I’m trying to get more detail on a PXLockViolationException trace error so I thought I’d try remote debugging on the server hosting Acumatica.  I started a remote debug session on the server but I’m not sure what to do next.Question: do I open some Acumatica project on my local machine?  If so, which one?  I’ve only been working with Customization Projects so I not sure how to start a remote debug session for hitting breakpoints coming from a trace. 

changing standard Shopify integration:I am stuck trying to find out where cbapi.Put<SalesOrder>(obj.Local, obj.LocalID)from SPSalesOrderProcessor class SaveBucketImport is defined in standard code.I can find only interfaceI need to override logic behind last line of codeClass SPSalesOrderProcessor        public override async Task SaveBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, string operation, CancellationToken cancellationToken = default)        {            MappedOrder obj = bucket.Order;            SalesOrder local = obj.Local;            SalesOrder presented = existing?.Local as SalesOrder;            BCBindingExt bindingExt = GetBindingExt<BCBindingExt>();            // If custom mapped orderType, this will prevent attempt to modify existing SO type and following error            if (existing != null)                obj.Local.OrderType = ((MappedOrder)existing).Local.OrderType;            SalesOrder impl;            DetailInfo[] oldDetails = obj.D

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.