Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
I have a customization that creates a CSV file and stores that as an uploaded file in Acumatica.Is there a way to automate so that when that file is created that it will automatically be downloaded to a shared folder?Alternatively, is there a way I can connect to Acumatica via web api and have my external web api connection automatically download a file? (the file name varies based on the creation date)I tried setting Synchronization of File Maintenance, but that does not work the way I want it to.BTW, a second question is : In WHAT table are all uploaded files stored in Acumatica? Below is a screen shot I took of where I located the “name” of the files I want to automatically download from the [dbo].[UploadFile] table in Acumatica. However, I do not know where those actual files are stored and how to pull them down in an automated way. It is highlighted in the screen shot, and there are multiple files of this again, based on the date in the file name.(yes, I actually want to DL all
I am new to Acumatica and am struggling to get a selector working in the purchase order screen. I want to add a customer field to the screen in the header area. I have created a custom field and want to use a selector to allow the user to choose the customer for the PO. Here is the custom field: [PXDBString] [PXUIField(DisplayName = "Customer")] [PXSelector(typeof(SearchFor<Customer.bAccountID> .In<SelectFrom<MOSCustomerProject> .InnerJoin<BAccount> .On<Customer.bAccountID.IsEqual<BAccount.bAccountID>>>), new Type[] { typeof(Customer.bAccountID), typeof(BAccount.acctName) }, DescriptionField = typeof(BAccount.acctName), SubstituteKey = typeof(BAccount.bAccountID))]The issue that I am having is that the selector does not get pop
Hello, I’m trying to use UnBoundFormula to aggregate some values in a detail DAC and save the result to a custom field in a header DAC. Below is my extension to the qty field on the SOLineSplit DAC. I want get the sum of allocated lines, and write this to usrQtyAllocated on SOLineExt.public class SO_SOLineSplit_ExistingColumn : PXCacheExtension<PX.Objects.SO.SOLineSplit>{ [PXMergeAttributes(Method = MergeMethod.Append)] [PXUnboundFormula( typeof(Switch<Case<Where<SOLineSplit.isAllocated, Equal<True>>, SOLineSplit.qty>, decimal0>), typeof(SumCalc<SOLineExt.usrQtyAllocated>))] public Decimal? Qty { get; set; }}Below is the definition of the custom field on SOLine where I want to write the total.public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>{ [PXDBQuantity()] [PXUIField(DisplayName = "Qty Allocated", IsReadOnly = true)] [PXDefault(TypeCode.Decimal, "0.0")] public virtual Decimal? UsrQtyAllocated { get; set; } public abstrac
What I am looking to do is simple, I want to have a workspace item which, when clicked, opens an external URL I specify in the same tab.Note : I do not want the external website to be embedded in my Acumatica screen(The external website doesn’t support that).I’ve tried several different things, but none have quite worked.One approach I took is creating a new Screen and then adding in the below code to the aspx.cs code behind file’s Page_Load callback. This got me very close but there is a pesky popup message when I try opening the page before the redirect happens. protected void Page_Load(object sender, EventArgs e) { System.Web.HttpContext context = System.Web.HttpContext.Current; String url = "https://www.acumatica.com"; context.Response.Clear(); context.Response.Write("<script language=javascript>"); context.Response.Write(String.Format("window.open(\"{0}\",\"{1}\");", url, "_top")); context.Response.Write("</script>");
Hi All,I need to clear the grid and refresh the screen once all the grid data saved to the DB. Can someone help me out?Thanks
Hi Team,Can we create a Sales Quote without entering Opportunity ID ? Note: Acumatica Version 2020R1 Best Regards,NNT
I’m trying to figure how to take a base64 string and create an attachment on an appointment. I’ve been able to do this in postman but I’m not sure what the C# code would be to accomplish this. In this post: It talks about using WebClientHelper but I’m not sure what package that is from.
Hello,I am creating a customization that will help us automatically populate rows for a new service order. The row information will be based on the attributes that are in the service order type. I cannot find the primary key or foreign key that links the service order type to an attribute.Where would I look for this linked value? Thank you,Marco 😎
Hi, For RC Orders in Sales order Screen, Basically when we bring the values from “Invoice Filter” Action it brings inventory items with invoice Nbrs in SOLine. And it Sometimes displays errror message on Qty feild “The return quantity exceeds the quantity available for return for the related invoice line AR010261, FOODCHIP36. Decrease the quantity in the current line, or in the corresponding line of another return document or documents AR010308, AR010316 that exist for the invoice line”, i Have also created another Action button in the grid,that works excatly like invoice filter action, i can bring the inventory items with invoice id to the SOLine grid, But i cannot display the error message that is being displayed with “Add Invoice Action” , Upon doing some R&D, i came to know that the error message is being displayed from “MemoCheck()” Methrod of “SOOrderItemAvailabilityExtension” graph, Hear is the sample code public virtual bool MemoCheck(SOLine line, bool persis
I need to attached XML file to File. I developed code for generate XML file and download. How is the possible way change that code to attached XML file to Files.This is my code : #region Action public PXAction<PX.Objects.SO.SOOrder> Attach; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Attach")] protected virtual IEnumerable attach(PXAdapter adapter) { // Use your favorite library to create XML file XmlDocument xmlDoc = new XmlDocument(); xmlDoc.AppendChild(xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", null)); // Create root node of XML file XmlNode rootNode = xmlDoc.CreateElement("GridData"); // Iterate rows of the DataView foreach (SOLine dacRecord in Base.Transactions.Select()) { // Create an XML Element to represent the DAC row XmlNode xmlDACRecord = xmlDoc.CreateElement("DACRecord"); // Add desired
After reload page, every page blank how to solve it.
Hello all,I have been trying to get displayed some fields of the Details tab of the Invoices (SO303000) in the Acumatica mobile app. I have been following the T410 guide and have added the following, But the mobile app doesn’t show up the fields that have been added under the “Details” Container.
Currently, a set of reports have been designed based on the type as Invoice, Debit Memo, Credit Memo and etc. Currently these reports can be accessed by the SO workspace menu items. Please check the below screenshot. Now user needs to directly run the appropriate report without navigating to workspace menu items. That means when user click the “PRINT INVOICE” button the pre designed set of report should be listed down like a dropdown and after selecting the relevant report, the report should be displayed.So if you can provide guidance to perform this customization, it is highly appreciated. Thank you.
/* I added a customization project with a single code file:*/using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.Common.Attributes;using PX.Objects.GL.Attributes;using PX.Objects.GL;using PX.Objects.PR;using PX.Objects;using System.Collections.Generic;using System;/* This field was already added to the database table with a default constraint value of false.*/namespace PX.Objects.PR{ public class PRPayGroupPeriodExt : PXCacheExtension<PX.Objects.PR.PRPayGroupPeriod> { #region SwipeAndConfirmationLock [PXDBBool()] [PXDefault(false)] [PXUIField(DisplayName="Swipe And Confirmation Lock")] public virtual bool SwipeAndConfirmationLock { get; set; } public abstract class swipeAndConfirmationLock: PX.Data.BQL.BqlBool.Field<swipeAndConfirmationLock> { } #endregion }}/* When navigating to Paychecks and Adjustments the following error occurs: Error: An error occurred during processing of the field Swipe And Confirmation Lock: Obj
Hello, good day everyone.I just started learning the Acumatica Test SDK by reading the SDK Readme, when I went to the section for creating Extension Classes for Generated Page Wrappers, I got an error at GL102000_GLSetupMaint, the error is attached in the photo below. Please help me, thank you.
In Batch Payment (AR305000) how can i export xml file include Reference Nbr, payment date, payment method using grid button. any one know solution ?
Hello, I’ve added an attribute to the Customer screen and an attribute to the Location screen.Attributes on the Customer screen. Attributes on the Location screen.I’ve finding that the attribute data is being saved to two different places.The customer attributes are saved to the CSAnswers table. I can access this easily. The location attributes are saved to the LocationKvExt table. I don’t know how to access data in these KvExt tables.PXGraph p = new PXGraph();Location location = p.Select<Location>().FirstOrDefault(x => x.LocationID == ardoc.CustomerLocationID);CSAnswers cSAnswersLocationANACode = p.Select<CSAnswers>().FirstOrDefault(x => x.RefNoteID == location.NoteID && x.AttributeID == "CHGLLOCEAN");I use the code above to access the attribute from the CSAnswers table - does anyone know how to access the data from LocationKvExt?
How to duplicate Bills and adjustment screen with same actions and workflow.
I’ve added a new string field to InventoryItem: #region UsrMCVisibility [PXDBString(1, IsFixed = true)] [PXUIField(DisplayName = "Visiblility")] [PXDefault(typeof(ItemVisibility.shopDefault), PersistingCheck = PXPersistingCheck.Nothing)] [ItemVisibility] public virtual string UsrMCVisibility { get; set; } public abstract class usrMCVisibility : PX.Data.BQL.BqlString.Field<usrMCVisibility> { } #endregionItemVisibility is a PXStringListAttribute: public class ItemVisibility : PXStringListAttribute { public const string ShopDefault = "X"; public const string Visible = "V"; public const string Featured = "F"; public const string Invisible = "I"; public class shopDefault : PX.Data.BQL.BqlString.Constant<shopDefault> { public shopDefault() : base(ShopDefault) {; } } public class visible : PX.Data.BQL.BqlString.Constant<visible> {
I am attempting to override the DAC attribute of TXAvalaraCustomerUsageType with a custom derivative. It is working on DAC extensions, however, there are some existing graphs that are already overriding with CacheAttached and if I try to do my own graph extension, it is not applying my change. For example:CustomerMaint has this:[PXDBString(1, IsFixed = true, BqlField = typeof(PX.Objects.CR.Standalone.Location.cAvalaraCustomerUsageType))][PXUIField(DisplayName = "Entity Usage Type", Required = true)][TXAvalaraCustomerUsageType.List][PXDefault("0", typeof(Search<CustomerClass.avalaraCustomerUsageType, Where<CustomerClass.customerClassID, Equal<Current<Customer.customerClassID>>>>))] protected virtual void _(Events.CacheAttached<PX.Objects.CR.Standalone.Location.cAvalaraCustomerUsageType> e) { }And I am trying to change the TXAvalaraCustomerUsageType.List (note: this is what’s in the code but the class is actually TXAvalaraCu
Hi All,I created a virtual DAC and linked that to my graph but when opening the screen it gives this error. can someone help me out?Incorrect syntax near the keyword 'WHERE'. My DAC and Graph [PXCacheName("HMRCVendorRegisterDetailDummy")] [PXVirtual] public class HMRCVendorRegisterDetailDummy : IBqlTable { #region Hmrcregid public virtual int? Hmrcregid { get; set; } public abstract class hmrcregid : PX.Data.BQL.BqlInt.Field<hmrcregid> { } #endregion #region VendorID [PXUIField(DisplayName = "Vendor", Required = true)] [PXInt] [PXCheckUnique(typeof(bAccountID))] [PXUnboundDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] public virtual int? BAccountID { get; set; } public abstract class bAccountID : PX.Data.BQL.BqlInt.Field<bAccountID> { } #endregion #region Utrno [PXString(256, IsUnicode = true, InputMask = "")] [PXUnboundDefault(P
How to change value Type dropdownlist value. i want remove some value in dropdownlist only check show in dropdownlist
Dear Team, I have created duplicate Screen and use the same graph and DAC, I want show show only related screen records when i click toolbar attached image below. When navigate through toolbar it shows both screen records. how to filter record here. I have filter separate GI & Selector Thanks,Arun.
Good day, I am having an issue updating a record in my custom table, I have a trigger in the INItemStats table, when the Maxcost changes the trigger adds a record to the custom table, these records are used in my processing screen only if their status is 0, after processing and doing the expected action I want to change the status of the record to 1, but Every attempt I do it gives me the same error, “Another process has updated EVTCMaxcost your changes will be lost”. And in the code is PX.Data.LockViolationException. I have changed the code multiple times to update, to save in the database and cleared the cache, but always get the same error. (I can’t use this. right now, because of the modification made and the method being static. )Cache.Persist(PXDBOperation.Update); this.ProcessView.Cache.Update(item); this.ProcessView.Cache.PersistUpdated(item); this.ProcessView.Cache.Persist(PXDBOperation.Update); this.ProcessView.Cache.Clear(); this.Actions.PressSave(); this.Persist();public c
Hi Team,We are using Manual tax zone for Invoice type order , when we are creating invoice to the sales order tax is not carrying to the Invoice.I’m using the 23.109 version.Tax at sales OrderTax at Invoice.Thanks in Advance.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.