General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,478 Topics
- 4,904 Replies
Hi guys, a question on multicurrency accounting.I transfered 1000 USD from the USD bank account to SGD bank account, I received 1350 SGD and there’s a gain of 1.16 SGD here (base currency is SGD). But in the journal transaction, the realized gain/loss from currency shows 0. Then I checked P&L, it actually shows the right amount of 1.16 gain in the statement. Anyone knows why’s it like that? Could there possibly be anything wrong with the journal transaction? Thanks!
After running customer report, I found discrepancy in Tax code. Part of invoices had taxes included and other part not. Please help me to understand how I can crate adjustment invoices for taxes that needed to be collected.
Hi,Our customer collects prepayments from the same customer for two different purposes. And these two different prepayments, they credit to two ledger accounts in the current practice. How can I post prepayments to two ledger accounts receiving from the same customer. Is there any possible way ? Thanks,Dulanjana
I imported my bank transactions and for the first time I’m trying to create missing transactions directly from the the right side of the screen and created rules for recurring transactions with specific criteria so going forward I won’t have to manually input them as they’re validated and I know what they are. However when I click ‘Process’ it won’t process them because it says the ‘extRefNbr’ cannot be empty. This field gets automatically populated from the bank’s Quickbooks upload file and I can’t modify it. Is there an option I’m missing to allow that field to be null or is there something else I’m doing wrong? Thanks in advance for any help you can provide!
I am wondering how to revalue inventory in ACU. I know I need to use the IN Adjust but still not getting the results I want. I have some items that have correct qty and the incorrect valuation. For these It would just have to remove all of the inventory at system cost, and when I add it back to I use IN Adj or IN receipt? I believe the issue I was having with IN adjust is the costing is tied to the receipt that you choose.We have a few items that have a value by no quantity. I am unable to do a IN adjust with a Qty of zero. The system does not create any transaction. How would I correct these issues?Thanks as always to a great community!
Yesterday our client informed me that there is an issue with using Gmail for sending large volume email-based communications from Acumatica. They were trying to send some 4500 statement emails when they encountered the following Gmail error: Too many login attempts. Please try again later. From my reading up, this error is possibly caused by each statement email sent creating a login attempt to the Gmail account. 2 questions on this:Does Accumatica have a config SMTPKeepAlive, which will allow the already created SMTP connection to be reused (without having to re-login each time)? If it does, is this configuration switched on? Is this an issue you have encountered before with Accumatica, and if so how was it resolved?
We have open prepayment from last year. Check has been cleared from the bank. It looks like the accountant didn’t know how to adjust with bill and they adjusted payment without clearing prepayment. Now I cannot void, the check number linked is reconciled and closed. How can i adjust this prepayment and cleared it from open A/P? Thank you,Shankar
I have a situation where Users create an Invoice and leave this in Balanced Mode, they are then able to print and email the invoice to the customer. Once done they subsequently receive cash payments from the customer, but then go and delete the invoice (because its still in balanced mode). This gives rise to fraud. How can I disable the ability to print or email an invoice in hold or Balanced mode, and only allow for the invoice to be printed / emailed once released into the system?
We have a problem when correcting time cards after they have been approved and released. It appears where we have work items associated with a task we get the error "The Employee Labour Cost Rate has not been found". So we cannot release the card. We don't have this problem if the work item is not associated with a task.Have you come across this before? Any ideas on a solution, please?
I have an AR Credit Memo stuck in a reserved status. It was initially created to process a refund but another AR credit memo was created in its place. The refund was processed and attached to the replacement CM and those two documents are closed.The AR Credit Memo is not applied to anything and all options on the actions, inquiries, and reports menus are grayed out. It is a part of a batch that was posted to the GL which makes me believe that the document was released before it was reserved. Any ideas on how to get this document out of reserved status? Our end goal is to delete it or close it out with a debit memo.
Hi everyone,We’re new to Acumatica and looking to implement an AP workflow that incorporates entering a vendor invoice and saving without posting to the GL i.e. we may need to edit the transaction lines prior to posting. We also need the process not to restrict us closing a period.Would the settings need to be following? Thanks and much appreciated
I’m trying to create an import scenario to reverse some AP Bills. I am getting this error “An error occurred during processing of the field Tax Calculation Mode value N TX Error: The Tax Calculation Mode field can have only the Tax Settings (T) value because the Net/Gross Entry Mode feature is disabled.”
HI, guys. does anyone know how to cancel/terminate a deferral schedule? the deferral schedule linked to a wrong invoice, but has not start the recognition yet? is that possible to terminate the deferral schedule? If I just leave it and create a new deferral schedule, the old one(the wrong invoice) will not be able to link to a new schedule. thanks in advance
We are receiving the error below when trying to Release invoices on the Process Invoices/Memo screen. We’ve tried processing these invoices individually and using Process All and receive the same error. I do not see anything that stands out on the invoices that would be preventing us from releasing these invoices. Any ideas on this error? Screen: Error:
While creating the company I have followed the steps that are mentioned in F100_Financial basics 2022 R1 and I have created company without branches but while coming at the step To Create Cash Accounts in that Step 1 : Creating the Cash Register Account Here while doing this step I got an error of branch id cannot be empty.So how do I fix it?
Hi Now we having the below problem. Not sure if anyone can help to solve it or give any suggestion.For Inbound shipment - We always based on receiving date to book into system instead of invoice date .The standard entry as below as per accumatica entry that receiving inventory into systemDR InventoryCR PO accuredDR PO accuredCR Account Payable. Currently, as our financial cut off date will be on 31 Mar 2021.Which mean we need to book in the inbound shipment as per invoice date for 31 Mar 2021 instead of receiving date . Example: Invoice date : 31 Mar 2021. ETA factory is 3 April 2021. Inventory qty : 1000pcs Value : USD1000We have to enter above invoice on date 31 Mar 2021 , however the inventory is not yet arrived factory yet so we should part under “Goods in transit “ instead of “ Inventory”May i know anyone know how to do this kind of transaction ?
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.