Financials

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 

What are best practices for closing financial periods? I went to “processes » close financial periods”  but  we were able to still post in 2021.  Having an issue with too many transaction still slipping through the cracks in periods that need to be closed and just wondering what a best practice is to cut this off? 

hi, currently our salespeople receive commission on paid invoices only so we are using the payment option to calculate commission. However, if a customer is a discount customer and gets a discount if they pay in a certain amount of days, Acumatica is giving the salesperson commission on the discounted amount.ex: if the sale is for $1,000.00, discount is $10.00, the salesperson should be getting commission on the $1,000 but instead is getting commission on the $990.does anyone know how i can change this or work around this so the salesperson gets the correct commission amount on the full sale?  

Hi all, How do I fix this error when encoding of customer. At first, I was able to encode the details of customer, but in the past few days, it suddenly got an error and I don’t know what happen. I’ve already checked in numbering sequence module and the sequence are correct List of customer in branch of CUB 

The AP Aging report is created to run based on the Document Date (Bill/Invoice Date)  which at the end of the month leaves our AP out of balance with the General Ledger.  We have some bills that are dated for the end of one month, but not entered into Acumatica until the beginning of the next month.  I understand that the invoice date is important as this indicates when the bill is due so I don’t want to change that.  But is there any way to run the aging report on a transaction date (date that the bill was entered) as opposed to the invoice date so that our AP Aging report and General Ledger will balance?

Hi Team, I have a query on how the financial data from the legacy system can be migrated into Acumatica. Could you help on this topic. Basically, we would update the financial statements balances as an opening balance from the legacy system to acumatica tenant. Which includes Open AR, AP, cash balance, Fixed assets, inventories, GL balance(TB balance). Awaiting for your response. Thanks in advance,Nithya

I am looking for a way to have widget showing accumulated sales figure over time, something like this:  I use Account Details as data and kind of works, however I can only use one account instead range because there are several sales accounts.  Appreciate if anyone can assist.

Hi, I was run a vendor AP balance report and noticed that when my accountant did the reconcilations, there was some balance showing at the payments.I would like to ask how to i clear those balance and close those payments. Thank you.

Client intend to move the financial year end from 31st March to 31st December to align with holding company.May I know how and where to change the financial year and the implications and changes expected in Acumatica system.Thank you.  

Hi!  Does anyone know how Acumatica updates the 1099 forms and information each year?  I can’t find any documentation on this process.  

Does anyone know of a way to format a date in report designer as follows:10th October 2022I can get the date, month and year correct, but not the ‘th’.Is this possible? 

Does anyone have tutorial videos on how to use Currency Management Module in Acumatica 2022 R1? 

Hi,Although we have branch security implemented, we are regularly getting employees picking projects from other branches on their expense receipts on Acumatica 2021 R2.Is there another way in our current version or is there a future version that supports this?Thank you,Dave Z 

Many of our customers (and my company, too) have begun using separate AP inquiry and invoice submission email addresses (e.g., accounting@ for inquiries and ap.invoices@ for invoices, etc.). As a result, when we send invoices or statements to a customer automatically, one of the other often is sent to the wrong address, unless we blast both addresses for everything, which is annoying if you’re on the receiving side. Is there any way to set up Acumatica to send customer invoices to a dedicated address and then use the general Billing contact email for statements (or vice-versa)?

Is there a known issue for all bank deposits not appearing.  I have 200+ ach transactions valued at $200,000 for deposit but only 172 for $160,000 are showing up.  What would be the reason for all transactions not showing up on the deposit?

Hi all, Does any one know how to reverse the Fixed assets has been depreciated?I try the “Reverse” action from the (...) Actions menu in the Fixed Asses profile screen. It revert all purchase, reconcile, depreciation accordingly, but all of my reversals posted to the same transaction date although transaction period is difference. When I export the report with the condition include tran.period & tran.date, it’s doesn’t show the reversal because it does not meet both conditions.I see the period of the reversal is correct & what I expect is the trans.date of the reversal should be same with the original date. Thanks

In trying to Export an ACH payment using FEDWIRE Payment Method, I am receiving the following error:  - Acumatica Cloud ERP 2021 R2 Build 21.214.0034   TRACE: Error:    Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index     SendRaised At: 10/13/2022 12:46:07 AM    Screen: AP.30.50.00         Details:10/13/2022 12:46:07 AM Error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)   at PX.DataSync.ACHSYProvider.Export(String objectName, PXSYTable table, Boolean breakOnErr

Hello - I am trying to add this Financial Period Parameter to my Dashboard, but the Widgets do not appear to be updating based on the month selected. Is there something more I need to do to my GI or filter settings on the Widget? Below is how I added my Fin Period:  

What is the maximum number of Fixed Assets that can be entered in Acumatica?

We have a P&L report in Acumatica where we have a column that calculates the percent of budget used. This column works for all lines except totals that add/subtract more than one line. The only reason I could suspect this is happening is because the system runs the line calculation after the column? I’m not entirely sure. I have tried creating an additional line that points at the total line but unfortunately it still does not calculate. Any thoughts?