Other Developer Topics

Hi everyone,I had implemented a web hook in 23R1 using the PX.Data.Webhooks.IWebhookHandler and I now attempt to upgrade my code to 23R2. In this version, the PX.Data.Webhooks.IWebhookHandler interface has been deprecated and I have to change my code so as to implement the interface PX.Api.Webhooks.IWebhookHandle instead. Does anyone has an exemple of webhook with this new interface ?Thank you

Hi,I’m currently working with a customer regarding their integration to retrieve Labor Cost Rate via REST API. Does this API endpoint use pagination like Employees(entity)? Do you have any API documentation? 

Hi Everyone, I'm having issues writing tests for code that use SelectFrom.I’m trying to set up a Unit test for the below method. public static List<KitSpec> GetKitSpecs(PXGraph graph, int? InventoryID) { var ksl = new List<KitSpec>(); var result = SelectFrom<INKitSpecStkDet>. InnerJoin<INKitSpecHdr>.On<INKitSpecHdr.revisionID.IsEqual<INKitSpecStkDet.revisionID> .And<INKitSpecHdr.kitInventoryID.IsEqual<INKitSpecStkDet.kitInventoryID>>>. InnerJoin<InventoryItem>.On<InventoryItem.inventoryID.IsEqual<INKitSpecStkDet.compInventoryID>>. Where<INKitSpecStkDet.kitInventoryID.IsEqual<@P.AsInt>. And<INKitSpecHdr.isActive.IsEqual<@P.AsBool>>. And<INKit

HelloHow could i take this message to update it in my code?If i take it like this I got body in this format   

upgrade to 2020R2 

where can I download acumatica 2020R2 build version 20.200….

Hi,I have a very basic question, but I’m struggling to find the anwser. We created a new screen where we do not allow inserts and updates. The properties AllowInsert, AllowUpdate and AllowDelete are set to false for the main view of the graph, However, when the users hover the name of the screen in a workspace, a contextual menu apprears with item “+NEW”. How can I prevent this menu to popup or at least, remove the create item from it ?  

As a tester, looking to get an unattended install for everything, Acumatica MSI, a new instance, and our custom plug-ins…  Might be i’m only running into this as i’m iterating on getting what we will be using in the end.  Finding at times the install process is failing with “An instance already exists….”.   Where or how is ac.exe determining a previous install exists…   Having removed:IIS && App Pool SQL Database File and Directory associated for the IIS instancesMost of the time removing all of these have cleaned up or removed the instance,  what else is there?   Really would like to remove the need to run AC.exe and go into App Maintenance and remove the zombie entry...

Hello, I have a user defined field Workorder, that I need to access from some business logic. How do I do this? Thanks 

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 s

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>, An

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 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, Boo

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(Noti

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.