Develop Customizations

Hello, I am currently trying to add a smart panel that just shows other orders a customer has placed. I used this vlog as a guide: https://www.acumatica.com/blog/vlog-changing-an-acumatica-po-number-with-a-smart-panel-and-custom-action/It got me most of the way there. Currently I have the dialog box popping up and I am able to close it. In the code I can see that I am pulling all orders that a customer has made. However, the grid in the dialog box only shows one item in it and I am not exactly sure why that would be. I thought it might be related to this other forum post:  But since I am seeing something in my grid, I think I am making a different mistake. namespace PX.Objects.SO { // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry> { public PXFilter<MSCustomerOrderDac> MSCustomerViewForm; //This is used as the key for the dialog box

I have found recently that a couple of newly created customisation projects seem to have disappeared from the Publish Customisation screen. I was wanting to make a change to one of them but I couldn't find the project anywhere.On the login screen, I can see which customisations are published, including the two projects that have disappeared, which I have highlighted. The changes in those projects are still working, which is great, but if something was to go wrong or I needed to change the functionality, then I wouldn't be able to find it.Here is the login screen with the publish projects highlighted. And here is the publish customisation screen which is sorted by all published customisations. As you can see, the two highlighted projects are missing.  Do you know if there is a reason why they would be hidden, and if there is a way to make them appear in this screen again?Thanks for any assistance on this.

Hello Community,I was wondering if is there a way to retrieve only the values of a single table based on the conditions from other tables. Something equivalent to SQLSELECT TableA.* /*ONLY I want TableA*/FROM TableA INNER JOIN TableB ON TableA_BID = TableB_BID /*Join TableA & TableB - One-to-one Relation in my case*/WHERE TableB_CID IN (SELECT TableC_CID FROM TableC WHERE TableC_CD = 'MyCondition') /*Filter Result Based on TableC*/ I know I can join tables and apply conditions in the WHERE statement, (for Example if I Join APInvoice with APTran) but the problem is when I join tables I will have the redundant APInvoice per APTran line and I want to avoid it also I do not want the APTran fields. I also know I can perform GroupBy but it is a headache and in my opinion, a dumb way to approach it. I only want to return a single table and its records that meet the criteria from other tables without redundancy caused by joining with other tables.

Hello, I have added two views to the PMTaskEntry, all works except when I try and delete the PMTask via the UI. I get the following exception.Collection was modified; enumeration operation may not execute. at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) at System.Collections.Generic.List`1.Enumerator.MoveNextRare() at PX.Web.UI.PXCallbackManager.GetCallbackResultInternal(PXCallbackResultMethod resultMethod)I think it has to do with the views trying to refresh while the row is being deleted, but I am not sure.I appreciate the help, thanks in advance. public class PMTaskEntry_Ext : PXGraphExtension<PX.Objects.PM.ProjectTaskEntry> { public static bool IsActive() => (true); #region Cost Budget //[PXFilterable(new Type[] { })] [PXDependToCache(typeof(PMTask))] public PXSelect<PMCostBudget, Where<PMCostBudget.projectID, Equal<Current<PMTask.projectID>>, And<

I need to override the accountattribute so that it accepts inactive accounts, how do I do this, currently the restrictors I want to remove…..     [PXDBInt]    [PXInt]    [PXRestrictorAttribute(typeof(Where<Account.active, Equal<True>>), "Account is inactive.", new[] { })]    [PXRestrictorAttribute(typeof(Where<Where<Current<GLSetup.ytdNetIncAccountID>, IsNull, Or<Account.accountID, NotEqual<Current<GLSetup.ytdNetIncAccountID>>>>>), "YTD Net Income Account cannot be used in this context.", new[] { })]    [PXUIField(DisplayName = "Account", Visibility = PXUIVisibility.Visible, FieldClass = "ACCOUNT")]   public class AccountAttribute : AcctSubAttribute, IPXFieldVerifyingSubscriber, IPXRowPersistingSubscriber    {        public const string DimensionName = "ACCOUNT";        public AccountAttribute();   

I have added UDF’s to the Employee Time Card screen.  The screen is fine on the web site.I’ve added these fields to the Mobile App.  One of the selectors works without adding anything extra to the xml.  The other 3 look exactly the same as far as the DAC is setup.  I cannot understand why one works and the other 3 do not.  I’ve gone through other posts for possible solutions.  None of them are working.  If the UDF’s contain data, they display fine on the mobile app.  You just cannot lookup a value in those selectors.Here is a screenshot of the screen for a new entry.  Note that the WG Task field allows me to lookup a value.  The other 3 with a red X do not do anything.Also, the Workgroup field is a standard Acumatica field (not UDF) that I added to the app.  It is a lookup field on the web site, but not on the mobile app. Just to show that the UDF’s are mapping correctly, here is a Detail that shows values when there is data in the fields (entered via the web site):Here is the DAC fiel

I am looking to build a customization to export shipment header and line detail information to an XML file.  I can do this easily within SQL using the XML writing shortcut, but I’m curious whether I can do something similar within Acumatica to generate the same file. There are a few things I shortcut below, such as contact info is not in the header of the shipment, but this is close to the format I am looking to export.SELECT ship.ShipmentNbr AS [@ShipmentNbr], ship.Customer As [@CustomerID], ship.CustomerName As [@CustomerName], ship.ShipmentDate As [@ShipDate], ship.CompanyName As [@ShipToName], ship.Phone1 As [@Phone1], ship.Fax As [@Fax], ship.Email As [@Email], ship.Location As [@Location], ship.LocationName As [@LocationName], ship.WarehouseID As [@WarehouseID], ship.WarehouseName As [@WarehouseName], ship.TotalShipmentQty As [@TotalShipmentQty], ship.ShippedWeight As [@ShippedWeight], ship.ShipVia As [@ShipVia], ship.AddressLine1 As [@AddressLine1], ship.AddressLine2 As [@Addres

I would like to check if Credit Memos or Prepayments exists when loading an Invoice. How programmatically incorrect is it to query the database on RowSelected? (I know you’re not supposed to make changes in RowSelected).

Hey ! Since fews days, system doesn’t allow me to add any new field on the CT Contract DAC.During validation, compilation is running an error : ‘Column name invalid’.I tried to use a shorter name ,try to unpublished all and to republished but same result. I can add  any field on other DAC (Baccoutn, etc) except this one.   Have you ever face the same error ?  Thank for any help ! :) Cecile

We have used the strings collection feature to localize our side panels titles. Unfortunately, if some of them appear correctly translated, some others don't, depending of the environment where this version is deployed. Maybe we didn't used the right way to do that.Does anyone knows how to proceed ?Thanks.

Hi, all. I’m currently working on custom processing form which uses a filter. However whenever I select entries and change the filter, the entries I selected remain selected. Is there an event handler needed to clear the selected fields or should it automatically clear all selected fields when the filter is updated? Here are some screenshots and initialization of the view.  public SelectFrom<ARPayment>. Where<ARPayment.docType.IsEqual<ARDocType.payment> .And<ARPayment.status.IsEqual<ARDocStatus.balanced>.Or<ARPayment.status.IsEqual<ARDocStatus.closed>>.Or<ARPayment.status.IsEqual<ARDocStatus.open>>> .And<ARPayment.status.IsLessEqual<GiroCheckToProcessFilter.action.FromCurrent>> .And<ARPayment.voided.IsNotEqual<True>> .And<ARPayment.paymentMethodID.IsEqual<PaymentMethodConstant.check>.Or<ARPayment.paymentMethodID.Is

Hello everyone,Have a nice day.Now, I can’t open server Report designer of Acumatica system on Localhost; Can anyone guide me or have something they used similar for this kind of scenario.Thank you

Hi, Does anyone know how to detect a grid click so that a value can be populated.  The scenario I have is how to efficiently enter data into a tally sheet:This is what I would like to accomplish:User enters number of rows in the form header (for the above example 16) 16 rows automatically appear in the grid beneath the header with the layer prepopulated 1 to 16 The user keys the 8 in the first cell, row 1 They then are able to just mouse click all the cells in the grid that should be 8 next, the user keys the 9 in the second cell row 2 and goes through the same click to populate process.I know how to do all of the above except detect the mouse click and then populate the last value keyed (step d).  Any ideas.Some of the tally sheets have lots of 3 and 4 digit numbers with high levels of commonality so the whole user keying experience is rather horrendous. Also, what about Optical Character Recognition (OCR) for a tally sheet that looks like the above?  Anyone done anything along those

I don’t have an actual issue/error here.  I am just seeking advice on an alternative way to accomplish my goal.In my Merge Tools application, you can merge customers and vendors (at this time...I hope to add other merge options later).  However, I want to prevent a user from merging vendors and customers simultaneously as this will surely cause errors as common tables are being modified by both processes in transactions and I don’t want changes from one process overwriting changes from the other process.Each merge process has it’s own screen.  I currently have it so that you cannot process a merge unless the users are locked out.The merge buttons are disabled unless the system is locked out.  Here they are enabled as I have the Lockout turned on.To prevent a user from performing merges on more than one option, I may need to create a screen to do something similar to the Apply Updates screen. I am thinking of creating a form that the user can select the current merge process being perfo

Hello,I was upgrading my website from version 6 to version 20R1 after upgrading i got this error in the customization project. what is this constructor takes?  

Hello expers,I don’t know if it is possible to create a Multiple Selector?In case it is impossible. Is there any workaround to achieve this goal?I found an article https://asiablog.acumatica.com/2018/01/multi-select-selector.html but it doesn’t work.Thank you for your sharing. Regards,Khoi

Hello Community,Does anyone have any experience with mass downloading attachments from Acumatica? I have done a little bit of digging and seems “UploadFileInq” is the graph that manages the files/attachments and the “GetFile” action handles single file downloading. The issue I am facing is I do not see the real implementation code for the graph just declaring the views, filters, actions, and handlers. For example, I see the “GetFile” action but I do not see its method code. Or I see “FilesFilter_RowUpdated” handler but I do not see any code in it but for sure there should be because when we change the filter parameters the result grid changes. Or I can not see any Files select statement tied to the current value of the filters.I was wondering if this is one of those graphs Acumatica doesn’t like to be accessible for customizations! Any thought or direction to the right path is greatly appreciated.Ideally, I would like to open “File Download” dialog once to get the download path and dow

Hi All,How to display all the list of preferred tech from attribute screen(CS205000) to service contract screen(FS305700).if i add the list for preferred tech here in attribute screen, that needs to be displayed as drop down in below attributes tab of service contracts screen, kindly pour your ideas.

I have a GI where I am joining AMMRPBucketDetailInq to INSite (joined by siteId) and to InventoryItem (joined by inventoryId). I am also grouping by siteId.I want the user to be able to select a warehouse, so I have set up a Parameter for INSite.SiteCd (NOT INSite.SiteId). When I execute, no matter what siteCD I enter, the GI displays all rows. It appears to be ignoring the INSite.SiteCd from the Parameter. The GI XML is attached.Thank you!

Hi,I’m a freshman to acumatica development. I followed some of recordings of Acumatica T series and started customizing a new screen for Pro-forma Invoices. Below screen shot shows what I have done so far.  Now I need to add a button called Add Orders in the tab and when click on the button , pop-up a new  window with all the available sales orders according to the customer ID (name) to be selected and add to the grid. Below screen shot taken from a different screen for the reference.  In this scenario, following points are identified cases.how to add a button and when clicked on the button pop-up a new screen . Do I need to add this button as an action or any other way to do this? How to load data into the newly opened window.? Do I need to customize this screen as well? how to filter data in this newly opened window/screen according to the customer ID?It’s really appreciated if someone can suggest me a solution to achieve these steps.Thank You.

Hello Everyone,Have tried to enable the following field in contract management but I’m unable to.Kindly assist All responses will be highly appreciated.

Hi,I have customized a new screen for Proforma invoices and now I need to add data to a custom report and print according to the given parameters. First I created the custom report using report designer without adding any parameters and included in the customization project.then I created an action called Print Report to print the report when clicked on the button. *Destination screen is the Pro Forma Invoice Report which is the report screen (PI302000.rpx)  After publishing the customization project , my customized screen is shown as below.  Now I clicked on the print report button and first it navigated me to the PI302000 screen and when I run the report it gives me the report with all data without any issue. Then I Modified the report with a parameter (refnbr) and included into the customization project again and modified the action with the parameter also.Report designer schema builder Action properties of customization projectNow I Published the customization project and clicked o

The Reference Nbr. and Type Columns are switched for some reason I am currently working on a customization which uses a custom processing form to call a modified release action. The modified release action is as follows: public static void ReleaseProcess(List<ARPayment> list, bool isMassProcess) { ARPaymentEntry graph = PXGraph.CreateInstance<ARPaymentEntry>(); var docsToRelease = new List<ARRegister>(list.Count); foreach (ARPayment payment in list) { if (payment.Status == ARDocStatus.Balanced) { docsToRelease.Add(payment); } } if (docsToRelease.Count == 0) throw new PXException(PX.Objects.AR.Messages.Document_Status_Invalid); ARDocumentRelease.ReleaseDoc(docsToRelease, isMassProcess, null, (ardoc, isAborted) => { }); for (int i = 0; i < list.Count; i++) { if (list[i] == null) con

Getting the below error in one of the customizations. Code Snippet belowError: The entry form (ID: AR303000, title: Customers) cannot be automated. Failed to subscribe the event PX.Objects.AR.XXXExt::LocationExtAddress_CBranchID_CacheAttached in the graph PX.Objects.AR.CustomerMaint. The method signature looks like an event handler, but the cache LocationExtAddress has not been found in the list of auto-initialized caches. Remove unused event handlers from the code.  public class XXXExt : PXGraphExtension<CustomerMaint.LocationDetailsExt, CustomerMaint.DefLocationExt, CustomerMaint.DefContactAddressExt,CustomerMaint>    {[Branch(null, IsDetail = false, DisplayName = "Shipping Branch", BqlField = typeof(CRLocation.cBranchID), IsEnabledWhenOneBranchIsAccessible = true)]        protected virtual void LocationDetailsExt_CBranchID_CacheAttached(PXCache sender) { }}

I am curious what is/are the very first graph(s) that are initiated automatically anytime a user logs in?