Financials

Hi everyone,We're currently running a custom Acumatica site on 2023 R1 and are planning to integrate Stripe as our payment gateway.Our requirement is to support both:Credit Card payments Direct Debit paymentsWe've reviewed the available Acumatica knowledge base articles and documentation and found references to Stripe support for credit card processing, but we haven't been able to find anything that clearly indicates whether Direct Debit payment methods (e.g. bank account debits) are supported through the native Stripe integration.Has anyone implemented Stripe Direct Debit with Acumatica 2023 R1, or is aware of:Whether it is supported out of the box? Any version-specific limitations? The need for customization or a third-party solution to enable Direct Debit processing?Any insights or experiences would be greatly appreciated.Thanks!

Hi All,Is there a standard way to automatically populate a specific Subaccount when a user selects an Account on detail lines? When entering a new line in Bills and Adjustments (AP301000)or Journal Transactions (GL301000): Select Account = 632 ➔ Subaccount automatically fills as SUB-632. Select Account = 641 ➔ Subaccount automatically fills as SUB-641.  The Use Default Subaccount checkbox on the Chart of Accounts only pulls the single system-wide default from GL102000, which doesn't allow mapping unique Subaccounts per Account. Is this possible via standard configuration (without custom code)?Thanks!

My financial year starts 1 March, so March = Period 01.I built a 12-month rolling Trial Balance using ARM based on a Start Period/Financial Period parameter.Requirement:P&L accounts: show Turnover (period activity only) Balance Sheet accounts: show Ending Balance (cumulative)The monthly columns work correctly.However, the issue is with the YTD column:For P&L accounts, even if I set the column to Ending Balance, the YTD column shows only the previous month’s amount instead of the cumulative total.Example:Jan = 500Feb = 600Expected YTD = 1100But the report shows 500.Has anyone configured a rolling ARM trial balance like this, especially with a financial year starting in March, P&L Accounts should show Turn Over and Balance sheet Accounts Should show ending balance. How did you handle the YTD column for P&L accounts? I have attached my XML File for quick reference

Hi, I'm experiencing an issue with Project Template security: I have assigned a Project Group to a Restriction Group to limit access. In the Project Templates (PM208000) screen, it works correctly (users outside the group cannot see the template). However, in the Projects (PM301000) screen, when clicking the Template selector, all templates are visible and selectable, regardless of the Restriction Group settings. Why the visibility restriction is not applied to the Template lookup field in the Projects screen?

Does Acumatica have integration with Stripe Payment Systems? Thanks

Hi Community, I am in need of some help. We are currently booking some AR payments into a clearing account and then using the Bank Deposit feature to transfer those funds to the final bank account. However, we’ve found a couple instances where a payment that’s part of a bank deposit is returned. We would normally void the payment.How should we go about recognizing the returned payment since we shouldn’t be voiding payments that are part of a released deposit? We also need to be able to select the returned payment in the Process Bank Transactions for matching.Appreciate any insight.Thanks.

Has anyone been able to get an import scenario to work for the Trial Balance screen?  No matter how I adjust the Commit checkboxes, the assignment of Import Number, or the Key assignment in the Data Provider among other things, the best I can do is get a single detail record saved and I wind up with the same number of trial balances created as I have records in the file.  I’ve tried using keys from the record (Branch, Ledger & Fiscal Period) and also an added field to the file to group the records by Key.  I currently have ‘<NEW>’ assigned to the Import Number field in the attached xml, but that isn’t the issue.  I haven’t had this issue with other import scenarios for screens that have a Master - Detail relationship.  Since I have about 15 companies and 13 trial balances that need loading per company, I’d rather use an import scenario over the grid import of the detail.  At this point, I haven’t even tackled the Validate step; I’d settle for just getting the detail records i

Hello! We are looking for a Credit Management Platform that will integrate with Acumatica. A platform that processes credit apps, stores needed documents and etc. Any suggestions would be greatly appreciated!

Hi , In GL Module the tran description has 256 Characters where in Fixed asset Module in it 512 Characters so could you please validate and add the point

Does Acumatica have a solution for tracking price/compare at price from Shopify on an order level?There are a number of reasons to use the ‘Compare At’ price function in Shopify. They can be utilized in more complex promos to avoid Shopify’s limited discount ‘slots’. They also offer a better customer experience with slashed pricing, an immediate view on the actual sales price, and no requirement to remember a code. The problem with this is that Acumatica is just receiving the price as compare at price so it doesn't look as if it has been discounted. E.g.Product X has a normal price of $50We use Shopify compare at functionality so that this now has an 'Is' price of $40 and a 'Was' price of $50 (which will shown a slashed pricing on the storefront).When this comes in to Acumatica the line item just shows a pricing of $40 but we want to be able to track the fact that this actually represents a $10 discount The compare at pricing isn't available through normal order JSON but is accessible

Overview:In Acumatica, the standard behavior calculates and records Withholding Tax at the time of payment. However, for compliance with local statutory requirements (e.g., India), we are exploring whether it is possible to calculate and post Withholding Tax at the bill creation stage instead.Current System Behavior in Acumatica1. Bill Creation (No WHT Yet) Account Debit (Dr) Credit (Cr) Purchase/Expense A/c 100   Accounts Payable   100 2. Payment (WHT Applied) Account Debit (Dr) Credit (Cr) Accounts Payable 100   Withholding Tax Payable   1 Cash/Bank   99 Expected Behavior (Needed)1. Bill Creation (WHT Recorded Immediately) Account Debit (Dr) Credit (Cr) Purchase/Expense A/c 100   Withholding Tax Payable   1 Accounts Payable   99 2. Paymen

Has anyone used a 3rd party product for AP automation? Companies like TRAILD, Tipalti, etc?We use the native AP “New Document Recognition”, but it is really klunky, and slow.  We have a ton of 3rd party Landed Costs and outbound freight.   We spend too much time processing these vendor invoices when they should simply just flow through the AP process. thank you.

We are newly using 2025R2 AP incoming document recognition.  Am curious from other users if/when it learns the repeat invoice(s)?  We are finding it is not learning at all.  Each time you are having to map the missing fields.  We are likely going to abandon soon.

When multiple approvers are assigned to one step and any of the approvers can fully approve that step, then one of the approvers approves that step, the other approvers are typically unaware this has happened. If they also try to approve the same step, they receive a fairly cryptic message about being “not authorized”. It would be much better if the message returned told them the workflow step had already been approved. As is, it leads them to believe there is a permissions issue or some type of error happening.Has anyone found a good workaround for this? Obviously over time we can train the approvers to recognize the cryptic message and understand why they are getting it, but it would be better if the message was more clear/informative.Any other thoughts on this?Thanks,Mike

We have 5 Companies that have different cash accounts.  A payment was posted in Company 04, and a deposit was made in Company 04 in Acumatica.  However, when attaching the backup, it was noticed the checks we deposited into the wrong company at the Bank and went into Company 01.  Since the payment and deposit were all made in the correct company in Acumatica, as well as in the subaccounts, can a Transfer Funds from Banking module be used?  I was also thinking of using a Journal Entry and using our intercompany accounts. What is the best way to record a deposit posted in the wrong company with the bank.  Everything in Acumatica was correct.  

I have analytical report I created in the finance module.  There are several rows where I don’t want the last column to print.  It seems like this can be done through View conditions under column group.  However I can’t  figure out where I can define the column group to setup which columns I want to print for that row.   It doesn’t seem to take a  column range.   I searched beacon and this website and the documentation but I wasn’t able to find out where to set up the column range.  

Hello,  We know we can change a vendor prior to positng an AP bill but only if the detail lines are blank.  Do any of you know if it’s on the horizon to be able to change a vendor without having to remove the detail lines first? Thanks,Kay

We are excited to share an important milestone with the Acumatica community.S4 Consulting is now an Official Velixo Partner in Vietnam.As an Acumatica Gold Partner, our mission has always been to help businesses go beyond ERP implementation. We believe that the real value of ERP comes from enabling management to make better decisions through real-time data and continuous cost optimization.That's why we are delighted to add Velixo to our solution portfolio.Velixo extends the power of Acumatica by bringing live ERP data directly into Microsoft Excel, allowing finance teams to build financial statements, management reports, budgets, forecasts, and dashboards without exporting data or waiting for custom reports.#Acumatica #Velixo #ERP #FinancialReporting #Excel #CloudERP #Vietnam #DigitalTransformation

Hi Team,Issue Summary:When attempting to save or process a bank transaction record under “Import Bank Transactions” in Acumatica, the system displays the following validation error:"Payment Date cannot be empty."Steps to Issue Summary:Navigate to Cash Management > Process Bank Transactions. Import a bank statement using a defined Import Scenario. Attempt to save or process a transaction line. The error appears: "Payment Date cannot be empty."Refer to the below error message,  Thank & Regards,Sanjana Perera    

Open the report that you need to modify in the Report Designer (see more about the report designer here https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/) Open File → Build Schema… menu and make sure the CCPayLink table is added to the report   Go to Relationships Tab and Left Join CCPayLink to ARInvoice or SOOrder based on PayLinkID   Add new Picture Box control to the report and configure it the following way: VisibleExpr: =[CCPayLink.Url]<>null BarcodeType: QRCode Source: Barcode Value: =[CCPayLink.Url]   Configure the size and position of the barcode. Add a new textbox and configure it the following way:Value “Click Here To Pay!” or any other label Navigate Url: =[CCPayLink.Url] Visible Expr: =[CCPayLink.Url]<>nullSave the report back to the server!Done! You now have a report with a barcode and a link that navigates customer to the pay link!  Troubleshooting:If you’ve configured the code and it still does not show up (or rather show up as

Apologies if this is already covered, I did search and could not find what I am looking for. Our five/six year old MYOB environment has a massive Audit history logs and I can’t find a way to delete on logs based on date and time?  Also, is this recorded for individual Tenants? Can the Audit log cleaning be done via UI or I need some special access to Database?  We have a cloud implementation, is it possible to get access to the database directly?

I am setting a P&L that shows month over prior month.  I would like to add a column that shows the amount variance and % variance.  What is the syntax needed in the calculation formula to do the math to subtract one column from another?  

Can anyone tell me what the formula $AdditionsInPeriod or $DisposalInPeriod in a FA report means? I assume it means the total additions or disposals for the period but I am not familiar with the prefix $.The report I am working on seems fine but the totals do not balance. I am trying to understand the field content so I can correct the totals.Many thanks in advance. 

hello,I am using Resource owner password flow to get Acumatica token.I am encountering an intermittent issue across all environments, including Production.When we receive an application for processing, we call the Acumatica Get Customer endpoint using a valid authentication token. Occasionally (approximately once a day or every other day), the request fails because the response cannot be deserialized. Our application expects a JSON response, but instead receives an HTML page, as shown below. We cache the authentication token and validate it each time it is retrieved from the cache. Token validation is based on the Date header returned in the token generation response to ensure the token has not expired. Could you help us determine why the API is intermittently returning HTML instead of the expected JSON response, despite the token being valid?Tokens:return html response : LqGoqJP-MvG2Q44kKI_QEq0PqziBlrWXnInucaZS9w0return Json (Valid): IPLN2zlT8ui3GzGoySRC2M5nyz0Xa-StJ3cup25MAncif (resp

Hello,  I have a scenario where my company is based on UK and I have warehouses in Netherlands and Spain (Also in few other countries) Also, I have an EU customer whom I shall deliver goods from either Netherlands or Spain.On a sales order when I select the warehouse considering the country of it (If the country can be taken from branch that is also an option), and country of the customer, it should update the correct Tax Zone. In simple terms, my tax zone needs to be updated not solely based on the customer country but also considering the order origin country.  Is there a way to get this done?