Develop Customizations

Hi,I have added a custom field to the ARTran table but I am getting an error when trying to access the extension of this table to update this custom field via code.I imagine I need to replace ‘ARTran’ with something else, but not sure what it would be.Here is the code I am currently using to access this extension:var row = (ARTran)e.Row;ARTran rowExt = row.GetExtension<ARTran>();And here is the error I get:\App_Code\Caches\ARInvoiceEntry.cs(55): error CS0311: The type 'PX.Objects.AR.ARTran' cannot be used as type parameter 'TExtension' in the generic type or method 'PXCacheEx.GetExtension<TExtension>(IBqlTable)'. There is no implicit reference conversion from 'PX.Objects.AR.ARTran' to 'PX.Data.PXCacheExtension'.What do you suggest I replace ARTran with to access the custom field via the extension? Kind regards,Andrew

Hello Community, I was wondering has anyone experienced using Switch in Selector Attribute something like the one below. I know the below doesn’t work and also I have seen some lengthy posts on how to create a dynamic selector but I was hoping Acumatica has something built-in so that I don’t go the long path.[PXSelector(typeof( Switch< Case<Where<MyDAC.module.IsEqual<BatchModule.moduleAP>>, Search<Vendor.bAccountID>>, Case<Where<HCLSMFileFilter.module.IsEqual<BatchModule.moduleAR>>, Search<Customer.bAccountID>>>))] 

Hi Experts,One of our customers looking for creating customers from the mobile App.I would appreciate your response in this case. Thank you.

All users are Unable to access the Mobile App. “Server returned an error. The Type initializer for 'PX.Api.Mobile.Models.Attachments-MetaFactory' threw an exception. Has anyone seen this error or have any advice on how to resolve??

Hi, I have developed a custom screen, it’s working fine in my development instance. Then we published it in a UAT instance for testing and when we checked , it was working previously but now the screen is not visible in the workspace we added. Even the admin has the right to access this custom screen but the screen is not there. So we unpublished the customization project and removed it from the instance. Then we published again the same project package and this time the screen is not available in the project as well. we unpublished it and published again, still the screen id is empty as below.customization project in the uat instancedoes someone have an idea on this issue?Thank you in advance.

Hi,I have a customization project in my test instance and it’s working properly.We created a news instance using snapshot in the test instance and add customization projects also .But. My customization project screen is not visible in my new instance.Anyone,Plz help me

 I Need help.I Got this error after i update acumatica from 2019 r1 to 2022 r2. does anyone got the same trouble ? 

Hello Everyone,In the persist delegate, I would like the custom field inside the PXLong Run operation but value is not updating. Can anyone help me on this?If try to save again, it is re-calling the Persist method and going to the infinite loop.Here is the sample code for your reference.  public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate baseMethod) { baseMethod(); if (Base.Document.Current != null) { PXLongOperation.StartOperation(Base, delegate () { try { //my custom logic is here //Updating the custom field value below, value is holding in the caches but updating Base.Document.Cache.SetValue<SOOrderExt.usrCustomField>(Base.Document.Current, true); Base.Document.Cache.Update(Base.Document.Current);

Hello-I have created a custom table and have then created a view under ProjectEntry ext graph. However, when I try to run a script to update the values- it will not, for the life of me, update the values- I’m perplexed- I’ve never had issues with base detail tables on the ProjectEntry graph.. but now that I have a custom table it is really not liking it. See below for view that I created and then the action that I call to update the value in the cache based on a static value (just for testing). I have simplified the code down a lot for testing and de-bugging purposes, but for all intents and purposes, the same logic applies.View:public PXSelect<BlyIconPMBudget> BlyIconPMBudgetView;Action: public PXAction<PX.Objects.PM.PMProject> UpdateBalances; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Update Balances")] protected void updateBalances() { foreach (BlyIconPMBudget b in BlyIconPMBudgetView.Select()) {

Hello Everyone,I would like to add posting class selector to these filter. The screen name is Historical Inventory balance(ScreenId=IN616000). Kindly assist for it is urgently required.All responses will be highly appreciated.Thank you all.

Hi,I created a new setup form for my custom screen in the same customization project. After publishing, it’s working fine in my local instance. Now I want to add this into the UAT instance and publish my customization project, But after importing and publishing the project package, setup form is not visible in the project editor, only the custom screen which is Proforma Invoice can be seen.what is the reason for this and can someone help me to resolve this?Thank you.

Hi Guys, I’m trying to add custom column - contract Price field from service contract and display in run service contract billing screen.I added the field in Screen editor customization. created the DAC, and graph but I’m not able to view the data in run service contract billing screen.Below is my custom field. DAC,#region UsrContractTotal        [PXDBDecimal]        [PXUIField(DisplayName = "Contract Price")]        public virtual decimal? UsrContractTotal { get; set; }        public abstract class usrContractTotal : BqlDecimal.Field<usrContractTotal> { }        #endregionGraph,Public class ContractPeriodToPostEntryExt : PXGraphExtension<CreateInvoiceByContractPost>    {        #region Event Handlers        public static bool IsActive() => true;        protected virtual void ContractPeriodToPost_ServiceContractID_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e, PXFieldSelecting InvokeBaseHandler)        {            if (InvokeBaseHandler != null)             

Hi,I created a setup form(AI101000) and delete it from my project.Again i created a setup form(AI102000) and add this file into my custom screen for the automating the custom screen field.In my dev instance all are working fine.but, when i getting the export and import into the my uat instance,I can’t see the setup form screen that I created(AI102000). When .I cheking the project.xml file It still have the my deleted page name(AI101000) in the site map menu.Can anyone please support for that.

Hi, I have developed a new screen, In this screen I need to load all the locations of related customer as drop down list in the location filed to allow select and add to the field.To accomplish this, I used PXSelector attribute like below in the DAC but it is not working as expected.  #region LocationID        [PXDBString(30, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Location",Enabled =false)]        //[PXSelector(typeof(Search<Location.descr, Where<Location.bAccountID, Equal<Current<APProforma.customerID>>>>))]        [PXSelector(typeof(Search2<Location.descr,InnerJoin<Customer,On<Location.locationCD, Equal<Customer.defLocationID>>>>))]        public virtual string LocationID { get; set; }    public abstract class locationID : PX.Data.BQL.BqlString.Field<locationID> { }    #endregion Can someone help me on this?thank you. 

Hello Community,In the Bill of Material screen, I have created a new tab i.e. TEST same as the OUTSIDE PROCESS. OUTSIDE PROCESS form is refreshing according to the selection of the record in the Operations grid but my TEST tab not refreshing.Tried belowCreated Tab same OUTSIDE PROCESS tab (Native Acumatica tab) Added AutoCallBack commands  Refreshed the grid in the RowSelecting event as well but not working.Any suggestions, highly appreciated.  

Hi,     I am using Visual Studio 2019 for all my customization development. After upgrading to 22 r2 I am facing issues in creating a new custom page or opening the existing page in design mode. I am using the template provided by Acumatica 22 R1It throws the following error  Pls, let me know how to fix it.Regards,R.Muralidharan

#region UsrAccount[Account(DisplayName = "Account", BqlField = typeof(INTranExt.usrAccount), Visibility = PXUIVisibility.Visible, Filterable = false, DescriptionField = typeof(Account.description), Required = false, AvoidControlAccounts = true)]public virtual int? UsrAccount { get; set; }public abstract class usrAccount : PX.Data.BQL.BqlInt.Field<usrAccount> { }#endregionI have created a custom field with Account attribute.Account attribute has this default warning in place. I have added FieldVerifying on the my custom field. But this warning seems to override my error message. How can I show my error over this default warning I am not able to figure this out.Can anyone share some suggestions.Thanks.

Hi,I’m new to acumatica. I customized a new screen with formtab template. Inside my tab I customized a grid. This time I want to add  “Add order” button which is used to pop-up a new window (smart Panel) including all the purchase orders which are available in the POOrder DAC and select and insert into the grid when click on each order. below screenshots for the reference. the gridI have created the smart panel so far. But I need to add the values of smart panel into the grid. Can someone suggest me the way to do this or provide me any guidence resource.thank You.

Hi,I’m new to acumatica. I have a customized screen. There is a button with an action which opens a pop-up window. In this pop-up window I have loaded data from both POOrder DAC and POLine DAC. To load data , I created a view using SelectFrom attribute .But when I try to add data from the pop-up window to the grid of my customized form, I’m getting below error. 'Unable to cast object of type 'PX.Objects.PO.POOrder' to type 'PX.Data.PXResult`2[PX.Objects.PO.POOrder,PX.Objects.PO.POLine]'. Can someone help me to solve this issue please?Thank you.see the below code for reference.namespace GRIProformaInvoice.Extension{ public class APProformaEntry_Extension : PXGraphExtension<APProformaEntry> { public SelectFrom<POOrder>.InnerJoin<POLine>. On<POLine.orderNbr.IsEqual<POOrder.orderNbr>>.View POrdersView; public PXAction<APProforma> MyAction; [PXUIField(DisplayName = "Add Purchase", MapEnableRights = PXCacheRights.Selec

Hi, I have a newly created screen including a form and grid. I have modified a button to pop-up a window which consists data of POOrder and POLine tables. To load data from these two tables, I have defined a view like below.public SelectFrom<POLine>          .InnerJoin<POOrder>.On<POLine.orderNbr.IsEqual<POOrder.orderNbr>            .And<POLine.orderType.IsEqual<POOrder.orderType>>>          .View POrdersView;I want to add some values from this smart panel to my custom grid in the screen. After adding the values to the grid, when I try to save to the database, I’m getting below error. There is no field called ‘OrderDate’ in my DAC for the grid, but both POOrder and POline have ‘OrderDate’. Even I don’t try to update records in these two tables, How can I get this error? Does someone have an idea on how to solve this?thank you

Hi,I’m customizing a new screen, In my screen I have a grid with some fields taken from my customized DAC. I modified some fields with Enabled=false property because I don’t need to allow edit those fields from the UI. below example for the reference.#region Ponbr        [PXDBString(15, IsUnicode = true, InputMask = "")]        [PXUIField(DisplayName = "Sales Order Number", Enabled = false)]                public virtual string Ponbr { get; set; }        public abstract class ponbr : PX.Data.BQL.BqlString.Field<ponbr> { }        #endregion        #region POLineNbr        [PXDBInt()]    [PXUIField(DisplayName = "Sales Order Line Number", Enabled = false)]    public virtual int? POLineNbr { get; set; }    public abstract class pOLineNbr : PX.Data.BQL.BqlInt.Field<pOLineNbr> { }    #endregion But after adding them, I’m unable to change the width of these columns in the grid as required. Before modifying them , I had changed the width property in layout properties of these fiel

Hi,Can we get report export as the XML one in the acumatica? Thanks & Regards

Hello,I'd like to modify slightly the snanning workflow of the IN301020 form.The initial worklow is the following one :1°) Scan the barcode of the warehouse,2°) Scan the barcode of the location,3°) Scan the bar code of the item,4°) Scan the lot / serial number5°) Create the corresponding receipt in the confirm state.This work fine but let's imagine you have to scan hundred of objects of exactly the same item type. For each of theses objects, you have to scan the barcode of the item and then the serial number.If we were able to scan once the barcode of the item at the beginning of our scan session, and then only the barcode of the serial numbers, we would save both time and effort.I have tried to change the workflow so that, after receipt creation (step 5), we come back to step 4 : "Scan the lot / serial number" and not to step 3 : "Scan the bar code of the item".Unfortunately, even with the informations found in the documentation, the code I have written doesn't work and lead to a stac

Hi Folks,I’ve tried to attachment pin on the Bills and Adjustment screen ID AP301000 for the mobile app using below customization code, but it didn’t work after publishing customization, so some one help me on this ?   

I’m trying to set an attribute invisible using this line of code : var row = (SOLine)e.Row; if(row != null){                var rowExtension = row.GetExtension<Objects.SO.SOLineExt>();                PXUIFieldAttribute.SetVisible<rowExtension.UsrStkDispEntrp>(cache,row,false); }   but i’m getting this error : 'rowExtension' is a variable but is used like a type thanks.