Financials

We have an issue when a customer account is on Hold or Credit Hold.  We are not able to process and past transactions, new payments, payment applications, AR Credit Memos or AR Debit Memos.Does Acumatica have a setting that would allow the customer to be on Hold or Credit Hold for new sales but not stop activities to already posted sales, new payments, applications of payments? When we process these already posted items we have to remove the customer from Hold or Credit Hold.  Then during this window of time new sales orders can be entered which is what we were trying to restrict by put the customer on Hold or Credit Hold.

Hi Acumatica,Goal: To delete a fixed asset that has transactions released and posted to GLBackground: We accidentally released a fixed asset purchasing transaction, and in the moment, posted the incorrect transaction to the GL, and posted a reversing entry in the GL. Now, when we attempt to delete the fixed asset, Acumatica disallows this. Furthermore, Acumatica disallows the deletion of the purchasing transaction that was created for the asset (and subsequently released and posted to the GL).Please help!Thank you, 

I have one Bill of amount 10,000 (Post Period December) and have a debit adjustment of amount 40 (post period : October) .  Both Bill and Debit adjustment is for the same vendor. Both Bill and Debit Adjustment status is ‘Open’ I went to the Debit Adjustment and clicked ‘Apply’ , this to me to the below screen .I tried to find the Bill , but Bill does not appear .Did I miss something ? or am I not doing it in the correct way ?  

Hi,We can create fund transfers in between different cash accounts and transfer cash from one cash account to another. How can we create a check for these fund transfers to transfer the cash between our current accounts at the bank.  Thanks,Dulanjana  

Hello,We are trying to dispose of an asset as part of Fixed Assets historical migration. Our client is live on other modules, so we imported all the assets successfully, using FA Migration Mode (unclick ‘Update GL’ in FA Preferences).One Asset was purchased in January 2022, depreciated through February 2022 and needs to be disposed of on 2/28/2023. When we try to dispose it, an error appears:  FA Error: The asset cannot be disposed of in past periods.We have tried requiring reconciliation prior to disposal, not requiring reconciliation, depreciating before disposal and not depreciating. We have tried re-opening the period for the disposal, and that made no difference. We are logged into the tenant administrators with full rights in all modules. All transactions for the asset have been released.I am able to successfully dispose assets as of a prior period in my Demo so I do think it’s possible.What have we missed?  Thank you.  

Hi, Is it possible to correct SO Invoice with Stock Item and Open status in Acumatica 2021R2 ? When I click on Correct Invoice system throws an error: SO Error: The invoice cannot be canceled because it contains direct sale lines with stock items. Process a direct return to cancel the direct sale.Thank You.

I wanted to clarify an important point regarding sales pricing and purchase orders in Acumatica.The sales price on a Sales Order is independent of the vendor cost on the Purchase Order. In theory, changing the customer price should not affect the PO. However, when a Sales Order line is linked to a Drop Ship PO, Acumatica locks certain fields—including Unit Price—to maintain document integrity.This means that once the PO is closed, the system prevents editing the Unit Price on the Sales Order, even though the two values are unrelated. While we can adjust the price at the invoice level, this does not update the Sales Order itself, which impacts sales journal reports and historical accuracy.To ensure reporting reflects the correct price, we would need the ability to override the Unit Price on the Sales Order after PO closure. Currently, the workaround is to remove the PO link, apply the price change, and then proceed—but this is not ideal for audit trail purposes.Please let me know if the

Hii, i want to ask or maybe you can give about your experience and thought about taxes in Acuamtica. I want to find more about module taxes, specially about Tax Adjustment and Tax Bill and Adjustment, because i want to pay may witholding taxes but while i try to use the Taxes “Transactions” it end with the picture i put bellow:I try to use Tax and Bill Adjustments, but the tax zone is empt.I hope you can help me to learn about taxes, please help me to try understand this module or if you have any files like PDF about taxes in Acumatica, it will really helpful. Thank you for your kindness, i really appreciate.

If we have Installment Terms in the Credit Terms for Customers, is there any way to create those Invoices before shipping the Product?Basically, our client has Terms for Customers that require progress/installment Payments including the Invoice before Product is shipped.I am running into two issues. If trying to create a PrePayment, I cannot do that if the Credit Terms have Installments.If I want to use the Installment functionality to create Invoices, I can't do that until the Product is shipped Any ideas on how we can solve this ?Ideally creating Invoices ahead of Shipment and utilizing the native Installment functionality on the Credit Terms. I know both my issues are apparently expected,  but we need to find a good way to have Installment payments done before Shipments.This is very common in the Manufacturing industry / custom machinery

-Version 25 R1-Ms Edge autofill is turned off (e.g. edge://settings/autofill/personalInfo). On the customer master general screen (or on the customer contact screen), when I enter the customer contact phone, I get blocked. Specifically, I select the field by either tabbing or clicking on the field and one of our IT admin phone numbers is displayed, but not entered.I can’t enter a phone number while I have the field selected, thus I am not allowed to enter a phone number. Here it is:  When loading the customers, I did use a generic email address at my first loading for all our customers and this phone number was used with this because I didn’t want testing correspondence to go to customers. Future import scenarios removed this email address and phone number. → I tested with other accounts→ I tested with InPrivate mode.→ We have active directory configured for our user accounts

Hello i need help on sales tax. December was inadvertently closed and i need to retrieve the December invoices. They are not showing up in the tax detail report in any other months. I thought they would show in Jan but they are not. We need in order to file taxes. 

When exporting a Generic Inquiry (GI) to Excel, the Debit/Credit column is showing Count in the Excel status bar instead of Sum, even though the values appear numeric. This happens because Excel interprets the exported data as text, not numbers.Details:Acumatica Version: 2025 R1 GI Column Expression:   =Round(IIf([GLTranR.DebitAmt] <> 0, [GLTranR.DebitAmt], -[GLTranR.CreditAmt]), 2) GIDespite using CDec() and numeric formatting, the exported Excel file still treats the column as text. This results in:Excel status bar showing Count only. Long trailing zeros in the values (e.g., 5273651.000000000000000000)Is this behavior expected in 2025 R1? Is there a way to force Acumatica to export calculated GI columns as numeric without post-processing in Excel? Any best practices for handling this in GIs? 

I want to share some tips and tricks for Acumatica Payments that is a part of Acumatica ERP 23r2. How to make the Payment Link look nice in the email notificationAcumatica can send Payment links to customers to pay their invoices. The default notification looks something like this: If you want the payment link to look like a text with a link, you need to do the following:Go to Email Templates and open Invoice Payment Link template   Remove the default ((PayLink.Url)) Click Insert → Link   Select ‘File from the Web’, for URL use ((PayLink.Url)), for Insert Link use any text you want and Click INSERT Enjoy your beautiful link in the email!  

Hello All, I am curious if anyone uses Acumatica to track Resale Certificates for your customers. If so, how would you does your company do that?

Hi AllIn our Acumatica instance, when entering a line in the Sales Price Worksheets screen, the defaut value for the Price Type comes up as Customer Price Class.Is there any way that it can be set to use Base as the default value instead, please?Price Type default value is currently Customer Price Class. We would like it to be changed to Base as the default value if possibleThanksAmit

We are using Avalara for AvaTax sales tax calculations as well as their Exemption Certificate Management system to handle our customer exemptions. We have a large volume of customers that have a sales tax exemption that only applies to certain product categories. For example, if customer buys product A it’s exempt but if they buy product B it’s taxable. Avalara has a feature “Exemptions by product category” and I believe I’ve set that up correctly adding the relevant Avalara tax code to the category then applying that category to the relevant customer exemption, however it doesnt work and charge taxes correctly. It sets the customer as fully exempt regardless of the product type when I test transactions in Acumatica. Does anyone use this feature or can they give me some guidance to a potential workaround? 

We have a Foundation that uses Fund Accounting. At the end of each year when we roll forward our balances to 1/1 we roll the contributions, interest and expenses into a fund account. We don’t show it as a JE just adjust the opening balances as of 1/1. See below for an example. Is there a way to do this in Acumatica?  

I am using the financial report writer to build a project P&L for my client. I am having trouble getting the project name to appear in the title since there does not seem to be a parameter available.In my column set, I have added:=@StartProject + ' - ' + THIS IS WHERE I WANT THE PROJECT DESCRIPTIONThe project code is an auto-numbered ID and without the name makes it difficult to identify the reports.Thank you in advance.

Does anyone have any xml files for basic Cash Account Generic Inquiries?  I would really like to build something simple that just shows me a total for a cash account based on todays current Balance and adjust for any AR or AP that is due within the parameter date range I give it.  I want to be able to say, how much will I have on 11/20/2025 based on the balance of today, any due AR and AP, and any future AR and AP that has not been paid yet.  Almost all of the banking and finance inquiries are Customizations that do not let me pull that information in as a data source. And I am not experienced enough to mess with the customizations themselves.   Has anyone made something like this? Or does anyone know how to make one?  Needed info: Cash accountBeginning balance @TodayDate filter/parameterSum AR completed and due within Date filterSum AP completed and due within Date filterEnding Balance running total for each day

Hello,On December 1st, our GST number changed and we are wondering what would be the best way to manage our AR invoices to reflect this change : every AR invoice dated November 30 or before should have our old GST number, whereas AR invoices dated Dec. 1st or after should show our new GST number. We usually set up the GST number on the Company screen. The problem is that if we change it on the Company settings, it would also change the GST number on previous invoices. What would be the best way to proceed in your opinion?

We did a mid-year Acumatica implementation. How do I load the vendor payments by branch for 1099 reporting purposes? Our branches have different EIN#s.

We recently migrated all our SKUs from average to standard costing due to average costs getting all mixed up. We did this by issuing out all of the inventory, updating costing to standard and entering a receipt back in. I am running the inventory valuation report but continuing to see the inventory valued at average cost rather than the new standard cost of the SKU for many items. One example is the following SKU:L175:Standard Cost - $42QTY on Hand - 425Expected Cost - $17,850 Cost per Valuation ReportAverage Cost - $235QTY on Hand - 425Cost on Inventory Valuation Report - $99,875 This appears to be an issue for all SKUs with an INCost ValMethod of “A”.Any reason why this INCost ValMethod would remain as average despite the SKU having been changed to Standard Cost?

Hey all! I cannot figure out why I cannot get a specific cash account to appear when creating a refund.  As you can see PAYPAL and WEBSITE are  accessible cash accounts for the “UNSETTLED” payment method. But “CCINCOME” is not, which is the desired cash account. Here are the settings for the desired cash account:  Here are the settings for the cash accounts that are available: Does anyone have any insight as to why it’s not an option to select?

We recently implemented the credit card surcharge features available through Acumatica Payments. Almost immediately, a request came in to enhance the Payment Receipt (AR643000) document to better delineate these charges.Specifically, we needed to clearly show the amount charged or refunded to the customer, the associated fees, and the resulting total balance. Attached is the customized stock report we developed to meet this requirement. Sharing here in case it might be helpful to others in the community or serve as a starting point if you are working on a similar customization.

Hello, I am new to acumatica, I am preparing for year end inventory, I cannot seem to prepare an inventory that shows all Active inventory Items. I have found that if I do a full physical inventory it actually is not. it leaves out items with 0 on hand.  Please anyone.