General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,461 Topics
- 4,853 Replies
We have recently upgraded our client to Acumatica 2023R1. Since the upgrade we have noted that the transactions posted in the GL related to Projects is not accurately reflected with the exchange rates defined in the GL transaction. A transaciton is created and released in the GL to reclass project costs from one project to another, and a specific exchange rate is updated in the transaction. GL Transaction in MYR with the exchange rate override 1MYR = 27.3973 JPYGL transaction in JPY (base currency) at JPY445,590 However, in the Project Transactions, the exchange rate used is the current rate based on the transaction date and post period: This therefore raises a discrepancy for the same transaciton within the GL compared to the Project Balance. Prior to the upgrade, users could update the exchange rates as necessary and the same rate would be used in both the GL and the Project transaciton for each transaction.Please advise if we have missed something. We have turned on Multi-Currency f
Hello - We have found a check at one of our properties “On Hold” from 12-2022 (screenshot 1). When I go to open this check, I get this error message, “Object reference not set to an instance of an object”. I have found this check applied to a Bill, with the status of “Open”, and I cannot delete the bill or clear the application. When I select “Pay”, I get the same error message “Object reference not set to an instance of an object”Additionally, I have found a debit adjustment referenced to this Bill in 09-2023, seemingly attempting to reverse the error. But I am unable to apply the Bill to the Debit Adj, or release it. (screenshot 3 and 4))Does anyone know a workaround so I can find this check and delete it? (A second check had already been cut and paid for the same time period)Thanks! Bill with the Check Applied and the Debit Adj
This article provides information about the Acumatica implementation of 1099-MISC and 1099-NEC tax documents and e-filing options for 2023. Detailed information about these forms is available from the IRS website (1099-MISC, 1099-NEC).Information for Customers who use Pre-Printed FormsForm 1099-MISC, Form 1099-NEC and filing instructions have been converted from an annual revision to continuous use. Therefore, there are no changes in 1099-MISC, 1099-NEC form layout that require changes in the Acumatica ERP. To resolve possible issue with the printing alignment, we encourage you to update to the following Acumatica ERP builds where the paper size of the 1099-NEC (AP653100) report have been changed to Letter:2022 R2 Update 3 (22.203.0043) or later 2022 R1 Update 14 (22.114.0029) or laterFor more info, workaround for earlier builds and additional steps to fix possible alignment issues, refer to the Known issue: The report printed on the 1099-NEC (AP653100) form did not fit the Letter pa
GL Error: Cannot update the record. The record Account (********) has been marked as deleted. Your changes will be lost.
Has anyone encountered this error before?: GL Error: Cannot update the record. The record Account (4000-103) has been marked as deleted. Your changes will be lost. We are working on an implementation for a client and had deleted the “4000-103” numbered account. Acumatica now wont let me recreate the same account #? Is there a specific root cause for this? Anyway to get around this?
Have formatted the excel import file date field to not display the time. When imported into Acumatica, it brings a time stamp. Just need the date, not the time. Have attempted setting the field on import scenario to “=TEXT([column name], “dd-mm,yyyy)”This does not work.Any suggestions?
Hey all, I’m seeing random issues with the bank feed form but I have yet to see this one on here. Figured it’s worth discussing. I’m also opening a case with Acumatica. Just wanted to see if anyone has come across this before. The customer has confirmed that all the credentials are correct despite the error message. “The bank feed service (path: 0/plaid/transactions/get) returned the following server error: one or more of the account IDs is invalid.”Please let me know if you have any information regarding this. Thank you!
Our customer has an executive team that wants to have 2 people approve checks. When they cut checks they want the executive team to approval checks then have another member of the executive team go in and approve checks gain.Is there any way to set this up so that the same person can’t approve checks both times?
Do any UK users have experience of setting up Acumatia to support collection of Direct Debits ?This involves sending an XML file every month to a bank with details of the Direct Debit payments being requested from customers i.e. customers bank details, an amount to be collected, a collection date etc.
Hello all, We work on Import Bank Transaction in 2022 R2, and we try to set up Relevance Calculation in the best manner. As I understand there’s two ways to set up Relevance 1. Cash management preferences 2. Match settings. Help section mention that the Cash Management preferences is the one who get priority if there’s no set up for a particular cash account. As you can see below, we’ve tried to put much off the weight on the amount, but the system doesn’t seem to take it into consideration and we can’t adjust directly in the match settings. How can we have 0 as a relevance if it takes amount in consideration?Is there any way to force him to take it into account? Thanks!
Hi, I created a GL account "999991" in the Parent tenant and attempted to map it to the Consolidation tenant. However, I was unable to locate the corresponding GL account in the Consolidation tenant for mapping purposes.Upon further investigation, I discovered that the Account ID (highlighted in yellow) value differs between the two tenants. Could this discrepancy be the cause of the mapping issue? If so, how can we synchronize the Account ID values to enable mapping between the tenants?
Corrected Question: How can the Trial Balance upload function be used with denominated accounts mixed in with the company’s natural currency accounts? Using V 23.110.0025The company currency is MXN and the parent company is USD. Two separate tenants - parent co in one and Mexican in another tenant so that the Mexican localization can be used. The parent wants one Cash Account in the Mexican company to be USD and the Fixed Asset Accounts to be denominated as well (USD). I'm trying to upload historical balances. If I use all MXN in the YTD balance on the Trial Balance Upload, the cash balance is not correct in the USD Cash Account. If I use USD in the TB upload, the TB does not balance; therefore, won't release. Suggestions besides journal entries with net changes vs the TB upload with YTD balances?
I am getting the below error when trying to delete a customer:Error: Updating 'Address' record raised at least one error. Please review the errors. Error: 'Address Line 1' cannot be empty. Error: 'City' cannot be empty. Error: 'State' cannot be empty. Error: 'Postal Code' cannot be empty. I reviewed all the locations I thought the address could be entered.Thoughts?
Team, our client is trying to do 1099 Reporting without the Credit Card Payments, and i am having such a difficulty to prensent the data to them, I originally was trying to do a Vendor History Summary, but there is no easy way to connect the Payment Method (APPayments) in the tables used for that Report, so, I am trying to present something by combining the APTran and get the AP details that have an 1099 Box not empty, and connect the APPayment table to get the Payment Methods to be filter without the CC payment method. I would appreciate if I can get help with the GI or any other idea to complete this for my client. The attached GI I have APtran, APpayment and APtranPost but still not able to grab all the bills, it would only give me Debit Adjusments.
IN - Inventory Transfer (2 Step) Created and released , However the JE is Unposted and Financials Reported .Can we Reverse it without Posting the JE or Reverse it after posting . as we dont need to include in the period which is already reported What is Best prictice
Altered the Import Scenario for “ACU Import AR Invoices”.Upload file version and Prepare are successful.Import gives error code of “Document” but there are no error codes on the data.“23 items have not been processed successfully. View name: Document.”How do you find the problem?
I can see transactions in my cash account and have the total I expect in the TB, but when I go to reconcile the same cash account I see transactions that I don’t see in the cash account detail and don’t see transactions that I do see in the cash account detail. When I run the reconciliation statement report, the transactions I’m missing show in the uncleared sections. But when I go to continue reconciling I can’t find them. Not a date issue, I’ve cleared all date filters and checked posting and cleared dates. I’ve trashed and restarted this recon a few times, thinking it might be a fluke. Same issue. We’re also on an older version of Acumatica, 2021 I think, with plans to update soon. Could that be causing this issue?
Hello Team,We are trying to implement a workflow in the Customer portal for Opportunity screen (Customized screen). We are aware that the feature of configuring workflow for a screen via Customization editor is not supported in the Customer portal. Hence, we are trying to implement it via code. We are not sure what we are missing, action or states defined don’t seem to reflect on the screen. Any thoughts on what could be the reason? Attaching the code as well, basically we are reusing the existing implementation of Opportunity Workflow.
We generally close our invoicing for a month by the second business day of a month and would ideally like to have Acumatica automatically generate the customer statement on the third business day and send them out. Not sure the best way to handle this. Seem to be able to set up the automation schedule to email the statements on the third business day, but the statement cycles screen that generates the statement only gives the option of selecting a fixed day of the month. The issue with this is that the 1st of a month can start on a weekend and could result in our statements being generated on the 1st business day of the month while we are still finishing our invoicing for the month.
Hi,we would like to show in the details of a sales quote the margin of a product (only for internal use)As have ave not bought the product before the last cost is empty. So the cost is zero. So is it possible to use the vendor price instead for the item cost? And if so, how?
We are a new Acumatica client. We were previously using Quickbooks Enterprise for our accounting. When we imported bank feeds (for ex American Express), we were able to assign the transactions to a particular vendor/business account and to a GL account. It appears that the only way to have a transaction assigned to a particular business account in Acumatica is to make a bill, then match the bank feed transaction to the bill. This is very impractical and time consuming, as we have hundreds of autopay transactions from some vendors in one month. Is there a way to match these transactions to a particular business account without having to create a bill each time? I even tried to assign a business account to an Entry Type and it will not allow me to do so.For example, if XYZ Company auto charges our account daily for multiple transactions, and I download those transaction in the bank feeds, I need be able to assign each of those transactions to XYZ Company (and the associated GL acco
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.