Develop Customizations

Hi Team,Need to know how to enable or disable specific field based on the another field value. Can someone help me? Here is my codeprotected void _(Events.FieldUpdated<HMRCVendorRegisterDetail, HMRCVendorRegisterDetail.verifiedTypeID> e)        {            HMRCVendorRegisterDetail row = e.Row;            if (row == null) return;            if (e.OldValue != e.NewValue)            {                if (row.VerifiedTypeID.Equals("M"))                {                    row.VerificationNote = "Manual Verified By " + PXAccess.GetUserName() + " On :" + DateTime.Now.ToString();                     //row.VerifiedDate  Need to Enable/Disable this field                }                                          }        }

Does a Fluent BQL equivalent exist for the STRING_AGG function in SQL Server? I am writing a query over a one-to-many relationship and would like to see a string column from the `many` table concatenated with commas.  Similar to how Customization Projects can display multiple Screen Names in a single cell. Does any one know the best practice for achieving this?

How do i go about creating an html file that can be accessed from another script?

Dear Team, Please help us with the following situation.We will warranty equipment products for customers with our products sold. The product is only warranted if the customer's product Serial number matches the Serial number of the Acumatica system that stores Serial data when sold.We save the Serial number when products are Receipted/Issued through the field "Lot/Serial Nbr." on the Acumatica system.When customers bring the device in for warranty service. We need to first check the Serial number on the "Case" screen. We've created new fields on the "Case" screen as below to do this.  The results we expect are depicted as shown below: 1/. On the Case screen. When entering the Serial number in the UsrSerialNbr(Serial Check) field => press Enter. If Serial number is found in PX.Objects.SO.SOShipLine => The fields (InventoryID, Inventory Description, ShipDate, OrderNbr) will display the corresponding data taken from DAC SOShipLine.2/. Conversely, If the Serial number is not found in

Dear Team, When creating a new CASE or opening a CASE, the default TAB is "DETAILS".  How to change default TAB to "ATTRIBUTES" ?  Best Regards,NNT

[PXOverride]        protected virtual IEnumerable ConfirmShipmentAction(PXAdapter adapter)        {            this.Base.confirmShipmentAction.Press(adapter);            return adapter.Get();        } I have written this code in my Graph extension to override the Base action but I get this error as soon as i click action button on the screen. And after that the shipment is confirmed.  Attempt by method 'Wrapper.PX.Objects.SO.Cst_SOShipmentEntry.ConfirmShipmentActionGeneratedWrapper(PX.Objects.SO.SOShipmentEntry, PX.Data.PXAdapter)' to access method 'MyCust.Acumatica.SOShipmentEntryExt.ConfirmShipmentAction(PX.Data.PXAdapter)' failed.

I was asked to restrict results of the Add Item button of the SOOrderEntry screen to only non-stock items and stock items associated to the current branch, filtering out items of other branches that are not extended to the current branch.My PXProjection inherits from SOSiteStatusSelected and uses PXSubstitute to utilize my select instead of the one in the base projection.  This seems to work well, except when I apply a filter to the Warehouse (Site ID) column in the dialog’s grid.  Other columns seem to work fine, but not Warehouse.  I get the following error: This is because filtering the result grid injects the following into the underlying SQL statement which obviously won’t work because the projection’s class isn’t in the database. AND ((SELECT TOP (1) [INSiteExt].[siteCD] FROM [INSite] AS [INSiteExt] WHERE ([INSiteExt].[CompanyID] = 4) AND ([INSiteExt].[BranchID] IS NULL OR ([INSiteExt].[BranchID] IN (75, 79, 78, 80, 81, 82))) AND [INSiteExt].[SiteID] = [SOSiteStatus

Hello,I want to enable the button “Enter AP Bill” which associate with action CreateAPInvoice on Purchase Orders screenby implementing Event handler Row_Selected as following:protected void POOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (POOrder)e.Row; if (row != null) { if (row.Status == POOrderStatus.Hold) { Base.createAPInvoice.SetEnabled(true); } } }but it doesn’t working.Do you have any suggestion?

Hello,I have been adding fields to the INUnits table to better fit our needs, and so far it seems to be exactly what we need. I followed the example from this link: https://www.acumatica.com/blog/creating-acumatica-dac-extension-tables/. However I have ran into issue relating to copy and pasting.When I try and copy this SKU to make a new one this happens    It makes sense that the key cannot be NULL, but why is it trying to insert the extension table row before the main row exists?Regardless, its not the end of the world to me if I am unable to bring over all of the UOMs, so I added this code to the graph extension based on this example: https://stackoverflow.com/questions/56261490/hiding-custom-fields-in-copy-past-optionPXViewName(Messages.InventoryUnitConversions)]PXImport(typeof(INUnit))]PXCopyPasteHiddenView]public PXSelect<INUnit, Where<INUnit.inventoryID, Equal<Current<InventoryItem.inventoryID>>>> itemunits;And am met with this when I copy and paste:This

Hello all, I hope you’re having a great day! I have added a customisation to add some fields to our Business account screen so we can more easily identify top end users etc etc. After publishing the customisation I have had an undesired effect where in the data fields aren’t displaying the same as they were in the customisation project editor, please see below for reference:I have also put a photo of how it is laid out in the customisation project editor:Not sure if the different icon for the first column means anything? Any advice on this will be greatly appreciated!! Many thanks in advance, Aleks

Hello,Im trying to build GI with ARInvoice being linked to SalesOrder. I tried to use InvoiceNbr in both but no luck. How can I do it?

Hi Team,Need know how to write bql query with order by and where part. Can someone help me?My Sample[PXFilterable]        public SelectFrom<HMRCVendorRegisterDetail>.OrderBy<Desc<HMRCVendorRegisterDetail.validTo>>.Where<HMRCVendorFilter.bAccountID.FromCurrent.IsNull.Or<HMRCVendorRegisterDetail.bAccountID.IsEqual<HMRCVendorFilter.bAccountID.FromCurrent>>>.View.ReadOnly DetailsView;

Currently in Acumatica, when you are trying to receive an item with serial numbers from a 2 step transfer, the document already comes with the serial numbers from the original transfer.I’ve tried to remove them from the Cache objects and views y different ways but ultimately it doesn’t work.  Is there a way to clear or remove all line details records when the Transfer number is selected? This way the user validates the physical serial number and enters it in the system.  Here is my code with all the ways I’ve tried. Any help will be much appreciated. protected void INRegister_TransferNbr_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (INRegister)e.Row; // this.Base.Caches<PX.Objects.IN.INTranSplit>().Clear(); //this.Base.Caches<PX.Objects.IN.INCostStatus>().Clear(); // this.Base.Caches<PX.Objects.IN.Overrides.INDocumentRelease.ItemLotSerial>().Clear(); //this.Base.Caches<PX.Objects.IN

This is 2022 R2 : Build 22.215.0056I am having all kinds of weird things happening in the data of the Sales Demo that I do not understand.Issue #1: (With No Customizations Published) When I look in the database file (Using SQL Manager) I see that there is a stock inventory Item named: “GoPro” But when I search for it in the IIS Application, it is not found: Issue #2I have extended the DAC for InventoryItem to add a field: UsrASGDescX -- it is an extended description field. I would like to also search by this field in Inventory Lookup on Sales Order. This is the definition of my field in the DAC: #region UsrASGDescX [PXString] [PXUIField(DisplayName = "Extended Description")] public virtual string UsrASGDescX { get; set; } public abstract class usrASGDescX : PX.Data.BQL.BqlString.Field<usrASGDescX> { } #endregionI have created a GI which allows me to see the extended data fields:I go to the inventory Item AALEGO500 -- since I can see it in the SQL Server AND the IIS

Hi Team,In the 22R1 version, we utilized the SOOrder.CCCardNumber fields in our reports to display Card Number details. However, these fields have been removed in the 23R1 version, leading to an "Invalid column" issue.Is there an alternative solution available?Thanks in advance.

Hi,In the Projects screen, a client is wanting to have the description field from the Tasks tab to be copied across to the ‘Task Description’ custom field in the Revenue and Cost Budget tabs. I have code set up from a previous request that copied over the Task ID column to these tabs, so I am just needing to add some additional logic to this code, but I am not sure how to achieve this. The comments in the code starting with ‘ATTEMPT:’ show where I was adding in the logic to try and achieve this. It publishes without any issues, but then when I try it out in the Projects screen, I get the error shown in the image below about an incorrect extension being requested. What would you recommend for my next attempt? Kind regards,Andrew protected void PMTask_UsrLineCtr_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (PMTask)e.Row; PMTaskExt rowExt = row.GetExtension<PMTaskExt>(); // ATTEMPT: Grabbing the DAC extension for the PMRevenueBudget and PMCost

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