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 have a requirement as follows and need to know how this can be catered via customizing the action.When I click on “Generate Orders for Subassemblies” for a parent item such as given below with a qty to produce of 10.00 When the button is pressed the child items also need to be set to a qty to produce of 10.00, currently the system sets it to 1.00 as shown belowHow can I also copy over the qty to produce as well over to the child items once the button is pressed?
Can I set CMType to visible when selecting a specific option from the DocType field? for example i will choose credit memo on doctypeCM Type will be set to visible Is it possible
I am trying to restrict the Attributes that show in the Attributes tab on the Project Entry screen.The Answers view on this graph is not a standard PXSelect. The first two lines are from the original graph.I’ve tried using public virtual IEnumerable answers() and public virtual IEnumerable projectAnswers()but neither of those fire my view override. I have a breakpoint on PXView currentView = Base.Answers.View; but it is never reached. //[PXViewName(Messages.ProjectAnswers)]//public TemplateAttributeList<PMProject> Answers;public virtual IEnumerable answers(){ PXView currentView = Base.Answers.View; //var view = new PXView(Base, false, myDetails.View.BqlSelect); //var startRow = PXView.StartRow; var startRow = 0; int totalRows = 0; foreach (object row in currentView.Select(PXView.Currents, PXView.Parameters, PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startRow, PXView.MaximumRows, ref totalRows)) { CSAttributeGroup a
Hi I have added a user defined warehouse selector as below in the Material Wizard 1 screen in Acumatica.[PXInt][PXSelector( typeof(Search<INSite.siteID>), typeof(INSite.siteCD), typeof(INSite.descr), SubstituteKey = typeof(INSite.siteCD))][PXUIField(DisplayName="Warehouse")] The records should be filtered based on the selected warehouse, but no filtering occurs. I have implemented the filtering logic below.using System;using PX.Data;using System.Collections.Generic;using PX.Objects.CS;using System.Collections;using System.Linq;using PX.Objects.IN;using PX.Objects.AM.Attributes;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class MatlWizard1_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard1> {#region View Extensions public override void Initialize() { base.Initialize(); // Modify the existing processing delegate Base.OpenOrders.SetProcessDelegate(list => {
Has anyone come across issue where a field has been added to the details tab of a process screen via customization and the column can not be filtered - as in added a column filters does not filters at allWe now have 3 process screen on 24R1 customers with this issue. I know one is SO505000 but can be sure of the other 2.
Missing Parameters In the development of the Quality Inspection tab in the POReceiptEntry screen, issues have been identified when attempting to dynamically populate records based on POReceiptLine entries. These issues prevent the system from accurately reflecting all the required quality parameters for each InventoryID. ScenarioSetup SetupPurchaseParameter contains predefined quality parameters linked to specific InventoryIDs. POReceiptLine contains the InventoryID of items being received.Requirements When a record is added to POReceiptLine, the system should check if the InventoryID requires a quality check (InventoryItemExt.UsrNeedQualityCheck = true). For such InventoryIDs, all associated parameters from SetupPurchaseParameter should be added as new records in the Quality Inspection tab. Observed Issue Case 1 - Adding a line with an InventoryID having two parameters in SetupPurchaseParameter results in only one record being added to the Quality Inspection tab. Codeusing System;
In version 24_202_0026 which was upgraded from version 23_107_0022 I attempt to programmatically create a SO document. The Bill Address and Bill Contact handling code works with issues. I had the PX.Data.PXLockViolationException error on PressSave(). SOBillingAddress billAddress = docgraph.Billing_Address.Current = docgraph.Billing_Address.Select();billAddress.OverrideAddress = true;billAddress = docgraph.Billing_Address.Update(billAddress);docgraph.Actions.PressSave(); Here I have fond a potential solution. SOBillingAddress billAddress = docgraph.Billing_Address.Current = docgraph.Billing_Address.Update(new SOBillingAddress { OverrideAddress = true }); docgraph.Actions.PressSave(); Using the recommended code I get the PX.Data.PXOuterException: 'Error: Inserting 'Billing Address' record raised at least one error. Please review the errors error, also, on the end of process, I see the Error: 'RevisionID' cannot be empty.Address is not validated. error. The Save operation works fine wh
Is it possible to extend the workflow on the Kit assembly screen to allow updates to certain fields on the User Defined field tab after the kit assembly has been released? I followed the directions on Irina’s post, but it didn’t work:https://community.acumatica.com/develop%2Dcustomizations%2D288/how%2Dto%2Denable%2Dthe%2Duser%2Ddefined%2Dfields%2Deven%2Dwhen%2Dthe%2Dwhole%2Ddocument%2Dis%2Dcompleted%2D5480I have used this approach successfully on the Sales Order screen. Is there something different about Kit Assembly, or am I doing something wrong? I was sure to make the workflow extension active.@Irina @ray20 @Neil Cantral Thanks,Laura
I created a custom screen of type FormTab. I added the following view to the form (summary) area. However, some fields appear as disabled(uneditable) when the screen is displayed. Specially all fields in the second DAC. When I add these DACs alone as the view, fields appear correctly with editability. This issue occurs only when the DACs are joined. public SelectFrom<AMMTran> .InnerJoin<AMProdItem>. On<AMProdItem.orderType.IsEqual<AMMTran.orderType>. And<AMProdItem.prodOrdID.IsEqual<AMMTran.prodOrdID>>> .View HeaderView;I tried resolving this issue using an a RowSelected event handler as follows, but it didn’t work. I also set Enabled = true for the fields using the Customization Project Editor, but the problem persists. Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you! protected virtual void _(Events.RowSelected<AMProdItem> e) { if (e.Row
HiI am adding the warehouse location field to the deadstock screen.I managed to add the field and view the location for each warehouse. However the data is not filtering based on the location.I know I tried creating a graph extension to add the location as a filter but its not working. using PX.Common;using PX.Data;using PX.Objects.CS;using PX.Objects.IN.DAC.Unbound;using PX.Objects;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System;namespace PX.Objects.IN.DAC.Unbound{ public class INDeadStockEnqFilterExt : PXCacheExtension<PX.Objects.IN.DAC.Unbound.INDeadStockEnqFilter> { #region Usrlocation [PXDBInt] [PXSelector(typeof(Search<INLocation.locationID, Where<INLocation.siteID, Equal<Current<INDeadStockEnqFilter.siteID>>>>), typeof(INLocation.locationCD), typeof(INLocation.descr), SubstituteKey = typeof(INLocation.locationCD))] [PXUIF
Hello all,I am trying to add a Selector attribute on a new field in order to store a vendor in a case screen customization using the Customization Project Editor. After I publish the customization, I receive the error: “Cannot create ctl00_phG_tab_t2_CstPXSelector122 control. The PXSelector attribute is missing for the UsrInst_InstallVendor field. Make sure the names of the data views specified for controls in the ASpX file match the names of the data views defined in the corresponding graph.”I have added the following attributes in the UsrInst_InstallVendor field:[PXDBInt][PXSelector(typeof(Search<PX.Objects.CR.BAccountR.bAccountID, Where<PX.Objects.CR.BAccountR.type, Equal<PX.Objects.CR.BAccountType.vendorType>>>))][PXUIField(DisplayName="Install Vendor")]Then, I create the control on the tab I have added in the Cases screen customization. After publishing, the screen shows the selector, but when clicked, I receive the error message above. Am I missing a step in my
Good day, I have a customization with 2 custom fields that are selectors called 480 Tax Line, one in Non sotck item screen and another in the lines of Bills and Adjustments; these selectors have the values from an Attribute and there is an Instance where I am having an error, everytime I choose one of the options and press save, I receive the error "Error: Updating 'Inventory Item' record raised at least one error. Please review the errors.” and then in the field it has the error '480 Tax Line' cannot be found in the system.The DAC is configured to show the description of the attribute in the UI and save the ValueID in the database, everything is working well on every other Instance I publish my customization, but in this one I don't understand why I have conflicts where everything is the same, the attributeID is APLINE and the data is the same on every other environment I have tested. public class InventoryItemExt : PXCacheExtension<PX.Objects.IN.InventoryItem> { #region Usr
Hello guys, I am having an issue with a workflow event handler:Workflow declaration:.WithHandlers(handlers =>{ handlers.Add(handler => handler .WithTargetOf<ARBalances>() .OfEntityEvent<ARBalancesCreditHoldExt.MyEvents>(e => e.CreditLimitViolated) .Is<SOShipmentEntryCreditHoldExt>(g=> g.OnCreditLimitViolated) .UsesPrimaryEntityGetter< SelectFrom<SOShipment>. Where<SOShipment.customerID.IsEqual<ARBalances.customerID.FromCurrent>>>() ); handlers.Add(handler => handler .WithTargetOf<ARBalances>() .OfEntityEvent<ARBalancesCreditHoldExt.MyEvents>(e => e.CreditLimitSatisfied) .Is<SOShipmentEntryCreditHoldExt>(g => g.OnCreditLimitSatisfied) .UsesPrimaryEntityGetter< SelectFrom<SOShipment>. Where<SOShipment.customerID.IsEqual<ARBalances.customerID.FromCurrent>>>() );})//Add to Sta
Hi Guys, Im having a little issue with redirections.I receive these errors:After I attempt redirection from here:The ‘Press and Glue Log’ works fine…My DAC key fields: #region DocNbrpublic abstract class docNbr : BqlString.Field<docNbr> { }[PXDBString(15, IsKey = true, IsUnicode = true)][AutoNumber(typeof(ISOSetup.autoNumberingQC), typeof(GCQCRecord.date))][PXSelector(typeof(GCQCRecord.docNbr), typeof(GCQCRecord.batchNbr), typeof(GCQCRecord.date), typeof(GCQCRecord.sOOrderNbr), typeof(GCQCRecord.status), ValidateValue = false)][PXUIField(DisplayName = "Doc Nbr", Enabled = false)]public virtual string DocNbr{ get; set;}#endregion#region BatchNbrpublic abstract class batchNbr : BqlString.Field<batchNbr> { }[PXDBString(15, IsKey = true, IsUnicode = true)][PXSelector(typeof(AMBatch.batNbr), typeof(AMBatch.docType))][PXRestrictor(typeof(Where<AMBatch.docType.IsEqual<Messages.move>>), Messages.MoveNotFound, typeof(AMBatch.docType))][PXUIFie
I am writing a custom DAC that uses the GLTran table. The default GLTran DAC will filter on the FinPeriodID field in the format MM-YYYY, however stores the field as YYYYMM. When i try to use the field directly in GI conditions I have to specify the financial period ID as YYYYMM to get the results. What do I need to do in my DAC for that field to operate in the MM-YYYY form like it does in the stock GLTran DAC? I tried working with something like this: #region DB Calced Formulas using FinPeriodIDLeft4 = Use<Left<GLTran.finPeriodID, int4>>.AsString; #endregionHowever, I do not know how to swap the first 4 and last 2 of the field value in order to make it work like the stock DAC does. Thank you in advance!
Acumatica Snapshots can be tricky, but they are extremely useful. If you are unfamiliar with the feature, Acumatica’s snapshot system is an amazing ERP feature that lets the customer export and import a company’s data into/from a zip file full of files that represent the data of SQL tables in the ERP. With Snapshots, you can create a copy instance of an Acumatica site by company. It’s an incredibly powerful tool that gives you a lot of power over your data. Customers can create copies of their sites for testing, experimenting, or for historical analysis. I’ve been using snapshots to troubleshoot customer issues since I started working with the product in 2013. No longer did I have to go through the nerve-wracking process of troubleshooting an issue in a customer’s production environment. I didn’t need to get a customer to allow me access to their system so that I could poke around, perhaps send a SQL query via the chat window, and desperately try to infer the issue in the time a
I am trying to integrate a 3rd party address validation rest service into acumatica, is there any documentation on how to do that to using the same workflow as avalara or vortex plug-in
Hi Community,Can you please help me with the sample to know which tab is selected.
Hi, I have a requirement where the values entered in the Attributes form need to be pulled into a custom form I make. So, I basically need a way to have a custom line level drop-down list field which contains all the values that are previously entered in the Attributes form. Any help regarding this would be appreciated.
Sorry for posting so many questions lately. in my command, I want to get the first two characters of the screen ID. If it is SM, I want to exclude the record from the selection. cmd = new SelectFrom<UploadFileRevision> .InnerJoin<UploadFile>.On<UploadFile.fileID.IsEqual<UploadFileRevision.fileID>> .InnerJoin<ICSUploadFileView>.On<ICSUploadFileView.fileID.IsEqual<UploadFile.fileID>> .LeftJoin<ICSSystemFiles>.On<ICSSystemFiles.systemFileName.IsEqual<UploadFile.name>> .Where<UploadFile.primaryScreenID.IsNotNull.And<ICSSystemFiles.systemFileName.IsNull> .And<Substring<UploadFile.primaryScreenID, int0, int2>.IsNotEqual<SMScreenConstant>>> .View(this);I know Substring can be used in the predicate, but do you know of a way to do it in the subject of the Where? I am using a SQL View since you can do a field not in ("SM") in the where in SQL. I want to get rid of the need for
I made a processing screen. In the grid, the file name is not selectable because it is read only (Inquire skin).I want the user to be able to copy the file name into their clipboard. I’ve tried every trick I know and I cannot find a way to make that field so that you can select the text in it. I’ve tried enabling the cache for the grid, enabling the FileName field in the grid, adding the field to the Fields in the project editor. The reason this is important is that there might be 40 revisions of the same file and by copying/pasting the file name into the filter will limit the view to just those files/revisions.For example, I want to put “SO Import Sales Order Template.xlsx into the filter but I don’t want the user to have to type the name.I created a work around by creating an action to get the current row and set the file name in the filter to the file name in the grid.protected virtual IEnumerable copyFileName(PXAdapter adapter){ UploadFileRevision ufr = (UploadFileRevision)F
Hello,I have grid of DAC Collector on a custom screen Survey as following:I want the field Collector ID should be clickable as hyberlink and open record in related screen when clicking.The bahavior should look like same as Generic Inquiry: Field Collector ID is clickable and open screen Survey Response in details Any idea would be appreciated.Thank you
I have a Tab form. The main form and first tab sho details from DAC1. Tab 2 contains a grid for records from DAC2.I have the following views in my graph public SelectFrom<DAC1>.View DAC1;public SelectFrom<DAC1>.Where<DAC1.dac1ID.IsEqual<DAC1.dac1ID.FromCurrent>>.View DAC1Detail;public SelectFrom<DAC2>.Where<DAC2.dac1ID.IsEqual<DAC1.dac1ID.FromCurrent>>.View DAC2; The foreign key referecens in DAC2 is defined as #region Dax1ID[PXDBInt()][PXUIField(DisplayName = "DAX1 ID")] [PXDefault(typeof(DAX1.dax1ID))][PXParent(typeof(SelectFrom<DAX1>.Where<DAX1.dax1ID.IsEqual<DAX2.dax1ID.FromCurrent>>))]public virtual int? Dax1ID { get; set; }public abstract class dax1ID : PX.Data.BQL.BqlInt.Field<dax1ID> { }#endregion If I add a new DAC1 and then save it and then edit the DAC2 grid all works well.If I add a new DAC1 edit it, then add details to the DAC2 grid and then save it, the DAC2 records are assigned to the wrong dac1ID.
I am not sure what I have done wrong but when I try to enter a new record for this custom DAC the key field blanks as soon as I am done entering and change focus to any other field.My expectation is that the value entered would be the new key for the new record. Is this field annotated improperly ? Attached is the whole DAC #region AssetCD [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC")] [PXDefault] [PXUIField(DisplayName = "Asset")] [PXSelector(typeof(Search<assetCD>), new Type[] { typeof(assetCD), typeof(assetTypeID), typeof(assetStatus), typeof(description), }, DescriptionField = typeof(description))] public virtual string AssetCD { get; set; } public abstract class assetCD : PX.Data.BQL.BqlString.Field<assetCD> { } #endregion
I have a customer with over 157K files in the UploadFile table. For reasons they know, they upload a LOT of files. They also send thousands of invoices per month which creates PDF files as well.They are running out of diskspace and they asked me for a way to purge files in masse. I created a screen to do this. But, I see that system images are being listed in my grid. I have tried very hard to find a way to identify these image files as “system files” so they cannot be accidentally deleted.For example: I thought about restricting files created by admin, but that would mean they wouldn’t be able to purge attachments to emails from many years ago.Further down in the grid shown above, there is a file that I think they should be able to delete without any issues being created other than losing history: Strangely, the File Maintenance screen will let you delete these files. They look to me like files that are needed by the core Acumatica site. This is the “finger print” image.I will r
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.