Solved

In the Classic UI, the grid is present, as shown in the screenshot below (highlighted for reference). However, after converting the screen to Modern UI and adding the grid in both the HTML and TS files, the grid still does not appear in the Modern UI. Please refer to the screenshots and HTML and TS code below, and please suggest the solution.HTML File :<template>  <qp-fieldset slot="A" id="frmGroupCustomZipCodesSync" view.bind="CurrentStore" caption="Custom Zip Codes Sync uk1" class="no-label" wg-container after="#frmGroupB2BCustomer">    <field name="UsrKNWWSPEnableCustomZipSync"></field>  </qp-fieldset>  <qp-fieldset slot="A" id="frmGroupCustomPriceSync" view.bind="CurrentStore" caption="Custom Price Sync" wg-container after="#groupInventorySettings">    <field name="UsrKNWWSPEnableCustomPriceSync"></field>    <field name="UsrKNWWSPPriceType"></field>    <field name="UsrKNWWSPPriceClassCode" config-enabled.bind="CurrentSt

Good afternoon,I am curious if there is a way to add a status to a sales order process or are they the set in stone as:OpenAwaiting PaymentPending ProcessingShippingBack OrderCompletedJust feel like Completed is rather misleading when reviewing things and wanted to see if there is a way to add something like “Fulfilled” as a middle man between shipping and completed.Thank you!  

I’m currently working on a Bills and Adjustments Generic Inquiry where the client requires the Project ID to be included. The dataset only contains around 6,000 records, but the GI is taking quite a long time to load.I’ve already tried applying groupings to improve performance, but the loading time is still quite slow. The main requirement from the client is to keep the Project ID visible in the inquiry.Has anyone experienced a similar performance issue with the Bills and Adjustments GI when including Project fields? Are there any recommended approaches to optimise the query or improve the loading speed? Any suggestions or best practices would be greatly appreciated. Thanks in advance!

v2023R1 currently.  It sounds like 25R1 will change our world on this topic, but we’re not there yet.  Even 23R2 would probably help because that’s where they introduced Allocation management.We typically allocate serials of heavy equipment and accessories that we sell at the sales order, rather than waiting for the shipment.  I select the line in the sales order, click Line Details, check Allocate and then browse for a serial, *every* serial in the warehouse shows in the lookup window.  I select one, and I’m told that inventory quantity will go negative because it’s already allocated to another sales order.Right now we do this dance down the list until it doesn’t error any longer.  What’s strange to me is that the lookup screen lists Qty On Hand (1), Qty Available (1) and Qty Hard Available (1) for every item in the list.  I would have expected one of the Qty Available values to be 0 when it’s allocated to another sales order, but unfortunately nothing on this screen shows that it is

Hello,I have a requirement where if a case lies under Pending Customer status for more than 2 days it should trigger an alert to the Case Owner. How can I set this up in Acumatica?

HI All When we try to click Send/Receive All in the Email Accounts screen, we are receiving the following error:Error:The mail receive has failed.Exception of type 'PX.Common.IO.LineSizeExceededException' was thrown.The customer has verified and confirmed that the emails are being received in their original mailbox, but they are not syncing into Acumatica.As part of the troubleshooting, I also increased the file upload size in the system preferences, but the issue still persists.Could you please assist

I am trying to update scheduled AR invoices detailed lines. They do have inventory IDs. Some have 3-5 detail lines. Having trouble getting the import scenario started. Testing multiple ideas.

   I’m trying to set an Automation Schedule for the Recalculate Customer Balances mass-process screen. The client hasn’t locked any periods, so the filter defaults to the first period in the system.In 24R1 I could use the Relative checkbox to adjust the period. In 25R1 Acumatica got rid of the box and says the date-relative options can be used, but I can’t enter @PeriodEnd in the Filters to Apply tab.Is it a permissions thing or roles?Release Notes2024R1 Auto. Schedule2025R2 Automation Schedule  

I’m trying to figure out why I can’t search for an Item Class.  I’m saving the ItemClassID to SQL even though the ItemClassCD is shown which is what I want.  However, my search is always throwing a “failed to convert parameter vale from a String to an Int32” popup box.Question: is there something that I’m missing to get my search to work?Here’s my DAC code:        [PXDBInt]        [PXUIField(DisplayName = "Item Class")]     [PXSelector(typeof(SearchFor<INItemClass.itemClassID>.Where<INItemClass.itemClassCD.IsNotEqual<Empty>>), SubstituteKey = typeof(INItemClass.itemClassCD), DescriptionField = typeof(INItemClass.itemClassID))]        public virtual int? ItemClassID { get; set; }        [SuppressMessage("Style", "IDE1006:Naming Styles", Justification = "DAC field BQL class uses same name with different case")]        public abstract class itemClassID : BqlInt.Field<itemClassID> { }Here’s my Grid:    <px:PXGrid ID="grid" runat="server" DataSourceID="ds" Width="

What is the trick to get a default value on this screen for the Warehouse? It is a customized screen vs a GI, but am not entirely sure. Does it need to be coded in, or can it be added in a simpler manner? Thanks   

Looking for a report to print and remit for payroll run that includes the garnishment deduction amount + the information for the corresponding codes Garnishment Details fields in Employee Payroll Settings. If no native report, any direction on which table contains the Garnishment Details field data?

Hi Acumatica Community,I'm creating a Generic Inquiry (GI) that joins EPTimeCard and EPTimecardDetail using the TimeCardCD field. The goal is to display all EPTimecardDetail records, but only for Time Cards that are either: Pending Approval, or Approved Currently, when I join these two tables in the GI and filter by status, I only see records where EPTimeCard.Status = 'A' (Approved). I want to also include records where the status is 'P' (Pending Approval), and exclude On Hold and Rejected records.My join is based on:EPTimecardDetail.TimeCardCD = EPTimeCard.TimeCardCD However, the GI still seems to only return approved records.Has anyone successfully configured a GI to include both approved and pending approval time cards? Am I missing something in the join or filtering setup?Thanks in advance for your help!— Tharindu

I have InventoryItemBody in the report.How can I configure the field so that it retains its formatting when printed?Thank you. 

Hello!Didn’t seem to see this on the community, so I thought I’d ask. Is there a preferred way of connecting an Excel document into Acumatica? My goal is to be able to use the excel file to pull data for data-entry purposes in other forms.I’ve seen some free excel/acumatica connectors online but wanted to check if there’s a preferred/official way.I know ODATA links to PowerBi, but not sure if this would enable the same thing.Thank youJoseph

Hi Community, Trying to enter a new Task, and running into this error. Has anyone ran into this before? I cannot find any documentation on it.Cheers,RJ

We’re trying to use planning BOMs, but don’t understand how Acumatica intends for us to handle them. Does anyone know of a good resource that explains the intended functionality? What we are envisioning is:Engineering creates a BOM that is somehow designated as “Planning” This BOM would not be able to be used to create a production order This BOM would work for MRP planning At some point, engineering converts the planning BOM to a “real” BOM Then manufacturing can create a production order and proceed as normal. Is the above at all similar to the process Acumatica designed?

Could not load file or assembly 'Microsoft.Extensions.Options.ConfigurationExtensions' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.IO.FileLoadException: Could not load file or assembly 'Microsoft.Extensions.Options.ConfigurationExtensions' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)How can I resolve this issue? Thanks in advance for your help!

Hi AllFor the last few days I have been getting the error shown in the screenshot below in my Production environment which causes the application to be stuck on a loading screen. Any ideas on what cuases this and how to have it fixed, please? Currently to fix it, I restart the server because I’m not sure where else to check. My version is 25R1 and it is a PCS deployment. 

We are trying to create a new carrier for Easypost, and choose US units (Pound/Inch) for Carrier Units.  Both the LB (Pound) and IN (Inch) were defined in the Unit of Measure, however, only the LB is available for Pound, but the IN is not available for Inch in the Carrier Units section.  Does anyone experience the same issue?  Any suggestion would be greatly appreciated. We are using 2024 R2 version.  Thanks...

Hello everyone,I’m currently facing an issue with a Generic Inquiry (GI).I created a GI that retrieves SOLine records from SOOrder, and my goal is to calculate the Total Available Quantity for each item in non-pickable locations.However, I’ve noticed that for some records, the Inventory ID displayed in my GI does not match the Inventory ID shown in the Side Panel GI. In other words, when I select a line, the item shown in the side panel appears to be different from the one in the main GI result.For the side panel link condition, I am currently using: InventoryCD = InventoryCD Has anyone experienced a similar issue?Could this be related to joins, aliases, or the way the side panel is linked?Any guidance would be greatly appreciated.Thank you!

I’m looking to prepare and import an import scenario every morning at 3:00AM. It looks like all of the help topics for this are older versions of Acumatica. I’m in 25R1I suspect it’s a business event but none of the actions types seem to fit a specific schedule/time scenario. Thanks!

Hello,I have my task emails set up to send out when a user gets a new task. For some reason, the emails are only sending out once a day at 8:30am. What is the best way to get them to send out as the task is assigned?Thank You,Brent

Hi Everyone!Is there a way to set-up an item to only allow sales in specific increments? As an example, we might buy a roll of 1000’ of wire, but I only want to be able to use (via BOM) or sell (via SO) in increments of 100’. Is there a way to set that up?

I would like to do two things with one scenario, but I cannot get it to work for multiple records. The first record works fine, but all the others error with the message “The system failed to commit the Items Row”. We have multiple discount sequences “5” and “10” within a code “SALE”, which mark items as 5% or 10% off; nothing complicated. Some items got put into the 5 sequence that should have gone into the 10 and I would like to use an import scenario to remove them from one and add them to the other. Yes, I can do this as two different scenarios, but it seems like something that should be manageable all at once. It seems straightforward enough: go to one sequence, lookup the item with @@InventoryID and remove it, then go to the second sequence (same discount code) and add it. Oddly, it wasn’t working when I had a ‘<Line Number> = -1’ action to add the item to the second sequence. I can’t reset the InventoryID key in the second sequence; it just merges with the first key line.T

I am in the process of implementing a client with multiple companies in multiple countries.I am trying to set each companu up with it’s own bas currency but I haven’t got the option to do so.I have seen comments about certain things need to be enabled on tenant level and also, that you need to purchase extra features.Where can I see the tenant features that are enabled and where can I see if the extra features is part of the current license? Regards,Carsten