Unanswered questions

After upgrading to 2025R2 from 2024R1, we are no longer able to manually add a partial quantity Ship Complete SO line to a consolidated shipment (status: On hold) and save. Now the shipment line with an incomplete Ship Qty (ex.4 of 6 items available) must have the Shipped Qty set to zero before being allowed to save.In the end we want to ship the line complete and are waiting for the transfers to complete. I understand the error if we were trying to Remove Hold. Is there a new setting in 2025r2 which has caused this behavior to be exhibited on shipments?  

I am building a GI to track OutOfStocks from sales orders, but have gotten stumped on the inclusion of the sales order pop-up notes. (We track our OOS via notes, since the backordered SKUs get removed from shipment and then cleared out so the backorder status etc is not able to be tracked for just those SKU as it gets completed still.) It seemed like I only need PX.Objects.SO.SOOrder + PX.Data.Note, but when I access those note text fields it is not correct. When I use “inspect element” it doesn’t work on the open popup, only clicking the note symbol which only gives me “NoteShow”  Per the screencap above, I’m trying to get “OOS 183889” to show in the GI, but I can’t seem to target THAT note field.Note.NoteText pulled in the origin sales order notes from the external system and/or AP, not the notes in the pop-up record in Acumatica.Note.NotePopupText found no text to display, even though I can clearly see them on the sales order.Is this the wrong table? Here are my settings: Thank you

Hello,I had a salesperson come to me and ask if I can make sure that the lines in her Project Quote match the lines that are printed in the report. I see for sales orders , SOLine.SortOrder can be used. However PMQuote.SortOrder doesn’t look to exist. Has anyone sorted the lines on a Project Quote?Thank You,Brent

I have created a 12-Month Profit and Loss Report and I want the columns to print on each page of the report.Page 1 (Descriptions and months 1-6) Page 2 (Descriptions and months 7-12)I have to be missing something. Any help would be appreciated.  

We upgraded our client to Prime from Advanced.Shortly after, we upgraded from 2024.1 to 2025.1We are experiencing extreme speed issues ever since.We have a case logged since 10.28.2025 but no resolution yet.Is anyone else experiencing slow down since upgrading either their license or version?I’d be interested to hear.Thank you.

Below is the import scenario I am trying to use to get our fixed assets into Acumatica.  When I run the import by scenario, it shows that the records processed, but nothing appears in the fixed assets form. 

I have a GI that shows the Qty On Hand for each item by Warehouse. I want to get the total quantity on open Production orders at that warehouse for that item.  What tables/DACs do I need to join to my GI to pull in those numbers? 

I have been using the Incoming Documents feature to bring in my invoices into Acumatica with the GL, however the subaccounts never populate even though I have it set up on the non-stock sku.

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. 

Hello!I currently have a report to show all orders entered for the prior date, and this is how it currently looks.This works fine but on Monday’s this will try and pull orders on Sunday (our company is closed on Saturday and Sunday). What would I need to add in this section to have this report skip the weekend and show me Friday orders on Monday? Thank you!

Hi, I am creating an import scenario for import bank transactions screen to import a csv file as my data provider. I was hoping to get answers to a couple of questions below please.In my csv file, I have a Beginning and Ending balance column which I think is wrong because you only enter them once in the UI. You don’t enter them line by line. How should I include my beginning and ending balance in my CSV file?    CSV file with Beginning and Ending Balance  In the above screenshot, the Amount column goes to positive and negative goes to disbursement. I’ve attached my import scenario. However, it is giving me an error below.    

Hello! I have successfully configured Acumatica Projects to order stock item to the Project. The item is correctly related to the project and the project has the material cost. The question is this: we are not invoicing a customer, we are using the material for R&D project.  The material needs to get expensed out of inventory (both the physical on hand quantity and the GL inventory account). I am not finding a way to accomplish this (I have some work around ideas but feel there should be an “out of box” process/solution for this).  Thank you to whomever is able to provide some ideas here. (Client has Projects only - Construction not included) 

Hello everyone,I haven’t seen much confusion about this, so I’m sure there’s a straightforward solution that I’m just missing! I finally got our construction team to start using cost projections to project the future of their projects by budget line in 2023 R2.We’ve just completed our upgrade to 2025R2 and I noticed the project status screen which seemed very helpful, but it runs off of a new cost projection by date screen. It seems a little less intuitive because you can’t import an excel and it doesn’t display the budget description per line. Any tips for using this screen?Do I have to now convert the team to using this screen or is it possible to make this screen load the info from their most recent Cost Projections? What is the purpose of the date functionality?I ask all this just because I really like the dashboard. Thanks to any and all help and information, I’ve already reviewed the ACM notes and it doesn’t really help differentiate these two projection methods.

We use serial tracked products that sometimes get consumed into other internal orders but sometimes get sold as is to the customer. We are having a hard time finding a way to get a list of serial tracked items that have neither been consumed into other orders nor sold to the customer. Any guidance of how to best pull together this information into a GI that employees can check against? I’m thinking probably some combination of ARTran and AMMTran info

I have a strange problem that bugged me for ages. For certain records there is a mismatch with the number of attached files vs the count of files. In the example below, you can see it has one file, but states two for the count. I’ve come across a similar thing in the Companies screen on the Visualization Tab, where the Logo File file URL has remained. In this instance, it is fixed by clicking Upload, which ‘nulls’ the path name due to no file being there.In this example though that little trick doesn’t work. Please, any advice would be great, as it is confusing to see a file in the screen, but have no actual linked.

Hello, Has anyone ever added a Vendor Ref # to the ACH export file? I do see this AddendaInfo.APInvoice_InvoiceNbr field but when I add this field value the export always returns a formula error (even if no formula present, tried removing formula all together).  Thanks, Eric 

Hello!What is the best practice for invoicing a deposit within a project? I have tested using VAT tax prepayment invoicing, which seems to work somewhat, although it is cumbersome, and was not developed for using in projects.Thanks! 

Hello everyone,We have an inventory item with the tracking method set to “Track Serial Numbers”, which allows users to manually enter serial numbers.We recently added a feature for some inventory items to auto-generate serial numbers from a numbering sequence on the Save action.However, when trying to assign the generated serial number to the Lot/Serial Number field during Save, we encounter the following error:“Key field cannot start with a leading space.”We are confident that the serial number generated from the numbering sequence does not contain any spaces.Could someone advise on the correct approach to assign auto-generated serial numbers to serial-tracked inventory items on Save without triggering this error?Thank you in advance! protected virtual void POReceiptLine_RowPersisting(PXCache sender, PXRowPersistingEventArgs e, PXRowPersisting BaseEvent){    BaseEvent.Invoke(sender, e);    var lineitem = (POReceiptLine)e.Row;    if (lineitem == null)        return;    if (Convert.ToSt

Hello Experts, I am unbale to figure out how to view the total number of production order with ageing category. I Tried creating GI but still facing problem how to group .Please let me know where am i missing .So my output result should look like:- 

What is the best process for the following szenario …Sales Order (SO) one normal stock Item but completely out of stock Order Qty.: 20 pieces PurchaseOrder (PO) for SO from Vendor 1 Order Qty: 20 PurchaseReceipt (PR) Qty.: 10 PO for the rest of 10 pieces from Vendor 2Thanks in advanceDeniz

Is there any reason the Application Period would not be the same month as the Application Date on checks? On Prepare Payments screen the Application Period matches the Application Date (users do not manually change this field) but once processed it changes in some cases

   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  

Hello!Do any of you that use Payroll print multiple w2’s for multiple cities?  We have used Aatrix in the past but they say they can no longer do this because Acumatica is webbased. Thank you! Kay Howe

Hi everyone, i want to ask about the fund transactions. So, I want to send my money from bank account (USD) to the other bank account (IDR), so it’s different bank accounts and currency. I already fill the blank item in the Fund Transactions, but I don’t get it why my RGOL is still zero (0)?I mean in my source dan destinations have a different date but why it’s still zero RGOL.Please help me to answer this, I’m just confused, where I should put the adjustment transactions of RGOL?Here I put the screenshoot bellow, Please help me to solve this, I really appreciate it. Thank you 

We have a need to completely isolate data between tenants into separate MS-SQL databases. As an example Company A and B cannot share a database due to parent company regulations. The two tenants will share a single instance and each set of tenant data will reside in a separate DB, e.g. DBA and DBB.The installation documentation reads: “ The following diagram shows an architecture with multiple application instances. Each instance has multiple tenants, and each tenant has its own database.”Here is the documentation link: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=4b65b79b-e09d-46bd-9a85-7c1c0bb4eba5I see that instances are tied to a single database and I do not see a way to get the desired configuration as described in the documentation.Can someone please help me? Either how to get the desired configuration or a concrete refutation of the documentation.Thank you