Financials

Hello,I was wondering if there is a way to set up the security so a user group can place an approved expense claim on hold to edit and then resubmit on the employee's behalf.Thank you,KT 

I would like to create a consolidated P&L for two tenants, but exclude sales between tenants. More specifically, tenant A sells to tenant B, but that revenue shouldn’t be considered. Can the row set exclude revenue for a specific customer?Any suggestions are appreciated.

How can I set up a consolidated report to eliminate intercompany transactions between Company A (Branch AA) and Company B? I attempted to use the Consolidation in Acumatica but couldn't get it to work. Any advice on what I might be missing? Thank you for your support!

I've set up a Unit Set hierarchy for consolidation, where Company A is the parent of B and C. Based on the documentation, Company A should show the consolidated data of its sub-units. But when I run the report for Company A, it’s not totaling B and C correctly. Is there a specific setting in the Unit Set or Report Definition that I might have overlooked?  

I need to transfer funds from one bank account in 1 currency to another bank account in a different currency. I can’t have a funds transfer or a journal entry with accounts that have different currencies. Is there a way to do this? 

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