Skip to main content

Other Developer Topics

Other Developer Topics

  • 189 Topics
  • 607 Replies
189 Topics
Dmitrii Naumov
Acumatica Moderator
Dmitrii NaumovAcumatica Moderator
posted in Other Developer Topics
Technical Webinars Poll

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 suggest.  

2
brianstevens65
Freshman I
2 months ago
Dmitrii Naumov
Acumatica Moderator
Dmitrii NaumovAcumatica Moderator
posted in Other Developer Topics
Technical Webinars

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

7
Dmitrii Naumov
Acumatica Moderator
7 months ago
K
Freshman I
kdesbiensFreshman I
asked in Other Developer Topics
Acumatica Mobile: Issue with Uploading Multiple Photos Simultaneously

Hello, We're encountering an issue with the mobile application when attempting to import more than one photo at a time. The photos enter an endless downloading state.   

2
Chris Hackett
Community Manager
5 months ago
M
Varsity I
mjgrice32Varsity I
asked in Other Developer Topics
Need Help on Projection DAC BQL not right

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

2
Chris Hackett
Community Manager
7 months ago
E
Jr Varsity III
edwardmcgovern53Jr Varsity III
asked in Other Developer Topics
After azure email is all setup and users are setup how do they initialize their account

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) 

2
E
Jr Varsity III
7 months ago
A
Freshman I
ahmedmnFreshman I
asked in Other Developer Topics
Acumatica as a Platform for Creating New Project

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

5
Vignesh Ponnusamy
Acumatica Employee
7 months ago
Y
Varsity I
ygagnaire12Varsity I
asked in Other Developer Topics
Duplicated record created on Update in cache

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

4
Y
Varsity I
1 month ago
M
Freshman II
mohammadessam53Freshman II
asked in Other Developer Topics
How to Debug a builtin function. i want to debug the delete action of soinvoice screen.

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?

4
Chris Hackett
Community Manager
8 months ago
H
Semi-Pro II
HarrySemi-Pro II
asked in Other Developer Topics
ParentAccount table in Account Details Inquiry

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.

1
H
Semi-Pro II
8 months ago
E
Jr Varsity III
edwardmcgovern53Jr Varsity III
asked in Other Developer Topics
Have a Process Screen, Its data source is a projection view that displays fine but when I click on select, the row blanks out

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

15
M
Varsity I
7 months ago
C
Freshman I
ccarverFreshman I
asked in Other Developer Topics
Internal Server Error Returned on Push Notification

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

7
C
Freshman I
9 months ago
M
Freshman I
mostafaahmed83Freshman I
asked in Other Developer Topics
Reduce the database size

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

3
Manikanta Dhulipudi
Captain II
9 months ago
jedmunds36
Jr Varsity III
jedmunds36Jr Varsity III
asked in Other Developer Topics
Improved Trace window is empty when run locally (unlicensed) in Acumatica ERP 23R1

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. 

9
jedmunds36
Jr Varsity III
8 months ago
M
Varsity I
mjgrice32Varsity I
asked in Other Developer Topics
Need Help with a CreateSrvOrdDocument Delegate

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;

3
M
Varsity I
9 months ago
M
Varsity I
mjgrice32Varsity I
asked in Other Developer Topics
Cannot Publish Customization Because of Customization No longer Present???

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'

3
M
Varsity I
9 months ago
S
Freshman II
swartzfegerFreshman II
asked in Other Developer Topics
Import scenario deleting field info and not updateing

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? 

2
S
Freshman II
9 months ago
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Other Developer Topics
Getting a reference to the Actions on a Wrapper in TestSDK using a generic method

@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

3
Joe Schmucker
Captain II
9 months ago
D
Freshman II
Dantheman88988Freshman II
asked in Other Developer Topics
Inventory Quantities

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!! 

4
Robert Sternberg
Captain II
9 months ago
D
Freshman II
davidgFreshman II
asked in Other Developer Topics
How to cancel prepaid order

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? 

1
vardan22
Jr Varsity II
9 months ago
M
Freshman I
MauricioMtzFreshman I
asked in Other Developer Topics
Enter the Warehouses screen and the datafield is filled automatically

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

3
darylbowman
Captain II
9 months ago
M
Varsity I
mjgrice32Varsity I
asked in Other Developer Topics
Need Help Overriding PXAction in Service Order to Create Appointment

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

5
M
Varsity I
9 months ago
P
Freshman I
philipkantewa56Freshman I
asked in Other Developer Topics
linking data fields on different pages

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

15
P
Freshman I
8 months ago
J
Jr Varsity III
jwestermann17Jr Varsity III
asked in Other Developer Topics
Missing Characters in PDFs with Custom Font on Windows Server 2016 and Acumatica/Haufe X360

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.

4
J
Jr Varsity III
9 months ago
M
Varsity I
mjgrice32Varsity I
asked in Other Developer Topics
Why is Create Service Order Grayed Out?

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! 

6
M
Varsity I
9 months ago
W
Freshman II
wanizaidi27Freshman II
asked in Other Developer Topics
How to pull Customized DAC field from SQL View in Notification Template, 'To' field

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 

0
W
Freshman II
10 months ago

Badge winners

Show all badges
Terms & ConditionsCookie settings