Financials

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 manually handled exceptionsSet the Vendor record to allow Bills prior to Receipt and create the Bill in Acumatica from the 810 and have it sit there to wai

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 reconciliations)?Any examples or lessons learned would be greatly appreciated.

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 suggestions and

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.

Good morning community,We are fairly new to the system and our data was transferred from Quickbooks. I have locations on accounts with different emails to send invoices to various departments. How do I assign emails to different locations instead of the main email address on the bill to.

I can create a percentage of individual wages accounts to be shown as a % of Total Sales. However, my client wants the calculations to be different based on different areas and Im not sure if this can be done.For Example, we have 5 wages accounts and 3 Sales Accounts.Wages Regular  to be shown as a % of the  Sales Regular accountWages Casual  to be shown as a % of the Sales Casual AccountWages Supervisor, Wages Manager, Wages Clerical to be shown as a percentage of total sales. The accounts change throughout the report.  Is there a mechanism to do this within the ARM reports.I have tried using rowcode and baserowcode calculations but only get to a certain point.Any indications of how this should be setup would be most appreciated.Thanking you 

I have a warning message on the customer master but we don’t use dunning. How do I turn this off?Thanks 

I need to know how to close a AP Bill that has already been paid and closed, but reopened due to its Account being reclassified. I have listed the full process the Bill went through below.Billed Entered Approved Released Paid in full by a check, closing the Bill Bill was then reclassed using “Reclassify Bill” functions and specifically the Account was changed during the reclassification.The bill is still linked to the check and it shows that it was paid and the amount paid, but is in open status.The check that it is tied to still shows the full amount as well 

Hello,I have an AP Bill that I was trying to reclass. When I initiated the reclass and attempted to ‘release’ the bill, I received an error message ‘Updating the ‘PMRegister record failed because data in some field is too long’ (screenshot is below)How can I shorten the description so that I can release the bill?Thank you.