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 you bunch of lovely people, I hope you’re all having a great day! I am rather new to acumatica, only been using it circa 6 months. I am adding some new fields to our business account screens and had a question. Some fields include ‘Top Architect’ - bool, and ‘Architect Sectors’ - Textedit. Is there any way of locking ‘Architect Sectors’ from being editable if ‘Top Architect’ is false? I appreciate any feedback! Many thanks in advance, Aleks
Hi All,Need to how to edit grid column value based on another column value and update the cache and enable the save button. Thanks
Hi, Need to know how to loop the PXGrid and change rows values by custom PXAction button.Can someone help me out?Thanks
Hello all, I am wondering if has anyone come across this issue that the “Upload” from Excel is disabled on Top of a details grid in a master-detail form (Below screenshot).Background:This button was hidden initially so in the page Grid Control I set the “AllowUpload” mode to true to make it visible. The user is admin and has full access. The DAC keys are verified and fine. The DAC didn’t have a PrimaryGraph so I thought it could cause the issue so using a DAC extension I added the PrimaryGraph to the DAC properties. I have checked and there is no event/method that disables the button in Acumatica source I tried to Enable the Action using RowSelected handler but I do not see this action amongst the rest of the actions. I reset Caches and restarted the application.I have no idea what else could disable the Upload action.
I need get “CSAnswer.Value” to “PORecieptLine” Using row selected. How can i achived that. This is the value I wantCSAnswer.valueI want get CSAnswer.value to Cuztomized feild. this is my code. Not give correct result.
1. IntroductionDocumenting an Acumatica customization project is beneficial to all. As anyone who has published, upgraded, or maintained a customization (i.e. a Customizer) can tell you, determining the purpose of a customization project is often difficult after it exists. Unless you are the author and can remember all its features during its lifetime of use, on the surface it can be a mystery. For example, if you look at the image in Figure 1, which was copied from the current Acumatica Customization Guide online help, do you know what the purpose of any of these customization projects are? You might have a clue, or you might not. Even if you do, are you aware of any of their features or impact, or the Acumatica release for which it was written? Answer: No. Figure 1: Customization Project List Imagine looking at these for the first time. In this example, there are no Descriptions. You should always include a short description of the project’s purpose when authoring a customiz
select ValueID from CSAttributeDetail where AttributeID = 'MFGPRPALLE';I need to get same result like above sql query. How can I get the result using PXSelector?
i have put a pxTransaction in the release button in the invoices screen .its working but it sometimes gets deadlocked by another process DeadLock Img This is the code that i think makes the problemusing (PXTransactionScope ts = new PXTransactionScope()){ PXDatabase.Update<MixPayments>(new PXDataFieldAssign<MixPayments.docType>(inv.DocType), new PXDataFieldAssign<MixPayments.refNbr>(inv.RefNbr), new PXDataFieldRestrict<MixPayments.orderNbr>(mix.OrderNbr), new PXDataFieldRestrict<MixPayments.orderType>(mix.OrderType)); ts.Complete();}is there a way to use with nolock in acumatica like SQL ?or is there another way to make this code work ?
Hi Experts,I'm facing a challenge with this customization to sort Labor Items on the Time Card Entry screen. The goal is to default an employee's department-specific labor items to the top of the list, with the remaining items following.I've written the following code for this purpose, but it doesn't seem to be sorting the items as expected. Interestingly, when I tried using an SQL query, it worked as intended.Code Snippets.using PX.Data;using PX.Objects.IN;using PX.Objects.PM;using static PX.Objects.AP.APGenerateIntercompanyBillsFilter;using static PX.Objects.CR.CRCaseClassLaborMatrix;namespace PX.Objects.EP{ [PXNonInstantiatedExtension] public class EP_TimeCardMaint_EPTimeCardSummaryWithInfo_ExistingColumn : PXCacheExtension<PX.Objects.EP.TimeCardMaint.EPTimeCardSummaryWithInfo> { #region LabourItemID [PMLaborItem(typeof(projectID), typeof(earningType), typeof(Select<EPEmployee, Where<EPEmployee.bAccountID, Equal<Current<EPTimeCard.employeeI
After publishing the project at the end of step 1.4.3 of T200 course I cannot see anymore the grids on Screen Editor RS201000. I can see the screen and add/edit data on this screen when I click Phone Repair Shop on Acuamtica main pane though. I am doing the course on Acumatica 2023.R1.
Hello All,When Acumatica’s Copy/Paste engine is running and the Graph’s IsCopyPasteContext is true how we can access the current record which is used as original record to create copy from it? In the event handlers as platform starts defaulting, inserting, … we can access the copy of the record but I don’t know how I can get the original record that drives the copied one.
I am looking into customizing SO301000 to automatically update the SOLine SalesPersonID when ever the Order Default SalesPersonID is updated. Occasionally, we will copy an order and change the customer ID. When you change the customer ID it removes the SOLine SalesPersonID from every line. We never have more than one salesperson on a sales order. So we would like to be able to quickly update every SOLine with the default salesperson ID by simply updating the Order Default SalesPersonID. I thought maybe this could be handled with a document Event Handler or Events at the field level within the screen. I have tested neither methods, because I am not too familiar with Event Handlers yet. I did create a test Event Handler but did not see the SOLine SalesPersonID field as an option to Update after changing the document default salespersonid. Any ideas?
I am just starting to learn Unit Testing. My custom graph references BAccount, Customer, and about 10 other tables which need data in them. For example, to create a customer, I need to have a Customer Class. The customer class has to reference GL accounts. (Joe falls down the rabbit hole and is never seen again).It would be a MONUMENTAL task to create the data in the caches. I’ve scoured the internet to see if I can use an actual database to use for tests. Is there any way to attach to the sample data in SQL server? If not, then Unit Testing is pretty much useless. In order to get my application certified for the Marketplace, I’m supposed to provide Unit Tests. That is just not feasible. My testing requires a full set of data like is provided in the Acumatica sample data.Any suggestions?
Hi everyone,Currently trying to get our version of Acumatica into a sandbox environment so that I can work on customizations without messing up the live environment. However, I keep running into issues and the latest one is that acumatica says I’m missing a file and that’s the reason why I can’t publish anything. Not sure how that’s possible As I downloaded a snapshot and used that in the installation process. We are on version 2022 R2.Error Message I get is: An error on the page ~/Pages/LP/LP303000.aspx with the message: Cannot access the uploaded file. Failed to get the latest revision of the file 592af516-fdab-4bb2-9c7e-3f71618f0f3eIf anyone knows how to fix this that would be much appreciated. Kind regards, Jacob
CSAttributeDetail shipTypeDetail = new PXSelect<CSAttributeDetail, Where<CSAttributeDetail.attributeID, Equal<Required<CSAttributeDetail.attributeID>>, And<CSAttributeDetail.valueID, Equal<Required<CSAttributeDetail.valueID>>>>> (Base).Select("MFGPRPALLE", attributeID.Value); What is the best way above code use in PXSelector ?
I am trying to populate the dynamic material no based on this above report condition. #region TransactionDate [PXDate()] [PXUIField(DisplayName = "Transaction Date")] [PXUnboundDefault(typeof(Today))] public virtual DateTime? TransactionDate { get; set; } public abstract class transactionDate : PX.Data.BQL.BqlDateTime.Field<transactionDate> { } #endregion #region Status [PXString(1, IsFixed = true)] [PXUIField(DisplayName = "Status")] [PXDefault("H")] [PXStringList( new string[] { DocStatus.Hold, DocStatus.Balanced }, new string[] { "On Hold", "Balanced" })] public virtual string Status { get; set; } public abstract class status : PX.Da
Hi, For RC Orders in Sales order Screen, Basically when we bring the values from “Invoice Filter” Action it brings inventory items with invoice Nbrs in SOLine. And it Sometimes displays errror message on Qty feild “The return quantity exceeds the quantity available for return for the related invoice line AR010261, FOODCHIP36. Decrease the quantity in the current line, or in the corresponding line of another return document or documents AR010308, AR010316 that exist for the invoice line”, i Have also created another Action button in the grid,that works excatly like invoice filter action, i can bring the inventory items with invoice id to the SOLine grid, But i cannot display the error message that is being displayed with “Add Invoice Action” , Upon doing some R&D, i came to know that the error message is being displayed from “MemoCheck()” Methrod of “SOOrderItemAvailabilityExtension” graph, Hear is the sample code public virtual bool MemoCheck(SOLine line, bool persis
Hi, I modify the exiting UI controls values after calling API. But after changing the values Save button not activated. Can someone check this and give me the answer?Here is by graph code and screen.public class HMRCVendorRegisterMaint : PXGraph<HMRCVendorRegisterMaint>{public SelectFrom<HMRCVendorRegisterDetail>.View VendorRegisterDetail;public PXAction<HMRCVendorRegisterDetail> VerifyVendor;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Verify Vendor", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]protected virtual IEnumerable verifyVendor(PXAdapter adapter){ //Responce from the API HMRCVendor hMRCVendor = serializer.Deserialize<HMRCVendor>(response.Content); if(hMRCVendor!= null) { VendorRegisterDetail.Current.HMRCVendorVerified = hMRCVendor.IsValid; VendorRegisterDetail.Current.HMRCVendorPrecentage = hMRCVendor.VendorPrecentage; VendorRegisterDetai
I have created 'Load Records from File' on Document Templates screen. However, when I Import, the 'TemplateId' attribute is missing in Property NameIn the AUTemplateData table, there is the attribute 'TemplateId' Here is my code [PXImport(typeof(AUTemplateData))] public PXSelectJoin<AUTemplateData, InnerJoin<AUTemplate, On<AUTemplate.templateID, Equal<AUTemplateData.templateId>>>, Where<AUTemplateData.templateId,Equal<Current<AUTemplate.templateID>>>> Items;How can i fix it ? Can someone please help me.
Hello All,I am trying to trigger FieldSelecting Event in a graph extension for EPApprovalProcess (ScreenID EP503010) but I am not sure why the event is not triggered while in the same extension RowSelected Event is triggered just fine. I had this issue in the past on a different graph that Generic Method was not working and with @Yuriy Zaletskyy guidance I switched to the traditional method DACName_FieldName_Event syntax style and worked fine (see below post). So I thought I had learnt from it so I tried both methods but it didn’t work. Please see the below code I have tried all possible methods but none of them are triggered.using PX.Data;using PX.Objects.EP;using static PX.Objects.EP.EPApprovalProcess;namespace MYTest{ // ScreenID EP503010 public class MYEPApprovalProcessExt : PXGraphExtension<EPApprovalProcess> { public static bool IsActive() => true; // This Row Selected Event IS triggered protected virtual void _(Events.RowSelected<EPOwned
Hi Team,I need to filter out vendors who are not in the my custom table (HMRCVendorRegisterDetail). I wrote following but it is not showing me the results. Any alternative for this?Only one vendor code is exists in the HMRCVendorRegisterDetail table [PXSelector(typeof(Search2<BAccount.bAccountID, LeftJoin<HMRCVendorRegisterDetail, On<BAccount.bAccountID, Equal<HMRCVendorRegisterDetail.bAccountID>>>, Where<BAccount.type, Equal<BAccountType.vendorType>,And <HMRCVendorRegisterDetail.bAccountID, Equal<Null>>> >), typeof(BAccount.acctCD), typeof(BAccount.acctName), SubstituteKey = typeof(BAccount.acctCD), DescriptionField = typeof(BAccount.acctName))]
Hi Team, I need to add the exiting database values to controls after selecting the particular vendor. I wrote some code and it is not working it clears the all controls. Can someone help me out? protected void _(Events.FieldUpdated<HMRCVendorRegisterDetail, HMRCVendorRegisterDetail.bAccountID> e) { HMRCVendorRegisterDetail row = e.Row; if (row.BAccountID != null && row.BAccountID > 0) { HMRCVendorRegisterDetail vendorDetail = PXSelectReadonly<HMRCVendorRegisterDetail, Where<HMRCVendorRegisterDetail.bAccountID, Equal<Required<HMRCVendorRegisterDetail.bAccountID>>>>. Select(this, row.BAccountID); VendorRegisterDetail.Current = vendorDetail; //VendorRegisterDetail.Current.Hmrcregid= vendorDetail.Hmrcregid; //VendorRegisterDetail.Current.Active = vendorDetail.Active;
Hello, I am trying to update the AR Payment when the capture button is clicked, prior to capturing. I need to add Entry Charges programmatically and then let the capture do the rest of its base processing. I have the below code but during the Save, I am receiving a PXLockException error, and a message that another process has updated the ARRegister. Can you please provide guidance on how I can properly update the record prior to the base method and let basemethod do its process based on the updated record?public class ARPaymentEntry_PaymentTransactionExt : PXGraphExtension<ARPaymentEntryPaymentTransaction, ARPaymentEntry> { public static bool IsActive() => PXAccess.FeatureInstalled<PX.Objects.CS.FeaturesSet.integratedCardProcessing>(); public override void Initialize() => base.Initialize(); public delegate IEnumerable CaptureCCPaymentDelegate(PXAdapter adapter); [PXOverride] public virtual IEnumerable CaptureCCPayment(PXAdapter adapter,
I’m creating SDK tests and I need to fill in the value for attribute. I’m able to find the needed row and it clicks on it, but I cannot insert any value to it. The error is “Could not find a web element”.I tried to make it with DynamicControl but it throws error as well (tried DropDown, DropDownList - nothing works).Could someone please help me out?
Hi,Im having problem generating page wrapper with ClassGenerator tool. Its config looks like<?xml version="1.0" encoding="utf-8"?><configuration> <appSettings> <add key="SitePhysicalPath" value="C:\Acumatica\PhoneRepairShop1" /> <add key="GenResultPath" value="C:\Acumatica\Plugins\Test SDK\ClassGenerator\Out" /> <add key="Username" value="tmuser@TIGER" /> <add key="Namespace" value="GeneratedWrappers.Acumatica" /> <add key="ClearOutput" value="false" /> <add key="FilenameFilter" value="*GL301000*" /> <!--<add key="PagesList" value="list.txt"/> <add key="PagesListAttribute" value="exclude"/> <add key="PagesListAttribute" value="include"/> <add key="PagesParameters" value="ParamsPP.txt"/> <add key="GenericInquiryParameters" value="ParamsGI.txt"/>--> </appSettings> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" />
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.