Financials

Hi!  We have 3 different translation IDs set up so we can translate our foreign entities (GBP, HKD, and CNY) into our main reporting currency (USD).  We occasionally run into an error when preparing the translations that is intermittent.  Anyone have any thoughts on what’s causing this, especially with it being inconsistent in occurrence? I have confirmed that we have translation loss and gain accounts and subaccounts set for USD within Currency Management > Currencies.One of my employees had this error yesterday when trying to translate our GBP branch into USD, but was able to do the translation this morning.  We’re both now receiving this error when trying to translate our HKD branch into USD.  This doesn’t happen every month when we do this and usually goes away the next day, so it’s not critical since it appears to re

Hi there, Wondering if anyone has any experience doing bulk asset transfers between companies. For example, the current Transfer Assets screen (FA507000) only allows the transfer between branches or departments of the same company: Instead, I’d like to transfer between two companies, e.g. ABRVL to ABSLL, and for multiple assets at a time. My only thoughts on this would be to either:For single transfers, dispose of and then bring back the asset (at NBV) to the new Company (very cumbersome) In the case of multiple transfers, do the above one-by-one, or create a negative asset in the source company and then create a positive asset in th

Using Acupay in 25R2, we are able to get the payment links to create and show up on the standard sales Order invoice but when generating a Prepayment Invoice, there is no payment link tab on the record and it is not showing up on the Prepayment Invoice.  Does the payment link not work with Prepayments or am I missing some configuration or checkbox?

Good morning,    Does anyone know how to add multiple signatures to a Cash Account?  

Hello,We are using Acumatica to manage VAT on payment / cash-basis VAT.Our requirement is to recognize or track VAT on payment, especially through the screen TX503500 – Recognize Input VAT, but without generating additional GL transactions.This is a one-time / temporary requirement, only until December 2025. Starting from January 2026, we would like to return to the standard Acumatica behavior, including the normal generation of GL transactions related to VAT recognition.From our understanding, the standard VAT recognition process generates GL entries to reclass VAT from suspended VAT to recognized VAT. However, during this transition period, we only want to track or report this information for tax / reporting purposes, without any additional accounting impact.Is this possible in standard Acumatica?If yes, how can we configur

Hi there! I am seeing GL batches created and I’m not sure what is causing them or why The transactions in question are the blue highlighted batches. I’m able to link all of the other GL transactions back to their source documents and they make complete sense but it seems like AFTER we release an invoice (and after the GL for that action is created) another GL is created moving funds from the HEADOFFICE unearned revenue accounts to the SEEDS unearned revenue accounts. When I click the source document for these 2 batches it brings me back to the prepayment. When I click the audit history of these batches I’m able to link the creation back to an automation that releases the invoices but to me it doesn’t make sense as to why it’s happening when it happens. 

When a customer is set to credit hold or inactive they do pop up in the search.  My concern with this is we had an employee accidently create a new customer for someone that was previously set on credit hold (also happened for one set as inactive) that we shouldn’t be selling to due to past due account.  How is this best handled in the system so employees are seeing these customers when searching.  

Hi, how do I reverse FA Reconciliation+ type? 

Any idea about this error when creating a Purchase Return from a Purchase Receipt and how do I resolve this? Item is serialized, so I ran Inventory Lot/Serial History and don’t see the item going out of warehouse location. See snippet below with only one transaction happened in that serial number.This is the POR with Line Type ‘Goods for MFG’ but when I tick each line and create a return, line type is ‘Goods for IN’ and unable to change. 

The International Accounting Standards Board has issues IFRS 18 - the new standard on presentation and disclosure in financial statements with a focus on Profit and Loss. One area addressed by this standard is foreign currency. “IFRS 18 requires foreign exchange differences to be classified in the same category as the income and expenses from the items that resulted in the foreign exchange differences, unless doing so would involve undue cost or effort.”In Acumatica, Revaluation Gains and Losses are set up for each currency. Since the Revaluation process Creates a CM batch in the General Ledger an accountant can manually adjust the batch to allocate foreign currency gains and losses to the related income and expense accounts.  Does anyone have suggestions for a more sophisticated approach to this?

Hi, Is there a configuration that allows revenue to be recognized as sales income at the time of shipment confirmation? Thanks,

I want to get the payments details of a specific customer reagarding the payments he did for this year from Jan 2025 to Current and the invoice details that were set off thorugh those payments.It can be a report or anything.Thank you

How can I enter a credit and a rebill when we are charged the wrong amount for materials.  It really isn’t a return and as of now, I cannot figure out how to do this.

 We need your help understanding the system's behavior regarding a negative Landed Cost.In warehouse Item A beginning quantity = 52 units, using Average Cost. We received 12 units via 2 receipts (applied initial Landed Cost) -> Did some inventory transactions -> Ending quantity = 12 unitsThe vendor gave us a credit. We created a negative Landed Cost linked to the original 2 receipts to reduce costs.When released, the system credited both the Inventory account and the COGS account.Why is the amount split between Inventory and COGS? Where is this posting behavior configured in the system? How does the system calculate the specific amount allocated to each account?Thank you!

Our customer has segmented subaccount numbers. They wish to do a search on the account details screen with a partial segment that will pull all subaccounts with that partial. Is it possible to use a lookup field for segmented numbers?  See screenshot below. 

If an item is received under the correct unit cost, specifically due to landed cost errors, would the best way to correct this is to do an adjustment referencing the receipt number, and adjusting the extended cost of the item? I thought that would be the best way to do this but when I tried in our test tenant I noticed that the cost layer for that item/receipt combination did not change. 

Hi, We are looking for Acumatica customers and partners interested in participating in the Beta program for AcuBot.AcuBot is an intelligent Acumatica assistant designed to help users find answers to configuration and process questions in natural language.Key capabilities include:Guided assistance for common Acumatica tasks Reduced dependency on support teams for routine questions Faster onboarding and user adoptionWe are seeking a small group of Acumatica customers and partners to provide feedback and help shape the product roadmap.If you are interested in participating in the beta program, please reply below or contact us directly.Thanks, Ashish

How can customer payments be set off against another customer account in Acumatica when there is no established parent-child relationship between the customers, and without creating debit or credit notes?Looking for recommended approaches or best practices.

Wondering if anyone is successfully using Bank feeds in Canada? Looking for strategies that work.  The client banks at BMO and BNC and we’ve had a hard time making connections to either. We’ve tried both Plaid and MX with no real success.  We did have a connection to BMO but using a bank card instead of normal account credentials but that has since stopped working. And at one point we were able to connect successfully using MX but the Refresh did not return any transactions on accounts that definitely had transactions.  Very frustrating!

When calculating the amount of daily bank funds transfers, sometimes mistakes are made.  The most easy fix would be to reverse the entire entry and start over.  However, Acumatica will not allow us to reverse a funds transfer entry.  Here is the error message:In the G/L #1001 is designated as a Cash Account as we use it for cash clearing.  Appreciate any ideas about what is stopping even our Admin from reversing a funds transfer.We only have 1 branch within Acumatica.

I have a customer that is using Plaid to as their provider for bank feeds. There is a column in the file labeled check number with the check number in the field. The check number is not appearing in the when the bank feed is processed. I attempted to map that field but when I did that, the customer received the error “object reference not set to an instance of the object. 

We have some items which we can stock ourselves or drop-ship to customers. When these items are drop-shipped, we would like to be able to change the Sales and COGS accounts to our drop shipping accounts. While we can change the sales account on the Sales Order for these items, we cannot find a location to overwrite the COGS account from the Purchase Order side of the process. It seems entirely driven by the Stock Items’ Posting Class, which is set to be the usual accounts as drop ship orders for these items are uncommon.Is there a way to specify the account of items on a Purchase Order/Receipt like there is on a Sales Order?

We recently purchased a piece of equipment that came with three separate bill (for its different components). However, for accounting purposes, these need to be recorded as one asset. When we try to use Reconciliation Addition to combine the costs, the system only updates the current cost value. The Orig. Acquisition Cost remains stuck at the value of the first bill, which doesn't reflect the true total cost of the asset on our reports. We need the final Asset ID to show an Orig. Acquisition Cost that equals the sum of all three bill.How can we set up for this?  

 Error: Unhandled exception has occurred, your changes have been rolled back: Error: An error occurred during processing of the field Cash-In-Transit Subaccount: Error: An error occurred during processing of the field Subaccount: Error: Branch, Product Group of Subaccount do not exist in the system.We don’t use subaccounts so I’m a little confused.The reason I am trying to change these preferences is because none of our credit card settlement transactions are matching even though I can find them via the Processing Center ID every time so I’m wondering if the document date is holding too much weight. We are also still using Authorize which I know is no longer supported so...maybe that’s the issue?

Has anyone found a method to auto release reversing journal entries? They get created on Hold and we are finding that users are making changes to them prior to release. We need to prevent that.