Financials

I have set up multi calendar on the same tenant now I want to consolidate. I have India company with calendar from April to March and UK parent company, with January to December. when I try to consolidate there is a period mismatch. how do I map the posting periods of India to that of UK, for consolidation purpose. 

We have an invoice from 2022 with a small negative balance that we would simply like to do away with in any manner possible. Since it is from 2022, write offs, credit memos have not worked. Now just looking for suggestions on how to just get rid of it, if possible. Thanks!   

I have set up bank rules for a range of different transactions. When processing these transactions, I always get a 1 cent variance due to the tax calculation. Is there a way to automatically apply a rounding account? 

Just a quick question asking about the best way to process a failed vendor payment from the bank when matching payments.We have voided the failed payments as we were shown but need to know do we still remove that payment from the payment batch so it can be reconciled?  And, then what do we do with the new receipt from the bank that is the return of the failed payment?  Do we just create a transaction in the matching payments screen and then journal that back to the bank when done to make sure the balances match?

When we apply invoices to Prepayments, we expect that the cash account would be debited, and our suspense account would be credited.  We are new to Acumatica and all of our knowledge on what should happen is based on the system we are moving from soon.  Any feedback would be greatly appreciated. 

How can a Calendar Fiscal Year be changed to a Non-Standard Fiscal Year?

I’m looking for ideas on a simple way to manage royalty fees that we will owe to a 3rd party licensing agent for stock items we are purchasing from a vendor (a separate entity from the licensing agent). Ideally these costs would be added to the inventory asset value but also generate an accounts payable due to the third party anytime the inventory item is received. We do this in other cases, but in those situations the licensor is supplying us with a royalty tag that is applied to the stock item and we’re using manufacturing to assemble a new stock item from the item we purchase and the royalty tagIn this new situation, the vendor we purchase the stock item from will apply the royalty tag on our behalf, but we need the liability costs to hit our AP as soon as the goods are received.  I believe we might be able to use landed costs, although that is somewhat complex to manage and I’m not sure it would automate the AP upon receipt. We could also dummy this by following the production work

We have a consolidation company which has a different calendar to the master calendar. When running the allocations for the branches in this company, the allocation process is using the master calendar and not the company calendar.For example: The company calendar period 01-2024 is the period 10-2023 in the master calendar. If the allocation is run for the period 01-2024, the batch period created from the allocation is  04-2024.When running these allocations one needs to use the master calendar relating to the company calendar: i.e. for period 01-2024 in the company, the period selected when running the allocation needs to be 12-2023.Is there a setting where one can specify which financial calendar should be used for the allocations in the selected company?

What user role is needed to create templates in Payroll? My employee is receiving an error message that says You have insufficient rights to access the object (AUTemplateController)I understand where to add them but I am not sure which role . Their current roles are AR-Accounts Receivable, AR Clerk-Access to AR functions, AR Viewer-Read only access to AR Functions and Viewer   

What is the best way to handle this scenario using ACUpayOrder create and Card payment was entered, and authorized for the full order amount of order  The item was shipped in two shipments (qty 24 on the first, and 16 on the second), generating two invoices.  When the first shipment invoiced, it captured the amount of that shipment and closed out the payment.  When the second shipment invoiced, it did so as an AR balance on the customer because the payment was closed. 

I want to bulk print the official receiprts (Receivable). Is there any such function? 

Is there any way to prevent customer discounts from affecting credit memos? We want to create credit memos without the discounts.

Remittance Tab Bill pay section has numbers defaulted in it which is not allowing me to change. Trying to delete or use backspace not numbers won't change. This is the cash account. 

Looking for tips to get our final “Release Retention” to create only a single final invoice.  Right now the system is looking at the Unreleased Retention on all previous Project Invoices and creating an Invoice for each one.  Wondering if this is a setting issue or a process issue?  Here you see it creates two separate invoices  

Hi Team,I just want to confirm is there a possible way to add a vertical line between data in ARM Report? 

We receive payments from vendors on warranty work that we perform.  The warranty “claim” is created as a Purchase Receipt “Return” record.  When we receive an AP credit from a vendor, it is applied against the return receipt and we can then use that credit to pay other invoices from the vendor.We have two vendors that insist on cutting us checks for the warranty payments rather than an AP credit.  The checks come into our lockbox and are processed by our AR team.  It’s a complicated “throw everything over the wall” process to take this payment and ultimately apply it to the warranty claim.I’m wondering if there is a way that I could extend the business account for these vendors as a customer record as well.  AR is very familiar with creating payments for customers (and the lockbox module can do it automatically).  I’m sure I could do it with a combination of customer and vendor documents hitting a clearing account, but I’m wondering if the system already can see “Vendor ABC is a custom

During 2024R1 launch it was demoed an option to Offset AP and AR Documents.  Was this included on 2024R1 version?  If so, what are the steps to make it active?Image from 2024R1 launch presentation. 

Trying to create cash basis P&L in Acumatica.  Has any one been able to do this without using a 3rd party add on? 

I have a client with 1 Company (With Branches Requiring Balancing) setup in Acumatica and have around 20 Branches in it. The client's new requirement is to establish an additional company and transfer certain branches from the existing company to this newly created one. This is necessary in order to facilitate the submission of Group VAT for specific branches located in the UK. Since these branches have existing transactions, the ability to switch and select a different company on the Branch screen is disabled. Is there a way to reassign the branches to the new company? Regards 

 Hello - does anyone know of a way to only produce month end AR statements that include invoices that are 30+ days old? If everything for a customer is current, don't even produce a statement. And/Or if there are invoices past due, leave off anything that is current. Thanks

In Finance → Manage Financial Periods, can I close month one of the new fiscal year if month 13 of the prior year is still open?

I am trying to close financial periods in Finance → Manage Financial Periods.  I am unable to close September due to an open A/R credit.  Is there any way to process the closing of this month prior to the credit being used/applied?

I have an bill that has an unreleased retainage. When you look at this original bill the rounding diff is 0. Once I release the retainage which creates a new bill it now shows up with a rounding diff. The problem here is that although I can execute payment, the retainage bill stays open because of this rounding diff. And consequently by having the retainage bill open the original bill also stays open even though the full amount has been paid. How can I work around this? Retainage BillOriginal BillOriginal Bill 

How do you adjust total accumulated depreciation for an existing asset.  Our tax auditors are constantly changing the depreciation method at year end.  We get a depreciation schedule for the next year.