Discussion Forums

Customer recently upgraded from 2024R1 to 2025R1.  In 2024R1 when a PO was created for a non stock item the PO Accrual account field was populated with the Expense account from the item.  The end result is that there is no posting to an accrual account - it washes through the expense account and the hits it again when the AP bill is produced.  This is how they want the system to work. After upgrading to 2025R1 all PO’s for non stock items are now populating the PO Accrual account from the PO Accrual account in the item instead of the Expense account.I did not set this up originally so I am not sure how it pulled the expense account in the first place so I can see what has changed since the upgrade.Has someone done this?  Thank you.

We are an Independent Special District of the State of Florida (Fire Department). We are members of the Florida Retirement System, which is a 401(a). We need to code the deduction for this retirement plan correctly. There is no option for a 401(a) in Acumatica currently. How do we add it? This is affecting an over 50 employee with his catchup contributions. Any help would be greatly appreciated. Sincerely,Denise McCaughanA 401(a) is a retirement savings plan that an employer sponsors, and that allows for contributions from both the employer and the employee: Availability: Some public sector employers offer 401(a) plans. Contributions: 401(a) plans typically have employer contributions that are non-elective, meaning they are made regardless of whether the employee contributes. However, contributions can also be elective, or "match" contributions, where the employe

Hello Community,  I keep receiving an error when running an import to create AR payments. The error that is being displayed is “Customer Exceeded Days Past Due”. This is a warning now, so I’m surprise the system is not allowing us to complete the import. If I go to the Payments and Applications screen and enter the payment manually, it saves without any issues (I get the Days Past Due warning but it still allows me to save the payment). Any ideas? Thanks,Eric   

Hello,I am trying to create a report in Acumatica Report Designer where I need to first group records from one table, and only after the grouping, use the result to join with another table.Is it possible to implement this in Report Designer? Does Report Designer support virtual tables or nested tables that would allow such a workflow?Any guidance or examples would be greatly appreciated.Thank you!

Hello,We are using the Acumatica native BigCommerce connector, and we’ve noticed that several sales orders created directly in Acumatica have been pushed to our BigCommerce portal, creating corresponding sales records there.We want to stop this, meaning that no sales orders created in Acumatica should be exported to BigCommerce. BigCommerce should only receive orders that originate from the website.Is the sync direction the cause of this issue, since it is currently set to bidirectional?If so, why are only some Acumatica-created sales orders being exported to BigCommerce, and not all of them? We have screenshots of the import and export mappings available for review.

Business Case:Business would like to be advised on the changes to a POLine.PromisedDate.Solution:Create a SQL view to extract the previous POLine.PromisedDate and the date it was amended. Surface the SQL View with a DAC and join to POline.Problem:Changes to fields are stored in AuditHistory.ModifiedFields, which is a nvarchar(max) datatype, and I’m having difficulty extracting the data with SQL.Has anyone else encountered this problem, and is there a more effective way to track date changes at a POLine item level?Thanks,Ewan.

Hello,I’ve enabled the new Modern Customer Portal but when I log in as admin or a Customer Contact with user and roles assigned nothing displayed.The Portals record has been configured.Anyone have ideas on what could be the issue?  I’ve tried with the classic Portal Enabled and Disabled and nothing changes.Tried with classic on/off.Various roles tested also, all on/off, etc.Portal configured.

General Information:Microsoft has announced the end of support for their Bing Maps tool on June 30, 2025. If you currently have a Bing Map Key, it will continue working until June 2025. Microsoft has discontinued issuing Bing Map Keys to new users as of July 1, 2024. Microsoft recommends Bing Map users register to use the Azure Map tool.Issue:Acumatica Field Services supports Bing Maps in our various map views tied to the calendar.  These include Appointment History on Map, Staff Appointments on Map, Routes on Map and Staff Routes on Map.Acumatica introduced support for Azure Maps in the 2023R2 update 17 release, which was made available for customers in October 2024. This support will cascade into 2024R1 update 14 and 2024R2 update 3 per our normal development roll-up p

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 tha

Hi,We would like to disable the access to the (+) button for manual addition of new lines in Purchase Receipts. All lines should be linked to a PO.However, we do not want to take away the (x) button for deleting lines, since the Purchase Receipt may require amendments after being created from the Purchase Order.I have not been able to disable the (+) button without also disabling the (x) button, as the Delete access right also gives access to creating new lines. Any ideas on how to implement this restriction?

Below are the customization packages for the Surcharge customization. This customization allows you to apply credit card surcharges to invoices and sales orders in Acumatica, helping you recover processing fees with ease while staying compliant with regulations.  NOTES  The customization only works with Acumatica Payments; no other payment providers are supported.    Version  Package  2024 R1 

Hi Everyone.I am looking at the user experience in Acumatica and I am looking at adding tooltips to the workspace items. Please point me in the right direction. Thanks in advance 

I have import scenario. When import have some error  

Hi guys, I created a report showing the invoices and credit memos. There is a total. I need the invoices to add and the credit memos to be subtracted.How do I show the values as negative in a report designer?

Cannot delete revision nor choose which revision from which to copy to a new revisionIn the product configurator module, I made a new revision (AF) on CFG0000030, but in doing so, I made a sizable error that I cannot easily undo. What I want to do is delete revision AF, go back to revision AE, and have that be the basis for yet another revision for the rest of the edits I need to make. However, the system does not allow me to delete revision AF. I can only inactivate it. If I do this, AF remains the basis for the new revision (call it ‘AG’). Is there anything I can do here?

Hello  I am trying to sync related products against template items between Acumatica and BigCommerce.  I am able to do this with non template items and it works as expected. For template items I have tried adding a related item to one of the SKU’s in the template item but it does not sync through. Is there a way to associate related products to template items please? Thanks  Matt

We have a Foundation that uses Fund Accounting. At the end of each year when we roll forward our balances to 1/1 we roll the contributions, interest and expenses into a fund account. We don’t show it as a JE just adjust the opening balances as of 1/1. See below for an example. Is there a way to do this in Acumatica?  

I am using the financial report writer to build a project P&L for my client. I am having trouble getting the project name to appear in the title since there does not seem to be a parameter available.In my column set, I have added:=@StartProject + ' - ' + THIS IS WHERE I WANT THE PROJECT DESCRIPTIONThe project code is an auto-numbered ID and without the name makes it difficult to identify the reports.Thank you in advance.

I have dialog, wich is have buttons in html and aspxHTML<qp-button id="buttonOK" caption="OK" state.bind="buttonOK" dialog-result="Cancel"></qp-button><qp-button id="ButtonCancel" caption="Cancel" state.bind="ButtonCancel" dialog-result="Cancel"></qp-button>and  <px:PXButton ID="ButtonOk" runat="server" Text="OK" CommandSourceID="ds" DialogResult="Cancel" CommandName="buttonOK"></px:PXButton>  <px:PXButton ID="ButtonCancel" runat="server" Text="Cancel" CommandSourceID="ds" DialogResult="Cancel" CommandName="ButtonCancel"></px:PXButton>also i have barcode field and added in aspx next code for Auto button press function Barcode_Initialize(ctrl) {    ctrl.element.addEventListener('keydown', function (e) {        if (e.keyCode === 13) { //Enter key            var barcode = px_alls['edBarcode

Hi Team,Is it possible to enable “Copy & Paste Clipboard” option on Projects screen, Since Standard Acumatica only have Copy function which can Copy Project within same Tenant and Same company.I need to copy the Project based on below scenario.To a different Company in same Tenant To a different Company in different TenantPlease help me on this. Regards,Ramya

Hi, i want to import migration data for AP Bill but when i try it there’s an Error 'AP Subaccount' cannot be empty. Enter the document open balance to this box”.There is any mapping that i missing, i really confused about this, when i try to remove the reference number, the error becomes “The Save button is disabled” So. i decided to put it random number, but when i try to input the number, there is a new error, please take a look, you can see the picture bellow:  And i already input Account and Subaccount in excel, i already did it manually in Bill & Adj. Form to see the Account and Subaccount but Acumatica cannot read it ya? Please help me to solve about this, i r

Hi, i want to import an AP Bill in Acumatica use Import Scenario but when i try to import there is an error “The Save Button is disabled” i already looked up my mapping and following the same field order as the screen but i still don’t get it. Please take  a look of my mapping bellow:I really appreciate for your help, thank you😊    

Hello, I want to send email to specific customers when their Invoice is released.For this,1. I have changed the Email setting for customers in the Mailing and Printing tab. 2. Created a new email notification template which is linked with the SO64300 report. 3. Created a new GI which joins the ARInvoice and Customers table to store the required information. 

Hi I have a working customization on the sales order screen which automatically creates a new line with item “NON-RETURN FEE” if the item class of the previous line is “CYLINDERS”. This then also populates the quantity of the line above to the NON-RETURN FEE line and also copies a UDF value from the given item to this auto generated line. This functionality works but the records gets auto-populated only on pressing the save button. How can I immediately get the “NON-RETURN FEE” line populated? For example straight after the quantity field of the previous line gets updated? I tried a fieldupdated event handler but this did not work either. Please let me know the best approach, thank you!Example below of what the generation looks like on sales order line:

I’ve done many different import scenarios and regularly make mass changes to our item configurations as we’re preparing for go-live with Acumatica Manufacturing and finalizing how everything will need to be structured. However, I’ve run into this problem that I can’t resolve.We have about 600 configurable items, each with close to 200 lines of options, so making any changes manually is really not an option.Currently, all the configurations are set to revision “0” and are in the pending status, so I can make any needed updates with an import scenario. However, once we are live with this, we’ll need to increment the revision number on all the configurations whenever there is a change, which happens frequently.I’ve attached a screenshot of my update scenario mapping below. The line circled in red is the one that is causing the error. I’m simply trying to take the value from the data provider and increment it by 1. The error that it throws is