Financials

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?

Good day Team,Our client is requesting to a Code 647 instead of the 627 Code for the offset line that the system do when you create click the Offset option on the PlugIn This line produces a offset debit line for the NACHA ACH File that starts with 627 I am trying to modify this to show a 47 instead of a 27. Does anyone has have luck doing this? I do have a case with Acumatica support, but I wanted to see if anyone had to do a similar change.

Hi community,We generated an invoice that is currently in Open status, but it has NOT been fiscally stamped (No Timbrado) yet.One detail line was missing its Tax Category (IVA16), so total tax was undercalculated. Since the invoice is already released, lines are read-only.Under the Corrections menu, we see Correct Invoice and Cancel Invoice. What is the recommended standard practice to re-issue or edit the tax on this document prior to CFDI stamping?Thanks in advance for your guidance!

Hello all,The requirement is to have a batch payment process that supports filtering by customer/vendor and date, along with manual invoice selection for both incoming customer payments and outgoing supplier payments, rather than automatically applying payments to all outstanding invoices.Is this setup possible. I know customization would be my last option, still wanted to hear out suggestions, if someone might have implemented.

trying to input sales tax on prepayment invoice. i know prepayment workflow is primarily built for VAT. it is not allowing us to calculate sales tax automatically as usual due to this. is everyone’s work around just making a SALES TAX non-stock or is there something i need to turn on in order for Acumatica to allow sales tax to work like normal?

When creating an AP bill directly from the Purchase receipts screen, then click ADD PO Receipt Line to add additional PO receipt lines to the same bill, some eligible receipts are not displayed.However, when we create the AP bill directly from the Bills and Adjustments screen, select the same vendor, and then ADD PO Receipt Line, all received PO receipt lines are available.Could someone please clarify why the available receipt lines differ between these two methods and whether there is a setting or process we need to follow to ensure all applicable receipts appear on the AP bill?

Hi all,Does anyone have any knowledge or experience with being able to have one “parent” customer with multiple bill to’s?  We use the locations for having multiple ship to locations but am looking to be able to link multiple Bill To’s to one customer number.

My FA team report the different about sub account of Credit Memo and Oriinal Invoice.they using Invoice Correction to generate that Memo. i have  try to identify, and i found that subaccount for the Memo same with  SO Subaccount  for the Original invoice.Is there any configuration that needs to be done so that the Credit memo subaccount is the same as the Original Invoice subaccount? thanks for helping me.

Hi everyone,We’re hitting a small snag with rounding in our setup and would love some advice!Our system is set to 2 decimal places, but a few of our vendors use unit prices with 4 decimals. Because of this, the total amount (ext. cost) gets slightly off when we generate Bills and Receipts compared to the original PO.Here’s what we’re doing right now: Vendor Bill: We can manually tweak the total so it matches the vendor's invoice fine. Receipt: It pulls the total directly from the PO and won't let us edit it. This leaves us with a small inventory value difference. Has anyone run into this before? What's the best way or workarounds to fix or balance this out on the Receipt side?Thanks in advance for any tips!

has anyone been able to use the decision wait time on approval maps?What happens when the decision wait time expires what happens to the pending transaction?I set my wait time for 10 minutes and nothing happened, I was still able to approve it after the ten minutes.Do i need to set something else up?

Hi, I have a customer that wants to expense depreciation to multiple subaccounts when depreciation is calculated and released.  The only way I know how to do this is by creating an allocation in the financial module to allocate the expenses to the correct subaccounts. Has anyone else know of another way to allocate the expenses to the proper subaccounts, the customer is not on board with the allocation method. Thanks,Coleen

Customer does not have the Deferred Revenue module.Does anyone know of a way to accomplish the following scenario:Invoice customer for sold item and install is also invoice up front. The install credits a deferred revenue account rather than revenue When the install is complete, via a Field Service invoice, we need to debit the deferred revenue account and credit revenue- therefore recognizing the revenue when the service is comlete.Thank you for any input you can provide.

Hi All,Looking for some guidance on a drop‑ship correction scenario in Acumatica 2025 R1.We accidentally created a Drop‑Ship PO linked to a Sales Order (SO), but the intention was to create a regular stocking PO. To unwind this mistake, a user processed:A Drop‑Ship PO Receipt (released) And then a Drop‑Ship PO Return (also released)These two transactions fully offset each other financially.The PO is now in Closed status.However, the Sales Order is stuck.Here is the sequence:The SO originally auto‑completed because the PO receipt was released I used Reopen Order After reopening, the SO went into Back Order status All lines have Open Qty = 0 The SO still shows POSource = Drop‑Ship Unchecking PO Linked does NOT remove the linkage "Cancel Order" fails with:“The sales order cannot be canceled because some items have been shipped.”There is no option to Close Order in the Actions menu The SO item is Non‑Stock, which limits inventory correction options Drop‑Ship PO only had one line — the SO h

Hello,I am trying to consolidate/combine Invoices for multiple Sales Orders through “Process Orders” screen. The Sales Order Type is of template Type “IN” that does not require Shipments.Important to note that Avalara is the Tax Provider. This functionality out of the box works fine when I don’t have Tax Zones. In other words, if there no Avalara involved, the Invoices are being consolidated through “Process Orders” screen. However, when I apply the Tax Zone Avalara, the system is creating separate Invoices for each Sales Orders. Note: Each Sales Order has different Ship-To Address. I believe this is the reason. Has anyone faced this issue? Any advise will be very helpful!Thanks! 

Does Acumatica allow for singular invoices per Shipment? When I attempt to process shipments, the step of creating invoices based upon a shipment, consolidates all shipments that are confirmed for a customer (different shipment numbers and different order numbers) into one single invoice. How do I avoid this? Below you can see where the system is creating one large invoice for customer TEST90, although it covers 4 different shipments and 4 different orders. I would need the system to create one invoice per shipment.  

Hey, gang - short of a customization is there any way to default the Payment Method and Cash Account fields based on the selected branch on the Process Payments / Print Checks screen (AP505000)?  Curious what ideas anyone here may have.   

In 2026 R1 on the Bill and Adjustments screen, the project entered on line one defaults to the project field on subsequent lines.  We expect an ‘X’ to default like in 2024 R1.  Is this new functionality or a bug?  Thanks for comments.

Hi Everyone,I got an error message “AP Error: the next check number value cannot be incremented because the last possible value of the sequence has been reached” preventing check printing. How can I increase the limit?Thank you. 

In Payments in Application the Withholding Tax Tab seems missing in the modern UI while in the classic it is visible. I also tried to check the screen configuration but still the tab is missing. Is there any work around that is required or it is a system limitation for the modern ui? or is it already fix in later version?please see attached files   

Hello all,I would like to understand if we can categorise the subaccounts based on the GL A/c that would be selected at the time of creating a transaction.So if I have a GL A/c = “Fees” and I have a range of subaccounts = “Accounting Fees”, “Legal Fees”, etc. so it should only allow the user to select the subaccounts mapped to Fees GL A/c codes only & not of any other.Kindly share your suggestions.

How can you see what the Project Accountant role actually provides access to?We would like to allow some users to use the ‘Reclassify Bill’ feature in AP, without giving them the ability to post costs to closed Projects.

Has the functionality of the Expense Claim screen changed?  Our accounting admin was previously able to place another user’s expense claim on Hold and/or Release it all right from the expense claim screen.  But now it seems that only the creator, claimer, or a delegate can place it on hold.  And the release button has disappeared.Has anyone else seen this change?  She has admin permissions and she is above everyone in the company tree. But she still is unable to correct or release a claim from the claim screen.  She can only release it from the “Release Expense Claim” screen which is time consuming to and difficult to flip back and forth.

All,We are looking to apply finance charges to all past due invoices of 60+ days.Following are our steps from Calculate Overdue Charges:> Select Statement Cycle, date, etc.> Calculate> Uncheck box for all transactions> Filter to overdue days of 60+> Check boxes (selecting only those transactions to apply the finance charge)> Select ‘process’ not ‘process all’Acumatica is creating finance charges for ‘all’ documents and not to only the filtered values.Is there an alternate solve for this?

Hello all! Since switching to the new upgrade a couple months ago, I’ve noticed there are far more issues with the intercompany dashboards loading. Meaning, when attempting to change the company I’m working in and switch to a new company, the selection doesn’t take. If I’m not paying super close attention this leads to incorrect bills being charged to the incorrect company. For example, I wanted to create an AP Bill for Vermeer High Plains today. It was a bill for a company we refer to as “CSL”. I switched to that company, or at least I thought I did. Because the Vermeer High Plains vendor exists for all our companies, the bill went through for the wrong company. I hope this makes sense.  In any case, I’ve noticed a significant increase in this happening along with the system having a hard time recognizing when switching between various modules. Such as switching from Receivables to Finance. I’ll make the selection, but it will take me back to the original screen I started on.  Has any

As i was releasing tax report this error popped up. see attached