Financials

I am implementing a client that has 12 entities covering two base currencies. I have setup company groups for use in the restrict visibility field to field in vendor profiles but the problem I am having is there are vendors that need to be available to transact in all entities regardless of the base currency of the entity. This seems like an odd requirement considering we have multi-currency available to resolve vendor currency differences against entity bast currency. When a vendor is used in all entities, ss the only solution available one that requires setting up duplicate vendors for each group?

Issue is that a handful of AP Bill transactions are appearing incorrectly in the September BAS when they should be appearing in the October BAS. Example: Transaction itself was created in the system in September 2023, dated 04/08/23 but post dated 04-2024.   GL Register Detail for this transaction confirms the From-To period as 04-2024. However, when running the report “Tax Details by GL Account by Period” this transaction is appearing and the Tax Period shows as 03-2024.My question is why is this transaction appearing on this report as post period 03-2024? Where is it picking up the post period date from? I have checked the Financials Tab and batch details but all showing as 04-2024 for October.

Good day,The accountant add a second invoice on a project in error.  They realized the issue. Removed the line items and placed the invoice on hold.  Now it is stuck.  The trace shows that we are getting table errors on the database.  Any help would be appreciated.Do I need Acumatica?It is causing issue with management because it shows the Project 2x on dashboards and report.Thank youEvan System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.   at System.ThrowHelper.ThrowKeyNotFoundException()   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Ta

I have a GI (Vendor summary) in which the top 10 records are to be shown, with total aggregate (SUM) set in the columns for amounts (e.g.blance due).We want to show these totals (of the selected records) on a dashbard, however the totals shown on the dashboard are from all records of the GI and not the selected 10.It seems the total aggregate function in a GI where the ‘Select top’ is selected, does not take into account the ‘Select top’ selection.How is one able to show these totals correctly on a dsahboard?

I have a check that is closed, however it is not showing up in the reconciliation detail.  Has this ever happened to someone else?  The check has not been voided, and it has cleared the bank.  

Hi, hoping someone can help me here.Our accounts payable module is posting to inactive general ledger accounts, which I then have to go and fix with a reclassification journal.Is there a setting somewhere that I can change to ensure the posting isn’t allowed in the first place?Thank you.

 According to the documentation, If the On Receipt Release option is selected, the system generates an inventory receipt and a transaction that updates the expense account when the purchase receipt is released. The system updates expense accounts for both stock and non-stock items in this case, and the system does not update any inventory accounts.Even though my settings are as stated above, no expense is booking with the PO Receipt release. It only books once the AP Bill has been released.Before AP Bill: After AP Bill: 

Hello,Has anyone ever added a beginning balance on a new bank reconciliation? We have a petty cash fund which shows as a balance on the balance sheet, but I wanted to add it the reconciliation process. I added the a new bank rec for the account but does not pull in the balance as on the balance sheet. I thought to add a JE to credit the cash account with the GL $ amount, then debited the same amount to the cash account- which do show up in the rec. If I clear the credit line and leave the debit line and the ending balance is populated with the correct amount. The issue is that the other line will never clear - which I prerfer not to see each month. Any thoughts?

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?