Develop Customizations

Hello Everyone,I’m busy with some customizations of the Sales Order Workflow. The new flow needs to go from On-Hold to Open and from Open I’ve added an action but this action needs to do 2 checks to either put the sales order on Credit Hold if the Customer’s limit is exceeded or if it is satisfied progress to the new state called Dispatch and then from there create the shipment.So far I’ve got the workflow to work for the customer with the satisfied limit but I can’t get the system to put the Sales Order on credit Hold if the limit is exceeded. Any ideas from someone where I might have gone wrong?

I have created custom field for Bills and Adjustments screen to approve the AP Bill. So then after I set the field to the Approve map as belows. but it didn't work for me.Anyone know what else should I do to work for this. I used acumatica version 22 R1.    

I want to add a counter which suggests how many times a pick list was printed. Which is the best DAC to use over her. According to me it should be SOPickingWorksheet. Please correct me if I am wrong and help me.

Hello everyone,I'd need to display the first PDF file linked to current AP invoice in the AP301000 screen. Is it possible to do that using side panels ? Thx.

Is there a way to add in a custom Function (C#) into a Generic Inquiry. I remember reading a blog post at a time where this was explained but I cant find it or this is not possible anymore.any guides or post about this will be helpfulthanks 

As shown in the above screenshot, I want to get the total of the “Line Volume” in the detail section and show in the field of Total Volume in the header level. This Line Volume is a newly added customized field in to the ARTran DAC. Relevant code for the Line Volume as follows.  Guys, If you can give me a guidance, it is highly appreciated. 

I have created a location selector under “Component and Warranties” grid in Equipment Screen (FS205000).The selector is working fine, location is also getting selected and saved into db. but when the focus is removed from the selector field, I can’t see the value. below is my code and screenshots attached :  #region UsrXDLocation        [PXDBInt]        [PXUIField(DisplayName = "Location")]        [PXSelector(typeof(Search<Location.locationID,Where<Location.bAccountID, Equal<Current<FSEquipment.customerID>>>>),             DescriptionField = typeof(Location.descr), SubstituteKey = typeof(Location.locationCD), Filterable = true)]        public virtual int? UsrXDLocation { get; set; }        public abstract class usrXDLocation : PX.Data.BQL.BqlInt.Field<usrXDLocation> { }#endregion This code is under FSEquipmentComponentExt.This screenshot is when the field i

What’s the best way to add an index to an existing table that’s a third-party table?It’s a table with an auto-increment field as it’s primary key (along with CompanyID). But when I look at the underlying views, the code is querying the table using non-indexed fields. I don’t have time, at the moment, to reach out to the third-party to suggest that they add a key to make the lookups faster mostly because I won’t have time to integrate any patch from them into my code base at this point even if they agree.So I was thinking of adding a non-unique key on the fields that I see the view using.Should I just add a SQL script to my customization project to add the index if it isn’t already in place?Or is there a more official way that I should do this?

I have a customer that I cannot publish ANY customizations for. (This is on my development server.)I have 12 different customers running on this server. All of them are fine. However, when I try to publish ant customizations for one particular customer, I get errors.Here is the process:I backup the customer’s database using SQL Server Backup and restore it to my local SQL Server. I create a new Application Instance using AcumaticaConfig.exe, attaching it to an existing database (done in step 1) I start up the application in IIS I go to the customizations page, and of course all customizations are unpublished I try to publish ANY of them -- even the Acumatica Github Customizations (eg PXLineCostForAccrue) -- ANYTHING, and I get this error:[2023-08-24 19:01:46.663] Compiled projects: PXLineCostForAccrue[07.17.23][2023-08-24 19:01:46.720] Valida

Hello,I have 2 extensions fields on the Project page. One is a checked box and the other is a date field. I am trying to set it up so that when the checkbox is checked, the current date is populated into the date field. When the checkbox is cleared, I want the date field to be cleared as well. I have this functionality working on another form but it is custom tables and not extensions. Here is my code protected void _(Events.FieldUpdated<ContractExtDS.usrInstalled> e) {        var row = e.Row;         //I don’t think that it is getting past this line, but I can’t figure it out           if(!(bool)(e.Cache.GetValueExt<ContractExtDS.usrInstalled>(row)))        {          e.Cache.SetValueExt<ContractExtDS.usrInstallationCompletedDate>(row, DateTime.Now);        }        else        {          e.Cache.SetValueExt<ContractExtDS.usrInstallationCompletedDate>(row, null);        }

I want to create a custom field using the [Inventory] attribute so that I get the selector and it is all sorted out for me.  I don’t want it to be PXDBInt.  I want it to be a virtual field of type PXInt.        #region UsrModEquipTempID        [Inventory]        [PXUIField(DisplayName = "Model Equipment")]        public int? UsrModEquipTempID { get; set; }        public abstract class usrModEquipTempID : PX.Data.BQL.BqlInt.Field<usrModEquipTempID> { }        #endregionIf I put [PXInt], it causes a compiler error.  How can I do that?  

Hello,I have an action that I would like to run as a process on a sales order. It’s really an ‘initialize’ action where I can do some validation while I save it. I have simplified the code to the base where I’m still getting the same behavior. Ultimately, I want to persist the record before I do any processing due to the way the system caches data on the tables/items I’m running calcs on. Can anyone tell me why when I execute this action (before initially saving) the system redirects me to a blank sales order? In order to find it again, I have to press the “Last” button to get back into it.  public PXAction<SOOrder> Test; [PXProcessButton(CommitChanges = true, Category = "Processing", Connotation = PX.Data.WorkflowAPI.ActionConnotation.Success)] [PXUIField(DisplayName = "Test")] protected IEnumerable test(PXAdapter adapter) { Base.Save.Press();

It show me like this when reload “ Incorrect syntax near ')' ”. I think my code is correctly but…here it is, please advice me[PXSelector(typeof(Search2<InventoryItem.inventoryID,LeftJoin<InventoryItem,On<InventoryItem.inventoryID,Equal<INItemCategory.inventoryID>>>,Where<INItemCategory.inventoryID.IsNull>>))]        protected virtual void _(Events.CacheAttached<INItemCategory.inventoryID> e)        { // Empty method        }

Hi,I have a simple processing screen displaying records in a grid. Above the grid, I have some action buttons.What I want to doI'd like to change dynamically the accessibility of one of thses action buttons : if the selected record in the grid has some specific characteristics, the button is enabled, otherwise, it is disabled.The problem  to solveMy problem is to catch the fact that a new row is selected in the grid : the RowSelected event is not invoked in this case.Some technical detailsThe declaration of the graph :public class EapActivityProcess : PXGraph<EapActivityProcess>The declaration of the view        public SelectFrom<EAPActivity>            .OrderBy<Desc<EAPActivity.lastChangeDate>>

Hi, In the Sales Orders screen, after clicking ‘Add Items’, as shown in the second image below, a client is wanting the Warehouse field to be set to ‘MAIN’ in the dialog box shown in the third image below. The code I currently have set up doesn’t seem to work. I am using the FieldDefaulting event but would I need to combine this event with another one, like RowSelected, to pass the value through? Let me know if I can provide any other information. Kind regards,Andrew protected void SOSiteStatusFilter_SiteID_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { if (e.Row == null) return; SOSiteStatusFilter row = (SOSiteStatusFilter)e.Row; INSite site = PXSelectReadonly<INSite, Where<INSite.siteID, Equal<Required<INSite.siteID>>>>.Select(Base, "MAIN"); row.SiteID = site

Hello Acumatica Community,i am trying to add the attributes of a stock item to the PO Line in the Details TabThese Attributes:For my problem i found this post: I thought i could transfer that to the PO and add the inventory attributes to the Details Tab. After 2 very long days and suffering i no longer know what to do. I would like you to take a look into the code of my customization. I added a new custom field in POLine which i believe later stores the value of the specific attribute. But i am not sur

I’m still new to programming in Acumatica, so I may have gotten several things wrong here, but I’m trying to get a single value to be returned from this BQL statement which should be the sum of a specific customer’s invoices for the current year for the price of goods only. I’m getting a highlighted error in Visual Studio that says that the entire BQL statement is a type that is not valid in the given context. I’m also not sure if the Convert.ToDecimal function will work with an ARInvoice.curyGoodsTotal object. namespace PX.Objects.AR{ public class DateYearStart : PX.Data.BQL.BqlDateTime.Constant<DateYearStart> { public DateYearStart() : base(new DateTime(DateTime.Today.Year, 1, 1)) { } } public class DocTypeString : PX.Data.BQL.BqlString.Constant<DocTypeString> { public DocTypeString() :

In the following BQL Fluent statement, I am selecting a record from the POVendorInventory table.In the table, the record has a NULL in the SubItemID field.  When there is a NULL in that field, this returns no record even though my parameter “reg.SubItemID’ is passing a NULL.That field is part of a unique index.  My select statement is making sure that if a record already exists with the key fields, it does not add a duplicate.POVendorInventory test = SelectFrom<POVendorInventory>                    .Where<POVendorInventory.vendorID.IsEqual<@P.AsInt>                        .And<POVendorInventory.inventoryID.IsEqual<@P.AsInt>>                        .And<POVendorInventory.purchaseUnit.IsEqual<@P.AsString>>                        .And<POVendorInventory.vendorLocationID.IsEqual<@P.AsInt>>                        .And<POVendorInventory.subItemID.IsEqual<@P.AsInt>>>

Looking for Acumatica configuration partners that know the ins and outs of Acumatica and are timely and responsive.

Hi All, I have previously asked this question for an AR Invoice in a different approach. But I was unable to resolve it using the replies of that question because of some issues(Release method is not triggering when we process invoices from a process screen).However, Now I want to attach a report pdf to files section of an AP Invoice through Release AP Documents screen. I tried to override Release action in APPaymentEntry graph. But it is not triggering when releasing invoices through Release AP Documents screen. Then I tried the below code snippet & it is triggering for each AP Invoice. There are no errors in the code. But file is not attaching as expected. Below is my code.Acumatica Version : 21.213using System;using System.Linq;using System.Collections;using System.Collections.Generic;using System.Text;using PX.Common;using PX.Data;using PX.Data.DependencyInjection;

Hi All, I want to show all records associated with any Account when Account Filter field is null in Account Details Screen. Otherwise it should work as usual. How can I achieve this? Thanks

I’m attempting to override the ReleaseFromHold action on the POOrderEntry graph, I need to add my own validation before the baseMethod is called.I created the delegate using the following code, but I receive the error message below.I’ve been able to override other action on this same graph using this method, is there something unique about the ReleaseFromHold action?  public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter); [PXOverride] protected IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod) { return adapter.Get(); } 8/18/2023 2:46:05 PM Error:Attempt by method 'Wrapper.PX.Objects.PO.Cst_POOrderEntry.ReleaseFromHoldGeneratedWrapper(PX.Objects.PO.POOrderEntry, PX.Data.PXAdapter)' to access method 'PX.Objects.PO.POOrderEntry_Ext.ReleaseFromHold(PX.Data.PXAdapter, ReleaseFr

Good day,I have several questions about buttons.I am trying to establish a sequence when creating customer locations, in the customer locations screen when a user selects a customer and is going to add a new location, it has to press the button, so it automatically assigns the number for the sequence. If I Define the action with PXButton in the graph extension, it creates a button in the toolbar and when pressed it does the sequence, but it places it in the wrong spot.First picture shows the button in the toolbar and on the top left corner the value.I am specifying in the code that I want the value in the LocationCD field but is not working.Then if I define the action with PXLookupButton(DisplayOnMainToolbar = false) there is no button in the toolbar which is good, but when I create a button control in the aspx the Command attribute doesn't seem to work. I can't link the code in the graph with the aspx. I did a debug and when I press the button it

Tôi muốn tạo mới report và chỉnh sữa báo cáo trên Acu phải làm như thế nào I want to create a new report and edit the report on Acu, how to do it?

Hello every one,I have done a payment integration on AcuPos. when the payment is processed succefully, the provider send back a payment reference.I have configured the payment reference to be pushed to the database directly upon being receive.Now, the user have to refresh the browser tab for the reference to reflect from the database to the UI.see below; is there a way I can refresh the specific field or the column or the tab so that the database value can reflect on the user interface without the user having to refresh the entire tab.Kindly assist.any kind of response will be appreciated.Thank you, great community!