Develop Customizations

Hello everyone, I am attempting to pull the unit cost for Sales Quotes from InventoryItemCurySettings to automate our gross profit calculations.Has anyone had any luck doing so? Thanks,Aleks

I added import functionality to the Physical Inventory Types screen IN208900.The override for the View for the grid is as follows:  public class INPIClassMaint_Extension : PXGraphExtension<PX.Objects.IN.INPIClassMaint>  {  [PXImport(typeof(INPIClassLocation))]  public      PXSelectJoin<INPIClassLocation,      LeftJoin<INLocation, On<INPIClassLocation.FK.Location>>,      Where<INPIClassLocation.pIClassID, Equal<Current<INPIClass.pIClassID>>>>      Locations;  }When you import the Excel file, the Pick Priority field is not available to map.  I assume that is because the field is not in the INPIClassLocation table.Does anyone know of a trick to get that field added to the view?  

Hello Everyone, I have been battling on what the best way is to get unit costs to auto-populate onto the Sales Quotes (CR304500) screen.Initially I had used a FieldUpdated handler for inventory ID but as we import plenty of worksheets from excel, this breaks and pushes the values a line down.Yesterday, I was doing the T230 course and I was inspired so I recreated it but for recalculating unit costs on Sales Quotes.Here is the code for the button, hope it helps someone!public class QuoteMaintCostExt : PXGraphExtension<PX.Objects.CR.QuoteMaint>{ public static bool IsActive() => true;//Make sure you have the views public PXOrderedSelect<CRQuote, CROpportunityProducts, Where<CROpportunityProducts.quoteID, Equal<Current<CRQuote.quoteID>>>, OrderBy<Asc<CROpportunityProducts.sortOrder>>> Products; public PXSelect<CRQuote, Where<CRQuote.opportunityID, Equal<Optional<CRQuote.opportunityID>

In sales quotes screen I am updating the ExtPrice of the non stock items based on some other fields by calculations. But the Amount is not changing as it does when we normally change the ExtPrice of the item. Can anyone help me here with this.

Hi Acumatica Community;decimal actualRevenueAmount = PXSelectGroupBy<PMProjectRevenueTotal, Where<PMProjectRevenueTotal.projectID, Equal<Current<Contract.contractID>>>, Aggregate<Sum<PMProjectRevenueTotal.curyAmount>>> .Select(Base) .RowCast<PMProjectRevenueTotal>() .Sum(rb => rb.CuryAmount ?? 0);I’m developing a code. I need to connect CRActivity and Contact Dacs. There was not direct Relationship between those two. I need to get CRActivity.PercentCompletion Like above code. Can anyone help me.

My background is C#, T-SQL, and ORMs like EF.  I’m continually having issues wrapping my head around the Acumatica paradigm.  Something as simple as conditionally adding a row to the DB with the user’s ID (if one isn’t present) to a custom master table (UserPriceComparison) escapes me. And then, I need to re-save the row whenever the user changes the form - and also refresh the details view.The reason for all of the above is that the complex pivot and aggregation logic I need to create is not performant anywhere except inside of a T-SQL view, which uses the values in the master table to do thing that I can’t explain here.While my instinct is to ask the question, I can predict that the first thing that will happen is that someone will ask to see my code.  Pretend I don’t have any.  This should be, what, 10 lines of code at most? private void CreateFilterWhenMissing()  // Call on load?  Or later. {     var u = PXAccess.GetUserID();     // Get the existing row for the current user     Emp

Hi Guys, just wanted to ask if the FieldUpdated handler will fire off when the field is populated via the SetValueExt method. Thanks guys,Aleks

In 2021r2, the compiler complains about obsolete PXReportTools and ReportProcessor methods.  And also, "SettingsProvider" does not have an "Instance" property so, this is causing a build error. How can I fix this? Below is the code snippet currently I’m using.      //Report Processing PX.Reports.Controls.Report _report = PXReportTools.LoadReport(“AP621C1”, null);PXReportTools.InitReportParameters(_report,parameters,SettingsProvider.Instance.Default);ReportNode reportNode = ReportProcessor.ProcessReport(_report);//Generation PDFbyte[] data = PX.Reports.Mail.Message.GenerateReport(reportNode,ReportProcessor.FilterPdf).First();

 error convert string to int in report parameters. please advice me

I Make New Scene I need List Subitem Input type , I make new DAC. I try to check the Subitem but no value if I press f3 Any . why is this even though the table subitem has a value ? This My new Screen Thi table My Sub item many value This My DAC Code using PX.Data;using PX.Objects.CS;using PX.Objects.IN;using PX.Objects.PO;using System;namespace Car{    [Serializable]    [PXCacheName("DetailDAC")]    public class DetailDAC: IBqlTable    {        #region DocumentID        [PXDBString(30, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Document ID")]        public virtual string DocumentID { get; set; }        public abstract class documentID : PX.Data.BQL.BqlString.Field<documentID> { }        #endregion        #region InventoryID        [PXDBInt]        [PXUIField(DisplayName = "Inventory ID")]        [PXSelector(        typeof(Search<InventoryItem.inventoryID>),        typeof(InventoryItem.inventoryCD),        typeof(InventoryItem.descr),        Substit

We’re trying to press the UPDATE IN action button on the shipment screen after a 2 step transfer. Steps: We create a new Sales Order with type TR. Create the shipment and goes to the Confirmed status. UPDATE IN. The button is active, it processes however the status doesnt change and the button remains active/visible like nothing happened.No customisations, and no exceptions in the Trace Log for the updateIN function?..

Hello All, I have an issue with access rights with 24R1 (no issue with 23R2).I have an action that opens custom report but it doesn’t work because of the error: "You have insufficient rights to access the object (IC970001).".I tested accessing to this screen directly from the link and got a blank screen.I have tried to change access rights to “Granted” for this report from “Access rights by screen”. Then it starts working.But when I add access rights to Customization Project and publish it I lose settings for Generic Inquires (checkbox “Replace Entry Screen with this Inquiry in Menu” is no longer selected).I also found in the 24R1 Release Notes:If a site map node does not exist in the target instance, the site map node will not be available for any roles; the access rights will be set to Revoked. That is, after the customization has been published, the system administrator should grant the access rights explicitly.In my case I have site map node (but without Workspace an category) But

How can i wrap a json response in square brackets in acumatica customization?

When I recompile my VS library, it takes on average 3 minutes or more to reload my site.In 2021, I bought a Lenovo Thinkpad (the “industrial” version).  Here are the specs on my pc:I am using Chrome as my browser.I’ve turned of IIS logging.It seems a lot slower than t used to be.  I’m wondering if I need to reset my pc and re-install everything.  Of course, that would be a royal pain.If I am debugging and trying to fix something, this REALLY annoying and feels like I spend half my day waiting for the site to reload.Is this normal?  Do I need to buy a new PC?  Any suggestions? Edit:  I’ve gone through the article on optimizing IIS as well as making the recommended changes to the web.config file.  I have a 2TB SSD.  I also read the topic That article is a year old, so I was wondering if things have changed. 

Hi, we have installed PrintCustomerRefundPkg to print refund checks which worked fine,but we recently upgraded to 2022R2 and it stopped working raising error belowi found that Acumatica updated the DAC Schema for CashAccountPaymentMethodDetail and stopped using the “AccountID” field, i updated the Relationships in the ar640501.rpx report to CashAccountID but it still didn't workmy assumption is that i need to update the subReport as this report show's the account & routing # in MICR font - which this data is in CashAccountPaymentMethodDetail tableany idea where i could find this MDMICR1.rpx report to update the Relationships? or any other solution?

Hi,Though I have added all the references and dll to the customization project and solution, I am getting the below error. Thanks,

In acumatica project screen(PM301000) i have add two custome fields. those are UsrOnBudget and UsrCompletedPrec. i need to develop when i check UsrOnBudget check box get PMRevenueBudget.CuryAmount and divide by PMCostBudget.CuryAmount And that value show on UsrCompletedPrec field. Those To Customized Field locate in CT.ContractExt. How can I achieve it?

Hi Everyone, I am getting Error in mobile App as below : Packages are published as below :I am trying to check inside the package gives same error : trying to click on below Gives same error. please provide me solution for this.   Thanks 

I’m trying to add a new DAC to the global search.  The dac is part of an an ISV product.I have customized the DAC with the following code, which seems to partially work, but it’s not displaying properly in the search results. After I run the rebuild Full Text process for this entity, I can see the data appears to look correct in the SearchIndex table, but it shows blank data in the Acumatica search results. (screenshots below)Any Ideas?  Am I missing something?ThanksScott public class IGMP_DAC_IGMPINDispatch_ExistingColumn : PXCacheExtension<IGMPINDispatch> { #region NoteID [PXMergeAttributes(Method = MergeMethod.Replace)] [PXNote( DescriptionField = typeof(IGMPINDispatch.workOrderNbr), Selector = typeof(IGMPINDispatch.workOrderNbr), ShowInReferenceSelector = true, BqlField = typeof(IGMPINDispatch.noteID) )] [PXSearchable(PX.Objects.SM.SearchCategory.All, "WO {0}: {1} - {2}", new Type[] {typeof

Does anybody already try to add Action button in this section:  

How can i change the Activity details to display on the side in the Opportunity screen (CR304000) the default view of Activity details is on the bottom of the screenhow can i change it it should show up on the side of the screen - see sample below 

Hello,I want to make some changes to fields when the Parent Account field is updated on the CustomerMaint graph.public class CustomerMaint_Extension : PXGraphExtension<PX.Objects.AR.CustomerMaint>{ protected virtual void _(Events.RowUpdated<Customer> e) { if (e == null) return; Customer customer = e.Row; if (e.Row.ParentBAccountID != e.OldRow.ParentBAccountID && e.Row.ParentBAccountID != null) { BAccount bAccount = Base.Select<BAccount>().FirstOrDefault(x => x.BAccountID == customer.ParentBAccountID); //bAccount is returned when the parent BAccount is a customer //bAccount is null when the parent BAccount is a supplier //do things } }}I’ve created an extension and I’m using the code above to get the BAccount record of the selected Parent Account. Problem is, when the Parent Account is a supplier the BAccount is not returned, when the Parent Account is a customer to works.If I add the following code, it worked for both suppliers and customers,

 I don’t see file path in add file

Hello All, I have created a class Extension to override a methd and then I want to call that class extension in a graph extension that I am overriding an action of the graph.Here is my Graph Ext:using System.Collections;using PX.Data;using PX.Objects.EP;namespace MyProject{ public class MyTimeCardMaintExt : PXGraphExtension<TimeCardMaint> { public static bool IsActive() => true; public MyEmployeeCostEngineExt MyEmployeeCostEngine; public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride] [PXButton] public virtual IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod) { // Do some stuff return baseMethod?.Invoke(adapter); } }}and here is my Class Ext:using System;using PX.Data;using PX.Objects.EP;namespace MyProject{ public class MyEmployeeCostEngineExt : EmployeeCostEngine { public MyEmployeeCostEngineExt(PXGraph graph) : base(graph) { } public static bool IsActive

If a grid column is added within code, is there a way to get its column position to persist after a user moves it - like any other grid column? I'm adding the column to the grid in the Page_Load event in a graph extension, but it doesn't seem to magically know what position it was moved like the others because it is being added each time. Could there be a setting I'm missing, or would I have to roll my own position persistence to get this to work?