Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hello everyone!I am trying to customize our SO workflow to change the state of a sales order based on conditions of sales order lines. By default I am not able to reference any of the SO Line fields in a condition for the SO301000 screen. Is there a way to add the SO Line fields so that I may reference them in a condition to automate the workflow changing the order status?For example I want to set up a condition like this:SO Line Description contains “Bar”ANDSO Line Qty over “200”Any and all help with this will be greatly appreciated!
I don’t want user to save the record if there is any error, I wrote a custom fieldverifying event for the RQRequestLine and it works fine when the values is selected however, it allows user to save the record event if there is rowpersisting event written that calls fieldVerifying event. protected void RQRequestLine_RowPersisting(PXCache cache, PXRowPersistingEventArgs e) { var row = (RQRequestLine)e.Row; if (row != null) { object newValue = row.ExpenseAcctID; this.Base.Lines.Cache.RaiseFieldVerifying<RQRequestLine.expenseAcctID>(row, ref newValue); } }protected void RQRequestLine_ExpenseAcctID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e){ // logic cache.RaiseExceptionHandling<RQRequestLine.expenseAcctID>(row, Act?.AccountCD, new PXSetPropertyException(Messages.Test, PXErrorLevel.Error, row.Expen
I have a two part segmented key, first part variable, second part auto incrementing number. For some screens I would like to set the default on a new Key to be ‘CUS-<NEW>’ rather than what is shown now ’ -<NEW>’ (three spaces and -<New>).How can I set one of the segments value on a new key for the default value?
How can we allow the negative quantity for the stock items when we add the line items on the sales order screen ? I tried using the SOLine_OrderQty_FieldVerifying event and was able to suppress the warning. But it still gives out an error while saving which I am not able to figure out.
Hi,Can we change the customization project screen id into new id and aspx file with same new id after publish the customization project.
Hi,I have some logic which is implemented via html,css and javascriptIt opens this form in browser and calls one API for further workMy goal is to do same for AcumaticaIs it possible to insert this form to Acumatica window ?I mean now it opens just in new tab in browser, does it possible to pass this from to Acumatica window like this ?Is it possible to do that without work with screen graph by adding new element, adding new screen and writing new business logic in Acumatica ?I have ready API and I just need to call it in new Acumatica window not new browser tabThanks in Advance
I am looking for the correct format to open a NEW PO screen from a link. I have a Tableau report I run from the site map inside Acumatica. I want to be able to pass over the vendor code and item and qty to the new PO screen.
Iam very new to Acumatica.Iam using Acumatica 2022 R2. I get error on below line before while practiced in T210 Certification. Still I am not clear. Does anybody can help me to clear this error on below line with DAC Fields Declartions.using PX.Objects.CT;[PXFormula(typeof(ContractTemplate.durationType.FromSelectorOf<RSSVWarranty.contractID>))]Error Message :- CS0426 - The Type name ‘FromSelectorOf<> does not exist in the type ContractTemplate.durationTypeThanks
If this looks familiar, I asked a question the other day about this issue. I resolved everything in that question except for this part, so I am re-asking based on the remaining open issue I am having.I added a column to a selector “typeof(USRBudgetTotalExt2.usrBudgetTotal)”. The column value is being derived from an extension. In that extension, I want to execute a BQL query to get a sum of the curyRevisedAmount field from the PMBudget table.My code currently returns a hardcoded amount of 100 just for proof of concept that my selector is working and returning the value for the column based on the extension.Looking good so far! :-) This is the code at this point.namespace PX.Objects.PO{ //[PXNonInstantiatedExtension] public class PO_POLine_ExistingColumn : PXCacheExtension<PX.Objects.PO.POLine> { public static bool IsActive() => true; #region ProjectID [PXMergeAttributes(Method = MergeMethod.Append)] [PXCustomizeSelectorColumns(
On the Subcontracts screen I want to add a custom column to the Project ID selector.The value will come from the Details tab of the Projects screen (sum of Revised Budget Total)I’ve tried numerous ways to do this. This is what I am trying at the moment. I am simply trying to put a dummy string into the custom column as a proof of concept before doing any BQL selects at this point.namespace PX.Objects.PO{ [PXNonInstantiatedExtension] public sealed class PO_POLine_ExistingColumn : PXCacheExtension<PX.Objects.PO.POLine> { public static bool IsActive() => true; #region ProjectID [PXMergeAttributes(Method = MergeMethod.Append)] [PXCustomizeSelectorColumns( typeof(POLine.alternateID), typeof(USRBudgetTotalExt.usrBudgetTotal))] public int? ProjectID { get; set; } #endregion } public sealed class USRBudgetTotalExt : PXCacheExtension<PX.Objects.PO.POLine> { public static bool IsActive()
I wanted to attach the invoice PDF file to the same invoice report. Is there any method to solve this?
Hi,I need to get Base currency rate(USD Conversion Rate) in the sales order report.Below sales order created under EUR currency and sales order report amount need to convert into USD amount.I get the currency rate from CurrencyRate table.But , this data related to EUR and order date is different from sales order currency rate.Sales order form is show the correct value.Can u please help me with this.
Hello I am working on customization screen ( Project Transaction Details) I want to add new selector field to the exisintg Enquiry screen. The problem I am facing is 1) The exsiting acumatica DAC Filter values, they are hidden and in same graph(TransactionInquiry)2) When I try to extend this filter and add new filter (i.e a new selector), it is not showing in my customization screen.3) I feel, as existing fields are all unbound and its hidden, my newly added extended dac filter selector is not exposed and does not recognize the TranFilter DAC. [PXHidden] [Serializable] [System.Diagnostics.CodeAnalysis.ExcludeFromCodeCoverage] public class TranFilter : IBqlTable { #region ProjectID public abstract class projectID : PX.Data.BQL.BqlInt.Field<projectID> { } protected Int32? _ProjectID; [Project(typeof(Where<PMProject.baseType, Equal<CT.CTPRType.project>, And<PMProject.nonProje
Hello everyone,I need to add the files field on the summary area as specified below. Kindly assist.Any kind of response will be highly appreciated.Thank you
Hi all,I have a Generic Inquiry which triggers a business event on “Record Inserted”.The point of this is to trigger a downstream process when a new Customer Location is inserted (from AR303020 let’s say). This works in principle, however we’re finding the following issue:If a user enters anything other than basic information on the location record, let’s say someone picks from a user defined field or some other association; when we’re consuming the data in our custom business event subscriber, The locationID key field from the Location table is being passed through as zero. If the user just fills in basic information then the correct new id for the Location is passed.It’s as if the event is being kicked off before the Location record has been persisted to the database.We have a number of joins on the Generic Inquiry so in theory I guess it is data being persisted in those tables that is triggering the event too early (for our needs).Can anyone shed any light on this behaviour? We need
I have a project that has evolved over the years. This project is only for use by one client. For example, when I first deployed the project, table SSGNCR had 10 columns. Over time, I’ve added fields and even changed field sizes/types.I now have this project with the original Custom Table Schema and a bunch of DB scripts that update the original schema.I had a case this week where the client went to publish an update to the project and they accidentally published a previous project. Somehow, this deleted data from some of the fields in the table. I am assuming one or more of the sql scripts was run even though it had already been applied. To change a field size, there are scripts that create a temp column, drop the original, recreate the column with the new size, copy the data back into the revised column, and delete the temp column. This may have been the culprit. We are now trying to recover the lost data from those fields. I am somewhat surprised that any of the previous scr
I am getting the “GetItemExtension failed.” error while changing the value of the Group by Task checkbox in revenue budget tab of Projects screen (PM301000). I am trying to add RowSelected event to implement my logic to display my custom column. protected void RevenueBudgetFilter_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { RevenueBudgetFilter row = (RevenueBudgetFilter)e.Row; if (row == null) return; if (row.GroupByTask ?? false) { PXUIFieldAttribute.SetVisible<PMRevenueBudgetExt.usrField>(this.Base.RevenueBudget.Cache, null, false); } else { PXUIFieldAttribute.SetVisible<PMRevenueBudgetExt.usrField>(this.Base.RevenueBudget.Cache, null, true); } }
I know how to add the quick search using Ext Properties/FastFilterFields under Layout Properties but how do I add the “All Records” pull down with the filter icon? (see screen shot)I thought setting Ext Properties/AllowFilter and Ext Properties/AllowSearch to both be “True” would add that, however, it did not. Under Layout Properties what do I have to set to add those?Thank you!
I did an SOOrderExtension, in which I overwrote the Persist method to add another method when saving, I call baseMethod() before and after my custom method.This method creates a SegmentValue and an associated Sub. Now I want to save the SubID in the SalesSubID-Field of the SOLines of the Order. I get an Error that the Sub does not exist in the System. If I press Save again, everything will work just fine.I tried clearing the Cache of SegmentValue and Sub, I tried clearing all the Caches. I tried using the Sub Graph to update SOLines fields.Does anyone have an idea how I can fix this?
I added a custom field to the Equipment screen FS205000.I am looking up the AMProdID and storing it in the custom field.The rowselected handler is getting the value and it shows on the screen. I set the cache to IsDirty = true so that the user will need to click save when the rowselected does not find a Production Nbr in the custom field.If I don’t set cache.IsDirty = true, then it does not show that the record needs to be saved.When you click the Save button, it does not save the value in the FSEquipment table.This is the screen and it shows the value I am adding to the screen: IF I change the Description and click Save, it DOES save the custom field.Here is the graph extension: public class SMEquipmentMaint_Extension : PXGraphExtension<SMEquipmentMaint> { public static bool IsActive() => true; #region Event Handlers protected void FSEquipment_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (FSEquipment)e.Row; FSEquipmentExt itemExt = PXCache<FSEq
I need update on fly user-defined field if Project on Expense Receipt page was changed. Like it is happened for Customer and Location fileds automatically, select new project and this field should update. Can somebody help how I can implement it - what is the best way for it. I tried with Generic Inquiry and with event FieldUpdated for Project/Contract, but not yet successful.When I tried to get to the change of the user-defined field through the event - I do not see this field in the EPExpenseClaimDetails modelI want to take value for Project Executive field from project. I added custom field to project:
Hi,I need to create a new custom table in acumatica and load data taken from an excel file into the newly created table. Can someone provide me the work around to accomplish this?Thank you.
Hi,In the Inventory → Receiving and Transfer page I want to prevent to create a journal entry when the user release the document. I know that in the inventory preferences I have a check box for that, but I only need this for receipt and transfer. I verify the INReleaseProcess graph but I don’t find when the system create the journal entry. Thanks,Ev
Hi ,I need to get data from third party application into my acumatica instance.I already have the rest api and I checked it with postman.It will work.Then,I need to get the data into my instance using this api.What is the workaround to archive it.thanks
In Acumatica instance of 22.212.0046 version I create a Sales Order.I chose a customer on header and an Inventory in the Details tab with some quantity. I Create Payment.I Release that payment.Then Icreate a Customer Refund on Payments and Applications screen and select the corresponding Customer.On Documents to Apply tab we set the Doc. Type to Payment, select the corresponding Reference Nbr., and RELEASE the Customer Refund. The Status of Payment becomes Closed, the SOAdjust.CuryAdjdAmt (UI name - Applied To Order) field continues to have amount. In other versions this field becomes 0. See the screenshot. After I delete the Sales Order's Detail line and attempt to save the sales order. I get the following error.SO Error: The applied amount cannot exceed the unbilled balance. Please see the screenshot. Is this an Acumatica bug or I should do the Customer Refund in another way? Do I miss something? Should I, for example put some checkbox, select some dropdown value, or do something els
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.