Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi, I am using Acumatica 25R1enabled with SSO, so SharePoint user can able to login in Acumatica by click on ‘Active directory‘ on login screen and put their SSO credential. I am trying from my Acumatica Instance to call Graph API to get data from SharePoint of login user but not find any way to do.In the this code I can get the loin user name, but I am not able to get the access token of graph API to get data, please check this code and help me what I am missing var httpContext = HttpContext.Current;if(httpContext != null && httpContext.User.Identity.IsAuthenticated) {ClaimsPrincipal user = httpContext.User as ClaimsPrincipal;var accessTokenClaim = user?.FindFirst("access_token"); // Ensure this claim exists if(accessTokenClaim != null) { return accessTokenClaim.Value; // Return the access token if it exists }} Regards,Abhishek
I want to use a selector in my grid that provides me with only with Customers , Vendors , Business Accounts , Contacts similar to Relations Tab in Business Account the problem is the EntityIDSelector which takes type of DAC like PX.objects.CR.BAccount , PX.objects.CR.Contact, PX.objects , PX.Objects.AR.Customer , PX.Objects.AP.Vendor i have noticed that when i start by selecting Business Account in the first place the selector works without changing the table fileds name in the selector view but if i start with a different type ex:Customer,vendor i get this Error “undefined: Cannot read properties of undefined (reading 'getAttribute')”Note: i have commit changes for the feilds
The title says it all.I want to show a button only if Modern UI is being used.
I noticed there is different in the two environment and on their website I am only able to download 25.101.0153 and not the 25.101.0153.1 version which is causing issue in one of our customization.Anyone has any update about it? Our production/live environment Our Testing environment
Hello. When I create a sales order with code it is different to the sales order I create via the UI.The order type and customer are the same so I don’t understand when the final order is different.The sales order below has been created with the UI. I only set the Customer and Customer Order Ref fields. Notice that the Contact field has been set to ‘Book In’ automatically. To create a sales order using code, I’ve used the following code.SOOrderEntry sOOrderEntry = PXGraph.CreateInstance<SOOrderEntry>();SOOrder sOOrder = (SOOrder)sOOrderEntry.Document.Cache.CreateInstance();sOOrderEntry.Document.Cache.SetValueExt<SOOrder.orderType>(sOOrder, "SA");sOOrderEntry.Document.Cache.SetValueExt<SOOrder.customerID>(sOOrder, 7511);sOOrderEntry.Document.Cache.SetValueExt<SOOrder.customerOrderNbr>(sOOrder, "Test Order");sOOrder = sOOrderEntry.Document.Insert(sOOrder);sOOrderEntry.Actions.PressSave();The sales order created is shown below. The Contact field is empty! Can anyo
Use Case: I needed to show line-level markup % on Sales Orders based on Unit Price and Unit Cost. Here's how I added the field and got it working smoothly in SO301000 (Sales Orders). Step 1: Create DAC Extensions1.1: SOLineExtMarkup (Line Level) namespace PX.Objects.SO{ public class SOLineExtMarkup : PXCacheExtension<SOLine> { #region UsrMarkupPct [PXDecimal(2)] [PXUIField(DisplayName = "Markup %", Enabled = false)] [PXFormula(typeof(Switch< Case<Where<SOLine.curyUnitCost, NotEqual<decimal0>>, Multiply<Divide<Minus<SOLine.curyUnitPrice, SOLine.curyUnitCost>, SOLine.curyUnitCost>, decimal100>>, decimal0>))] public virtual decimal? UsrMarkupPct { get; set; } public abstract class usrMarkupPct : PX.Data.BQL.BqlDecimal.Field<usrMarkupPct> { } #endregion }} 1.2: SOOrderExtMarkup (Header Level) namespace PX.Objects.SO{ public class SOOrderExt
Hello All,I have a scenario where I created a new tab called “MyOrder” on the Sales Order screen (SO301000) using a Customization Project. Inside this tab, I have a grid bound to a custom table (MyOrder) that has a foreign key relationship with SOOrder (OrderType and OrderNbr).The grid correctly shows the data after I insert records inside the RowPersisted event of SOOrderEntry. The data comes from an API call (currently hardcoded for testing). Here is a simplified version of my code:public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry> { public PXSelect<MyOrder, Where<MyOrder.ordertype, Equal<Current<SOOrder.orderType>>, And<MyOrder.orderNr, Equal<Current<SOOrder.orderNbr>>>>> MYOrder; protected void _(Events.RowPersisted<SOOrder> e) { SOOrder row = (SOOrder)e.Row; if (row == null) return;
We just really started using the location tracking map in Services and noticed that sometimes location information would stop transmitting. After digging into our setup on our Android devices we have found that the Location Permissions are only Allowed only while using the app” instead of “Allowed All the Time”. The “Allowed All the Time” is not an option. There is no we we have found to allow all the time and our technicians don’t necessarily keep the app open on our devices. Can the Mobile app be updated to allow All the time Permissions?
I am dynamically creating grid columns on a Modern UI grid. This works great.What is not working great is that the dynamic columns seem to vanish when the grid ‘refresh’ button is used or the grid paging is used.Does anyone know how to prevent this?TypeScript:@gridConfig({ adjustPageSize: true, exportRowsLimit: 5000, fastFilterByAllFields: true, generateColumns: GridColumnGeneration.AppendDynamic, //generateColumnsAfterSelect: true, pagerMode: GridPagerMode.Numeric, preset: GridPreset.Inquiry, preventInitialFocus: true, repaintColumns: true, //statusField: "Availability", suppressAutoHide: true,})export class DXDynamicResult extends PXView { @columnConfig({ width: 70, textAlign: TextAlign.Left }) DXResultNbr : PXFieldState;} tagging @vanit05 because of this post
I have added two unbound custom fields to the List Members grid of the Marketing Lists screen.These fields are coming from two Attributes on the Contact.They display correctly which is a good start. However, if I try to sort by Department for instance, it sorts the current list of items in the grid, not all records in the grid.If I try to filter the Department column by “SALES”, it shows one record for SALES. I believe it is grabbing just one record from what is being displayed in the grid, not all records in the grid.I suspect this might be due to the fact that I have unbound fields added to the grid’s DAC.It is not an option to add these two fields to the table. This would not be a viable solution.I overrode a method to get these values from the contact attributes for each record.Here is my method to get those unbound fields.[PXProtectedAccess]public virtual IEnumerable listMembers(){ if (Base.MailLists.Current is null) yield break; PXCache myCache = Base.Caches<Contact>();
I am trying to add this field to the inventory lookup in SO.Line PX.Objects.IN.InventoryItem.usrSeattleItemNbr However, when I add the column the attribute adds the following path...note the EXT.typeof(PX.Objects.IN.InventoryItemExt.usrSeattleItemNbr) There is no InventoryItemExtSelector column in SO Details does not show my added fieldsIf I edit the attribute to InventoryItem.usrSeattleItemNbr it fails validation. Any ideas to troubleshoot would be appreciated...thanks.
Hi All, We are getting this error after recently upgrading our site to 2023R1.This is happening when an Incoming email is processed by a Schedule job also when we manually try to process the email getting the same error. This was working fine in the previous version.
I am looking into converting some custom pages to modern UI. The underlying DAC of these pages frequently uses DescriptionField derived from PXEnityAttribute to modify how an attribute is displayed in a grid. For example: [CustomerActive(Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName), Filterable = true, IsKey = false)]The underlying attribute is an int for the customer ID, but rather than displaying that int it displays the string Customer.acctName to the end user.This works fine in classic UI, but when pages are converted to .html files and .ts for modern UI, the conversion process doesn’t seem to respect the presence of description fields. The selection process works fine, but the final thing displayed is the non-descriptive int.How do I need to amend the html or ts to give it a hint regarding the presence of the DscriptionField on the DAC property?
Acumatica customization gurus, is it possible to reference the UserPreferences.DefaultSite field in an event? Code snippet is below, but I’m receiving the error ‘UserPreferences’ does not include a definition for ‘DefaultSite’. The field does exist in the SQL table in my local test environment. Thanks in advance! var line = e.Row; var currentUserID = PXAccess.GetUserID(); UserPreferences prefs = PXSelect<UserPreferences, Where<UserPreferences.userID, Equal<Required<UserPreferences.userID>>>> .Select(Base, currentUserID); if (prefs?.DefaultSite != null) { line.SiteID = prefs.DefaultSite; }
We are trying to Extended INRelatedInventory DAC Fields in the Releated Items Tab Grid section classic to Modern UI .DAC has 2 extended fields need to display it in the modern UI classic UI screen shot Tried with below code, but unable to see fields in Modern UI import { PXFieldState, PXFieldOptions, columnConfig } from "client-controls";import { IN202500 } from "../IN202500";import { ReleatedItemsTabBase } from "../../common/related-items/tab-related-items/tab-related-items";export interface RelatedItems_customfields extends IN202500, ReleatedItemsTabBase { }export class RelatedItems_customfields extends ReleatedItemsTabBase { @columnConfig({ width: 100 }) UsrNAWSurchargeSO: PXFieldState; @columnConfig({ width: 100 }) UsrNAWSurchargePO: PXFieldState;}
Hi, I have two local instances of 2022.217.202.5321 hosted on the same PC which have two different customisations. On one of these instances the debugger behaves perfectly, on the other it doesn’t. On the one that doesn’t behave I was getting lots of missing symbols/can’t load Nlog.pdb, etc. messages. After doing some research on symbols, I ended up changing the paths in the yellow box below in Visual Studio from tools Options/debugging/symbols. On the instance which is having the problems I currently have:C:\Users\John\Wrk\Helm\MYOB Versions\MYOB.Advanced-2022.217.202.5231\Files\Bin C:\Users\John\Wrk\Helm\MYOB Versions\MYOB.Advanced-2022.217.202.5231\Schick_20230929\BinI set these to make the unable to load symbols messages I was getting go away. Have never had to mess with these before and I’m not 100% sure that I am doing the right thing here - but id did resolve the missing symbol problems. On the instance which works fine I have:c:\users\john\wrk\helm\natt C:\Users\John\Wrk\Hel
This is a follow up to a previous blog post I made - Here, I added a set Delivered action to the SO Quick Process that adds it into the middle of the SOShipment workflow. Today, I will go into more detail on how I was able to change the workflow, completely from the Extension Library.The use case is that we want orders to be delivered before they are invoiced. We set them as confirmed when picked, and they may sit and wait for the delivery date, or longer, depending on the local delivery route. We added an action to ensure that it is delivered before invoicing. This action may be pressed on each shipment directly, or triggered from another screen in our custom delivery application.To accomplish this, we need to override some of the existing workflow, as well as adding a custom event handler.The first step, is adding our Custom event handler to a graph extension on the SOShipment table. public class SOShipmentExt : PXCacheExtension<PX.Objects.SO.SOShipment> {
I have a grid that looks like this:When I click + to add a new line item, I want to default the value in the Greater Than field to the Less Than value in the previous line.I can get it to work, but no matter which event handler I use, it only will do the update to the field AFTER I leave the line.Enter 6000 in the less than field Tab out of the line and the 5000 gets populated.I am using the FieldDefaulting handler to get the previous line and update the newvalue for the row being defaulted.NOTE...this code WORKS, but it only fires AFTER you leave the line. When the current row has a SortOrder of zero, this tells me that this is a new row and to get the previous row. protected void ICSPricingMatrix_FromPrice_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (ICSPricingMatrix)e.Row; if (row == null) return; if (row.SortOrder == 0) { ICSPricingMatrix prevItem = SelectFrom<ICSPricingMatrix> .Where<ICSPricingMatrix.priceClassID.IsEqual<@
I’m creating a vendor compliance workflow based on the Vendors (AP303000). However, I’m stuck with adding a conditional field (IsExpired) that’s related to the compliance documents on the Compliance tab of the Vendors screen. Please see the screenshots below..I need to add the ‘IsExpired’ field (found on the vendors screen - compliance tab) to the list of fields displayed. The yellow highlighted field (Expired) on the Compliance tab of the Vendors screen is what I need my condition to be based on. Please help to provide the steps needed to achieve this requirement.Thanks!
We’re getting this error when clicking on the shipments tab of SOOrderEntry. This is an upgraded system, coming from 24R2, upgrading to 25.101.0153.Through the project editor we have added a state to SOShipment. We have a workflow that takes the new state into account. It’s been working in 24R2 from the beginning.Edit: In 24R2, the shipments tab does not display the correct status value, it’s showing the database value, not the text for that value:When I check the trace, the last line is: at PX.Objects.SO.GraphExtensions.SOOrderEntryExt.Status.GetValue(SOOrderShipment row)This error only appears if the order has shipments that have a Status value equal to the new status that we added.If I put the shipment on hold/off hold to change the status to Open, I can view the shipment on the Sales Order Entry’s shipments tab.I have unpublished all customizations and the error persists. This suggests to me that the issue is within the workflow somewhere but I have no way to debug it (that I know
Hi team, Is it possible to customize file dialog to add new column. Thanks,Arun.
Hi,I need to develop new screen same as the existing standard sales order form.I’m checking the training videos and references in the acumatica openuni.But,I have some kind of problems when checking the videos.What is the best method to develop the project. ? Download and install acumatica ERP and develop project using visual builder and then deploy the project. My client already have an acumatica ERP hosted in cloud, Can I develop new screen using Customization Project Editor?I’m waiting for your answers.Thank you
We would like to add an additional Toolbar option “Printing and Emailing” to Screen ID PO302000.Created a new Customization and can see “Printing and Emailing” in the Form-Specific tree.How can I add another action here to point to and print a different report?
I have a requirement to add an “Item Condition” field to the INItemLotSerial record. We need this because we offer Rent-To-Own contracts on our portable buildings. When the customer returns a building rather than completing the contract to ownership, we create a return order to ship it back and receive it back into our inventory as a “Used” building. Since all buildings are manufactured by us, all new records should have the “New” condition. I’ve added the below field to a DAC extension of INItemLotSerial, using the PXDefault attribute to set the value to “New” for new lot serial records. The SWItemCondition.List attribute is a custom string list attribute to provide options for “New” and “Used” conditions. Now; this value is only changed to used when a return shipment is completed for this item. I update it using the following code. This “SetItemCondition()” method is called in an override of the “SOShipmentEntry.updateIN()” method, for return shipments only. This all works, and if I
Is there any documentation on how to setup the dev environment for the Modern UI?The only thing I can find is the PDF of the slides from Andrew Bulanov’s DevCon 2023 presentation.- Install Node.js of the version 16.14 or higher- Open a command prompt window, change the directory to FrontendSources folder of the site- Execute npm run getmodules- Execute npm run build-devI installed the latest version of Node.js from the Node.js web site.I executed the getmodules command.I also ran this command to make sure typescript was installed: npm install -g typescriptWhen I run the last command I get a lot of errors. Maybe these can be ignored?Using Node and Typescript is new to me and I was hoping there was a cheat sheet from Acumatica on how to get started.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.