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 created a very simple sub-report with the below specifications. Please see the below screenshots.Parameter of the sub reportFilter in sub reportThis sub-report worked well after being published in the instance. But when I connect this sub-report with my main report, data from the sub-report is not coming. Please see the below screenshot. Main report with sub reportPlease give me a support to overcome this issue. Thank you.
Hi,In the receive and put away form, when the item is lot/ser I want to enter separate lines even if the lot or expiration date is the same. It is possible? I dont want to create multipe receipts. Which method I can edit or replace? Thanks,EV
Hi!I’ve trying to deploy the ability to print the SalesOrder/Quote report in the Mobile App. I follow the code described in this article Acumatica but nothing happens. The PrintSalesOrder/Quote action doesn’t appear in the container “Order Summary”. I was able to add the report screen in the main menu but i want to have the redirect within a specific Sales Order record.Anybody know what is missing?Thanks!
How do I add a “Total Budget” column to current P&L? I have report design rights.
I tried following the instructions from the link below to create a hyperlink in a grid; however, I am receiving an error message during validation/compile, (error message below. The code snippet also here shows what I have written. public PXAction<CRCase> ViewCase; [PXButton] protected virtual void viewCases() { CRCase row = CasesGraphView.Current; string caseCD = row.Casecd; CRCase casenbr = PXSelect<CRCase, Where<CRCase.casecd, Equal<Required<CRCase.casecd>>>>.Select(this.Base,row.Casecd); CRCaseMaint graph = PXGraph.CreateInstance<CRCaseMaint>(); graph.Case.Current = casenbr; if (graph.Case.Current != null) { throw new PXRedirectRequiredException(graph, true, "Cases"); } } How to create a hyperlink user field in a griderror CS0029: Cannot implicitly convert type 'CustomerCasesTab.CRCase' to 'PX.Objects.CR.CRCase'Does anyone have some direction on what I h
Has anyone come across - is it possible to add a document to this page using Rest API. Which API entity can be used for this. I tried to find a separate document or find a link to the vendor, but I can't find it. The vendor can expand the api using the WebService Endpoint, but there the work is carried out not with a collection of documents, but with one - and there is a warning that the documents must be requested one at a time and not included in the upload, the message is not clear what is available and how to do with this. Does anyone have experience with this entity using Rest API, I will be glad for any ideas
Hello Everyone, kindly advise, How to add below Addressline1 & Addressline2 details from customer Location screen(AR303020) to existing Sales Order screen(SO301000) in Location field. Data Class: SOOrder and field name is CustomerLocationID from Sales Order screen .
We are relatively new to Acumatica and we are looking for an easy way for our AR people to see what a customer owes in each of the aging buckets when they call to make a payment. Most of our customers have consolidated accounts - meaning one parent account with a number of children accounts rolling up to the parent. When a customer calls in to make a payment we are not able to easily see what they owe as a function of aging. All we get is a balance amount which includes everything including the invoices that will appear on next months statement. Ideally we would like to be able to go to the customers screen (AR303000) see what they owe in each of the aging buckets then click the Create Payment action which opens the AR302000 screen and have it show the aging amounts for the customer there as well. Right now we have to bounce around between various reports, write down the amount and then go to the payment screen and create the payment. Has anyone heard of or done anything with displayin
I have created a new grid in Cases where when you populate the Relations grid tab with invoice documents it then populates this new grid called CAMRelations with all of the invoices entered in the Relations tab.Right now, I have it working where the CAMRelations grid pulls the invoices one at a time from the Relations tab, but I want it to populate with all of the invoices from the Relations tab, not simply one at a time. If you highlight each item in Relations the CAMRelations pulls the correct invoice information, but again only one at a time and not a list of the invoices from the Relations grid.The screen shots below show what I am seeing.Basically below is the logic I want to use, it simply fails validation. So I do not know what I should do for this. var items = Base.Relations.Select().FirstTableItems.ToList(); foreach (CRRelation item in items) { PXSelect<ARInvoice, Where<ARInvoice.noteID, Equa
Hi,I have developed a new report in acumatica.I need to the create variable and need to the add above highlighted fields into the variables.and then all the values i need to the show in the header level.Can u please give the suggestion to that.
I have read through several posts here but am still have a problem trying to put the sum of a column from multiple rows of a grid into a header column. I have seen code snippets, however, I think I am not arranging my code correctly.I am still very new to Acumatica coding. Below the error message is the full CS code I am using. Everything validates and compiles, but when I try to access the Cases screen I receive this error message. So I obviously do not know where and what I need to do here.Can someone point me in the correct direction?What I am trying to do is on the Cases screen, use the Relations tab to associate Invoices to a Case and then in a new grid populate that grid with all of the invoice information from the Relations tab. (the other problem I have is that the new grid called “CAM Relations” only lists one invoice at a time, but that is a different problem not for this topic; unless dear reader you know what I am doing wrong there also).Then I have a UDF in the header
Ive developed a custom SQL view and associated DAC which generates a table of available quantities of stock kits.Im trying to show the Qty in the Sales Order by adding PXDBScalar to the SOLine DAC detail screen however I keep getting null? namespace AutoKitAssembly{ public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine> { #region UsrKitQtyAvail [PXDefault(TypeCode.Decimal, "0.0")] [PXDBScalar(typeof(Search<KitAssy.qtyAvail, Where<KitAssy.builtItemID, Equal<Current<SOLine.inventoryID>>, And<KitAssy.siteId, Equal<Current<SOLine.siteID>>>>>))] [PXUIField(DisplayName = "Kit Qty Available")] public virtual int? UsrKitQtyAvail{ get; set; } public abstract class usrKitQtyAvail: PX.Data.BQL.BqlInt.Field<usrKitQtyAvail> { } #endregion }}
I have a custom mater-detail screen and all standard action buttons including Copy & Paste. When I try to copy and paste an existing dataset to a new form, I get an error. I was wondering does Acumatica’s engine itself handles the copy and paste operations or I should write a custom code for it?
Hi expert.I want Show Total Line Show Pages Nbr - Calculate Depreciation FA502000 (same in Sale Orders Screen). Can you help me? Very thank everyone.Reference topic: Same topic
Hello Community,Does anyone know how to prioritize loading the extensions? Let's say I have two or more extensions on a base graph. How we can educate the platform on which one should be executed first and which one next? or necessarily I should declare my Graph Extensions hierarchical? For example, if I have a MyExtA that has priority over MyExtB I should do public class MyExtA : PXGraphExtension<BaseGraph> {}public class MyExtB : PXGraphExtension<MyExtA , BaseGraph> {}
I imported and published a customization project package which I received from another. When I proceed to project folder of the instance that I imported the package there are no any .cs files only the moveControl folder.Please check the below image.Project folder of the imported customization project packageProject Editor Screen of the imported project package But I want to obtain the .cs files of this imported package like in an ordinary customization project in my local instance as follows. Can you please give me some guidance to obtain code files of this imported package? Thank you.
Hi,I have to get Account Id ,Transaction Description from APTran Table and adjusted amount from ApAdjust Table for my Payment Voucher Report.I need to join ApPayment Table with APAdjust Table and ApTran Table.1st I joined ApPayment Table(column - RefNbr) and ApAdjust Table(column-AdjgRefNbr) below like that. Then I joined ApAdjust Table(column - AdjdRefNbr) and ApTran (column-RefNbr)Table below like that.But,After adding 2nd join report designer show below error. If we remove the second join error is gone. Can you give the solution for this issue.Thanks
Hello,We are getting started and I would like to learn how to create Generic Inquiry and how to customize dashboards for users. Does anyone know of any tutorials or guides on creating them and some useful GI so I can start learning how to create them.Thanks
Hello,I am currently going through training, trying to generate a custom object and have it be able to be interfaced via the workflow engine ui. However, when I attempt to add a field to the “State Identifier” field on the workflow interface, it does not return any available values. I plan to debug.. but figured I would put this on the community to see if there is something that immediately jumps out that I’m doing wrong. Thanks in advance, code snippet for DAC and Graph below.Note: I realize that I’m taking a shortcut by not creating a helper class for the status values (perhaps to my detriment).. figured I would give it a shot before I go the effort to build out entirely.If I were to guess at what the problem is, I’m either not decorating the DAC or field with an attribute to signal to the engine that its a valid field to build the workflow off of. I’m trying to get away from having to code the workflow by hand.DAC:using System;using PX.Data;namespace BlyTestObject{ [Serializable]
I currently have the scan move screen customized to flow into the Qty State automatically to allow for a qty to be scanned in.However I would like the user to have the option to hit enter and skip the step, which would ideally pass a default qty of 1.The issue I’m running into is that the barcode field won’t allow the user just hit enter to pass a null value.Is there a way I can have null values passed through on that field?Thank you.
public class NewTest : PXGraph<NewTest> { public PXFilter<TestFilter> Filter; public PXCancel<TestFilter> Cancel; public PXFilteredProcessing<APPayment, TestFilter, Where< APPayment.docType.IsEqual<TestFilter.docType.FromCurrent>. And<TestFilter.fromDate.FromCurrent.IsNull. Or<APPayment.adjDate.IsGreaterEqual<TestFilter.fromDate.FromCurrent>>>. And<TestFilter.toDate.FromCurrent.IsNull. Or<APPayment.adjDate.IsLessEqual<TestFilter.toDate.FromCurrent>>>>, OrderBy<Desc<APPayment.createdDateTime>>> CheckPayments; [PXHidden] public class TestFilter : IBqlTable { #region IsVoid [PXString(3, IsFixed = true)] [PXUIField(DisplayName = "Doc. Type")] [PXDefault(APDocType.Check)] [PXStringList( new string[] { APDocT
Hi,I need to know, If I created a DAC extension table for the POline table and create a orderType field for the DAC extension.Is it possible to get same orderType column data inside in the POLine table into my DAC extension orderType field.ex: POline row 1 OrderType is ‘standard’ and My DAC extension orderType is same to with ‘standard’ type.?
I’m starting to get really frustrated with processing screens lately, but maybe I’m just bad at making them. The latest frustration is that when I use ProcessingView Lines, the screen looks like a processing screen: But when I use ProcessingView.FilteredBy<PODDocumentsFilter> Lines, all the processing tools go away: I have defined the data view like this:public PXCancel<PODDocumentsFilter> Cancel;public PXFilter<PODDocumentsFilter> Filter;[PXFilterable]public SelectFrom<SOPackageDetailEx>. InnerJoin<SOShipment>. On<SOPackageDetailEx.FK.Shipment>. LeftJoin<ISSOShipmentTrackingPOD>. On<ISSOShipmentTrackingPOD.FK.PackageDetail>. Where< SOPackageDetailEx.customRefNbr1.StartsWith<fedEx>. And< Brackets< PODDocumentsFilter.action.FromCurrent.IsEqual<actionDownload>. And<ISSOPackageDetailExExt.usrIsPODDownloaded.IsEqual<False>. Or<ISSOPackageDetailExExt.usrIsPODDownloaded.IsNull>>. Or
We’ve noticed this a few times at different clients but I don’t have a smoking gun to bring in tech support so I’m looking to see if anyone else has had similar experiences.When there has been an update due to Windows/IIS/SQL security patches, or some other update on the Acumatica side, that we find that sometimes a customization project has reverted back to a prior version. We’ve seen source code within the project revert and we’ve seen cases where a DLL appears to have reverted back one version.Last night our clients production site had some updates and this morning they called with some configuration related issues. We checked on fields in a setup screen and discovered that some fields were blank causing invoices to be missing a default cash account value. These fields were populated the day before because it prevents invoices from being posted. We filled in the missing values and everything went back to running smoothly - like it has been for weeks.Like I said, we don’t have a smok
Has anyone created or attempted to create a customization that would provide a user interface where an Excel file containing multiple rows of PO Receipt information could be used to generate multiple receipts based on a PO Number being associated with each row? Basically, a grid interface like is typically seen in various components of Acumatica wherein a “user” simply imports the desire info. This would alleviate the need to use an import scenario, which we do not want most users to touch. It would be a tremendous efficiency gain for those processing PO Receipts. Currently, my users have the worksheet and they have to split the information out into separate files to perform the grid level import for each individual PO Receipt. I’m hoping someone else has thought of and created such a customization. I’m too new to Acumatica to create what I believe is a more complex customization.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.