Develop Customizations

HiI’d like to create a new Mailing ID but I could not find the screen where these records are managed. Is this possible? (they can be selected via the Customers screen, on the Mailing & Printing tab) I did find the table used to store the Mailing ID records: NotificationSetup. The existing records were created by screen SM209900, but I couldn’t load this screen via the UI.Have experimented by adding a record manually to NotifiationSetup via a DB script, seems to work but not sure if this is a recommended approach.My other option is to override an existing Mailing ID, which is my Plan B at this stage.  ThanksJames 

Default length for value field is 255 in CSANSWERS table. We are getting cast error after we extend DAC to 500. Since the field is shared with different control types. So what could I do to extent the field length to allow longer text for Text type attribute? Thanks.

Hi all,Previously I have asked a similar question on this. In DataSource of the page in Customization Project Editor, setting the PageLoadBehavior to ‘GoLastRecord’ solved this issue only when using Web Application.But when we use mobile application it is still showing the list of records instead of last record.Is there any way to add this behavior to Mobile application as well? Thanks

I will need to do this in four different Graphs, but let’s start with the most common one: Sales Orders.When entering an InvertoryID in Sales Order Detail (SOLine) Acumatica does a search inside VendorID --using the InventoryCD as well as Inventory Description-- as they enter the item: My customer has two more fields they would like to also search on. But these fields do not exist in the default InventoryItem DAC. There is a post on StackOverflow that describes how to add columns to the search (I think) ...public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry>{ public override void Initialize() { base.Initialize(); //for InventoryID lookup CR.CRAttributesFieldAttribute.Activate(Base.Caches[typeof(InventoryItem)]); PXSelectorAttribute.SetColumns(Base.Caches[typeof(SOLine)], "InventoryID", new string[] { "InventoryCD", "Descr", "itemClassID", "Color_ATTRIBUTES" }, new string[] { "InventoryCD", "Descr", "itemClassID"

Hi, i have created a Methord that Pulls Soline items, i want to throw Error for certain conditions in that methord, How can we Achive that?

I list of item show in PXSmartPanel grid panel, the navigation can move next or previous when i don’t selected item. When selected item and click move next or move previous, the navigation disable like above image. Please advice me what’s i missing ? 

Good day every one,In my customization I have extended the KitAssemblyEntry (KitAssemblyEntry_Extension) and added an event handler to the release action: [PXOverride] public PXAction<INKitRegister> release; [PXProcessButton(CommitChanges = true)] [PXUIField(DisplayName = Messages.Release, MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Update)] public virtual IEnumerable Release(PXAdapter adapter) { //Base.Document.Ask("Application date does not equal to Business date, do you really want to release payment?", MessageButtons.OK); INKitRegister kitRegister = (INKitRegister)Base.Caches[typeof(INKitRegister)].Current; InventoryItem inventoryItem = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, kitRegister.KitInventoryID); inventoryItem.Descr = "Update from Kit Assembly"; // Update t

Does anyone know if it would be possible to create a tab on a document (sales order) where the entire tab is an iframe displaying an external website?Any example customization/code would be appreciated if you have an idea on this. Thank you!

Hello, the following code works in version 22.215.0056 but it doesn’t work in version 23.105.0016UploadFileMaintenance upload = PXGraph.CreateInstance<UploadFileMaintenance>();NoteDoc doc = upload.Select<NoteDoc>().First(x => x.NoteID == fromNoteID);if (doc == null) return; //no file attached - exitGuid g = ToGuid(doc.FileID); //this just converts guid? to guidPX.SM.FileInfo sourceFile = upload.GetFile(g);In the older version upload.the GetFile method works and returns the details of the file to the sourceFile variable. In the new version the GetFile method always returns null. I’ve checked the guid and the file I would like to access does exist in the UploadFile table. Is there a new way to access files in the newer versions for Acumatica?ThanksSteve

Hello everyone!, I hope you are fine.It's me again and I wish you could help me. I need to know if I can create a projection with a query table and save values ​​in its fields in the other table. Can you help me solve this question?

Hi All,In my custom screen has a PXGrid which is empty in the beginning. After I add new record and press the Verify Vendors button (Some validation is added) then another new empty row added to the grid automatically. Can someone help me out to avoid this scenario?Following is my custom screens and button click event.Before the click event After the click event Button click event  public PXAction<HMRCVendorRegisterDetail> VerifyVendors;         [PXButton(CommitChanges = true)]         [PXUIField(DisplayName = "Verify Vendors", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]         protected virtual IEnumerable verifyVendors(PXAdapter adapter)         {                         foreach (HMRCVendorRegisterDetail vendorRegisterDetail in VendorRegisterDetail.Select())             {                                 if(vendorRegisterDetail.UsrSelect == false)                 {                     VendorRegisterDetail.Cache.RaiseException

Usually we are directed to Add new record when we navigate to specific screen in Acumatica. But I want to redirect user to last record when user initially navigate to that screen.Also, please note that this is a new screenIs there any way to do this?

Hello Community,I have been trying to add a Contact selector field in the Stock Items (IN202500) but looks like there’s something I am missing here. Can anyone guide me out what else I am missing here?Code Attribute:[PXDBInt][PXUIField(DisplayName = "Contact", Visibility = PXUIVisibility.SelectorVisible)][PXSelector(typeof(Search<CRContact.contactID>),    new Type[] {         typeof(CRContact.contactID),         typeof(CRContact.fullName),         typeof(CRContact.email)    },    SubstituteKey = typeof(CRContact.contactID),    DescriptionField = typeof(CRContact.fullName),    CacheGlobal = true)]​​​​​​​

I am overriding the Process Shipments screen by adding a custom filter.  For testing, I created a “Five” class and if I put Five instead of @P.AsInt, it works great. In the PXSelectBase command, I am able to put @P.AsInt in the statement, but I don’t know how to pass in my value.  How do I pass in the value to the @P?This is the “Five” class which returns an integer 5.    public class Five : PX.Data.BQL.BqlInt.Constant<Five>    {        public Five() : base(ICSConstants.Five)        {        }    }This is the command I am overriding                                    cmd = new                                        SelectFrom<SOShipment>.                                        InnerJoin<INSite>.On<SOShipment.FK.Site>.                                        InnerJoin<Customer>.On<SOShipment.customerID.IsEqual<Customer.bAccountID>>.SingleTableOnly.                                        LeftJoin<Carrier>.On<SOShipment.FK.Carrier>.    

Hi, I have created some custom fields in the Invoices and Memos screen, and in the report designer, I can see that they appear in the ARInvoiceExt table, as shown below. However, when I go to include one of these in the report, nothing seems to appear. I also tried joining the ARInvoiceExt table to the ARInvoice table by RefNbr but that didn’t seem to help either. The custom fields on the right of the image below are what I am trying to pull through: What is the best way for me to get these custom fields to pull through in the report? Kind regards,Andrew  

I want to calculate TotalKHR field include with tax amount. so how to calculate tax from tax category.

How do I unpublish all customizations via Postman? I am a newb to the Postman platform (just installed it), but I have broken my instance, all screens come up blank, and need to unpublish via Postman if possible. If someone could send me a screenshot/walkthrough of what I’m needing, I’d be super appreciative!

    [PXDBInt]    [PXRestrictor(typeof(Where<InventoryItem.itemType, Equal<INItemTypes.nonStockItem>>), "Non-Stock Only")]    [PXSelector(typeof(Search<InventoryItem.inventoryID>),typeof(InventoryItem.inventoryCD),SubstituteKey = typeof(InventoryItem.inventoryCD),DescriptionField =typeof(InventoryItem.descr))]    [PXUIField(DisplayName = "Item ID")]    public virtual int? UsrItemID { get; set; }    public abstract class usrItemID : PX.Data.BQL.BqlInt.Field<usrItemID> { }I should show Item ID

Bakground:I have a business need that requires tracking and storing changes made to Projects Cost Projection which is way beyond the Acumatic’s out-of-box features and functionality. I tried to customize Acumatica’s out-of-box screen but the changes where too much and also I faced screen crashing almost every other time loading the screen or making changes as it was very very very slow . So I decided to create a brand new screen. The performance of this new screen is much better than out-of-box customized one but still is not satisfactory from my perspective. Below I have attached the screenshot of the new screen. On a side note there are more columns in the screen and about 450 Lines in the Parent Grid:  Business Logic:As you can see the screen has 3 major DataViews. From Top I will call them here “Form”, “Parent Grid” and “Child Grid”. The “Parent Grid” is all read-only values and all of them are Bound fields stored in DB. When User wants a New Projection either copies one of the pre

Hi, Need to know how to show an error or warning message on grid row. Can someone help me out?Here is my sample codepublic PXAction<HMRCVendorRegisterDetail> VerifyVendors;        [PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Verify Vendors", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]        protected virtual IEnumerable verifyVendors(PXAdapter adapter)        {                        foreach (HMRCVendorRegisterDetail vendorRegisterDetail in VendorRegisterDetail.Select())            {                                if(vendorRegisterDetail.UsrSelect == false)                {                    //Need to show a error message on paricular row                }                else                {                    //Logic                }                                               }            return adapter.Get();        }Thanks 

Hi all,In Payments and applications screen, I want to load corresponding invoices automatically when we updating customer. Although it should work as default, it is not working.Is there any configuration that I should do to enable this? or Can I do that using a customization? Any idea on this?

Hi all,I have defined a key field in my newly created DAC as follows#region RefNbr [PXDBIdentity(IsKey = true)] [PXUIField(DisplayName = "Ref Nbr")] public virtual int? RefNbr{ get; set; } public abstract class refNbr: PX.Data.BQL.BqlInt.Field<refNbr> { }#endregion This is how I defined it in DB ScriptRefNbr INT NOT NULL AUTO_INCREMENT UNIQUE, In my Screen it shows Like this initially before record is saved. But After it is saved it shows the actual RefNbr like (1,2,3….) How can I stop showing this as a negative value. Can I show that as <New> instead of this negative value before saving the record. Thanks

I am trying to change the “Create Appointment” button on the Service Order screen so it opens up in a new window instead of the current. Is there a way I can only override part of the action?

Hi Team,Can someone tell me how to show Error/Warning message box?Here is my codeprotected void HMRCAPIConfigDetail_Active_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)        {            var row = (HMRCAPIConfigDetail)e.Row;            var activeAPIConfigs = ActiveAPIConfigs;            if(activeAPIConfigs != null)            {                row.Active = false;                throw new PXException(Messages.APIActiveErrorMessage);            }        }Thanks

Hi Team,How to pass customized field values from Sales Header to shipment Header?Currently I overrided “CreateShipmentFromSchedules” to pass the customized field values from Sales Line to Shipment. But i cannot find a way to pass the values for headers.Could you please help me on this.Regards,Ramya