Financials

Hi! i am trying to modify the AR invoice form to add a section related to applied payments, however, its not showing up on the invoice properly and i’m not sure where i’m going wrong.  i’m not super familiar with report designer which doesn’t help  ideally, i would like section 1 to refer to the original invoice amounts and section 2 to refer to payments but this is how it’s showing up when i save the report: i am not able to upload the report but if anyone has any ideas, i would really appreciate it! thanks,  Iqra

We recently transitioned to Acumatica and have so issue with ggetting the credit card feed to work. Our company uses Royal Bank Credit Card (Commercial Visa Avion Cards) and we manage these cards thru Visa Spend Clarity Enterprise platform.  We are currently still using Concur Solutions (SAP) because we are unable to connect the credit card feed with Plaid or MX or via SFTP server. Does anyone have experience with Royal Bank and their credit card feed thru Visa Spend Clarity. We have about 50 cards and spend over 250K per month on them so the feed is very important to us. Thanks for your help Bruno

Bad title perhaps; I’m not an accountant, but they’ve asked me why and I don't know.Not sure how to explain this since, but basically they’re saying somehow the transaction was processed with negative GST.  In the Journal it shows the #’s reversed for this 1,149.91 All others look like this (Debit left column, Credit right): There’s hundreds as above, but this one below the values are in the opposite accounts and no one appears to know how this happened (including myself):  Anyone able to please enlighten me on what may have gone wrong? 

Saw this really great video (https://www.youtube.com/watch?v=weBglqXkBpA) from ​@Doug Johnson on Automated AP Bill Approvals with 3-way matching and he had 3 great side panels on the bills and adjustments screen that I would love to replicate. Related purchase orders Related REceipts Unbilled Vendor ReceiptsHe briefly showed the generic inquiries required to make the side panels but didn’t fully show them. I am trying to replicate it but was hoping someone had something similar that I could piggy back off.

Hi Acumatica!In my row sets → data source section, I chose expand code-description for a range of GL codes.How can I remove the spaces between the last digit of the GL code and the dash? The way it currently displays the GL codes looks awkward.selected code-description to expand the GL codes for a range of GLsOutput places 4 spaces between last digit of GL code and first letter of GL Description. I'd like to remove these spaces.Thanks!

We are working on setting up a vendor EDI integration to received AP Bills into Acumatica. from 810 messages. We are running into some challenges surrounding how to do the 3 way matching when we create the AP Bill prior to the PO Receipt mainly surrounding linking the receipt to the bill and handling 3 way matching for Bills that have multiple receipts. We stumbled on this post https://community.acumatica.com/distribution%2D6/hold%2Dap%2Dbill%2Duntil%2Dthree%2Dmatch%2Dcomplete%2D11048 and came up with the following options which I have listed the Pros and Cons for. If anyone have any experience with this I would love to hear how you approached this as we are at an impasse on whether or not there should be a technical solution to all of this or if certain scenarios, mainly multiple receipts against a single bill, will have to just be

I’m working on some testing of the fixed asset module and have come across a scenario that I can’t figure out.We have a handful of assets that we disposed this year and are looking to bring them into Acumatica with its correct disposal information.  When running my import scenario, it does not allow me to modify the disposal date, disposal method and disposal amount.  I have already done GL transactions directly for the disposal of these assets, so I do not want to post again. Has anyone does this before?

There are orders that contain non-stock items that get fulfilled right away before syncing to Acumatica the Shopify connector. These orders get the status of filtered. We would like to sync them to Acumatica using import scenario or API.Is there a way to import archived orders or modify Shopify orders to archive after 7 days? How do we prevent this from happening?

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

How do you set up Direct Deposit to receive payments from customers?

 I want to extend a new customers from business account, but while i try to extend there is error like this and also I can’t add a the new customer or account class. Can anyone help try to solve this?I really appreciate, thank you

Dear Supporters, I don't know why my set up approval have problem the user approval can't approval on the bill. Please kindly advise and Thanks in advance for support.  

Relatively new to Acumatica--we would like to make a change to the Profit and Loss financial statement to sort by Account Class then by Account Number.  Can this be changed and if so, what is the procedure to do so.  Thank you in advance.

Going to lay out the scenario below. Import 1 - worked fineImport 2 - worked fineImport 3 - worked fine (or at least seems so)Import 4 - does not recognize import 3, and sees import 2 as the last import The issue we are having with this is the system is giving us an error that our Start Balance Date and Beginning Balance do not match the last import.Error: “Start date does not match the end date of the previous statement (7/24/2025).” Is it okay to bypass this warning? What could be causing this and is there a way to correct? 

We’ve run into issues where our PO accrual account is overstated due to duplicate or mismatched transactions. Examples include: POs created but later paid by credit card, Vendor bills entered without a matching PO, Duplicate POs or receipts for the same items, POs received in error or not closed properly. Right now, the only way to confirm is by going line by line through hundreds of transactions, which is very time-consuming.Question: Has anyone built reports, generic inquiries, or other tools in Acumatica that can quickly identify and confirm duplicate or mismatched PO accruals across these types of scenarios? If so, what fields, filters, or logic worked best?In addition, what controls, best practices, or system setups have you found effective in preventing these issues from recurring (e.g., automated alerts, required fields, workflows, or periodic

I have a receipt that has been released and I can’t attach it to an AP bill because when I do, and then try to complete the process for the AP bill, it tells me that the Project Task was changed between the PO and POR and now I can’t process. I also can’t return the POR because I can’t change the Project Task. I created a dummy PO and POR so I could pay the bill, but now I have that POR “stuck”. Can I override it someway to mark it complete so it goes away? Please help!

How can I print a paid receipt for a payment made on a Requisition / AIA Billing?

We've encountered an issue when creating purchase orders: if the vendor and the branch are in different tax zones, the system prevents the PO from being created.To work around this, we set the vendor's tax zone to "Exempt," which allows the PO to be created successfully. However, when AP enters the bill, the tax zone defaults to blank due to the exemption setting.Is there a way for the AP bill to automatically pull the tax zone from the branch receiving the product instead? This would help us maintain accurate tax handling without having to override or manually adjust fields.Looking forward to your guidance.

Hello, I am getting this error when attempting to void a payment that is stuck in Pending Processing status: I have a list of about 20 payments that are stuck in this status, and a majority of them never actually made it to the external processing center, Authorize. They don’t appear in their records.  Since they are stuck in that status and never actually charged the card, I want to void them. However, I get that message that they are locked for editing. I cannot delete or void the payment.  Any ideas on how to resolve this? Thanks!

I am trying to void multiple integrated CC payment documents where the authorization has expired, but I get the following error message:“The payment is locked for editing. Please wait for the external transaction result. If the payment does not get unlocked, click Actions > Validate Card Payment to request the transaction result from the processing center.”When I click the “Validate Card Payment” action button I get the following error message:“Updating 'AR Payment' record raised at least one error. Please review the errors. Error: The 06-2025 financial period of the HIVIS company is closed in Accounts Receivable.”I cannot open the closed period. How do I void these payment records?

Hello Community,I have a concern on migrating cash account balances for cash accounts in foreign currencies. Here is the steps I have taken.The cash accounts are denominated in foreign currencies which makes unable to post transactions in local currencies. Therefore, when migrating the TB via a journal I have set up a clearing account and debited the balance of foreign currency cash account to the clearing account.  Then created another journal in foreign currency to the cash account crediting the clearing account which makes the clearing account balance is zero.Once the migration is done, the clearing account balance become zero. But it keeps showing the debits and credits posted to in the TB. What we can do to this account to make it not visible in the TB. Thanks,Dulanjana 

Hello, Working with my Acumatica test account I ran into some issues with linking payment methods, for this specific example with credit cards, to locations rather than business accounts. For the companies that I am working with they have multiple locations where different buyers purchase for us, and a lot of times they have different shipping addresses and credit cards. This has made it a lot harder to send invoices automatically because I have different emails to send them to, but the business account only holds 1 email. I am curious if anyone had experience with assigning a credit card and email with a specific locations that would allow invoice to only be sent to the information on that location. Or if someone has a better solution I am open to trying them. I know a lot of people have suggested for me to make different business accounts or do parent and child accounts, but that does not really work for retaining CRM the way I would like. I look forward to different

Is there a way to change existing fixed assets to post depreciation to expense accounts without potentially breaking the standard fixed asset functionality.

I have a landed cost document that needs to be paid before product is received, these fees need to be allocated to the cost of the item. But landed cost documents can’t be paid without a PO receipt. Is there a work around that allows me to easily allocate these fees to the unit cost? Thanks!

We’ve used Avalara for quite a few years, and it works well in Acumatica, but the pricing is becoming astronomical with their year over year increases.  Wondering if anyone else has experience with less expensive options for sales tax calculation that integrates easily in Acumatica without custom integration needed.