Financials

I am trying to hide or disable the Return option in Purchase Receipts for our users since it is often used in error. I was really hoping I could figure this one out myself by using access rights by role in user security but am struggling to find the proper section. On another note, I am excited that they finally added the option to either cancel/correct a receipt in 2025R1!  

Hello Community, While exploring the Controller dashboard I tried to modify the Cash Position widget to display the Account Description instead of the Account Code.  I took at look at the underlying GI, CA0002DB, which has the Account Description selected, active, and visible. However, when you view the GI results the Account Description does not appear and it is not available in the Column Configuration window.I have tried removing the field and then adding it but there is no change.What am I missing?  

Hi All,In some instances, we have to move AP invoices to other projects. This is something we were able to do in our old system but cannot seem to do this in Acumatica.For some reason, you can still move the purchase order to another project but the AP invoice does not move meaning the figures are incorrect against the projects.This is mainly for part-billed or closed invoices. Thanks 

Hi,I need to get a list of unreconciled fixed assets in the system. I tried building a generic inquiry but the system says the data class “GLTranFilter” is not available in the system.Further, I tried running Unreconciled Transactions for the Period report and it gives only transactions which are credited to the Fixed Assets Accrual account. Does not show any assets created manually and not reconciled. Kindly expect your assistance.Thank You,Dulanjana

Hi all,We're on Acumatica 2024 R2 (Build 24.206.0014) and have a scenario we’re unsure how to handle:Use CaseWe need to pay a single AP Bill to multiple vendor payment locations (e.g., 70% via ACH to LOC A, 30% via Check to LOC B).Splitting the bill is not an option – we need to preserve the original bill detail for 1099 reporting and analytics.Questions Is there a native way to pay a single AP Bill to multiple locations? Has anyone implemented or used a custom payment allocator for this? If customization is needed, what’s the best approach ?

Anyone know how to prepare a positive pay file to upload to the bank?

I am trying to create a GI for unreconciled assets as follows:All fixed assets, with a left join to FATran, only for TranType = “R+” (Reconciliation).  I’m assuming that the assets that have no FATran record will be the ones that were never reconciled.How do I add a condition statement that allows only fixed assets with no reconciliation transactions?

Hi,My mater financial calendar is designed in a way that start and end is not according to the general calendar. Example is as below. And I’m setting up fixed assets and when creating a fixed asset with acquisition date 27/10/2021  it gives me below error. “ FA Error: The document cannot be released, because the 05-2022 period in the posting book does not match the financial period in the general ledger for the SFT company. To amend the periods in the posting book based on the periods in the general ledger, on the Book Calendars (FA304000) form, click Synchronize FA Calendar with GL.” Then I tried the process but it gives me below error. Can you please anyone help me with this? Thank you,Dulanjana

Hello! I am running into this error when trying to process a payment for a prepayment invoice.I tried looking everywhere but I cant find what the below is referencing. I thought it was the Prepayment GL Account on either the customer class or customer profile, but neither were able to get rid of the following error. Does anyone know how to solve this? Thank you!

Hi CommunityI have ha this issue before but I cannot remember how I resolved it.Client wants to reverse application on a payment but cannot release the document. It gives the error “The document is out of the balance.”They do not want to allocate another invoice immediately.Please remind me of the solution.regards 

We are trying to reverse a payment application on an AP Bill through Checks and Payments on the Application History tab. We get an error of “SO Error:  the document is out of balance”. Any idea why? The “Reverse Application” works fine on the AR side, but it is not working on our AP side.Thanks!  

We are currently looking into how to best integrate credit card expenses into Acumatica. Do any of you know how to do this?

Is anyone transacting foreign currency payments in the real world in Acumatica?If so, I’m curious how you’re handling the difference between the rate on the AP Payment record in Acumatica and the rate that your payment provider uses, assuming that you process the payment in Acumatica before processing it with your payment provider. Here’s an example:1. The Base Currency ID on the Companies (CS101500) screen is USD  2. Enter an AP Bill in the Bills and Adjustments (AP301000) screen on April 01, 2025 for 100 EUR at a rate of 1.11111111  3. Here’s the journal entry that gets created when releasing the AP Bill showing USD of 111.11  4. Enter an AP Payment in the Checks and Payments (AP302000) screen on April 14, 2025 for 100 EUR at a rate of 1.12733217  5. Here’s the journal entry that gets created when releasing the AP PaymentThe cash gets pulled out of the 10700 account for 112.73 USD because of the 1.12733217 rate on the payment:100 EUR * 1.12733217 = 112.73 USDThe 20000 account gets re

I’m trying to modify the existing Journal Transaction report to ignore subaccounts.  We have subaccount enabled in our set up but it is only meaningful in certain situations.  When I want to look at the activity in an ACCOUNT, I don’t want it broken up by subaccount. I know the GLHistory tables are used to pull the opening balances and they are organized by account & subaccount.  When I try to collapse the grouping around subaccount I get garbage for opening balances.I’ve also tried abandoning the GLHistory table and have built up the opening balance by pulling in all records from GLTRAN and totaling all of the DR/(CR)’s prior to the period I want.  But, I can’t get that calculated variable to pass from the detail section of the report to the header section for the account.  Can anyone suggest an approach to either pull the combined records from GLHISTORY or how to pass a variable from a detail section BACK to a header section.Thanks in advance.

We have several assets with NBV of $0.00 and beyond the end of Useful Life, but the status of the asset is still Active, while the status on the Balance tab shows Fully Depreciated. See below: How do we get the statuses to synch up? This is not the case with all assets with no NBV.Thanks.

For the tariffs in Acumatica, we are looking at using a document discount (with the discount % being input as a negative).  We are wanting the sales order line discounts to post to one GL account and the discount used for the tariff to post to different account.  What is the proper way of setting this up in Acumatica?

I turned on subaccounts today and now it sees like employees can’t create purchase orders. I wish I had an example of the error I just know that when I disabled subaccounts it fixed the issue. I don’t get that error in my test tenant but I’m wondering if it is because the purchase order was already partially created?Has anyone have experience with this? I know it’s a very vauge problem I apologize.

is there a PO line limit in Acumatica, as i wanted to add thousand lines in there.

When trying to hit the ‘+’ button on Vendors screen, a pop-up with following error message comes up:Error: [DiscTakenSubID] '00000 ' cannot be found in the system. Please verify whether you have proper access rights to this object.Don’t know what that means. If anybody knows anything about it, or anything similar, please reach out.Thanks

Hello,When we have migrated the fixed assets and when we run depreciation for the next first period, system will look at the asset from the acquisition date and calculate any over/under depreciation. Is there any way that we can depreciate asset from the migration date without doing over/under adjustment by the system for the fist period after migration? Simply system needs to run depreciation without considering over/under depreciation adjustments.Thank you,Dulanjana

We are finding inconsistent behaviour with the recognition of expenses receipts (24R2).Sometimes European dates are recognised other times not.But this question is about currency.  We are finding that all receipts are assigned the currency code of the company and that the currency symbol on the receipt is ignored.I would like to know if users in the US find that the expense recognition recognises the currency.  I assume that US employees will frequently have CAD or GBP expenses to claim.  ThanksJames 

Hi Team,For xxxx Customer. The total payment was $10,021.98 but T5018 reports shows only $6883.56 As shown in the screenshot below, the highlighted Ref. Nbr. appears correctly in the T5018 Report Details; however, the remaining payments are not being displayed. Could you please advise on the root cause of this issue?   

Good day,I added a new Company/Branch to the Unit Set.  All the individual company/branch reports work.  However, the Consolidated (ALL) report is now not working.  I have new Canada reporting ledger that is the new addition. Nothing else has changed other than adding the new company/branch reporting ledger for Canada. Any advice to getting the ALL (Consolidate Balance Sheet) for a consolidated Branch.  Below is the Unit set.Thank you.  

Good day communityI need to do a bulk reversal of batches created by FA which can’t be deleted. I have posted all the batches and created an import scenario to reverse. Error message is “Batch Status invalid for processing.” Can anyone help? Thank you 

We have been creating statements for several months and today when we went to run statements we got an error ‘ Nullable object must have a value’ . I have checked the statement cycles and the preferences and have not found a problem.  Any suggestions on what to check next?