Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
public PXFilteredProcessingJoin<TSFixedDemand, TSProductionOrdersCreateFilter, InnerJoin<InventoryItem, On<InventoryItem.inventoryID, Equal<TSFixedDemand.inventoryID>>, LeftJoin<SOOrder, On<SOOrder.noteID, Equal<TSFixedDemand.refNoteID>>, LeftJoin<SOLineSplit, On<SOLineSplit.planID, Equal<TSFixedDemand.planID>>, LeftJoin<SOLine, On<SOLine.orderType, Equal<SOLineSplit.orderType>, And<SOLine.orderNbr, Equal<SOLineSplit.orderNbr>, And<SOLine.lineNbr, Equal<SOLineSplit.lineNbr>>>>, LeftJoin<INItemClass, On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>, LeftJoin<SOOrderType, On<SOOrderType.orderType, Equal<SOOrder.orderType>>, LeftJoin<TSProdFormulaMTranSplit, On<TSProdFormulaMTranSplit.planID, Equal<TSFixedDemand.planID>> , LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TS
var openSalesOrders = SelectFrom<SOLine> .InnerJoin<SOOrder>.On<SOLine.orderNbr.IsEqual<SOOrder.orderNbr> .And<SOOrder.orderType.IsEqual<SOLine.orderType>>> .InnerJoin<InventoryItem>.On<SOLine.inventoryID.IsEqual<InventoryItem.inventoryID>> .InnerJoin<INItemClass>.On<InventoryItem.itemClassID.IsEqual<INItemClass.itemClassID>> .Where<INItemClass.itemClassCD.IsEqual<@P.AsString> .And<SOLine.openQty.IsGreater<Zero>> .And<SOLine.operation.IsEqual<@P.AsString>>> .View.Select(this, "811", "I");Is there a way to add a GroupBy to the above query to group and sum all sales order lines by Month & Year?Coming from Python and Django in particular, something similar to Trunc is what I am looking to do.Does BQL offer anything similar?
When I create a generic inquiry, I am able to modify the order of columns in that inquiry. Is this information stored in the database? Thank You,Abhijit
Hi All,I need to add a condition to release from hold to unhold event. Based on the condition need to block transferring to unhold status.Can someone help me to achieve this?ThanksBhagya
Hello All,I am trying to retrieve data using OData V4 but I get the error in the subject line. Everything is on my local machine and works with OData V3. Any help is appreciated why does V3 work but not V4?
Hi Team,I have upgraded my REST API code from 2022R1 to 2023 R2. As per latest RESTSharp DLL I have modified the code and able to compile. but I’m not getting response for my Asynchronous GET Method.Below is the code and Error message for your reference. Please help me to rectify this issue.Error Message: Object Reference Error. Regards,Ramya Krishna
The Sales Quotes screen has an option to ‘Convert To Order’. This option pops up the screen below and when you click Create And Review, the system creates a sales order based on the sales quote and uses ‘throw new PXRedirectRequiredException(docgraph, "");’ to direct the user to the sales order screen.Below is the sales orders screen, the important point is that the sales order has not been saved to the database at this point. The user has to click save to persist the info to the database.At the point of saving the sales order I want to create a purchase order (I won’t explain why). It’s important that the purchase order isn’t created unless the sales order is saved. I was going to create a POOrderEntry graph in the RowPersisting event but this results in error PX1045, as shown below. I cannot figure out where I can place my code in the SOEntry graph without the use of an event, which isn’t allowed. I wondered whether the call of PXRedirectRequiredException might provide a method I cou
Hi,Im trying to run tests for acumatica test sdk. I was able to make login into acumatica instance with code but code crashes when I try to open Sales Order screen with OpenScreen function. The issue isOpenQA.Selenium.WebDriverException: 'javascript error: window.__siteMap.Workspaces is not iterable (Session info: chrome=119.0.6045.105)'
I try complete bidding screen some can complete and some cannot compete. No error popup or in trace log. How to know log error beside trace log ?
Hi All,I’m currently using Acumatica Build 23.112.0032. We want to disable a operation id thus preventing a employee from being able to scan that operation id. Is there a way to do so?
Hi All,I have created a custom processing screen and now I need to call the processing method using the process buttons. Can some one help me out?My Processing Classpublic class HMRCVerificationProcess : PXGraph<HMRCVerificationProcess> { public PXCancel<HMRCVendorRegisterDetail> Cancel; public SelectFrom<HMRCVendorRegisterDetail>.Where<HMRCVendorRegisterDetail.excludeverification.IsEqual<False>>.ProcessingView AllVerifiedVendors; #region Overridden Properties public override bool IsDirty => false; #endregion public HMRCVerificationProcess() { AllVerifiedVendors.SetProcessCaption("Run"); AllVerifiedVendors.SetProcessAllCaption("Run All"); } }My Graph public class HMRCPeriodicVerifyMaint : PXGraph<HMRCPeriodicVerifyMaint> { public PXSave<HMRCVendorRegisterDetail> Save; public PXCancel<HMRCVendorRegisterDetail> Cancel; //Or
I have REALLY crazy one here. Our customer works with finance companies who require a separate invoice for each ITEM shipped. In their current system, they have an option to “split an invoice” into multiple invoices AFTER the invoice from the shipment is created. CRAZY.In Acumatica, assume I am selling 2 tractors on one Sales Order. The customer is having the tractors financed by a finance company, so the invoices will go to the Financier. On the Process Shipments screen, if I Prepare Invoices, it will produce one invoice per shipment. I know about the Batch checkbox you need to uncheck in the Shipments screen action “createInvoice”. That helps, but does not do what I need.They do NOT want shipments to be split. Just the invoices from the shipment.There are 3 things I can come up with to get a single invoice per ITEM on the Sales Order that has been shipped.Before the Sales Order is shipped (at the Sales Order screen where the CREATE SHIPMENT button is available), write code th
I got this error log. I try to find column in my customization but i see only oneSystem.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'UsrAccountName' in table 'dbo.Address' is specified more than once. 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 bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32
Hi Team,I added two customized fields to Branch table and created new tab in the company form (CS101500).But those two fields are read only. Can someone please help me out to enable this field.My Screen public sealed class BranchExt : PXCacheExtension<PX.Objects.GL.Branch> { public static bool IsActive() { return true; } #region UsrComUTRNo [PXDBString(20)] [PXUIField(DisplayName = "Company UTR No")] public string UsrComUTRNo { get; set; } public abstract class usrComUTRNo : PX.Data.BQL.BqlString.Field<usrComUTRNo> { } #endregion #region UsrComAORefNo [PXDBString(20)] [PXUIField(DisplayName = "Company AO Ref No")] public string UsrComAORefNo { get; set; } public abstract class usrComAORefNo : PX.Data.BQL.BqlString.Field<usrComAORefNo> { } #endregion } ThanksBhagya
Some custom field already update to database already with last customize and I just add one custom field to other customize and publish. but it go to omit one or two in other table.
Dear Team,I have created a Custom field (UsrContactPhone) on the Cases screen to display the Contact's phone number.I used FieldSelecting Event to do this. The result displayed the value of Custom field (UsrContactPhone) on the Cases screen, but I can't re-enter another value for this field (UsrContactPhone). After entering another value again, the system updates the default value of FieldSelecting Event.How can I change the value of the field after performing FieldSelecting Event or FieldUpdated Event ?Please help me with the solution !Best Regards,NNT==============protected void CRCase_UsrContactPhone_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e, PXFieldSelecting InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (CRCase)e.Row; if (row == null) { return; } Contact contact = PXSelect<Contact, Where<Contact.contactID, Equal<Required<
I’m working on UI tests using Acumatica’s Test SDK which wraps around selenium. There are a number of things that I would like to do which the Test SDK does not seem to provide functionality for. My question is, can I use vanilla Selenium alongside the Test SDK and if so how? Specifically I’m wondering how/if I could go about connecting to the same WebDriver(which to my understanding is how Selenium sends commands to the browser). When I try creating a new WebDriver and using that it ends up creating a new browser window which is not what I’m wanting. Other info Browser : ChromeOS : Windows 10Acumatica Version : 23r2 Here is the sample code I used to create a new WebDriver but like I said it opens in a new window not the window that is already open. var driver = new ChromeDriver("C:\\Projects\\TestSDK_23_105_0016_17\\Chrome");
When use PXNonInstantiatedExtension. How to use it ?
My customer would like to add the State field to the Vendor Selector form on the AP BIlls and Adjustments form.I have followed this article https://www.info-sourcing.com/how-to-add-fields-to-acumatica-selector-lookup-no-coding/ but it is not adding the column.Has anyone had any success adding a column to the vendor selector window?
Hello all,I need to write some codes in “Page_Load”. I have done the coding and it works flawless on browser. But, when I call the same method that results in Page_Load from the “Mobile App”, the Page_Load does not evalue the variables correctly or returns an unexpected value. here is the partial code: public partial class Page_HC509090 : PX.Web.UI.PXPage{ protected void Page_Load(object sender, EventArgs e) { AccessInfo accessInfo = (AccessInfo)this.ds.DataGraph.Caches[typeof(AccessInfo)].Current; int? contactID = PXAccess.GetContactID().GetValueOrDefault(); Guid? userID = CommonServiceLocator.ServiceLocator.Current.GetInstance<ICurrentUserInformationProvider>().GetUserIdOrDefault(); MyDAC myDAC = (MyDAC)this.ds.DataGraph.Caches[typeof(MyDAC)].Current; // Do stuff {}To add a little more context, when from screen A an action button is pressed by a user, some suff happens then using “PXRedirectHelper.TryRedirect()” platform directs the u
Hello all,Does anyone have any idea why I am getting null exception (Subject Line error)? if (fixedDemand != null && Base.FixedDemand != null && Base.FixedDemand.Any()){ PXResult<POFixedDemand> matchingDemand = Base.FixedDemand.Select() .Where(r => r.Record.RefNoteID == fixedDemand.RefNoteID && r.Record.FixedSource == fixedDemand.FixedSource && r.Record.SiteID == fixedDemand.SiteID && r.Record.PlanType == fixedDemand.PlanType && r.Record.PlanID == fixedDemand.PlanID && r.Record.RecordID == fixedDemand.RecordID) .FirstOrDefault();}
I’m creating SDK tests and I need to select the row by column name and value. However, it throws error “Element is not interactable” when I use this: users.UserRoles.SelectRow("Role Name", "Anonymous"); or this:users.UserRoles.SelectRow(users.UserRoles.Columns.Rolename, "Anonymous");It only works with index: users.UserRoles.SelectRow(10);Could someone please help me out?
I have a screen with an masterview and some virtual DACs which are filled by data got from API requests. Now i need to be informed of the change of the masterviews current record to refresh the virtual DACs. Is there an event i can use for this purpose?
Hello, I want to run some code when the ‘Line Details’ button is clicked on Purchase Receipts. Overriding the appropriate method seems like the way to go but I’m struggling to get the code to work. This is a screen shot with the button hightlightedThe button calls a method called ShowSplits, this displays a SmartPanel. I want to do something when the SmartPanel closes. Unfortunately this method is in an extension (POReceiptLineSplittingExtension) so I’ve tried to define the extensions in the class definition for my extension. My code looks like thispublic class POReceiptLineSplittingExtension_Extension : PXGraphExtension<POReceiptLineSplittingExtension, LineSplittingExtension<POReceiptEntry, POReceipt, POReceiptLine, POReceiptLineSplit>, POReceiptEntry>{ public delegate IEnumerable ShowSplitsDelegate(PXAdapter adapter); [PXOverride] public IEnumerable ShowSplits(PXAdapter adapter, ShowSplitsDelegate baseMethod) { var ret = baseMethod(adapter); //Do Something return ret;
Hi Team,I'm trying override the "Release" action on "Sales Price Worksheets" Screen, since i need to insert the newly customized field value on "Sales Price" screen. Usually i execute the base method and then insert the values. but here the main problem is i couldn't find any relationship between "ARPriceWorksheetDetail" and "ARSalesPrice"Please let me know how i can handle this situation. Regards,Ramya Krishna
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.