Financials

When attempting the Reverse Disposal action in the Fixed Asset module I encountered an error.  Acumatica will not post to a Control Account when creating the reversal disposal transaction.  Is there something I am missing in the setup? 2022 R122.120.0019 Error EncounteredAllow Manual Entry is OFF for the Account we would like to keep it this wayThe original Disposal We are currently using a work around where we enable manual posting, process the reversal of the disposal and then disable manual posting.  

A debit memo was entered in the system when it should not have been I was able to remove the invoices and attach them to the correct payment.  But now I have an Open Debit memo.  Is the best way to fix this is by doing a Credit Adj to clear this payment out?  

Hi Everyone,Whenever we select the Export action in the Payment Batches, receiving an error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".Build VersionThanks

Hello! :) Does Acumatica have anything to streamline entry of deposits from scanned checks?  I'm looking for something similar to the inbound documents feature on the AP side.  Thank you!

I hope I stated my issue correctly above.  We are trying to figure out how to properly enter taxes on an invoice where we have partially invoiced but sales tax would not be applied until shipment has been made and the final invoice issued.  This is fairly common for us as we don’t always know the location of shipment prior to those final invoices (we are an Oil & Gas equipment manufacturer and our equipment will be sent to multiple locations in an oil field(s) ).  We are trying to figure out how to get the full amount of tax properly reflected on that final invoice. 

Dear all,Please help me in this case:The depreciation method used for the asset is SL, with depreciation spread over 2 months. However, after 2 months of depreciation (the last depreciated period being 08-2024), a net value still remains.Now, we want to clear the net value in the current month, how can we do?Thank you so much! 

Hello! A client just upgraded to 21 R1 from 20 R1, and it seems there is a slight process change that I’m looking for insight on how best to handle in the new version.Previously the client would Prepare Invoice and then on the Process Invoices and Memos screen, they would click Create and Capture, then Email Invoice, then Release. In this new version,  the invoice does not show on the create and capture process list because it’s pending email first and not in balanced status. They like to create and capture prior to emailing because their form marks the invoice as paid. Also, they do not want to release prior to emailing the invoice and have the setting specified to not allow release until email.So, they are now stuck with how best to work through the steps in this new version. Anyone have any thoughts on how to handle?

Is it possible to use a contains filter in an ARMS report Profit and Loss like you can use with a GI? My client heavily uses sub-accounts and they want to be able to use "contains" filters with sub-accounts. For example, they want to be able to filter for the second segment in the subacount. So if they filter for '10' they would see the selected rows as you can see: 

Our users (but not administrators) are experiencing the following.They run the profit and loss statement (we have various formats but this problem occurs in all, also standard Acumatica P&L report) They try to drill down on a figure They all get the same error - Error:  You have insufficient rights to access the object (CS600000).The screen that the error is referencing is not related to financials at all, it is a configuration screen.  Any ideas what access is required for this drill down to work?Edited to add - my apologies, the screen that it is trying to reference is this one: However this is not in the Finance Workspace of Access Rights by Screen.  How do I find it?

When creating a Return for Credit and adding a line item from an Invoice.  If the original UOM is a Case and it will convert to Each and then it will multiply the discount by the Quantity.  Which is incorrect and your Credit Memo will be much higher.Example1 case of 6 units - total discount is 2.55 and total case is 48.45Credit Memo for the 1 case of 6 units, it converts to Each (base uom) 6 units but it does not divide the discount instead it multiply the discount of 2.55 * 6 = 15.30InvoiceCredit Memo Please fix this bug ASAP, impacting the credit memo process.The original way is to just keep the some UOM when creating Credit Memo.

Hi, can we set up a Consolidation Parent Company with a financial Calendar that differs from the one used by the Consolidation Units?We have a client whose fiscal year begins from January, but for reporting purposes, they would like to setup a Parent consolidation Company ( preferably within the Same tenant) to use a financial calendar begins from the month October(they have “Multiple Calendar Support” feature enabled).So when we run the consolidation Import, the period 01-2025 (January 2025) data from the Consolidation units should get imported into the period 04-2025 (January 2025) in the Parent Consolidation Company.Thanks

Using the Trial Balance by Summary and Detail Report Filtering logic I think I figured out why it would not return values but wanted to confirm with community.Acumatica 24R1 Build 24.104.0008Single Tenant, Multiple Company, same ledger for Actual. 1 company has multiple branches and the other company is a no branch setup.I cleared the Company/Branch field on Report Parameter Tab ( “Blank”).  On “Additional Sort/Filter” Tab I selected the “Property” branch.branch ID field with “Condition” EQUALS, and selected branch from List of branchs in the “Value” field. I noticed by selected the “Value” it inserts the word branch which is invalid for branch id name. I had to just manually type in “Value” field the branch id.  Also tried to use the 2nd value field to include an additional Branch ID. The 2nd value field does not appear to work and display 2nd branch TB info even if manually typed. If I only used the “Value” field, manually input the branch ID, and used separate Rows for each branch i

This is not currently turned in my configuration, if I do make it active, am I liable to get charged more?

Dear ALL,We have an AP transaction that was released but unposted and we do not want to post this AP transaction.How to close Financial Period with unposted batch ? Best Regards,NNT

I have a negative quantity available and am trying to figure out what is causing it.  I went through the history of the inventory transactions and everything seems to be ok.  I have an FS Booked quantity of 1 in the inventory allocation and wondering if this could be the reason? 

Hi,I have a requirement to default the tax category based on the entry type selected. Currently following options are available. My tax setup includes multiple tax categories under one tax zone. System picks the default tax category for the tax zone attached to the entry type.Use can manually change it. we can use a non-stock item to default the tax category. Use has to select the tax category and also the  entry type in the cash transaction. Is there any way that I can set the tax category to pick automatically connected to an entry type?Thank you,Dulanjana

Is there a way to add a column for cost of FS Allocated items to the Inventory Allocation Details page?  

To properly account for payroll related expense, we would like to:Account for non-project (non-billable) labor in 3 distinct buckets Indirect Labor (Overhead): Supervision, Maintenance, Engineering  Direct labor (direct employees nonbillable hours) (not Labor COGs) SG&A labor Differentiate straight time, premium time, vacation time, and holiday timeIt would look something like this.  Reg Time OT Holiday Vacation Bonus Benefits Work Comp Project/ Billable Direct 61010 61020 62800 62710 61030 62110 62400 52000 Indirect 61040 61050 62800 62710 61060 62110 62410 52000 SGA 71010 71040 72810 72710 71030 72110 72410 52000

Hi, I have a requirement to record expenses for a customer contract. I see in AR invoices, there is a field to enter the contract for revenue, but in AP Bills I cant find the contract ID. Is there anyway that we can enable entering contract ID in AP bills or any other transactions similar to entering the project ID?Thank you,Dulanjana

Is it possible to add a 13th finical period after you are set up and using 12?Is this documented somewhere ?

How do you get a Vendor bill to connect to Avalara so that use tax will calculated?

Is it possible to Block creating and editing transactions of cash accounts (bank accounts) once the reconciliation is done?Currently users can post transactions into reconciled months.Your insights are highly appreciated. Thanks in advance…   

Is anyone using any of these FP&A packages, and do you have integrations with Acumatica?   Jirav, Mosaic, Amacum, Vareto

Hi,Is there a way for me to set us fixed asset approval flow in the system? Currently there is no approval in that I can assign approval map in Fixed Asset Preferences. If I would like to set up approval map in General Ledger for Fixed Asset Depreciation, is there a way to set up in the system? Or it can only be done through customization? Thank you. Regards,Chern 

For some time now the bills and adjustments screen is taking a long time to load. It takes around 8 - 10 seconds. We have 31k records on there. What can we do to improve this load time?