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 all,I have a new customized screen . I’m adding sales orders to the grid of the screen taken from sales orders screen line level. To select sales order lines, I use a custom smart panel as below. As highlighted above, I need to avoid loading sales orders when the status is ‘Cancelled’ to my smart panel. To accomplish that, can someone help me to modify the below view definition which I already use to get values form both SOOrder and SOline DAC’s to the smart panel or any other suggestion to do it?public PXSelectJoin<SOLine, InnerJoin<SOOrder, On<SOLine.orderNbr, Equal<SOOrder.orderNbr>, And<SOLine.orderType, Equal<SOOrder.orderType>>>>, Where<SOLine.customerID, Equal<Current<APProforma.customerID>>, And<SOOrder.customerLocationID, Equal<Current<APProforma.locationCD>>>>> POrdersView;Thank you.
Hi I am stuck at a very basic requirement, where i have to make this field required at screen level. Below is Original attributes for that field.Field Name : ExpirationDateData Class : PX.Objects.CR.CRQuoteOriginal Attributes: [PXDBDate(BqlField = typeof(Standalone.CRQuote.expirationDate))] [PXMassUpdatableField] [PXUIField(DisplayName = "Expiration Date", Visibility = PXUIVisibility.SelectorVisible)]I tried this by using CustomAttribute for both Required and Default : [PXMergeAttributes(Method = MergeMethod.Append)] [PXCustomizeBaseAttribute(typeof(PXUIFieldAttribute), "Required", true)] protected virtual void CRQuote_ExpirationDate_CacheAttached(PXCache cache){}and [PXMergeAttributes(Method = MergeMethod.Append)] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] protected virtual void CRQuote_ExpirationDate_CacheAttached(PXCache cache) { }but still the form is allowing blank values. Please note field is a datetime type.Please help
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,
Hello,I want to create new status value “Archive” to screen Invoices and Memo and enable this field when the status is Open so that End-User could change status to “Archive”I tried add new status value as instruction in topics and use following code to enable Status fieldusing PX.Data;namespace PX.Objects.AR{ public class ARInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AR.ARInvoiceEntry> { #region Event Handlers protected void ARInvoice_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (ARInvoice)e.Row; if (row != null) { PXUIFieldAttribute.SetEnabled<ARInvoice.status>(cache, row, true); } } #endregion }}However, I can’t find new value in list dropdown valuesand fields Status is still disableCould you please help me? Regards,Khoi
Hello community!I need to get the users phone current longitude and latitude information and record it into a custom screen. What library should I use? Is there any documentation for this?I appreciate any help you could give me
Noob question, I apologise in advance.On a sales order I have these two fields that I am trying to add to a report. I reference the first field in a report with=[SOOrder.CustomerOrderNbr]and it works perfectly.However, I reference the 2nd field in a report with=[SOOrder.ExtRefNbr]and it produces an empty column.If that field isn’t ExtRefNbr, how can I determine the field ID?thanks.
How can I create a file uploader on request screen on the summary area.see belowLike this one, but this one is only for images On the following screen Kindly assist.All responses will be highly appreciatedThank you
The customer requested a checkbox on the 22R2 Task screen CR306020. It was easy enough to add but now I run into the old issue of allowing the field to be edited when the task is complete, as seen below:I used several posts on the community to do this on other screens but they always start at the workflow or automation step.The issue with this screen is there are no automation steps or workflows. I tried to add a workflow and it just spins forever.Where should I start?
Hi, all.I’m currently trying to create a customization project which uses a .dylib file to tell the runtime which .dll to use (These .dll files are the same name however are in different folders x86 and x64). However, acumatica does not seem to read the file so the .dll which is referred is not found by the application. To fix this I can force the application to use a version of the .dll file which works by copying it out from the x64 folder to the Bin folder of the system so it can be found.Is there a better way to do this? Thanks.
Hello I am trying to add a custom stock item status that will have certain behavior associated with it. I want to create a custom status for stock items that would basically allow for it to be added to Sales Orders but not added to Purchase orders. I read through another thread and understand how to actually get the status added, but I am not sure how to customize the behavior of the items in that status.
I have added custom fields to the cases screen. When you select a record type, the Service Type field should be cleared so the user has to select a new value. The Service Type selector is filled with data based on the selected Record Type.When you select a new value in the Record Type field, the Service Type should be set to null.Strangely, it works, but ONLY if it is the FIRST time you update the Record Type after bringing up the case.Any changes in that field other than the first one, the Service type is not being cleared.I used the RowSelected handler for CRCase to try to null the field. protected virtual void _(Events.RowSelected<CRCase> e) { CRCase row = (CRCase)e.Row; if (row == null) return; CRCaseExt itemExt = PXCache<CRCase>.GetExtension<CRCaseExt>(row); if (itemExt == null) return; if (itemExt.UsrServiceTypeID != null) { SSGCRServTypeRecTypeLinks link = SelectF
HelloI have acumatica solution with .net framework 4.8 assemblies. Acumatica Version 2022R2. When I build assembly from Visual Studio 2019 and refresh website it takes about 1 minute until load. But, when I Build same assemby from Visual Studio 2022 it takes 10 minutes. Also I have used in Visual Studio 2022 Visual studio 2019’s MSbuild path and it took 1 min. as it seems it is Visual studio 2022 MSBuilds Problem. so have you any suggestions?
I have created an action button in SO detail grid and I am opening a smart panel using the action.I want to incorporate the same scenario in mobile app as well. Below is the screenshot for my Action Button “ADD FREE ITEM”. Below is the screenshot of opened smart panel. I am not able to get the Action Name under Action Content of WDSL schema of SO301000 screenTools → Web Service → Service Description.
I want a selector that will let me pick a BAccountID from a list of BAccounts which I filter, but I also want it to have one additional option I can pick “All Trading Partners”. If all I want is to pick a BAccountID then I would just use a vanilla selector, however since I also want that additional option, I’m trying to use a simple Custom Selector here is an example. Here is the selectorpublic class SimpleSelectorAttribute : PXCustomSelectorAttribute { [Serializable] public class SelectorFields : IBqlTable { #region id public abstract class id : PX.Data.BQL.BqlString.Field<id> {} [PXString] public virtual string Id {get; set;} #endregion #region displayField public abstract class displayField : PX.Data.BQL.BqlString.Field<displayField>{} [PXString] public virtual string DisplayField {get; set;} #endregion } public SimpleSelecto
Firstly, this is a two-part question:Part One, is it possible to use the API endpoint interface to insert data into existing screens from within the same customisation project? I obviously don’t want to write POST or PUT requests externally as the data transfer is within the same application, but the API endpoints are easy to use for data insertion in a global JSON format and I would avoid situations like below.Any opinions or thoughts would be appreciated. Part Two, I am trying to make new records of a time sheet in the EP305000 screen and this requires entering data into the main page and a tab in that page. I have successfully inserted data into pages in the past using the View / VewDelegate, method where you create a new instance. This time I need to insert data into two parts of the page and I have no idea how to do this, my attempt is below. // View - using EPT Time card as its the header, I'm inserting data into header and Tab - error public PXSelect<EPTimeCard> I
If a customer has a Live and Test tenant what are the ramifications of publishing a customization in Test for testing and not in Live ? Is there any documentation that says you can publish in one tenant and not the other ?
I am working in 2022R1.I created a custom table with a default to one of the fields. I created the table in MSSQL Management Studio. After I create the table and create a script of the table it shows that the default is there. I tested it by adding a dummy record and “AV” is filled into the Module field.This is the script to create the table:CREATE TABLE [dbo].[ICSMergeLock]( [CompanyID] [int] NOT NULL, [Module] [char](2) NOT NULL, CONSTRAINT [ICSMergeLock_PK] PRIMARY KEY CLUSTERED ( [CompanyID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[ICSMergeLock] ADD DEFAULT ((0)) FOR [CompanyID]GOALTER TABLE [dbo].[ICSMergeLock] ADD DEFAULT ('AV') FOR [Module]GOIn the project editor, I ADD CUSTOM TABLE SCHEMA for the table. In Edit Project Items, this is what the project is storing for this table:<Sql TableName="ICSMer
I have used two different Emulators. Nox - FAQ | NoxPlayer FAQ (bignox.com) (Support.bignox.com) BlueStacks - www.bluestacks.comI initially started using Nox and have stayed with. Both are free base on my understanding used for testing. What this is is a emulator, so you don't have to run tests on you phone. Instead you setup one of these emulator and then install the Acumatica app on it. Its Andriod, so you just go to the google apps area and search for the app. When finished using close it down. Good for testing. This is not a question. Just sharing.
Hello, In various parts of the Acumatica source code I’m finding code similar to this. public void RowPersisting(PXCache sender, PXRowPersistingEventArgs e){ //some code if (sender.RaiseExceptionHandling(_FieldName, e.Row, sender.GetValue(e.Row,_FieldName), new PXSetPropertyKeepPreviousException(Messages.errorMainWarehouse))) { throw new PXRowPersistingException(_FieldName, null, Messages.errorMainWarehouse2); } //more code}Does anyone know what this code is doing?My theory was that “if (sender.RaiseExceptionHandling(_FieldName, e.Row, sender.GetValue(e.Row,_FieldName), new PXSetPropertyKeepPreviousException(Messages.errorMainWarehouse)))”is checking to see if “RaiseExceptionHandling” has already been called against e.Row for _FieldName. I think it is specifically checking to see if Message.errorMainWarehouse was raised previously. If the RaiseExceptionHandling method returns True then we get to the PXRowPersistingException and an error is displayed on save. I think that “new PXSet
Hi Team,Anyone came across this issue before, we are getting error when running commissions for Projects. This is a customized screen and while debugging can see BaseCuryInfoId and ProjectCuryInfoID values under PMTran are not set. When compared with previous version i.e. 2019 there is a change in DAC definition.public abstract class baseCuryInfoID : PX.Data.BQL.BqlLong.Field<baseCuryInfoID> { } [PXDBLong] [CurrencyInfo(CuryIDField = nameof(TranCuryID), CuryRateField = nameof(BaseCuryRate), ModuleCode = BatchModule.PM)] public virtual long? BaseCuryInfoID { get; set; }2022 R1 [CurrencyInfo] [PXDBLong] public virtual long? ProjectCuryInfoID { get; set; } // // Summary: // The identifier of the CurrencyInfo record that stores exchange rate from the // transaction currency to the base currency. // // Value: // The value of this field corresponds to the
I’m using a dialog for data entry, and I’m having issues initializing the filter view with values before displaying the dialog.I’ve tried several different approaches based on searching the Acumatica source, my latest attempt is in the following code block.The dialog always initially shows without any of the pre set data displayed. If I enter in the additional data and save, a new record is correctly created with the prefilled values.When I debug, I can see the values are updated before the AskExt call, they just do not display on form.If I run the action a second time after the first record is updated, the dialog shows the previously input data including the prefilled values.I seems like this should work, I’m handling for the multiple calls for the AskExt by checking the for Answer == None and only initializing the fiilter in that case. I’ve tried it with and without passing the RefreshRequired parameter as true. Same results. Action - this is in POOrderEntry extension publ
Hi Everyone, I’m new to Acumatica development and would like to ask if anyone knows where to find the 2021 R2 Development Couse Materials? I would be very grateful if someone can help me find them. Thank you.
Dear Team, Is it possible to wrap label text globally using style sheet in acumatica. Thanks,Arun
Dear Team, I am looking for solution to allow negative Qty in purchase Receipt details lines? kindly advise how to do this requirement. Thanks,Arun.
I am attempting to make a custom field on a sales order required. This custom field is only visible when OrderType is “NC”.I am struggling with how to determine if the field is visible and if it is null or blank.I have tried several different methods I have found from various sources. The code below is totally wrong… but is where I got to the point of asking for help…. This code is in my DAC extension. protected void _(Events.RowPersisting<SOOrderExt> e) { var isVisible = SOOrder.orderType.IsEqual<ncOrder>; if (BqlString.Field<usrNoChargeDept> == null && isVisible) { throw new PXException(Messages.RequiredNCDept); } } ncOrder is: public class ncOrder : PX.Data.BQL.BqlString.Constant<ncOrder> { public ncOrder() : base("NC") { } }RequiredNCDept is a string in a file with other messages.I attempted the solution here: But ran into the issue of finding when the field is visib
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.