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 Everyone I am reaching out to seek guidance and assistance with modifying workflow state descriptions within our Acumatica ERP system. We are currently looking to enhance the clarity of our Sales Order processing workflow by updating the descriptions of certain workflow states to better align with our operational processes. Current Configuration:We have a state named "Completed" which we would like to rename to "Invoice Pending".Additionally, we have a custom state originally named "Invoice Released" that we need to change to "Completed". Objective:Our objective is to make these state descriptions more intuitive and reflective of their actual functions in our business process. This change is intended to improve user understanding and interaction with the system. Challenges Faced:We understand that modifying state descriptions might not be straightforward through the Workflow Editor or UI, and are concerned about the potential impacts on system integrity and future updates. Direct d
Hi all, I have a selector in SOLine grid as follows.#region UsrProductionNbr [PXDBString(15)] [PXUIField(DisplayName = "Production Nbr")] [PXSelector( typeof(Search<AMProdItem.prodOrdID, Where<AMProdItem.inventoryID, Equal<Current<SOLine.inventoryID>>>>), typeof(AMProdItem.orderType), typeof(AMProdItem.prodOrdID))] public virtual string UsrProductionNbr { get; set; } public abstract class usrProductionNbr : PX.Data.BQL.BqlString.Field<usrProductionNbr> { }#endregion I have another field for production order type in the same grid as follows. #region UsrProdOrdType [PXDBString(5)] [PXUIField(DisplayName = "Prod. Order Type", Enabled = false)] public virtual string UsrProdOrdType { get; set; } public abstract class usrProdOrdType : PX.Data.BQL.BqlString.Field<usrProdOrdType> { } #endregion I want to set the UsrProdOrdType value based on se
Hi,Nice to meet you all. Long time reader first time poster.In 2022R1, I am trying to publish a customisation that includes an extension to the SOOrderEntry graph. I am having problems though because an existing customisation that also includes an extension to the same graph is already published. The first time I tried this, the whole application crashed because my extension was the only one published, and the other customisation had other code that tried to obtain a reference to its extension using CreateInstance<SOOrderEntry>.GetExtension<”extension name”>().I tried to replicate this error in a local instance also running 2022R1, but it didn’t happen, and browsing my filesystem provides a clue as to why. In the <Appfolder>\App_Code\Caches folder, my extension is contained in a file named ‘SOOrderEntry.cs’. The other extension is contained in a file named ‘<Package name>.SOOrderEntry.cs’, where <Package name> is the name of the .NET package it exists in.
This question is an extension of this one.I have changed the second script to be as follows:<script>var map;async function initMap() { const center = { lat: 40.75, lng: -77 }; const { Map } = await google.maps.importLibrary("maps"); const { AdvancedMarkerElement } = await google.maps.importLibrary("marker"); const { Geocoder } = await google.maps.importLibrary("geocoding"); /* the map */ map = new Map(document.getElementById("map"), { zoom: 7.8, center: center, mapId: "DEMO_MAP_ID", }); /* get addresses from Acumatica field */ /*var addressesToPlot = px_alls["cstAddressesToPlot"].getValue();*/ var addressesToPlot = "Robisonia, PA; Mechanicsburg, PA; Philadelphia, PA"; var addresses = addressesToPlot.split(';'); /* encode addresses as lat/lng */ const geocoder = new Geocoder(); for (var i=0; i<addresses.length; i++) { geocoder.geocode({ 'address': addresses[i] }, (results, status) => { if (status == google.maps.GeocoderStatus.OK) { const marker = new AdvancedMarker
We get this Error when opening up Customization Projects that have been upgraded to 24R1.They published without Error, it’s really just when Opening them. Any idea as to what is going on?
I have been trying to learn and get this to work, but I haven’t had any luck. I am trying to add the AddressLine1 field to the location selector on the opportunities screen. I have done some digging and have come across this, but all it spit out was the LocationID and Description with bad looking column headings, the same as what happened here. I tried his fix of moving it to a visual studio project and that didn’t work for me either, I had the same outcome. I also tried using this method, changing from contact to address. It seems to work (I can see the AddressLine1), but I can see every single one in the system, not just the ones related to the BAccount I have selected on the opportunity. If someone could give me a hand, that would be great, I’m still new to coding. Here is the code I am using currently.[PXSelector(typeof(SearchFor<Location.locationCD>.In<SelectFrom<Location>.InnerJoin <Address>.On<Location.defAddressID.IsEqual<Address.addressID>>&
I have a customization that was written originally for Acumatica 2021 R2 (Build 21.218.0027) and it runs fine there.It adds an action button to the opportunities screen (CR304000) (See screenshots below)The purpose of this button is to have the tech in the field be able to press it to call out to a web based forms system we have developed. So, I have code in the customization to make it visible on the mobile app: update screen CR304000 { update container "OpportunitySummary" { add recordAction "ASGExtForms" { behavior = void redirect = True } }This works fine in Acumatica 2021 R2, Build 21.218.0027.However, it will not work in Acumatica 2022 R2, Build 22.223.0007Everything compiles fine, but the button will not show in the Mobile app. Weirdly, I have almost identical code for the Appointments screen (FS300200), and the action shows there.Does anyone have any idea what changed, and how I have to change the mobile app code (I am assuming) to
I have extend stock item screen in my customization, I have added two new tabs....now I have convert it to modern ui by convert to modern ui built in convertor.Once Screen converted modern UI ...I have not seen my customized changes. newly added tabs are not showing.
Good Day,In the screen of Checks and Payments, I need the lines of the grid filtered by Branch, when I select a vendor and add a new line I am filtering the options in the reference Nbr selector by the Branch/Company the user is logged on, but I also need to have the records filtered when I press the tab button "LOAD DOCUMENTS”When I debugg the code, the foreach goes through the lines I need, but when I stop debugging it inserts every document from any Branch, not sure if it is because I am returning the baseMethod but I would appreciate assistance or some ideas on how I could insert only the records filtered. public class APPaymentEntry_Extension : PXGraphExtension<PX.Objects.AP.APPaymentEntry> { #region Event Handlers public delegate IEnumerable LoadInvoicesDelegate(PXAdapter adapter); [PXOverride] public virtual IEnumerable LoadInvoices(PXAdapter adapter, LoadInvoicesDelegate baseMethod) { PXSelectBase<APInvoice> invoiceQu
I am trying to do some work on the Pick, Pack and Ship screen (SO302020).When I add the screen to my project and select the FieldUpdating Event to add code to, I get this:sing System;using System.Linq;using System.Collections;using System.Collections.Generic;using System.Threading;using PX.SM;using PX.Common;using PX.BarcodeProcessing;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.Common;using PX.Objects.Common.Extensions;using PX.Objects.Extensions;using PX.Objects.AR;using PX.Objects.CS;using PX.Objects.IN;using PX.Objects.IN.WMS;using WMSBase = WarehouseManagementSystem<PickPackShip, PickPackShip.Host>;using PX.Objects;using PX.Objects.SO.WMS;namespace PX.Objects.SO.WMS{ public class PickPackShip+Host_Extension : PXGraphExtension<PX.Objects.SO.WMS.PickPackShip+Host> { public static bool IsActive() => true; #region Event Handlers protected void ScanHeader_PackageLineNbrUI_FieldUpdating(PXCache cache, PXFieldUpdatingEventArgs e) { var ro
Here is my scenario.I have a table that has a range of zip codes. If the left 3 characters of the Ship Address zip code fall in the range of “lower” and “higher” I want to select that record.Example:Ship Address Zip is 100234.In my lookup table, the lower is 100 and the upper is 130.So the left 3 digits of the zip (100) falls in the range.In my BQL statement, I do not see a way to do an IsGreaterEqual using the string value. It causes errors.This is what I want to do:ICSFSSScheduleLine item = SelectFrom<ICSFSSScheduleLine> .InnerJoin<ICSFSSSchedule> .On<ICSFSSSchedule.scheduleID.IsEqual<ICSFSSScheduleLine.scheduleID>> .Where<ICSFSSScheduleLine.scheduleID.IsEqual<@P.AsString> .And<ICSFSSScheduleLine.lower.IsGreaterEqual<@P.AsString>> .And<ICSFSSScheduleLine.upper.IsLessEqual<@P.AsString>> .And<ICSFSSSchedule.active.IsEqual<True>>> .OrderBy<Asc<ICSFSSScheduleLine.lower>, Asc<ICS
((BusinessAccountGraphBase<Customer, Customer, Where<PX.Objects.CR.BAccount.type, Equal<BAccountType.customerType>, Or<PX.Objects.CR.BAccount.type, Equal<BAccountType.combinedType>>>>) graph).BAccount.Insert(m); BusinessAccountGraphBase is missing and so how to find code that equal above
Is there any utility that will let me test BQL against an acumatica instance? I am thinking something along the lines of LINQPAD.
Need assistance in passing data saved on a custom screen to a vendors screen cache to allow user to edit before saving. Current I m able to pass just the AcctCD data which gets passed through the url paramshow do I pass the address details to the screen’s cache public PXSelect<PHKyc> KycMain; public PXSelect<PHKycBusiness, Where<PHKycBusiness.kycNbr, Equal<Current<PHKyc.kycNbr>>>> KycBusiness;public PXAction<PHKyc> extendToVendor;[PXUIField(DisplayName = "Extend to Vendor", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)][PXButton]public virtual IEnumerable ExtendToVendor(PXAdapter adapter){ PHKyc current = KycMain.Current; PHKycBusiness business = KycBusiness.SelectSingle(); PX.Objects.CR.BAccount bAccount = new BAccount { AcctCD = current.KycNbr, AcctName = business.BusinessName, Type = BAccountType.VendorType, AllowOverrideRate = false, CuryRateTypeID = "SPOT", All
Hi Community, I have an issue with a client where we are installing paperless functionality to their warehouse.The Inventory Manager moves dead stock to different locations within the warehouse to make room for items that sell better. They keep this information on paper. The issue we found while testing is that when you move stock between locations it is also removed from the deadstock calculation. This can lead to inaccuracies in identifying true dead stock items.We looking to add a setting in Inventory Preferences, when selected, remove IN Transfers from the calculation.Has anyone done something similar before?
Hi group,When cursor reaches the last editable cell, it creates a new rowDo you know if it's possible to prevent adding new row automaticly at the end of a row (when pressing enter) in grids of acumatica? People have "Insert" right(not delete), they can Cancel the row after an unvolontary inserting but it's little bit anoying Thanks =)
Hello, We have a customer that is requesting an approval process on the Vendor screen- specifically on banking information. Has anyone come up with anything, or have any ideas on how this can be done?Thanks, Kathleen
Hello Community,i have been wondering if we can mark the Document or Line-level Notes as required? if yes then how? Can we achieve it via low-code/No-code customization? Thanks in advance.
The below custom code is not working in SOOrderEntry graph extension when I upgraded my customization to 24R1 version, though the same code is working fine in SOInvoiceEntry graph extension in save versionI am trying to add action menu item. public override void Initialize(){ base.Initialize(); this.Base.action.AddMenuAction(recalculateCPPriceAction); }Below is the error and screenshotBelow is my SOOrderEntry graph extension structure Can anyone help me out with this issue, I am confused about its working in anothe graph extension(SOInvoiceEntry) but not working in SOOrdrEntry graph extension in the same project. Thanks and RegardsSD
We’re using MRP for production. We don’t include On Hold sales orders in the calculation. But now we have a change in requirements so that we want to include orders in the Awaiting For Payment status - which has the order being on hold.The idea is that we want to prepare for the order to be placed but we don’t want to ship it until we’ve received a prepayment. But we do want to be able to plan our production around this order.So I figured there are two ways to tackle this:Via customized workflow. I create a custom field to indicate that we’re waiting on a payment for this order. That field will impact the visibility to the Create Shipment button. So the order will be officially “open” and thus included in MRP but, from the user’s standpoint, they cannot ship the order until a prepayment has been applied to the order. Adjust the MRP calculation to include this sub-set of orders similar to how Blanket Orders are added to the MRP calc. The concern is that MRP is a complicated set of calcu
Hi, I’m trying to override a method in a graph extension, then override it again in a second extension. I’ve simplified the code to provide an example.public class SOShipmentEntryWrite : PXGraphExtension<PX.Objects.SO.SOShipmentEntry>{ [PXOverride] public void ConfirmShipment(SOOrderEntry docgraph, SOShipment shipment) { Base.ConfirmShipment(docgraph, shipment); //Write some info }}public class SOShipmentEntryRead : PXGraphExtension<PX.Objects.SO.SOShipmentEntryWrite, PX.Objects.SO.SOShipmentEntry>{ [PXOverride] public void ConfirmShipment(SOOrderEntry docgraph, SOShipment shipment) { Base1.ConfirmShipment(docgraph, shipment); //Read the info }}There are 2 classes SOShipmentEntryWrite and SOShipmentEntryRead. SOShipmentEntryRead is an extension of SOShipmentEntryWrite.My hope was that ConfirmShipment in SOShipmentEntryRead would override ConfirmShipment in SOShipmentEntryWrite.Then I could use Base1.ConfirmShipment in SOShipmentEntryRead to call ConfirmShipm
I call WebDialogResult multiple times in a loop.However, this window is displayed only once:(My code:foreach (DateTime dateTime in dateTimeList) { WebDialogResult result = PaymentCalendar.Ask(ActionsMessages.Warning, PXMessages.LocalizeFormatNoPrefix(textMessage), MessageButtons.YesNo, MessageIcon.Warning, true); if (result != WebDialogResult.Yes) continue; } } Help me please
Hello community,I want to filter list records in Grid result by a custom field on screen Vendor Prices (APVendorPriceFilterExt.usrShippingTermID) How to override the original select statement and add condition?Source code of selects Records:[PXFilterable]public PXSelectJoin<APVendorPrice, LeftJoin<InventoryItem, On<InventoryItem.inventoryID, Equal<APVendorPrice.inventoryID>>, LeftJoin<INItemClass, On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>, LeftJoin<Vendor, On<APVendorPrice.vendorID, Equal<Vendor.bAccountID>>, LeftJoin<INSite, On<APVendorPrice.siteID, Equal<INSite.siteID>>>>>>, Where2<Where<Vendor.bAccountID, IsNull, Or<Match<Vendor, Current<AccessInfo.userName>>>>, And2<Where<InventoryItem.inventoryID, IsNull, Or<Match<InventoryItem, Current<AccessInfo.userName>>>>, And2<Where<INItemClass.itemClassID, IsNull, Or<Match<IN
Hey guys,Hope you are all well, I am working on including some of our ISO records onto Acumatica. I have created a new from for Non-Conformance entries and a substitute GI for the entry screen.However, I keep receiving the error ‘Error: Another process has updated the 'NCRLog' record. Your changes will be lost.’ The first save works fine, however any actions thereafter, e.g., save, delete, cancel, all give that error. Has anyone encountered this before?I have attached my code files here.NCRLog.csGilcrestMaint.csThanks,Aleks
I’m following the steps in the article below to add a new method onto my GIRO data provider. My data provider is called .CheckGIRO. The attached package is intended to add a running total to the file (which ultimately needs to be a line number for invoices applied to the payment). Once I was able to add the method in the package and publish, I now get the following error trying to use it on the Batch Payments screen saying the method doesn’t exist.https://asiablog.acumatica.com/2016/08/configuring-batch-payments-for-custom.html
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.