Develop Customizations

I have two dropdowns/combos I’ve added, and would like to control the visibility of the second menu based on the value of the first:I would like the second dropdown (Shot Peen) be visible if the first dropdown (Mold Part) = 1/YesWould I set the visibility like this?[PXUIVisible(typeof(Where<TSMIGOpportunityQuotePricingExt.UsrCMoldPartTexture.IsEqual<1>>))]So the final would be something like this:[PXDBInt][PXIntList(new int[] {0, 1}, new string[] {"No", "Yes"})][PXUIVisible(typeof(Where<TSMIGOpportunityQuotePricing.UsrCMoldPartTexture.IsEqual<1>>))][PXUIField(DisplayName="Shot Peen 330 or Less?")]Any help appreciated… the first time I tried this I got an error but I think because I got the dac/field name wrong.  

Hello quite new to acumatica, currently I am trying to add a field onto the Project Quotes screen however the field will not hold any data entered if I save and then leave the page and return to it. Anyone able to help?

Hi everyone,I'm having trouble because I submitted a third-party service request to Acumatica and, using the information, created a selector control, but this affected performance and slowed down the system.The selector's instruction was:PXStringListAttribute.SetList<MyDac.field>(sender, row, values.ToArray(), values.ToArray()); Then, I used the RowSelected method where I requested the WS and set the information in the control, but it is very heavy because I need to make 4 different requests in this event handler.Do you know of any other ways to do this?I'd appreciate any help! :)

Hi all, I tried a low code customization to set a dropdown menu’s default value, and for some reason it’s not working. So I’m attempting to set the default via customized attribute like this:[PXDBInt][PXIntList(new int[] {0, 1,}, new string[] {"No", "Yes"})][PXDefault[(0)][PXUIField(DisplayName="Mold or Part Texture?")]I’ve tried setting the default to 0, to No (no quotes) and “No”, and none of them seem to work… I must be doing something wrong! :) Any help appreciated.

If we change the length of a standard Acumatica field, is there a risk that the field length will be reverted back on the database with an upgrade? Causing the extra characters to be truncated?

Hello,I am trying to add a user field (decimal) called UsrSalesCommPct  public class AMEstimateItemExt : PXCacheExtension<PX.Objects.AM.AMEstimateItem> { public static bool IsActive() => true; #region UsrSalesCommPct [PXDBDecimal] [PXUIField(DisplayName = "Sales Commission (%)", Required = true)] public virtual decimal? UsrSalesCommPct { get; set; } public abstract class usrSalesCommPct : PX.Data.BQL.BqlDecimal.Field<usrSalesCommPct> { } #endregion #region UsrContingencyPct [PXDBDecimal] [PXUIField(DisplayName = "Contingency (%)", Required = true)] public virtual decimal? UsrContingencyPct { get; set; } public abstract class usrContingencyPct : PX.Data.BQL.BqlDecimal.Field<usrContingencyPct> { } #endregion #region UsrMargin [PXDBDecimal] [PXUIField(DisplayName = "Margin")] public virtual decimal? UsrMargin { get; set; } public abstract cl

I am struggling to add a PXDBScalar field to a CRQuote extension. In my customization, I have added a NonPersistedField to CR.CRQuote:[PXDecimal][PXUIField(DisplayName="Lead Days (Rev)")][PXDBScalar(typeof(Search<PBSA.UsrQTRevision.leadDays, Where< PBSA.UsrQTRevision.opportunityID, Equal<CRQuote.opportunityID>, And< PBSA.UsrQTRevision.quoteNbr, Equal<CRQuote.quoteNbr>, And< PBSA.UsrQTRevision.revNbr, Equal<CRQuoteExt.usrRevNbr> > > >>))]PBSA.UsrQTRevision is a custom table and DAC. I have another table and DAC like it for Sales Orders called UsrSORevision. For troubleshooting purposes I have added a similar PXDBScalar field to a SOOrder DAC extension:[PXDecimal][PXUIField(DisplayName="Lead Days (Rev)")][PXDBScalar(typeof(Search<PBSA.UsrSORevision.leadDays, Where< PBSA.UsrSORevision.orderType, Equal<SOOrder.orderType>, And< PBSA.UsrSORevision.orderNbr, Equal<SOOrder.orderNbr>, And< PBSA.UsrSORevision.revNbr, Equa

I don’t use FieldSelecting (almost never) and I think I should have been using it a lot more.  However, When I set the Qty on a line in Bills and Adjustments, it just displays it on screen, and if you add a cost, it doesn’t extend the cost out.You can see it defaults the Qty to 1.  But when you add an item, the extended cost is 0.Here is my method: protected void APTran_Qty_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { var row = (APTran)e.Row; if (row == null) return; if (row.Qty == null || row.Qty == 0) { e.ReturnValue = 1m; } }If I do this in the RowInserting it works, because I can actually update the cache. protected void APTran_RowInserting(PXCache cache, PXRowInsertingEventArgs e) { var row = (APTran)e.Row; if (row == null) return; if (row.Qty == null || row.Qty == 0) { cache.SetValueExt<APTran.qty&gt

Hi everyone, I have a troble and I hope if someone could help me.The issue is in a project of customization, I needed to create a new screen and I had to redirect from another screen so the new screen is a pop-up screen.In the pop-up screen I have a grid and I want to save a record from another table but when I push Save button it doesn’t nothing, I checked that current cache of the dac (I mean the cache of the grid) is full but it doesnt save when i'm in its tab but if I change the tab and I try to save, it's done and It save the record, it's rare because I didn't save nothing, I didn't remove neither modify. The primary view was refered another Dac and the others tabs was refered the same view but the issue tab was from its view. Also the Dac “Cargos Adicionales” have a compound key, I mean, it have the keys from the primary table that is the primary view in the screen. I don’t no if I could be the problem because it worked if it have a identity key in the schema, but for request I n

Hello Everyone, We are trying to create a new field in the sales order screen and we need to display it in the modern UI Sales order screen.  Created a new instance with version (24.205.0015). While creating the instance enabled the Install NodeJS  and Enable Modern UI check boxes.  After completing the instance setup, I tried running the npm run getmodules command, but encountered the following issue. First the NodeJS   files was not in the FrontendSources  folder. The NodeJS  folder was created in the C:\Program Files\AcumaticaTools\NodeJS\node-v18.12.1-win-x64 path.  Moved NodeJS  to the FrontendSources  and tried still same issue.  I also tried running the .\npm command in the NodeJS folder, but it did not work. It seems the NodeJS is not installed that I have installed with Acumatica instance. Removed the NodeJS from the path and followed these instructions(https://learn.microsoft.com/en-us/windows/dev-environment/javascript/nodejs-on-windows) After installing NVM (Node Version Ma

Hi,I have been playing around the customization Project. I have added a new filed Excise Duty in the details tab of the Sales Order Screen SO30100. Now I want that Excise Duty to be 4% of the Quantity.  But I am getting error ofBelow is my DAC and I have added code to calculate the Excise Duty 

I want to add a new field that will allow me to pick a list of employees or users. Or that will allow me to link to an attribute that I already have with employee names. I have added the field already thru customization, but am stuck trying to figure out the pick list. Am I doing it correctly? My main goal is to put a pick list of employee on my project quote screen, so that I can then view it on the inquiry screen as a column and create reports. Any help or direction would be greatly appreciated! Thanks 

 Hello everyone, Getting the error below when I press the button REMOVE HOLD.What could be the issue?All responses will be highly appreciated.

Dear Team,How to add "Inventory" Type of "Source" Role in "RELATIONS" Tab on Cases screen ? The expected results are as follows: Best Regards,NNT

HI,I have recently installed SQL Server and the Acumatica application.I then created a Customization Project and added a Sales Order screen but did not make any other modifications. Then I published it, but the system showed an error message. The system is not validating this. I assume this is the Local configuration issue.  I tried to get this to Visual studio, I have attached the screen.   I would like to know how to fix this. I have uninstalled and reinstalled multiple times, but it does not work.

All,We’re currently on 23R2 and in the process of upgrading to 24R2, testing it on the supplied sandbox.One change we noted (I think this happened back in 24R1) -- customers on credit hold are now selectable from the Customer field in the sales order screen. We DO NOT want to place orders for Customers on credit hold. :) So I changed the code (probably incorrectly)original attribute:[PXDefault] [Customer(typeof(Search<BAccountR.bAccountID, Where<True, Equal<True>>>), // TODO: remove fake Where after AC-101187Visibility = PXUIVisibility.SelectorVisible,DescriptionField = typeof(Customer.acctName),Filterable = true)][CustomerOrOrganizationInNoUpdateDocRestrictor][PXRestrictor(typeof(Where<Optional<SOOrder.isTransferOrder>, Equal<True>,Or<Customer.status, IsNull,Or<Customer.status, Equal<CustomerStatus.active>,Or<Customer.status, Equal<CustomerStatus.oneTime>,Or<Customer.status, Equal<CustomerStatus.creditHold>>>&

Hi All,When our customer tries to release a Credit Memo type invoice, they encounter the following error message: (Acumatica version 23.R1)Could someone please advise on how to resolve this issue?Thank you.Regards,Lalith

I have read over the instructions for adding custom fields to the new Modern UI, however I am getting this error.The field Document.UsrICProjectTaskID cannot be bound to a FieldState.Attached are the HTML and TS files I created. The screen is AR301000  

Hi Everyone,In the SO Invoice screen, I have overridden the Release action, and when the GL document is created, I would like to delete the GL Tran line created by Acumatica and would like to insert another 3 new lines. It has the right amounts but still getting error like saying Document out of balance.  Can anyone help me with this?Assume my invoice total is 1000. public class SOInvoiceEntry_Extension : PXGraphExtension<PX.Objects.SO.SOInvoiceEntry> { #region Event Handlers public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride] public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod) { //var res = baseMethod(adapter); PXGraph.InstanceCreated.AddHandler<JournalEntry>((graph) => { graph.RowInserted.AddHandler<Batch>((cache, e) => { Batch row = e.Row as Batch; if (row != null) {

I have a selector that, after you select a value, only shows the “CD” of the field.  I want it to show the “CD - Description”.When you click the lookup, you see this:After you select a row, you see this:I want it to show T1 - test1Note that if I add DescriptionField = typeof(SSGCRServiceType.description))], the field clears out after the row is selected.  I don’t know why that occurs.  Maybe because the field value in the table is int?Does anyone know what I need to modify in this select statement to make this happen?#region UsrServiceTypeID[PXDBInt][PXUIField(DisplayName = "Service Type", Required = true)][PXDefault(PersistingCheck = PXPersistingCheck.Null)][PXSelector(typeof(Search2<SSGCRServiceType.serviceTypeID, InnerJoin<SSGCRServTypeRecTypeXR, On<SSGCRServTypeRecTypeXR.serviceTypeID.IsEqual<SSGCRServiceType.serviceTypeID>>>, Where<SSGCRServTypeRecTypeXR.recordTypeID.IsEqual<CRCaseExt.usrRecordTypeID.FromCurrent>. And<SSGCRServiceType.is

Good day i have this one last problem on my report it duplicates the taxID on every invoice there is a one data that duplicatesactually its not really duplicating it adds a tax ID even though its not on the transaction like here it diplays wc158,wc120  

I had implemented a custom DAC and screen called prospect vendor. then I need to create a default vendor in the system on a button click. following is the action code. My issue is the header section of vendor page contains data from vendorR dac, which is extended from Vendor Dac, I try to create a vendor instance and saved it, action runs without error, but data is not saved to Database. when I try to save vendorR instance it gives error. how can save a BAccount instance rated to my vendor via VendorMaint graph object. public PXAction<ESProspectVendors> CreateVendor;[PXButton(DisplayOnMainToolbar = true, CommitChanges = true)][PXUIField(DisplayName = "Create Vendor", Enabled = true)]protected virtual IEnumerable createVendor(PXAdapter adapter){ ESProspectVendors vendor = ProspectVendorsView.Current; PXLongOperation.StartOperation(this, delegate { SaveVendor(vendor); }); return adapter.Get();}public static void SaveVendor(ESProspectVendors prospectVendor){

Hi Community,I’m working on the Customer Details Inquiry screen in Acumatica, specifically on the Pay/Apply Document action. I’ve overridden this action to handle multiple document selection so I can apply payments to multiple invoices at once. Here’s the code I’m using:public delegate IEnumerable PayDocumentDelegate(PXAdapter adapter);[PXOverride]public virtual IEnumerable PayDocument(PXAdapter adapter, PayDocumentDelegate baseMethod){ List<ARDocumentEnq.ARDocumentResult> selectedDocuments = Base.Documents.Cache.Updated .RowCast<ARDocumentEnq.ARDocumentResult>() .Where(shipment => PXCache<ARDocumentEnq.ARDocumentResult> .GetExtension<ARDocumentResultExt>(shipment)?.UsrSelect == true) .ToList(); if (!selectedDocuments.Any()) { // Fall back to base behavior if no rows are selected return baseMethod(adapter); } // Iterate through each selected document foreach (var doc i

I’ve added two tabs to a tab strip.  These two tabs do not need to load unless the user actually clicks on the tab.  Is there a way to prevent the loading of a tab until it is activated by the user?

Hi EveryoneCould you please help me with a question regarding unpublishing customization that impacts the instance in a multi-tenant environment?For example, we tested a customization that would impact the instance in a Test tenant. It works well. We publish it in Live tenant again. Due to another test we need to do in the test tenant, we unpublish this customization in test tenant, while the same customization project in Live remains published. My understanding is that some customizations impacts the instance, not just the tenant it is published in. Does it also in term have the same effect when we unpublish?  Removing the same customization in test tenant will impact live tenant and may cause errors. What would be the best practice when we want to test customisation in a multi-tenant environment?Appreciate your insight and suggestions.Thanks.