Discussion Forums

I'm trying to download JournalTransaction data. I'm following the documentation to Retrieve the List of Records in Batches, using the $top and $skip parameters. I've tried different values for those.But I can see that as the $skip parameter grows each request take increasingly longer to finish.Finally, after ~1 hour of processing, it fails with a ReadTimeout. Even if I retry, after 60 secs or more, it keeps failing with ReadTimeout. It is not a session expiration issue: I tried with logout/login.Besides it is not consistent. For example with a $size of 500 it typically fails on $skip=115500. But sometimes I get up to the next page ($skip=116000) until it fails.And I can't get over that.Any ideas?

In assignment and approval screen of Requests cannot find field status but on screen ui I can see the status field.  

I am trying to update the Billing tab email on the Customers screen AR303000 using an Import Scenario.Goal:Update Customers → Billing → Bill-To Info → Email for existing customers. The Billing → Bill-To Info Override checkbox is already checked on the customer.Test customer:Customer ID / AcctCD: 18907What works:I created an Export Scenario on Customers AR303000 and successfully exported the field:Billing → Bill-To Info → EmailThe export correctly returns the current Billing email for customer 18907, so the field path appears to be correct. Import file:AcctCD = 18907Primary Contact Email = XYZ@123.comImport Scenario:Screen Name: CustomersProvider: Excel providerProvider Object: TemplateI have tested mappings such as:Customer Summary → Customer ID = AcctCDBilling → Bill-To Info → Override = ='True'Billing → Bill-To Info → Email = Primary Contact Email Prepare works and shows the one row correctly, but Import fails with:“1 items have not been processed successfully. View name: BAccount.” 

When trying to import Expense Receipts, I keep getting this error message but I’m not sure what is erroring. Looking at the import scenario, it looks like its pulling the information correctly but it doesn't like something about the claimdetails. Any advice? 

Hi SirWe would like to know what mean of production variance.As we do a disassembly transaction and notice that system auto generate “ production variance” May  i know what is this for? Please refer to the below.If based on below journal , does it mean the production variance 21.44 is reduce the inventory value as the double entry is credit account code14720 inventory.  

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 Acumatica Community Webinar - Customizing Acumatica Without A Developer II: Vibe Coding With Copilot - May 27, 2026Have you needed to customize something in Acumatica but didn’t feel comfortable doing so? This session builds on Customizing Acumatica Without A Developer session 1 (that covers how to utilize the low-code/no-code capabilities of Acumatica).  If you’re comfortable with Acumatica low-code/no-code options and ready for more, it’s time to get more self-sufficient with Acumatica's advanced customization capabilities that allow you to tailor Acumatica specifically for your organization.RSVP HERE Acumatica User GroupsNew! Indiana Acumatica User Group, NorCal Acum

I wanted to help out if anyone was having an issue with slowness after an upgrade to 25R2.  I have two instances that both have the same issue (support tickets 482453 & 482455).Check your system monitor and look for failed Automation Scheduler exceptions.  Look at the details and see what schedule is causing it.  For us it’s Cross-Selling ML Generation.  We disabled it manually and seems to have resolved the slowness.  What I believe is happening is in the AUSchedule DAC, the AbortCntr field is a smallint data type which is a range of -32768 and 32768.  What I think is happening is it's maxed out at 32768 (failures) already and trying to add a failure to it which I think is causing a buffer overflow and it doesn’t know what to do so it’s causing the system to slow down.   We can see in AUSchedule that the AbortCntr is set to 32767.  I have manually disabled the automation schedule for it.  Notice that the new “Max consecutive aborted executions” checkbox of “Do not deactivate” is c

Is there a way to email AIA invoices similar to how the Proforma can be automatically sent?

How do I find a GI’s screen ID from the name of the GI.I’m using OData to get information from GIs into my external application, but I’d like to provide a link back into Acumatica to the GI in question.  Unfortunately, the OData meta-data doesn’t include the screen ID.  I’m trying to find the cross-reference of GI screen names to the IDs but have not had luck. I had assumed that GIDesign + GINavigationScreen would have worked, but some GIs that are Exposed Via OData don’t have rows in GINavigationScreen.   

Hi All,I need some help with regards to bringing the amounts from a proforma Invoice to a main report.I have attached the zip file for the main report(PM652500.rpx) and the subreport. (PM652500CI.rpx)I have the below parameters on the main report.   Below is the external parameter for the sub report.   Parameters on the subreport   My problem is, I can’t figure out how to populate the amounts for [PMProformaLineWithPrevious.CuryLineTotal] on the main report which on the below column. 

Help us shape the future of AP automation!We are currently working on three-way matching improvements and have a prototype we'd like users who work with vendor invoices to test and provide feedback on. This capability aims to eliminate vendor bill discrepancies and protect your organization from overpayments, audit risk, and unauthorized vendor billing. With automatic matching, a simple interface to review mismatches, and smooth integration with Acumatica approval workflows, your AP team gets the control and visibility that modern finance teams need. No more relying on custom generic inquiries or manual workarounds.Be a part of our Acumatica Labs Program to test this prototype and help shape the final solution!If you're interested in participating, please complete this short questionnaire. Update: questionnaire is closed for now. Thank you!We are looking for up to 10 customers to join the program, which will run over the next 2–3 months. We will get back to you within 5 business days t

Hi everyone,We’re delighted to announce this Community Mentoring session with @Neil Cantral!Business Events for Order ManagementA brief overview of Acumatica Business Events, how they are used to manage orders in a B2B distribution company, and a Q&A.Neil: I’m a leader in the PNW Acumatica Users Group and the Director of IT for Wilmar LLC, a B2B distributor of automotive tools trading under brands like Performance Tool. My Acumatica journey started in 2016 and I’m always happy to talk and share my experience with the platform. My focus over the years has been rooted in the Distribution module with a lot of experience in inventory allocations, reporting, third-party WMS, and customization.Community Mentoring sessions are approximately 30 minutes and limited to small groups (10-12) of members with one of our power users who is an expert on a topic. If this session is one you feel will help you in your journey with Acumatica, please let us know in the comments below. We’ll be selectin

Hello Team!I have a customization for the Release AP Documents form that adds a couple of fields to the grid (Cash Account and Cash Discount Date).On classic UI the column filter works ok for the Cash Account. But with modern UI, the search field of the filter wont list the available cash accounts: This is my custom TS extension:import { PXFieldState, columnConfig, GridColumnDisplayMode} from "client-controls";import { AP501000, APRegister } from "src/screens/AP/AP501000/AP501000";export interface AP501000_CBAPReleaseImproved_generated extends AP501000 {}export class AP501000_CBAPReleaseImproved_generated {}export interface APRegister_CBAPReleaseImproved_generated extends APRegister {}export class APRegister_CBAPReleaseImproved_generated { @columnConfig({ allowFilter: true, width: 100, visible: true, allowUpdate: false, hideViewLink: true, displayMode: GridColumnDisplayMode.Both }) APInvoice__PayAccountID: PXFieldState; @columnConfig({ width: 100, visible: true }) APInvoice__Dis

I was doing some work in a column set and noticed validation errored when I tried to use @EndPeriod in a caption column. Running the report, it still generated correctly using @EndPeriod. I noticed on Row Sets, you can still select report parameters from the Formula window. DPL standard Column Set from Acumatica: DPL standard Row Set from Acumatica:   We just upgraded to 2026R1 but I noticed the same in a 2025R2 environment with the modern UI. Switching the column set back to Classic UI, the parameters validated correctly. 

Our management wants to display a metric on the Dashboard that identifies customers whose purchase frequency has dropped over the last month, compared to their regular historical buying pattern.For example:Customer A normally places 3 orders per week, but only placed 1 order weekly recently Customer B normally orders once every two weeks, but has made no purchase in the past two weeksWe need to flag these customers for sales team follow‑up to prevent customer churn. Could you advise how to build this logic via Acumatica Inquiry?

I have a TypeScript type generator which generates type from the ODataV4 $metadata XML. However, I wanted the type generated for certain fields like Status an enum or even just union of the possible values instead of simply “string”. I am unable to achieve this at the moment as I’m not sure where I can get the dropdown values from the built in DACs. I am referring to this kind of information when you inspect dropdown fields:Would appreciate any pointers on how to fetch this information. Thank you!

We need to flag inventory items that fail to hit our expected monthly sales growth targets, by comparing current‑month sales against the same month’s sales from the previous year.For example: Item A sold 100 units in May last year, with a predefined 2% sales growth target. If it sells fewer than 102 units in May this year, this item should be listed out for review.Is this logic achievable within Acumatica Generic Inquiry? If so, could you share the approach or required data sources to implement this YoY sales growth comparison?

Hi, do you know why this is showing as ‘billable time’? I’ve checked the timecards and it is not tagged as billable. 

Hi Team,I created the tables as shown in the screenshot for the Expenses Paid AP report and am currently trying to fetch the vendor details, specifically AcctCD and AcctName.I tried multiple possible approaches, including adding APTran, Vendor, and PMTran tables, but still no luck. I’m running into issues such as: Missing records Duplicate records Incorrect IDs being picked even after applying grouping It seems the joins/grouping logic is not returning consistent results for the vendor details. Could you please help review the approach or suggest the best way to retrieve the correct vendor information without duplication or mismatched IDs?Thanks! 

Following up on our credit memo reason‑tracking requirement, we also need to record reasons for customer‑returned goods in Acumatica.Ideally, the return reason should be captured at the line level for each returned inventory item. If line‑level setup is too complex using native tools, we can accept document‑level reason selection as a fallback option.Just like with credit memos, this field is only for reporting and statistical analysis and will not affect existing business processes. We need to analyze return quantities by reason using Generic Inquiry later.Again, we prefer native no‑code functionality to avoid customization compatibility issues during the Classic‑to‑Modern‑UI transition.Could you advise how to set this up with standard Acumatica features such as attributes or built‑in reason codes?

Hello all, I have a Business Event that creates a PO Transfer Receipt from a Transfer Sales Order/Shipment. The material needs to be received in a roject-specific location so the main steps are:Create the receipt and add the transfer order Update the location on each line with the project location. I can get #1 through this import, but #2 only updates the first line of the receipt. I think I’m missing one key change, but can’t quite put my finger on it. Any help is greatly appreciated. Import used in the BE: Results from this import. Only the first line is getting the project: 

We’re about to start a construction project for a third party.  We’ll be billing them all construction costs (without mark up) plus a management fee.  We will be providing them Cost Reports on a monthly basis and need the management fee to show as a cost of the project.  All of our other projects have been in house so we record the management fee twice - once to the developer as revenue (through an invoice) and then a second time as WIP to the property company (through a bill).  Only the WIP gets the project details. Since this is an external client we don’t have access to that second entry.It “feels” like I should be able to put the project related info on the AR line of the invoice so that it will be picked up on the cost reports.  But, that doesn't seem to work.I can’t believe we’re the only builder using Acumatica for external clients.I’ve also thought about recording the invoice with three lines so that it looks like thisdr A/R    cr fee revenue, proj xdr COGS, Proj external, task

Hi there,I’m trying to create an Import Scenario to dispose of a large number of assets across multiple companies.However, I’m getting a generic error.Below is the trace:Here’s what the Import Scenario looks like - I’ve also attached the .xml file for reference (note we don’t have sub accounts active).What am I doing wrong here? Thanks!

Hi All,Is It Possible to 2-ways Data Exchange Between Acumatica and Sharepoint Via Microsoft Integration? I want to save uploaded files in Acumatica to the sharepoints. Do you know any possible ways instead of using Azure Bob Storage?Thank much

How can I break down a budget by vendor?  You can’t use vendor as a subaccount which was what I initially thought.  Thanks in advance!