Financials

Is it possible to reverse a voided check in AR

We discovered this process screen from the developer at our VAR; it wasn’t brought up during training.  I don’t have to use it too often, but if I wind up with an invoice that is out of balance it does the trick.  We currently run some other recalculate screens (like recalculate inventory) weekly--should Recalculate Customer Balances be set to run regularly as well?

I am trying to build a line graph widget to show opportunities by month year over year:Lines by year (2022, 2023) x-axis of each month - Jan, Feb, Mar, etc.  y-axis quantity of opportunities I can’t get it to show generic months and have all years on the 12 months vs actual month 1-2022, 2-2022, etc.Please let me know if you have a solution.Thanks!  

When running the 12-Month P&L Rolling ARM report in Acumatica based on the Budget Ledger, the report still displays values from the Actual Ledger. The Column Set or Row Set in the report is not specific to any ledger.Has anyone experienced this issue before? Could it be related to the report configuration or a missing setting in the ARM definition? Any insights or guidance on resolving this would be greatly appreciated!

I want to lock, not allowing further updates, to my forecast. 

The out of the box system does not let you specify any other type of account for a Vendor on an ACH (NACHA) export from AP. Follow these steps to fix:Go to Banking → Preferences → Payment Methods Select the Payment Method ID of the profile that you want to update, mine is ACH Click the “SETTINGS FOR USE IN AP” tab Click the + to add a new line ID Description Entry Mask Validation Exp 5 Account Type (Chk=22, Sav=32) 00 ^\d{2,2}$   Save  Go to Integration → Profiles → Export Scenarios Select “Export AP Payment to ACH” or which ever one you use Click the + to add (3) new lines Field Values Source Object Field/Action Name Target Field/Value vendorPaymentSettings @VendorPaymentMethodDetail.detailID ='5' vendorPaymentSettings DetailValue CCD_TransactionCode vendorPaymentSettings =IIF([CCD_TransactionCode]=null,'22',[CCD_TransactionCode]) CCD_Transact

Hello all,I would like to know the steps to following after we setup the fiscal year, import the balances in the Journal transactions.Thanks in advance.

I had complete Invoice transaction AR then I need to release Tax, but I don't know why it didn't have transaction to process. Thank so much for your sharing and helping 

Is there a way to configure a Tax Report Line that includes a Taxable Amount AND the Tax Amount? Example:Can I add a line 7 that sums lines 5 + 6 ? 

Hello!We are calculating Depreciation for number of days from the Placed-in Service Date. I want to know how the depreciation is calculated as seems it does not calculate depreciation based on 365-day calendar. Depreciation per Day = Acquistion value / (365 * number of years)First, I thought of above but seems is takes days around 371. Can anyone please help me with this?Thank You! 

Hello Everyone,We have a scenario where our client has multiple Companies within a tenant and processes invoices for Vendors across these Companies. When making a payment in the "Checks and Payments" screen, the "Reference Nbr." finder under the "DOCUMENT TO APPLY" tab currently displays all open bills for the selected Vendor across all Companies.The client would like the system to show only the open bills related to the Company/Branch they are currently working in (as selected in the top menu).Although the filter option is available on the "Reference Nbr." finder , managing it becomes impractical since the client operates over 20 companies, requiring them to set up and maintain more than 20 filters. Ideally, the "Reference Nbr." finder should automatically display only the open documents for the currently selected Company/Branch.is there any way to restrict the "Reference Nbr." finder to show only open bills for the active Company/Branch?Any suggestions on system configurations or alt

We are using Version 23.211.0017 22R2.  This upgrade changed the way retention was released.  When we upgraded, we had some open invoices that did not have retention released.  We released retention in this new version.  Once that retention was eventually paid for those existing invoices, the original invoice (not the retention invoice) never closed.  The whole project has a Zero AR Balance but it is still showing Open Invoices.  Any ideas?  It won’t let me write it off because there are no open line items and that is required for the write-off.  

I am testing the import of historical fixed asset data. Client uses SL with Mid Month convention. We do not want historical depreciation adjusted in the first month depreciation is run in Acumatica so all historical assets are imported using the RV method. The problem I am running into is that there are assets depreciating to a negative value and some assets that will not fully depreciate. I have used RV plenty of times however this is the first time I am running into this. My understanding is the RV method with historical assets should ignore what the system thinks should be the correct A/D and depreciate the remaining value of the remaining life. I thought that RV may only work with full period Averaging Conventions so ran another test asset using the same values however the remaining months were not calculated equally.  Any ideas if my theory is correct or why this may be occurring? 24R2 Build 24.204.0004

Does the latest version of Acumatica support having separate Charts of Accounts (COA) for different branches or companies within the same tenant? If not, are there plans to introduce this feature in future releases? Additionally, is it currently possible to limit GL Account access to specific branches or companies, and what configurations or best practices would you recommend for this scenario?

Will Bank Feeds function when the financial institution requires tokens for log in?

Dear Community,I am facing an issue while calculating the sum for a specific column in my report. The column values are displayed and calculated correctly for individual rows, but when I attempt to compute the sum at the column level, it does not work as expected.To clarify, the roll-up calculations are functioning perfectly, but the column-wise sum is not reflecting the correct value. I have attached screenshots below to provide a clearer understanding of the issue.Could you please guide me on how to configure the report to resolve this? Any suggestions or insights would be greatly appreciated!Thank you for your help!  

I’ve been working with some customers and realized that they may benefit from a dashboard where all things that may require attention are shown in one place for Acumatica Payments. I’ve prepared the following dashboard that I find quite useful. The customization package with the dashboard is attached. Feel free to download it and use it. Also let me know if there is something else you’d like to see on this dashboard.

Is there a way to allow a user to Reopen a Financial Period without giving them access to the Financial Supervisor Role? We want our AP and AR users to have access to reopen financial periods, but do not want them posting to closed periods, which is happening with the Financial Supervisor Role. Thanks all!

Good day CommunityI have a real mystery. I have deleted budget in the GL but when I run an ARM report, the budget is still there.It has also been deleted in the database by the administrator. Is there another table holding the budget information?GL Budget Edit:ARM Report:This make no sense to me. Can anybody assist please?Many thanks

Hello,I am looking for a deprecation report to show all my assets, regardless of depreciation. My auditors like the standard report in Acumatica within FAS (“Depreciation” ) but it is only returning assets that have depreciation within the period. Therefore it does not show all my assets regardless of depreciation value. I looked in the schema on report builder and cannot figure out why it is limiting records. Anyone have any insight on it?   

HI All,When entering a Bill, it is pulling the expense account from the vendor even when I put in an inventory item. I have checked the posting settings and preferences and feel like I am just missing something. Does anyone have any ideas? The client wants it to pull the expense account on for the item on the bill. My local Acumatica pulls in the item’s expense account though. Not sure what I’m missing. The bill with no inventory itemThe vendor GL accountsWhen I add the inventory itemThe inventory item expense account 

We received money from customer in advance and unused money needs to pay back to customer at the year end, how to record prepayment and then how to apply prepayment to invoices?

Hello All,I have a client that has two companies in one tenant with a fiscal calendar and the other on a calendar year. I can’t figure out how to use the other both calendars in fixed assets. Can it be done? Thanks

Hello there we have a customer who intended to pay for invoices A+B+C+D+E+F...a total of ‘say’ USD50,000. However they made a mistake and paid for eg 45000.00. I want to see the invoices above as paid and a separate entry for the 5K not paid ...not allocated just sitting on the statement until they put it right. I have tried a few options but am not able to get this situation echoed on Acumatica. Obviously I want the bank entry correct so that I can do a reconciliation but I don’t want to part pay a particular invoice as this was not the actual scenario. I thought maybe I should raise a credit note !!!! and then re-invoice to take care of this but it seems very clumsy to do this. Best Regards Malinda

Hi All,I have a customer that want to have their statements send to a specific email address. When I send the customer statement it send it to the Account Email? What am I doing wrong?  ThxDries