General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,089 Topics
- 3,626 Replies
Excel Cannot Open the File " File Format or File Extension is not valid"
Hi Acumatica,Seeking your assistance to figure out the reason behind this error,Upon generating a report into excel file, The generated file has 0 bytesand when opening the file the excel give as this king of error, May we know the cause of this error?Thanks!
Balance sheet line contains data from another ledger
I am trying to understand how the Balance Sheet works on Acumatica so I can reproduce it in my integration project. From my understanding, Balance Sheets are generated based on a Ledger. However, it appears that the Inventories account in the Balance Sheet below contains data that has been posted to a different Ledger.This Balance Sheet was generated using the T100 demo data, using the ACTUALSOFT Ledger. Inventories amount of 440,480. In addition, I am not sure why this Balance Sheet does not balance. The Journal Transaction that I am confused about is shown below.As you can see, this journal was posted to the ACTUALCOMP Ledger, and not the ACTUALSOFT Ledger which I used to generate my Balance Sheet. However, it is still present in my Balance Sheet. You can see the calculation for the Inventories account below to see that it includes that transaction.419,000 + 21,480 = 440,480 -- the amount shown in the Balance Sheet Why is this transaction, that has been posted to a different ledger,
Unposted GL Transactions
Does anyone know why journal transactions from the AR Module wouldn’t automatically post to the GL if it’s set up to do so? We have noticed that 3,666 transactions from a one week period in December have not posted to the GL. I’m relatively new to the position and at a loss as to why this would have happened. Any help is greatly appreciated!
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
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
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?
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
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
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
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?
Shipping order to a company, but Invoice to the company-owned leasing company
Hi everybody,our customer rents out heavy machinery and it regularly happens that he receives a sales order from a daughter company of a big client. Our client then creates the shipping order and ships out the item to the daughter company.At the end of the billing period, our client has to create the invoice NOT for the daughter company, but to a specified leasing/financial company (also owned by the big client).One way would be to just change the billing address, but that is not what our client wants (for various reasons).Is there any possibility to do that in Acumatica without a customization?Thank you for your help!
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
Trial Balance Report- Bringing in 12th Period of Prior Year
I’ve been trying to build a subreport (basically a copy of the trial balance report) that would pull the 12th period ending balances for each account and pass that value to the standard Trial Balance. I can get the subreport to show values if I run it directly but the value never shows on the original. Am I missing something or is there an inherent problem with trying to get this value into the same report? I’ve attached the report (GL632EMS) and subreport (GL632e99) to this topic. If anyone can point to me what my issue is I much appreciate the assist!
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.