Solved

In 25R2 Acumatica is pushing everyone toward the “Modern UI” (HTML/TS) customization path and, as part of that change, the old in-product ASPX Editor is effectively no longer available.

25R2 classic to Modern UI converted and added to the package , package published in another instance unable to see the MUI changes in the screen  In 25R2, to be able to add the files to the Customization project you have to have the Modern UI files in the following path, FrontendSources\screen\src\developmentAfter publish the package in another instance the Modern UI files not reflected in any where 

If I print AP Aging MC (summary or detail) as of December 31st, it does not show vendors paid on January 2nd. They are included in the final total but are somehow hidden(?) from showing up on aging. Our Implementation consultant (thru Support team) had said this was fixed with 25R1 but I still see this issue happening.Has anyone else come across this for Canadian localization? Have not tested this with AR aging but I will once I enter January cash receipts. Both reports must show documents OPEN on the “as at date” so I am not sure why they are hidden. It is very important for the auditors.Thank you!

Hi everyone, Happy new year! I was hoping for an insight regarding setting up a default recipient in Mailnig & Printing tab specifically in Purchase Order preference.  This is how I set it up but email doesn’t seem to be sent. I was hoping to set this up as CC so I don’t have to update each vendor.Thanks so much in advance.  

Hi, I am trying to run a report that lists all PO#’s (Open, Closed, etc.) that include a specified Inventory ID. The Purchase Order Details by Inventory ID seems exactly what I am looking for but it only lists results for items that have Open POs?  The Inventory Transaction History shows the PO receipt #, but you need to navigate individually through the PO receipt to get the PO# so no value. The Inventory Allocation Details only shows outstanding POs. Can’t imagine this doesn’t exist out of the box - surely the Purchase Order Details by Inventory ID can display results including both Open and Completed Orders?  

When updating the Safety Stock and other settings on the INVENTORY PLANNING tab of a stock item, the new value carries over to all existing item warehouse details records for the item. Shouldn’t it only carry over to whatever the default warehouse is? It seems undesirable for it to update all warehouse detail records because each warehouse could have its own safety stock. This is on 25R1 25.101.0153.5. I understand that when multiple warehouses are available that the planning settings should be updated on the individual item warehouse details records. However, it becomes confusing for users when there may only be 2 warehouses (one ‘Main’ and a secondary back up warehouse). It’s easier to simply update the safety stock on the stock item and have that setting carry over to the warehouse detail record for the default warehouse, rather than also updating the secondary warehouse. Is this expected behavior?

I am very, very new to creating Wikis. I’ve created a wiki article to serve as my Portal Homepage, but it displays a bunch of metadata that I don’t want to show, and it has the “Rate this article” picker at the bottom that I don’t want either. Is there a way to configure the article so that this stuff doesn’t show?  

I have created a DAC with two keys and an Identity field. I can view and edit existing records fine, however when I create a new record and enter in a new key value as soon as I leave the field it blanks. Both Key fields blank after I focus is lost.Any Ideal?  [Serializable] [PXCacheName("MLS Listing")] [PXPrimaryGraph(typeof(MLSListingList))] public class GPMLSListing : PXBqlTable, IBqlTable { public class PK : PrimaryKeyOf<GPMLSListing>.By<address1, postalCode> { public static GPMLSListing Find(PXGraph graph, string address1, string postalCode) => FindBy(graph, address1, postalCode); } #region ListingID [PXDBIdentity( FieldName = "Property ID")] //[PXSelector(typeof(Search<address1>), ValidateValue = false)] public virtual int? ListingID { get; set; } public abstract class listingID : PX.Data.BQL.BqlInt.Field<listingID> { } #endregion #region Selected [PXBo

Hi All,  I am in the process of doing a Generic inquiry tracking approvals and time differences between approval steps.But I'm struggling to get the difference between one approval step and another approval step.Step 1 Calculated Field: =iif([POApproval.StepID]='DBB0026D-FC97-ED11-9A17-00155D000300' ,[POApproval.ApproveDate] , Null)Step 2 Calculated Field: =iif([POApproval.StepID]='423376CC-B2A9-EC11-81C1-3CECEF0440D8' ,[POApproval.ApproveDate] , Null) Both the above returns dates, I am trying to get a datediff between the 2( Step 1 and Step 2), but my formula returns blank. 😑Datediff Formula: =Datediff( 'dd', iif([POApproval.StepID]='DBB0026D-FC97-ED11-9A17-00155D000300',[POApproval.ApproveDate] , Null), iif([POApproval.StepID]='423376CC-B2A9-EC11-81C1-3CECEF0440D8' ,[POApproval.ApproveDate] , Null))Anyone have any idea how I could approach getting the date difference? Thanks in Advance.

Hi All,Is it possible to add a line number as a field item and use it to format the output of the GI? For e.g., I have a GI that lists 10 rows but I had like to use the line number to change the background color of each alternate row, which is not based on any conditiion. Since, the Row Number is available only for display, how to get a row number for any GI (not a report)?Manish

Hi gurus. How do I create an Import Scenario that changes the transaction dates of Open Move Transactions dated in the current month to update to the first day of next month?Users make the move transactions ahead of time and so when they go to close out EOM, they can’t because there are "open Move transactions". The import aims to just shift them to the first day of the next month e.g. 30/11/2025 > 1/12/2025. Data provider would be a GI of open move transactions.

I have a WIP import scenario that works if and only if the serial number that is being allocated is Available for Shipping, with is correct, but if one of the serials I am trying to allocate is not available the whole import scenario fails and no serials get allocated at all even the available ones.I get this error “ The record was not processed because of an error during processing of the previous record” Thank you for anything that might help me get to the bottom of this. 

Hello all, We can open a new screen using PXRedirectRequireExcption. We also can include parameters as argument when we throw the exception. My question is how in the “target” screen we can access the parameters provided as argument when we threw the exception in the “source” screen. for example I throw the below exception from screen A that will open screen B. So when screen B page is loading how I can access the P1 and P2? to be more specific I need to access them in the Page_Load.throw new PXRedirectRequiredException(myGraph, true, string.Empty, P1, P2) { Mode = PXBaseRedirectException.WindowMode.NewWindow };Any help is appreciated.

hi All,I’m trying to use a Generic Inquiry (GI) in Power BI. The GI is already published and exposed via OData, as shown in the screenshot. The user has full admin rights and all related permissions.However, when connecting to the Acumatica instance from Power BI using the OData feed, this specific GI does not appear in the available list.Can anyone help identify what might be causing this issue? My Version is 2024 R2 24.209.0013 Thank you in advance!   

How to show PXRichTextEdit in the mobile app?

Hi, I'm working on a customization project in Acumatica 2024 R2 to allow for split payments for Cash Sales. I have a custom DAC that will store the multiple payments for a cash sale if it's allowed for that invoice. However after trying to add a line counter to the SOInvoiceExt to keep track of the lines added for the split payment I'm unable to load the SO303000 screen. Please see below code for the SOInvoice DAC, Custom DAC and the extended graph. Any help is greatly appreciated.**SOInvoiceExt** public class SOInvoiceExt : PXCacheExtension<PX.Objects.SO.SOInvoice> { #region UsrSplitPayment [PXDBBool] [PXDefault(false)] [PXUIField(DisplayName="Split Payment")] public bool? UsrSplitPayment { get; set; } public abstract class usrSplitPayment : PX.Data.BQL.BqlBool.Field<usrSplitPayment> { } #endregion #region UsrSplitLineCntr [PXDBInt()] [PXDefault(0)] //[PXUIField(DisplayName="Split Line Counter", Enabled= false)] public int? UsrSplitPa

Hello!I have a GI that I need to filter by date range. When running the GI it is not filtering down to the date range window. GI and Screenshots below. I feel like I’m missing something obvious.Thank you for the help!  

I’m looking to find a screen or maybe a way to create a GI view that shows the history of actions on Invoices and Sales Orders. Specifically, I want to see if records have been deleted and if so, which record and when. Is this possible?

This question was asked and answered before.  But the solution on that topic does not work in 25R2 for me.PXAction created on Graph ext Show on Modern UI grid Header | CommunityI'm trying to add a custom action to a grid on AP301000.  I am working on a local demo instance with no other customizations.I am able to add my action, but when I do, all the other actions on the grid disappear.I tried thisexport interface AP301000_APTran_ICSAllocations_converted extends APTran { }@gridConfig({    preset: GridPreset.Details, autoGrowInHeight: GridAutoGrowMode.Fill, repaintColumns: true,    topBarItems: {        AddNew: { index: 0, config: { commandName: "AllocateLine", text: "Allocate Line" } }    }}) And thisexport interface AP301000_APTran_ICSAllocations_converted extends APTran { }@gridConfig({    topBarItems: {        AddNew: { index: 0, config: { commandName: "AllocateLine", text: "Allocate Line" } }    }})Any assistance would be greatly appreciated.

Is executing Validate Project Balances (PM504000) on a recurring basis using an automation schedule a recommended best practice?  I’ve heard some say yes, because it’s necessary to maintain accurate project balances.  However, I’ve also seen someone say no, it should not have to be done as part of normal operations, suggesting incorrect project balances are a symptom of something going wrong and needing to be corrected.

Does anyone know why it is no longer possible to print shipping labels using Screen “Shipments”, ScreenID “SO302000” or Screen “Process Shipments”, ScreenID “SO503000” after shipping is confirmed or invoiced? → “Print Labels” is inactive → Only Shipments with confirmed status are listedAre there any settings that make reprinting possible in the cases described above?Thanks in advance.

         Does Acumatica support deploying applications and databases on separate servers? If so, should I prioritize configuring the hardware for the application server or the database server?

I’m working on an Import Scenario that will update a sales order’s user-defined attribute.The simplified process will go as followed:Identify the order by Type and Number Open or Re-Open the order (QT requires the Re-Open) Set the attribute Return the order it starting stateSteps 3 and 4 need to be conditional and I haven’t found any documentation on how to do that. For instance, step 3 would need something like: IIf(=[Document.OrderType] = ‘QT’, <Action: Open Order> (OpenOrder), <Action: Re-Open Order> (ReopenOrder)As a work-a-round I am thinking about using Target Restrictions to limit the data to a single condition, i.e., QT and Completed or QT and Canceled. That way I can set the Mapping fields and change them each time to match the current conditon. I’m really trying to avoid this since it will be fairly manual. 

Hey, team - I know very little about configuring export scenarios.  I’ve got a client on 24R2 using the Export AP Payment to ACH v2 scenario.  No modifications have been made to it; everything is out of the box.  The output ends with hundreds of 9’s.  Where in the ES is this part dictated?  TIA.  

We are a construction and field service company.  We are currently running our own compliance software that we had custom built for us many years ago.  We have basically outgrown it, and the cost and time to maintain it has become burdensome.  We are looking for suggestions on something that will tie into acumatica’s field service and construction projects for doing hazard assessment, circle checks, inspections, etc. so we don’t have to maintain 2 systems like we are now (prevent duplicate entries and human error).  Being able to do it through mobile is a must.I have gone through the marketplace and there is nothing specific to this.  The only integrations that were close were some forms software, but they didn’t look like they talked nice to field service out of the box.I appreciate your help.Andrew