Develop Customizations

Hi,I have developed a new report in acumatica.I need to the create variable and need to the add above highlighted fields into the variables.and then all the values i need to the show in the header level.Can u please give the suggestion to that.

I have read through several posts here but am still have a problem trying to put the sum of a column from multiple rows of a grid into a header column. I have seen code snippets, however, I think I am not arranging my code correctly.I am still very new to Acumatica coding.    Below the error message is the full CS code I am using.  Everything validates and compiles, but when I try to access the Cases screen I receive this error message.  So I obviously do not know where and what I need to do here.Can someone point me in the correct direction?What I am trying to do is on the Cases screen, use the Relations tab to associate Invoices to a Case and then in a new grid populate that grid with all of the invoice information from the Relations tab. (the other problem I have is that the new grid called “CAM Relations” only lists one invoice at a time, but that is a different problem not for this topic; unless dear reader you know what I am doing wrong there also).Then I have a UDF in the header

Ive developed a custom SQL view and associated DAC which generates a table of available quantities of stock kits.Im trying to show the Qty in the Sales Order by adding PXDBScalar to the SOLine DAC detail screen however I keep getting null?  namespace AutoKitAssembly{  public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>  {        #region UsrKitQtyAvail        [PXDefault(TypeCode.Decimal, "0.0")]        [PXDBScalar(typeof(Search<KitAssy.qtyAvail,            Where<KitAssy.builtItemID, Equal<Current<SOLine.inventoryID>>,                And<KitAssy.siteId, Equal<Current<SOLine.siteID>>>>>))]        [PXUIField(DisplayName = "Kit Qty Available")]        public virtual int? UsrKitQtyAvail{ get; set; }        public abstract class usrKitQtyAvail: PX.Data.BQL.BqlInt.Field<usrKitQtyAvail> { }        #endregion  }}  

I have a custom mater-detail screen and all standard action buttons including Copy & Paste. When I try to copy and paste an existing dataset to a new form, I get an error. I was wondering does Acumatica’s engine itself handles the copy and paste operations or I should write a custom code for it?

Hi expert.I want Show Total Line Show Pages Nbr - Calculate Depreciation FA502000 (same in Sale Orders Screen). Can you help me? Very thank everyone.Reference topic: Same topic

Hello Community,Does anyone know how to prioritize loading the extensions? Let's say I have two or more extensions on a base graph. How we can educate the platform on which one should be executed first and which one next? or necessarily I should declare my Graph Extensions hierarchical? For example, if I have a MyExtA that has priority over MyExtB I should do public class MyExtA : PXGraphExtension<BaseGraph> {}public class MyExtB : PXGraphExtension<MyExtA , BaseGraph> {}

I imported and published a customization project package which I received from another. When I proceed to project folder of the instance that I imported the package there are no any .cs files only the moveControl folder.Please check the below image.Project folder of the imported customization project packageProject Editor Screen of the imported project package  But I want to obtain the .cs files of this imported package like in an ordinary customization project in my local instance as follows. Can you please give me some guidance to obtain code files of this imported package? Thank you.

Hi,I have to  get Account Id ,Transaction Description from APTran Table  and adjusted amount from ApAdjust Table for my Payment Voucher Report.I need to join ApPayment Table with APAdjust Table and ApTran Table.1st I joined ApPayment Table(column - RefNbr) and ApAdjust Table(column-AdjgRefNbr) below like that. Then I joined ApAdjust Table(column - AdjdRefNbr) and ApTran (column-RefNbr)Table below like that.But,After adding 2nd join report designer show below error. If we remove the second join error is gone. Can you give the solution for this issue.Thanks

Hello,We are getting started and I would like to learn how to create Generic Inquiry and how to customize dashboards for users. Does anyone know of any tutorials or guides on creating them and some useful GI so I can start learning how to create them.Thanks

Hello,I am currently going through training, trying to generate a custom object and have it be able to be interfaced via the workflow engine ui. However, when I attempt to add a field to the “State Identifier” field on the workflow interface, it does not return any available values. I plan to debug.. but figured I would put this on the community to see if there is something that immediately jumps out that I’m doing wrong.  Thanks in advance, code snippet for DAC and Graph below.Note: I realize that I’m taking a shortcut by not creating a helper class for the status values (perhaps to my detriment).. figured I would give it a shot before I go the effort to build out entirely.If I were to guess at what the problem is, I’m either not decorating the DAC or field with an attribute to signal to the engine that its a valid field to build the workflow off of. I’m trying to get away from having to code the workflow by hand.DAC:using System;using PX.Data;namespace BlyTestObject{ [Serializable]

I currently have the scan move screen customized to flow into the Qty State automatically to allow for a qty to be scanned in.However I would like the user to have the option to hit enter and skip the step, which would ideally pass a default qty of 1.The issue I’m running into is that the barcode field won’t allow the user just hit enter to pass a null value.Is there a way I can have null values passed through on that field?Thank you.

public class NewTest : PXGraph<NewTest> { public PXFilter<TestFilter> Filter; public PXCancel<TestFilter> Cancel; public PXFilteredProcessing<APPayment, TestFilter, Where< APPayment.docType.IsEqual<TestFilter.docType.FromCurrent>. And<TestFilter.fromDate.FromCurrent.IsNull. Or<APPayment.adjDate.IsGreaterEqual<TestFilter.fromDate.FromCurrent>>>. And<TestFilter.toDate.FromCurrent.IsNull. Or<APPayment.adjDate.IsLessEqual<TestFilter.toDate.FromCurrent>>>>, OrderBy<Desc<APPayment.createdDateTime>>> CheckPayments; [PXHidden] public class TestFilter : IBqlTable { #region IsVoid [PXString(3, IsFixed = true)] [PXUIField(DisplayName = "Doc. Type")] [PXDefault(APDocType.Check)] [PXStringList( new string[] { APDocT

Hi,I need to know, If I created a DAC extension table for the POline table and create a orderType field for the DAC extension.Is it possible to get same orderType column data inside in the POLine table into my DAC extension orderType field.ex: POline row 1 OrderType is ‘standard’ and My DAC extension orderType is same to with ‘standard’ type.? 

I’m starting to get really frustrated with processing screens lately, but maybe I’m just bad at making them. The latest frustration is that when I use ProcessingView Lines, the screen looks like a processing screen: But when I use  ProcessingView.FilteredBy<PODDocumentsFilter> Lines, all the processing tools  go away: I have defined the data view like this:public PXCancel<PODDocumentsFilter> Cancel;public PXFilter<PODDocumentsFilter> Filter;[PXFilterable]public SelectFrom<SOPackageDetailEx>. InnerJoin<SOShipment>. On<SOPackageDetailEx.FK.Shipment>. LeftJoin<ISSOShipmentTrackingPOD>. On<ISSOShipmentTrackingPOD.FK.PackageDetail>. Where< SOPackageDetailEx.customRefNbr1.StartsWith<fedEx>. And< Brackets< PODDocumentsFilter.action.FromCurrent.IsEqual<actionDownload>. And<ISSOPackageDetailExExt.usrIsPODDownloaded.IsEqual<False>. Or<ISSOPackageDetailExExt.usrIsPODDownloaded.IsNull>>. Or

We’ve noticed this a few times at different clients but I don’t have a smoking gun to bring in tech support so I’m looking to see if anyone else has had similar experiences.When there has been an update due to Windows/IIS/SQL security patches, or some other update on the Acumatica side, that we find that sometimes a customization project has reverted back to a prior version. We’ve seen source code within the project revert and we’ve seen cases where a DLL appears to have reverted back one version.Last night our clients production site had some updates and this morning they called with some configuration related issues. We checked on fields in a setup screen and discovered that some fields were blank causing invoices to be missing a default cash account value. These fields were populated the day before because it prevents invoices from being posted. We filled in the missing values and everything went back to running smoothly - like it has been for weeks.Like I said, we don’t have a smok

Has anyone created or attempted to create a customization that would provide a user interface where an Excel file containing multiple rows of PO Receipt information could be used to generate multiple receipts based on a PO Number being associated with each row?  Basically, a grid interface like is typically seen in various components of Acumatica wherein a “user” simply imports the desire info.  This would alleviate the need to use an import scenario, which we do not want most users to touch.  It would be a tremendous efficiency gain for those processing PO Receipts.  Currently, my users have the worksheet and they have to split the information out into separate files to perform the grid level import for each individual PO Receipt.  I’m hoping someone else has thought of and created such a customization.  I’m too new to Acumatica to create what I believe is a more complex customization.

Hello, I’m struggling with the FieldUpdated event. On the Project Quotes form (PM304500) you enter Inventory IDs on the Estimation tab. When you commit an Inventory ID on a grid row, the description, uom and unit price are returned. Very similar to entering products onto a sales or purchase order. I would like to ignore the default price returned and update the field with my own value. The screen shot above shows that when SOFTLIC was entered the unit price was defaulted to 666.00I’ve tried using the following (heavily cut back) code to update the unit price field but it’s not working, 22 doesn’t appear in the field: protected void CROpportunityProducts_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (CROpportunityProducts)e.Row; string val = "22"; cache.SetValueExt<CROpportunityProducts.curyUnitPrice>(row, val); }I’m pretty certain that there is another event in the Acumatica code which is firin

I added a few selector fields as UDFs in Cases. As you can see in the screenshots, when accessing in the web, the selector field works. But in the mobile app, there is no magnifying glass icon for me to select the options. Instead, it’s just a text type field… Am I missing something easy or does this functionality require customization to the mobile app?  

Hi expert.I want Show Total Line Show Pages Nbr - Convert Purchases to Assets FA504500 (same in Sale Orders Screen)Can you help me? Thank you so much.

Hello All,I am wondering how is the relationship between Acumatica Customization Projects (ACP) and C#.  Shoulda) each ACP be translated and linked to a “Solution” in C#? or b) we can have multiple “Projects” in a single C# “Solution” and bind each ACP to a “Project” in a “Solution” not a “Solution” itself?When I try the second option to bind an ACP to a “Project” it apparently is searching for a “Solution” and not allowing me. If I am to create many “Solutions” to have one-to-one relation between ACP and C# solutions, my customization solutions will be too many. How you guys are managing your Customization Projects?

I have a custom maintenance screen and a related custom table.  There is a field I want to use as a selector on other custom screens.  On the maintenance screen where you maintain the items for the selector, the field is showing a selector on it.  DAC Field:        #region NCRDispCD        [PXDBString(2, IsFixed = true, IsKey = true)]        [PXCheckUnique(typeof(SSGNCRDisp.nCRDispCD))]        [PXUIField(DisplayName = "Disposition CD", Visibility = PXUIVisibility.SelectorVisible)]        [PXSelector(typeof(Search<SSGNCRDisp.nCRDispCD>),            typeof(SSGNCRDisp.nCRDispCD),            typeof(SSGNCRDisp.description))]        public virtual string NCRDispCD { get; set; }        public abstract class nCRDispCD : PX.Data.BQL.BqlBool.Field<nCRDispCD> { }        #endregionI tried making this field without a selector and adding the selector in the cache attached of the other screens but that didn’t work and seems like a bad way of trying to do this.  In the Project Editor, I ca

Hello I want to set the avg  field value with a desired value as seen in the below screen.But It is being applied.   I am handling it on FieldUpdated.tCode Example:        protected void _(Events.FieldUpdated<INItemSite, INItemSite.inventoryID> e)        {                      if (e.Row.InventoryID != null)            {                ………….                    e.Row.AvgCost = (decimal?)100.00;            }        } The problem is Avg Cost field is having the PXDBPriceCostCalced attribute , therefore its not setting my desired value.public abstract class avgCost : PX.Data.BQL.BqlDecimal.Field<avgCost> { }protected Decimal? _AvgCost;[PXPriceCost()][PXDefault(TypeCode.Decimal, "0.0")][PXUIField(DisplayName = "Average Cost", Enabled = false)][PXDBPriceCostCalced(typeof(Switch<Case<Where<INItemStats.qtyOnHand, Equal<decimal0>>, decimal0>, Div<INItemStats.totalCost, INItemStats.qtyOnHand>>), typeof(Decimal), CastToScale = 9, CastToPrecision = 25)][Cur

Hello guys, I need help and I don't know why it doesn't do what I want, I have it published in this link since it won't let me go through this medium. I am modifying the AP screen, mass release, inside it I am inserting a new line of the existing document in detail and at the same time I am creating a new credit adjustment. https://stackoverflow.com/questions/76018096/modification-of-the-screen-when-releasing-ap-documents-2022r2

I have a pair of DACs that are in a loose header/detail relationship. It isn’t directly parent/child but the header and detail fields are joined by shared data value, like a transaction number.The header DAC is linked to a field on SOLine using the same transaction number value.If the user attempts to delete the SOLine record, I want to check to see if it is okay to delete the related Header DAC. The Header DAC, in turn, needs to see if the detail DAC records can be deleted.If the Header DAC and Detail DAC records can be deleted, then I’ll let the SOLine.RecordDeleting event continue. If there is a problem, I’ll set e.Cancel = true.My question is - in what event should I do the deletion of the related DACs?  I need to instantiate a PXGraph for the Header and for each of the Detail records (each one could be a different PXGraph) because there are other tables that need to be updated.I’m not supposed to be creating PXGraphs in event handlers (I believe).Do I do this in SOLine.Persist whe

Hi expert. Have a nice day.I custom PXSelector field in below image. I want search on both columns(Description and Asset ID).I try code: [PXSelector(typeof(Search<FixedAsset.assetCD>),typeof(Search<FixedAsset.description>))]but system build error:Can you help me this case? Thank you so much.