Community
Discussion Forums
Financials

Financials

General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management

2,042 Topics
6,837 Replies

When you subscribe we will email you when there is a new topic in this category

2042 Topics

Recently active

Most replies Most views Newest first

prabhu83Freshman I

asked in Financials

How to FinPeriodID Parameter pass to YYYYMM format(202306) in Report Designer?

1 year ago

swartzfegerFreshman II

asked in Financials

user roles: restricting the release of invoices

All, our distribution team is releasing invoices which is causing issues on our AR side. Is there a user role/s and/or access screen right I can restrict so only AR can release? Thank you!

1 year ago

fpantelidakis65Jr Varsity II

asked in Financials

Import for AR History in Migration Mode not showing up on Customer Transaction History Report

Hi,I imported AR History via Cash Sales in migration mode. Everything imported correctly. No issues there. However, when I try to run the Customer Transaction History report nothing is showing up. Do you know why? Do I have to customize the report to reflect the data. I ran Customer History and the migrated information showed up there and also on the AR Register. The client is on 2023 R1 Canadian version. Let me know.Thank you,Frances

1 year ago

jvarughese23Freshman II

asked in Financials

Failing to Select Cash Account in Process Payments / Print Checks

1 year ago

chidao

asked in Financials

How can voided 1 line in a check has more than 2 lines?

Hi All,I got a check apply for 2 bills. Is it possible to voided only 1 bill from check?

1 year ago

enriqueyFreshman I

asked in Financials

Recalculate Account Balances

What does Recalculate Account Balances? I’m trying to create a bank reconciliation but I’m worried it will destroy the information.

1 year ago

prabhu83Freshman I

asked in Financials

Processing Screen use to Particular Vendor(BAccount) move as Customer

how to break this issue?

1 year ago

kstockmanFreshman I

asked in Financials

Non Stock Item Sales Account

Hello,I’m setting up Non Stock Items for services and was wondering how I make the system post to the sales accounts tied to the item vs the sales account for the customer when invoicing? Thank you in advance!

1 year ago

lewisadFreshman I

asked in Financials

Partially billed service order identification

Is there a way to identify partially billed service orders and then list them?

1 year ago

rfrantzFreshman I

asked in Financials

Reconcile Refund Checks in system

Good morning, I am curious, best practice. If I were to cut a handful of refund checks to customers and a few days later those are all cashed. What is the best process or most straight forward process Acumatica offers to reconcile those against the bank deposit?

1 year ago

bernadeth58Jr Varsity III

asked in Financials

How to Bulk delete all line items in Sales Prices

Hi. Does anyone knows how to bulk delete all items existing in Sales Prices? Thank you.

1 year ago

dmzasdfVarsity I

asked in Financials

Branch Split Open AR Transfer

Hi!Branch A open AR is moving to a new Branch B; Branch A will become inactive and Branch B will contain part of another Branch C that will stay active.We use an Open AR import in migration mode to move the AR, but unsure whether Branch A open AR will be closed out when migrated to Branch B or will we need to do something on our end for that? Team thinks we might have to do a customer payment for the open AR and then clear the balance from the Branch A bank account to Branch B AR, but would like to know if that’s the best path?Either way, we will test in sandbox before executing in production.We are running Acumatica 2021 R2, Build 21.212.0039 customized with ProcoreBuiltCustomizationPackage2021R2V4, VelixoConnectedAppConfig, VelixoLiteDACsThank you,Dave Z

1 year ago

dconcannon20Freshman I

asked in Financials

"Open Item" Customer Statement with Adjustments

BackgroundThe Customer Statement only prints adjustments if the customer’s statement type is Balance Brought Forward. The ARStatementAdjust table is not populated if the customer’s statement type is Open Item.Business CaseCustomers with statement type of Open Item have requested their (monthly) statements to include lines that show adjusting document(s) which explain the difference between Orig. Amount and Balance statement-columns. Note: We are aware of AR Balance by Customer that can show these details.QuestionsIs there an easy customization to make to populate the ARStatementAdjust table for statement type Open Item? Has anyone modified the Customer Statement report to use other AR adjust tables? If so, how did you handle ARStatementAdjust fields that drive critical calculations in the Customer Statement report, that do not exist in the other adjust tables? Are there any other options?Thanks,Dan

1 year ago

rfrantzFreshman I

asked in Financials

Customer tax exemption expiration date inquiry

Good afternoon, New to Acumatica...trying to set things up. Is there an expiration date field available in the Acumatica screens for tax exemptions on a customer level? Or do you usually just use your tax service for such case? Looking to set up our customers maintenance screens to have an expiration date on their exemption forms so we can obtain an updated one when the time comes...but not sure where that would be located.

1 year ago

kmckenzieJr Varsity III

asked in Financials

Prepayment and Approval Maps

I have a multi-tier approval map set up by the amount of the Bill. Everything that I am reading says that Prepayments should generate an approval but mine doesn’t until it is applied to the Bill. Can we not use approval maps for Prepayments?

1 year ago

yashodhalakshini85Freshman I

asked in Financials

Consolidation Accounts

Hi Team, Suppose that we have two companies in one tenant. And also I have configured only one set of chart of accounts yet. The following two concerns are need to be clarified from you all. Can we maintain two set of chart of accounts for those two companies ? If can, how to do the consolidation of accounts ? Thank You & Best Regards,Yashodha

1 year ago

helpdesk37Freshman I

asked in Financials

An invoice error

I have an invoice error, the order and pick list do not have the last item appearing, advise

1 year ago

chanampafeFreshman I

asked in Financials

No reduction after Sales Order and Purchase receipt and Invoice has been issued to customer

My inventory Account does not show a reduction after i sell (invoice created) a stock item from inventory. Posting classes are correct. Accounts seems correct

1 year ago

danielleallisonFreshman I

asked in Financials

Cash Account Branch Change

Is there a way that we can change a cash account to a new branch? Example:We are are currently using cash account **1234 for branch A and would like to use it for branch B

1 year ago

McAuleyFreshman I

asked in Financials

foreign currency budget consolidation

Hi We are trying to consolidate our groups budgets. One company is in a foreign currency. Goal is to report Group actual results against Group budget results using local currency for both.Our support partner has told us that Acumatica can’t translate foreign currency budgets so they can be consolidated into Group. Is this true? Seems odd that it can’t. thanks Peter

1 year ago

Troy VarsSemi-Pro I

asked in Financials

AP Batch Payment Daily Sequence Number not updating so File is overridden

Anyone else having issues with the DateSeqNbr field not updating?I think this is because we are doing this from multiple companies/branches but the File name doesnt contain the branch so when we do multiple batches in the same day company CDO over writes the export IHO and then we do company BVO it over writes the file for CDO and IHO and so forth. I temporarily recoded the export to use the date + time so that this isnt over writing and because it didnt like the ref to Company I tried to use...

1 year ago

khowe86Freshman I

asked in Financials

General Ledger Report for all accounts for a particular year

Hello! Do any of you know how to run a general ledger for all accounts for a range of dates (most commonly quarter or year) with a beginning and an ending balance showing all account detail for the period selected? Thanks,Kay HoweJackson, OH 740-418-5250

1 year ago

zillayFreshman I

asked in Financials

Hide Column for Balance sheet

Hi,i have created a balance sheet by month and added 12 columns for 12 periods and selected the first two digits of the period in the Start Period and End Period in the Data source.i want to hide columns based on the period selected when user runs the report. e.gif user selects 06-2021 then only 6 columns become visible. i have looked at Visible Formula option but dont know how to use it to hide any column where financial period selected in the data source is greater than the selected period.

1 year ago

enriqueyFreshman I

asked in Financials

Import 1099 vendor information

Hi,How do I import vendor payment balances? We imported the vendor information (Vendor#, name, address) except the payment balances. Our system is set up with 10 companies (10 different EINs). Some vendor have payment balances in all 10 companies. Thanks

1 year ago

aborisova37Semi-Pro I

asked in Financials

Issue with Processing Bank Transaction (2022R2)

We are currently experiencing an issue with matching and processing bank transactions. It began occurring right after the recent upgrade to 2022R2 (22.206.0035).Here's the error message we are receiving:We upload OFX files from our bank. Please advise.

1 year ago

Page 44 / 82

Badge winners

aiwanhas earned the badge Manufacturing expert
wfilipiak67has earned the badge Acumatica expert
MSwanson86has earned the badge Easy talker
jon95has earned the badge Easy talker
Graeme Laughton-Mutuhas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.