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,I need to remove this Inserted cach while keeping the Updated cach as it is.Is there any way to achive this?Thanks.
Hi everyone!I have a custom popup and I need to clear view’s cache on the popup closing (after clicking on the close button). is it possible to track the window close event?I also found the OnClosingPopup attribute, does anyone know in which cases it is used?[PXButton(OnClosingPopup = PXSpecialButtonType.Cancel)]
we upgraded the version from 22r2 to 23r2. after rebuild the solution while try to open in browser for login page getting the following error.
Hi there, I am trying to override the address line 1 on Shipment screen by defaulting it to the User Defined Field selection (pointing to Customer table). However, when I got this error when I try to test it: Below is my DAC as well as code for your reference:DAC:using System;using PX.Data;using PX.Data.BQL;using PX.Objects.SO;namespace PX.Objects.SO{ [Serializable] [PXCacheName("SOShipmentKvExt")] public class SOShipmentKvExt : IBqlTable { public abstract class recordID : BqlGuid.Field<recordID> { } [PXDBGuid(IsKey = true)] public Guid? RecordID { get; set; } public abstract class fieldName : BqlString.Field<fieldName> { } [PXDBString(50,IsKey = true)] [PXUIField(DisplayName ="Name")] public string FieldName { get; set; } public abstract class valueNumeric : BqlDecimal.Field<valueNumeric> { } [PXDBDecimal(8)] [PXUIField(DisplayName = "Value Numeric")] public decimal? ValueNumeric { get; set; } public abstract class valueDate :
If you’re like me, you don’t enjoy typing out long BQL queries, or writing all the boiler plate code for a new DAC, with all its properties, abstract classes, and attributes.Here’s a little tip I’ve discovered to save me a lot of time there.This is one of the very positive uses for ChatGPT, and writing boiler plate code is something it is quite good at, if you use a GPT that has been trained specifically for Acumatica. This is NOT a sales pitch, but on the GPT store, you can get the Acumatica Developer Assistant GPT (by Evan Trowbridge). The usage is throttled, but you can still use it a few times per hour for free. It is substantially more accurate than regular ChatGPT. A simple prompt with a few instructions can get you most of the code for a DAC in a few seconds. You’ll still need to make some adjustments, but this will get you 95% of the way there.Here’s a small example. I will probably refine my prompt so I can add more information to it and have the resulting code more complete,
There are three tenants in our Acumatica Instance. For the purpose of creating a SQL view, we used the below DB Script.create or alter view ardiscountView asselect ROW_NUMBER() OVER(ORDER BY Usrdiscountcoden ASC) row,RefNbr,TranType type,Usrdiscountcoden discount,sum(CuryDiscAmt) amount from artran where Usrdiscountcoden is not nulland CompanyID=2group by RefNbr,TranType,UsrdiscountcodenBut in here we had to hardcode the CompanyID. But we want dynamically pick the CompanyID depending on the current tenant. If you can provide a way to perform this it id highly appreciated.
I have 2 tenants in one Acumatica instance, one is for testing and the other one is the live tenant.When I publish a Customization Project in test Tenant I can see the same changes in Live tenant as well.I don’t want this to happen. Is there something that I have to anything specific to handle this?Can anyone advise me on the best practices of publishing customization projects?Thank you.
Hi,I have a requirement in Acumatica to retrieve the system time when a user saves a form for the first time. I need to use this system time to perform a calculation and update a field value on the same form. Is there a method to get the system time in Acumatica? If so, could you please provide detailed steps or guidelines on how to achieve this?Thank you in advance for your assistance!
Hi All,I’m just getting started with the Test SDK, and I’m following the starter guide on GItHub (Acumatica/Test-SDK-Starter-Guide (github.com)) , but I cannot get past the “Could not read configuration file: Illegal characters in path.” error. I updated the command line to point to the config file, I’ve downloaded the original project multiple times, but I keep hitting the same issue.Feel like I must be missing something simple.Error and Parameter shown in below screenshots.
I want to add the address field to the selectors commonly used on the Contacts, Leads and Opportunity tables. I have to join the address table to make this happenI looked at this post, but don’t think it will allow me to join the additional table.Is there a way to add Contact.displayName to the columns in the Selector for the Customer Lookup in an SO? | Community (acumatica.com) It's a large effort to modify every field using a Contact, Lead or Opportunities to add this join and additional column, is this the only way? This is the code I am using for the Contact table ContactId field. it looks to work in most cases however when navigating to the contact screen from an opportunity when clicking on the contact field edit button (the pencil button) I get the following error.“Conversion failed when converting the nvarchar value 'Leif' to data type int.” Leif is my name, so that is a clue. #region Contact_ContactID_CacheAttached [PXMergeAttributes(Method = MergeMethod.Merg
Can I make a button to call a popup whose contents are the designer's report, which I made previously? and the report parameters or filters are filled in via the action button method in pxgrap ?
I want to change the sort order when printing checks from RefNbr to Vendor AcctCD. In my override, I am adding one additional line to the select statement. If I use the original code, it works normally. If I use my code which only adds this line to the statement: OrderBy<Asc<Vendor.acctCD», the process screen “resets” after you select the payment method “Check”. public class APPrintChecks_Extension : PXGraphExtension<PX.Objects.AP.APPrintChecks> { [PXOverride] public virtual IEnumerable GetAPPaymentList() { //Original //var cmd = new PXSelectJoin<APPayment, // InnerJoinSingleTable<Vendor, On<Vendor.bAccountID, Equal<APPayment.vendorID>>, // InnerJoin<PaymentMethod, On<PaymentMethod.paymentMethodID, Equal<APPayment.paymentMethodID>>, // LeftJoin<CABatchDetail, On<CABatchDetail.origModule, Equal<BatchModule.moduleAP>, // And<CABatchDetail.origDocType, Equal<APPayment.docType>, // And<CABatchDet
Hello I’m trying to update SalesOrder PurchasingDetails through this url: PUT method https://gtp.acumatica.com/entity/DefaultEndPoint/23.200.001/SalesOrder/?$Expand=Detailsusing this script:{ "id": "91bdadf9-ef21-ef11-835e-06ae6affe5a5", "Details": [ { "id": "c5ce115a-f021-ef11-835e-06ae6affe5a5", "PurchasingDetails": [ { "POOrderType":{"value":"SO"}, "POOrderNbr":{"value":"Code-000396360"}, "POOrderLineNbr":{"value":1}, "Selected":{"value":true} } ], "VendorID":{"value":"V10156"} } ] }i getting this error message: "innerException": { "message": "An error has occurred.", "exceptionMessage": "Purchase Order Line (Order Type = SO, OrderNbr = Code-000396360, LineNbr = 1) cannot be found in Purchasing Details for Sales Order line (LineNbr = 1).", "exceptio
Hi,I need to create a field in Acumatica that automatically updates its value based on the input of other fields. Additionally, this field should also be manually editable by users. Is it possible to achieve this in Acumatica? If so, could someone please provide detailed steps or guidelines on how to implement this functionality?Thank you in advance for your assistance!
Hi, is there a way we can add the “TaskTotal.Curyxxx” to Projects GI?
Hello, is It possible to add other field on the screen IN401000 as new filter that doesn't exist in the list of fields proposed in customization? Thanks.
I’ve been learning how to create screens from scratch using the new UI framework, and so far I’ve created a simple maintenance screen and a basic Inquiry screen.The maintenance screen is working just fine and the Inquiry screen is also working as expected except for one peculiar issue that I need help with that doesn’t even seem related to the new UI.(I’m suspicious I may be overlooking something obvious, but the solution has eluded me!) I am aware that the new UI is not ready for production use - I’m just trying to learn what I can so I’m ready for it!The inquiry screen is built on a simple projection DAC and combines information from SOOrder, SOLine, and SOLineSplit.The header of the screen has 2 filter fields.Inquiry header filtersThe “Only Show Completed Lines” filter is working correctly and when selected, only lines with an order status of “Completed” are shown.The “Warehouse” filter returns 0 records when a filter value is entered. No Matching Records FoundI’ve shared screenshot
On the Purchase Orders Screen (PO301000), I’m trying to extend the View responsible for populating the Details Tab. Specifically, these details are made up of Purchase Order Lines (POLine) which each have an InventoryID, which is the identifier for an InventoryItem. I want to be able to add data fields from the Inventory Item to this View in order to be able to add them to the Details Tab Grid. Does anyone know how to do this? Below is my attempt to override the original PXOrederedSelect responsible for creating the Data View that populates the Details Grid. I add the PXOverride and the LeftJoin logic, but everything else is the original code.[PXOverride] [PXViewName(Messages.POLine)] [PXImport(typeof(POOrder))] [PXCopyPasteHiddenFields(typeof(POLine.closed), typeof(POLine.cancelled), typeof(POLine.completed))] public PXOrderedSelect<POOrder, POLine, LeftJoin<InventoryItem, On<POLine.inventoryID, Equal<InventoryItem.inventoryID>>>,
Hello, I have created a workflow action in screeens FS300200 with a dialog boxes associate to it. The dialog box is working well on web browser both on computer or mobile. When i use the mobile app, the screen dont show or is shown empty if the action “the Expose to Mobile” is cheked.Preview of the dialog box In customization project > mobile application, i have added an update FS300200. My issue is i dont see the dialog boxes created for the screen in the WSDL schema so the container is incorrect. Is there a way to have accces to those kind of dialog box or i will need to create a custom smarth panel for mobile? Code in mobile APP (I have try the container where is see my field)update screen FS300200 { update container "AppointmentRecords"{ add containerLink "Attributes" add recordAction "SurveyToDo" { redirect = true redirectToDialog = "FS300200D6" } } add dialog FS300200D6{ type = FilterListScreen openAs = Form add dialogAction "Ok" {
CASE : Let's say we have attached a File on a Vendor.Process: 1. Create PO 2. More Options > Click On Email Purchase Order3. The File attached in the Vendor, should be displayed on the Email Activity Screen WHAT WE IMPLEMENTED :you can refer to the code mentioned below ISSUE WITH THE CODE :The implemented Code is that when we Create an Activity, it is not being attached on the first Time.But when we Create an Email activity for the Second Time for the Same PO, it is Attached.We tried implementing Row Inserted, Row Persisted Events, but the Event is not hitting when the email activity is Created. WHAT WE NEED HELP WITH :To fetch the files attached to the vendor, in the First Go Code we Implemented: Image 01 Image 02
Hi Team,I have customized a screen and action button to insert list of records into my custom table. I can able to insert single record at a time, but array list fails. Could you please provide me the correct JSON format for inserting array of records.I tried the below format but it’s not working.[ { "ScannedId": "14", "ShipmentNbr": "SDO592042", "LineNbr": 1, "Quantity": 1.000000 }, { "ScannedId": "15", "ShipmentNbr": "SDO592042", "LineNbr": 2, "Quantity": 1.000000 },] Regards,Ramya
I added a new column to the grid in the "Prepare Replenishment" screen (IN50800) please refer the image below: Please note that I have marked the column header which is added as a custom column.Please refer the code below:namespace PX.Objects.IN.S{ public class INItemSiteExt : PXCacheExtension<INItemSite> { public class ProgNameAttributeID : BqlString.Constant<ProgNameAttributeID> { public ProgNameAttributeID() : base("PROGNAME") { } } #region UsrProgramName [PXString(255, IsUnicode = true)] [PXUIField(DisplayName = "Program Name")] public virtual string UsrProgramName { get; set; } public abstract class usrProgramName : BqlString.Field<usrProgramName> { } #endregion }}Graph extension:namespace PX.Objects.IN{ public class INReplenishmentCreate_Extension : PXGraphExtension<INReplenishmentCreate> { #region Event Handlers protected void INReplenishmentItem_RowSele
Has anyone created a customization to automatically attach files to an invoice? We need a solution where we can attached service order reports to SO invoices upon emailing. Someone submitted an idea on this matter 2 years ago, with several upvotes, but Acumatica hasn't acted on this yet.
I added a custom field UsrHoldForPaymentProcess to the Bills and Adjustments screen. This field gets created in the APRegister table. It is a checkbox to indicate that we do not want to show this bill on the Approve Bills for Payment screen. On the Approve Bills for Payment screen, I want to only show Bills that do not have the UsrHoldForPaymentProcess field set to true.One problem I see is that the select statement for the Approve Bills screen pulls from APInvoice, not APRegister. To adjust what gets displayed in the grid, I want to override this method in the APApproveBills graphprivate static Type getAPDocumentSelect(bool groupBy = false) I cannot seem to get the override correct as I get an error that the signature does not match.public delegate Type getAPDocumentSelectDelegate(bool groupBy = false);[PXOverride]public static Type getAPDocumentSelect(bool groupBy, getAPDocumentSelectDelegate baseMethod) I tried to do what would seem like the EASY approach by adding a Where to the
Hey Guys, Summary:We are experiencing an issue with saving changes made to the Project Attributes (attributes section of the PM304500 screen) when they have been modified. The goal is to save the changes automatically when a project attribute is updated. However, attempts to implement this using the PXLongOperation class have not been successful, and we encounter the error "The record could not be saved".Detailed Description:We have implemented a customization for the PMQuoteMaint graph to save changes to project attributes automatically when they are modified. This involves setting a flag when an attribute value changes and then attempting to save the changes using a custom action with PXLongOperation.Despite various attempts, the save operation fails, and we receive the error "The record could not be saved". Below is the code we have used: using System;using System.Collections;using System.Collections.Generic;using System.Linq;using PX.Common;using PX.Data;using PX.Objects.CS;using P
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.