Develop Customizations

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

I have a customization for the Sales Order graph that affects the Add Invoice process used by return orders. When a user selects an invoice line to be added (by checking the checkbox in the grid) it will automatically select additional lines that are related to the line selected.This is achieved using the FieldUpdated event for the InvoiceSplit.Selected field and a RequestRefresh() call on the invoiceSplits view. Everything was working fine in version 22R2, but in updating the package for 24R1 I am running into an issue with the select all grid control.When the select all check box in the grid header is selected, it selects every line but then it deselects the lines my code would select. Something similar happens when all lines are selected and the select all control is deselected. In that case it deselects all lines then selects the additional lines my code would select.I know I can turn off the select all option for the grid, but is there any other way to override how the select all

I want to retrieve the values of selected detail lines to invoke an action in Acumatica. Some values from the selected detail lines should be passed as parameters to open a custom screen in a popup. How can I retrieve the selected detail line information from a grid to use in an action in Acumatica?Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you!

Hi Acumatica experts,Hope you are doing well.I have a requirement to add an auto-complete feature to a custom column within an existing selector.For example, in the Inventory ID selector, I have added a custom column to the selector. I would like this custom column to use the auto-complete feature so that when I type text contained in this custom column, suggestions will appear without clicking on search icon, just as they currently do for Inventory ID and Description. I understand that these fields are key fields, which is why suggestions are available for them by default. I’m looking for a way to make my custom column support auto-complete suggestions as well.Your insights on this would be greatly appreciated.

I’ve build a processing screen for showing log entries and i have an action to show the details.I am not able to get details shown on double click on a grid row.  Any ideas?

I can't find them in the attributes. How can I select the field name in my import scenario?

Hello,I try to add the new custom field on the screen and when I create the control for new custom field it just uncheck the box I selected and not showing it added.Can someone help me with this issue ?Thank you very muchSee below for more information 

hi i just want to ask can i get the trans tax amount per transaction because i can only get the total[APInvoice.CuryTaxAmt] i have the solution but im having problems because if it has more than one taxid it duplicate its record based on how many tax ID it has  

I have 2 fields declared in DAC. Here is the part of codeAccount(DisplayName = "Offset Account", AvoidControlAccounts = true)]public virtual int? OffsetAccountID { get; set; }SubAccount(typeof(ARPaymentChargeTran.accountID), DisplayName = "Offset Subaccount")]public virtual int? OffsetSubAccountID { get; set; } As a result I have this.When I use [Account] attribute on both of fields, I am able to see the lookup, of course both are of Account data. The main problem is, that I have the correctly working lookup in another test Acumatica instance. The same package has different behavior in different instances. Both instances have the same options enabled on Enable/Disable Features screen, including the Finance - Advanced Financials - Subaccounts, both are of version 23.202.0026. Note, that the correctly working one was upgraded from 23.105.0016 and had a snapshot restored. If the problem is based on version, version upgrade, then we can do nothing, but if is based on snapshot, then I just

Hello,I’m creating SDK tests, and I need to know how can I use the "select all" option in a grid?Thanks  

I have added a custom field on the header of the Project Transaction screen, but I need this to be editable when the transaction is released.This screen has no workflow, so wondering if anyone can assist with how to do this please.Its all enabled, and I can update it on screen, but when I press save, it loses the data / does not actually save it to the PMRegister table.

I need to create a new Email Activity for SOOrder, Shipment, and Payment and Applications in my customization code. Was wondering which method I would override for my requirements and what I need to pass into it in order to create this new record. I’m handling emails being sent out with a different provider so I don’t want the emails to be sent out from Acumatica.

 Hi team,Recently migrated to 2023R1, while publishing customizations on local env validation is failing.But the same works on a site deployed on test server.Any thoughts?Screenshot of a test customization. 

Overview Modern UI Files Support PX.CommandLine Tool - General Information Command Line Syntax Shared Arguments Methods Description ValidateExtensions Arguments UploadCustomization Arguments RemoveCustomization ValidateCustomization Arguments PublishCustomization Arguments BuildProject Arguments Building of a customization stored in a source control folder DeleteProject Argument MergePackages Arguments ExportSnapshot Arguments UpdatePages Arguments  Overview Greetings, Community,As you may know Acumatica has a console tool PX.CommandLine. It is mentioned in Acumatica Help Portal:https://help.acumatica.com/(W(89))/Help?ScreenId=ShowWiki&pageid=0450cd3a-9c71-4ee3-a11c-46128f227d04For a long time the documentation did not describe all capabilities of the PX.CommandLinetool. The only thing described was how to use the tool to build the customization package. However, the PX.CommandLinetool can do many other tasks that could be useful for your CI pipelines.The documentatio

Dear Support,I have created usrLookup (Part No) field on Inventoryitem and I want this field to add on column Sales Order Line.Please advise. Thanks,Idrus

I have Added Tab in Acumatica Stock item Wiki page.Now i want to save this changes in my visual studio   

Hello community, I am looking for some guidance on how to “reset” a few custom fields on a sales order if the related shipment entry is deleted. I was able to get these fields to update when creating a shipment. However, I am a little lost on how to get them to clear on a shipment deletion. For inserting them I wrote an override to “CreateShipment”. For the deletion, I tried to do a SOShipLine_RowDeleted, but cannot reference the SOOrderEntry due to the “PX1045: A PXGraph instance cannot be created within an event handler.” Any help is much appreciated!Thanks,Adam

Hi,I’m trying to capture whenever SOOrder status is changed to shipping so that I can do some of my own customization code when this event happens. Originally I had it when createshipment action was triggered. However, I realized it would send even if there was missing items in inventory and it would send even if the shipment wasn’t created. What graph would I look for capturing this event happening. My current code in SOOrderEntry isn’t capturing this change.  

Hello Everyone, We have a requirement to add a popup validation message on the “Remove Hold” action in the Change Order screen. If a specific condition is met, we need to throw an exception so that the Change Order remains in “On Hold” status until the user corrects the values. We are able to display a popup warning message on the screen using `View.Ask("")`, and it’s working fine. However, once the user clicks “OK” on the popup, the status changes to “Pending Approval.” If we throw an error upon clicking "OK," the record appears as "On Hold" on the screen, but in the table, the “Hold” field changes to false. We also tried bypassing the base method if our custom condition is met. In this case, the status on the page shows as “On Hold,” but in the backend, the “Hold” field still becomes false, preventing further edits. Even when we simply throw a `PXException` in the “Remove Hold” action, the exception displays correctly, and the screen shows “On Hold” status, but the `Hold` field in th

I think I’ve been looking at this too long. 24r1I have set ShipVia to be required through cache attached in my SOOrderEntry extension. I added Required = true to PXUIField and changed the PersistingCheck in PXDefault to NullOrBlank:[PXMergeAttributes(Method = MergeMethod.Merge)][PXUIField(DisplayName = "Ship Via", Required = true)][PXDefault(typeof(Search<Location.cCarrierID, Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<Location.locationID, Equal<Current<SOOrder.customerLocationID>>, And<Current<SOOrder.behavior>, NotEqual<SOBehavior.bL>>>>>), PersistingCheck = PXPersistingCheck.NullOrBlank)]protected virtual void _(Events.CacheAttached<SOOrder.shipVia> e){ }So, in theory, I should not be able to save the record without supplying a shipvia value. But, I can click Remove Hold.Now, the record is not persisted to the database, but the order is now Off Hold.And I understand that’s because the action for