Develop Customizations

I don’t even have the Outlook plugin activated... C:\Program Files\Acumatica ERP\AcumaticaERP\FrontendSources>npm run build> build> node build-and-clean.jsexec error: Error: Command failed: gulp build[16:19:36] 'build' errored after 680 ms[16:19:36] Task finished with errors[16:19:33] Requiring external module ts-node/register[16:19:35] Using gulpfile C:\Program Files\Acumatica ERP\AcumaticaERP\FrontendSources\gulpfile.ts[16:19:35] Starting 'build'...[16:19:35] Starting 'outlookPlugin build'...[16:19:35] Starting 'screens build'...> outlook-plugin@0.1.0 build> webpack --env production> screen@0.1.0 build> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack -- --env productionnode:internal/modules/cjs/loader:1252  throw err;  ^Error: Cannot find module 'C:\Program Files\Acumatica ERP\AcumaticaERP\FrontendSources\outlook-plugin\node_modules\webpack\bin\webpack.js'    at Function._resolveFi

Hi Guys, i want the Field CountryOfOrigin in the Soorder Detail Section. i tried it with a User Defined Field , but PXFormular is not working. namespace PX.Objects.SO{  public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>  {    #region UsrUrsprungsland    [PXDBString(200)]    [PXUIField(DisplayName="Ursprungsland")]    [PXFormula(typeof(Selector<SOLine.inventoryID,InventoryItemExt.CountryOfOrigin>))]      public virtual string UsrUrsprungsland { get; set; }    public abstract class usrUrsprungsland : PX.Data.BQL.BqlString.Field<usrUrsprungsland> { }    #endregion      }}   Hope u can help me.

I have added a field called ‘Production Order No.’ which is meant to pull the production order number for the given line in Inventory Lot/ Serial History screen without having to click on reference number → go to manufacturing tab on issues screen → view production number. Field Production Order No. in Inventory Lot/ Serial History ScreenManufacturing Tab of Issues ScreenAccess Production Order NumberI have added the code however it pulls incorrect details for some inventory SKUs.namespace PX.Objects.IN{ public class InventoryLotSerInq_Extension : PXGraphExtension<PX.Objects.IN.InventoryLotSerInq> { #region Event Handlers protected virtual void INTranSplit_RowSelected(PXCache sender, PXRowSelectedEventArgs e) { if (e.Row == null) return; var row = (InventoryLotSerInq.INTranSplit)e.Row; if (string.IsNullOrEmpty(row.RefNbr) || string.IsNullOrEmpty(row.DocType)) return; PXTrace.WriteInformation($"

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 se​​​​​​t 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