Financials

We have recently started with Acumatica and had all of our information from our previous system ported over, however the checks were not included.  For context we never used the previous system to reconcile our bank statements.  We exported our information on to an excel sheet and did it there.  We made the necessary JE’s into the system as needed to balance, therefore all of the checks on that system were never marked as having been cleared individually.  So I know that for that reason porting them over would have been a gargantuan task! I will be using Acumatica for our reconciliation and know how do use it. What I don’t know is how to clear out the previous checks that are now clearing?  Because everything that was ported over was in our GL, I’m not sure what to do? Any help is greatly appreciated! 😊

Is there a way to turn off Auto application of Credit memos in accounts receivable?I want to be able to choose what credits get applied to what invoices so the customer and I are on the same page.  I can do this by un-applying the credits, but this is making more lines than necessary and extra steps to the process.

Hi,We're having a hard time viewing the Inventory Transaction History report because it only shows invoices that have been invoiced and shipped items aren't showing up. Is there any way I can see them?Thank you.

Hi,We entered the wrong date on the Transfer Receipt. How can I revoke it? Thanks!

Hi!Does anybody know why its not possible to select a credit or debit memo when the Reverse and Apply to Memo action is selected in a Receivable Invoice? The user case is that I need to increase the amount of the original invoice to increse the outstanding balance of a customer and to do that a Debit Memo should be createdThanks!

Hi guys, I’ve configured my company with the type of “with branches requiring balancing”, as this is supposed to be the setting that allows each branch to have its own financial statements. But how can I generate BS and P&L report based on different branches? Here I could only choose a ledger.Besides, is there any reports based on different subaccounts? If I use subaccounts to reflect departments and I want to see how much income every department generates, how should I do that? Thanks! 

I am a relatively new Acumatica user and have a question. I am wanting to set up “PLanned Start” and “Planned End” dates to match an overall Project schedule. I will then set up a Task that is tied to a Project Task that’s schedule matches the budget for that project task. ex: A cost collector project task is budgeted for 80 hours. I would assign a task to an employee that spans two work weeks in the start and due date fields of the task. So far, all of that works great. The ISSUE:On a Task that will take several days/weeks to complete will not allow an employee to submit a time card that includes task work items on a task that is not yet completed. What can be done about that? Is there a setting I need to change? Thanks! 

We have some instances where a client entered an invoice for a vendor. Let’s say it is $50. But the amount that ended up being paid was $60. In the process bank transactions window, this amount that shows is the $60. The invoice is still only for $50. We would like to match to the invoice and then just create a cash transaction for the remaining $10. Would anyone know how to do this? Or if there is a better process? 

Hello,I’m setting up Sales Tax Reporting and I’m getting weird results in the Calculations… possibly human error. Grand Total Lines seem to be adding themselves to other totals, sometimes twice.In this case, it’s not possible for me to use line 13 (a total, not a group) in another total in the Grouping screen. How did it get included in Calculation Rule? What am I doing wrong? Version 2022 R1.Here are my Reporting Groups. I expect group 8 to be in 4 calculations (total lines 12, 13, 14, 15) and 13, 14 to not be used in Calculation Rule column:Thank you in advance for your advice!

Hello,Having an issue with the dunning levels not updating based on days past due. In “Prepare Dunning Letters” list, each customer is at level one despite some being 120 days+ past due. I have the levels specified under the AR preferences dunning tab. Any idea why levels aren't updating? Thanks in advanced!  

Since we upgraded to 2021R2 Build 21.211.0033 and also now to 2022R2 we get an error when we UNMATCH ALL and SAVE in Process Bank Transactions. Is there anyone else who has also experienced this error?The only why now to Unmatch is if I go line by line to and Unmatch. On my Cash Account for the bank in question all my Entry Types are linked to a Tax Zone. I even created ZZZ - No tax line, just to have a value in the field.    

Hi, I’ve been trying to set up a dunning fee for dunning letters. The following is the dunning setup: Then I prepare the letter and prepare to release it: But when I release it the fee reference number is not generated and there is not dunning fee invoice either: Am I making a mistake somewhere causing the dunning fee to not be created?Side note: Are dunning fees always fixed price? Are there other options for calculating the fee, say based on a percentage of the amount overdue?Any help and insight will be deeply appreciated, thanks.

CIBC Bank has (IMHO) an odd setup for ACH files.  Instead of a 9-digit EIN number they use a 10-digit value that prefaces the EIN with the Letter P.  We’re working on how to configure this with the ACH setup but I wanted to know if anyone has a correctly functioning ACH setup that works for CIBC. If so, I would love to have the Export Scenario and Export Provider XML files.

Client would like to be able to have his projects go through an approval process if it has been moved from suspended to active.  We were not able to to find anything other than writing some code with a custom action.  Does anyone have any other ideas?Client is currently on 2021R1 but testing for 2022R1 upgrade

There was a topic from about 5 years ago that verified that Acumatica is not compatible with Tier 3 credit card processing using the Authorize.net option.  Is this still the case?  If Acumatica does support Tier 3 processing through Authorize.net, does entering a new card from the mobile app also support Tier 3 processing? Thanks in advance,Scott

Hi, I’ve been trying to set up a dunning fee for dunning letters. The following is the dunning setup: Then I prepare the letter and prepare to release it: But when I release it the fee reference number is not generated and there is not dunning fee invoice either: Am I making a mistake somewhere causing the dunning fee to not be created?Side note: Are dunning fees always fixed price? Are there other options for calculating the fee, say based on a percentage of the amount overdue?Any help and insight will be deeply appreciated, thanks. 

Hi,Is it possible to process an Invoice with multiple payments in 1 entry or without creating multiple Payments? Let say I have an open Invoice worth 12,000 and customer will pay in advance through 6 Post Dated Checks (the date is every 6th of the month). How can I record those 6 checks in Acumatica?Thanks in Advance.

Is there a way to “hide” the vendor tax ID after it is entered?  

Hi, everyone,I have error when y create a new Fixed Asset, I trate to explainWhen enter receipt date “12/12/2017” and in te field Placed-in-service date “01/12/2022”i have a error Asset will be depreciated from 01/12/2018 to 12/31/2027, book 'FIN' does not have financial periods generated from 2018 to 2027. You need to go to 'Generate FA Calendars' screen and generate financial periods before changing this asset. has it happened to someone?the periods has ben created! thanks

Does anyone use barcode scanning for issuing inventory items?Does anyone use barcode scanning for month-end inventory?

When we go to create an AP bill and error comes up because the project does not match. This was not an issue until we did the update. Does anyone have a work around so we can get vendors paid? Acumatica is saying it is a bug in the update and they do not have a fix for it yet… Hoping someone had this same issue because we can’t create any AP bills and it is not only affecting paying our vendors but also being able to bill our customers. 

I am trying to create an export for customer locations.  on the export scenario, I have  Source Object as Location Summary, Field / Action Name of Customer, target field / Value of =Every. customer mapped to customer id. Location ID mapped to location.  I do not get all customer/locations on my export.  The number of lines that exports is the number of customers only,  I am missing hundreds of other customers which has multiple locations.  Please advise

Are there ways to un-release a bank reconciliation statement released with an incorrect date? The incorrect date does not allow pre-dating subsequent reconciliations. Any help will be much appreciated. Thanks.

Does anyone else have their business event not fully creating extra long ACH Remittance reports before creating the email?This only happens to one of my vendors report which typically runs 7-17 pages long. None of the other vendors have an issue (they are only 1-2 pages long).Is there an underlying processing time, line, or page limit on the Process payments / print checks screen?

Hi All,Is there a way to extract all invoices in a project with cost codes included?  I’m able to drill-down to each bill individually and see the cost code for that invoice, however, I’m wondering if these can pulled in bulk for a project.  All help is appreciated