Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi Experts,I’m working on the certification for 2021R2, and I got some validation errors from Acumatica(like “The error has been found in the SQL scripts. The project-specific database tables and columns must be mapped to DACs.Sql | Table1”).I have fixed these errors, but I want to validate locally before I submit it. I know I can validate the project by the following steps. But I got the following message “No errors or warnings have been found during validation.Validation has completed successfully”.Does any one have some idea about validating the customization projects locally? Thanks,Frank
Sales Orders used to have a REPORTS drop down menu where I could add in reports etc. I seem to be missing that now with the upgrade to 2021 R1. How do I re-add the reports drop down button?
I’m working on importing leads using a webhook. I can get all the lead data to insert into acumatica but we have a requirement to set the Source Campaign of the lead depending on which one of our websites the lead comes from. I’ve added an attribute on the Marketing Campaigns called LEADWEBSIT. I want to use the website address to search for the correct Marketing Campaign based on the value in the LEADWEBSIT attribute. For example the website the lead comes from could be https://ourmainsite.com/contact-us/ or it could be https://ourmainsite.com/demo-survey/The LEADWEBSIT value would just be ourmainsite. We want to find the Marketing Campaign where the attribute value in LEADWEBSIT is in the address the lead came in from.I know how to do a search like this: var campaignGraph = PXGraph.CreateInstance<CampaignMaint>(); CRCampaign campaign = campaignGraph.Campaign.Search<CRCampaign.campaignID>("1");But I’m not sure how to search on an attribute and how to search using
I created custom Inquiry form which provides Project Summary information and the Inquiry form working fine as I get desire result when I run directly but when I add new widget and try to select that screen from Inquiry screen drop down the created custom inquiry form is not available. Is there any way I can create widget from custom created inquiry form?
I’m trying follow instruction of S100SysAdmin2017R2 Lesson 5: Publishing Customizations, Step 5.1: Importing a Customization Project . I download the “Manufacturing.20.111.0017.49.zip” and “ManufacturingWiki.20.1.zip” according to the instructions. when i tried to Publish the Manufacturing.20.111.0017.49.zip i got following validation issue is Validating Binary FilesJAMS.dll Method signature was changed: System.Nullable`1<System.Guid> PX.Objects.IN.InventoryItem::get_ProductManagerID() declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullJAMS.dll Method signature was changed: System.Nullable`1<System.Guid> PX.Objects.IN.INItemSite::get_ProductManagerID() declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullJAMS.dll Method signature was changed: System.Void PX.Objects.CR.PMTimeActivity::set_OwnerID(System.Nullable`1<System.Guid>) declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullFixed binding: t
Issue is on upgrade.Previously you could add a number of Automation Steps of Notification type. This allowed a number of Notification Actions to be defined. Now that the Automation Steps are no longer supported I’ve added a Notification Action in the Customization for the screen and this worked fine. But when I went to add some more then the option to choose Notification as an existing is no longer available. Any ideas on how to work around this?
Hi Good night. I need to do the following.When selecting one or clicking on a row of the grid, obtain the value of the selected Id (current). The grid has a “SelectedRow” event? in test mode. I created a Button (AddSelected). When i select a row and then i push de button, I need to get the value (Id) of the current row. (now i am obtain only the value of the first row (Id = 86)the current Id is 88 but i obtaing 86 ever.i put the code of the Add Selected button. public PXAction<CEEstimate> AddSelected; [PXButton(CommitChanges=true)] [PXUIField(DisplayName = "Add Selected")] protected virtual void addSelected() { CEEstimate row = viewCEEstimate.Current; CEEstimateEstimate rowd = viewCEEstimateEstimates.Current; //row.Description = CEEstimateEstimate.Current.Id.ToString(); row.Description = rowd.Id.ToString(); }CEEstimate (viewCEEstimate) is the header and CEEstimateEstimate and viewCEEstimateEstimates is the detail cna you helpme please
I want to dynamically change the warehouse selector results in Acumatica on the following screens:Opportunities Sales Orders Purchase orders Sales Quotes Requisitions, by either company(All warehouse under selected company) or branch. The condition will be met with custom fields I have added to the Inventory preferences screen.I came to the conclusion of having to use a custom selector attribute, but how to achieve this I am not sure.Any guidance and help would be greatly appreciated.See code attached for my Custom DAC fields and the code for the Sales Order Graph:public class INSetupExt : PXCacheExtension<PX.Objects.IN.INSetup> { #region UsrAllowBlockin [PXDBBool] [PXDefault(false)] [PXUIField(DisplayName="Block Normal Journal Posting by Creator")] public virtual bool? UsrAllowBlockin { get; set; } public abstract class usrAllowBlockin : PX.Data.BQL.BqlBool.Field<usrAllowBlockin> { } #endregion #region UsrByCompany [PXDBBool] [PXDefault(true)] [PXUIField(Display
I have been attempting to update 2 Boolean field values on Time Activity based on the same usr fields in the PM-Task Table. So when a time card has the project Task with “OnSite” Checked or “Travel” Checked it will carry over to the Time Card. Once created I plan to use this to create fields to match Billable and Total Billable on the Time cards. I understand that is best done with Event Handlers and maybe this would have been as well. This is my first time working with Attributes and I have tried to write this a number of ways but somehow I am missing something. My code is below if anyone has any ideas. PMTask{ public class PMTaskExt : PXCacheExtension<PX.Objects.PM.PMTask> { #region UsrIsOnsite [PXDBBool] [PXUIField(DisplayName="IsOnsite")] public virtual bool? UsrIsOnsite { get; set; } public abstract class usrIsOnsite : PX.Data.BQL.BqlBool.Field<usrIsOnsite> { } #endregion #region UsrIsTravel [PXDBBool] [PXUIField(DisplayName="IsTravel"
I am using PXFormula to multiply a qty and cost to create a new extension field in the details of Physical Inventory Review (although I would think the specific screen wouldn’t matter.) That part is working fine. However, I then want to sum that new column’s values into a new extension field in the header. I can't get that part to work.Here is the relevant detail code:using PX.Data;using System;namespace PX.Objects.IN{ public class INPIDetailExt : PXCacheExtension<PX.Objects.IN.INPIDetail> { #region UsrExtBookCost [PXDecimal] [PXUIField(DisplayName="Ext. Book Cost")] [PXFormula(typeof(Mult<INPIDetail.bookQty, INPIDetail.unitCost>), typeof(SumCalc<INPIHeaderExt.usrTotalBookCost>))] public virtual Decimal? UsrExtBookCost { get; set; } public abstract class usrExtBookCost : PX.Data.BQL.BqlDecimal.Field<usrExtBookCost> { } #endregion }} Here’s the header code:using PX.Data;using System;namespace PX.Objects.I
I’ve modified the sales quote to allow the unit cost to be visible and editable but when I create a sales order from the sales quote the sales order is using the unit cost setup on the stock item and not what I set on the sales quote. I’m not sure what needs to change in order to get the unit cost on the sales order lines to match what is on the quote line. Is that something that can be changed? If so how would I go about it?
Hello, The generic inquiry for our push notifications includes several custom fields that are only used by downstream systems. They are not really part of the account data per se. So we want our push notifications to contain these fields, but don't necessarily want changes in these fields to trigger push notifications. Is this possible? Can a generic inquiry or push notification be configured such that a notification is only sent when certain fields are changed, but not others?Thank you for your help. Best regards, Dave
Hello Guys, It's possible to disactivate the approval workflow in the persist action and activate it after integrating the supplier invoice (Click on the button INTEGRATE) (AP301000) ??Version: Acumatica 2020R2Thanks for your feedback
I am currently developing a customization on the SO503050 screen including mobile. The problem that I am facing is that I already configured everything to be able to redirect the user after the process action is completed but its not redirecting. I attached some images about what I already configured: On the Update MENUOn my custom screenAnd I have already added the respective add Screen “SO644000” of type report for each of the reports. I am missing something?
Hi All, Ineed to create a create a kit item - on-the-fly on the sales order from NetSuite. can anyone help me with solution, and thanks inadvance
I wanted to redirect to a generic inquiry with a "Drilldown" tab similar to dashboard widget clicks.After some research, I found the following method. string inqID = "cb567d54-187b-4466-a2e5-8776831ca6e9";var url = new StringBuilder(PXGenericInqGrph.INQUIRY_URL).Append("?id=").Append(inqID).ToString();List<PXFilterRow> filterRows = new List<PXFilterRow>();filterRows.Add(new PXFilterRow("SOShipment_customerID", PXCondition.EQ, "AACUSTOMER"));filterRows.Add(new PXFilterRow("SOShipment_siteID", PXCondition.EQ, "Retail"));PXRedirectToUrlException ex = new PXRedirectToUrlException(url, PXBaseRedirectException.WindowMode.New, false, null);ex.Filters.Add(new PXBaseRedirectException.Filter("Results", filterRows.ToArray(), "Drilldown"));throw ex;You have to add filter rows to the redirect exception. You can learn more about GI redirects below.https://asiablog.acumatica.com/2019/03/working-with-generic-inquiries-from-code.htmlhttps://stackoverflow.com/questions/42537829/open-gi-on-bu
Hello,I want to know if i can get the action name of the pressedaction in the screen from graph by code.Best regards.
Hello I have an action button that needs to be conditionally available after the quote approved checkbox is selected from the opportunity then this box “conver to project” needs to be conditionally available. I was provided a sample code, but I am unsure of how I use it? Would I create a project, and create a new code with it? protected virtual void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler){InvokeBaseHandler?.Invoke(cache, e);SOOrder row = e.Row as SOOrder;if (row != null){if(Condtion){ActonName.SetEnabled(true);}else{ActonName.SetEnabled(false);}}}
I’m looking to add a "Date of Service" column to the Services > Invoice > Details grid.I'm trying to add a column on the Details tab of the Invoices screen to show the Appointment Date for charges listed on the Details tab. It pulls this information just fine on one of my reports (relationships shown on the bottom row, Left join FSARTran to FSAppointment, in the attached image), but when I duplicate this join (the FSAppointments table to FSARTran) in the Generic Inquiry for the Invoices page, the fields are all there, and it saves with no errors, but it begins generating errors for our users. Anyone know how to add a column for Appointment Date to the Details tab of the Invoices screen?I found the info (see image) for tying the Invoice to the Appointment Dates in the report file SO643000.RPX. All the fields seemed to be there and the tables appeared to add and relate without error. However, once I clicked Save, the system began generating errors when attempting to populate the In
In my code I’m looking to see if an invoice already exists before proceeding. I was using this query: ARRegister invoice = PXSelect<ARRegister, Where<ARRegister.docType, Equal<Required<ARRegister.docType>>, And<ARRegister.refNbr, Equal<Required<ARRegister.refNbr>>>>>. Select(this, receiptRow.ApplyToDocType, receiptRow.InvNbr);But it would not find the record. I confirmed that it is in the ARRegister table (local install, local database).So I decided to try this:ARInvoice invoice = SelectFrom<ARInvoice>. Where<ARInvoice.docType.IsEqual<@P.AsString>. And<ARInvoice.refNbr.IsEqual<@P.AsString>>>. View. Select(this, receiptRow.ApplyToDocType, receiptRow.InvNbr);and that worked. It is a different table but the primary keys on both tables are the same.So, my question is, what’s the difference between the PXSelect and the SelectFrom calls? In case it matters ‘this’ is within an Action bu
I am wondering if anyone has ideas on where to start with a customization to accurately capture field staff utilization in Acumatica. Our work is all project based and we have hundreds of projects running at a given time. Teams are tracking Travel time in the projects under the tasks IBT and OBT (inbound and outbound travel) The rest of tasks are onsite time. I am hoping to shape the data in a way I can use the stock Dashboards to report Onsite vs Travel time and %of 40 hours a week but in a GI I can’t seem to create all the calculations I need so am thinking I need to have a custom field or two to store the data. My GI is based on PX.Objects.CR.PMTimeActivity and left joins in the Projects and Tasks to use the common name between projects for the tasks.Here is the way I am calculating the hours “Onsite” in the GI =((CDec([PMTimeActivity.TimeBillable]) - iif( [PMProject.ContractCD] = '1',CDec([PMTimeActivity.TimeBillable]),0) - iif( left(CStr([PMTask.TaskCD]),3) = 'IBT',CDec([PMTi
I’m not sure why but a custom field I’ve created is not showing in the grid on the screen.The new field is the Mark Up % and it shows in the Column Configuration but not in the grid. Here are the layout properties: Here is the aspx: Here is the extension code:using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CM.Extensions;using PX.Objects.Common.Discount.Attributes;using PX.Objects.Common.Discount;using PX.Objects.Common;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN.Matrix.Interfaces;using PX.Objects.IN;using PX.Objects.PM;using PX.Objects.SO;using PX.Objects.TX;using PX.Objects;using System.Collections.Generic;using System;namespace PX.Objects.CR{ public class CROpportunityProductsExt : PXCacheExtension<PX.Objects.CR.CROpportunityProducts> { #region UsrMarkUp [PXDBDecimal] [PXDefault(TypeCode.Decimal, "0.000", PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField
I have added a field to the existing SOOrder DAC in order to carry a ReasonCode.. But I only want to select records from the ReasonCode where the Usage field is equal to ‘A’Here is my selector code to display the ReasonCodeID and Descr fields..[PXSelector(typeof(Search<ReasonCode.reasonCodeID, Where<ReasonCode.usage, Equal<'A'>>>), typeof(ReasonCode.reasonCodeID), typeof(ReasonCode.descr))] But this is the error:\App_RuntimeCode\PX_Objects_SO_SOOrder_extensions.cs(36): error CS1031: Type expected
Hello,I have a source code for the approbation for purchase which works well at acumatica 2020R1.When I did the migration to 2020R2 then it does not work the approval function.I want to know what the problem is exactly. protected void createRecipt(POOrder order, List<POLine> PoOrderLine, SOShipment shipment, SOShipment newshipment, POOrderEntry graph1) { PXAdapter adapter3 = new PXAdapter(new DummyView(graph1, graph1.Document.View.BqlSelect, new List<object> { graph1.Document.Current })); adapter3.Menu = "Approve"; PXAutomation.CompleteAction(graph1); adapter3.Arguments = new Dictionary<string, object>(); adapter3.Arguments.Add("actionID", 1); graph1.action.PressButton(adapter3);}Exception : PX.Data.PXLockViolationExceptionBest regards
Hopefully I explain this correctly. On the Project Revenue Budget tab I’ve added two new fields: Unit Cost and Mark Up. When the values in these fields change we want to update the Unit Rate. I’m using the FieldUpdated event to do this and everything works great. The problem is that we also want to allow the user to enter the Unit Rate manually and when that happens it needs to update the Mark Up. This also works fine but the issue is that when the Mark Up is updated from the change in Unit Rate the FieldUpdating event on the Mark Up is called and then updates the Unit Rate again. Currently my Mark Up rounds to two decimal places. Because of the rounding on the Mark Up the Unit Rate is then recalculated incorrectly. Questions:1 - Can I change my precision on the Mark Up to more than two decimal places to give me more precision and prevent rounding? If so, the how?2 - Can I prevent the code from running in the FieldUpdated event for Mark Up when the Unit Rate is changed?3- Shoul
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.