Financials

Hi, i need help to set up company with 3 subsidiaries in 3 different countries. Therefore we will need 4 different base currencies, but 1 consolidated base currency for the group (USD). The 3 subsidiaries must also be able to report in their local base currency on day to day operations, including local taxes. 

Hello!  We recently went live with Acumatica and are using the Acumatica Payments.  The embedded help information says that for a payment link to be automatically sent with an invoice a Processing Center must be selected.  - First screenshot I can’t find a way to default this processing center to ACuPay (or something that’s not blank).  Is there a way to do this or does our Billing Specialist have to populate this for each invoice?  - Second screenshot 

For eg:-FY 2023-2024 —> should remain Apr 1st 2023 to 31st Mar 2024 (No change)FY 2024-2025 —> Currently set as Apr 1st 2024 —> 31st Mar 2025,But we want it to end on Jun 30th 2025 instead of March 31 2025.Can you help me how to resolve this issue.We want FY 2024-2025 to become a 15 month financial year (Apr 2024 to Jun-2025)Thanks in advance

Hi all,I created a GI with pivots for my company that shows unit sales, $ and margin by period as in the past it was done by calendar month.All totals line up and even individual amounts add up as well. There is just one particular set of months from 2 fiscals ago where the units don’t show up same as the calendar date report but instead show up 2 periods later. I was wondering if this would go away if I used TranPeriodID? only thing is the TranPeriodID is formatted differently which causes the reports to show up as “20-2602” instead of “02-2026”. when I try to format it it then messes up the internal comparisons and none of the unit sales line up properly anymore. in short, is it fine to stick with FinPeriodID from ARTRAN? Joseph

I have a service order which i am trying to run the invoice, when i choose run billing the process completes but no invoice is created. What can I do?

Hi All,As per our requirement I have created a new COA 20040 - while creating the same selected use default sub account check box and saved.  At the same time while creating Non Stock Items selected this sales account and updating  default sub account.  it is not allowing me to save and showing an error as below 'Sales Sub.' cannot be found in the system. Please verify whether you have proper access rights to this object.  I have verified all access rights and provided necessary accounts.  Stil showing same error.  Please help me how to fix this issue.  

It would be nice to create the Prepayment as a “request” to send to the customer. But the Sales Order status remains as Awaiting Prepayment until the Prepayment is Released. While the Prepayment is still Balanced, that would indicate that the payment is not yet received.  A workaround is to create the Prepayment in AR Payments and don’t link to the Sales order until after payment is received. But this requires more effort on the part of AR team and making sure they link to the correct Sales Order.Is there any way to control this?  To leave the Sale Order Awaiting Prepayment until the Prepayment linked to the Sales Order is Released?

Acumatica has been consistently releasing new versions (R1 and R2) every six months, bringing valuable enhancements and new features. The pace of innovation is appreciated, and many of the new capabilities are genuinely useful.However, from an implementation and consulting perspective, we are increasingly facing challenges during version upgrades.In several upgrade scenarios, we have observed: Existing functionality that previously worked without issue begins to fail or behave differently. Customizations and reports requiring unexpected rework. Performance inconsistencies post-upgrade. Support responses indicating the issue is a “known issue” and will be addressed in a future release. While we understand that no system upgrade is perfect, it becomes difficult to explain to customers why stable functionality in the previous version is impacted after moving to a newer release — especially when the resolution is deferred to the next version.Frequent releases are beneficial for innov

Hello!  Do any of you know how to run a general ledger for all accounts for a range of dates (most commonly quarter or year) with a beginning and an ending balance showing all account detail for the period selected? Thanks,Kay HoweJackson, OH 740-418-5250

I am attempting to reprint a check using the same number in 25R1. I follow steps below but it reprints with the next number, not the same. What am I missing?After printing (without releasing), select “Reprint” action on the Release Payments screen, select the payment, and process. Status is changed to Pending Print.  Print / Process the payment again. Next number is assigned instead of the original. If I try to manually change, it errors saying the number already exists. Thanks in advance!

We cannot find a way where we can point the posting of sales tax payable amounts to individual sales tax payable GL accounts in Acumatica when the Avalara integration is active. IEIL Tax = GL account 2152PA Tax = GL account 2153OH Tax = GL account 2154How is this possible? Currently, all AR documents are posting to the same sales tax payable account listed on the tax GL account tab in the vendor master.

At summit I seen a few cool examples of people using business scenarios/recurring tasks for month end checklists etc. I am not finding a lot of guidance on the web or in the documentation.Anyone have good examples and/or a good place to go learn more?Anyone using these for sop’s?Screens WZ201000/WZ202000.   

The prepare tax button and process/release was done mid month on accident. Now our GL is off and our generated AP bills are incorrect. Not capturing the second half of the month. The only solution I can come up with is creating a manual AP bill to pull the rest of the sales tax due in, but is there any other way to reverse what has happenned in order to just start over? Is there a way to capture the remaining tax due for October besides a manual AP bill? What would the ramifications be of creating an additional AP bill to pull in the rest of the sales tax due? How does that transmit into next months Sales Tax Prep in ACM? Does it mess anything up if our generated Tax due in ACM does not match what we actually file and pay?Thanks for any help!

Acumatica does not allow us to apply a 2nd Prepayment against a Balanced Invoice if a Prepayment  already transferred to the Invoice from the Sales Order.Here is our process:Create SO Apply Prepayment of 10% to SO Create Balanced Invoice (do not release, we have to wait until our customer picks up the product to release the invoice) - Acumatica automatically pulls the SO Prepayment over to be applied to the Invoice. When customer makes final payment prior to picking up the product, we want to apply a 2nd Prepayment against the Balanced Invoice - Acumatica does not allow this (I found a quirky workaround that if you temporarily unapply the SO Prepayment from the Invoice, apply the 2nd Prepayment, then reapply the SO Prepayment, it will allow you to apply both Prepayments).  The reason we use a Prepayment for the final payment prior to pickup is because we have situations where a customer makes a final payment but doesn’t pick up until the next month.  If we would use a ‘Payment’ type tr

Hi.  Our client is looking for best practices in tracking vehicle and equipment loans.  How have you addressed this?   Do you create a separate GL account for each loan?  Have you found a way to tie it to the Fixed Asset in the FA module?  Has anyone successfully used subaccounts to make 1 GL account and then use subaccounts to distinguish between particular loans?I know there is this idea out there.  If you need this as well, you can go to the post below and upvoteFixed asset Loan Tracking | Community

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 

Does Acumatica allow the ability to group multiple purchases to one Asset Under Construction?  A one to one relationship between a purchase and an Asset does not line up in all cases(Example--parts from one vendor and Service from another for one specific portion of an overall project).  

Hi, I am trying to install device hub but idk why installer is showing me this error again and again. I tried to fix it but did work out. Any suggestion please? 

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) 

We have a vendor for whom we paid multiple invoices in one payment batch. Therefore, there is only one payment reflected in ACU. However, the payment amounts for each invoice withdrew from the cash account individually, so there are now multiple bank transactions that match to a single payment. Acumatica allows you to select multiple payments to match to a single bank transaction, but it does not appear to work the other way around. Does anyone know a way to get this to work that I may be missing, or a handy workaround? I would like to avoid voiding and recreating the payments if I can, but let me know if that is the only way.

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.  

Hi Team, Loading issue .  controls.0e1524f82c6d60c668f2.bundle.js:1 Extension AP301000_Approvals registered for the AP301000 screen view modelcontrols.0e1524f82c6d60c668f2.bundle.js:1 featureInstalled: PX.Objects.CS.FeaturesSet+Constructioncontrols.0e1524f82c6d60c668f2.bundle.js:1 Extension AP301000_Compliance registered for the AP301000 screen view modelcontrols.0e1524f82c6d60c668f2.bundle.js:1 Extension AP301000_ComplianceDocuments registered for the ComplianceDocuments viewcontrols.0e1524f82c6d60c668f2.bundle.js:1 Extension AP3010000_JointChecks registered for the AP301000 screen view modelcontrols.0e1524f82c6d60c668f2.bundle.js:1 Extension AP301000_DuplicateReference registered for the AP301000 screen view modelcontrols.0e1524f82c6d60c668f2.bundle.js:1 Extension AP3010000_PO_FillingInvoiceWithPOEntities registered for the AP301000 screen view modelcontrols.0e1524f82c6d60c668f2.bundle.js:1 Applying mixins for the the AP301000 screen view modelvendors.33828d476a3649b7bfc8.bundle.js:2

We recently upgraded to 2025R2 and set our site to use Modern UI everywhere. Some of our row sets use alphanumeric row codes (“1010A”) and this was causing an error: “Input string was not in a correct format.” The row set was unable to be edited without reverting the Row Sets screen (CS206010) to the classic UI. I then had to manually edit the row codes and formula references. The row set was then able to be converted to the modern UI.  Can anyone at Acumatica confirm if there is a fix coming for this? All of our other row sets converted to modern UI without issue. 

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

Hello,We have a customer that uses ‘locations’ to ship to the various stores under the main customer umbrella. We noticed that the sales person would need to be added to each individual location for them to be attached to it. However, when we do this, it duplicates the customer in its entirety. I have seen in my research about duplication verification, but that is not on my enable / disable list.  I’ve also read that this may not be possible yet (i may have been looking at an old post.) Has anyone else experienced this issue and possibly know a fix?