Develop Customizations

I am trying to attach a file one specific report to the shipment record when the shipment is confirmed. Can anyone here help me with the flow on how to do this with a customization.  Thanks

This is a custom-made screen and by clicking the “PRINT REPORT” button a custom made report can be executed. But now when click the “PRINT REPORT” the above message popups as in the above screenshot. Can I know how to troubleshoot this?

Is there a way to customize/add data on this shipping label?

Dear Team,How to enable “Create Sales Order” and “Create Invoice” features in Opportunies screen ?    Note: Acumatica Version 2020 R1 Best Regards,NNT

Hello all, I have come across a wierd situation. In my extension to “EPWeeklyCrewTimeEntry” screen “EP307100” I simply want to rename one of existing grid columns to match with my import excel file column name. So I have added a CacheAtached event that works fine. Column is renamed, user does normal data entry, saves and so on. The problem I am facing surfaces itself when I use “Upload” button to import from Excel. The uploads works as meant to work and imports all data correctly BUT at the end shows a dialog saying “Unable to cast object of type 'PX.Objects.CR.BAccount' to type 'PX.Objects.EP.EPEmployee'”. If I click OK I still can save the imported data without any issue but after spending couple of hours, I can’t seem to figure out why this errors is thrown at the end when everything is imported correctly. If I comment the event code I do not receive this error. I have tried both old and new syntax, tried Append, Merge and even Replace the attributes and on all of them I get the sam

FYI, self taught, have a lot of python backgfround and now trying to learn C# with Acumatica. So I have a a PXFilter View and I have populated it with some data from the T100 Acumatica local installation. When I debug I can the information is in it but one row of data is under the Current folder and the rest of the rows are in the Inserted folder. Here is a screenshot. For some reason when I pass it to the FormGrid on the UI only the row from the Current folder shows. See here.  Here is a screenshot of the Customization showing I have the CombinedView set as the datamember for the grid.  Does anyone know what I am doing wrong and why the rest of the rows are not populating? --UPDATE--I just found a different spot in the View that has the same Current folder with same data. I am not sure what this is used for as it is outside of the cache. 

Hello, I want to display a pop up message when the quantity is entered on a sales order line if a condition is met. I have the following:protected virtual void _(Events.FieldUpdated<SOLine, SOLine.orderQty> e){ SOLine row = (SOLine)e.Row; if (row == null) return; if (row.Qty > 10000) { WebDialogResult res = Base.Document.Ask("Warning", "This is a large order", MessageButtons.OK); }}This works, as shown below. I enter a sales order and the message appears.  The problem is that the message also appears when a Sales Quote as converted to a Sales Order.This makes sense since the SOOrderEntry is used to perform the convertion. Is there any way to check whether the UI is being used to enter the sales order, or to check which graph has called the SOOrderEntry graph? Thanks

Hello everyone,I have created a tab called fulfillment, I need it to display Normal Purchase Orders  and the corresponding purchase receipts that fulfilled the blanket order. I have tried to find any data or fields I could use to link the tables in order to get the required output. But haven't found enough to enable achievement.could anyone be having an idea on how I go along to achieve this?kindly assist.Any kind of response will be highly appreciated

I would like to enable / disable the command button below ASSEMBLE KITS REQUEST based on the checkbox Auto Assemble Kits (UsrAutoAssembleKits). The command button is linked to an action and working correctly thanks to @Naveen Boga.. I assume its connected with the Field_Updated event. the ID for the command button is CMD3namespace PX.Objects.SO{ public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public PXAction<PX.Objects.SO.SOOrder> UsrKitsAssembleReq; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Assemble Kits Request")] public virtual IEnumerable usrKitsAssembleReq(PXAdapter adapter) { if (Base.Document.Current != null) { SOOrderExt soOrderExt = Base.Document.Current?.GetExtension<SOOrderExt>(); SOOrder soOrder = (SOOrder)Base.Caches[typeof(SOOrder)].Current; if(soOrder.OrderNbr.Contains("NEW") == false){

Should user-defined fields be created using a customization project or just adding them directly into Acumatica is fine? I have not setup a customization project before but I have heard that creating customizations within a customization project is recommended since you can apply and unapply with the upgrades. I am trying to consider if there will be any issues with upgrading and user-defined fields. 

Hi,I want to create a JSON body when user clicking the REMOVE HOLD in PO Screen.public IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod){ RootObject obj = new RootObject(); obj.OrderNbr = order.OrderNbr?.ToString(); obj.PromisedOn = order.ExpectedDate?.ToString(); obj.Status = order.Status?.ToString(); foreach (PXResult<POLine> result in polineIntview.Select()){ POLine line = result; Details detail = new Details(); detail.Amount = line.CuryExtCost?.ToString(); detail.CustomerOrderNbr = SOOrder.PK.Find(Base,"SO",line.SOOrderNbr).CustomerOrderNbr?.ToString(); detail.DiscountAmount = line.CuryDiscAmt?.ToString(); detail.DiscountPercent = line.DiscPct?.ToString(); if (obj.Details == null) obj.Details = new List<Details>(); obj.Details.Add(detail);

 When i publish my customization to print labels from the shipment screen and publish to multiple tenants, The forms show on the screen in both tenants as expected.   However they will only show in the actions web services for the main tenant.  But are missing from the other tenant  Any idea what is cause this … this is keeping me from showing the forms on the mobile for the other tenants .

Hi,I am trying to add a new custom checkbox field as a grid column in the Process Shipments screen called UsrRequiresInvoices, and this custom field resides in the BAccountExt DAC. I imagine I would need to create a custom DataView that pulls in this field, but I wasn’t sure if I needed to structure it in a certain way to ensure the Process Shipments screen still functions as expected. The image below shows how the custom field is currently sitting in the Customers screen. The reason for this field is to identify customers that only want the final shipment invoice to be sent to them without receiving a Shipment Confirmation beforehand. If it is possible to add this custom field as a column via a custom DataView, what would be the best way to structure it? Let me know if I can provide any further information on this. Kind regards,Andrew

Hi,I’m wanting to extend SOInvoiceFilter on Process Invoice and Memos (SO505000) to enable filtering on Customer Class.  Have made a start and think I’m mainly on the right track but have a problem I can’t quite crack.  Think the answer to this should be relatively simple.So far, I have extended SOInvoiceFilter  as shown below to add a selector for Customer Class: Have added the new Customer Class selector to the Form with Commit Changes = TrueHave extended the graph: The above is all the changes I have made so far.  What is happening is on changing any of the fields in the filter, I get: I think that the issue must be that BQL in the graph extension is not correct, but I can’t spot the issue.Any help would be greatly appreciated.  Also, I’m not 100% sure on what other steps will be required to get the extended filter to work on the grid so any pointers on that would also be helpful. My thinking was I would need to override GetInvoices() so that it returns records based on the SOInvoic

Hi guysHow do I add import and export functions to my customized screen tool bar on clipboardas shown in the shot thanks. 

Hello,We are working with the WMS functionality and the message text shows the KEY (CD value) which is useless if you don’t have intelligent numbering. If we are trying to get away from paper (true paperless) we need the ability to expose both the KEY and the Description of the stock item in the message shown on the main screen of WMS on mobile. It looks like there are two options-Try to figure out how to update the message to show KEY - Description. I don’t know how much effort this would be but I imagine a lot since there are a lot of different strings that get created in the message box. Find the current pick line (I believe this corresponds to the WantedLineNbr on the ScanHeader DAC) and then retrieve the inventory id on the SOPickerListEntry and expose to the header to show as a new field on the mobile header.I have done some tinkering on the dev side and realized that the WMS was apparently rewritten recently and so a lot of the attributes/fields/functionality I’m looking to inte

How to get stock items which are checked by custom checkbox using $Filter parameter.

Hi,Need to know how to clear existing error and warning messages in the UI. As per my screen example, I set some exception messages based on the logics inside the Verify Vendor Button event. So, I need to clear the existing validation error once it’s filled correctly. Thanks

I want to add the item class on in the Catalog grid in the portal. I want to add custom filters to the screen.Populating the field with a rowselected or initializing wont work because I need to filter the value.  I have try adding the field in a extension file but the field keeps giving back 0 as the value, any idea what I could be doing wrong?namespace SP.Objects.IN{      public class InventoryLinesExt : PXCacheExtension<InventoryLines>    {        // Here i tried adding a new field to link with the current line inventoryID        #region UsrCustomField        [PXInt]        [PXUIField(DisplayName = "Item Class")]        [PXDefault(typeof(Search<            InventoryItem.itemClassID,            Where<InventoryItem.inventoryID, Equal<Current<InventoryLines.inventoryID>>>>))]        public virtual int UsrItemClass { get; set; }        public abstract class usrCustomField : PX.Data.BQL.BqlInt.Field<usrCustomField> { }        #endregion           // her

Im trying to click on a simple command button on the SOOrder screen that sets another bound boolean field on the form. The comman button seems to fire but I cant seem to get the checkbox boolean field to set and update the database? Please help!! PXAction logic after clikcing ASSEMBLE KITS REQUEST (exception gets thrown “Request Sent”) public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public PXAction<PX.Objects.SO.SOOrder> UsrKitsAssembleReq; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Assemble Kits Request")] public virtual IEnumerable usrKitsAssembleReq(PXAdapter adapter) { SOOrderExt1 soOrderExt = Base.Document.Current.GetExtension<SOOrderExt1>(); Base.Document.Cache.AllowUpdate = true; Base.Transactions.Cache.AllowUpdate = true; soOrderExt.UsrKitsAssembleReq = true; throw new PXException("Reques

How can I turn on File Attachments Drag and Drop functionality on custom Data Entry Documents(Header)?

Hi All, I have created a projected DAC as follows.   [Serializable]  [PXCacheName("ProjectedSOLines")]    [PXProjection(         typeof(Select2<SOLine,        InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>,            And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>>>), Persistent = true)] public partial class ProjectedSOLines : IBqlTable  {        public abstract class orderNbr : PX.Data.BQL.BqlString.Field<orderNbr> { }        [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC", BqlField = typeof(SOOrder.orderNbr))]        [PXSelector(typeof(SOOrder.orderNbr))]        [PXUIField(DisplayName = "Order Nbr.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]        //Other attributes like PXSelector        public virtual String OrderNbr { get; set; }    #region Status    public abstract class status : PX.Data.BQL.BqlString.Field<status> { }    [PXDBString(1, IsFixed = true, BqlFiel

Hi everyone,I have been assigned to create a new order type for Purchase Orders screen and do use a custom numbering attribute for a certain type.So when I created a new numbering sequence and the necessary code below, but when I try to select a vendor from the selector I get this error:the code looks like this:for the POSetup’s DAC Extension: for the new numbering Sequence:And for the POOrder Extension: For the POOrderTypeExtension: For the CustomNumberingPOAttribute:So if you guys can possibly point out something that I might have been missing, I would really appreciate it. Looking forward to reviews from the amazing community.

Hello All,If I am not mistaken, Acumatica introduced “IsInSubselect” & “IsNotInSubselect” with FBQL which is the Equivalent of “IN” and “NOT IN” of SQL. When we use these two functions it is translated to SQL correctly but they have a deadly flaw. This flaw impacts the whole result and when you expect to have thousands of records you get NONE. Look at the two below SQL queries (just logic, do not think what a stupid query). Please note I can NOT use Join//#1SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT DefPOAddressID FROM BAccount WHERE DefPOAddressID IS NULL)//#2SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT ISNULL(DefPOAddressID, 0) FROM BAccount WHERE DefPOAddressID IS NULL) Both queries are instructing SQL to return all vendors which do not have DefPOAddressID but the first query returns none while the second one in my case over 2,000 and this is what I expect to get. The only difference is the ISNULL wrapping. Acumatica translates its queries to the first one so I

I’m trying to update an attribute value on appointments in Postman but the value will not update.Here is my PUT request:{{acuBaseUrl}}/Appointment?$filter=ServiceOrderType eq 'PM' and AppointmentNbr eq 'SV001280-1'&$expand=Attributes&$select=AppointmentNbr,Attributes/Attribute,Attributes/ValueHere is the body:{    "ServiceOrderType": { "value": "PM" },    "AppointmentNbr": { "value": "SV001280-1" },    "Attributes":     [        {            "AttributeID": {"value": "Is Inspection Complete?"},            "Value": {"value": true}        }    ]}I’m not sure what else needs to be done.  I’ve also tried using the Attribute ID of INSPECTED but it still won’t update.  I’m using the Default/22.200.001 endpoint.