Financials

In 2025 R1, Acumatica released electronic payment method to allow for file creation type that used by RBC to pay vendors in the US from a Canadian bank account (like an ACH). Has anyone had any luck setting it up?  When I try to, I am unable to choose the expot method shown in the guide (Page 105 - https://acumatica-builds.s3.amazonaws.com/builds/25.1/ReleaseNotes/AcumaticaERP_2025R1_ReleaseNotes_full.pdf) Guide: Our instance: 

Good day. I’m having an issue with my subreport. When I use the reference number range (from and to), it only retrieves the first reference number, and all the results end up being the same.  and this is what i put on my SubReport  

We’re trying to display our current bank balance in the Acumatica system. However, we have found that the balance that Acumatica is wildly different than what the Bank reports. Is there a way to get the tow balances to accurately reflect each other. I think this may have to do with a delay in updating, but I have no idea how to rectify this.

Hey, team - I have a way around this issue, but I’m curious about Why it’s even happening.As a background, our customer has their chart of accounts significantly restricted by Branch.  I know I can simply grant more visibility to the account in question, but I’m curious why I’m getting the error in the first place.  Our customer (not live) is attempting to release a Funds transfer, and the system is attempting to reference the Cash-In-Transit account from the Cash Management Preferences, but the criteria for using it only states that it’s when the Transfer Date precedes the Receipt date.  This is not the case in this transfer.  I’ve also attempted this with the business date equal to the Transfer Date and got the same result.   

Error: Inserting 'GL Transaction' record raised at least one error. Please review the errors. Project is Required but was not specified. Account '64XX00' used in the GL Transaction is mapped to Project Account Group.We are encountering this error while running an Finance allocation. Has anyone else experienced this issue after the 25R2 upgrade?

Hi CommunityI have a real mystery so I hope someone can help.Asset purchased and allocated via AP to Class Leasehold Improvements.Asset created in the FA module to a different Class, i.e. Land & Buildings.Transaction results Purchase+ debit Land & Bldgs, credit Assets in ProgressReconciliation+  debit Assets in progress, credit Leasehold ImprovementsReversal of asset does the exact opposite (to reverse)The problem is that although the asset has been reversed, the original entry (from AP) is still in the GL Leasehold Improvements, meaning that the FA subledger no longer balances to the GL.Can anyone advise me how to get rid of this correctly?Thanks in advance. 

I want to some fields in EPEmployee and try to link approval and employee. But I cannot make it work. Please guide me

HelloI saw in some notes from the Seattle 2026 conference a couple of items that interested me:Parent child projects  A new option to block document process on branch mismatchesBoth are interesting to me but cannot see any further notes in any of the break-out slides.Anyone who was there that can provide any more insight into these two?

 Here’s our issue since upgrading to 2025 R2: This invoice is giving us the strange error message ‘SO Error: The document is out of the balance.We understand the part about the project budget being exceeded. This is simply because of different model numbers being used in the quote that what are being used in this purchase order/bill.We’ve already selected “Allow Adding New Items on the Fly” in the project settings.The document appears to be in balance to me. Any thoughts?

Hi everyone,I’m new to Acumatica and currently exploring the Accounts Payable module and Generic Inquiries.I wanted to check if there is an existing standard report or Generic Inquiry that allows users to search vendor invoices and view related payment details, specifically:Amount paid Payment date Associated cheque number or EFT referenceIf not available out of the box, I would appreciate guidance on:Which tables or data sources to use (e.g., APInvoice, APPayment, etc.) Any recommended approach to linking invoices to payments within a GIThank you in advance for your help!

Has anyone ever done a customisation to Enable Pay By Line to work for Sales Invoices generated from Sales Orders. Acumatia does not support it and am wondering why they did not allow it. 

When is the employee sales account used?

New Drip Campaign Available in MAP! I’m excited to share a brand-new drip campaign in MAP designed to help you share the benefits of Accounts Payable Automation, powered by BILL. This campaign is your go-to resource for showcasing how this powerful integration can transform financial operations for your customers. With automated approval workflows, seamless bi-directional data syncing, and flexible vendor payment options, this solution is built to streamline invoice workflows and enhance cash flow visibility.Here’s a sneak peek at what the campaign highlights:Automated approval workflows to reduce errors and speed up processing. Flexible vendor payment options to simplify financial operations. Real-time dashboards and reporting for a 360° view of cash flow. Seamless connection to BILL’s network of over 8M businesses.Getting started is easy!Access the campaign emails here. Customize them to fit your audience and goals. Launch your campaign!

What is the best way to add a subcontractor to a service order?  Is there a way through a PO or how do you tie the bill to the service order? 

Dear all, In the old version, If there are multiple lines in the AP Invoice, there will be corresponding multiple lines in Convert purchases to assets.But Now in the new version 2023 R2,  If there are multiple lines in the AP Invoice, there will be only one line with total amount in Convert purchases to assets.So If I want to have multi lines as the old version, how to config? Thanks and Best regards,

Hi,I have a requirement to transfer the balance of the cash account in one company to a cash account in another company. For that, when Im trying to create the Inter Branch mapping the system does not show me the offset account in the search. What could be the reason ?Thanks!

When importing historic balances into the GL, one was imported into an Asset account with an incorrect branch.The asset account was subsequently used for a cash account and, after recalculating the balance, it was discovered that the offending transaction did not appear in the reconciliation.I am now unable to reclassify or journal the transaction out and replace it with one in the correct branch because the branch does not match the branch associated with the Cash Account.  We have already imported transactions into the Cash account so I can’t delete it and start again either.  It would appear that I am stuck between a rock and a hard place.Does anyone have any bright ideas on how to resolve or work around this? Thanks in advance…   John

We have a payment made in 2026 (application date 2026 also) but it was posted in 2025. We accidentally adjusted it to match a 2025 invoice that was reclassified and now we can't adjust it to the correct 2025 invoice in Acumatica to ensure the reporting is correct.

Hi all,I’ve created a Generic Inquiry (GI) to capture the customer’s first invoice date, and I’m using that as the customer start date.What I’m trying to achieve is something like an annual reminder/email based on that date.For example:If the first invoice date is 1st August 2024, then every year on 1st August (like 2025, 2026, etc.), the system should pick that up and trigger an email.So basically, I don’t care about the year — I just want to match the day and month with today’s system date.If today is 1st August, the GI should return only those customers whose first invoice date is also 1st August (any year). Then I can use that to send emails like “you’ve been with us for X years”, etc.The GI I created is already working fine to get the first invoice date, but I’m stuck on how to build the logic to:extract the day and month, and compare it with the current system dateI wasn’t able to get that condition working properly in the GI.Has anyone done something similar or have any idea how

I need to create a fairly straight forward CSV payment file to a local bank.I have checked the standard exports and they are much more complex than I need.However, I am not sure where to find information like the vendors bank account info in the export scenario I am trying to create.Any assistance would be appreciated. Carsten

Hello Community,Have a small issue - when trying to send an AR invoice we have placed 2 email addresses in the Account Email Field under “Additional Account Info”.  The address are separated by a semi colon ;   I cannot change this to a comma, it defaults to a semi.When sending emails, it will only send to the first email and not both emails.  I have found a couple similar issues here:https://community.acumatica.com/distribution-6/send-po-to-multiple-email-addresses-8956?postid=31480#post31480https://community.acumatica.com/distribution-6/sales-order-notifications-not-sending-to-all-emails-listed-to-send-to-7564 I have looked into both of these solutions, however I’m not sure which BUILD is being referred to in thread one.  In thread 2 removing the field in the “TO” field results in an error saying there is no Email address to send the notification to. Hoping someone may have insight?Cheers,​​​​​​​K2

Hi All,Has anyone successfully used an Import Scenario to automatically convert purchases to Fixed Assets in Acumatica?I have been testing the Convert Purchases to Assets screen with a Business Event + Import Scenario approach. The scenario runs successfully without errors, but no Fixed Asset is created in the end.My understanding is that this screen relies on UI behavior:select the transaction in the top grid the detail line appears in the bottom grid fill in Asset Class and Department mark Create Asset then click ProcessThe reason I am trying to automate this is because I want the FA number to be available immediately when the stock is issued/shipped out. My warehouse team needs to attach the FA code to the item at the time of issue, so I need the purchase-to-FA conversion to happen automatically and the FA code to be created right away during the issue-out process.In my tests, the Import Scenario can run successfully, but it seems the asset is still not actually created.Any advice o

Hi, we are trying to automate the calculation and processing of AR Overdue charges. I have setup the Automation schedule and the last two months, it did not create any Invoices.So in looking at the Scheduler, it does not give the action to calculate first.  So Process all does not process any documents. Please advise.  

Hello Acumatica Community,I'm reaching out to connect with finance professionals who are heavily involved in the month-end close process. Our team is working on enhancing this critical workflow with improved automation and AI capabilities, and we'd love to hear from you!We're particularly interested in speaking with:Controllers and accounting managers who oversee month-end close Team members who execute month-end tasks regularly Anyone who has developed checklists or workflows for month-end activitiesIf you're willing to participate in a brief discovery call, we'd like to discuss:Do you have a checklist workflow that you use for monthly close? How did you create that checklist and how often does it change? How much time does your month-end close process typically take? What are the most time-consuming or tedious tasks in your process? Which activities are performed inside vs. outside of Acumatica?Your insights will directly influence our development priorities as we work to make the mo

We have a critical need to get the actual dollar amount that the customer has paid to date on a project so that we can display that value on a project summary report.  We’ve tried to figure this out but whatever formula or string we need to develop in order to come to the number has proven to be elusive.  Anyone have a way to get this paid-to-date number?