General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,089 Topics
- 3,626 Replies
HiAm trying to configure automation schedule to prepare and email statements to my client, the statement cycle set up for all the customers in the client system is end of financial period but he wants the system to prepare and email statements by end of month(EOM), is it possible configure the same as per his demands? Regards
Australian Diminishing Value Depreciation method
Hi, We are trying to use Australian Diminishing Value in Fixed Assets, however system forces us to use ‘useful Life Year’.This method is only capturing the place-in-service date, the cost and the percentage per year.So it does not make sense to have years against each asset, as it’ll change the method. Can someone assist and let me know how you imported your assets using this method? Thanks,Foujan
Recurring entry for monthly loan payments where principal and interest distributions determined from amortization schedule
Situation - a business has a long term loan, a mortgage loan, where the monthly payment is fixed and the split between principal and interest varies each month based on the mortgage amortization schedule. The monthly loan payments to the lender are set up to be made via PAD direct from the company bank account.I can create the first monthly mortgage payment as a journal transaction and then create a recurring transaction from the journal transaction. Generate recurring transactions will create the monthly payment journal transactions, but only the 1st payment will be correct. The finance user will need to edit the 2nd and future journal transactions and correct the principal and interest distribution amounts manually, according to the amounts from the amortization schedule.Is there a better way to configure this?I suppose the Balanced 1st journal transaction could be exported to Excel and the future monthly payment transactions be added into the Excel sheet with the correct split betw
An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.
I’m trying to delete a void payment that is in a balanced status but I receive the below error.An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details. How can I delete the voided payment?
Sales tax report setup questions
Hello,I am working on my first sales tax report and i can’t get the report the way I need it. We are on 2022R2 with fast track implementation.We are setup to have zones that pay multiple rates. Base MN 6.875 plus county of .25%. On the report the tax amount due is correct, but the taxable amount is doubled up and broke into multiple groups.. I need to report the taxable amount for each group. 8k to state @6.87% and 8k@.25% to the counties. and the state website calculates the tax amount due (which it should match) I have tried multiple settings and groups, but can’t get the settings quite right. Thanks,Jeremy
Bank Reconciliation by using other currencies.
Hi All,I need to do a bank reconciliation for EURO currency. But my base currency is USD. Could you please let me know that should I convert my EURO figures to USD before import my bank statement to the system or system automatically converts it. Thank you
2022 R2 build Multiple Generic Inquiries Error: incorrect syntax n ear '1000'. Incorrect syntax near ')'.
I installed the 2022 R2 build on my local Demo install and we also have it in an upgrade sandbox we are testing. I have several Generic Inquiries that came with Acumatica that all have similar errors.Error: incorrect syntax n ear '1000'. Incorrect syntax near ')'.Reclassifications by Period Unprocessed GL Transactions with High Scores Open Anomalies by ConfidenceWhat needs to be done to get these errors to go away? Is something not enabled that should be with this new release?
Closed financial periods still aloowing posting
My customer recently upgraded to v2022 R2. They are attempting to close financial periods but have noticed that even though the financial period is closed they are still able to post transactions to the closed period. This was not an issue prior to their upgrade. Is this a known issue?
My Cash Account doesn't balance to my GL financial period
I have experienced 2 situations recently where the cash account balance might not match the GL at a given date. Here is how I reconciled them. Not all GL transactions are in the cash account:This can happen if the cash account was opened after transactions have been posted to a given GL bank account. Unlike other re-balance account screens, the Banking » Processes » Recalculate Account Balance will actually add missing GL transactions to Cash Account that are in the GL but not the cash account. This is not very well explained in Acumatica Open University but I discovered on a recent ticket to Acumatica. To take advantage of this solution, rebalance the cash account as of the oldest financial period available.Transaction dates don’t match Financial period.Acumatica let’s you override the financial period after entering a transaction date. Bank reconciliation runs on transactional date but the GL runs on Financial Period. I had a client post many (read millions of dollars) to the cu
Trouble with Expense Receipt - AP Subaccount Cannot Be Empty
Hello, We are experiencing an issue when attempting to release an expense claim in the system. Everything to me appears to be filled out correctly, but we get the following error when trying to release the claim. Here is a screenshot of the Trace Log that basically just shows the same thing. From the first screenshot, it looks like the Expense account and subaccount are filled in correctly. And I’ve compared this claim to others that have been able to release. Any ideas why this one won’t go through?
Stop previous day changes
I am looking for suggestions on how to prevent previous day postings. I do daily reconciliations of sales and COGS accounts. Everyday I am having to go back and do each day because there are changes and my numbers are no longer balanced. This has become very cumbersome to manage. Is there a setup that we are missing to stop the constant changes?
Already have an account? Login
Social LoginLogin with your Acumatica account
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.