Community
Discussion Forums
Develop Customizations

Develop Customizations

Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions

2,738 Topics
11,125 Replies

When you subscribe we will email you when there is a new topic in this category

2738 Topics

Most replies

Recently active Most views Newest first

MichaelShirkSemi-Pro I

asked in Develop Customizations

How to create a summary field that takes ALL filtering into account for a regular Inquiry screen?

This seems like a simple task, but I haven’t been able to find instructions that have worked.I have an inquiry screen with a simple Filter DAC for the header and a Details DAC for the grid.The grid contains a column “Commission”, and I need a summary field to display “Total Commission” either in the header or on the grid footer.I’ve found an article Calculating Grid Totals on an Inquiry Form - Acumatica Developers Blog and followed the last (most advanced) example and I’m still getting inconsistent results when I have a mixture of header filters, shared filter tabs, and ad-hoc user filters applied.I’ve been working on this for a few days and trying many different things, but always with mixed results.If nothing else works, I’m willing to consider adding an action button that has to be clicked to refresh the total.In a regular Generic Inquiry, a summary field can be defined for the footer, and the column total will reflect the total for all records in the grid view, regardless of how fi

2 months ago

HarshitaCaptain II

asked in Develop Customizations

Dropdown List not displaying

Hello experts,I have been trying to add a dropdown list to a new processing screen but, the list isn’t getting displayed. I have shared the dac and graph codes below. Please guide me out where i am getting wrong.Thanks in advance.Dac code:using System;using PX.Data;namespace MassCust{ [Serializable] [PXCacheName("Mass_Activity_Table")] public class Mass_Activity_Table : IBqlTable { #region Activities [PXDBString(50, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Activities")] public virtual string Activities { get; set; } public abstract class activities : PX.Data.BQL.BqlString.Field < activities > { } #endregion #region Source [PXDBString(10, IsFixed = true, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Source")] public virtual string Source { get; set; } public abstract class source : PX.Data.BQL.BqlString.Field < source > { } #endregion #region Cust_Lead_ID [PXDBString(IsUnicode = true, InputMas

1 year ago

AndrewAVarsity I

asked in Develop Customizations

Force close of Purchase Order via Custom SQL Script

Hi,A client is having an issue where purchase receipts have been created for a purchase order, and it is fully receipted, but the purchase order is not able to be closed as it is still thinking it needs to be receipted, as shown in the image below.I was thinking a way to close this purchase order would be to publish a custom sql script, and then remove this customisation after the script has run successfully. However, I am not sure how to update the status field via SQL. The dropdown values for the Status field show that the Closed option has a value of ‘C’, so would I set the status to ‘C’ or ‘Closed’ in the SQL query?Let me know if I can clarify anything.Kind regards,Andrew Enter PO Receipt button still showing despite order being fully receipted and billed After the Enter PO Receipt button was clicked

3 months ago

roberts40Freshman II

asked in Develop Customizations

Add a Stock Item Attribute to the Sales Order Line Grid

I am attempting to add the SQFTINBOX stock item attribute to the Sales Order Grid. I have declared a class PXAddAttributeColumns as below: public class PXAddAtttributeColumns : CRAttributesFieldAttribute{ string[] _names; bool _IsForSelector; public PXAddAtttributeColumns(string[] names, Type entityType, Type entityIDField, Type classIDField, bool IsForSelector = true) : base(entityType, entityIDField, classIDField) { _names = names; _IsForSelector = IsForSelector; } public override void CacheAttached(PXCache sender) { this._IsActive = true; base.CacheAttached(sender); } protected override void AttributeFieldSelecting(PXCache sender, PXFieldSelectingEventArgs e, PXFieldState state, string attributeName, int idx) { if (_names.Any(attributeName.Equals)) { //Out-of-box DisplayName is prefixed with "$Attributes$-" - if you need to take that off. state.DisplayName = (!String.IsNullOrEmpt

2 months ago

aaghaeiCaptain II

asked in Develop Customizations

Receiving error " 'object' does not contain a definition for 'ToList' ” when I am trying to create a List

Hello Everyone, I have a method that I am calling them in different graphs. To make this happen I have used Reflection and dynamic parameters. a part of my method require creating a List of ApproveInfo. If I copy and paste my code to each graph it works just fine but when I call it in the Generic Method I am creating, raises the below error:“Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: ''object' does not contain a definition for 'ToList''”using PX.Api;using PX.Common;using PX.Data;using PX.Data.EP;using PX.Objects.EP;using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Reflection;using static UDApprovalWorkflow.EPApprovalAutomationHelper;// I get error on the second line of my methodList<ApproveInfo> approvalSealedData = new List<ApproveInfo>();approvalSealedData = Approval.GetApproversFromNextStep_Extension(Document, assignmentMap, stepBase.Sequence, Action).ToList(); What I am doing wrong? Any help is appreciated.

2 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Make certain fields editable based SO Lines for closed order

This is almost a duplicate of this post https://community.acumatica.com/develop-customizations-288/make-certain-fields-editable-based-on-po-status-15192I’ve tried the suggestions on that post but it is not resolving my issue.I am trying to make two fields editable when the SO is CLOSED. I’ve modified the Workflow as follows:I added code as well:namespace PX.Objects.SO{ public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { #region Event Handlers protected void SOLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected baseHandler) { baseHandler?.Invoke(cache, e); var row = (SOLine)e.Row; PXUIFieldAttribute.SetEnabled<FSxSOLine.sDSelected>(cache, row, true); PXUIFieldAttribute.SetEnabled<SOLine.requestDate>(cache, row, true); } #endregion }}The fields are still not editable.I am thinking that the update cache option for the SO Lines is disabled for a closed order. If that is th

3 months ago

stephenward03Varsity I

asked in Develop Customizations

Stop save after RaiseExceptionHandling is used

Hello, I have created a custom grid which stores a list of warehouses. I have a requirement to perform a couple of checks. 1. The warehouse in the list cannot be the same as the selected warehouse. 2. A warehouse shouldn’t be entered into the list twice. I’ve added these checks onto the RowSelected event, everything appears to work fine, the red cross appears on the row with the problem and on the tab. I’ve used this code to raise the error:e.Cache.RaiseExceptionHandling<PinnSitePriority.prioritySiteID>(e.Row, inSite.SiteCD, new PXSetPropertyException(errDuplicateWarehouse, PXErrorLevel.RowError));When I click the Save button I see the following:This is exactly what I want. However, if I click into another row and the editing icon appears and then I click on the Save button... Acumatica doesn’t display the message - it ignores the errors reported on the grid and Saves the data, the Save button become disabled. Can anyone explain what is happening? I had expected that saving woul

1 year ago

DewaldHJr Varsity II

asked in Develop Customizations

Could not transform licenses file into a binary resource - Error on Solution Build

Good morning all, I recently did a local installation for Acumatica (version 2022.205.103.4522) and all the functionality is working fine, however when I tried to publish a customisation package, it fails with the following: When I opened it in Visual Studio (2022 and 2019) I get this error:..\..\licenses.licx: Could not transform licenses file into a binary resource. Index (zero based) must be greater than or equal to zero and less than the size of the argument list. As anyone else experienced this, or found a solution around this?Thanks

3 months ago

mrthanhkhoiJr Varsity II

asked in Develop Customizations

How to retrieve SalesOrder in event RowInserted of Shipment

Hi,I am implementing event handler RowInserted for Shipment with the goal: copy value a custom field from Sale Order and set it to the field on Shipment (also custom field).Here is code: protected void SOShipment_RowInserted(PXCache cache, PXRowInsertedEventArgs e) { var row = (SOShipment)e.Row; var query = new SelectFrom<SOOrder>.InnerJoin<SOOrderShipment>.On<SOOrder.orderNbr.IsEqual<SOOrderShipment.orderNbr> .And<SOOrder.orderType.IsEqual<SOOrderShipment.orderType>>> .Where<Use<SOOrderShipment.shipmentNbr>.AsString.IsEqual<@P.AsString>> .View(Base); SOOrder order = query.Select(row.ShipmentNbr).TopFirst; if(order!=null){ var orderExt=order.GetExtension<SOOrderExt>(); row.GetExtension<SOShipmentExt>().UsrIn

1 year ago

rhooper91Varsity III

asked in Develop Customizations

Detail Info from Graph Not Populating on Create

Hello,Please see below for action script to create a new issue. I successfully pass over header level information (the only field I have mapped is description, everything else defaults). However, it is not populating my detail rows from the foreach loop. Any reason this might be happening?This script is placed as an extension to the ProjectEntry class and the table that I’m selecting from is the project inventory w/ lotserial numbers. I have also confirmed that this particular ProjectID has two lines that would be created on a successful action execution.Any help would be greatly appreciated! #region Actions public PXAction<PMProject> createIssue; [PXUIField(DisplayName = "Create Issue", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton] protected virtual IEnumerable CreateIssue(PXAdapter adapter) { INIssueEntry graph = PXGraph.CreateInstance<INIssueEntry>(); INRegister head

2 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Unit testing - can I use the Acumatica sample data in SQL server?

I am just starting to learn Unit Testing. My custom graph references BAccount, Customer, and about 10 other tables which need data in them. For example, to create a customer, I need to have a Customer Class. The customer class has to reference GL accounts. (Joe falls down the rabbit hole and is never seen again).It would be a MONUMENTAL task to create the data in the caches. I’ve scoured the internet to see if I can use an actual database to use for tests. Is there any way to attach to the sample data in SQL server? If not, then Unit Testing is pretty much useless. In order to get my application certified for the Marketplace, I’m supposed to provide Unit Tests. That is just not feasible. My testing requires a full set of data like is provided in the Acumatica sample data.Any suggestions?

11 months ago

param2022Jr Varsity II

asked in Develop Customizations

Not able to add values on fieldDeaulting event

I am trying to fetch value from DB in FieldDefaulting event but the value is not reflected in the UI.This my code in graph extension.protected void SOShipment_UsrPickListPrintNumber_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (SOShipment)e.Row; SOPickingWorksheetReview tempGraph = PXGraph.CreateInstance<SOPickingWorksheetReview>(); SOPickingWorksheet txsetup = PXSetup<SOPickingWorksheet>.Select(tempGraph); SOPickingWorksheetExt rowExt = PXCache<SOPickingWorksheet>.GetExtension<SOPickingWorksheetExt>(txsetup); e.NewValue = 100; }DACExtension#region Virtual fields [PXInt()] [PXUIField(DisplayName = "# of times Pick list printed", Required = false, Enabled = false)] public int? UsrPickListPrintNumber { get; set; } public abstract class usrPickListPrintNumber : PX.Data.BQL.BqlInt.Field<usrPickListPrintNumber> { } #endregion

2 years ago

param2022Jr Varsity II

asked in Develop Customizations

Issue with adding the grid on Projects screen

I am trying to add a grid to store values to my custom DAC on Projects screen. But I am not able to add a new row. When I try to add new row the row is added momentarily and then just vanishes. I checked the trace and it is showing this exception. ComplianceDocuments view is available in the Acumatica code. My Custom DAC codeusing System;using PX.Data;namespace MyCust{ [Serializable] [PXCacheName("MyDAC")] public class MyDAC : IBqlTable { #region ProjectID [PXDBInt(IsKey = true)] [PXUIField(DisplayName = "Project ID")] public virtual int? ProjectID { get; set; } public abstract class projectID : PX.Data.BQL.BqlInt.Field<projectID> { } #endregion #region Id [PXDBIdentity(IsKey = true)] public virtual int? Id { get; set; } public abstract class id : PX.Data.BQL.BqlInt.Field<id> { } #endregion #region CreatedDateTime [PXDBCreatedDateTime()] public virtual DateTime? CreatedDateTime { get; set; } public abstract class createdDate

10 months ago

jeewanishalika20Jr Varsity II

asked in Develop Customizations

Need To validate Unit Price field in Sales Order Screen

I need to show an error message when unit price is 0 in sales order line details.User can upload the sales order line details from excel into sales order screen and according to the inventory item unit price is automatically capture from arsales form.I add fieldverifing event below like that.protected void SOLine_CuryUnitPrice_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e, PXFieldVerifying baseMethod) { SOLine row = e.Row as SOLine; if (row.CuryUnitPrice == 0) { throw new PXSetPropertyException("Unit Price should not be 0"); } }After uploading so line from excel ,If condition is true or false error message is shown.

1 year ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Need help finding the method to override on the ARPrintInvoices graph

On the Print Invoices and Memos screen, I want to override the email process. I want to intercept the process where the invoice is being emailed and remove the PDF invoice from the email and add a custom PDF invoice that has been uploaded manually instead.The first step to try to do this is to find the delegate method to override when the processor is run.I am looking at the source code for the ARPrintInvoices graph for that screen. I don’t see anywhere in that code where the process gets called. I looked for other files in the PX.Objects.AR repository and I don’t see anything like “ARPrintInvoicesProcess” etc.Can anyone help me find the place in the code where I can override the processing delegate? I think there are some cases in Acumatica where you don’t have access to certain code, but I’m hoping it is just because I don’t know where to find it.

1 year ago

charithalakshan49Varsity I

asked in Develop Customizations

Attach files to file section from process screen does not work

Hi all,I want to attach a report pdf to files section of an invoice. I tried the below code snippet. It works for a single invoice only. But when we process multiple invoices from Process Invoices screen, file is attaching only for first invoice. For other invoices, file is not attaching.Any idea about fixing this?public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);[PXOverride]public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod){ foreach(ARInvoice invoice in adapter.Get<ARInvoice>()) { //Report Paramenters Dictionary<String, String> parameters = new Dictionary<String, String>(); parameters["ARInvoice.DocType"] = invoice.DocType; parameters["ARInvoice.RefNbr"] = invoice.RefNbr; PXReportSettings settings = new PXReportSettings("AR641000"); //Report Processing PX.Reports.Controls.Report report = ReportLoader.CheckIfNull(nameof(ReportLoader)).LoadReport("AR641000", null); ReportL

1 year ago

param2022Jr Varsity II

asked in Develop Customizations

How to get certificate ?

I just completed the quiz for T200. How can I get my certificate for that ?

2 years ago

abdallaahmed61Varsity III

asked in Develop Customizations

Fire Custom Code daily

Hello guys,i have a case that i want to call an API daily in a custom function i wrote.i tried the business events but i think it dosent accept a custom code.is there a way to call a function daily in acumatica?

1 year ago

junmao01Jr Varsity III

asked in Develop Customizations

SQL view doesn't return all records.

I created a simple SQL view for table INLocationStatus in customization "TestStockLogMasterInventoryReport" Create VIEW [dbo].[LogoMasterInventoryReport]ASSELECT TOP (100) PERCENT LS.CompanyID, LS.InventoryID, LS.SubItemID, LS.SiteID, LS.LocationID, LS.QtyOnHand, LS.QtyOnHand AS [TotalQtyonHand] FROM dbo.INLocationStatus AS LS The table should have 212623 records. But the SQL view only returns 212213 records.I created GI for INLocationStatus, and it return 212623 records. The GI for LogoMasterInventoryReport view only return 212213 records. Does anyone know there is any records restrictions for SQL view in Acumatica? This is for 2023 R2. Thanks.

8 months ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Can I do a IsGreaterEqual in a BQL Fluent statement on a String field?

Here is my scenario.I have a table that has a range of zip codes. If the left 3 characters of the Ship Address zip code fall in the range of “lower” and “higher” I want to select that record.Example:Ship Address Zip is 100234.In my lookup table, the lower is 100 and the upper is 130.So the left 3 digits of the zip (100) falls in the range.In my BQL statement, I do not see a way to do an IsGreaterEqual using the string value. It causes errors.This is what I want to do:ICSFSSScheduleLine item = SelectFrom<ICSFSSScheduleLine> .InnerJoin<ICSFSSSchedule> .On<ICSFSSSchedule.scheduleID.IsEqual<ICSFSSScheduleLine.scheduleID>> .Where<ICSFSSScheduleLine.scheduleID.IsEqual<@P.AsString> .And<ICSFSSScheduleLine.lower.IsGreaterEqual<@P.AsString>> .And<ICSFSSScheduleLine.upper.IsLessEqual<@P.AsString>> .And<ICSFSSSchedule.active.IsEqual<True>>> .OrderBy<Asc<ICSFSSScheduleLine.lower>, Asc<ICS

4 months ago

dharmendarm43Freshman I

asked in Develop Customizations

About Customization in Contact PopUpForm of ContactGrid in Customer Screen

Hi, I want to Customize Contact Popup Form of Contact Grid in Customer Screen, so i added one custom Field in that Popup form ,while creating contact custom column value not updating to the Contact Table, please suggest me on this

2 years ago

MichaelhSemi-Pro II

asked in Develop Customizations

Add Import from Excel Button 21R1

I’d like to add an import from Excel button to the Payments and Applications grid on screen: AR302000I can see some stuff online, but it’s ancient. For 2021 R1, how do you add that feature to a screen? I’m barely competent with things like PXSelect<>, so brace yourself for crazy questions :D Thanks,

1 year ago

ppowellSemi-Pro I

asked in Develop Customizations

Is there any way to override the from address in certain cases on the generated label when confirming a shipment?

We allow our customers to drop-ship items to their customers directly from our warehouse. We need a way to override the label generated by CONFIRM SHIPMENT in certain cases and put the customers from address instead of our address. Is there any way to do this already or how complicated is it to do this? I was thinking of an identical button next to the CONFIRM SHIPMENT button that would do the same process but insert the customers address info instead of our address.I’m just trying to see if this is an option at this stage or even if there is a better way to do this.Thanks,Phil

8 months ago

jeewanishalika20Jr Varsity II

asked in Develop Customizations

Base.Document Is not support Acumatica 2022 R2

Hi,I tried to do some customization in my acumatica Erp (2022 R2).When I add the Base.Document.Current method it shows an error below like that.Is it not valid? Please help me.Thanks you

1 year ago

darylbowman

asked in Develop Customizations

How can I programmatically assign a Related Entity

I need to programmatically tie an email to a Case. The code I have makes some kind of association, because the email will display in the Case activities. However, the email ‘Related Entity’ field remains blank. Here’s my code:Base.CurrentMessage.SetValueExt<CRSMEmail.refNoteID>(email, taxCase.NoteID);email = Base.CurrentMessage.Update(email);Base.Actions.PressSave();In the database, the field is being correctly set, but the UI does not reflect the change.

2 years ago

Page 5 / 110

Badge winners

aiwanhas earned the badge Distribution expert
ebenrouxhas earned the badge Easy talker
aiwanhas earned the badge Manufacturing expert
wfilipiak67has earned the badge Acumatica expert
MSwanson86has earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.