Financials

Hello everyone, so i want to proses bank transaction in acumatica between Bank Statement and Transactions in Acumatica. While i try to match on transaction in Bank Statement, there is not match Payment, Invoice, nor create payment for Cash Advance Transaction.When i check to Check & Payment with type of Prepayment, the transaction already completed and the journal also already created with status OPEN because there is still not settlement for the cash advance.Is it because the status still open in Check & Payment (for type Prepayment) so Acumatica while try to Process Bank Transactions not read it the transaction of Cash Advance. So it makes my Bank Reconciliation not work. Please help me to explain about this,  i really appreciated your answer. Here i attached of the detail bellow:  

Hi, we currently save emails to MS Outlook and would like to save them in MYOB acumatica/payables/suppliers. when i try to drag an email into the supplier “files” in payables, i get this error. Any ideas on how we can drag emails into MYOB to save them there? 

I am wondering if it’s possible to unlink Customer and Company. This customer is extended from a Company.The reason for this is we want to change Company type from not having branch to have branches.To be able to do this, the Company cannot have customer/supplier extended.I try to delete Customer however because it has transaction, this cannot be done hence I’m looking for an option to unlink.

Hello,We have just created a budget in Acumatica.Is there a way to :(1) Link the budget line item with the bill / cash purchase transaction(2) Automatically flag an invoice when it exceeds the budget for that vendor?  We are looking for various ways to instore controls to ensure that our actuals do not exceed the budget. 

This is a two-part question/request for guidance. I need to set up AR so construction billing will retain tax on the retainage. I understand we need to specify the retainage tax payable account/subaccount in TX205000. We use Avalara for tax calculations. I have not found any documentation to help guide me through this process or show me the accounting flow of this. Can I assume the retained tax account would be a liability account? I have a test tenant, but do not have an Avalara sandbox so testing is useless at this point. Thanks. 

We have a maintenance service contract with a customer that has multiple locations, and need to bill the contracts for all the locations into one bill to the main customer. We need separate contracts because the appointments need to be created for each location being sent to different field technicians. 

Hello, I'd like some advice on how to appropriately configure pricing and discounts to solve a business need. Here's a concrete example:- For simplicity, let's say we have three different 12oz Cups: white, black, blue. - If a Customer orders 120 12oz Cups, in various colors, they get 10% off those products. - I can't set up this scenario using Sales Prices, so I'm using a Group Discount instead. I like everything about the functionality of Group or Document level discounts...except for one thing: On the ARTran table, the Sales Price—and resulting product margin—aren't correct, because it's applying the discount as a separate line item.  I'm hoping there is just a setting somewhere to "apply discount to components evenly". How have others handled this limitation, or is there anything I'm not thinking of?  ​​​ 

Hi Acumatica TeamI have a FA that have been reversed on feb 2024, currently my client needs to Close 11-2025 period but he can’t, Acumatica show the following message:Not deprecated by the book in 11-2025 period:I did the tracking of the depreciation, and I verify that my client only calculates the depreciation of 11-2025 but without running the depreciation.I verify that Acumatica does not allow reversing the calculation.Is there a way to close the period in this scenario?Thanks you very much for your attention Karolina 

I was wondering if anyone has a work around for reconciling Balance Sheet accounts?  Our accountant likes us to reconcile all of our Balance Sheet accounts.  When we were using QuickBooks, this wasn’t an issue.  However, using Acumatica, this doesn’t seem possible.  Any suggestions? 

Hi, I’m trying to consolidate group of companies for financial reporting. I’m using ARM reports to consolidate different companies and there are minority adjustments to be made to remove the non-controlling interest of few companies. Is there any way that can be configured in Acumatica?Thank you,Dulanjana

Customer have Company wise Financial Calendar . I am running my 12 months BS based on Master Calendar”  What variable I can use to display the Respective company wise Periods (Eg :11-2025 ,12-2025) .   

Good afternoon,Is there a way to set up a line item (i.e. - our company catalog) to go in at $0 value and bypass CREDIT HOLD so it doesn't get tied up?We want it to count against inventory for the product, but just no monetary value.Thank you!

Hi everyone,I'm having an issue with automatic tax calculation in Sales Orders (SO301000).The scenario: When I create a new Sales Order and select or change a Customer, the Tax Zone is correctly pulled from the Customer profile (Shipping tab) and updated on the Financial tab of the Order. However, the Taxes tab remains empty. 

Let's say I have three different companies: A, B, and C.I have also enabled "Customer and Vendor Visibility Restriction".Company A has customers A1, A2, A3...Company B has customers B1, B2, B3...Company C has customers C1, C2, C3...I have an external processing center that adds customer payment methods to these customers, regardless of which company they belong to, processing them uniformly.Then, I use an Automaton Schedule to synchronize this processed data.My problem is, using my administrator role (which has access to A, B, and C), no matter which company (A, B, or C) I create the job in to synchronize customer payment methods, there are always issues. For example, if I create the Automaton Schedule in company A, it cannot synchronize B1, B2..., C1, C2..., because the Import by Scenario function throws an error, stating that B1, B2... cannot be found in the system.Is there a way to circumvent this problem? Do I have to create separate Automaton Schedules for A, B, and C, and then di

Hello everyone,We’re in the process of switching to a new bank (we’re based in Canada), and I’m trying to make sure everything is set up correctly in Acumatica. Unfortunately, our financial contact from our supplier is away on vacation right now, so I’d like to get some clarity in the meantime.Specifically, I’d like to know the recommended steps for:Adding the new cash account for the new bank.Ideally pointing it to the same GL account as the original bank account (so reporting stays clean).Getting EFT set up for the new account.If anyone has experience with Canadian banks and Acumatica EFT setup, I’d really appreciate a walkthrough or best practices.Thanks in advance for any guidance!

Does anyone have any experience with separating a branch of your company into a separate company or separate tenant in Acumatica?  We have entered into a membership agreement with another entity and need our Foundation (currently a branch of our company in Acumatica) to be completely separate with its own set of customizable financial statements.  Just wondering if we should make our foundation a new company under the same tenant or create a completely new tenant in Acumatica???

Hey, gang - One of my customers is looking to establish thresholds for Customer Statements.  In their words, “Some months we would like to run statements for accounts having over $500 balance and others a $0 balance.”On the Print Statements (AR503500) screen, I simply added a filter and applied it to the Statement Balance field.  Has anyone else in the community managed thresholds like these for customer statements?  If so, what things did you do to accommodate this?  

Hi @all,Is it possible to Reprint check which is in closed status?

Hi everyone,Does anyone here encountered their automation schedule suddenly stopped processing after a few days? We have the following configured to automate recognition of deferred taxes. It is running but nothing is processed. Any advise? Tried replicating this same configuration on my local instance but gives the same result. Thanks, 

I generated periods for 2026. When I try to open them on Manage Financial Periods, 2026 is unavailable for selection. I’m in the Sales Demo environment, but I don’t think that should make a difference. Thoughts?

Can anyone explain me the stepwise procedure to reprint the AP checks?Already went thru the below post:https://community.acumatica.com/financials%2D7/payable%2Dcheck%2Dre%2Dprint%2Dfunctionality%2D7430 Thanks in advance.

We received a credit card refund from a vendor and I am unable to see it when I am reconciling the credit card statement.  I have entered the debit adjustment in AP.

Hello Acumatica Community,We currently apply multiple discount codes to a single AR Invoice. These discounts are summed and posted as a single document discount, which is then mapped to one GL discount account.Is there a way to configure Acumatica so that different discount codes on the same AR Invoice can post to different GL accounts instead of being combined into a single discount posting?Any guidance or recommended approach would be appreciated. 

Hello,We refunded the customer, but in Acumatica the refund was voided by mistake (this was not voided on the credit card portal). The customer did receive the refund — the issue is only with the record inside Acumatica.What is the best way to correct this so the system reflects the actual refund?Thank you. 

AI was used to create this Post.In Acumatica ERP, Intercompany Transactions allow you to manage business operations between multiple companies (subsidiaries) within the same Acumatica instance. This feature is essential for organizations with multiple entities that need to transact with each other, such as transferring inventory, sharing expenses, or consolidating financial data.Here’s a detailed guide on how to set up and manage InterCompany Transactions in Acumatica ERP:1. Enable Multi-Company and Intercompany Features Enable Multi-Company Mode: Go to Configuration > Enable/Disable Features. Enable the Multi-Company feature. Enable Intercompany Transactions: In the same Enable/Disable Features screen, ensure that the Intercompany Transactions feature is enabled. 2. Configure Companies for Intercompany Transactions Create or Configure Companies: Go to Configuration > Organization Structure > Companies. Create or configure the companies involved in interc