General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,470 Topics
- 4,877 Replies
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?
How can we assist our clients in getting the vendor 1099s updated to include amounts from their previous system prior to their migration to Acumatica?Keep in mind most of our clients will not have access to their old systems, nor will they be able to run the 1099s for 2023 year-end.
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.
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?
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 our third subaccount segment, it’s a product subaccount ideally linked to inventory item.When I create a sales order and sales invoice, I see all 3 subaccounts generated Channel-Customer-product. However, even though the item is invoiced, no issue was created. Usually this is an automatic process but I had to manually look up that issue and when I click release, it has an error, saying Product of subaccount does not exist.I’m not sure where Acumatica pull the subaccount from.Here is the screenshot of the customer and inventory ID subaccount:
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.
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.
We have a client that had an error on their production orders and accidentally applied overhead to all of their outside processes. it was not realized until the production orders were completed (NOT Closed), but there are roughly 1000 production orders that were effected. They tried to do a WIP adjustment to offset the costs, but that was not effective, as it was reversed when the production order was completed. If anyone has any thoughts on how to best remove these, that would be helpful.
I am having a hard time understanding exactly where these costs are coming from and how to adjust.Standard cost sectionPending costs - ???Last cost - ???Current cost????? - where can I update this?? Cost Statistics SectionLast cost - this is the last cost that it was moved into inventory at (looks to be actual cost of materials issued against production order)average Cost - this is the number that I just entered under Item warehouse Details, then rant updated standard costsmin/ max - looks to be actual cost from production orders my questions are 1. - how come EVERY time I update cost on the warehouse details, it automatically goes back to what I just updated it from? 7.67. updated to 8.30 and now it looks to be going back to 7.67 tomorrow- where and how do I update current Cost. what is this number and where is it used? when I update standard costs, why does it go to the average cost, vs the standard cost last cost?am I missing something??? thank you!
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
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?
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?
HiI want to discuss/ask questions regarding fully depreciated assets:Scenario: I am in the middle of a financial year and an asset on SL or RV method reaches fully depreciated status. At year end Audit the auditors tell me that this assets needs to live for another 2 years.I now have to get it active again and adjust the accumulated depr and let it carry on for another 2 years.At the moment I cannot do that in Acumatica. Why is that? what is the logic behind preventing us from making a fully depreciated asset Active again.
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?
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.