Recently active topics

Our client is using Filters on the Inventory Planning Display in 24R2.  While testing for 25R2, I noticed the option to setup filters is gone.  This is a critical piece for our client.  Is there a work around that I am missing?  The client has many users of this screen that need standard filters to review the results.Has anyone else noticed or experienced this issue?

Hello all,How can I create Production order based on MRP. So its like, based on SO, MRP will be generated and then the Production Order will be created. How to do so with MRP?Thanks.

I'm trying to set up an external application using Microsoft graph authentication in order to authenticate a shared mailbox in Microsoft.  In the external applications, there's an option to select Microsoft Graph, but in the email authentication drop-down when setting up a new email account the only options are OAuth.  Can anyone advise on this?

Hi everyone,We order things from vendors sometimes direct from overseas or from domestic locations. An item could have different pricing based on where we are ordering it from. e.g. Overseas is $10 USD, Domestic stock from US is $15 USD…Is there a way to keep both sets of pricing for each item in the system without creating a separate vendor?Thank youJoseph

Dear community,We are in the process of migrating Pivot Tables to the Modern UI and would like to collect some feedback and information about the usage scenarios.In the Classic UI, there is an option to create a pivot table directly from a GI as a GI’s tab or to go to the SM208010 Pivot Tables form and create a pivot table as a separate form with its own Screen ID and a menu item.Can you please share your usage scenarios for the second option? (pivot table as a standalone form)

In 25R2 I have an admin user account that has access to the AR Invoices and Memos, yet when I try to access the odata for the DAC, I get a 403 after entering my credentials.https://url.acumatica.com/t/tenant/api/odata/dac/ARTaxTran?$top=1The same user works on other DAC level odata endpoints. I also tried the odata4 url string:https://url.acumatica.com/ODatav4/tenant/ARTaxTran?$top=1I assume I’m missing something simple :-)

I’m stumped here. I have a screen with a tree view driving a form and details grid. this was working perfectly in the classic UI but I simply cannot get it functioning in the MUI. The modern UI displays the tree nodes correctly, but no matter what I do, the grid and form stay empty as if totally disconnected from the tree nodes. Anyone have suggestions or direction? The documentation has very few examples, and I also wasn’t able to find any answers by reviewing the front end code for the Configuration Entry screen. I’m assuming IF the issue is in the front end code, it’s in the “@treeConfig” decorator, but I’ve tried changing so many things and it hasn’t affected the dependent form or grid at all. I’m left thinking something may need to be changed in the graph.  Classic UI, from and grid load as expectedASPX from Classic UI <%@ Page Language="C#" MasterPageFile="~/MasterPages/FormTab.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="PV302010.aspx.cs" Inherits="Page_PV

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Mark De Castro - Acumatica Community Featured Member for June 2026Meet Mark De Castro our Acumatica Community Featured Member for June 2026. It’s great to have you as part of the Acumatica Community ​@MarkD! Acumatica Community Webinar - Is your Acumatica system running harder than you realize? - June 18, 2026Acumatica 2026 R1 introduces a powerful new Resource Monitoring dashboard that gives administrators and partners real-time visibility into how their system is actually consuming CPU, SQL, and memory — mapped directly to the screens and actions driving that load.Join us for a live walkthrough where we'll show you how to use the new monitoring tools to spot performan

A few years ago, I wrote about Creating Acumatica DAC Extension Tables — a clean alternative to dumping custom fields directly into standard Acumatica tables. If you haven't read that post, the short version is: a DAC Extension Table is a separate SQL table that Acumatica automatically joins to a standard table like SOShipment. Your custom fields live in that extension table, keeping the standard table clean and your customization nicely isolated.That post covered the backend C# side: the DAC definition, the PXTable attribute, and the SQL table structure. What I didn't cover — because it wasn't relevant at the time — is what you need to do on the frontend when your Acumatica instance uses the Modern UI.This article picks up where that one left off and walks through the TypeScript and HTML changes needed to surface extension table fields on a Modern UI page.A Quick Refresher on Modern UI Page StructureModern UI forms are defined in TypeScript and HTML files rather than ASPX. For a given

I'm trying to create a processing screen with a filter containing an Email Account selector and a grid below showing incoming emails for the selected account.Initially I tried using a PXProcessingJoin directly on CRSMEmail:public PXProcessingJoin<CRSMEmail, LeftJoin<BZPODocument, On<BZPODocument.messageID, Equal<CRSMEmail.messageId>>>, Where<CRSMEmail.mailAccountID, Equal<Current<EMailAccount.emailAccountID>>, And<CRSMEmail.isIncome, Equal<True>, And<BZPODocument.messageID, IsNull>>>> Emails;When I set grid's DataMember to this view, I got the following error:An unhandled exception has occurred in the function 'get_Item'. Please see the trace log for more details.undefined: Cannot read properties of null (reading 'elemByID')I then switched to using a PXProjection DAC based on CRSMEmail: [PXProjection(typeof(Select2<CRSMEmail,LeftJoin<BZPODocument, On<BZPODocument.messageID, Equal<CRSMEmail.me

We have a regular business need for barcode images (JPGs) of arbitrary lists of items for use on promotional and other sales materials. It could be up to a thousand items so the ability to mass-process is a must. It seemed silly to me to license additional software just for this when we already are printing barcodes internally on reports like the pick list. So I devised a report which gets as close as can be - it still relies on external software like Adobe Acrobat Pro or PDF24 to convert the PDF into images. It uses some clever page setup and join tricks, so I thought I’d share. Piece 1: Page SetupExported PDFs don’t have individual images embedded and the images don’t export to Excel. The PDF → Image converters can split the document by page, so the goal is to have one barcode per page. A page break after the detail section easily accomplishes this. To save on further processing, I also wanted the page to be exactly what was needed for our materials, that being just a thin strip of b

I am trying to set up overdue charges in Acumatica. We want the charge to be per invoice.I have our test account set up to apply overdue charges: Their customer class also has overdue charges applied: And the test invoices have overdue charges applied as well: When I calculate and generate the invoice for the overdue fee, it has a fee for each overdue invoice, as well as the “Contractor Overdue” fee:How can I set this up so that only the invoice fees appear on the Overdue fee invoice?The logical fix is to uncheck “apply overdue” on the Customer Class page and the individual Customer page, but when I do that, nothing populates during the “Calculate” function on the AR507000 page.

 GIDate MM/DD/YYExport ScenarioExport Scenario Date format is adding time. I want it in date in MM/DD/YYYY 

Please provide feedback on the Modern UI if you have issues with it so that Acumatica can focus on improvements to it.  Acumatica AI will pick up your feedback for them to focus on improving it prior to the 26R2 release when the classic UI goes away.

I am effectively trying to match strings with an IIF statement to create an ‘substitution list’ with a GI. =IIF(InStr([ATTR_USES.Value], 'Hiking')>=0, 'Outdoor', IIF(InStr([ATTR_USES.Value], 'Athletic')>=0, 'Athletic', 'Casual'))Issue is that it italways provides incorrect resultsAs you can see above, when I join on CSAnswers I don’t get the raw values back?  Looking for answers on both. thanks! 

 We have a requirement to provide users access to financial reports only for the subaccounts they are authorized to view. How can this be achieved? I have already tried using restriction groups. But seems it doesn’t restric users by viewing the other subaccounts.

In a new 26 R1 instance, screens in /src/development using qp-include do not build the included elements.I’ve spent 4-6 hours racking my brain attempting to figure out what’s wrong. Here it is:It's a bug in the Acumatica build-tools package — specifically in extractScreenNameFromHTMLFile in utils.js.The guard clause at line 78 blocks development paths:function extractScreenNameFromHTMLFile(rootContext, resourcePath) { const filePath = resourcePath; const fileData = path.parse(filePath); const screensPath = path.join(rootContext, SRC_DIR, SCREENS_DIR); const screensCustomizationPath = path.join(rootContext, SRC_DIR, SCREENS_CUSTOMIZATION_DIR); const systemScreensPath = path.join(rootContext, SRC_DIR, SYSTEM_SCREENS_DIR); // ← This guard only allows src/screens, src/customizationScreens, src/systemScreens if (!fileData.dir.startsWith(screensPath) && !fileData.dir.startsWith(screensCustomizationPath) && fileData.dir !== systemScreensPath) return

 when I try to create shipment on this order, I have the problem “Order RR RR26000144 does not contain any items planned for shipment on '12-Jun-2026 12:00:00 AM'.” It causes the problem only order RR.

Hi!  We have 3 different translation IDs set up so we can translate our foreign entities (GBP, HKD, and CNY) into our main reporting currency (USD).  We occasionally run into an error when preparing the translations that is intermittent.  Anyone have any thoughts on what’s causing this, especially with it being inconsistent in occurrence? I have confirmed that we have translation loss and gain accounts and subaccounts set for USD within Currency Management > Currencies.One of my employees had this error yesterday when trying to translate our GBP branch into USD, but was able to do the translation this morning.  We’re both now receiving this error when trying to translate our HKD branch into USD.  This doesn’t happen every month when we do this and usually goes away the next day, so it’s not critical since it appears to resolve itself; it’s more of an annoyance than anything else.  Thanks in advance for your thoughts!

 I am currently building a Generic Inquiry to identify valid Purchase Receipts that require an AP Bill. The logic is that if a receipt has no corresponding AP Bill, it should then check whether there is a related Purchase Return; otherwise, it is considered valid and requires an AP Bill but I seem to be getting a duplicate. Any insight as to how to make it efficient? Sharing my GI. Thank you for your time in looking.  

Hi, In the project record, I configured the Project Group with the intention of limiting visibility so that not all users with project access can see the project records. Specifically, each project manager has their own group, and only members of that group—such as the project administrator and coordinator—are allowed to view their respective projects.Additionally, I enabled the Restrict to Employees option for the foreman role. and set up their name under the Employees tab. Please note that foremen do not have access to the project record itself. The purpose of this setting is to ensure that foremen can only select projects in the Daily Field Report (DFR) that are assigned to them.Based on my understanding:Project Access controls visibility and access to the project record. Restrict to Employees controls access related to time activities (e.g., DFR and timecard entry).However, based on my testing, when Project Access settings are enabled, the Restrict to Employees functionality does n

Has anyone experienced this issue with Field Service billing? Could stale posting records, posting batches, or a known Field Service bug cause this error?Any suggestions on additional tables, posting records, or diagnostics to review would be appreciated.

Does anyone know why the Cost Code is not defaulting when I assign Staff Members in Appointments, even though I'm using the Default Cost Code on the Default Project Task?This is preventing us from using the Calendar Board to have our scheduler assign technicians to unassigned appointment while scheduling. We receive the following error…“Error: 'Cost Code' cannot be empty. Please specify the default cost code for the related service order type.” 

Hello,We’ve been live on Acumatica for just over a month. One issue we’ve been encountering is the path to production process for customizations.Is it standard practice for Acumatica developers to publish code directly to the production environment and to test tenants instead of promoting code through the test environments to production after testing?

We want to clear out our purchase accrual report of outdated Purchase Receipts and Purchase Receipt Returns that have no Bills or Debit Adjustments against them.  We are creating Bills and Debit Adjustments using an import scenario for these outstanding lines, however, the unit cost on each line must be updated to 0.  The documents will have a total of 0.00.  That’s the tricky part, particularly for Debit Adjustments, because you don’t have the option on that screen to pull in purchase receipt lines one by one there, only entire purchase receipts, which brings in e.g. 6 lines at a time.  How do you “go back” in an import scenario to update each line to 0, one by one?  @@inventoryID is not a solution because in some cases, the same non-stock code is repeatedly used.  I have attached the XML, also including some inactive lines where I tested doing this by Purchase Receipt Line (it works for Bills but not Debit Adj.).