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,we have this Create AP Bill Action in the Details Tab of the Appointments (FS300200) Screen which will redirect to Bills and Adjustments Screen. we want this Action to display in the mobile application. I have exposed the action form the Project editor. And update the container with the Action name as follows. now, even though the action is visible in the mobile application, it won’t redirect user to the Bills and Adjustments screen. it is showing a loading icon and do nothing. Help :)
Hello all,I am wondering how can I get the Data Type (string, decimal, int ...) of a field. I have a method like below and I need to know what is the Data Type of the “Field” public static void MyMethod<Field>(PXCache cache) where Field : IBqlField{ string fieldName = cache?.GetField(typeof(Field)); // This gets me the name correctly // I tried all below and they are returning null var aa = cache?.GetType()?.GetField(fieldName)?.FieldType; var bb = cache?.GetType()?.GetProperty(fieldName)?.PropertyType?.GetField(fieldName)?.FieldType; var cc = cache?.GetItemType()?.GetField(fieldName)?.FieldType; var dd = cache?.GetItemType()?.GetProperty(fieldName)?.PropertyType?.GetField(fieldName)?.FieldType; // Rest of my code}
May I ask if there is a way to change the date formats in acumatica?I tried to format DAC, CreatedDateTime (Created On) and ResolveDateTime (Resolved On) the format only working on CreatedDatetime column but the other column Resolved On though the dates are correct but the time was always 00:00. This how I format those columnsCreatedDateTimeResolveDateTime
Think I already know the answer to this, but is it possible to make the grid on a process screen editable? Ability to change one or two fields. I am pretty sure this is not possible but incase someone has a way around the norm would appreciate any insight.
Since upgrading to 2023R2 the Order Description is being automatically copied to the Shipment Description. This is not desirable and causing extra work as we have to remember to remove it manually.Is there a way to customize this to disable this copy? Thanks for any help, Phil
We use copy/paste all the time when creating new items and have noticed that since upgrading from2022 R2 Build 22.208.0012to 2023 R2 Build 23.208.0026when copying/pasting a stock item the Last Cost value is no longer included.Is there an existing way to include/exclude fields from the copy/paste routine? If not is it possible to customize the stock item screen in order to re-enable that functionality?This is a significant issue as we have many items that need to be set up identically and it adds another step in the process which wasn’t there before. Thanks for any advice you can provide,Phil
Hi there, I would like to default the Text Formatting (as shown below) to Plain Text but there doesn’t seem to be a way to do it via any configuration. I’ve looked into customization as well and confirmed that there are no such values in Customization Project Editor screen, and the whole thing is basically encapsulated under InventoryItem.Body. Is there a way to actualize this?
Picture this: One customization package adds a custom UI tab with grid and underlying view via graph extension. A second customization needs to extend it by modifying the view and adding a new joined column to the grid.The problem: The custom tab needs added to the second customization package with a grid to make the change, and the result of publishing is that two of the same tab appear on the screen with different grid contents, because merging of a tab is problematic with the UI publish.I understand that modifying the first customization instead of adding a new customization would resolve this, but in this particular scenario, the first customization shouldn’t change for one instance, but for another it should.Any ideas for handling this?
In my customization code I create a prepayment, after the sales order is persisted. How can I insert the prepayment record into the Adjustments cache? I insert an SOAdjust record and attempt to persist. But an error returns - a complaint about the field CuryInfoID.public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate baseMethod) { baseMethod() ARPaymentEntry entryGraph = PXGraph.CreateInstance<ARPaymentEntry>(); entryGraph.Clear(); ARPayment payment = new ARPayment { DocType = ARDocType.Prepayment, CustomerID = c.BAccountID }; payment.CuryOrigDocAmt = doc.CuryOrderTotal; payment.AdjDate = doc.OrderDate; payment.ExtRefNbr = doc.OrderNbr; payment.PaymentMethodID = detail.PaymentMethodI
Can you help me on how can I get the current user (username) then assign it to a variable?
I have a customization which updates a custom date field when another custom field (called UsrAIWHLPrice) is updated. This has been working fine since 2022. Since upgrading to 2023R2 the field doesn’t update any longer. The code is below: protected void InventoryItem_UsrAIWHLPrice_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (InventoryItem)e.Row; if (row == null) return; try{ InventoryItemExt invItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(row); if (invItemExt.UsrAIWHLPriceChangeDate != null) { invItemExt.UsrAIWHLPrevPriceChangeDate = invItemExt.UsrAIWHLPriceChangeDate; } invItemExt.UsrAIWHLPriceChangeDate = PX.Common.PXTimeZoneInfo.Now; } catch (Exception error) { PXTrace.WriteInformation("error: " + error); } }There is no error in trace so I suspect it is b
Hey guys, I am currently developing a customization where I need to attach files from the Invoices and Memos screen to the Email Activity screen. E.g from this screen: to this screen: I am currently implementing the following logic: But it looks like the trace log below the assigning of the emailActivity retrieves a noteID of null although retrieving a file from the invoice: Any help on this would be greatly appreciated!
I have created a customization for our Pro Forma Invoices to include extra fields for submitting the Pro Forma Invoices to our finance department which is a simple check box on the pro forma invoice screen: PM307000I have built a generic inquiry to show these checkboxes which have been checked or not, but now the users want a way to update multiple pro forma invoices at the same time. I have edited the generic inquiry to add mass update fields which gives me the functionality with the actions → Update, but there is an Update All inside this action bar, I do not want this there as there is a potential that a user might update all pro forma invoices accidentally. Is there a way to either remove Update All or make it disabled with a role or completely remove it from this Generic Inquiry?
Is it correct to filter on ARInvoice using a statement like : Where<ARInvoice.status.IsEqual<"Closed">>?
Hello all,I was wondering can we open the dialog shown using the Vie.AskExt() method (it shows a nice and neat grid) in a new tab by existing tabs instead of displaying a dialog in a new window without going the long way of designing a grid … and all other required works to use in redirect? Here is the code: public PXAction<MyDac> showHistory; [PXUIField(DisplayName = "Show History")] [PXButton] public IEnumerable ShowHistory(PXAdapter adapter) { MyView.View.AskExt(); // Can I show this in a new tab? return adapter.Get(); }
There is a need to maintain an automated external reports repository. That means After executing a report and then clicking the save it as a PDF, automatically the downloaded report’s PDF should be uploaded to OneDrive. 22R2 is the current version. Can I know is this possible and if it is possible I kindly request please give some guidance regarding this. Thank you.
Is there a way to get the current user role or type in a code then assign it to a variable?
HI TeamWe have a requirement where we want to override the ChangeID button in customer screen and need to update the CustomerID value through code. We also want to do it at the time of Customer sync from Bigcommerce to Acumatica.Could someone be able to assist me with this? I would greatly appreciate any help.
Hi,I developed a new report to maintain sales order invoice details. I need to show above highlighted numbers as a list inside the highlighted box (above packing/delivery method box).this field is capture from the inventoryitem table.When I used the column like above always it return only one data(4012.90.10)Can you please give a solution to select all data (4012.90.10 and 4011.70.00)
Hello, we are trying to run a service order profitability report and are having issues with the sub reports not populating. The for the sub report is FS631500 and the parameters are SOType & SONum. Any ideas on what would be causing this? (Yellow where they should be)
graphically it can be done this way but I need to bring the pdf file from a local path and then upload it through code
Hello I want to override value of field Asset Class and Department of data class FAAccrualTran (screen FA504500)I implemented event handler RowInserting to set value for two fields: Asset Class and Department as following:protected void FAAccrualTran_RowInserting(PXCache cache, PXRowInsertingEventArgs e, PXRowInserting InvokeBaseHandler){ if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (FAAccrualTran)e.Row; if (row != null && row.GLTranInventoryID != null) { InventoryItem inventory = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, row.GLTranInventoryID); if (inventory != null) { var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventory); if (inventoryItemExt != null && inventoryItemExt.UsrDepartment != null) { cache.SetValueExt<F
I am trying to push the Demo Instantce for a client site, on 23.207.2025, but I am getting the error “Error during file upload: Object reference not set to an instance of an object.”, the File size was increase to received the file from 25000kb to 100000kb, but still not able to import the file into the Customatizations Screens. As anyone encounter this issue and found a solution?
Hi Team,We would like to override below base method (ConfirmRow()) from INScancount graph (Scan and Count ) ,we have tried below but its not working, Can you please advise how can we achieve this, [PXOverride] public class ConfirmLogicExt : ScanExtension<CountMode.ConfirmState.Logic> { public static bool IsActive() { return true; } public string Prompt => Basis.Localize(Msg.Prompt, Basis.SightOf<WMSScanHeader.inventoryID>(), Basis.Qty, Basis.UOM); public CountMode.ConfirmState.Logic Mode { get; private set; } protected FlowStatus PerformConfirmation() => Basis.Get<Logic>().Confirm(); public class Logic : ScanExtension { protected Func<FlowStatus> var1; public static bool IsActive() { return true; } public virtual FlowStatus Confirm() { if (!CanConfirm(out var error)) return e
Hi everyone, I am having screen with Supplier (Right) Grid.Having fields Vendor Ref, Ref Nbr.When i will select Matched Vendor ref. selector the related record should populate in Ref Nbr.But in my case, i am having same Vendor reference nbr with same datatype so there is no unique field.Ref Nbr Vendor RefA 000011158B 000011158C 000011158When i am select B - 000011158 it will populate A - 000011158. Selector Code: #region MatchRefNbrExcel // working here commented below n added my code WIP [PXDBString(255, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Matched Vendor Ref.")] // Rajani changed on 29 Jan 2024 [PXSelector(typeof(Search5<APInvoice.invoiceNbr, InnerJoin<BAccountR, On<BAccountR.bAccountID, Equal<APInvoice.vendorID>>, InnerJoin<APRegister, On<APRegister.refNbr, Equal<APInvoice.refNbr>>, InnerJoin
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.