Financials

Released Invoie lines details editing possible??

While reconciling deduction transaction, the system doubled the amount and now my fixed asset clearing account has a balance and no way to relieve it.  Below if a screen shot of the Reconciliation History by Assets report with the transaction marked.  Can anyone help me fix this issue? 

There is a transaction in GL in an unposted status.Finance - > Post Transactions , I posted the entry and it posted just fine. I do not want this transaction to update the GL , so when I tried to reverse , I received the error ,  “Error: An error occurred during processing of the field Inventory ID value ________IN Error : Th Inventory Item is Inactive” My question is Why does the system let me post it once but then not allow me to reverse it ?

Hello,We are trying to understand how best to proceed if we closed down one branch in our larger company of 33 branches in 2023, but still would like to see historical data without it impacting our 2024 reporting. The branch only has equity and retained earnings on the books.Regards, Brandon McIlhargey

Good afternoon!Do any of you know why the Export to Excel feature is not on the Process Bank Transactions Screen (ScreenId=CA306000)?   Thanks, Kay Howe

My client doesn’t have the asset purchase date/receipt in date without trolling through invoices. Is there a way around this by simply entering a dummy date and what implications will this have? thanks.

They seems to have the same result from what I have read.

Our acumatica system has open periods all the way back to 2015 , I have been successfully able to close periods from 2015-2019.However , When I get to 2020 I can close the submodules but there are two transactions in GL in an unposted status which are preventing me from closing the period.My inclination is to delete the transaction but the “trash can” symbol is grayed out . Is this related to access rights ?. But the bigger question is (1) If I delete transactions is that going to change the sub-module balance thus causing a need to make a G/L entry to being it back in sync with one another ? (2) If I delete an entry in GL which is coming from AR, for example , does the AR module need to b re-opened before the system will allow me to delete it ? May be that’s why the trash can is grayed out ? The weird thing is I was able to close the AR module even through the G/L has an unposted entry from that sub-module. 

New user here (and new to the company) -- the CPA entered opening Trial Balance balances into Acumatica for the cash accounts as of 1/31/2023.  However, we did not “go live” with Acumatica until 10/1/2023 - still used QB.  How do I adjust those opening TB balances now?  No bank reconciliations have been completed to date.

Our acumatica system has open periods all the way back to 2015 , is it okay to close multiple periods at a time ? Will there be any system resource issue ?

I created an ARM income statement with a unit set. My understanding is that SUMMARY (see below) should sum up the nodes underneath it. When I run the report, there is data in each of the nodes. But when I click SUMMARY it’s empty. I did it this way for another income statement (different site) and it works. Haven’t been able to find any difference in settings, or anything that would cause this. Anyone have an idea?Below is a screenshot of the unit set:  

Hello, I just had a quick question to better understand Companies vs Tenants in Acumatica. I know that Tenants are fully separate legal entities. However, when researching I see that multiple companies under one tenant share at least base currency and chart of accounts. When setting up a multi company user, I also see they share all business accounts, inventory, posting classes, etc… From the looks of it they also share numbering sequences between them. Am I correct in understanding this? Is there a way to have each company use their own numbering sequences for invoices\bills\sales orders\purchase orders? They seem to share the same preferences between the companies so I cannot set it there. Is there a built in way to keep the transaction numbers separate with their own numbering sequences? Sorry if this has been answered before, I was unable to locate anything on this. 

Our company has multiple branches, so it would be nice to be able to upload all branches at the same time (P&L and Balance Sheet).  Has anybody found a simple way to do this?  We also have Velixo, but haven’t tried the writeback capability out of concern of not fully understanding it yet.  Thank you in advance!

In our industry, it is common to provide monthly rebates to customers that meet certain order quantities. We could base this rebate off of monthly order quantities or monthly sales totals. For example: Tier A (0-100K), Tier B (101-250K), Tier C (251-500K), Tier D (501K+). Similar to how Acumatica processes Sales Commissions, we’d like to track sales of stock items so that we can send rebate checks to our customers that qualify for these rebates. Tier A would receive a 2% rebate, Tier B would receive a 4% rebate and so on. I can calculate this in excel, but it would be nice to have the capability built into Acumatica.

Hi,I am completing the financial training for Acumatica and I am thoroughly confused by the refund process. According to the training manual, this is the general flow: So, according to this, when you release a refund it increases cash and increases AR?  I do not understand this at all.  Refunds decrease cash.  I have no idea why an AR account is involved.  You now have:an entry increasing cash that will not be reflected in the bank statements and will be impossible to reconcile An entry increasing AR when no invoice was issued.  This would impact your cash audit trail, distort AR and cash balances, mess up your reconciliations, and possibly circumvent cash controls.   They’d all have to be needlessly restated or reclassified in the ledger to correct them.In addition,  when you apply it to a prepayment (the second red box), it reduces customer deposits, assuming it’s properly classified as a liability, and decreases cash?  Why?  Normal sales refunds have nothing to do with customer depo

I have 3 Financial reports, consolidated, company and branch. They use the same Row Sets & Column Sets but the results are different, as is expected.They do not use Unit Sets.Where do you set the parameters to run report for a Company or a Branch or Consolidated across companies.Any help would be appreciated - I just can’t find the setting.Many thanks in advance.

Hello Community,I am hoping to get some assistance with setting up budgets in Acumatica. I'm trying to define the budget amount for an account using a subaccount mask, but I can't seem to find a way to do this directly in the Budget form. The form only allows entering a specific subaccount, not a mask.We have a large number of accounts and subaccounts with six level segment ID. Even if we use only two segment IDs, it will exceed 20,000 lines in preparation. Manually creating budget entries for each individual subaccount would be incredibly time-consuming and impractical.Does anyone know of a way to define the budget amount using a subaccount mask in Acumatica?I've searched the documentation and haven't found a clear solution. Any insights or suggestions would be greatly appreciated!Thanks in advance for your help.

I need to create financial reports for multiple branches, however, one branch has a different financial calendar to the others. The finacial year of this branch starts in November (i.e. for the financial year of 2024, the first period for this branch is 11-2023 on the master financial calendar.There is the ‘Use Master Financial Calender’ check box in the report designer. How does this work?Would it be that if it is selected and requested, then the periods in the report will be taken from the Master Calendar so for this particular branch, the period would be 03-2024?And if the master Financial Calendar is not selected, then does the report take the Company Financial Period? In this case for the first period, for this branch the period would be 01-2024 (November)?

I have a prepayment that has already been paid to our vendor and I am trying to find out how to close the prepayment on “checks and payment” without applying the Purchase Order since the Purchase Order has not been completed yet. Does anyone have an idea how I can close the Prepayment and then once the Purchase Order is completed can I just apply the prepayment under “Purchase Orders - Prepayments”? Thank you! 

Currently User A do not have the AP Clerk role assigned . Suppose that someone gave AP Clerk access to this User A . How to find out who made the changes and when was it made ? How to enable this type of tracking ?  

How do I clear STATEMENTS TO EMAIL from the AR Clerk Dashboard? We have already emailed these statements and still they do not clear from this card.   

When running reports, for example, the Customer Summary Report I cannot get it to sort by name. It always sorts by the customer ID. I change the sort in the Additional Sort and Filters and  I’ve tried to change the sort in the report designer but it still won’t sort it the way I want. Any help will be appreciated. Thanks,

Is there a way to apply and Open Debit Adj to an Open Credit Adj?

I don’t know how I got a Debit Adj in “reserved” status.How can I get rid of it? Sue

Hi,@Laura02 This is an urgent Issue.We had a an issue with not all our some of Invoice not having the correct sales tax agency and now need to file and Amendment. In doing research we discovered that total sale on P&L Is a good bit less than Income we have recorded on Invoices for 2023. I exported all in AR Invoices and this total is good bit higher then what is showing on P&L. Is this normal?