Financials

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! 

Hi,In case the employee needs to get some cash in advance to go perform a job. how this works in Acumatica if we will know how the money was used after the fact and we need to track it in the system? Thank you 

Hi I would like make some Profit and Loss report (DPL)  figure in Dashboard for easy reference. example: revenue , gross profit , net profit.  Not sure who can share with me how to extract the figure to dashboard?  

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?

For internal control purposes, how to restrict certain users from having access to “release” button for journal entries and have all JE release thru specific user only?Thanks ahead. Regards,Aaren

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.”

The translated values in one company are using Account Ending Balances to apply the exchange rate for translation.Is it possible to apply the exchange rate to the Period Turnover amounts, rather than end balance?

How can we apply open prepayment with vendor bill? How can we adjust open prepayment created by mistake?  Appreciate your help. 

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? 

If invoice is for 299.98 and payment was processed for 299.99; how can we adjust 0.01 in AR? 

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 ?  

Hello,   We are adding a second company on to our current working Payroll setup for our main company.  When trying to run Payroll on this new company an error is coming up stating “The Batch is out of balance, please review” for which a large/cryptic trace has a lot of info that does not seem to point in the right direction.  Anyone with Payroll experience have any clues as to where we could look to solve this issue?  The batch does not appear to be out of balance to us:  

Hello Acumatica Community,  Looking for some help building a generic inquiry that will track all customer discrepancies. Basically, I want to group a report together by customer that will list out all the customers who have a value in the discrepancy field on the Customer Details screen. As you notice, Acumatica only displays this by clicking into each customer, looking for a list of all customers with discrepancies.  Here is my issue… The Balance Discrepancy is being displayed by a “Filter” table which as far as I know cannot be used on a GI.   My second thought was to use the detail of the report to calculate the discrepancy. The Balance Discrepancy is calculated by the following formula; Balance by Document - Current Balance. The problem with this is that since I can’t use the “Filter” table to

It would be useful to be able to add financial reports to dashboards.  It is a feature I have seen elsewhere and for finance people this is very useful.

Hi All, I have select wrong fixed asset in convert purchase to asset. How can I reverse it? I try to create FA Transaction with transaction type purchase + with negative amount, and it FA Accrual is on debit and asset is on credit (batch nbr FA000155), the asset balance is deducted but it showing error on fixed asset reconciliation tab “The current cost of the 00000026 fixed asset and its unreconciled amount must have the same sign.” and in the convert purchase to asset is not showing the journal of batch nbr FA000155).fa adjustment purchase + with negative amounterror info reconciliation