Other Developer Topics

Dear community, We are collecting feedback about technical webinars you’d like to see.Please leave a comment for the webinar you’d like to attend. Also, if you have other ideas for webinars, feel free to suggestAcumatica Unit tests Framework Acumatica DB Upgrade process Performance troubleshooting New UI – practical session Webhooks BQL/FBQL - getting started BQL/FBQL - deep dive Import/Export providers Working with dialogs

I used to see line numbers with the stack trace but with the new layout of the trace screen, I seem to have lost the line numbers.  I have uploaded my pdb file.My web.config file has <system.web> <compilation debug="True" What else might I be missing?

I am trying to create a projection of the Service Order Detail joined to the Appointment detail.This is the SQL statement I am trying to emulate:SELECT FD.[SrvOrdType] ,FD.[RefNbr] ,FD.[OrigSrvOrdNbr],FD.[OrigLineNbr] ,FD.[UnitCost],FD.[UnitPrice] ,FS.[RefNbr] ,FS.[LineNbr] ,FS.[LineRef],FS.[UnitCost] ,FS.[UnitPrice],FS.[TranDesc] ,FS.[SODetID],FS.[SOID]From [FSAppointmentDet] FD JOIN [FSSODet] FS on FD.OrigSrvOrdNbr = FS.RefNbr AND FS.LineNbr = FD.OrigLineNbrWHERE fs.UnitPrice <> FD.UnitPrice And this is the Projection I am trying to get together, but there are syntax errors here I can’t seem to trace down: [PXProjection(typeof(Select2<FSAppointmentDet, InnerJoin<FSSODet, On<FSSODet.refNbr, Equal<FSAppointmentDet.origSrvOrdNbr>, And<FSSODet.lineNbr, Equal<FSAppointmentDet.origLineNbr>>>, Where<FSSODet.unitPrice, NotEqual<FSAppointmentDet.unitPrice>>>), Persistent = true)]I seem to

After all setup is done for connecting to Azure Accounts, application created in azure and added to the users account, the admin doesn’t enter an azure account password for the user. There is a test button on the users profile, do they have to go there to “activate” the account? And if so what are the minimum rights to make the test button thing work for a typical user (I put this in the wrong place and can’t move) 

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, We are working on developing a new project still on evaluating which tools we are going to use for frontend and backend etc. my question is:Can we use Acumatica tool or framework to help us speed up our development instead of using .Net Core, and React or angular as frontend?  Thanks

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

Greeting all, before upgrading to 23r2 there was no problems with 22r1but after upgrading i am facing an error in invoices screenThere is an error that’s pops up whenever i want to delete any invoice.says “This record is referenced by at least one 'dbo.SOInvoice' record. The operation cannot be completed.” i unpublished all the customizations and then it worked well,so i tried and commented The customizations of soinvoice_extension and its dac extensions only but the error still the same.so i may have to debug the delete action to see why it gives error and how to solve it.So how to debug the builtin delete action?

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

My local development with Acumatica ERP 23R1 (any version) does not display Trace detailsin the improved Trace window when opened on a page via the Tools » Trace option.It shows No records found.Has anyone else encountered this issue?The Improved Trace works fine on our development server, but not under localhost/iis. 

I’m creating testing in the TestSDK and one of my operations runs over 12 to 15 minutes.  I’m getting a timeout error:WaitTimeoutException: Timed out waiting for the WaitForLongOperationToComplete condition within the specified timeout: 360000msIf I only run the process for a few records, it works fine so it is not a problem with the actual code in my project.  Is there any way I can change this timeout limit or is this a “selenium” limitation?

Hello Community,I would like to know the value being fetched under the ParentAccount table in the Account Details (GL404000) inquiry form.I have the following list of tables that says it is included in this inquiry form:But I am unable to find this particular table in the Inquiry form. Can anyone let me know the SQL query to run to check out the same?Thanks in advance.

Hello, I have created a Push Notification Webhook, to update external application when a Production Order is released. I had this working at one point, but now its not. I am using webhookinbox right now to test the webhook transmission. I am not getting anything to the inbox, so I looked inside the Acumatica system monitor, and I see the Push Notification was attempted, and the notification is as expected, but I keep getting a ‘webhook returns not success code: internal server error’. Not too sure where to go from here seems everything is working properly but it isn’t receiving a response from the server. Any suggestions/directions would be greatly appreciated, Thank you in advanced!Exception =System.InvalidOperationException: Send to target Mechanilink (New Prod Order) failed. Message: WebHook returns not success code: InternalServerError; Message: Internal Server Error   at PX.PushNotifications.NotificationSenders.HttpClientPushNotificationSender.Send(NotificationResultWrapper result

I think this is just ignorance but I have a customer who is upgrading to 2022 R2 and they no longer have a create service order option from the opportunity. It is there but it is grayed out. (You can hardly see it, but it is there: So two questions: Is this just expected behavior, because my user has missed a step and that is why the Create Service Order isn’t active? Can I programmatically change it in the customization so it is enabled for them? Thanks! 

Greetings,we are currently in the process of integrating a new custom font into our system, specifically on Windows Server 2016, for use within the Acumatica / Haufe X360 environment. The font in question, an open-source font available at Source Sans 3, appears to be installed correctly. It is also visibly rendering in the PDFs we generate. However, we've encountered a curious issue: the generated PDFs are consistently missing certain characters, namely 'i', 'j', 'ä', 'ü', and 'ö'. This peculiar omission has left us somewhat perplexed, and we're currently seeking insights into the potential causes of this anomaly. Any suggestions or ideas on this matter would be greatly appreciated. Thank you.

How to reduce the size of Acumatica database without losing data?

I need to set extended fields when a Service Order is created via a Project.I am trying to use the logic shown to me in this post: (Create Appointment With Extended Values)But when I create this: public delegate IEnumerable CreateSrvOrdDocumentDelegate(PXAdapter adapter); [PXOverride] public IEnumerable CreateSrvOrdDocument(PXAdapter adapter, CreateSrvOrdDocumentDelegate baseMethod) { //Adds RowInserting handler when the ServiceOrderEntry Graph is created PXGraph.InstanceCreated.AddHandler<ServiceOrderEntry>((graphServiceOrderEntry) => { var CQ = Base.QuoteCurrent; var currentQuote = CQ.Current; PMQuoteExt QuoteExt = currentQuote.GetExtension<PMQuoteExt>(); graphServiceOrderEntry.RowInserting.AddHandler<PX.Objects.FS.FSServiceOrder>((sender, e) => { var SvcOrderObject = (PX.Objects.FS.FSServiceOrder)e.Row;

I have a customization I am working on, and it had an error that showed up when trying to publish it.So, in order to work through this, I thought I would simply republish the rest of the packages, and leave that one out. But it doesn’t let me. I keep getting an error regarding the package.I have tried to clear out caches and manually deleting files from the bin directory, but I still get the errors.It fails with this error (there is no assembly for American216… But that customization is not part of what I am publishing. There is no need to be trying to load it. It is a stand alone package that is no longer published, and not referenced by anything, but Acumatica keeps looking for it? Why????) :[2023-12-13 18:59:56.937] Validating Extensions[2023-12-13 18:59:56.937] Failed to load types from assembly American216, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null with message: Could not load file or assembly 'PX.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3b136cac2f602b8e'

All,I created a data provider and import scenario to update business accounts. It makes two changes:Updates a user-defined field of “Next Contact By” to replace the current person with “John Smith” (example) Updates the current BAccount owner with the new owner (“John Smith”)The user-defined “Next Contact By” field is updating properly (ie, changing Sally Jones to John Smith). But the owner field is deleting Sally Jones and leaving the field blank (it should be replaced with Sally Jones as well.)Could someone look at my xml/screenshot and tell me where I’m messing this up? 

@AaronB I am tagging you on this.  You are the TestSDK guru and you might have a quick solution to this.  :-)This is probably more of a C# question, but hopefully it is an easy answer.I am running a large number of reports in TestSDK.  This is an example of the code I am using to run a report which works just fine.public void APBalanceByGLAccount(){ using (TestExecution.CreateTestStepGroup(ICSMessages.APBalancebyGLAccount)) { AP632000APBalanceByGLAccount screen = new AP632000APBalanceByGLAccount(); screen.OpenScreen(); screen.Run(); screen.Excel(); }}Rather than have this code duplicated 50 times, I want to use a generic method where I just pass in the wrapper and generate the report.  When I explicitly setup the screen object above, it automatically gives me access to .Run() and .Excel().The generic method code below runs and opens the screen for the GL Register report.  I just can’t find a way to run the report and export it to Excel.public static void RunReport<T>() where

Can someone help me with the quantity riddle? I’ve seen this on what the different quantities mean however it doesnt seem to apply. I have an item below 11451-LOOSE (which incididentally is a stock kit though i dont think this matters) and it has:Quantity On Hand = 2370.694Quantity Available for Shipping = 2370.694 (there IN Issue, SO Allocated and SO Shipped must all be zero)Quantity Available = -24,829.3 which implies SO Prepared, SO Booked or SO Back Ordered must be large to account for the difference, however as you can see these are all zero too? I do feel that Acumatica over-complicates simple concepts and makes it near impossible for the end user to understand...and Im a Developer of the system and I cant understand it nor able to advise my clients!! 

We have the order that was prepaid. Now customer want to cancel it. trying to cancel it sales manager got an error: “SO Error: The sales order XXXXX cannot be canceled because it has the YYYYY payment applied. Reverse the payment application before you cancel the order.”What we doing wrong? 

I am working to move a customer to Acumatica 2022 R2.In their build, there was a delegate that we overrode (InsertDataIntoAppointmentDelegate)The issue is we added some fields to the Service order that we want to carry over into the appointment automatically.So, we called baseMethod.Invoke() and then added our code after that: { baseMethod.Invoke(order, appt); FSServiceOrderExt orderExt = order.GetExtension<FSServiceOrderExt>(); FSAppointmentExt aptExt = appt.GetExtension<FSAppointmentExt>(); //insert values aptExt.UsrAuthorizedByContact = orderExt.UsrAuthorizedByContact; aptExt.UsrFieldSiteContact = orderExt.UsrFieldSiteContact; aptExt.UsrDoorLocation = orderExt.UsrDoorLocation; aptExt.UsrLaborType = orderExt.UsrLaborType; aptExt.UsrProductType = orderExt.UsrProductType; aptExt.UsrCustomerIsExempt = orderExt.UsrCustomerIsExempt; aptExt.UsrTaxExempt = o

protected void INLocation_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { INLocation row = (INLocation)e.Row; INLocationExt rowExt = row.GetExtension<INLocationExt>(); if (rowExt != null) { // Accede a la nueva columna y realiza acciones adicionales decimal? valorNuevaColumna = rowExt.UsrVolumen; decimal? valorNuevaColumna2 = 78; // Verifica si es necesario actualizar el objeto INSite INSite orderInCache = Orders.Current as INSite; if (orderInCache != null) { // Ajusta para actualizar el campo usrSumVolumen Orders.Cache.SetValueExt<INSiteExt.usrSumVolumen>(orderInCache, valorNuevaColumna2); PXTrace.WriteInformation("EMPEZAMOS - Nuevo valor: " + valorNuevaColumna2.ToString()); // Persiste el cambio

Hi all, I tried to send email to workgroup and have created a SQL View to compile all the employee emails in one field. The problem now is field from SQL VIEW is not showing under Entity in ‘To’ field in notification template, Image 1: All employee member under each workgroup already combined in one field using SQL ViewImage 2 Field not display under Entity in Notification template